6958 - Oracle Developer / Migration Specialist (Candidate must be reside in Sacramento, CA to be considered)

  • Sacramento, CA
  • Posted 14 days ago | Updated 1 day ago

Overview

Hybrid
$40+
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 36 Month(s)
No Travel Required

Skills

AWS Aurora
Aurora
Azure SQL
ERwin
Eclipse
JIRA
Maria DB
MySQL
Oracle
RDS
SQL
Subversion
database design
database software
dba
information systems
optimization
relational database
relational databases
relational models
research
researching
schemas
system architecture
systems architecture
tuning

Job Details

Staff Tech is looking for an Enterprise Projects database administrator (dba) to provide database support for projects. This position will plan for, develop, test, and support database migrations to new databases within a Cloud environment.

  • 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.
  • 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
  • Experience with software and tools used by the end client, including: ERwin Data Modeler, Toad, Eclipse, JIRA, Clear Quest, and Subversion.