Senior Database Developer - Lensa : Job Details

1 week ago Be among the first 25 applicants

Lensa is a career site that helps job seekers find great jobs in the US. We are not a staffing firm or agency. Lensa does not hire directly for these jobs, but promotes jobs on LinkedIn on behalf of its direct clients, recruitment ad agencies, and marketing partners. Lensa partners with DirectEmployers to promote this job for City of New York.Job DescriptionNOTE: This is a temporary funded position through June 30, 2026.THE AGENCYThe Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and sharing its perspectives on growth and community needs with sister agencies in collaboration with the Office of Management and Budget (OMB).DCP is a great place to work – cultivating intellectual inspiration, professional development, and creativity. Visit our website at www.nyc.gov/planning to access the full listing of job opportunities and to learn more about the agency's services.THE DIVISIONInformation Technology Division's (ITD) vision is to become a dynamic and vibrant technology delivery organization of the New York City government that leads business transformations and technology innovations to enable citizen-centric smart urban planning, while promoting a culture of collaboration, talent development, and equity. ITD is responsible for developing technology solutions to support agency needs and citywide asks, including City Charter mandates, grant funding requirements, and citywide geospatial services, and maintaining systems infrastructure and endpoint assets, to optimize operational efficiency, promote innovation, and collaborate with other city agencies to enhance service accessibility to citizens. The division provides necessary computing infrastructure and productivity-enhancing technology tools in a hybrid mode (on premise and in the cloud), to support DCP's interdisciplinary staff across five boroughs, including planners, urban designers, project managers, and executive management. The division is comprised of experienced and talented software engineers, geographic specialists, service engineers, and technology leaders who specialize in managing system infrastructure, cyber security, geospatial data engineering, application services, and portfolio management.Within ITD, the GeoSupport Services (GSS) unit is responsible for the maintenance and continued enhancement of the GeoSupport system that processes geographic locations in New York City to provide unique geospatial references for city boroughs, community districts, tax blocks, lots, street stretches, intersections, etc., to the rest of the city agencies, partners, and the public. The geo-processed location references are made available to incorporate into internal and external system workflows and data analysis, to represent the geography of locations and assets, enabling map-based visual representation, conflict resolution, and collaboration. The GSS unit is staffed by a team of software engineers specializing in Geographic Information Systems (GIS) and web service design, using a variety of technology stacks and cloud computing infrastructure.THE ROLEITD's GeoSupport Services (GSS) unit is seeking an experienced and certified Senior Database Developer for Microsoft SQL Server who has strong expertise in data modeling, normalization, ETL processing, integration/reporting services, OLAP data models, ORM tools (Entity Framework), and query performance tuning skills to join our agile development team. This role requires hands-on experience with T-SQL, data modeling, database query optimization, SSIS, SSAS, and SSRS to support enterprise applications and data-driven solutions. The candidate will play a crucial role in designing, developing, and maintaining the next generation GeoSupport system services and applications, collaborate with cross-functional teams to deliver high-quality software solutions that meet business requirements, while ensuring performance, scalability, security, and accessibility to manage nearly 70 billion GeoSupport service calls made each year.ResponsibilitiesUnder supervision and general direction, with considerable latitude for the exercise of independent judgment, the Senior Database Developer's responsibilities include, but may not be limited to:

