MySQL DBA

Responsibilities: Work with operations team to enhance the systems performance; Troubleshoot and resolve production database issues; Profile server resource usage, optimize and tweak as necessary; Ensure performance, security, and availability of databases; Implement the security policy and audit requirements Coordinating with database programmers and IT project managers; Protecting database from threats and unauthorized access; Recommending changes and improvements for database protection; Work closely with the backup admin to ensure healthy backups are available at all times; Execute periodic restoration testing and submit related reports Review the database architecture Monitoring systems performance and identifying problems that may arise proactively Requirements: Bachelors degree in computer science or related IT field preferred; Experience with data modeling in relational databases and writing complex SQL queries; Familiarity with monitoring tools and how to apply to DB environment; ETL / data migration experience with large data sets; Unix shell scripting and the ability to automate routine tasks; Understanding of MySQLs underlying storage engines, such as InnoDB; Knowledge of standards and best practices in MySQL; Proficient in writing and optimizing SQL statements; Experience with replication configuration in MySQL; Experience with routers and database clusters Must be ready to support environments remotely while on-call; Ability to plan resource requirements from high level specifications; Experience with ETL tools and data warehouse concepts is a plus Experience with MySQL Backup tools and Monitoring tools; Experience with Reporting/Visualization tools #J-18808-Ljbffr