Job Title: Oracle Database Administrator

Location: Austin, TX

Contract Duration: 1 Year

**REMOTE ROLE

Job Description:
The contractor role is for a Senior Database Administrator and will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. Assists the team in creating and maintaining logical and physical data models. The successful candidate will work with Full-stack Java applications on Client's cloud platform (Azure/AWS) within an Agile (Scrum) environment for the CFO application. The role will involve migrating data from Oracle applications to SQL schemas and loading it into collections.

Additionally, the candidate will optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics. The DBA III works on activities including but not limited to database tuning, indexing, customization, transformation, data migrations/conversions, installations, troubleshooting, upgrades, patching, user management, security of data at rest and in motion, disaster recovery, clustering for high availability and load balancing, data backup, purging and archiving, implementation of database policies, data replication and backup to secondary sites like disaster recovery environments, procedures for the integrity, availability, and confidentiality of the sensitive and business-critical databases. The role will involve working closely with the team to create and maintain logical and physical data models, with a primary focus on Oracle and Azure Microsoft SQL. This role will require converting Oracle Stored Procedures and Functions to Azure SQL.
Required Experience:
10 Required Database experience.
8 Required Experience with Oracle, Microsoft SQL - (or similar).
8 Required Experience with Relational Database Administration - (SQL Server or Oracle, for example).
8 Required Experience in database design, database structures, 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)

Required Preferred Experience:
8 Preferred Experience with large volume databases, high availability, and disaster recovery infrastructure.
6 Preferred Experience with Azure.
6 Preferred Ability to Extract, transform, and load (ETL) data from various sources into Azure SQL.
3 Preferred Experience in DevOps technology including CI/CD pipeline and build and deployment tools such as Git.
3 Preferred Experience in Java/J2EE Enterprise Development
1 Preferred Azure certification is preferred and not required.
1 Preferred DBA Associate certifications are preferred and not required.

About Us:

AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,850 staff across offices. AgreeYa works with 500 organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at Agreeya for more information.