The MySQL DBA will manage MySQL environments, perform database administration tasks, tune performance, and create reports in Jaspersoft. The role involves collaborating on high availability environments and data import/export processes.
Company Description
HUGHES NETWORK
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 InformationSend me your resumes at vince@alphait. us
Pozdrawiam / With best regards,
Alpha Technologies Inc (USA)
Vince Taylor
Sr Technical Recruitment Specialist
Top Skills
Elasticsearch
Hadoop
Jaspersoft
Linux
MongoDB
MySQL
NoSQL
Postgres
Python
Ruby
Similar Jobs
Productivity • Sales • Software
Responsible for maintaining the Denver office environment, managing vendor relationships, solving facilities issues, and enhancing employee experience through various office projects and activities.
Top Skills:
Email Tools (OutlookGoogle Calendar)Microsoft Office (ExcelPowerpoint)Word
Artificial Intelligence • Computer Vision • Machine Learning • Natural Language Processing • Defense • Generative AI
The Senior Machine Learning Engineer will enhance AI capabilities for defense applications, collaborate on ML models, optimize data processing, and ensure security in high-stakes environments.
Top Skills:
DockerDocker ComposeKubernetesLlmsNumpyOllamaPandasPythonScikit LearnTransformers
Digital Media • Gaming • Information Technology • Software • Sports • Esports • Big Data Analytics
As an Operations Associate, you'll manage customer lottery ticket orders and ensure operational efficiency in a fulfillment center.
Top Skills:
Excel
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
