SUMMARY - The Database Administrator (DBA) will be responsible for improving, maintaining and supporting the production databases for our web-based products. We provide a highly available service to students across the globe, so the DBA must perform all duties with discipline and awareness of our SLAs to our customers. This individual plays a key role in ensuring the database environment is designed and managed to meet business and IT demands for availability, performance and manageability.
SCOPE AND IMPACT OF JOB - Successfully meets day to day responsibilities, duties, accountabilities and performance results of our database administration to ensure 24/7 database availability. Provide significant input to the strategic direction, daily operations, best practices, security policies, and implementation procedures relating to our large scale data infrastructure
DATABASE ADMINISTRATOR PRIMARY RESPONSIBILITIES
Support an existing production MySQL master-slave environment. Monitor, respond and correct operational issues associated to database health and utilization of system resources.
Manage the correct operation of back-up and restoration procedures.
Manage database software upgrade process, including data migration.
Establish themselves as the primary subject matter expert on DB design issues
Improve database performance by analyzing performance characteristics and introducing better approaches
Work with Systems and Development teams to design, implement, maintain, scale and tune open source SQL and No-SQL database systems
Supports the installation, administration and configuring of MySQL and NoSQL Databases in a high availability, multiple database server environment.
Implements scalable solutions that will support the companies continued growth
Manages DB as it relates to system maintenance, monitoring, security, troubleshooting, disaster recovery and other procedures to maximize availability and uptime
Manage the movement of production data to development and QA instances.
REQUIRED ATTRIBUTES AND SKILLS
7+ years DBA experience
Extensive MySQL experience and familiarity with NoSQL technologies (MongoDB)
Extensive experience with large scale environments.
Extensive experience with highly available critical services.
Experience with MySQL replication
Solid understanding and experience in disaster recovery planning and implementation
Experience in data profiling, meta data analysis, data modeling, and relational schema design
Expert level skill in scripting languages such as KSH, BASH, Perl, Python as needed for large-scale data movement operations
Ability to create and maintain automation frameworks to eliminate repetitive daily monitoring/maintenance operations
Experienced and Skilled in working with business users, technology development teams, and external vendors
Strong attention to detail and accuracy.
Excellent writing and communication skills. Must have the ability to effectively present information before our management, and employees of organization.
Ability to write and submit routine reports, project updates, and correspondence in a timely, responsive and accurate account.
Actively participate in building and maintaining productive working relationships with coworkers. Actively share information as required with coworkers and team members.