Systems Engineer III- Oracle DBA

Spectrum

Client Reference Code: 202831
JOB SUMMARY
Responsible for the design, implementation and maintenance of production databases in compliance with application specifications and company policies, standards and procedures. Manages and maintains all production and non-production databases.

MAJOR DUTIES AND RESPONSIBILITIES

Performs installations and configurations of grid infrastructure, databases, clients etc.
Designs and maintains access and security administration.
Designs, implements and maintains backup and recovery strategies on Database Management Systems.
Designs, installs, configures and maintains High Availability (RAC, RAC One Node, Data Guard etc.) Database solutions.
Install, configure, troubleshoot and monitor GoldenGate replication.
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.
Gathers business requirements and designs, implements multiple projects along with the production support.
Creates standard operational procedures and templates.
Performs research and provides plans to remediate complex business problems.
Participate in on call rotation.

REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Strong knowledge of Oracle 11g and 12c database architecture and its implementation
Strong understanding of best practices in maintaining medium to large scale Oracle database systems
Extensive experience with Oracle RAC and ASM
Strong knowledge of Instance, database and query tuning to improve the performance of the database/application
Strong knowledge of Linux operating systems and shell scripting
Hands on experience with Oracle OEM monitoring
Hands on experience with GoldenGate replication
Knowledge of MySQL database
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 judgment and initiative and to accomplish job duties
Ability to work independently
Ability to work with others to resolve problems, handle requests or situations

Education
Bachelor’s degree in Computer Science or related field, or equivalent experience

Related Work Experience
7+ years of experience working with Oracle and various database management systems in testing, implementation, maintenance and administration in a multiple platform environment

WORKING CONDITIONS
Office Environment
24×7 on-call support
Job Code : TWCISY350 Systems Engineer III Exempt

202831BR

To apply for this job please visit the following URL: http://itjobpro.com/22659 →