At iOCO, we are at the forefront of technology and innovation. As a key player in the digital landscape, we empower businesses through advanced technology solutions and a diverse team of experts. We are committed to fostering a collaborative and inclusive environment where talent thrives.
We are seeking an experienced SQL Server Consultant to join our dynamic team. The ideal candidate will have extensive hands-on experience in a multi-tiered and multi-client environment, with in-depth knowledge of SQL Server databases and cloud-native database services. You will work closely with clients to understand their business requirements, provide tailored solutions, and optimize database performance across various platforms.
What you’ll do:
- Provide expert guidance on SQL Server database design, development, and optimization, with a focus on performance tuning and best practices.
- Work with cloud-native database services, including Azure SQL Database and MIS, to deploy, maintain, and optimize cloud-based solutions.
- Manage and implement advanced SQL Server services such as AlwaysOn, database mirroring, SSIS, SSRS, clustering, and replication.
- Design and implement database architectures, with strong adherence to best practices in data modeling, normalization, and denormalization.
- Troubleshoot complex SQL Server issues, focusing on query optimization, index tuning, and overall server configuration for optimal performance.
- Collaborate closely with clients to understand their technical and business needs, ensuring effective communication of technical solutions to both technical and non-technical stakeholders.
- Perform regular database health checks, audits, and optimizations to ensure high availability and peak performance of SQL Server environments.
- Provide recommendations for infrastructure improvements and assist with strategic database planning.
Your expertise:
- Minimum of 5 years of hands-on experience in a multi-tiered and multi-client environment.
- Proficient with SQL Server 2016, 2019+, with deep expertise in database design, optimization, and performance tuning.
- Experience with cloud-native database services such as Azure SQL Database or MIS.
- Strong understanding of advanced SQL Server services and features, including AlwaysOn, SSIS, SSRS, database mirroring, replication, and clustering.
- Proven experience with data modeling, schema design, and adhering to database best practices.
- Expertise in query optimization, index tuning, and SQL Server configuration for performance enhancement.
- Excellent communication skills with the ability to translate complex technical information to both technical and non-technical audiences.
Personal attributes:
- Proven ability to work creatively and analytically in a problem-solving environment
- Confidence to express ideas as part of a team
- Excellent communication (written, oral) and interpersonal skills.
- A Self-Starter capable of working under pressure
- Curious and engaged in Continuous Learning and Professional Development
Why work for us?
Want to work for an organization that solves complex real-world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies. 
You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains. 
Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft. 
By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.