SQL Development – Lead/Architect -10-12+ years(F2F must)

Position: SQL Development – Lead/Architect -10-12+ years

Location: KOP, PA

Duration 12-18 months 

Interview Mode: Video conferencing followed by two face to face interviews

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. 

Mahesh Gunnam

USM Systems Inc.

703-880-4184

gmahesh(at)usmsystems.com

If my requirement matches your resume, then please do reply on my email id gmahesh(at)usmsystems.com and contact number 703-880-4184.