This job ad has been posted over 40 days ago...
0

applicants

Full-time MySQL Database Administrator

at MedAllies in New York | NY Jobs

Skills:
mysql PERL SQL
Location:
Fishkill, NY
MedAllies offers the expertise and resources to help physicians with the application and meaningful use of health information technology, providing solutions that facilitate the collection, secure transmission and reporting of critical clinical information. Visit our website at www.medallies.com.
MedAllies offers a generous benefits package, including medical and dental insurance, 401(k), life and disability insurance and paid time off.
The MySQL Database Administrator will be responsible for installing, configuring, administering and maintaining MySQL to support business needs and application development, utilizing strong technical, communications and prioritization skills. This individual will coordinate, review, analyze and approve the physical database requirements of MySQL databases and all associated objects; such as, but not limited to tables, views, and indexes. This person will ensure Database security, optimum performance of databases, backup & recovery and disaster recovery. This position is expected to establish and provide oversight for various databases to ensure optimum performance, reliability, recoverability and stability across production, test, development, and QA environments.
Main responsibilities:
Develop, implement, and maintain MySQL database structures in test, quality assurance, and production environments utilizing current standards and procedures.
Provide performance-related support and systems related support for MySQL data structures in production, test, development, and QA environments utilizing current tool sets.
Provide support on all the stages of database implementation and/or database related deployments
Installation of new MySQL instances, applying necessary patches and version upgrades.
Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
Communicate regularly with technical, applications, and operational staff to ensure the database integrity and security.
Troubleshoot MySQL performance and non-performance related issues either independently or in conjunction with other DBAs.
Maintain existing MySQL environments, including large replication environments and mid-sized High Availability environments.
Manage backup/recovery for MySQL instances and provide Disaster Recovery (DR) support.
Write database documentation, including data standards, procedures, and definitions for the data dictionary.
Provide 24 hour on-call support on a rotation basis.
Requirements:
Bachelor’s degree in Computer Science or related field or a BS in healthcare related field with additional education in computing technologies.
3 years experience in a MySQL DBA role.
1 year work experience with the design, creation and maintenance of database engine and its structures.
1 year work experience with the development and revision of database standards, procedures and strategies
Experience with MySQL Clustering configuration, setup and maintenance.
Experience with High Availability MySQL environments.
Experience using PERL for database maintenance and interaction.
Experience with MySQL in both Windows and Linux environments.
Expert in SQL language
Experience in one or more scripting languages; Python, Perl, Shell, Ruby
Java experience is a plus
Experience is agile development environments is plus
Experience in reporting and data mining technologies is a plus
Passionate about data and making sense out of data


Recent jobs at MedAllies
Full-time Network Security Administrator at MedAllies in New York | NY Jobs 15-02-2014
Full-time Systems Specialist at MedAllies in New York | NY Jobs 15-02-2014

« Go back to category
Is this technology job ad fake? Report it!   
Recommend to a friend
Published at 15-02-2014
Viewed: 155 times