Database Administrator Specialist

» Database Administrator Specialist
Information Technology
in San Francisco
, CA
Reference: 19-03871
Description:
  • Manage and maintain all production and non-production databases across multiple complex MySQL/MariaDB DBMS implementations
  • Set standards and is responsible for design, creation, and monitoring of physical data storage, maintenance, access requests and security administration
  • Perform backup and recovery on database management systems, configure database parameters and prototype designs against logical data models, define data repository requirements, data dictionaries and warehousing requirements
  • Optimize database access and allocates or re-allocates database resources for optimum configuration, database performance and cost
  • Actively monitor existing databases to determine appropriate preventive actions to ensure high availability and optimal performance
  • Understand the business drivers for multiple business units and ensures the database platform is appropriate to the business use
  • Research new technology and develops business cases to support enteric-wide database solutions
  • Work independently within a team, provide general direction with occasional work product reviews
  • Accountable for quality, completeness, and on-time delivery of own work products
  • Minimum 4 years relevant experience
  • Bachelor’s degree or equivalent
  • Develop, manage and test database back-up and recovery plans for complex initiatives
  • Install new applications and customize existing applications to be fit for purpose
  • Recommend the appropriate database platform for the business use
  • Proactively monitor performance and manage parameters to provide fast query responses
  • Apply company policies and procedures to resolve complex issues
  • Estimate efforts for assigned projects anticipating interactions across more than one team
  • In-depth knowledge of database concepts, designs, and architectures within multiple technologies
Preferred Qualifications:
  • Experience with MySQLslap benchmark tool (3 years) to see MySQLd performance
  • Experience with MonYog monitoring (3 years)
  • Performance tuning experience with Percona Toolkit (5 years)
Basic Qualifications:
  • 5+ experience with MySQL
  • 3+ years experience with MariaDB
  • Experience with AWS (3 yrs) components such as EC2, S3, RDS, Security Groups, Route 53, VPC in cloud infrastructure benchmarking, profiling queries to see where the time being spent
  • 3 + years experience using Jenkins, GitHub and Teraform