MYSQL Developer

MySQL Developer Job SpecificationCompany: Hire SQLLocation: Remote (available nationwide in the U.S.)Type of Employment: Full-time (Contract or Regular)Working Hours: 9-5 PM or 10-6 PM EST

OverviewHire SQL is seeking a highly skilled and experienced MySQL Developer to join our remote development team. This role involves designing and implementing large-scale database solutions that are critical for the operational success of our clients. As a MySQL Developer, you will be responsible for ensuring the integrity, performance, and security of databases while working collaboratively with cross-functional teams to meet business and technical requirements.

Key ResponsibilitiesDesign, develop, and maintain highly scalable database solutions using MySQL.Optimize database systems for performance efficiency.Implement, maintain, and automate database backup and recovery systems.Ensure data security, privacy, and integrity.Monitor database performance, implement changes and apply new patches and versions when required.Work closely with developers to integrate databases with business applications.Provide technical support and guidance on database management and configuration.Assist in identifying, analyzing, and resolving complex database-related problems.Participate in peer reviews and contribute to the development standards.Document database schemas and models, including flowcharts and code commentary.

Technical Requirements

Core Skills & KnowledgeProfound knowledge of MySQL database management.Strong understanding of SQL programming and optimization techniques.Experience with database replication, backup systems, and disaster recovery.Proficiency in writing complex queries, stored procedures, functions, and triggers.Familiarity with the principles of database design and normalization.Knowledge of Linux environments and shell scripting.Ability to manage and deploy MySQL on cloud platforms such as AWS, Azure, or Google Cloud.Experience with version control tools such as Git.

Preferred ExperienceA minimum of 3 years of professional experience in MySQL database development.Bachelor’s degree in Computer Science, Information Technology, or related field; or equivalent work experience.Experience in working with NoSQL databases (MongoDB, Cassandra, etc.) is a plus.Familiarity with containerization and orchestration technologies (Docker, Kubernetes) is desirable.Previous experience in Agile development environments.Strong analytical and problem-solving skills.

Tools & TechnologiesMySQL and potential NoSQL databases like MongoDB, CassandraCloud services (AWS RDS, Azure Database for MySQL, Google Cloud SQL)Linux/UNIX platformsDevOps and CI/CD tools (Jenkins, CircleCI)Scripting languages (Bash, Python)Database management tools (phpMyAdmin, Sequel Pro)ORM frameworks (Hibernate, Entity Framework)

Work ConditionsRemote work setting; must have a dedicated, quiet workspace.Standard working hours with expectations to manage time effectively across various time zones.Should possess strong communication and collaboration skills, capable of working effectively in a dynamic team environment.

Key Skills

• Mysql
• SQL