MYSQL DBA
Company Description
HUGHES NETWORK
Job Description
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
Additional Information
Send me your resumes at vince@alphait. us
Pozdrawiam / With best regards,
Alpha Technologies Inc (USA)
Vince Taylor
Sr Technical Recruitment Specialist