Database Administrator - Gurgaon jobs in Gurgaon at IHS Markit

The Shared Services team is responsible for managing and supporting our Managed Services clients.

The role involves being a member of the database team within Shared Services which is responsible for

maintaining managed services databases in 3rd party data centers and on the cloud including

Administration

Housekeeping

Change Management

Support and issue resolution

Monitoring

Tuning

Furthermore, the Shared Services team is responsible for all of the infrastructure and automation required to support continuous integration and continuous delivery.

maintenance and provisioning of all internal environment and integration databases

Administration of all internal oracle and postgres 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.

Successful candidates will play an integral role in the Shared Services offering providing support and expertise to ensure maximum uptime of environments. They will ensure that client SLAs are strictly adhered to and their primary focus will be on continuous performant operations.

Additionally, candidates will be 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 Shared 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 rota

Document all work, particularly around Managed Services.

Education and experience

5+ 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

ora2pg

Good Linux/Unix knowledge

Good Database skills

Data Modelling

Database Release management

Good oracle knowledge and experience

Administration

Performance Monitoring

Datapump & RMAN

SQL

PL/SQL

Experience of the following technologies

ASM

RAC

JIRA

Shell scripting

Amazon Web Services

Amazon RDS

Knowledge of the following technologies beneficial

Data Guard

python

Commercial awareness

Knowledge of Corporate Actions business is major plus. Knowledge of financial markets or financial feeds would be very useful

Personal impact

Significant customer service focus

Willingness to learn new skills

Excellent Problem Solving Skills

Strong attention to detail

Strong inter-personal skills with practical, can-do approach

Self-motivated, proactive work ethic

Good personal time management and ability to complete individual work assignments without daily supervision

Communication

Excellent verbal and written communication skills

Teamwork

Ability to collaborate in a team environment