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

EROS Technologies Inc.; Pennsylvania Furnace (PA); On-site; USD 100,000 - 130,000; Full time

Job summary

A strategic technology partner is looking for a SQL Development Lead/Architect in Pennsylvania Furnace. This role requires over 10 years of experience in SQL Development, strong proficiency in T-SQL, and the ability to ensure performance and security. Key responsibilities include creating SQL objects, debugging issues, and coordinating with Dev and QA teams. Candidates with knowledge in the financial domain and experience with large databases will have an added advantage.

Qualifications

• 10+ years of SQL Development experience required.
• Very strong troubleshooting and debugging skills.
• Sound understanding of Execution Plans.

Responsibilities

• Create and alter SQL Objects as per business requirements.
• Ensure performance and security of SQL.
• Debug and propose solutions for reported issues.

Skills

T-SQL proficiency

SQL Server 2014

Troubleshooting skills

Data modeling

Execution Plans

Tools

SVN

Octopus

TeamCity

Job description

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

EROS Technologies was founded with a simple motive of offering the clients exactly what they want, how they want and when they want it. By leveraging for its clients its technological edge and right-sourcing advantage, EROS in a short period of time has grown to become one of the most trusted strategic technology partners. Treating every client as the top priority, we customize our solutions and services to align with the unique needs of each client.

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.

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