MySQL Database Administrator

Company DescriptionIn 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 DescriptionPlan, 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 replicationInstall, configure, and maintain MYSQL Multi-master Group and Galera replicationOptimize and tune MySQL database performanceContinually improve monitoring, perform database capacity and usage planningWrite and maintain scripts to automate routine DB tasksTroubleshoot database-related application performance issuesEnsure security and data integrity of all MySQL instancesPerform routine, periodic and proactive DB maintenanceProvide on-call support of MySQL databasesImplement tools to automate database operation and monitoringImplement database Backup and Monitoring solutionsTest restore(master), recovery(point-in-time), replicationTest cluster/multi-master failover and disaster recoveryImplement, document and maintain database roles and securityResearch and evaluate alternatives and recommend solutions for business issuesCreate capacity planning reports based on historical data trends and projected data growthMaintain current knowledge of relevant technologiesQualifications:3-5+ years of experience in administering MySQL database , replication, tuning, backup and recoveryExperience with MySQL Group replication and Galera replication is a plusMust be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoringStrong Expertise in building, maintaining, supporting, troubleshooting, tuning, and monitoring production MySQL database serversStrong Knowledge with database architecture design, including data partitioning and application partitioning is a plusSolid Team player with a positive attitude and team spirit – can work alone and with othersAbility to mentor team members.Communicates well (oral and written) with customers and managementDegree in Computer Science or equivalentQualifications3-5+ years of experience in administering MySQL database , replication, tuning, backup and recoveryMust be highly proficient in backup, recovery, replication, performance tuning, and proactive monitoringDegree in Computer Science or equivalentAdditional InformationAll your information will be kept confidential according to EEO guidelines. SummaryType: ContractFunction: OtherExperience level: Mid-Senior LevelIndustry: Telecommunications