Senior Member Technical Staff ( Postgres DBA)
The Nielsen CompanyBengaluru, IndiaOn-Site
Needs a free Superjobs account. You'll finish on The Nielsen Company's SmartRecruiters page.
Skill score
Summary
This Senior MTS (P3) owns the PostgreSQL database infrastructure at Gracenote, designing high availability, disaster recovery, performance tuning, and cloud deployments while mentoring engineers and escalating production issues. It suits an experienced, autonomous database engineer with deep PostgreSQL operations experience who can make and defend architectural decisions.
- Estimated salary
- Est. ₹13–19 LPA
- Estimated for a staff-level role, ~8 yrs experience, India. Not published by the employer.
- Work mode and location
- On-Site, Bengaluru, India
- Experience
- 8+ yrs
- Employment type
- Full-time
Job description
Overview
We are seeking a highly autonomous and strategic Senior MTS (P3) to architect, scale, and take full ownership of our PostgreSQL database infrastructure. At this level, you will not just maintain databases; you will drive our data architecture, define best practices for High Availability (HA) and Disaster Recovery (DR), and lead cross-functional initiatives to ensure our systems are resilient, performant, and scalable. This role requires a proactive problem-solver who bridges the gap between complex application logic and optimal database design, while leveraging modern cloud infrastructure and AI technologies to future-proof our stack.
Roles and responsibilities
- Architectural Leadership: Lead the design and deployment of highly scalable, distributed database architectures that support complex, high-throughput application requirements.
- Infrastructure Reliability & HA: Design, implement, and manage High Availability (HA) architectures. Configure and maintain streaming & logical replication, clustering, and automated failover mechanisms. Proactively identify single points of failure and engineer automated failover mechanisms.
- Disaster Recovery (DR): Develop, execute, and test robust disaster recovery plans. Ensure data durability through automated backup strategies and rapid point-in-time recovery (PITR) procedures.
- Advanced Query & Performance Engineering: Perform deep-dive performance tuning. Analyze complex execution plans, optimize locking behaviors, and design and implement advanced partitioning and indexing strategies.
- Cloud & Infrastructure Management: Drive the deployment, security, and cost-optimization of PostgreSQL within modern cloud environments (AWS, GCP, or Azure), utilizing infrastructure-as-code (IaC).
- End-to-End Ownership: Take full accountability for database health, migrations, and data integrity from the development phase through production deployment.
- Cross-Functional Mentorship & Ownership: Act as the ultimate owner of database health. Collaborate closely with software engineering teams to influence backend code, guide API data access patterns, and mentor junior engineers on database best practices.
- AI Integration & Tech Exploration: Lead the evaluation and integration of emerging technologies, including NoSQL data stores and AI/ML vector databases (e.g., pgvector), to solve complex business problems.
- Complex Problem Solving: Act as a key technical escalation point. Leverage strong analytical skills to diagnose deep systemic issues, perform rigorous root-cause analysis (RCA), and implement highly scalable, permanent solutions for production bottlenecks.
Skills required
Top skills
- PostgreSQL
- High availability
- Disaster recovery
- Replication
All skills (8)
- Performance tuning
- Terraform
- AWS EC2
- Python
- Cloud databases
- MVCC
- NoSQL databases
- pgvector
Qualifications
- Experience: 8 - 12+years of proven, hands-on professional experience working extensively with PostgreSQL in production environments.
- Resiliency & Cloud Mastery: Expert-level knowledge of replication strategies, HA architectures, and DR planning. Proven track record managing cloud-based/on-prem (e.g., RDS, Aurora, Cloud SQL) data infrastructure
- Core Database Expertise: Deep command of relational database design, ACID transactions, MVCC (Multi-Version Concurrency Control), and advanced SQL querying.
- Programming & Automation: Solid proficiency in at least one backend or scripting language (Python, Node.js, Java, Go, or Bash) to build automation tools and integrate with CI/CD pipelines.
- End-to-End Execution: Demonstrated ability to independently manage large-scale projects from conception to production, making high-level architectural decisions and defending them with data.
- Problem-Solving Mastery: Exceptional troubleshooting skills with a proven track record of deconstructing complex, ambiguous infrastructure challenges and delivering elegant, data-backed solutions.
- Terraform & EC2 Hands-On Expertise: Deep, practical experience using Terraform to provision and manage cloud infrastructure. Must have strong hands-on experience deploying, tuning, and managing self-hosted PostgreSQL clusters directly on AWS EC2 instances, including storage optimization (EBS volume types, IOPS tuning), network configuration (VPCs, Security Groups), and custom AMIs.
Nice to have
- NoSQL Exposure: Familiarity with NoSQL databases (e.g., MongoDB, Redis, Cassandra, DynamoDB) and a solid understanding of when to leverage NoSQL versus relational data models.
- AI Acumen: Hands-on experience integrating database systems with AI pipelines, or utilizing AI-driven tools to enhance developer productivity and database operations..
- Modern Tech Adaptability: A strong appetite for exploring new tech stacks and frameworks, with a history of successfully introducing new, impactful technologies to a team.
Company info
About The Nielsen Company
At Nielsen, we are passionate about our work to power a better media future for all people by providing powerful insights that drive client decisions and deliver extraordinary results. Our talented, global workforce is dedicated to capturing audience engagement with content - wherever and whenever it’s consumed. Together, we are