Database Administration - PostgreSQL

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

Job summary

Circana is a leading provider of technology, AI, and data solutions for consumer-packaged goods companies, manufacturers, and retailers. We are seeking a skilled PostgreSQL Database Administrator (DBA) with 3-4 years of hands-on experience to manage and support PostgreSQL environments in a hybrid work model in Bangalore.

You will handle database administration, performance tuning, backups and recovery, and high availability, while collaborating with application and infrastructure teams to keep

Qualifications

• 3-4 years of hands-on PostgreSQL DBA experience.
• 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.

Responsibilities

• Install, configure, and maintain PostgreSQL databases.
• Monitor database health, availability, and performance.
• Create and manage database users, roles, and permissions.
• Monitor replication status and troubleshoot issues.
• Assist in failover and recovery activities.
• Troubleshoot database-related incidents and outages.
• Use scripts to automate routine DBA activities.
• Maintain database documentation and operational procedures.

Skills

PostgreSQL DBA

Linux

SQL Performance Tuning

Backup & Recovery

Shell/Python Scripting

Replication & Monitoring

Education

Bachelor's Degree in related field

Job description

Job Category: Infrastructure, Cyber & Corporate Systems

Requisition Number: DATAB022405

• Full-Time
• Hybrid

Locations

Showing 1 location

Description

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.

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

• 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.
• 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.

As well as the technical skills, experience and attributes that are required for the role, our shared behaviors sit at the core of our organization. Therefore, we always look for people who can continuously champion these behaviors throughout the business within their day-to-day role:

• 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 improvementLocation

  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