Senior DB2 LUW and Postgres Database Administrator

At Ensono, our Purpose is to be a relentless ally, disrupting the status quo and unleashing our clients to Do Great Things!  We enable our clients to achieve key business outcomes that reshape how our world runs. As an expert technology adviser and managed service provider with cross-platform certifications, Ensono empowers our clients to keep up with continuous change and embrace innovation.  

We can Do Great Things because we have great Associates. The Ensono Core Values unify our diverse talents and are woven into how we do business. These five traits are the key to achieving our purpose: Honesty, Reliability, Curiosity, Collaboration, and Passion. 

What You Will Do:

Reports to the US Database manager. You’ll be part of Global Implementation & Operational team, supporting the Operational & migration activities of mission critical infrastructure of Ensono’s clients, delivering a responsive and exceptional support service for client events and requests. We are looking for a Senior Db2 LUW/PostgreSQL(EDB) DBA who can bring strong expertise to join our team as a dedicated resource for a key client. Key responsibilities include:

•    Primary role will be to support our existing key client.
•    Work with clients on issues, requests related to Projects.
•    Work proactively and review high level project requirements and deliverables. 
•    Participate in an on-call rotation for 24x7 support for incidents and outages.
•    Automate DBA best practices.

You will achieve common goals with our teams to create a positive learning environment where knowledge sharing will help all associates be able to support the environment. The position will be challenging with opportunities to work on a broad range of Cloud technologies and products.

Key Responsibilities

•    Design and enhance, upgrade, or build new client Db2 LUW and EDB PostgreSQL environments.
•    Work closely with clients daily on projects, troubleshooting, or consultations.
•    Perform software installations, upgrades, and patches to Db2 LUW, PostgreSQL instances and servers.
•    Define and maintain Db2 LUW & PostgreSQL standards and governance.
•    Utilize industry standard technologies & methods to ensure the integrity & recoverability of Db2 LUW & PostgreSQL applications.
•    Perform Database Upgrades from Oracle or DB2 LUW to PostgreSQL
•    Serve as technical resource to business analysts, solutions development, and other groups responsible for Db2 LUW & PostgreSQL application development standards, system design and integration.
•    Ensure Db2 LUW & PostgreSQL systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).
•    Assist in creating new or maintaining documentation, runbooks, knowledge articles and diagrams. 
•    Assist with major issues, technical challenges, and troubleshooting.
•    Facilitate open communication and collaboration between our ops DBA team and the client, ensuring alignment and effective problem-solving.
 

We want all new Associates to succeed in their roles at Ensono. That's why we've outlined the job requirements below. To be considered for this role, it's important that you meet all Required Qualifications. If you do not meet all of the Preferred Qualifications, we still encourage you to apply.  

What You Will Need 

•    More than 5 years of experience in Db2 LUW Database administration
•    More than 2 years of experience in PostgreSQL Database administration (AWS RDS/EDB/ Open-Source PostgreSQL)
•    More than 2 years of experience in Database migration from Oracle/MSSQL/Db2 LUW to PostgreSQL
•    Maintain the database using different utilities. This includes using pg_ctl, pgdump, pgbackrest, BARMAN, psql, etc.
•    Solid understanding of Database technology
•    Extensive Database performance tuning experience
•    Expertise in implementing and maintaining High Availability and disaster Recovery configurations like Streaming/Multi-master Replication, EFM, BDR, Logical replication, RDS Global
•    Database Deep knowledge of industry-standard, enterprise-class best practices for a large database environment 
•    Good understanding of AIX and Intel platforms
•    Deep understanding of HADR Database and storage technologies like Data replication, TSM, etc.
•    Experience implementing, supporting and auditing database security
•    Experience with Unix/Linux OS platform and Unix Shell scripting and automation
•    Knowledge of administering advanced Db2 database functions including High Availability (HADR), Q-Replication and SQL replication (capture and apply, both continuous and non-continuous)

Preferred
•    Automation skills in Shell Scripts/Python/Ansible/Terraform (cloud) to automate routine maintenance activities. 
•    Knowledge of the ITIL framework\

Ability to work independently, analyze the requirement, and provide solutions.
•    A ‘client centric’ approach
•    Excellent demonstrable English written and verbal communication skills
•    Able to communicate in groups with confidence and conviction
•    Ability to multi-task and work well under pressure 
•    Excellent team collaboration skills are essential
•    Strong organizational and analytical skills
•    Ability to document processes and procedures in a clear, concise, and logical manner
•    Self-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule

 Why Ensono?  

Ensono is a place to make better happen – for our clients and for your career. You can do great things through innovation or collaboration, by learning or volunteering, or to promote diversity and inclusion. You can do great things for your own health or for a healthier planet. Whatever it means to you to do great things we want Ensono to be the place you can do it.   

We are a client-facing business, but we do encourage clients to allow us to work remotely most of the time so if you are not required to be on a client site, you can choose to work from home or in our Ensono offices. 

Some of our benefits include: 

• Unlimited Paid Days Off  

• Three health plan options through Blue Cross Blue Shield  

• 401k with company match  

• Eligibility for dental, vision, short and long-term disability, life and AD&D coverage, and flexible spending accounts  

• Paid Maternity Leave, Paternity Leave, and Sabbatical Leave 

• Education Reimbursement, Student Loan Assistance or 529 College Funding 

• Enhanced fertility coverage 

• Wellness program  

• Depending on location, ability to take advantage of fitness centers 

• Flexible work schedule 

As of the date of this posting, a good faith estimate of the current pay scale for this role is $95,000 to $148,000 annually based on a full-time schedule. Please note that placement in the range may vary based on numerous factors including but not limited to skills, experience, internal equity, and business needs. In addition to base salary, other compensation programs, depending on eligibility, include an annual bonus plan based on company and individual performance [OR] a role-based, sales-incentive plan, and an equity grant under our Associate Equity Appreciation Program. 

Ensono is an Equal Opportunity/Affirmative Action employer. We are committed to providing equal employment to our Associates and building a diverse and inclusive workforce. All qualified applicants will be considered without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or other legally protected basis, in accordance with applicable law.  

Pay transparency nondiscrimination statement/posting OFCCP’s pay transparency policy can be found on OFCCP’s website.  

If you need accommodation at any point during the application or interview process, please let your recruiter know or email USTalentAcquisition@ensono.com.