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

Posted 3 Days 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
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

USM Business Systems Logo USM Business Systems

Architect

Artificial Intelligence • Information Technology • Internet of Things • Software • Automation
In-Office
King of Prussia, PA, USA
580 Employees

CrowdStrike Logo CrowdStrike

Sr. Brand Media Manager (Remote)

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
130K-200K Annually

Comcast Logo Comcast

Senior Program Manager

Digital Media • Information Technology • News + Entertainment
Hybrid
Philadelphia, PA, USA
115000 Employees

Comcast Logo Comcast

Engineer 1, Hardware Engineering

Digital Media • Information Technology • News + Entertainment
Hybrid
Philadelphia, PA, USA
115000 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account