Software Engineer

Sr Engineer – Monet SQL

Let’s be unstoppable together!

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 have a global commitment to diversity, equity, and inclusion as we believe in the undeniable strength that diversity brings to our business, 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. Learn more at www.circana.com.

Job Responsibilities

• Installation of Monet software on Required machine.
• Compile the source binaries based on required version.
• Mange Monet DBfarm and Databases.
• Backup and restore for a specific table/tables using mysqldump.
• Complete database Refresh from source to target.
• DBSync of databases from source to target.
• Verification of errors logs and see for any issues.
• Identifying the cause of database crash.
• Upgrading databases from lower to higher versions.
• Identification of running queries from database.
• Validation of monet database performance issues.
• Recommendation for any query running mechanisms.
• Understand the odbc driver releases and recommend for any AS changes on drivers.
• Managing merge tables and recommend for performance improvements.
• Installing PostgreSQL and its related extensions on different flavors of Linux environment.
• Health check of a PostgreSQL instances monitoring whether it is up and running all the time.
• Tunning PostgreSQL configuration parameters as per the server specs.
• Creating Databases, Tablespaces, and users/Schemas.
• Learn continuously, leveraging training resources and self-directed training, Sharing knowledge and skills with rest of the team.
• Skills in other open-source databases will be a plus
  
  

Requirements

• Minimum 5 + years of hands-on experience on PostgreSQL and Monet databases on Linux.
• The candidate should have good communication skills and strong technical knowledge on PostgreSQL.
• Hands on experience in performance fine-tuning, monitoring and administration in production instances required.
• Should have exposure on different kinds of backups and restore activities.
• Should have good knowledge on PostgreSQL high availability features.
• Experience in Disaster recovery setups, Active-Active PG configurations.
• Ability to perform maintenance activities to improve performance.
• Good Experience in data migration activities from oracle to PostgreSQL using ora2pg.
• Ability to setup the foreign data wrapper mechanisms for cross database access.
• Should have experience in configuring and managing the pgpool and troubleshoot for any kind of issues.
• Ability to perform upgrading of PostgreSQL clusters from lower version to higher version.
• Should have experience in tuning the application queries and recommends for changes accordingly.
• Ability to perform maintenance activities like performing full vacuum and analyze operations.
• Experience working offshore-onshore model will be a plus.
  
  

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/ Pune

Prospective candidates may be asked to consent to background checks (in accordance with local legislation and our candidate privacy notice ) Your current employer will not be contacted without your permission.