Company:         S&P Global

Website:           www.spglobal.com

Eligibility:        Any Graduate

Experience:      3+ yrs

Location:          Gurgaon

Job Role:        Database Developer

JOB SUMMARY:

Company Profile:

S&P Global Market Intelligence, formerly S&P Capital IQ and SNL Financial, is a division of McGraw Hill Financial (NYSE:MHFI). The firm is a leading provider of financial and industry data, research, news and analytics to investment professionals, government agencies, corporations, and universities worldwide.

Job Description:
1. Designing databases and ensuring their stability, reliability, and performance.

2. Design, create, and implement database systems based on the end user's requirements.

3. Improve application's performances (middle tier) connecting to MSSQL DB’s.

4. Prepare documentations for database applications.

5. Memory management for database systems.

6. Develop database schemas, tables and dictionaries.

7. Ensure the data quality and integrity in databases.

8. Fix any issues related to database performance and provide corrective measures.

9. Create complex functions, scripts, stored procedures and triggers to support application development.

Candidate Profile:
Experience:
1. At least 3+ Years of experience and working knowledge on MSSQLDB technologies as DBA DEVELOPER or DEVOPS

2. 2+ Years of experience in windows and cloud environments.

3. 3+ Years of experience in Microsoft SQL Server

Required Skills:
1. Advanced/Expert level knowledge (devops) of MSSQL DB’s.

2. Intermediate/Basic level knowledge of PostgreSQL or NoSQL DB technologies

3. Excellent procedural Scripting knowledge (working) on MSSQL DB i.e TSQL.

4. Fine tuning TSQL queries(MSSQL) knowledge.

5. DEVOPS mindset to deliver projects ontime and quality.

6. Migration/Development/Performance tuning experience on MSSQL

7. Devops knowledge on MSSQL databases preferably 2017 or latest versions

8. Working in agile scrum model

9. Database query tuning or optimization experience on MSSQL Database technologies.