What are the responsibilities and job description for the Database Administrator position at ArnAmy, Inc.?
Database Administrator
Introduction:
This position is for a Senior Database Administrator (Database Administrator III) who will perform advanced database administration tasks for databases used by applications with complex data models, workflows, and reports. The successful candidate will work with Full-stack Java applications on HHSC’s cloud platform (Azure/AWS) within an Agile (Scrum) environment. The role involves 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.
Responsibilities:
- Creating and maintaining logical and physical data models
- 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, archiving, implementation of database policies
- Data replication and backup to secondary sites
- Creating technical and functional design documentation
Requirements:
| Years | Required/Preferred | Experience |
|---|---|---|
| 10 | Required | Database experience |
| 8 | Required | Experience with Oracle, Microsoft SQL - (or similar) |
| 8 | Required | Experience with Relational Database Administration |
| 8 | Required | Experience in database design, analysis, and performance tuning |
| 8 | Required | Experience in database structures, data analysis, 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 |
| 8 | Required | Experience with multi-tier system/application development |
| 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 into Azure SQL |
| 3 | Preferred | Experience in DevOps technology including CI/CD pipeline and build and deployment tools |
| 3 | Preferred | Experience in Java/J2EE Enterprise Development |
| 1 | Preferred | Azure certification is preferred |
| 1 | Preferred | DBA Associate certifications are preferred |
DISCLAIMER: Candidates for this position will be subject to a pre-employment security review to determine employment eligibility.
Salary : $60 - $65