PostgresSQL Lead

Primary Responsibilities

• Take ownership of database performance tuning and optimization, ensuring support for high-throughput, low-latency applications in production environments.
• Analyse and resolve performance bottlenecks across application and database layers, including query optimization, indexing strategies, locking, blocking, and resource contention.
• Architect and implement scalable, resilient database systems (relational and NoSQL) that meet the demands of high-load applications (excluding mobile apps).
• Collaborate with cross-functional teams to understand business requirements and deliver robust, scalable application and database solutions.
• Design and develop backend services using any programming language, preferably Java or Python, ensuring efficient data flow and seamless integration with databases.
• Build and maintain database schemas, stored procedures, and views aligned with application logic and performance goals.
• Work closely with DevOps and cloud teams to deploy and manage applications and databases in cloud environments (AWS, Azure, GCP).
• Implement high-availability and disaster recovery strategies for both applications and databases.
• Ensure secure handling of sensitive data including PII and PHI, enforcing role-based access controls, encryption, and auditing.
• Integrate application and database changes into CI/CD pipelines using tools like GitHub Actions and Jenkins, ensuring smooth and reliable deployments.
• Maintain clear documentation of database configurations, application architecture, and performance tuning strategies.

Required Qualifications

• 9+ years of experience in development of highly scalable distributed applications
• 8+ years of experience in backend application development with strong programming skills in any language, preferably Java or Python.
• 6+ years of experience in database engineering, with a primary focus on performance tuning and managing high-load production workloads.
• 5+ years of experience with containerization and orchestration tools like Docker, Kubernetes, and Packer.
• 5+ years of experience with PostgreSQL in high-performance scenarios with Database Schema Design and Database modelling
• 5+ years of experience resolving SQL waits, locking, blocking, and resource contention in production environments with Indexes, Views and Triggers, execution Plans and query Optimization
• 4+ years of experience deploying and managing applications and databases on cloud platforms (AWS, Azure, or GCP).
• 3+ years of experience with change management systems like ServiceNow and Jira.
• 2+ years of experience with NoSQL databases such as Redis, MongoDB, or Cassandra.

Preferred Qualifications

• Bachelors degree in Computer Science or a related field.
• Experience with monitoring and logging tools such as Prometheus, Grafana, Splunk, Azure Monitor and ELK Stack.
• Proficiency in Git and branching strategies for version control.
• Proven experience in System Design and integration projects for high-load applications.
• Strong consulting and communication skills to translate business needs into scalable technical solutions.