Database Administrator (Oracle)
Responsibilities
- Provide on-site database and system support
- Monitor, collect statistical information, and provide reporting on capacity and system performance
- Based on statistics, make recommendations to maintain and improve capacity and system performance
- Monitor the system, and act upon system and application automated alerts
- Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
- Plan and perform software installation, configuration, upgrade and patching
- Plan and perform database configuration, maintenance, upgrade and patching
- Perform and manage system and database backups
- Perform manual switch to redundant system / database components, in case of system failure
- Understanding of Help Desk tools and trouble ticket tracking processes
- Understanding of support agreements and their implied service levels
Must Have Skills/Requirements
- 10+ years of experience as a DBA
- Experience in OCAC, AWR, ADDM, ASH , SQLT, Golden Gate, Exadata (should have experience with majority of these) – 8+ years of hands on experience (in combination of all technologies listed)
- Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution – 8+ years of hands on experience
- Strong knowledge of SQL, PL/SQL, Python (with all 3 however PL/SQL experience is most important, Python experience doesn’t have to be as strong) – 8+ years of hands on experience in combination
- Proven ability to write excellent technical documentation (part interpretation and analysis of the AWR report) – 8+ years of hands on experience
- ORACLE OCP Certification
Nice to Have Skills
- Jira, Confluence & ServiceNow
- RAC, RMAN certifications/trainings
- Banking experience (understand processes and terminology, importance of applications)
Soft Skills
- Strong communication skills – written & verbal (will be speaking with various teams)
- Need someone willing to learn
- Quick to pick up on new things
Education
- Bachelor’s degree in a technical field such as computer science, computer engineering or related field required