96 applicants

Company

Circana · 19 hours ago

VP of Database Operations (Level 20)

United States

Full-time

Remote

Director/Executive

$160K/yr - $175K/yr

12+ years exp

Maximize your interview chances

Market Research

H1B Sponsor Likely

Insider Connection @Circana

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

PostgreSQLMonetLinuxDisaster recoveryMongoDBOracleSQL ServerPerformance tuningCapacity planningData migrationHigh availabilityPgpoolOra2pgOpen-source databasesUpgrading PostgreSQL clustersQuery tuningVacuum operationsTeam management

Required

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

Benefits

Paid time off

Medical/dental/vision insurance

401(k)

Company

Circana

Circana consults on the complexities of customer behavior.

Founded in 1966

Chicago, Illinois, USA

5,001-10,000 employees

https://www.circana.com

H1B Sponsorship

Circana has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (29)