DATABASE ADMINISTRATOR(MySQL)
Responsibilities Key duties :
- Establish the needs of users and monitoring use access and security.
- Monitor performance and managing parameters to provide fast query responses to front-end users.
- Map out the conceptual design for a planned database in outline.
- Consider both back-end organization of data and front-end accessibility for end-users.
- Create the messaging for each new product launch and manage the cross-functional implementation of each launch plan.
- Refine the logical design so that it can be translated into a specific data model.
- Further refining the physical design to meet system storage requirements.
- Install and testing new versions of the database management systems (DBMS).
- Maintain data standards, including adherence to the Data Protection Act.
- Write database documentation including data standards.
- Control access permissions and privileges.
- Develop, manage and test back-up and recovery plans.
- Ensure that storage, archiving, back-up and recovery procedures are functioning correctly.
- Capacity planning.
- Work closely with IT project managers, database programmers and multimedia programmers.
- Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
- Commission and install new applications and customising existing applications in order to make them fit for purpose.
- Strong technical knowledge of VMware technology. Should be able to set up, migrate as well as troubleshoot performance issues on VMware platform.
- Performs on-call duties as required.
- Assists in policing our usage policies (spam, porn, warez, bots) and works with customers and internal organizations to find a resolution to the issues.
Strategic duties :
- To keep current with new and developing technologies, suggesting ideas where the company are able to support new services.
- Work within SLA’s and drive to get these down, providing world class services to clients.
Job specific :
- Experience in designing, implementing, and managing database systems for mission critical, high-traffic OLTP and OLAP systems.
- In-depth knowledge of the MySQL platform, including high-availability design/operation, performance tuning, capacity planning, automated backup and recovery.
- Expertise with MySQL replication, RedHat clustering, disaster recovery, and geographic load distribution of database services.
- Experience with task automation scripting using Python, Perl, Shell, or other UNIX based languages.
- Systems administration skills required to troubleshoot database-related problems at the O/S level, on Linux/UNIX/Solaris, and commercially available server and storage systems.
- Ability to work with and support a team of development professionals, operations team members, and design engineers.
- Excel at documenting database architectures, and processes. Follow ITIL change management best practices for system modifications.
- Conceptual knowledge of service-oriented architectures.
- Strong understanding of applied statistics and analytics algorithms.
- Foundation knowledge and experience with baseline performance and load testing for computing system capacity planning methodology.
Person specific :
- Ability to identify areas of improvements and a determination to make a difference.
- Keen focus on the customer experience.
- Flexibility, as this role involves shift work. ‘Flexibility’, by the way, refers to your schedule – if you’ve got physical flexibility to go with it, all the power to you.
- Ability to work independently on projects.
- Excellent organizational and follow-up skills.
- Excellent written and verbal communication.
- Excellent and effective customer service.
- Ability to properly articulate ideas, suggestions, and provide positive/constructive feedback.
- Ability to manage multiple activities and projects.
- Ability to work independently, without direct supervision.
- Ability to anticipate, identify, diagnose, and solve critical problems.
- Willingness to work with team members or group and other departments to achieve common goals.
- Sense of fun and play and enjoy a fast paced dynamic environment.
- Demonstrates an appetite to perform, succeed and grow in ways most people never dream of.
- The working week will be Monday to Friday core business hours, potential requirement to work one day each weekend. Flexibility required.
Education/Experience :
- Bachelor's Degree in Computer Science, or related field.
- Experience ( System Administrator ) – For (6) + years.
- Software Application -- Expert knowledge and use of Linux, MySQL and VMware Platforms.
- 4 - 6 years in the field of database administration with experience in the design, planning, implementation and monitoring of database systems in a heterogeneous, multi-vendor Linux networked environment Experience with MySQL and Unix, a must.
- Excellent interpersonal, written and oral communication skills.
Apply Now
iiwhosting.com