PostgresSQL Lead
- Optum
- 10 - 15 years
- Noida, Gurugram
- 4 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+ View Contact
Keyskills: PostgreSQL application development Backend Development Docker Kubernetes Java as Redis locking Cassandra SQL waits blocking Nosql Databases MongoDB Python
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in