Senior Database Engineer
Must be local to Burlington, MA (For now this is a mostly remote contract role with a Syrinx Biotech Partner)
U.S. Citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
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