The Office of the Queens County District Attorney (QDA) is seeking an experienced Senior Database Administrator to design, implement, optimize, and support relation database management systems to support in-house created and off-the-shelf commercial applications to aid in case tracking and processing. The Senior Application Developer will be part of QDA’s Information Services Bureau that includes a staff of 12 and serves an office of over 800 staff.

The Senior Database Administrator’s responsibilities will include, but are not limited to:

• Design redundant, highly available database clusters for several in-house and off-the-shelf enterprise applications.
• Implement and maintain zero loss databases across multiple nodes in multiple clusters.
• Perform index tuning and optimization tasks using SolarWinds DPA.
• Develop and maintain entity relationship diagrams of data stores.
• Experience with MS SQL tools such as MS SQL Management Studio.
• Design disaster recovery plan, schedule and implement the plan on a regular basis.
• Create and document various data views for use in data visualization tools, such as Power BI.
• Maintain object relationship consistency across all related data stores, enforcing foreign key constraints on dependent tables.
• Implement role-based security access, leveraging SSO and MFA where required.

Required Skills:

• MS SQL Server
• MariaDB
• SolarWinds DPA
• Index Tuning
• E-R Diagramming
• Data Normalization
• Backup and Restore
• Clustered Databases
• Query Optimization
• MongoDB
• PostgreSQL

Database Tools: SQL Server Management Studio, Azure Data Studio, SQL Profiler, SQL Prompt.  No SQL, Hive, SQL Data Compare, SQL Compare.  ETL tools Teradata, MS SQL Server, Data Transformation Services (DTS) Export/Import, SQL Server Integration Service (SSIS), ADF, DataStage, Azure Synapse. Reporting tools SQL Server Reporting Services (SSRS), Power BI

Additional Databases:  Azure SQL Database, SQL Server Analysis Service (SSAS), EDW, EDL DevOps, Azure Blob, Azure Data Lake, Synapse, AWS, S3, GCP, Azure Functions.

Operating Systems:  Windows Server 2022/2019/2016, Unix Server, Red Hat Enterprise Linux, Windows 10, 11

Version Control:  CVS, SVN, GIT, GitHub, TFS.

Project Environment:  SDLC, Agile/Waterfall.

Other Tools:  ERWIN, Lucid Chart, Redgate, MS Dynamic 365, SQL Server Agent.

Preferred Education and Qualification Requirements:

1. A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to information technology service management, process management, operations; or,

2. A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related IT service management, process management, operations; or,

3. Education and/or experience which is equivalent to "1" or “2” above.

A master’s degree in computer science or a related field from an accredited college is strongly preferred.

Must have excellent communication skills and experience in handling confidential information.

For current New York City employees, a permanent computer-related civil service title is preferred but not required.

Application Information:

Comprehensive benefits package including health insurance, and more.

Salary Range: $100,000 – $130,000. Salary commensurate with experience. 

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.

To apply, please submit a resume and cover letter, by clicking on the link below: