AGM Tech Solutions, on behalf of our highly reputable Client, is proudly hiring top talent to join their innovative team.

About the Role - We are seeking a highly skilled Senior PostgreSQL DBA to develop, implement, and maintain scalable, secure, and efficient database solutions. This role is a key member of the database team, supporting the effort in migration, development, optimizing performance, ensuring data security, and collaborating across teams to support business needs. The ideal candidate has extensive expertise in PostgreSQL, database design principles, and a strong understanding of cloud-based and on-premises environments.

Responsibilities -

• Database Development and Support:
• Develop and Support high-performance PostgreSQL databases.
• Develop schema designs that balance performance, scalability, and reliability.
• Ensure database solutions align with business goals and technical requirements.
• Performance Tuning and Optimization:
• Analyze and optimize complex SQL queries, indexes, and database performance.
• Identify and resolve performance bottlenecks in existing systems.
• Implement partitioning, sharding, and other techniques to handle large-scale data sets.
• Database Security and Compliance:
• Ensure compliance with security standards and data protection regulations.
• Implement database access controls, encryption, and backup strategies.
• Perform regular security audits and vulnerability assessments.
• Cloud Integration and Management:
• Develop, support, and manage PostgreSQL databases in cloud environments (AWS, Azure, GCP).
• Leverage cloud-native tools for scaling, monitoring, and disaster recovery.
• Team Leadership and Collaboration:
• Collaborate with development teams to design and implement database solutions.
• Provide guidance and mentorship to junior database engineers and administrators.
• Work closely with DevOps teams to automate database deployment and maintenance.
• Documentation and Best Practices:
• Develop and maintain comprehensive database documentation.
• Promote best practices in database development and management.

Qualifications -

Education:

• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
• Experience:
• 8+ years of experience in database architecture, with a focus on PostgreSQL.
• Expertise in SQL development and creation of new databases
• Proven expertise in migration, support, and management of large-scale PostgreSQL databases.
• Experience in cloud-based database management and tools (AWS RDS, Aurora, etc.).
• Technical Skills:
• Deep understanding of PostgreSQL internals, performance tuning, and optimization.
• Proficient in SQL, PL/pgSQL, and database modeling.
• Familiarity with tools like pgAdmin, pgBouncer, and replication techniques.
• Experience with ETL processes and integrating PostgreSQL with data pipelines.
• Knowledge of high availability, clustering, and disaster recovery solutions.

• Soft Skills:
• Strong problem-solving skills and attention to detail.
• Excellent communication and ability to translate technical concepts to stakeholders.
• Leadership and mentoring experience in a technical setting.

Preferred Skills -

• Experience with NoSQL and hybrid database solutions.
• Certifications in PostgreSQL or cloud platforms (e.g., AWS Certified Database – Specialty).
• Knowledge of containerization (Docker, Kubernetes) and Infrastructure-as-Code tools.

Pay range and compensation package - Pay range or salary or compensation

Equal Opportunity Statement - Include a statement on commitment to diversity and inclusivity.