Experience: 2-12 yrs
Location: Chennai
Skills Required: SQL Server, Stored Procedures, TSQL, QUERY Writing
SQL Developer / Senior Developer / Technical Consultant / Team Lead
Must Have
- Strong proficiency with SQL Server and its variation among popular databases
- Well versed with the advanced level of writing stored procedures, construing the query plans, altering the indexes and troubleshooting the performance holdups
- Skilled at optimizing large complicated SQL statements
Nice to Have
- Familiar with SSIS, SSRS, reporting tools
- Knowledge in .Net for developing/debugging API/web services
Job Description
Technical consultant who is proficient in SQL database-based application development having experience between 2 - 12 years.
He will be responsible for
- Database designing and ensuring their stability, reliability, and performance.
- Development of application screen in Ramco Platform, implement and optimize stored procedures and functions using T-SQL
- Debugging application issues by taking SQL Trace & fix the root cause of the issue in TSQL
- Development of Integration touch points using API / Web services in Ramco Platform
- Would require to learn in-house development tools for development of screens, reports, Data Drill Down reports, Dashboards etc
- Profile server resource usage and optimize and tweak as necessary
- Prepare documentations and specifications
- Collaborate with other team members and stakeholders