Open Positions


AWS Cloud DBA / AWS Aurora PostgreSQL DBA

  job ID :   Tek1201

  job Title :   AWS Cloud DBA / AWS Aurora PostgreSQL DBA

  job Type :   Contract

  job Post Date :   2023-03-02

Job Description

Job Description:

  • 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).

Please share your resume to kiran@tekstad.com for for immediate consideration

up