Job Description
Dear Candidate,
We have a job opening for one of our client for below mentioned position.
Role : Database Administartor
Experience : 2 to 10 Yrs
Location : Bangalore
Job Title : Core Operations Database Administartor - ITSO
Description :
The Core Operations (Ops) Database Administrator (DBA) is responsible for safeguarding the business data in the database, and delivery of databases support.
Role :
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.
Accountabilities
Develop and implement standards and best practices for database administration.
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 Groups Information Security Standard (i.e. ISIP,Trust Domain,Security Baseline,etc)
Operates under general direction. Assignments are very broad in nature and of the highest level of complexity. Able to impact beyond area of responsibility.
Dimensions and Special Challenges
Ability to effectively communicate with internal and external stakeholders and deliver practical solutions taking multiple agendas into account
Capacity to manage complex interfaces across organizational and geographic boundaries in both the Project team and the service delivery teams. This requires the capability to manage multiple tasks and have the ability to network / influence to achieve results.
Must show initiative and drive in identifying opportunities to save cost, time and improve efficiencies within the DBA area and have the ability to drive the solutions.
Must be willing to be on-call and/or work overtime and/or weekends as necessary for applications and systems support and maintenance.
Department : Computers
Industry : IT-Software
Skills : admin, sql
Recruiter details
Company name : Shell
Company discription :
Shell is an integrated energy company that aims to meet the world’s growing demand for energy in ways that are economically, environmentally and socially responsible.Shell is a global group of energy and petrochemical companies.Our operations are divided into four businesses: Upstream, Integrated Gas and New Energies, Downstream, and Projects & Technology.In Upstream we focus on exploration for new liquids and natural gas reserves and on developing major new projects where our technology and know-how add value for resource holders.In Integrated Gas and New Energies, we focus on liquefying natural gas (LNG) and converting gas to liquids (GTL) so that it can be safely stored and shipped to markets around the world. The New Energies business has been established to explore and invest in new low-carbon opportunities.In Downstream, we focus on turning crude oil into a range of refined products, which are moved and marketed around the world for domestic, industrial and transport use. In addition, we produce and sell petrochemicals for industrial use worldwide. Shell’s oil sands mining activities in North America are also part of the Downstream organisation.