Seeking an experienced MySQL DBA in San Diego who works around InnoDB deadlocks with ease, optimizes complex queries in the blink of an eye, and is ready to manage a server farm of many high-end production systems - with data footprint growing daily. Looking for: Creative, innovative, and open to introducing new technologies and concepts to create a highly-available and scalable environment for years to come.
Database Administrator II (DBA II)
At Avadyne Health, our innovative revenue cycle management software provides hospitals with the advanced communications and automation capabilities they need to effectively process insurance billings and optimize incoming cash flow. Visit us at www.avadynehealth.com to see why we are a leader in healthcare administration technology.
Roles & Responsibilities
The Database Administrator II (DBA II) supports our existing database instances and participates in their design, implementation, optimization, and ongoing management and maintenance. This role is vital to meeting Avadyne Health’s strict requirements for application scalability, availability, and performance. The DBA II needs a wide range of experience as they will be called upon to interact with a number of business units; but they must maintain an enterprise-wide view of data accessibility and integrity as a vital corporate asset. While the primary database technology is MySQL/MariaDB, candidates with experience with MSSQL, InterSystems Cache, or Informix will be given stronger consideration.
Provide support for MySQL/MariaDB/MSSQL Server/InterSystems Cache/Informix database instances across production and development environments across multiple office and data center locations
Performance tuning MySQL/MariaDB and MSSQL Server database instances
Communicating in a timely manner all issues, risks, concerns and status to management
Review/perform data manipulations (DML) and data definition (DDL) changes to support application requirements
Serve in an on-call rotation as an escalation contact for critical production issues and drive escalation/resolution of problems into the IT HelpDesk/Customer Support teams
Coordinate with developers and data team members to design, review, and optimize complex SQL queries
Develop and maintain database monitoring tools and automation systems
Participates in the capacity planning, budgeting, and implementation of new database instances to meet operational needs
Manage replication links between master-slave/master-master to maintain high availability
Monitor performance and tune database configurations/tables to optimize for a variety of workloads
Perform/maintain backup and restoration of MySQL/MariaDB and MSSQL Server instances
Provide data warehousing support to data teams
Maintain comprehensive documentation and standards on production database environments
Strong analytical and troubleshooting skills; ability to take ownership and exercise good judgment
Strong communicator and works independently, as well as in a team environment
Technical Skills (Required Skills)
Minimum of 4 years administering MySQL/MariaDB servers in a mission critical environment
Expert at troubleshooting MySQL/MariaDB related issues (lock contention, high load, slow queries, performance, etc) and identifying root causes
Proficiency with MySQL/MariaDB/MSSQL query structure, syntax, testing, and optimization
Experience working with MySQL/MariaDB replication and high-availability designs (load balancers, sharding, clustering)
Proficient with the CLI and a working understanding with CentOS/RHEL
Experience administering large InnoDB engine tables/high-quantity table databases
Technical Skills (Desired Skills)
BS or MS degree in Computer Science, Engineering, or related technical discipline
Ability to script using Bash/Perl/Python to automate database activities
Experience working with MySQL data on a Storage Area Network (SAN)
Experience with Nagios, Cacti, MONyog, Oracle Enterprise Monitor or other monitoring tools
Experience with CentOS/RHEL systems administration and various systems automation/centralized management tools
Experience Level: 4+ years
Compensation is based on your qualifications and includes our generous benefits program. Candidates for this position do not need to be local.
Visit us at www.avadynehealth.com to see why we are a leader in healthcare administration technology. We are headquartered in San Diego’s Mission Valley.
For consideration, please send your resume to us at
careers@avadynehealth.com with Subject: Database Administrator II – Your Name. Please list your specific salary requirements.
Please no agencies or 3rd parties. No sponsorships or relocations. We are an Equal Opportunity Employer.