Oracle DBA SME position

Oracle DBA SME (Long Term)

Position

Description:

• Administration of databases throughout the development and production life cycles.
• 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.

• 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

• Able to prepare technical presentations
• Able to prepare requirements documentation
• Database schema design and implementation
• Experience with Label Security
• Experience with Python

Bachelor's degree from an accredited college in a related discipline, with eleven years of professional experience.