SQL Database Administrator

Think Tank, Inc.; New York (NY); Remote; USD 110,000 - 160,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) plan

Personal time off

11 federal holidays

Personal time off

11 federal holidays

Job summary

A technology organization is seeking a skilled SQL Database Administrator to manage databases supporting key enterprise systems. The role involves designing, optimizing, and securing SQL Server databases while collaborating with development teams. Ideal candidates have 7+ years of DBA experience, strong ETL and data management skills, and proficiency in SQL Server 2016+. This remote position requires occasional travel to Brooklyn, NY.

Qualifications

• 7+ years of experience as a SQL Server DBA in enterprise environments.
• Strong understanding of large-scale data management and system integrations.
• Proficiency in SQL Server 2016+, T-SQL performance tuning, and ETL workflow design.
• 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

Responsibilities

• Design, maintain, and optimize SQL Server databases for enterprise applications.
• Support development team with stored procedures and queries.
• Implement data validation rules and ETL pipelines.
• Monitor database performance and implement tuning strategies.
• Manage backup/restore strategy and disaster recovery procedures.
• 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.

Skills

SQL Server DBA experience

Data management

ETL processes

T-SQL performance tuning

Database security

Reporting frameworks

Analytical skills

Effective communication

Tools

SQL Server 2016+

SSIS

Azure Data Factory

Power BI

SSRS

Job description

Authorization to work in the US is required

This is a remote position with occasional travel to onsite location in Brooklyn, NY

Applicants residing within travel distance are preferred

Three references are required

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

RESPONSIBILITIES:

• 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

Think Tank is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. All qualified candidates will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, veteran status, or any other protected characteristic under applicable law.

Compensation for the successful candidate will be determined based on a variety of factors, including education, relevant work experience, work location, specific job responsibilities, professional certifications, and other job-related criteria.

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.