Senior MySQL Database Administrator
What you will be doing:
The DBA team is looking to add to their current talent a self-motivated, highly experienced Senior level MySQL Database Administrator. The DBA team is responsible for tasks such as project management, development of best practices and repeatable procedures for deploying databases, day-to-day operational activities including break/fix, capacity management, backup and recovery, database replication setup/management and ongoing database change reviews. The team also builds and maintains large-scale and very high transactional MySQL databases on Linux/Windows platform.
You will be-
- Managing large scale MySQL databases
- Managing high transactional MySQL databases servicing OLTP and DSS applications
What you bring:
- Solid understanding of MySQL internal architecture, demonstrated experience with MySQL database design, implementation, performance tuning, and capacity planning.
- Project management
- Experience with enterprise backup and recovery strategies
- Experience in database software management (patch and version management)
- Good scripting ability and good working knowledge of Shell Scripts, Perl or Python.
- Demonstrated experience with Open Source/Linux development and production environments
- Hands on experience with designing and implementing database replication strategies
- Experience in designing and automating repetitive processes
- 8 years plus working with MySQL technology.
- Possess creative ability, credibility, self-confidence and independence
- Good team player with strong analytical, communication and troubleshooting skills
- Pro-active, dedicated, committed and responsible
-MySQL Server full administration
-Using the MySQL interactive client
-User account maintenance
-Log file maintenance
-Database backup/copying
-Database Performance and Tuning
-Multiple server setups
-Software updates and upgrades
-File system security
-Server security
-Repair and maintenance
-Crash recovery
-Preventive maintenance
-Performance analysis
-Responsible to design the data structure at early phases of system design or for system changes.
-Install and configure MySQL Database servers on Linux and Windows environments and responsible to make sure database is available and protected for business continuity purposes
-Design, install, and configure MYSQL cluster and provide detailed documentation on the setup and configuration process for each.
-Develop database architecture components in collaboration with storage administrative teams.
-Assisted in designing, capacity planning, and security and accessibility functions of RDBMS databases.
-Implement procedures for database infrastructure, performance optimization and development of database applications.
-Provide technical assistance for establishment and tuning of database servers and migration processes.
-Formulate database DR failover, switchover strategies and plans for system backup services, recovery, and availability.
-Setup MySQL Replication administration on Master-Slave and Master-Master.
-Create complete system documentation relating to application architecture, assembling and technical platforms includes maintenance and troubleshooting
-Configure MySQL Replication as part of HA solution.
-Other related duties assigned as needed in PostgreSQL management, Oracle database technologies RAC, Data Guard, ASM, and Exadata appliance maintenance.
-Provides 24/7 support of production database environments.
Bachelor’s degree in computer science or engineering or the equivalent combination of education, training, or work experience.