PostgresSql lead with Application Development

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

• Bachelor’s 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.