MySQL Full-stack Developer

Solvd Inc. is a premier software engineering company. We have 8 offices across the globe and over 800 international employees on staff. With over 12 years of experience, highly skilled teams around the world and deep industry knowledge, we help clients create software that improves their operations and opens new markets. We have built an impressive roster of digital-native enterprise clients including some of the biggest brands in retail and social media.

We are looking for a MySQL Full-Stack Lead to join our growing team.

Responsibilities:

Data Lake Design & Architecture:

• Design a scalable and efficient data lake architecture to store ONIX data in MySQL.
• Define the schema, tables, indexing strategies, partitioning, and relationships to optimize data storage and retrieval.

Data Mapping:

• Analyze ONIX data (XML) and map it to MySQL tables and fields.
• Ensure data integrity and consistency during the mapping process.

Data Ingestion Pipeline:

• Develop data ingestion pipelines for both on-demand and periodic updates (e.g., daily, hourly).
• Integrate support for additional data formats (CSV, Google Sheets, Excel).

Stored Procedures and Queries:

• Write efficient stored procedures, queries, and joins to process and format data.
• Optimize database performance for large datasets.

API Development:

• Design and build RESTful APIs to expose formatted data from MySQL.
• Ensure APIs are scalable, secure, and well-documented.

Consulting:

• Act as a consultant to the client, providing guidance on best practices for database design, data ingestion, and API development.
• Collaborate with the client’s team to understand requirements and deliver solutions.

Testing and Validation:

• Perform thorough testing of the data lake, ingestion pipelines, and APIs.
• Validate data accuracy, consistency, and performance.

Documentation:

• Create detailed documentation for the data lake architecture, ingestion pipelines, stored procedures, and APIs.
• Provide training and support to the client’s team.

Required Skills and Qualifications:

Technical Expertise:

• Proficiency in RDBMS (database design, stored procedures, query optimization).
• Experience with data ingestion pipelines (ETL/ELT) and tools (e.g., Apache NiFi, Talend, custom scripts).
• Strong knowledge of data mapping and data modeling.
• Expertise in API development (RESTful APIs, GraphQL).

Programming Skills:

• Proficiency in Python, Java, or Node.js for backend development.
• Experience with XML parsing and handling other data formats (CSV, Excel, Google Sheets).

Database Skills:

• Advanced knowledge of SQL (joins, subqueries, indexing, partitioning).
• Experience with database performance tuning and scalability.

Soft Skills:

• Strong consulting and client-facing skills.
• Excellent problem-solving and analytical abilities.
• Ability to work independently and deliver results in a remote environment.