Careers

    Current Openings | My Account - TeamWork Online | Mobile |

    Technical Services: IT Database Management/Services
    Database Engineer - Twinspires.com (Lexington, KY)

    The Database Engineer is a part of the TwinSpires database team and works to ensure the uptime and reliability of the database environment for TwinSpires.com and related business units, and assists development teams to support SQL development. Responsibilities include, but are not limited to assisting in the proper design and implementation of databases, queries, stored procedures and reporting as may be needed to accomplish company goals.  Monitor and maintain database performance on an ongoing basis.  Administer database server access and ensure the proper adherence to Corporate Security Policies.

    Job Essential Functions

    • Build, manage and maintain MySQL 5.6 and 5.7 server environments
    • Familiarity with AWS RDS MySQL and Amazon Aurora
    • Effectively build and execute backup/restoration plans and strategies
    • Manage and maintain user/group assignments within MySQL server
    • Maintain and improve Master to Slave and Master - Master Replication
    • Familiarity with replication modes, threads and constraints placed on development and released under various replication schemes
    • Report on MySQL server performance and operations
    • Troubleshoot and repair problems
    • Collaborate with developers to understand database needs and implement into the environment and design complex features, data structures and database code
    • Write and maintain ETL (extract-transform-load) scripts
    • Performance tuning proficiency, experience analyzing query planner output to inform indexing strategy
    • Efficiently designs, debugs and manages stored MySQL procedures and functions
    • Debugs nested procedures and functions as well as anonymous code
    • Perform deployment-related DB tasks through staging and production environments
    • Comfortable with fast paced work environment.
    • Other duties as assigned by Management

    Education and / or Experience

    • Bachelor Degree in Information Science, Engineering, or other closely related discipline; or
    • Equivalent experience coupled with MySQL certifications
    • Experience working in Linux and Microsoft operating system environments

    Apply for this position

    Click here to see all of our employment opportunities.


     

    Sports Jobs Board Powered by TeamWorkOnline.com

    Technical problems? Contact the TeamWorkOnline webmaster / FAQ

    TeamWorkOnline Privacy Policy (Opens Popup Window)