SQL DBA
hc1.com, Inc. - Indianapolis, IN

This job posting is no longer available on hc1.com, Inc.. Find similar jobs: SQL Database Administrator jobs - com jobs

DESCRIPTION

This individual will be responsible for all production databases, including product line databases, resolving fundamental design issues, data modeling and design, backup and restore strategy and execution, upgrades, performance monitoring/tuning, testing and change deployment. Must be comfortable working in an evolving architectural environment where changing business requirements demand support from the underlying technology. The ability to think quickly and solve complex technical problems is essential to this role. The SQL DBA will report to the VP of Engineering.If you are a SQL DBA and want to make your mark in SaaS unified communications this is your opportunity! This is a unique position for a mid-senior level DBA to make a significant impact on the entire industry.

DUTIES

Identify and recommend tools and services for managing database infrastructureHardware sizing requirements for database loads based on efficient use of multi-core systemsUpdate and tune MySQL instances in a high volume environmentProviding database administration support to include the following: configurationmaintenancesecuritycapacity planningupgradestroubleshootingissue resolutionbackup/recovery proceduresdatabase performance tuning Conducting performance tuning on databases.Ensuring database availability, performance and continuance.Designing, implementing, and monitoring database backup and recovery processes.Implementing performance optimization techniques of databases on Linux and Windows platforms.Providing periodic reviews of database performance and monitoring levels.Designing, testing, and documenting upgrades of current database environments.Reviewing and analyzing system and database error logs.Participating in software upgrades, revisions, fixes and patches as mandated by the vendor.Participating in reviews of the technical documents for completeness, correctness, and accuracy.

QUALIFICATIONS

Bachelor's degree in Computer Science or a related field and 3+ years of professional experience. An equivalent combination of education and experience may be considered.5 years + RDBMS experience working in a high volume production environment.At least 2+ years as a specific MYSQL DBA in a LAMP environment working with Centos/ Fedora/ RedHat.Network and I/O performance tuning.Solid experience with LVM(Logical Volume Management) and snapshots, Perl, Nagios, Cacti, Subversion. MySQL replication (Master-Master, Master-Slave, cluster replication) and sharding. Solid knowledge of physical and logical database designSolid knowledge in schema design principals with demonstrated aptitude to apply best practices for scalable designs and influence developersMySQL 5.x (InnoDB and MyISAM engines)Proficiency in a scripting language (perl preferred)Oracle and or SQL installation and configuration experience.Experience with SQl Server 2005/2008, SQL queries, concepts, and structures.Possess excellent written and oral communication as well as presentation skills.Must have good interpersonal and consulting type skills to work successfully with clients on a daily basis.MySQL cluster setup and tuning, MySQL query performance tuning, and MySQL system/network performance tuning (for example, disk I/O, etc).Deep knowledge of SQL.Extensive experience in high transaction rate environment tuning and designing databasesData modeling expertise (Erwin or similar).Experience in designing and writing stored procedures in an N-tier development environment.Experience with Database replication, migration, backup and recovery using MySQl.MySQL Security - access privilege and user account management.Experience with MySQL monitoring and performance tuning toolsAbout hc1.com: hc1.com, the world's leading healthcare cloud company, is experiencing triple digit annual percentage growth in the vast, rapidly growing healthcare market. Led by veteran technology entrepreneur and "IBJ 40 under 40" award recipient Brad Bostic, the company was a 2012 Mira Award finalist, and won the 2011 Indiana Companies to Watch Award. More recently the company won the 2013 MIRA Award and the Red Herring Top 100 North America Award.hc1.com is the only cloud-based healthcare CRM solution on the planet designed from the ground up to meet the specific needs of healthcare entities. hc1.com's CRM and healthcare business intelligence play an integral role for over 500 healthcare organizations across the country, including Alere, St. Vincent Health, NeoGenomics, Know Error, Bostwick Laboratories, Sterling Reference Labs, Northwest Radiology, and South Bend Medical Foundation. Identify and recommend tools and services for managing database infrastructureHardware sizing requirements for database loads based on efficient use of multi-core systemsUpdate and tune MySQL instances in a high volume environmentProviding database administration support to include the following: configurationmaintenancesecuritycapacity planningupgradestroubleshootingissue resolutionbackup/recovery proceduresdatabase performance tuning Conducting performance tuning on databases.Ensuring database availability, performance and continuance.Designing, implementing, and monitoring database backup and recovery processes.Implementing performance optimization techniques of databases on Linux and Windows platforms.Providing periodic reviews of database performance and monitoring levels.Designing, testing, and documenting upgrades of current database environments.Reviewing and analyzing system and database error logs.Participating in software upgrades, revisions, fixes and patches as mandated by the vendor.Participating in reviews of the technical documents for completeness, correctness, and accuracy.

hc1.com, Inc. - 13 months ago - save job - block
About this company
New 2-minute video on our company culture: https://vimeo.com/78639852 hc1.com, the world's leading healthcare cloud company, is...