Circana
Website:
circana.com
Job details:
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:
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 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
Click on Apply to know more.
