Title: Senior Oracle Database Administrator
Duration: 5 Months (3 Years Ext)
Location: Austin, Texas 78751. The working position is Hybrid - On Site and Telework. Position will be 3 days remote with 2 days (Mon& Tues) required to be onsite at the location listed above.
Summary:
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 the client 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.
Required Skills:
- 10 years of Required Experience in Database Administration
- 8 years of Required Experience with Oracle, Microsoft SQL
- 8 years of Required Experience in database design, analysis, and performance tuning
- 8 years of Required Experience designing enterprise applications and/or services
- 8 years of Required Experience creating technical and functional design documentation
- 8 years of Required Experience within software development Life Cycle using Agile methodology (Scrum, for example)
- 8 years of Required Experience with multi-tier system/application development (SOA, Microservices, 3-Tier applications, for example)
Preferred Skills:
- 6 years of Preferred Experience with Extract, transform, and load (ETL) data from various sources into Azure SQL
- 4 years of Preferred Experience with large volume databases, high availability, and disaster recovery infrastructure
- 4 years of Preferred Proficiency in converting and adapting database structures for cloud environments, specifically Azure
- 3 years of Preferred Experience in configuring PowerBI environments and developing PowerBI reports
- 3 years of Preferred Experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git 3 years of experience with Azure
- 2 years of Preferred Experience with migrating On-Prem databases to Cloud (preferably Azure)
- 1 year of Preferred Azure certification is preferred but not required
- 1 year of Preferred DBA Associate certifications are preferred but not required