We are seeking an experienced PostgreSQL Database Administrator with strong expertise in database migration. The ideal candidate will have in-depth knowledge of PostgreSQL management, optimization, and performance tuning, along with proven experience in migrating large-scale databases from other platforms (e.g., Oracle, MySQL, SQL Server) to PostgreSQL. This role will involve planning, executing, and troubleshooting database migrations and ensuring high availability, security, and efficiency of PostgreSQL databases.
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:
• Bachelor’s 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.