Database Administrator II
1 Howard Street Burlington, VT 05401
Design, model and build effective, high-performing relational and document-oriented database systems.
Develop strategies and implement solutions for data loading, archiving, backup, recovery and deployment of databases.
Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
Provide direction and oversight to engineering, systems engineering, and business team members regarding data and database system strategies, standards and roadmaps.
Plan and execute proof of concept of new database technologies.
Develop and implement data retention policies.
Clean and maintain the database by archiving, removing and deleting stale data.
Install and configure RDBMS and associated software.
Support software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.
Collaborate with software engineering and other departments to design effective solutions and streamline data related processes.
Prepare paperwork and attend departmental and project related meetings.
Excellent communication skills, both oral and written.
Experience supporting large, highly available, distributed, enterprise production database systems.
Ability to quantify and qualify merits of database technologies.
Linux scripting skills with shell scripts is required.
Multi-datacenter deployment experience preferred.
Skilled in advising developers on upgrades, data consistency and availability.
Experience in tuning data structures, indexing and queries.
Experience in replication implementation and best practice consulting.
Experience with MySQL server tuning for both InnoDB and MyISAM
Highly skilled in query development and tuning
Knowledge of MySQL maintenance best practices
Experience with database scaling and high-availability designs
Experience with low-level database performance tuning on virtualized platforms and bare metal
Experience with clustered or multi-master deployments preferred