Member Technical Staff 2 - Postgres DBA

Job Description

About the Role

We are seeking a highly motivated Database Engineer with a strong foundation in PostgreSQL to take full ownership of our database infrastructure. In this role, you will lead the design, optimization, scaling, and reliability of our core relational databases while actively exploring emerging frameworks. This position is ideal for a proactive engineer who bridges the gap between database architecture and application logic, thrives on solving performance bottlenecks, builds resilient cloud architectures, and is excited to leverage AI and modern technologies to drive our data strategy forward.

Key Responsibilities

• Infrastructure Reliability & HA: Design, implement, and manage High Availability (HA) architectures. Configure and maintain streaming & logical replication, clustering, and 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.

• Database Design & Architecture: Architect, model, and deploy scalable database schemas that align with complex application requirements and business logic.

• Cloud & Infrastructure Management: Deploy and manage PostgreSQL databases within modern cloud environments (e.g., AWS, GCP, Azure), optimizing for cost, performance, and security.

• Query Optimization & Performance Tuning: Write, analyze, and optimize complex SQL queries. Utilize advanced indexing, partitioning, and execution plan analysis to ensure low latency.

• End-to-End Ownership: Take full accountability for database health, migrations, and data integrity from the development phase through production deployment.

• AI Integration & Workflow Optimization: Leverage AI tools to streamline development workflows, and collaborate on integrating database systems with AI/ML pipelines (e.g., utilizing vector data extensions like pgvector).

• Technology Exploration: Continuously evaluate and pilot new database engines, NoSQL solutions, and modern tech stacks to keep our infrastructure efficient and future-proof.

Qualifications

• Experience: 3 to 10 years of proven, hands-on professional experience working extensively with PostgreSQL in production environments.

• Resiliency Expertise: Deep knowledge of database replication strategies, High Availability (HA) setups (e.g., Patroni, PgBouncer), and Disaster Recovery planning.

• Cloud Infrastructure: Solid hands-on experience with cloud platforms (AWS, GCP, or Azure) and managed database services (e.g., Amazon RDS, Aurora, Google Cloud SQL).

• Core Database Expertise: Deep understanding of relational database design principles, ACID compliance, normalization, and advanced SQL querying.

• Programming Exposure: Basic proficiency or working knowledge of at least one general-purpose programming or scripting language (e.g., Python, Node.js, Java, Bash) for automation and backend integration.

• Autonomy: Demonstrated ability to take ownership of tasks, manage multiple priorities, and deliver robust solutions with minimal supervision.

Preferred Qualifications

• 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: Strong familiarity with artificial intelligence concepts, either through integrating AI-driven features into applications or utilizing AI assistants for coding and process efficiency.

• Adaptability: A strong willingness and enthusiasm to step outside your comfort zone, learn new programming languages, and adopt cutting-edge technologies as project needs evolve.

Additional Information

Please be aware that job-seekers may be at risk of targeting by scammers seeking personal data or money. Nielsen recruiters will only contact you through official job boards, LinkedIn, or email with a nielsen.com domain. Be cautious of any outreach claiming to be from Nielsen via other messaging platforms or personal email addresses. Always verify that email communications come from an @nielsen.com address. If you're unsure about the authenticity of a job offer or communication, please contact Nielsen directly through our official website or verified social media channels.