Advanced Database Administrator

Description Designation: Advanced Software Engineer. Experience: 8 to 14 years. Location: Bangalore/ Chennai Technical Skills & Expertise • SQL Development – ability to write and troubleshoot T SQL Code and design (stored procs, functions, tables, views, triggers, indexes, constraints). • Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention. • Working knowledge of backups, restores, recovery models, database shrink operations, DBCC commands. • Working knowledge of indexes, index management, and integrity checks, configuration, patching. • Knowledge of High Availability (HA) and Disaster Recovery (DR) options Using FCI/Always on for SQL Server. • Analyse existing SQL queries for performance improvements. • Having knowledge in SSIS /SSRS is desirable. • NoSQL administration/development experience in MongoDB is added advantage. Responsibilities • Help write and optimize in-application SQL statements. • Ensure performance security, and availability of databases. • Prepare documentations and specifications. • Handle common database procedures such as upgrade, backup, recovery, migration, etc. • Profile server resource usage and optimize and tweak as necessary. • Collaborate with other team members and stakeholders. Qualifications Education Bachelors degree in related field. Years of Related Experience Years of experience 8 to 12 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 Corporation 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 contracts. In 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 fulfil 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