Senior Oracle DBA/Golden Gate – Contract

Senior Oracle DBA/Golden Gate (Bi-Directional Set Up)

Location: St. Louis, MO or Charlotte, NC

Work Style: On-site from Day 1

Duration: Long Term Contract

Must Haves:

• We require candidates who are local to Charlotte, NC or St Louis, MO.
• Candidate should have 10+ years of strong Oracle DBA experience with Golden Gate (Bi-Directional) set up.

Responsibilities:

• Perform installations and configurations of grid infrastructure, databases, clients etc.
• Design and maintain access and security administration.
• Design, implement and maintain backup and recovery strategies on Database Management Systems.
• Support multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Design, install, configure and maintain High Availability (RAC, RAC One Node, Data Guard etc.) Database solutions.
• Expertise in setup using OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues.
• Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues.
• Performs capacity planning of Oracle server environment and provides recommendations to management to sustain business growth.
• Design, implement, maintain Disaster Recovery (DR) methodologies and creates documentation.
• Gather business requirements and design, implement multiple projects along with the production support.
• Creates standard operational procedures and templates.
• Act as mentor for Database Administrators and Associate Database Administrators.
• Perform research and provide plans to remediate complex business problems.
• Assist the development teams to improve database design and procedures on PL/SQL best practices etc.

Requirements & Experience:

• 10 + Years of experience.
• Experienced DBA with extensive knowledge with PL/SQL programming and database architecture.
• The ability to read, analyze, and enhance PL/SQL scripts delivered to their team by the development team.
• Able to utilize all Oracle DB tools and functionality to create/modify PL/SQL scripts for performance on large DBs and datasets.
• Thrives on problem solving and is able to apply those skills to think outside the box to engineer new solutions as well as improve existing solutions.
• Good Experience with Oracle RMAN and Golden Gate (Bi-directional set up) is mandatory.
• A good communicator to interface with APO production DB support teams.
• The ability to write detailed documentation along with MOPs for all projects assigned to them.
• Strong knowledge of database architecture and its implementation.
• Strong understanding of best practices in maintaining medium to large scale Oracle database systems.
• Strong knowledge of PL/SQL programming language.
• Strong understanding of Change Management procedures.
• Strong knowledge of Instance, database and query tuning to improve the performance of the database/application.
• Strong understanding of SAN technologies related to SQL server disk layouts.
• Strong knowledge of Windows/Linux/Solaris operating systems and shell scripting.
• Ability to communicate orally and in writing in a clear and straightforward manner.
• Ability to communicate with all levels of management and company personnel.
• Ability to handle multiple projects and tasks.
• Ability to make decisions and solve problems while working under pressure.
• Ability to prioritize and organize effectively.
• Ability to show judgement and initiative and to accomplish job duties.
• Ability to use personal computer and software applications (i.e. word processing, spreadsheet, etc.).
• Ability to work independently.
• Ability to effectively consult with department managers and leaders.

Salt is acting as an Employment Business in relation to this vacancy.