Database Administrator 3

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

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.

• Direct programmers/analysts to implement database changes
• Review, test, and correct programs
• Analyze impact of database changes on systems and costs
• Perform performance tuning to improve database efficiency
• Plan, develop, maintain, and monitor integrated database systems
• Ensure database design aligns with application requirements
• Maintain data integrity and minimize redundancy
• Perform data modeling (logical & physical) and prototyping
• Monitor database performance and recommend improvements
• Manage database loading, reorganization, backup, and recovery
• Define data standards and maintain data dictionary
• Implement database security and disaster recovery procedures
• Create and manage test database environments
• Assist in database software installation and selection
• Support benchmarking and performance testing
• Provide user support for data access and issues

• 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.

CANDIDATE SKILLS AND QUALIFICATIONS

• 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

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.