Job Specifications
About the Company
Senior MS SQL Developer with strong hands on expertise in advanced SQL programming, data modeling, and performance optimization.
About the Role
The ideal candidate should have extensive experience working with large data volumes, developing complex stored procedures functions, and tuning SQL queries for high performance database environments.
Responsibilities
Database Design
Design and maintain conceptual, logical, and physical data models for enterprise systems.
Create normalized and denormalized schemas, ensuring scalability, data integrity, and performance.
Collaborate with architects and application teams to support data architecture decisions.
SQL Programming Development
Develop, enhance, and maintain stored procedures, functions, triggers, views, packages, and complex SQL scripts.
Implement business logic in the database layer with efficient, reusable, and well-structured SQL code.
Assist in code reviews and SQL development best practices.
Large Data Volume Processing
Build and optimize ETL/ELT logic to handle large-scale datasets efficiently.
Write and tune queries to support high-volume transactional and analytical systems.
Ensure data accuracy, quality, and consistency across processes.
Advanced Querying Optimization
Write highly optimized, complex SQL queries for reporting, analytics, and application workloads.
Analyze execution plans and tune long-running queries using indexing strategies, statistics updates, and schema refinements.
Identify performance bottlenecks and implement proactive database optimizations.
Performance Tuning Maintenance
Monitor and optimize database performance, including indexing, partitioning, query tuning, and resource utilization.
Identify and resolve locking, blocking, deadlocks, and long-running processes.
Recommend improvements to database design, configurations, and operational processes.
Qualifications
Advanced proficiency in MS SQL Server development.
Strong experience with data modeling (ER design, schema design).
Required Skills
Advanced proficiency in MS SQL Server development.
Strong experience with data modeling (ER design, schema design).
Preferred Skills
None specified.
Pay range and compensation package
Not specified.
Equal Opportunity Statement
We are committed to diversity and inclusivity.
About the Company
Envision Technology Solutions (ETS) is a leading staffing and recruitment firm specializing in providing top-tier talent and workforce solutions across industries. With a proven track record, we connect exceptional candidates with exceptional opportunities, helping businesses thrive and individuals achieve their career goals.
ETS has a team of highly skilled recruiters and industry experts with in-depth knowledge of different sectors. Leveraging our expertise, we identify, attract, and select the best candidates for clie...
Know more