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

• Contact seller
• Share
• See all ads from this advertiser