Senior Software Engineering Lead - Postgres SQL Server

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:

• 8+ years of experience as a Postgres SQL Server Data Engineer with experience in design, implementation, and management
• 5+ years of solid experience with tools like Terraform, Kubernetes, Docker, Packer
• 5+ years of hands-on experience with CI/CD tools ( Github action, Jenkins etc.)
• 5+ years of experience with change management systems, such as ServiceNow and Jira
• 5+ years of experience with SQL waits, locking, blocking and resource contention
• 4+ years proven experience managing Databases on cloud platforms
• 3+ years of experience PII Personally Identifiable Information or PHI Personal Health Information

Preferred Qualifications:

• Bachelors degree in Computer Science or related field
• Cloud Platforms:Familiarity with AWS, Azure, or GCP services
• Monitoring & Logging: Knowledge of monitoring tools (e.g., Prometheus, Grafana, Datadog) and logging tools (e.g., ELK Stack)
• Version Control: Experience with Git and branching strategies
• Infrastructure as Code: Proficiency in tools like Terraform and Ansible
• System Implementation & Integration: Proven experience in system implementation and integration projects
• Consulting Skills: Ability to consult with clients and stakeholders to understand their needs and provide expert advice.