Database Administrator - Oracle
JOB SUMMARY
Responsible for the 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
Actively and consistently supports all efforts to simplify and enhance the customer experience
Performs installations and configurations of grid infrastructure, databases, clients etc.
- Maintains standards and design of physical data storage, maintenance, access and security administration
- Creates/maintains backup and recovery strategies on Database Management Systems
- Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data
- Installs, configures and maintains High Availability (RAC, RAC One Node, Data Guard etc.) server solutions
- Troubleshoots alerts (alert log, Jobs, Disk Group, Tablespace etc.) and performance issues. Performs database performance tuning tasks
- Utilizes OEM as a monitoring and diagnostics tool and identifies/resolves the performance issues
- Implements multiple projects along with the Production Support
REQUIRED QUALIFICATIONS
Required Skills/Abilities and Knowledge
Ability to read, write, speak and understand English
- Knowledge of Database Architecture and its implementation
- Knowledge of PL/SQL programming language
- Knowledge of Instance, database and query tuning to improve the performance of the database/application
- Understanding of Capacity Planning of Oracle Server environment to sustain business growth
- Understanding of Disaster Recovery (DR) methodologies
- Understanding of SAN technologies related to Oracle disk layouts
- Knowledge of Windows/Linux/Solaris operating systems and shell scripting
- Understanding of Change Management procedures
- 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 use personal computer and software applications (i.e. word processing, spreadsheet, etc.)
- Ability to work independently
- Ability to work with others to resolve problems, handle requests or situations
- Ability to effectively consult with department managers and leaders
Required Education
BA/BS in Information Technology, Computer Science, or related field or equivalent work experience
Required Related Work Experience and Number of Years
3-6 years of Experience working with Oracle database management systems in testing, implementation, maintenance and administration in a multiple platform environment
WORKING CONDITIONS
Office environment
24x7 on-call support
IDB380 317416-3 317416BR