This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/jobs/12370436 Let\'s be unstoppable together!

Circana (formerly IRI and NPD) is the leading advisor on the complexity of consumer behavior. Through unparalleled technology, advanced analytics, cross-industry data, and deep expertise, we provide clarity that helps almost 7,000 of the world\'s leading brands and retailers take action and unlock business growth. We understand more about the complete consumer, the complete store, and the complete wallet so our clients can go beyond the data to apply insights, ignite innovation, meet consumer demand, and outpace the competition.

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.

What will you be doing?

This position will be responsible to architect and develop solutions on PostgreSQL , Monet, MongoDb, oracle and SQL server Databases with primary focus on open source.

Job Responsibilities

• Installing PostgreSQL and its related extensions on different flavors of Linux environment.
• Architect Database solutions with focus on open source platforms
• Interface with executives and cross functional teams on design and planning
• Ability to manage a large team across the world
• Architect Disaster recover solutions
• 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.
• Work closely with business, IT Associates and outside vendors to effectively choose, Plan, Deploy and maintain system changes.
• Develop standardization documentation and research for new features for best practices.
• Understand DBA challenges, deliver technical solution that meet the unique needs of DBAs with innovation and automation.
• Learn continuously, leveraging training resources and self-directed training, Sharing knowledge and skills with rest of the team.

Requirements

• Minimum 12 + years of hands-on experience on PostgreSQL and Monet databases on Linux.
• Ability to architect DB solutions
• Ability to work with Senior executives on design and planning
• 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.
• Ability to estimate and perform capacity planning on required phases on environment.
• 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.
• Should have experience on third party tools such as pgbadger, barman and pgbackrest.
• 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.
• Skills in other open-source databases will be a plus.
• 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, respec