• Perform data modeling and database design for application development and product implementation initiatives under the guidance of database administrator and technical leads.
• Follow best practices in data modeling including use of standard naming conventions, processes and templates to ensure consistency of data models.
• Design and optimize T-SQL queries, stored procedures, functions, and triggers for high performance SQL Server databases.
• Perform data extraction, transformation, and loading (ETL) processes to integrate data from multiple sources.
• Develop, manage, optimize, and automate ETL workflows using SQL Server Integration Services (SSIS) and other ETL tools.
• Design and implement OLAP reporting models, star and snowflake schemas, and optimize data cubes.
• Identify and resolve SQL Server performance bottlenecks, including indexing, query execution plans, and partitioning to ensure availability, performance, reliability, and scalability.
• Ensure data integrity, security, and compliance with industry best practices.
• Collaborate with .NET development teams to ensure database efficiency and scalability.
• Optimize database interactions in .NET/C# web applications, ensuring efficient ORM (Entity Framework) performance.
• Work on data migration strategies for on-premise to cloud (Azure SQL, AWS RDS, etc.) transitions.
• Create reporting solutions using SQL Server Reporting Services (SSRS) by analyzing user needs and information availability.
• Perform data model management and version control using industry standard tools.
• Reverse engineer and document database architecture for business-critical legacy databases.
• Work closely with business analysts, subject matter experts and development teams in design, development, testing, implementation, and support of application projects.
• Facilitate creation, migration and maintenance of database objects across development/QA/production environments.
• Define and implement data testing strategies with business stakeholders, application development teams and QA groups.
• Participate in the software testing process, including identification and resolution of defects.
• Contribute to and support roll-out strategies.
• Participate in and contribute to formal/informal technical reviews and presentations.
• Understand other database platforms like Oracle, MySQL and IBM DB2.
• Understand high level application architecture/design, network design, performance constraints and security frameworks.
• Apply technical knowledge to determine solutions and solve complex problems.
• Estimate time required to complete tasks accurately, prioritize multiple tasks effectively, and ensure issues are identified, tracked, reported, and resolved in a timely manner.

IT AUTOMATION AND MONITORING E - 95712Qualifications

• A baccalaureate degree in computer science, engineering or a related field from an accredited college and four years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure; or
• Eight years of satisfactory full-time experience related to IT automation engineering, monitoring engineering, management of infrastructure;
• Education and/or experience which is equivalent to 1 or 2 above.

Additional InformationThe City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.Salary Min: $115,000.00Salary Max: $125,000.00If you have questions about this posting, please contact [email protected]

Seniority level

• Seniority levelMid-Senior level

Employment type

• Employment typeFull-time

Job function

• Job functionInformation Technology
• IndustriesInternet Publishing

Referrals increase your chances of interviewing at Lensa by 2x

Get notified about new Senior Database Developer jobs in New York, NY.

Jersey City, NJ $120,000.00-$160,000.00 2 weeks ago

Manager, Database Developer, Clinical Data Collection Strategies

New York, NY $92,600.00-$171,500.00 2 days ago

Manager, Database Developer, Clinical Data Collection Strategies

Pearl River, NY $92,600.00-$171,500.00 2 days ago

Tableau Developer with Finance Domain Exp - Rutherford, NJ (Hybrid) - Full-TimePower BI Fabric Support Engineer & DeveloperSenior Engineer Identity & Access Management

Parsippany, NJ $115,000.00-$155,000.00 9 hours ago

Whippany, NJ $209,639.00-$225,161.00 2 weeks ago

Whippany, NJ $209,639.00-$225,161.00 2 weeks ago

Whippany, NJ $223,000.00-$230,000.00 2 days ago

Whippany, NJ $223,000.00-$230,000.00 2 days ago

New York City Metropolitan Area $90.00-$100.00 1 week ago

Senior Engineer II - Microsoft Copilot & Power Platform SolutionsSenior Software Engineering Lead - Private Equity & Real Estate Technology

New York, NY $175,000.00-$235,000.00 2 weeks ago

React.JS Software Engineer (Senior Full Stack React.JS Developer)Front-End Designer & Animator, Senior AssociateVice President, Senior Software Engineer - Capital Markets

New York, NY $166,000.00-$205,000.00 2 weeks ago

Whippany, NJ $165,000.00-$227,000.00 1 day ago

Senior Robotics Software Engineer (ROS2 / PLC / CV)

New York City Metropolitan Area 2 weeks ago

PL SQL Developer_Roseland, NJ_ONLY ON W2

Englewood Cliffs, NJ $115,000.00-$145,000.00 1 week ago

New York City Metropolitan Area $75.00-$85.00 4 days ago

New York, NY $106,125.00-$176,875.00 1 week ago

We're unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr