HireFT
Browse JobsHow it worksPricingSuccess Stories
    Back to jobs
    LA

    LanceSoft Inc

    IT Services

    MySQL Database Administrator

    Westlake, United StatesOn-SiteContract3–5 yrs experiencePosted 2mo ago
    All LanceSoft Inc jobs

    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

    • 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

    All your information will be kept confidential according to EEO guidelines.

    Job details are sourced from the employer's original posting.

    Open job posting
    LA

    About the company

    LanceSoft Inc

    Established in 2000, A Minority Business Enterprise (MBE), LanceSoft Inc. is a pioneer in providing premium end-to-end Professional IT/Non-IT Contingent Workforce Solutions and IT Services to diverse clients across various domains. Core Service Offerings We offer a gamut of services across diverse domains, categories, skill sets with varying lengths of assignments, that include, but are not just limited to: - Temporary Staffing - Permanent Staffing - Payrolling - Recruitment Process Outsourcing (RPO) - Back-office Services - Application Design and Development - Website Design and Development - Program/Project Management Our Domain Strength With currently over 1000+ staff serving over 49 clients worldwide including “Fortune” companies, LanceSoft serves a wide array of industries including Healthcare/Pharma, Clinical/Medical Devices, Technology, Telecom, Retail and Distribution, Energy & Utilities, Banking, Finance, Insurance, Manufacturing, Automobile, Media, Transportation, and Government Sectors. Geographic Coverage LanceSoft is headquartered in Herndon, Virginia and has a network of branch offices across the US in Chicago (IL), Irving (TX), Basking Ridge (NJ), Atlanta (GA) and San Diego (CA). We also have an International footprint with two country offices in Canada (ON and BC) along with three delivery centers in India- Bangalore, Indore and Hyderabad to further help serve our clients better. We currently operate and recruit in 49 US states catering to diverse Contingent Workforce needs of our clients. Awards and Accolades Following are some of our awards and accolades in the US Contingent Workforce space: - Manpower “Premier Vendor” – 2014 - Kelly’s “Supplier Innovation Award” – 2012 - Kelly’s “Supplier of the Year” Award – 2012 and 2011 - Kelly’s “Service Excellence Award” – 2010 and 2009 - “Stewardship Recognition” from Johnson & Johnson’s (J&J) Kelly Work sense program Specialties IT/Non-IT Contingent Workforce Services, Creative Solutions, Temporary/Permanent Staffing, Recruitment Process Outsourcing, Payrolling, Application Design and Development, Back-office Services, Program/Project Management, Website Design and Development

    View all LanceSoft Inc jobs
    Industry
    IT Services
    Founded
    2000
    Open roles
    160

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.