Job Description:
***Crop to Crop resumes are accepted
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 HHSC s 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:
- Experience in database administration
- Experience with Oracle, Microsoft SQL
- Experience in database design, analysis, and performance tuning
- Experience designing enterprise applications and/or services
- Experience creating technical and functional design documentation
- Experience within software development Life Cycle using Agile methodology (Scrum, for example)
- Experience with multi-tier system/application development (SOA, Microservices, 3-Tier applications, for example)
Desired Skills:
- Experience with Extract, transform, and load (ETL) data from various sources into Azure SQL
- Experience with large volume databases, high availability, and disaster recovery infrastructure
- Proficiency in converting and adapting database structures for cloud environments, specifically Azure
- Experience in configuring PowerBI environments and developing PowerBI reports
- Experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git 3 years of experience with Azure
- Experience with migrating On-Prem databases to Cloud (preferably Azure)
- Azure certification is preferred but not required
- DBA Associate certifications are preferred but not required