Database Architect

Shree Narayani Networking Solutions • New York City, NY

5d • Onsite

About The Position

The SQL Developer / Database Architect / Data Engineer is a senior technical role responsible for designing, developing, administering, optimizing, integrating, and governing data for the Client Construction organization. This hybrid role combines database architecture and data engineering to support business applications, analytics, and digital transformation initiatives. The successful candidate will create and support scalable, secure, and highly available database solutions, as well as enterprise data pipelines, integrations, and reporting platforms. The role balances planning, hands-on technical work, operational support, and collaboration across technical and business stakeholders. It also requires concise, sufficiently detailed written communications for technical and non-technical audiences.

The position is with Con Edison, based onsite in Manhattan, New York. Local candidates from the tristate area are required. Utilities experience is a significant plus. The role is listed as a 6+ month C2C engagement at a rate of $60 per hour. The interview process includes an initial video interview and a mandatory onsite second interview. H-1B and OPT candidates are not accepted.

Requirements

• Bachelor's degree in Information Technology, Computer Science, or a related field, or equivalent experience.
• Five to eight years of MS SQL Server development experience.
• Six or more years of hands-on software development and systems integration experience.
• Strong T-SQL programming skills, including complex queries, joins, views, stored procedures, functions, and query optimization.
• Strong experience developing and supporting 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.
• Strong to advanced experience with Microsoft Excel, Word, PowerPoint, and Outlook.
• Experience with SQL Server performance tuning, indexes, index management, and optimization.
• Excellent analytical, critical-thinking, and problem-solving skills, including the ability to anticipate and proactively address issues.
• Excellent written and verbal communication skills, including the ability to explain technical concepts to non-technical audiences.
• Ability to prepare concise, sufficiently detailed documentation, deployment plans, status reports, and meeting notes for technical and non-technical audiences.
• A methodical and organized approach to problem-solving.
• Ability to execute existing SQL queries and interpret, modify, and write scripts and SQL queries.
• Expertise in databases, ETL, and BI.
• Must be local to the tristate area and able to work onsite in Manhattan, New York.
• H-1B and OPT candidates are not accepted.

Nice To Haves

• Utilities experience.
• Experience with PowerShell scripting and automation.
• Experience with SQL Server administration, security, backup and recovery, and maintenance.
• Ability to present and explain information clearly and concisely to technical and non-technical people.

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 loading, reconciliation, data validation, and data quality processes.
• Analyze, solve, and correct data, ETL, and database-related issues, providing end-to-end resolution.
• Maintain database objects, schema changes, and scripts using version control systems such as Azure DevOps and GitHub.
• Follow team standards; recommend new or updated standards where gaps exist and identify areas for improvement.
• Document and update technical documentation, operational procedures, and support runbooks as appropriate.
• Take ownership of assigned deliverables and follow them through to completion, adapting to priority changes.
• Learn and follow the Client's policies, procedures, and standards.
• Develop accurate estimates of effort and timelines and complete assignments accurately within approved schedules.
• Assist with query tuning, performance optimization, and schema refinement.
• Assist with SQL Server database administration, including monitoring, maintenance, security, backup verification, and troubleshooting.
• Provide backup database administration support during planned absences, vacations, and off-hours support rotations.
• Collaborate effectively with business and technical teams in cross-functional and cross-matrixed environments.
• Support release deployments, testing, and production implementations as required.
• Create, document, and execute test plans, including white-box, black-box, positive, and negative testing.
• Perform other duties as assigned, directed, or requested.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior