• 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
