Oracle DBA SME (Long Term)
Position Description:
- Administration of databases throughout the development and production lifecycles.
- Design and develop logical and physical database designs from customer requirements.
- Administration tasks for several Oracle databases.
- Provide advice and support to development resources.
- Provide guidance in the creation and modification of standards and procedures.
- Support the standing standards, policies and procedures of the customer team.
- Provide mentorship to group members and help develop and support mid and junior level staff.
- May be scheduled for after-hours on-call support and required to apply production packages during non-peak hours.
- Accept other duties as directed by management.
Qualifications
- 9+ years of experience in Oracle DBA
- Excellent verbal and written communication
- Experience preparing technical specifications
- Database and application performance tuning
- Experience with Oracle PL/SQL, stored procedures, and trigger development
- Expertise with troubleshooting and debugging
- Expertise with RMAN backup and recovery
- Expert with Real Application Clusters (RAC) administration and development
- Expert with Oracle Advanced Security
- Expert with Enterprise User Security
- Exposure to materialized views (design and implementation)
- Expert with Data Guard
- Expert with Advanced Compression
- Expert with Multitenant
- Expert with installation and configuration of Oracle 12c and all of its components
- Expert with Listener configuration
- Expert with Oracle ASM sizing and configuration
- Expert with Linux command line commands, BASH scripting and regular expressions
Additional Information
- Able to prepare technical presentations
- Able to prepare requirements documentation
- Database schema design and implementation
- Experience with Label Security
- Experience with Python
Education
Bachelor's degree from an accredited college in a related discipline, with eleven years of professional experience.
#J-18808-Ljbffr