Senior MySQL Database Architect | Remote High-Load Systems Expert

Are you a database virtuoso who thrives on solving complex data challenges? We're in pursuit of a seasoned Senior MySQL Database Architect to revolutionize our high-load, multi-threaded systems. Your expertise will be instrumental in crafting resilient database solutions that power our real-time applications. From developing sophisticated stored procedures to optimizing performance for tables with millions of records, your database mastery will drive our technological advancement. Key Responsibilities: - Design and implement scalable database architectures for heavily loaded, multi-threaded real-time applications. - Craft and refine MySQL stored procedures, triggers, and functions that underpin business-critical operations. - Execute advanced database optimization for complex analytical reports operating on tables with millions of records. - Architect elegant database solutions that ensure seamless interaction between multiple database ecosystems. - Collaborate with development teams to implement and fine-tune data access layers utilizing ADO.NET and Entity Framework. - Contribute to full-stack development of sophisticated back-office and front-office systems built on .NET 8 and .NET Core platforms. - Establish and maintain robust database monitoring, performance tuning, and high-availability configurations. - Meticulously document database structures, optimization strategies, and integration methodologies. Required Skills and Qualifications: - 5+ years of hands-on experience with MySQL database development and administration. - Demonstrated proficiency in designing and optimizing high-load OLTP systems and transaction-intensive applications. - Advanced command of SQL, encompassing complex query construction, stored procedures, and function development. - Comprehensive knowledge of MySQL 8.0, InnoDB engine optimization, and performance tuning methodologies. - Practical experience implementing database sharding, replication, and clustering solutions. - In-depth understanding of database normalization principles, sophisticated indexing strategies, and query execution plan analysis. - Substantial experience with .NET development ecosystem, particularly ADO.NET and Entity Framework implementation. - Proficiency with Git version control and database change management practices. - Exceptional troubleshooting capabilities for resolving intricate database performance bottlenecks. - Hands-on experience with database backup orchestration, recovery protocols, and data migration procedures. Nice to Have: - Experience with specialized MySQL monitoring tools such as MySQL Enterprise Monitor or Percona Monitoring and Management. - Working knowledge of NoSQL database technologies and their strategic integration alongside relational database systems. - Familiarity with cloud-based database solutions (AWS RDS, Azure MySQL, GCP Cloud SQL). - Understanding of DevOps principles and experience implementing database CI/CD pipelines. - Prior work experience in fintech, e-commerce, or other high-transaction volume environments. - Active contributions to open-source projects or engagement with the MySQL community. Why Join Our Team: This fully remote position offers unparalleled flexibility to work from your preferred location while collaborating with our global team of technology innovators. You'll tackle fascinating database challenges that impact millions of users and have substantial influence over core architecture decisions. We provide competitive compensation, continuous professional development opportunities, and a collaborative culture where your database expertise will be not just appreciated, but celebrated. Are you ready to elevate your MySQL career to the next level?