SQL Database Administrator

Think Tank, LLC

New York, NY, United States

2 months ago

Apply on dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

.NET Framework Backup Devices Big Data Cyber Security Databases Data Validation Data Governance Extract Transform Load (ETL) Database Security Software Debugging Disaster Recovery Failover Clustering

+16 more

Microsoft SQL Server Performance Tuning Release Management Power BI SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Integration Services Systems Integration Transact-SQL Workflow Management Systems Enterprise Software Applications Application Enhancement Tool Azure Data Factory Database Performance Tools for Reporting

Job description

The SQL Database Administrator will be responsible for managing DOE application databases supporting Galaxy Systems, Enterprise Application Systems, and Vendor Portal Systems. This includes performance tuning, data modeling, security administration, backup/restore operations, and supporting application enhancements with robust and scalable database solutions., * Design, maintain, and optimize SQL Server databases used across DOE enterprise applications.

Support the development team in writing efficient stored procedures, triggers, and queries.
Implement data validation rules, transformation logic, and ETL pipelines to improve data accuracy and reliability.
Ensure compliance with DOE cybersecurity, data privacy, and audit requirements.
Monitor database performance and implement tuning strategies.
Develop and maintain data dictionaries, schemas, and database documentation.
Manage backup/restore strategy and disaster recovery procedures.
Support application releases, data migrations, environment refreshes, and integration with other DOE systems.
Troubleshoot database-related issues and collaborate with the development team for resolution.

Requirements

7+ years of experience as a SQL Server DBA in enterprise environments.
Strong understanding of large-scale data management, data governance, and system integrations.
Experience supporting .NET applications and ETL processes.
Proficiency in SQL Server 2016+ version, T-SQL performance tuning, SSIS, Azure Data Factory, and ETL workflow design
Advanced knowledge in Database security, encryption, auditing, backup/restore, replication, and failover clustering
Experience with reporting frameworks (Power BI, SSRS a plus)
Strong analytical and debugging abilities
Effective communication and documentation skills
Ability to collaborate with developers, analysts, and DOE teams
Attention to data accuracy, integrity, and security

Benefits & conditions

Think Tank also offers a comprehensive benefits package that includes medical, dental, and vision coverage; long-term and short-term disability; and a 401(k) plan; personal time off, and 11 federal holidays. All benefits are subject to eligibility requirements.