Database Architect

Shree Narayani Networking Solutions Pvt Ltd; New York (NY); On-site; USD 68,000 - 97,000; Full time

Job summary

Con Edison is seeking a Jr. Database Architect to design, build, and govern enterprise data solutions.

The hybrid role combines database architecture with data engineering to support critical applications, analytics, and digital transformation. The candidate will create scalable, secure, and highly available database systems, develop data pipelines, and partner with cross-functional teams to ensure reliable data delivery and reporting.

Qualifications

• Bachelor's degree in IT/CS or related field.
• 5+ years of MS SQL Server development experience.
• Strong T-SQL programming and query optimization.
• Experience with ETL/ELT processes and enterprise data integrations.
• Experience with data ingestion, incremental loading, data validation, and data quality processes.
• Experience with enterprise data warehousing and dimensional modeling.
• Proficiency with Microsoft Office tools.
• Excellent analytical and problem-solving skills.

Responsibilities

• Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions.
• Design, develop, and support ETL/ELT processes for enterprise data integration and transformation.
• Build and maintain data ingestion, incremental load, reconciliation, data validation, and data quality processes.
• Analyze, solve, and correct data, ETL, and database-related issues with end-to-end resolution.
• Maintain database objects, schema changes, and scripts using Azure DevOps and GitHub.
• Document technical procedures, deployment plans, and status reports for technical and non-technical audiences.
• Take ownership of deliverables and adapt to changing priorities.
• Collaborate across cross-functional teams and support release deployments.

Skills

MS SQL Server

T-SQL

ETL/ELT

Data warehousing

Dimensional modeling

SQL performance tuning

PowerShell scripting

Data governance

Education

Bachelor's degree in Information Technology or Computer Science

Tools

Azure DevOps

GitHub

Job description

Role: Jr. Database Architect
Client Con Edison -2382
Rate $60/hr. C2C
Duration 6+ months
Location- Manhattan, N.Y. (Onsite - need locals to Tristate)
VISA: No H1b, opt

Interview Process

1st. Video. 2nd -- On-Site Mandatory

Local Candidates

- Utilities Experience is a huge plus

JOB DESCRIPTION

The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for the design, ETL/ELT, administration, optimization, integration, and governance of the Client Construction organization data.
This hybrid position combines database architecture, and data engineering functions to support critical business applications, analytics, initiatives, and digital transformation programs.
The successful candidate will create and support scalable, secure, and highly available database solutions while developing and supporting enterprise data pipelines, integrations, and reporting platforms. The role requires a balance of planning, hands‑on technical expertise, operational support, and cross‑functional collaboration across many stakeholders.
Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non‑technical audiences

Responsibilities

• Develop, maintain, and optimize SQL Server stored procedures, views, functions, and advanced T-SQL solutions.
• Design, develop, and support ETL/ELT processes for enterprise data integration and transformation.
• Build and maintain data ingestion, incremental load, reconciliation, data validation, and data quality processes.
• Independently analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end problem resolution.
• Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps and GitHub.
• Follow established team standards. For any gap, recommend new or updated standards and proactively identify areas for improvement.
• Document and update technical documentation, operational procedures, and support runbooks when appropriate.
• Take ownership, support, and follow-through of assigned deliverables, adjusting well to changes in priority.
• Demonstrate a willingness and commitment to learn Client's policies, procedure and standards.
• Develop accurate estimates of effort and timelines.
• Ensure that all assignments are completed accurately and within approved delivery schedules.
• Assist with query tuning, performance optimization, and schema refinement.
• Assist with SQL Server database administration activities, including monitoring, maintenance, security, backup verification, and troubleshooting.
• Serve as a backup resource for database administration support during planned absences, vacations, and off‑hours support rotations.
• Work closely and effectively with business and technical teams in a cross-functional and cross‑matrixed business and technical environment.
• Support release deployment activities, testing, and production implementations as required.
• Create, document, and execute test plans, including white-box testing, black-box testing, positive and negative testing.
• Other duties may be assigned, directed, or requested.

What You Will Need

• Bachelor's degree (Information Technology, Computer Science, or related field) or equivalent experience is required.
• Five (5) to eight (8) years of MS SQL Server development experience is required.
• Strong T-SQL programming experience, including complex queries, joins, views, stored procedures, functions, and query optimization are required.
• Strong experience developing and supporting ETL/ELT processes and enterprise data integrations is required.
• Experience with data ingestion, incremental loading, data validation, and data quality processes is required.
• Experience with enterprise data warehousing and dimensional modeling is required.
• Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required.
• Experience with SQL Server performance tuning, indexes, index management, and optimization is required[SC1]
• Experience with PowerShell scripting and automation is a plus
• Experience with SQL Server administration, security backup/recovery, and maintenance is a plus
• Excellent analytical, critical‑thinking, and problem‑solving skills, with the ability to anticipate and proactively address issues, required.
• Must have excellent communication skills, both written and verbal.
• Ability to effectively present technical concepts and information to non‑technical audiences.
• Ability to prepare concise yet sufficiently detailed written communications, including documentation, deployment plans, status reports, and meeting notes, for both technical and non‑technical audiences.[SC2]
• A methodical and organized approach to problem‑solving.

Must Have

• 6+ years of hands‑on software development and systems integration experience
• Ability to execute existing SQL queries
• Ability to intrepid, modify and write scripts and SQL queries
• database/ETL/BI expert

Nice To Have

• Ability to present and explain information in a clear and concise manner to both technical and non‑technical people