Job Title: Sr. Oracle DBA
Location: Austin, TX, (Hybrid)- 3 days remote with 2 days (Mon & Tues) required to be onsite
Position Type: Contract
Interview Mode: MS Teams
Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50-mile radius). **Subject to change per the hiring team**
Job Description
The contractor role is for a Senior Database Administrator to perform advanced database administration tasks for applications with complex data models, workflows, and reporting requirements. This role involves several key responsibilities, particularly focusing on database optimization, migration, and integration with cloud services. The successful candidate will work with Full-stack Java applications on cloud platform (Azure/AWS) within an Agile (Scrum) environment for the SCOR application.
Database Management: Install, configure, upgrade, and maintain Oracle databases and infrastructure, ensuring high availability and performance.
Data Migration: Lead the migration of on-premises Oracle databases to Oracle DB@Azure Cloud, focusing on decoupling existing BLOB storage into data and Azure Blob Storage.
Job Management: Transition batch cron jobs to Oracle Database Jobs, enhancing workflow automation and efficiency.
Performance Optimization: Actively identify and resolve performance bottlenecks, implementing monitoring solutions to track database health, performance metrics, and manage storage capacity effectively.
Disaster Recovery: Manage backup, restore, recovery, and disaster recovery strategies to ensure database integrity and continuity.
GoldenGate Administration: Administer Oracle GoldenGate for efficient data replication.
Compliance and Standards: Develop and adhere to architectural standards, guidelines, policies, and procedures to ensure the integrity of the database environment.
II. CANDIDATE SKILLS AND QUALIFICATIONS
|
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
|
|
Years
|
Required/Preferred
|
Experience
|
|
10
|
Required
|
Experience in database administration
|
|
8
|
Required
|
Experience with Oracle, Microsoft SQL
|
|
8
|
Required
|
Experience in database design, analysis, and performance tuning
|
|
8
|
Required
|
Experience designing enterprise applications and/or services
|
|
8
|
Required
|
Experience creating technical and functional design documentation
|
|
8
|
Required
|
Experience within software development Life Cycle using Agile methodology – (Scrum, for example)
|
|
8
|
Required
|
Experience with multi-tier system/application development – (SOA, Microservices, 3-Tier applications, for example)
|
|
6
|
Preferred
|
Experience with Extract, transform, and load (ETL) data from various sources into Azure SQL
|
|
4
|
Preferred
|
Experience with large volume databases, high availability, and disaster recovery infrastructure
|
|
4
|
Preferred
|
Proficiency in converting and adapting database structures for cloud environments, specifically Azure
|
|
3
|
Preferred
|
Experience in configuring PowerBI environments and developing PowerBI reports
|
|
3
|
Preferred
|
Experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git 3 years of experience with Azure
|
|
2
|
Preferred
|
Experience with migrating On-Prem databases to Cloud (preferably Azure)
|
|
1
|
Preferred
|
Azure certification is preferred but not required
|
|
1
|
Preferred
|
DBA Associate certifications are preferred but not required
|