SQL Development – Lead/Architect

Responsibilities

· Create and alter SQL Objects including Stored Procedures, Functions, Views, etc. as per business requirements.

· Ensure performance and security.

· Debug, troubleshoot, and propose solution for any issue reported by Production Support or Business.

· Create and propose data model as per business requirements.

· Perform peer Code Reviews for SQL Objects created.

· Validate and approve SQL code submitted by developers for ad hoc execution in QA and Prod environments.

· Create SQL builds.

· Coordinate with Dev and QA teams for release management.

Skills

· Should have 10+ years of SQL Development experience.

· Strong proficiency with T-SQL and SQL Server 2014.

· Very strong troubleshooting and debugging skills.

· Sound understanding of Execution Plans and Hands-on experience with optimizing large and complex SQL Statements.

· Experience with working on large and complex databases with tables having terabytes of data.

· Strong in RDBMS concepts and Experience in data modeling.

· Knowledge of SQL Server Profiler tool.

· Knowledge of best practices when dealing with relational databases.

· Ability to plan resource requirements from high level specifications.

· Knowledge of Financial Domain will be an added advantage.

· Knowledge of tools like SVN, Octopus, and TeamCity will be an added advantage.

All your information will be kept confidential according to EEO guidelines.