Job Description

You will need to have hands-on experience with production databases. You should be able to:
• Create databases with efficient structures
• Write optimized queries, views and triggers for integration with other applications
• Maintain high standards of data quality and integrity
• Understand issues related to network performance and security
You should also have a background in:
• Reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS) and SAP Crystal Reports
• SQL database systems
• Big data technologies like Hadoop and Spark
• Amazon AWS Cloud Services
• The Software Development Life Cycle (SDLC), specifically Scrum and Agile methodology
Tasks & Responsibilities:
• Develop and support production MySQL databases.
• Develop and support MySQL database replication and clustering
• Monitor and optimize MySQL database performance and capacity planning
• Troubleshoot database issues, maintain database systems availability
• Plan and execute for database scalability
• Develop and optimize database design for new applications Preferred Qualifications:
• 10+ years of experience in MySQL Administration and PL/SQL programming
• Demonstrated experience with MySQL database design, implementation, performance tuning, and capacity planning. Managing large scale database system is a PLUS
• Demonstrated experience with Open Source/Linux development and production environments
• Solid knowledge in PL/SQL programming and its optimization
• Proficient at using the MySQL admin tools for issue inspection
• Experienced with performance analysis (IO, CPU, etc) and optimization (indexes, partitions, schema redesign, etc)
• Solid knowledge in server monitoring for detection of emerging issues (performance, locking, bad usage)
• Possessing a solid understanding of Linux - shell scripting but also ability to inspect hardware performance and load indicators
• Good understanding of master-master replication