Senior SQL Developer

BLDG SVC 32 B-J•New York, NY

About The Position

Under the supervision of the Team Lead, Data Integration, the Senior SQL Developer is responsible for designing, developing, and maintaining complex SQL databases, queries, and procedures. The role involves deep collaboration with business analysts and other developers to create efficient database systems that meet organizational needs. The Senior SQL Developer leverages expertise in SQL Server, performance tuning, and database architecture to ensure the reliability, security, and efficiency of database-driven applications.

Requirements

7+ years of experience in SQL development, including database design, performance tuning, and query optimization.
Proven experience with Microsoft SQL Server (versions 2016 and later) and SQL Server Reporting Services (SSRS).
Extensive experience in writing complex T-SQL queries and developing stored procedures.
Experience in database performance tuning and optimization (PTO), using native monitoring and troubleshooting tools.
Solid understanding of database security, backup/restore strategies, and high availability solutions (e.g., Always On, replication).
Familiarity with data warehousing concepts, ETL processes, and Azure SQL Database.
Experience with cloud-based database solutions, particularly in Azure (e.g., Azure SQL, Azure Data Factory).
Familiarity with other database technologies such as Oracle, MySQL, or PostgreSQL.
Experience with modern data integration tools and processes.
Knowledge of DevOps practices and CI/CD pipelines for database changes.
Ability to work with business analysts and business users
Candidate must have excellent communication (verbal and written) and interpersonal skills
Bachelor’s degree in Computer Science, or a related discipline.
Speak, read, write and understand English
Detail oriented with excellent organization and analytical skills;
Ability to plan and take initiatives to accomplish objectives in timely fashion;
Ability to prioritize work and meet deadlines;
Ability to establish and maintain effective working relationships with project team members, supervisors, and employees from other departments.

Nice To Haves

Working knowledge of Oracle and Java programming is a big plus
Microsoft SharePoint is a plus
Understanding of Microsoft Dynamics is a plus

Responsibilities

Design, develop, and optimize complex SQL databases, tables, queries, stored procedures, triggers, views, and functions.
Maintain and enhance existing SQL databases, ensuring high availability and performance.
Participate in requirement analysis sessions with business analysts and users to gather and document database requirements and develop technical solutions to support business needs..
Develop and manage database models, database schema, database normalization, indexing strategies, and data migration plans.
Optimize and fine-tune SQL queries to improve performance and scalability.
Monitor and troubleshoot database performance issues, implementing optimizations as necessary.
Provide production and end-user support for database-related issues.
Work closely with application developers and architects to design and implement efficient database structures.
Create and maintain detailed database documentation, including data models, schemas, and stored procedures.
Ensure adherence to industry standards and best practices for database development, backup & recovery, replication, and security.
Assist in the estimation and planning of database development tasks, reporting progress to management.
Mentor junior developers and provide guidance on SQL best practices and coding standards.
Research and recommend new database technologies and tools to improve existing systems.
Production and End User Support Activities
Work on multiple projects at the same time
Assist and support other programmers in development procedures, techniques and coding assignments
Research and recommend new and existing technologies to meet business needs, including creating prototypes, design documents, and solution designs
Perform tasks as required by management/supervisory staff.
Provide support after hours as required.