Senior Database Developer

About us:

VisionX works with world-leading brands, Fortune 1000 as their innovation partner, providing product strategy and custom application development leveraging agile methodologies, technology accelerators, and by creating Intellectual Property.

VisionX has been listed in the Top 10 Most Innovative Companies of 2020 by Fast Company – ranked alongside the likes of Microsoft & Snap Inc.

We develop cutting-edge software products integrating computer vision, 3D modeling, AR, VR, decision sciences, and IoT addressing a wide variety of use cases across different industries.

Your role

We are seeking an experienced and skilled Senior MS SQL Server Database Developer with a focus on reporting within the Customer Service or Contact Center space. In this role, you will specialize in writing complex reporting queries, conducting data analysis, and optimizing database performance to support our customer service SaaS product. The ideal candidate will have deep expertise in MS SQL Server and experience working with customer service or contact center data, terminology, and metrics.

Responsibilities

1. Design and implement complex SQL queries and stored procedures to support reporting requirements and data analysis tasks specific to customer service and contact center operations.
2. Collaborate with stakeholders to understand data and reporting needs within the context of customer service and translate them into efficient database queries.
3. Analyze and optimize existing database queries to improve performance and support key metrics relevant to customer service, such as response times, call volumes, and customer satisfaction scores.
4. Develop and maintain data models and database schemas that are tailored to the needs of customer service reporting.
5. Monitor database performance and usage patterns, and implement tuning measures such as indexing and partitioning to support efficient reporting.
6. Create and maintain ETL processes to extract, transform, and load data from various sources relevant to customer service operations into the SQL Server databases.
7. Ensure data accuracy, integrity, and security through proper database design, data validation, and backup strategies, with a focus on customer service data.
8. Troubleshoot and resolve database issues, including data corruption, connection problems, and performance bottlenecks, particularly as they relate to customer service data.
9. Stay updated on the latest developments in MS SQL Server and customer service technologies, including new features and best practices, and incorporate them into your work.
10. Provide technical guidance and mentorship to backend developers and analysts, sharing knowledge and best practices, particularly in the area of customer service reporting.

What you need

1. Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).
2. Proven experience as an MS SQL Server Developer, with a strong portfolio showcasing your work on complex reporting queries and data analysis within the customer service or contact center space.
3. Expertise in writing and optimizing complex T-SQL queries, stored procedures, and functions, particularly as they relate to customer service reporting.
4. In-depth knowledge of database design principles, data modeling, and normalization, with an emphasis on customer service data structures.
5. Experience with performance tuning techniques, including indexing, partitioning, and query optimization for customer service data.
6. Familiarity with ETL processes and tools, with the ability to create and maintain data pipelines for customer service reporting.
7. Strong analytical and problem-solving skills, with the ability to interpret customer service data and provide actionable insights.
8. Understanding of data security and compliance best practices, with experience implementing data validation and protection measures for customer service data.
9. Excellent communication and collaboration skills, with the ability to work effectively in a team environment and interact with stakeholders in the customer service domain.
10. Detail-oriented mindset with a focus on delivering high-quality solutions within established timelines.
11. Certification in Microsoft SQL Server or relevant technologies is a plus.

Why choose us

Our global network of industry experts and mentors helps shape your growth and future. We believe in delivering client value through our work. We build products that are not good or great, but outstanding.

You deliver We will make your stay and journey with us worthwhile.

We are an equal opportunity employer, and we value diversity. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, disability status, or any other legally protected status.