MySQL Database Administrator
lancesoftAustin (TX)
About the role
Company Description:
In business since 2000, LanceSoft is a nationally certified Minority Business Enterprise (MBE) that has established itself as a pioneer in providing highly scalable, cost-effective workforce solutions to a diverse set of customers across various industries in the United States.
Job Description:
Plan, design, deploy database systems, including base definition, structure, documentation, requirements gathering, preparing operational guidelines, and securing data.
Develop data models and perform planning of architecture, functions, modules, recovery, standards and implementation Work with internal and external customers to develop new value-added programs and data solutions with existing data warehouse structure Act as liaison with customers on all new MySQL based projects Validate designed applications Analyze and determine information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities Research and evaluate alternatives and recommend solutions for business issues Engineer and create ad-hoc reports utilizing various data sources Maintain current knowledge of relevant technologies Participate in all major application/database enhancements and fine tune the systems for optimal performance Responsibilities:
- Install, configure, and maintain MySQL multi-level Master-Slave replication
- Install, configure, and maintain MYSQL Multi-master Group and Galera replication
- Optimize and tune MySQL database performance
- Continually improve monitoring, perform database capacity and usage planning
- Write and maintain scripts to automate routine DB tasks
- Troubleshoot database-related application performance issues
- Ensure security and data integrity of all MySQL instances
- Perform routine, periodic and proactive DB maintenance
- Provide on-call support of MySQL databases
- Implement tools to automate database operation and monitoring
- Implement database Backup and Monitoring solutions
- Test restore(master), recovery(point-in-time), replication
- Test cluster/multi-master failover and disaster recovery
- Implement, document and maintain database roles and security
- Research and evaluate alternatives and recommend solutions for business issues
- Create capacity planning reports based on historical data trends and projected data growth
- Maintain current knowledge of relevant technologies
Qualifications:
- 3-5+ years of experience in administering MySQL database, replication, tuning, backup and recovery
- Experience with MySQL Group replication and Galera replication is a plus
- Must be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoring
- Strong Expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production MySQL database servers
- Strong Knowledge with database architecture design, including data partitioning and application partitioning is a plus
- Solid Team player with a positive attitude and team spirit – can work alone and with others
- Ability to mentor team members.
- Communicates well (oral and written) with customers and management
- Degree in Computer Science or equivalent
Qualifications:
- 3-5+ years of experience in administering MySQL database, replication, tuning, backup and recovery
- Must be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoring
- Degree in Computer Science or equivalent
Additional Information: All your information will be kept confidential according to EEO guidelines.
Summary
Type: Contract
Function: Other
Experience level: Mid-Senior Level
Industry: Telecommunications
Before you apply
Applying takes about a minute. These four things decide how fast it moves after that.
Your profile is current
It's what we read first. Occupations, seniority and locations matter more than a long history.
Two examples you can talk through
Not a portfolio — just two pieces of work where you can explain the decisions and what you'd change.
A number in mind
What you're on now and what would make you move. We negotiate better when we know both.
Your notice period
Employers plan around it, and it's the question that stalls offers most often.
Once you apply, someone reads it and calls you before anything reaches the employer — usually within two working days.
More like this