MYSQL DBA

Alpha Technologies Inc USA; Superior (CO); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology company in Colorado is seeking a contract DBA to manage MySQL and PostgreSQL environments. Responsibilities include maintaining existing databases, tuning environments, and implementing new setups. The ideal candidate has a Bachelor's degree in Computer Science/MATHEMATICS and at least 4 years of Linux experience along with a strong background in database administration. This contract position offers the potential for conversion to a permanent role.

Qualifications

• 4 years of experience with Linux, including scripting.
• 3 years of hands-on experience in MySQL and/or PostgreSQL.
• 1 year of performance tuning for MySQL/PostgreSQL databases.

Responsibilities

• Maintain existing MySQL environments, including replication.
• Review and recommend tuning for existing environments.
• Design, create, and implement new database environments.

Skills

MySQL Administration

Linux Scripting

Database Performance Tuning

Data Reporting

Education

Bachelor’s degree in Computer Science or Mathematics or Engineering

Tools

MySQL

PostgreSQL

Jaspersoft

AWS

MongoDB

Elasticsearch

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

Additional Information

Send me your resumes at vince@alphait. us