Oracle DBA SME
- Country: United States
- Region: Arizona
Job Title: Oracle DBA SME
Location: Phoenix, AZ (Hybrid)
Hire Type: Contract
Job Description:
Experience ? 10+ Years
Job description
Skills Requirements:
· 10+ years of experience in Oracle DBA
· Excellent verbal and written communication.
· Experience preparing technical specifications.
· Oracle 12c DBA experience in a Unix/Linux environment
· 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 Data Masking.
· Exposure to Materialized views (design and implementing)
· 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
The SME will
· Primarily be database subject matter expert for multiple applications,
manage the complete database lifecycle.
· Primary responsibility is the successful migration of large datasets from
PostgreSQL to an Oracle database system.
· Develop, implement, manage, support and maintain database technology and
infrastructure, adhering to the best practices, architectural guidelines and
policies.
· Work closely with other Infrastructure engineering, product development,
business operations, and technical operations teams to ensure delivery of
database services.
· Assess the existing databases and gauge the complexity and estimate the
efforts required for a migration to the new Oracle database.
· Prepare data migration strategies and designs for project.
· Develop solutions to enhance database reliability.
· Good understanding of Oracle database fundamentals and Architecture.
· Good understanding of Oracle database security management.
· Knowledge on PostgreSQL, as this role is for moving the work from PostgreSQL
to Oracle.
· Knowledge on migration tools.
· Proven work experience as a Oracle Database SME.
· Familiarity with Oracle database design, coding, and documentation.
· Knowledge of database backup procedures, recovery systems, and SQL.
· Knowledge of programming languages and API.
· Excellent communication and problem-solving skills.
· Ability to visualize algorithmic structures.
Reference : Oracle DBA SME jobs