**Title**:Database Architect (SQL) - **NEARSHORE!**
**Contract/Contract to Hire/Direct Hire**:6-month contract - expected to continuously extend every 6 months
**Location**:NEARSHORE!!! Mexico, Guatemala, Columbia
**Must Have Skills/ Requirements**:(Top 3-5 or more)
- Must be extremely strong in SQL
**Key Responsibilities**:
- Design and implement efficient database architectures that align with business requirements.
- Quickly adapt to understanding existing database schemas, including tables, relationships, stored procedures, and data types.
- Create comprehensive documentation of current database setups, including schema designs, data flows, process flows and architectural diagrams.
- Develop, optimize, and maintain stored procedures, triggers, and functions.
- Implement CI/CD pipelines to automate the deployment of SQL changes and ensure consistent database environments.
- Perform database modeling, data mapping, and data migration.
- Monitor database performance, troubleshoot issues, and implement necessary improvements.
- Ensure data integrity, security, and compliance with industry standards. Create documentation of database designs, procedures, and best practices for development and operational teams.
- Stay current with emerging database technologies and trends to inform strategic decisions.




- Provide guidance and mentorship to junior database team members.
**Qualifications**:
- Proven experience as a Database Architect or similar role, with a focus on relational databases.
- Strong proficiency in SQL and experience with stored procedure development.
- Familiarity with database management systems Microsoft SQL Server.
- Experience implementing CI/CD practices for database changes, including version control and automated testing.
- Knowledge of database design principles, data modeling, and normalization techniques.
- Experience with performance tuning and optimization of database queries.
- Understanding of database security best practices and compliance regulations.
- Understanding of hosting and monitoring best practices for DB in Azure cloud.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills.
- Background of Airlines/Hospitality industry is a plus.
- Ideally target someone in the airlines/transportation/logistics industry
- Bachelor’s degree in computer science, Information Technology, or a related field is a nice to have
**Interview Process**:Most likely two steps.
**Job Type**: Contract
Contract length: 12 months
Expected Start Date: 25/07/2025

📌 Database Architect (Guadalajara)
🏢 Apollo Technology Solutions
📍 Guadalajara