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

Posted 3 Months Ago
Be an Early Applicant
Pennsylvania Furnace, PA, USA
In-Office
Expert/Leader
Artificial Intelligence • HR Tech • Information Technology • Consulting
The Role
Lead SQL developer/architect responsible for designing data models, creating and optimizing SQL objects (stored procedures, functions, views), ensuring performance and security, troubleshooting production issues, conducting peer code reviews, and coordinating releases with Dev and QA.
Summary Generated by Built In
Company Description

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.

Job Description

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

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.

Additional Information

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

Skills Required

  • 10+ years of SQL development experience
  • Strong proficiency with T-SQL
  • Experience with SQL Server 2014
  • Very strong troubleshooting and debugging skills
  • Understanding of execution plans and experience optimizing large, complex SQL statements
  • Experience working with very large databases (tables with terabytes of data)
  • Strong RDBMS concepts and experience in data modeling
  • Knowledge of SQL Server Profiler tool
  • Familiarity with relational database best practices
  • Ability to plan resource requirements from high-level specifications
  • Knowledge of Financial Domain
  • Knowledge of SVN, Octopus, and TeamCity
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Lewes, DE
125 Employees

What We Do

EROS Technologies Inc. is a global IT services and consulting company specializing in providing tailored workforce solutions and staffing, particularly in the technology sector. The company leverages AI-powered tools to deliver top-tier talent and provides 24x7x365 multi-vendor IT support, acting as a single source of accountability for mission-critical computing environments across demanding industries.

Similar Jobs

Spectrum Logo Spectrum

Senior Manager, Strategy & Engagement- Risk & Resilience (RapidScale) (Remote)

eCommerce • Information Technology • Internet of Things • Mobile • On-Demand • Retail • Software
In-Office or Remote
Philadelphia, PA, USA
100000 Employees

Optum Logo Optum

Architect

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office or Remote
Fort Washington, PA, USA
160000 Employees
113K-193K Annually

Optum Logo Optum

Registered Nurse, Home Health Weekend (Fri-Mon)

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Harrisburg, PA, USA
160000 Employees
34-62 Hourly

Optum Logo Optum

Home Health Aide

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Scottdale, PA, USA
160000 Employees
16-24 Hourly

Similar Companies Hiring

Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account