PostgresSQL Lead
- Optum
- 10 - 15 years
- Noida, Gurugram
- 7 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
- 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.
Job Classification
Industry: Analytics / KPO / ResearchFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Technical LeadEmployement Type: Full timeContact Details:
Company: OptumLocation(s): Noida, Gurugram
Keyskills: PostgreSQL application development Backend Development Docker Kubernetes Java as Redis locking Cassandra SQL waits blocking Nosql Databases MongoDB Python
Similar positions
Optum
With the playing field for software development radically altered by distributed computing applications that span from cloud to mobile to Internet of Things (IoT), efficiency is at a premium. OptumSoft streamlines the software writing process through a platform that replaces the ad hoc approach many...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in