Key Responsibilities:

• 1. Database Administration:
  • Administer and maintain PostgreSQL databases across development, staging, and production environments.
  • Implement database management policies, procedures, and standards.
  • Monitor database performance, optimize SQL queries, and resolve performance issues.
  2. Database Migration:
  • Plan and execute migrations of databases from legacy systems (e.g., Oracle, MySQL, SQL Server) to PostgreSQL.
  • Develop and implement data migration strategies, scripts, and procedures.
  • Conduct pre- and post-migration performance and compatibility testing.
  • Troubleshoot migration-related issues, ensuring data integrity and accuracy.
  3. Backup & Recovery:
  • Design and implement robust backup, recovery, and archiving strategies.
  • Perform regular database backups and conduct periodic disaster recovery tests.
  4. Security & Compliance:
  • Manage database security, including roles, permissions, and encryption.
  • Ensure compliance with organizational policies, regulatory requirements, and best practices.
  5. Performance Tuning & Optimization:
  • Proactively monitor and tune the database for optimal performance.
  • Analyze and troubleshoot slow-running queries and optimize database indexes.
  • Implement database monitoring and alerting to ensure performance SLAs.
  6. High Availability & Replication:
  • Configure and maintain high-availability solutions such as replication and clustering.
  • Set up and manage replication for both high availability and scaling purposes.
  7. Documentation & Training:
  • Document migration plans, database architectures, and configurations.
  • Provide training and support to development teams on PostgreSQL best practices.
  

Required Skills & Qualifications:

• • Bachelors degree in Computer Science, Information Technology, or a related field.
  • 5+ years of experience as a PostgreSQL DBA, with at least 2 years focused on database migration.
  • Proven experience migrating from Oracle, MySQL, SQL Server, or other RDBMS to PostgreSQL.
  • Strong knowledge of PostgreSQL architecture, replication, clustering, and tuning.
  • Expertise in SQL query optimization, indexing strategies, and performance tuning.
  • Experience with backup, restore, and recovery models.
  • Familiarity with tools for database migration (e.g., pg_dump, pg_restore, AWS DMS, Oracle GoldenGate).
  • Proficiency with Linux operating systems and shell scripting.
  • Knowledge of database security practices and data encryption.
  • Familiarity with cloud database management on AWS, GCP, or Azure is a plus.
  

Preferred Qualifications:

• • Certification in PostgreSQL or related database technologies.
  • Experience with DevOps practices and automation tools (e.g., Ansible, Terraform).
  • Knowledge of additional databases (e.g., MongoDB, Redis) is a plus.
  • Experience in agile project management environments.