Description
Job Duties/Responsibilities:- Perform database plan, design, creation, maintenance, backup/recovery, and performance tuning tasks daily to support 24X7 availability for mission critical applications.
- Participate in on call rotations, monitoring, and change requests to resolve incidents in the database environment.
- Setup and maintain documentation (standards, procedures, and disaster recovery).
- Provide input for staffing and support of programs and create accurate and detailed schedules.
- Successfully hand off project to Program Managers or Project Coordinators.
- Monitor the performance of the Oracle Database environment and implement solutions to increase performance.
- Design storage strategies around backup and recovery for complex database environments, physical structures, and specialized database applications.
- Monitors application performance and evaluates areas to improve efficiency.
- Perform root cause analysis with other support teams to prevent recurrence.
- Mentoring and assisting with on-the-job training for level 2 Oracle support.
Required:
- Broad knowledge in Unix, Shell Scripting, Oracle Enterprise Manager, and over all knowledge of Oracle concepts and processes.
- Proficiency with configuration of operating system settings applicable to Oracle running on distributed platforms (AIX, Windows, Linux).
- Demonstrated expertise in Oracle backup and disaster recovery procedures.
- Experience in systems analysis and application program development with a Back End relational database.
- Excellent analytical and problem solving skills.
- Bachelor's degree in computer science or equivalent training required.
- 7-8 years experience required.
- 7 years experience Oracle- Guru preferred.
- 4 years experience Database Monitor/Tune- Intermediate preferred.
- 4 years experience PL/SQL- Intermediate preferred.