Strong SQL Coding

70 percent coding 30 admin

Roles and responsibilities:

Expert level of experience in SQL server

Good understanding of SQL, Stored procedure, and all functions

Very strong in Troubleshooting and debugging SQL code

Should be expert in SQL query Performance optimization(Indexing, Collecting stats, Partitioning, etc.,) for long running queries and DB administration

Should be able to analyze requirements and write large & complex queries creation based on requirements

Support and suggest the developers on query implementation whenever required

Connect with developers to understand the issues and guide them on resolution

Should be able to troubleshoot and identify the translation issues when data transferred from source to target.

Support developers to produce code which meets clients coding standards and best practices.

Should work with the client's technical personnel to clarify and validate business requirement

Should be able to identify potential problems and proactively suggest changes and solutions.

Should be able to act as a reference for the data integration and reporting solution

Interact with and communicate detailed technical requirements to project development team