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

USM; King of Prussia (PA); On-site; USD 100,000 - 130,000; Full time

Job summary

A fast-growing IT Systems Integrator is seeking a SQL Development Lead/Architect with 10-12 years of experience. The role involves creating and modifying SQL Objects according to business needs, ensuring performance and security, and troubleshooting any reported issues. Strong proficiency in T-SQL and SQL Server 2014 is essential, along with the ability to work on large databases. This position offers the opportunity to drive SQL development within a dynamic organization located in King of Prussia, PA.

Qualifications

• 10+ years of SQL Development experience required.
• Strong T-SQL and SQL Server 2014 skills essential.
• Ability to debug and troubleshoot effectively.

Responsibilities

• Create and modify SQL Objects per business requirements.
• Ensure performance and security of SQL queries.
• Debug issues reported by Production Support.

Skills

SQL Development experience

T-SQL and SQL Server 2014 proficiency

Troubleshooting and debugging skills

Execution Plans understanding

Optimizing SQL Statements

Experience with large databases

RDBMS concepts

Data modeling experience

SQL Server Profiler knowledge

Relational databases best practices

Financial Domain knowledge

SVN knowledge

Octopus knowledge

TeamCity knowledge

Job description

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

USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers.

Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services.

Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps.

USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.

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.
• 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.

USM Systems Inc.

703-880-4184

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