Senior Software Engineering Lead - Postgres SQL Server
- Optum
- 8 - 13 years
- Noida, Gurugram
- 5 months ago
- Email to a friend
- Report this job
Job Description
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.
Job Classification
Industry: RetailFunctional Area / Department: Engineering - Software & QARole Category: DevOpsRole: DevOps Consultant / ArchitectEmployement Type: Full timeContact Details:
Company: OptumLocation(s): Noida, Gurugram
Keyskills: continuous integration ansible cd tools terraform ci / cd tools kubernetes us healthcare ci/cd dbms change management docker sql java git gcp jenkins jira python github microsoft azure packaging cloud platforms sql server servicenow grafana aws
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in