What are the responsibilities and job description for the DevOps Database Administrator position at SII Group USA?
SII Group USA is seeking a DevOps Database Administrator to design, implement, and maintain database infrastructure in a cloud environment. You are expected to monitor, capacity planning, automation, and ensure the availability, performance, backup, recovery, and security of AWS RDS databases and collaborate closely with the DevOps team to integrate database solutions with CI / CD pipelines
Key Responsibilities
- Design and implement database infrastructure in a public cloud environment, including performance monitoring, capacity planning, and automation of database-related processes.
- Develop and implement migration strategies for AWS RDS databases, including MySQL and Amazon Aurora.
- Plan, script, execute, and support the upgrade and / or migration of data to new schema structures, database software, or hardware.
- Develop scripts to support integration with monitoring tools, automate backups, and report usage metrics.
- Tune MySQL and Amazon Aurora database and query performance.
- Ensure 24 / 7 availability, performance, backup, recovery, and security of AWS RDS databases.
- Implement cloud security best practices, including identity and access management, encryption, and continuous monitoring.
- Troubleshoot, isolate, and resolve database issues in a cloud environment.
- Develop scripts, jobs, stored procedures, and functions to replicate data to backup databases and purge old data from log tables.
- Test and deploy patches and security updates.
- Support the development, deployment, and maintenance of customer reporting solutions.
- Provide technical assistance and support to customers.
- Independently troubleshoot system issues and establish call bridges with appropriate personnel to restore databases to proper operating condition, documenting all efforts from start to closure.
Required Skills & Experience
Preferred Qualifications
