Senior PostgreSQL DBA

Job Title: Senior PostgreSQL DBA

Job Summary:

We are seeking a highly skilled Senior PostgreSQL Database Administrator (DBA) with expertise in PostgreSQL administration, configuration, development, security, infrastructure, and management. The ideal candidate will be responsible for designing, implementing, and maintaining PostgreSQL databases, ensuring high performance, security, and availability. Experience in migrating databases from SQL Server to PostgreSQL is highly desirable.

Key Responsibilities:

• Manage, configure, and optimize PostgreSQL databases for high availability, scalability, and performance.
• Implement best practices for database security, access control, encryption, and compliance with industry standards.
• Monitor and optimize query performance, indexing, and storage strategies to ensure efficient database operations.
• Design and maintain robust backup and disaster recovery strategies for PostgreSQL databases.
• Set up and manage PostgreSQL replication, clustering, and high-availability solutions.
• Write and optimize stored procedures, functions, triggers, and SQL queries for efficient data processing.
• Lead migration projects from SQL Server to PostgreSQL, ensuring data integrity and minimal downtime.
• Utilize monitoring tools and automation scripts to proactively detect and resolve database issues.
• Work closely with developers, DevOps, and infrastructure teams to support application development and deployment.

Required Skills & Qualifications:

• 7+ years of experience as a DBA, with a strong focus on PostgreSQL database administration.
• Expertise in PostgreSQL setup, configuration, optimization, and troubleshooting.
• Deep knowledge of SQL and PL/pgSQL for writing and optimizing database queries and procedures.
• Experience with security best practices, role-based access control, SSL/TLS encryption, and data masking.
• Hands-on experience with database replication, failover, clustering, and high-availability architectures.
• Proficiency in database migration, specifically from SQL Server to PostgreSQL.
• Experience with PostgreSQL tools like pgAdmin, pgbouncer, and extensions (e.g., PostGIS, TimescaleDB).
• Familiarity with infrastructure management, including Linux administration, scripting (Bash/Python), and cloud environments (AWS, Azure, or GCP).
• Strong troubleshooting skills to diagnose and resolve database performance issues.

Preferred Qualifications:

• Experience with Kubernetes, Docker, and containerized PostgreSQL deployments.
• Familiarity with CI/CD pipelines for database deployments.
• Knowledge of NoSQL and hybrid database architectures.
• Experience with ETL tools and data warehousing solutions.