Job Description

The Role

The Core Ops DBA is responsible for safeguarding the business data in the database, and delivery of databases support. The role will serve as a database expert consultant to provide database technology solutions meeting business and application needs. It will provide architectural guidelines to build and maintain scalable database environments and will be responsible to assist the DBA Lead to continually engineer a database service and database technical solution that meets dynamic business/IT requirements. The Core Ops DBA acts as a database technology subject matter expert, and works with cross functional teams in building, scalable enterprise solutions hosted in cloud (Azure).

• Develop and implement standards and best practices for database administration.
• Hands-on experience in either Azure cloud platforms
• Automation & Evergreening Database landscape components
• Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
• Manage and maintain database architecture including database replication, disaster recovery, and backups strategy. Participate in disaster recovery planning and testing.
• Manage database capacity including sizing estimation, growth planning, usage monitoring and alerts.
• Implement database performance monitoring and fault monitoring. Promote continuous improvement
• Establish and maintain performance baselines, troubleshoot performance issues and provide recommendations/fixes for identified issues.
• Responsible to ensure Application tuning, configuration and administration to deliver optimal performance of applications.
• Responsible to ensure the Application portfolio is compliant with the relevant IT controls and information security standards & baselines.
• Ensure that end-to-end performance is monitored and maintained to high level of quality, standards, supportability and operability as defined within negotiated and agreed Service Level Agreements (SLAs) and to propose and implement necessary Service Improvements
• Provide user support and consultancy service to Application and Infrastructure Developments teams and projects (i.e. assisting development in writing and tuning of SQL and PL/SQL code)
• Responsible to provide consulting in relation to data technology, architecture, modelling and design.
• Ensure the reviewing of releases, upgrades and fixes available from database software suppliers and subscribed security organizations and identify those which merit action.
• Ownership of coordination with vendor support services regarding database problems and issues.
• Ownership of problem and situation management calls and undertake root cause analysis on situations or major incidents related to databases.
• Escalation point for operation-related issues. Manage and coordinate S@R and Situations.
• Manage the Implementation, compliance with and maintaining security as per Security Incident Process.
• Manage the demand and the implementation of planned and emergency database changes according to defined Change Control procedures and policies and in conjunction with Application Development Teams.
• Documenting standards and procedures. Ensure licensing agreement compliance with DBMS and DBMS related software.
• Maintain a "master" level of knowledge of the Shell Group Information Security Standard
• Operates under general direction. Assignments are very broad in nature and of the highest level of complexity. Able to impact beyond area of responsibility.

We're keen to hear from individuals with minimum 5 years experience in a reputed company or industry.

Disclaimer

Please note: We occasionally amend or withdraw Shell jobs and reserve the right to do so at any time, including prior to the advertised closing date. Before applying, you are advised to read our data protection policy. This policy describes the processing that may be associated with your personal data and informs you that your personal data may be transferred to Royal Dutch/Shell Group companies around the world. The Shell Group and its approved recruitment consultants will never ask you for a fee to process or consider your application for a career with Shell. Anyone who demands such a fee is not an authorised Shell representative and you are strongly advised to refuse any such demand. Shell is an Equal Opportunity Employer.