Database Administrator - PostgreSQL

About the Role :

We are looking for an experienced Database Administrator (DBA) specializing in PostgreSQL to join our team. The ideal candidate will have deep expertise in database design, development, performance tuning, and administration. You will play a critical role in managing the database infrastructure, developing robust ETL processes, and ensuring high availability and data integrity across production environments.

Key Responsibilities :

• Develop and maintain complex stored procedures, functions, and views to support application enhancement requirements.
• Provide best practice recommendations and guidance on database design, indexing strategies, and query optimization to development teams.
• Design, develop, and optimize relational database schemas to meet evolving business needs.
• Implement and manage ETL strategies for seamless integration and migration of data from multiple sources into data warehouses.
• Develop automation scripts and tools to streamline data loading and database maintenance processes.
• Monitor and optimize database performance, including query tuning, indexing, and resource allocation.
• Implement and maintain PostgreSQL replication setups, including multiple hot standby nodes for high availability and disaster recovery.
• Manage Point-In-Time Recovery (PITR) using WAL (Write-Ahead Logging) archiving and implement backup strategies using tools like pg_dumpall and BART (Backup and Recovery Tool).
• Handle WAL shipping and replication processes to ensure zero data loss during failovers.
• Identify and resolve production data issues, ensuring data integrity and minimal downtime.
• Collaborate with cross-functional teams to support application deployments, upgrades, and data migrations.
• Maintain documentation of database architecture, replication setups, backup procedures, and troubleshooting guides.
• Stay current with PostgreSQL updates, patches, and best practices to continuously improve database reliability and performance.

Key Skills & Knowledge :

ref : hirist.tech)