Core Purpose:
- To provide a stable and secure production database environment which performs in alignment with predefined standards and is recoverable in case of hardware failure or disaster situations.
- To provide technical expertise to the client and their junior Database Administrators.
- Provide MySQL DBA services to a corporate client as a managed service
Qualifications and Experience:
- Relevant IT Qualification or experience
- 6+ years practical experience as MY SQL DBA.
- Experience with large, corporate, complex corporate databases a huge advantage.
- Best Practice in Database Administration; ITIL & Quality Management
- Principles; Microsoft Office Suite; Remedy System Operation. MySQL
- Database product licensing knowledge desirable.
- Checking Things; Examining Information; Exploring Possibilities;
- Following Procedures; Interacting with People; Managing Tasks; Meeting Timescales;
- Producing Output; Providing Insights; Team Working; Upholding Standards.
Duties and Responsibilities:
- Snr MY SQL DBA work with large, corporate, complex corporate databases
- Optimisation, Queries, Troubleshooting
- Compile and maintain the integrity of a Configuration Management Data Base in alignment with the client’s standards and using the prescribed systems.
- Utilise the Client’s Remedy system for request, incident and problem handling, rectifying and implementing preventative actions as and when required.
- Continuously monitor performance, analyse trends and tune database for optimum performance and record and build a known error database (KEDB) for Problem Handling (R&D).
- Build and maintain a network of support structures e.g. vendors, employees, user groups etc. for consultation purposes.
- Continuously stay abreast with the latest release versions and ensure approval of new versions through a user’s acceptance testing (UAT)
- Implement and comply with Quality assurance (QA) processes;
- Design and execute a release implementation plan; maintain the Definitive Software Library (DSL);
- Install, maintain and report license issues as and when they occur.
- Continuously monitor and report on space utilisation, execute trend analysis, alerts and escalation; monitor memory utilisation and Central Processing Unit (CPU) at all times.
- Devise monitoring methodology and processes, utilise the appropriate toolsets and report on the availability or uptime.
- Identify, propose and implement appropriate toolsets for an effective back-up strategy
- Ensure continuity of services and monitor the back-up strategy on a continuous basis. Validate a DR Plan for the data base(s) under the data centre management, consider the replication, snapshots or remote copy as applicable.
Personal Characteristics and abilities:
- Best Practice in Database Administration; ITIL & Quality Management
- Principles; Microsoft Office Suite; Remedy System Operation. MySQL
- Database product licensing knowledge desirable.
- Checking Things; Examining Information; Exploring Possibilities;
- Following Procedures; Interacting with People; Managing Tasks; Meeting Timescales;
- Producing Output; Providing Insights; Team Working; Upholding Standards.
Desired Skills:
- MYSQL DBA
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Diploma