MYSQL DBA

Television is at an inflection point. New technologies and businesses are rapidly evolving and reshaping how we watch TV. We are EchoStar, a pioneer in internet delivered television and we are seeking a contract DBA in Superior, CO for a 6 month contract to hire,  to perform duties in the full cycle including development, testing and production support for MySQL and elastic search data stores. Databases will include a variety of types such as: large data warehouse used for tracking and reporting, high availability web server backend DBs, large replication environment, etc. 

Responsibilities:

• Maintain existing MySQL environments, including large replication environments for data mining and mid-sized High Availability environments in AWS and other data center environments

• Review and make recommendations for tuning existing environments

• Design and tune new tables and databases

• Create, update, and maintain scripts and data import/export processes for MySQL and SQLite databases

• Design, create and implement new database environments including HA and replication setups

• Maintain reports in Jaspersoft for AWS and build new Jaspersoft reports for scheduled execution and delivery

• Deliver ad hoc SQL-based reports combining data from multiple data sources

Basic Requirements:

• Bachelor’s degree in Computer Science or Mathematics or Engineering or equivalent experience

• 4 years of experience with Linux, including experience writing Linux scripts with bash, python, ruby, or similar scripting language

• 3 years of hands-on experience in database administration of MySQL and /or PostgreSQL

• 2 years of experience with setup, configuration, and maintenance, trouble-shooting MySQL and/or PostgreSQL replication environments

• 1 year of experience with performance tuning MySQL and/or PostgreSQL databases for a variety of environments and user requirements 

Preferred Qualifications:

• Experience with using and configuring NoSQL environments, e.g. MongoDB, Elasticsearch

• Experience with High Availability MySQL environments

• Experience with workflow engines and creating traceability of data through multiple systems

• Experience with Hadoop ecosystem administration and map-reduce jobs; Hive, Hbase, Impala, Sqoop, and Pig

• Experience with database reporting systems, especially Jaspersoft

• Experience working in a software development environment with software configuration management and agile development practices

Travel Percentage 

0 - No travel required