Database Administration - PostgreSQL Bengaluru, KA, IN Posted 2 hours ago

Circana; Bengaluru; On-site; INR 800,000 - 1,400,000; Full time

Job summary

Circana is seeking a PostgreSQL Database Administrator to manage and optimize PostgreSQL environments in Bengaluru. You will ensure data availability, performance, and reliability across production databases, with a focus on backups, recovery, and disaster readiness.

The role requires 3–4 years of hands-on DBA experience, strong SQL tuning skills, and familiarity with Linux and scripting. You will collaborate with engineering and operations teams to keep our data platforms robust and scalable.

Qualifications

• 3–4 years of hands-on PostgreSQL DBA experience.
• Strong knowledge of PostgreSQL architecture and concepts.
• Experience with PostgreSQL backup and recovery methods.
• Knowledge of SQL query optimization and performance tuning.
• Experience with PostgreSQL replication.
• Good understanding of Linux/Unix environments.
• Familiarity with Shell scripting or Python scripting.
• Experience with database monitoring tools.
• Strong troubleshooting and problem-solving skills.

Responsibilities

• Install, configure, and maintain PostgreSQL databases.
• Monitor database health, availability, and performance.
• Perform routine database maintenance activities.

Skills

PostgreSQL DBA

Linux

SQL Performance Tuning

Backup & Recovery

Shell/Python Scripting

Replication & Monitoring

Education

Bachelor's Degree in related field

Tools

PostgreSQL Tools

Job description

Database Administrator (PostgreSQL)

Let's be unstoppable together!

Circana is a leading provider of technology, AI, and data solutions for consumer-packaged goods companies, manufacturers, and retailers. Our predictive analytics and Liquid Data® platform help clients measure market share, uncover consumer behavior, and drive growth--powered by six decades of expertise and an expansive, high-quality data set.

At Circana, we are fueled by our passion for continuous learning and growth, we seek and share feedback freely, and we celebrate victories both big and small in an environment that is flexible and accommodating to our work and personal lives. We're a global company dedicated to fostering inclusivity and belonging. We value and celebrate the unique experiences, cultures, and viewpoints that each individual brings. By embracing a wide range of backgrounds, skills, expertise, and beyond, we create a stronger, more innovative environment for our employees, clients, and communities. With us, you can always bring your full self to work. Join our inclusive, committed team to be a challenger, own outcomes, and stay curious together. Circana is proud to be Certified™ by Great Place To Work®. This prestigious award is based entirely on what current employees say about their experience working at Circana. Learn more at www.circana.com.

What will you be doing?

• We are looking for a skilled PostgreSQL Database Administrator (DBA) with 3-4 years of experience to manage and support PostgreSQL database environments. The candidate will be responsible for database administration, performance monitoring, backup and recovery, troubleshooting, and ensuring high availability of critical business databases.

Job Responsibilities:

Database Administration

• Install, configure, and maintain PostgreSQL databases.
• Create and manage database users, roles, and permissions.
• Monitor database health, availability, and performance.
• Perform routine database maintenance activities.

Performance Monitoring & Tuning

• Monitor database performance and identify bottlenecks.
• Optimize SQL queries and indexes.
• Analyze slow queries and recommend improvements.
• Support capacity planning and database growth management.

Backup & Recovery

• Execute and validate database backup procedures.
• Perform database restore operations when required.
• Assist in disaster recovery testing and documentation.
• Ensure backup policies and retention requirements are followed.

High Availability & Replication

• Support PostgreSQL replication environments.
• Monitor replication status and troubleshoot issues.
• Assist in failover and recovery activities.

Production Support

• Troubleshoot database-related incidents and outages.
• Work with application and infrastructure teams to resolve issues.
• Participate in on-call support and maintenance activities.
• Perform root cause analysis and document findings.

Automation & Monitoring

• Use scripts to automate routine DBA activities.
• Work with monitoring tools for proactive alerting and reporting.
• Maintain database documentation and operational procedures.

Requirements:

• 3-4 years of hands-on experience with PostgreSQL Database Administration.
• Strong knowledge of PostgreSQL architecture and database concepts.
• Experience with PostgreSQL backup and recovery methods.
• Knowledge of SQL query optimization and performance tuning.
• Experience with PostgreSQL replication.
• Good understanding of Linux/Unix environments.
• Familiarity with Shell scripting or Python scripting.
• Experience with database monitoring tools.
• Strong troubleshooting and problem-solving skills.

Preferred Skills

• Experience with PostgreSQL upgrades and migrations.
• Knowledge of High Availability solutions such as Patroni, PgBouncer, or repmgr.
• Exposure to AWS, Azure, or GCP cloud platforms.
• Knowledge of DevOps tools and CI/CD practices.

Qualifications

• Bachelor's Degree in related field.
• 3-4 years of relevant PostgreSQL DBA experience.

Key Competencies

• Strong analytical and troubleshooting skills.
• Good communication and documentation abilities.
• Ability to work independently and collaboratively in a team.
• Willingness to provide production and on-call support.

• Primary Skill: PostgreSQL DBA Secondary Skills: Linux, SQL Performance Tuning, Backup & Recovery, Shell/Python Scripting, Replication & Monitoring.

Circana Behaviors:

• Stay Curious: Being hungry to learn and grow, always asking the big questions
• Seek Clarity: Embracing complexity to create clarity and inspire action
• Own the Outcome: Being accountable for decisions and taking ownership of our choices
• Center on the Client: Relentlessly adding value for our customers
• Be a Challenger: Never complacent, always striving for continuous improvement
• Champion Inclusivity: Fostering trust in relationships engaging with empathy, respect and integrity
• Commit to each other: Contributing to making Circana a great place to work for everyone

Location

• This position can be located in the following area(s): Bangalore

An offer of employment may be conditional upon successful completion of a background check in accordance with local legislation and our candidate privacy notice. Your current employer will not be contacted without your permission