The Azure/MySQL Database Administrator II will be responsible for managing production and non-production databases, database maintenance, troubleshooting, and more.
Requirements
- Install/Configure/Setup/Administer and Maintain production and non-production environments
- Setup High-Availability and Disaster Recovery
- Plan and test high availability and disaster recovery
- Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets
- Resolve database integrity, performance, blocking, deadlocking, connectivity, and replication issues.
- Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.
- Perform and manage Database backup/recovery/restore and capacity monitoring
- Setup SQL agent jobs, elastic jobs and runbook automation
- Identify and setup alerts and logging in Azure
- Maintain databases – Statistics, Indexes, fragmentation
- Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)
- Implement operational automation using scripts.
- Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
- Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
- Deploy and configure SSIS packages and SSRS Reports. Troubleshoot issues with SSRS and SSIS.
- Design and create databases to support development initiatives
- Experience migrating on-prem environments to the Cloud (Azure)
- Knowledge of best practices in the areas of application design, performance, security, scalability and maintainability is also desired.
- Experience with extended features (partitioning, compression, CDC, encryption, auditing, etc)
- Identify future risks in the environment before they happen and work with leadership to get the work prioritized.
- MySQL, Mongo, and other DB technologies preferred
- Synapse, Databricks, and other data warehouse workflows preferred
- Support release/code deployment activities
- Provide 24x7 support as necessary
- Must work well as part of a team, get along with others, follow lawful directions and instructions the first time, follow all company policies and procedures, and ask questions to clarify instructions.
Benefits
