Job Description :
ESSENTIAL DUTIES AND RESPONSIBILITIES
Develops, documents and rolls out standard process for implementing database and system patch upgrades and new Oracle 12c database environment builds
Defines, refines, and standardizes database performance and tuning practices
Refines and manages baseline configurations for the MSRB database environment
Automates routine database functions to ensure accuracy and minimize costs
Establishes and practices a consistent database backup and recovery practice that complies with the MSRB backup and retention policies and business continuity practices
Performs migration of corporate database systems from Windows to Linux
Performs migration of corporate databases from Oracle 11g to Oracle 12c
Develops and follows upgrades procedures to ensure consistency within all MSRB databases
Conducts performance testing and reports on impact of Oracle 12c upgrade on MSRB applications
Enhances the MSRB data replication processes to reduce the amount of time between replication using Oracle golden gate 12c.
Provides 24x7 operational support of corporate production databases on a rotating schedule
Performs routine production database and application maintenance tasks on a rotating basis
Monitors all production database activity for operational improvements to include, but not limited to CPU, Disk and Memory utilization, space utilization, replication and consistency of sites, long running queries/data loads, query access plans, security infractions and overall performance of databases Develops and implements corrective measures for database issues/problems found during monitoring.
Provides database technical support for Technology and Application Delivery projects to include, but not limited to: analysis of database design and schema, database environment provisioning, security assessments, database build executions, database application performance testing/tuning and supporting project deployments. Leads and manages all database aspects of the assigned technology delivery project.
Provides database technical support in maintaining and building the database non-production environments, including database refreshes, database patch management, database space management, database performance tuning and migration/upgrade of the non-production database environments to Linux/Oracle 12c
Acts as subject matter expert for all database systems; provides level 2 and 3 technical support for complex database issues. Provides technical input to software developers and end users in the areas of database capabilities, performance and best practices.
Provides training and guidance to peers and Database Administrators
Recommends, creates, and follows all relevant policies and procedures to operate a controlled production environment
Leads and manages database administration activities as assigned by the Lead Database Administrator
Performs other duties as assigned

EDUCATION/QUALIFICATIONS
Bachelor’s degree in computer related studies with ten or more years of related experience with other DBMS software. Oracle DBA certification is preferred. Must possess advanced knowledge of Oracle DBA administration, Oracle clusters, database/application tuning, and recovery. Demonstrated knowledge and experience with Linux/UNIX operating systems, PL/SQL development and IT General Controls.

Ability to work in a fast-paced development environment and provide 24x7 support to ensure continuous market presence. Ability to read and comprehend complex instructions, write detailed reports, business correspondence, system requirement documents, procedures, and training manuals.

Ability to effectively present information and respond to questions from groups of managers and staff. Ability to define problems, collect data, establish facts and draw valid conclusions. Ability to interpret and deal with an extensive variety of technical instructions in mathematical or diagram form. Ability to identify, research and present technical solutions to management and stakeholders for action.