About This Role
Coordinating and advising on new projects for database server installations, setup, and database patching is the core of this role. The SQL Administrator ensures alignment with existing standards, policies, and strategies while designing database infrastructure with monitoring, backup, restoration, and high availability disaster recovery designs.
Responsibilities
- Coordinate and advise on new projects for database server installations and setup
- Ensure alignment with existing standards, policies, and strategies
- Design database infrastructure with monitoring, backup, restoration, and high availability disaster recovery designs
- Detail, test, validate, and implement database infrastructure definitions for new projects and landscapes
- Plan and define standards for infrastructure and architecture design for databases
- Support in database capacity planning and implement measures to accommodate growth
- Develop, test, and document new installations and migration approaches for new database technologies
- Document new database technologies installation processes
- Ensure the setup of database backup and monitoring configuration for all databases being managed and provide reports
- Install other service-related software (e.g., database client software)
- Manage database projects implementation including scheduling of technical installations, documentation, and handover until go live
- Perform initial new technology cluster setup or high availability and disaster recovery setup and testing for all database variants and upcoming database technologies
- Receive vulnerability reports on the database servers and define action plans for timely resolution of issues
- Ensure proper transition to run operations by creating documentation and updating relevant details in tools
- Provide advice and guidance on the selection, sizing, procurement, and usage of servers and related utility software
- Regularly review, update, and maintain service catalogue for database services
- Review database performance and raise issues, advising operations team for immediate resolution
- Review SLAs, OLAs, and contracts and revise when necessary
- Set up regular database service level reporting process and continuously monitor compliance with the SLA
- Define and periodically review and improve the database operation services scope for the provision and management of database systems
- Develop process improvements and automation for database provisioning, configuration changes, patch management, and other database tasks
Requirements
- Primary skills: MySQL administration
- Primary skills: SQL administration
