Building Service 32BJ Benefit Funds · 1 week ago
Senior SQL Developer
New York, NY
Full-time
Onsite
Senior Level
$120K/yr - $155K/yr
7+ years expBuilding Service 32BJ Benefit Funds is seeking a Senior SQL Developer responsible for designing, developing, and maintaining complex SQL databases and queries. The role involves collaboration with business analysts and developers to create efficient database systems that meet organizational needs while ensuring reliability and performance of database-driven applications.
EducationNon ProfitTraining
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
Qualification
Required
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
Preferred
Working knowledge of Oracle and Java programming is a big plus
Microsoft SharePoint is a plus
Understanding of Microsoft Dynamics is a plus
Company
Building Service 32BJ Benefit Funds
The Building Service 32BJ Benefit Funds is the umbrella organization responsible for administering benefits, including Health, Pension, Retirement Savings, Training and Legal Services benefits to over 100,000 SEIU 32BJ members.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Anna McQuere
Assistant Director of Clinical Partnerships
Sabrina Benteftifa
Clinical Partnerships Manager
Company data provided by crunchbase