Oracle Database Administrator

Job Description: Designs implements and maintains all functions of database system including access methods and time device allocations performance monitoring and tuning validation checks organization security documentation and statistical methodology. Analyzes current business practices processes and procedures and identifies future business opportunities for leveraging data storage and retrieval system capabilities. Monitors overall standards and procedures and assists in the integration of various systems through the database system. Consults with users determines applications development requirements and provides recommendations on database establishment and utilization.

Minimum Required Skills: Bachelors in computer science or equivalent engineering including certifications (11G/12C OCP) Minimum 7 years experience with Oracle DB administration (installation upgrades migration and configuring on Linux platform capacity planning backup & recovery including load balancing and clustering) in a production environment. Expert in administration troubleshooting and performance tuning (cert an added advantage) Strong monitoring experience with Oracle enterprise manager. (Other relevant tools). Knowledge of various backup restore and recovery models Ability to be flexible and adapt to any given situation Ability to perform multiple tasks concurrently Excellent customer service attitude communication skills (written and verbal) and interpersonal skills Excellent analytical and problem-solving skills Ability to make timely and sound decisions Ability to work independently and in a team-based environment Ability to work under pressure and in high-stress situations

Additional Notes: Plan coordinate and administer matters related to Oracle databases including definition structure documentation upgrades long-range requirements operational guidelines and protection. Maintain and support Real Application Cluster (RAC) 11g/12c and Active Data Guard and streams other methods of Replication (Goldengate). Support production databases in a high-quality and dynamic environment and assist developers with database change activities. Responsible for solving SQL performance-related issues and optimizing poorly performing queries and stored procedures. (Working knowledge of Jobs DDL DML PL/SQL stored procedures triggers views constraints and cursors required) Implement and maintain database integrity & security TDE (create and maintain users and roles assign privileges). Translate logical to the physical design develop comprehensive DB architectures implementation and upgrade plans and assist in the definition of database standards policies and procedures. Attends product specification meetings with project team members to determine the scope and limitations of various projects. Ensure high levels of performance availability sustainability and security. Responsible for 24x7 production operations (incident break/fix change service requests management) and On-Call pager rotation. *Intake call notes* Interview will be a 2 round process with managers from the team. Willing to hire in any US location as long as candidate can work hours set my HM.