Perform physical and logical database administration functions as required for Application Sustain Services.
Work with Customer and other Third Parties (Application, Architects, ITO personnel, tester etc) to support DBA functions.
Provide appropriate resources and skill sets to support the DBA functions for the Applications as required.
Assist in analyzing, performance tuning and maintain test and production databases.
Review with Customer new Database Management System (DBMS) releases to understand the business and technical impacts.
Set up and maintain test and production databases.
Propose database changes to ease monitoring and administrative effort.
Document and implement changes to databases via proper Change Management methodology.
Monitor and analyze database activity to proactively identify and prevent potential Incidents and also recommend performance improvements.
Participate in situation management of incidents related to database operations.
Test and evaluate impact on Applications of new DBMS Software releases.
Ensure integrity of all database components, eg. Table definitions, structure definitions, statistic and indexes status etc.
Report and remediate all security violations.
Familiar with tuning utilities and reports. For example AWR, ASH, ADDM, SQLT, SQL Tuning Advisor, SQL tracing and analysis, database event tracing etc.
Familiar with Oracle CPU and PSU patching procedure.
Capable of evaluating new RDMBS technology with the objective to improve the quality of database administrative tasks.
Minimum Requirements that must be reached:
Senior DBA resource with 7+ overall years of experience
5+ years of solid experience with Oracle RAC and 11G / 12C architecture, design, deployment and operational experience
2+ MS SQL Server would be nice to have
Sybase 15/16 experience also desirable
Extensive SQL tuning experience.
Solid knowledge of Korn Shell scripting.
Strong communication, decision making and interpersonal skills.
Strong organizational and time management skills.
Able to work under pressure and take responsibility during situation management.
Agree to work independently and manage time and deliverable