Overview
We are seeking a skilled SQL Developer for our client to design, develop, and optimize database solutions using MS SQL in support of their Java-based product build-out. The role involves developing complex queries, ensuring data integrity, and performing performance tuning. The successful candidate will collaborate with cross-functional teams to deliver secure, efficient, and scalable database solutions.
Responsibilities
- Database Development
- Design, develop, and optimize databases using MS SQL.
- Create and maintain schemas, indexes, views, stored procedures, and functions.
- Ensure data integrity, security, and compliance with industry standards.
- Collaborate with engineering teams to align database solutions with product requirements.
- Maintain data models, ER diagrams, and design documentation.
- Query Development
- Build complex queries for reporting, analytics, and visualization.
- Optimize queries for performance and scalability.
- Partner with reporting teams to deliver BI and reporting solutions.
- Performance Tuning
- Monitor and analyze database performance.
- Implement indexing, caching, and optimization techniques.
- Troubleshoot and resolve performance bottlenecks.
- Collaboration & Code Quality
- Work closely with engineering, product, QA, and DevOps teams.
- Participate in code reviews and enforce coding standards.
- Support smooth deployment and maintenance of database solutions.
- Database Maintenance & Security
- Implement backup and recovery strategies.
- Ensure compliance with security and regulatory standards.
- Troubleshooting & Documentation
- Diagnose and resolve database issues (performance, data inconsistencies, system errors).
- Maintain root cause analysis and troubleshooting documentation.
- Produce technical documentation for system architecture and database design.
Requirements
Required Education & Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, or a related field.
- Master’s degree (preferred) in Data Science, Information Systems, or related discipline.
Required Skills
Mandatory :
- Strong expertise in MS SQL and PL/SQL.
- Knowledge of performance tuning and query optimization.
- Solid understanding of database design principles and data modeling.
Nice to Have :
- Programming knowledge in Java or Python.
- Familiarity with DevOps practices and CI / CD pipelines.
- Exposure to cloud-based databases (Azure SQL, AWS RDS).
Soft Skills :
- Strong problem-solving and analytical skills.
- Excellent collaboration and communication abilities.
- Ability to work in fast-paced, cross-functional teams.
Benefits
What We Offer
- A Competitive Salary Range: AED 12,000 - AED 28,000 per month, commensurate with experience and qualifications.
- Career Development: Structured training programs, mentorship, and clear pathways for career advancement.
- Professional Growth: Support in obtaining advanced industry certifications.
- Work-Life Balance: Comprehensive benefits package in line with UAE labor laws.