Senior Software Engineer MS SQL Developer

Scientific Games:

Scientific Games is the global leader in lottery games sports betting and technology and the partner of choice for government lotteries. From cutting-edge backend systems to exciting entertainment experiences and trailblazing retail and digital solutions we elevate play every day. We push game designs to the next level and are pioneers in data analytics and iLottery. Built on a foundation of trusted partnerships Scientific Games combines relentless innovation legendary performance and unwavering security to responsibly propel the global lottery industry ever forward.

Position Summary

Job Description: SQL Developer


Experience: 3 to 7 years
Location: Bangalore
Type: Full-time

About the Role
Looking for a strong SQL developer who can also work across the Microsoft stack. 80% of work will be deep in MS SQL Server writing tuning debugging complex queries. The other 20% maintain/enhance legacy ASP/ apps and build new features in C# JavaScript.
Key Responsibilities
SQL Server Development - Primary - 80%
Write optimize and debug complex T-SQL stored procedures functions views triggers
Tune slow queries using Execution Plans Indexes DMVs. Handle tables with 10M rows
Design database tables relationships and constraints for new modules
Data migration cleansing and bulk operations using SSIS packages
Troubleshoot deadlocks blocking timeouts and performance issues in production

Application Development - Secondary - 20%
Maintain and enhance existing Classic ASP / / VB6 web applications
Develop new features in C# .NET Framework/.NET Core with Framework
Create/modify SSRS reports datasets parameters subscriptions drill-down reports
Build UI screens using HTML CSS JavaScript jQuery. Handle AJAX calls to backend
Fix bugs across the stack from SQL proc to JS front-end

Support & Collaboration
Work with BAs to translate business requirements into SQL queries reports
Deploy DB objects and code via SQL scripts TFS/Azure DevOps/Git
Support UAT provide data extracts and resolve production data issues
Document stored procs table schemas and report logic

Must-Have Skills
Strong SQL Knowledge
3 years hands-on with MS SQL Server 2014
Advanced T-SQL: Joins CTEs window functions temp tables dynamic SQL error handling
Performance: Can read execution plans create covering indexes avoid cursors reduce scans
SSIS/SSRS: Built/modified packages and paginated reports. Know SQL Agent jobs
DB Objects: Comfortable with all CRUD operations schema design constraints transactions

Moderate Application Skills
Classic ASP / VB / : Can read legacy code fix bugs add small features. No need to architect
C# .NET: Write console apps APIs or web forms. Understand OOP basic LINQ
JavaScript/jQuery: DOM manipulation AJAX calls form validations JSON handling
HTML/CSS: Create tables forms basic responsive layouts
Tools: Visual Studio SSMS IIS basics TFS/Git for version control

Qualifications

Education

Bachelors degree in related field.

Years of Related Experience

Years of experience 5 to 8 years

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job the employee is regularly required to sit stand walk bend use hands operate a computer and have specific vision abilities to include close and distance vision and ability to adjust focus working with computer and business equipment.

Work Conditions

Scientific Games LLC and its affiliates (collectively SG) are engaged in highly regulated gaming and lottery businesses. As a result certain SG employees may among other things be required to obtain a gaming or other license(s) undergo background investigations or security checks or meet certain standards dictated by law regulation or order to ensure SG complies with its regulatory and contractual commitments as a condition to hiring and continuing to employ its employees SG requires all of its employees to meet those requirements that are necessary to fulfill their individual roles. As a prerequisite to employment with SG (to the extent permitted by law) you shall be asked to consent to SG conducting a due diligence/background investigation on you.

This job description should not be interpreted as all-inclusive; it is intended to identify major responsibilities and requirements of the job. The employee in this position may be requested to perform other job-related tasks and responsibilities than those stated above.

SG is an Equal Opportunity Employer and does not discriminate against applicants due to race color sex age national origin religion sexual orientation gender identity status as a veteran and basis of disability or any other federal state or local protected class. If youd like more information about your equal employment opportunity rights as an applicant under the law please click here for EEOC Poster.