Oracle DBA

Title: Oracle DBA

Location: Remote

Length: Long term

Restriction: W2 or C2C

Description:

*** Webcam interview long term project initial PO for 3 years with multiyear extensions ***Remote***

*** Need 3 verfiable references ***

This position will plan for, develop, test, and support database migrations to new databases within a Cloud environment.

Tasks and Responsibilities:

Research, analyze, present alternatives, including cost and performance analysis, and recommend cloud alternatives to the current databases.

Develop and document a plan to migrate to a new database, including conversion, data migration, and data reconciliation.

Design, develop, and document the structure for the new database, including database models and schemas, ensuring the integrity and security of the database.

Lead and execute the build and deployment of the new database.

Lead and execute the migration to the new database, including conversion and data reconciliation.

Administer the new database and provide plans and instructions for administration activities.

Conduct performance optimization to meet SLAs.

Analyze reported issues and provide recommendations for resolving.

Develop auditable data scrubs to correct data issues.

Provide a monthly status report.

Required Skills:

5+ years experience designing complex, normalized, relational application databases, including Oracle.

5+ years experience designing, developing, and deploying relational databases in a cloud environment, especially Azure and or AWS, ensuring the integrity and security of the database.

Experience migrating an on premises or cloud Oracle DB to any one cloud based solution such as Azure SQL, MySQL, Azure Oracle in VM, AWS Aurora, or AWS RDS.

Excellent written and verbal communication skills, with both technical and non technical audiences.

Experience analyzing requirements, researching alternatives, and making successful recommendations for database solutions.

Experience developing and executing successful migration plans from one database solution to another (e.g., Maria DB to MY SQL, Oracle to Azure SQL, not from one Oracle DB to another Oracle DB).

Demonstrated knowledge and successful execution of the principles and techniques of the full database design, modeling, development, testing, and documentation lifecycle.

Demonstrated knowledge and successful execution of the principles and techniques of systems implementation, including conversion, data reconciliation, and documentation.

Experience developing and documenting relational database models, based on functional specifications and conceptual object models.

Experience developing and documenting database schemas based on relational models.

Experience building and deploying relational databases based on database design, models, and schemas.

Experience administering relational databases and conducting performance optimization to meet SLAs.

Experience analyzing database configuration to research and resolve database and application issues.

Extensive experience with function and stored procedure packages using SQL.

Experience with database performance monitoring and tuning tools and techniques.

Experience developing data scrubs to correct data based on knowledge of the application.

Principles of information systems architecture for enterprise wide systems deployment such as multi tier, web based, distributed system architecture and development principles, and internet intranet application delivery mechanisms.

Experience coordinating with 3rd party vendors to resolve database software issues

Desired Skills:

Experience with software and tools used including, ERwin Data Modeler, Toad, Eclipse, JIRA, Clear Quest, and Subversion.