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:
Support and issue resolution
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
Amazon Web Services
Amazon Aurora or RDS
Knowledge of the following technologies beneficial:
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)
If you are currently employed by IHS Markit, please apply internally via the Workday internal careers site.
Job Description During third shift, greets and registers guests, providing prompt and courteous service. Checks guests out of the hotel....Apply For This Job
SUMMARYPerforms assigned administrative assistant, secretarial and clerical duties and responsibilities to assist in the professional and efficient operation of Beecher...Apply For This Job
Company Overview At Memorial Sloan Kettering (MSK), we’re not only changing the way we treat cancer, but also the way...Apply For This Job
IMMEDIATELY HIRING!!! – APPLY TODAY!!! For more than a century, Goodyear has led the industry in manufacturing innovative tires that...Apply For This Job
Clerical Support Positions- Virtual Interviews Event DetailsDate: Tuesday, September 7, 2021 What We’re Hiring For Clerical Support Intake Details:Technical requirements...Apply For This Job
Putaway Associate job details: location:Rocklin, CA salary:$16 per hour date posted:Tuesday, August 17, 2021 experience:Entry Level job type:Temp to Perm...Apply For This Job