IHS Markit Hiring for Postgres Database Administrator at United States Full Time

Postgres Database Administrator

The Managed Services team is responsible for managing and supporting our Managed Services clients as well as providing L3 support for our on-prem clients.

The role involves being a member of the database team within Managed Services which is responsible for maintaining managed services databases on the cloud including:

• Administration

• Housekeeping

• Change Management

• Support and issue resolution

• Monitoring

• Tuning

  The database team also supports our on-prem clients as and when database issues arise that require postges expertise.

  The overall Managed Services team is also responsible for all of the infrastructure and automation required to support continuous integration and continuous delivery internally.

• Maintenance and provisioning of all internal environment and integration databases

• Administration of all internal postgres (and oracle) instances and servers

• Development, documentation and governance of all DDL and DML product scripts

• Packaging of Database Releases

• Providing client troubleshooting support and SQL script development / reviews and general postgres (and oracle) expertise for the support desk

• Offering support and expertise to ensure maximum uptime of environments

• Ensure that client SLAs are strictly adhered to and their primary focus will be on continuous performant operations

• Involved in core team tasks including data modelling, governance and quality of database artefacts as well as release packaging

  ​

  Candidates will be required to liaise with the other teams in Managed Services to ensure the overall team works together as a unit. Candidates will also need to be able to liaise with various other groups (e.g. Architecture, Design Authority, Support) to ensure changes to the database or support issues are dealt with comprehensively.

  Candidates should be familiar with operating in a challenging production environment supported from different locations and should also have a good appreciation of Development processes, toolsets and delivery infrastructure, and be comfortable working with multiple differing systems and tools. The successful applicant will be required to work within a team structure. The candidate should demonstrate a willingness to learn new technologies, processes, toolsets and be comfortable working with multiple differing systems.

  Duties & accountabilities

• Management of managed services environments

• Provide support for any database related issues to all clients, particularly managed services clients

• Manage high severity incidents via process and work with all stakeholders to resolve issues as soon as possible including attending client bridge calls

• Ensure Database requests are dealt with within defined SLA’s

• Modelling and scripting database changes for all our products

• Ensure client releases are packaged and made available in a timely manner

• Be available for on-call rotation

• Document all work, particularly around Managed Services

  Education & experience

• 8+ years of experience in similar role with Degree in Technology, Computer Science, IT or a related course

• Extremely proficient in Postgres – Administration, Performance and Tuning, pSQL, PL/pgSQL, pgdump, PGBadger etc.

• Good Linux/Unix knowledge

• Good Database skills – Data Modelling, Database Release management

• oracle experience would be a plus

  Experience of the following technologies or concepts:

• Replication / HA for postgres

• WAL

• MVCC

• JIRA

• Shell scripting

• pSQL

• Amazon Web Services

• Amazon Aurora or RDS

  Knowledge of the following technologies beneficial:

• Python

  Commercial awareness

• Knowledge of Corporate Actions business is major plus

• Knowledge of financial markets or financial feeds would be very useful

Inclusion and diversity are critical to the success of IHS Markit, and we actively encourage applications from people of all backgrounds. We are committed to providing equal employment opportunity without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, status as a protected veteran, or any other protected category. For more information on the many ways in which we enthusiastically support inclusion and diversity efforts for both candidates and employees, please access our Inclusion & Diversity Statement here.

We are proud to provide reasonable accommodations to applicants with disabilities. If you are interested in applying for employment with IHS Markit and need special assistance or an accommodation to use our website or to apply for a position, please contact ([email protected]) or call +1 212 849 0399. Determination on requests for reasonable accommodation are considered on a case-by-case basis. This contact information (email and phone) is intended for application assistance and accommodation requests only. We are unable to accept resumes or provide information about application status through the phone number or email address above. Resumes are only accepted through the online application process, and only qualified candidates will receive consideration and follow-up.

IHS Markit maintains a substance-free workplace; employees may be asked to submit to a drug test (where permitted by law). In addition, as a federal contractor in the United States, the company participates in the E-Verify Program to confirm eligibility to work.

For information please click on the following links:

IHS Markit Business Code of Conduct (https://investor.ihsmarkit.com/static-files/86e1cd0a-429d-4398-9f95-c54d4c2fa1e0) Right to Work EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) EEO is the Law Supplement Pay Transparency (https://www.dol.gov/sites/dolgov/files/OFCCP/pdf/pay-transp_%20English_formattedESQA508c.pdf)

Current Colleagues

If you are currently employed by IHS Markit, please apply internally via the Workday internal careers site.