What are the responsibilities and job description for the AWS PostgreSQL DBA with heavy experience in SQL SERVER DBA- 100 % Onsite role in MD position at Unisoft Technology Inc?
(100% Onsite- from day 1 )
AWS Cloud DBA / AWS Aurora PostgreSQL DBA
- Collaborate with application developers to design and optimize database structures for efficient data storage and retrieval.
- Design and implement backup, recovery, and disaster recovery plans to protect critical data.
- Implement AWS cloud solutions that effectively utilize PostgreSQL databases.
- Manage AWS resources related to PostgreSQL databases, such as EC2 instances, RDS instances, and S3 storage.
- Implement database scaling and high availability strategies in the AWS cloud environment.
- Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
- Plan and execute database migration projects, including schema migration, data migration, and application migration.
- Develop and implement migration strategies to minimize downtime and ensure data consistency.
- Plan & perform database upgrades, applying patches, and ensuring compatibility with new versions of PostgreSQL and AWS services.
- Conduct thorough testing and validation of migrated databases to ensure data integrity and optimal performance.
Qualifications and Skills:
- Bachelor''''s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- 12 years of experience in Database
- Proven experience as a Database Administrator .
- In-depth knowledge of database management systems, primarily AWS PostgreSQL , SQL and MongoDB.
- Familiarity with database design principles, data normalization, and indexing techniques.
- Understanding of data security and access control principles.
- Must have great experience in AWS RDS
- Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
- Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
- Experience with PostgreSQL monitoring and performance tuning tools.
- Proficiency in SQL and experience with writing complex queries and stored procedures.
- Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
- Familiarity with Linux/Unix operating systems and shell scripting.
Preferred Qualifications:
- PostgreSQL (e.g., PostgreSQL Certified Professional).
- AWS certifications (e.g. AWS Certified Database - Specialty)
- SQL Server DBA
----------------------------------------------------------------------------------------------------------------------------------
Unisoft is an Equal Employment Opportunity (EEO) Employer
All our Information Technology professional positions required a minimum Bachelor degree in computer Science or Information Technology or related field.