Senior Database Engineer

Company Description

Job Description

DOB's Information Technology bureau is responsible for the data processing functions and operations of systems that provide operational, analytical and managerial support functions, as well as IT resource management for the agency. DOB IT develops and maintains application software for such systems. Working closely with owner/client bureaus within the agency, IT develops and implements both customized and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions.

The Department is in the process of the development, conversion and modernization of the agency's numerous old legacy systems. The Senior Database Engineer will serve as a Database Developer who will support DOB's architecture team with consolidating and optimizing new technology initiatives for the agency's mission critical systems.
Under general direction, with broad scope for the exercise of independent initiative and judgment, responsibilities include, but are not limited to:
-Supervising data engineering projects from beginning to end, including planning, designing, testing and implementation. Projects could include but not limited to the following:
oExtract, transform, and load (ETL) data warehouses, including the use of change data capture to load incremental changes from on premise data source to the cloud data warehouse.
oOptimize and tune complex SQL code for faster data retrieval and processing.
oDevelop API that ingest data as well as share DOB agency data with external stakeholders
-Serving as a project leader for complex projects involving database systems and providing technical leadership and guidance to other development team members in the design, architecture, and best practices of data engineering solutions.
-Planning, designing, developing and implementing scalable database structures to support business requirements for anticipated data growth.
-Leading database design by working with development teams, coordinating with other developers, business team representatives, and others to accomplish the database design and documented specification.
-Developing SQL Server 2016 - 2022 T-SQL/Store Procedures/SQL Optimization and Tuning.
-Creating Complex Queries/Functions/Views/SQL jobs/Database Objects.
-Leveraging Python to call API to integrate data with our DOB data warehouse.
-Creating and maintaining end-to-end analytics solution in Azure Synapse, including creating Synapse pipelines to support Azure Data Lakes and Serverless and Dedicated Pools, which are used as data sources by our reporting systems, Power BI and Oracle Analytics.
-Deploying and troubleshooting SSIS Packages.
-Designing and implementing solutions for extraction and integration of data to and from a relational database or data warehouse for the purpose of reporting, decision support and analysis.
-Diagnosing and resolving database issues to maintain uninterrupted operations.
-Ensuring database optimization, data integrity, consistency, security and privacy is part of the application designs.
-Safeguarding data through robust security measures and regular audits.
-Implementing and managing backup and recovery protocols to prevent data loss.
-Monitoring database performance, implementing optimization strategies for increased efficiency.
-Collaborating with developers to implement database design in prototypes to help communicate database requirements to all interested parties and inform an iterative database design process with customer feedback.
-Reviewing developers' queries and stored procedures to check for correct implementation of database design.
-Performing scheduled activities; recommending solutions or alternate methods to meet requirements.
-Developing data dictionary, system specification, guidelines and documentation.
-Implementing, maintaining and supporting a variety of reports utilizing various reporting tools.
-Assisting in development of standard reports for ongoing business needs.

CIVIL SERVICE STATUS:
Only permanent Computer Specialists (Software), applicants who are reachable on the Computer Specialist (Software) open competitive list, and applicants as indicated below will be considered. If the list is exhausted, applicants who passed the most recent open competitive exam for Computer Specialist (Software) may also be considered.

Candidates who are permanent in comparable civil service titles may be considered for title change under rule 6.1.9 of the Personnel Rules and Regulations of the City of New York.

REMOTE WORK:
This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program.

To Apply:
Visit Jobs NYC (cityjobs.nyc.gov) to view and apply for available positions. Search by agency (Department of Buildings), keywords, or for the specific Job ID .

NOTE: ONLY THOSE CANDIDATES UNDER CONSIDERATION WILL BE CONTACTED.

REMOTE WORK
This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program.

COMPUTER SPECIALIST (SOFTWARE) - 13632

Qualifications

(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or
(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in "1" above, including one year in a project leader capacity or as a major contributor on a complex project; or
(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.
NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification
requirements.
Special Note
To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.

Additional Information

The 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.