SQL Database Administrator

Job Description

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 requiredPOSITION 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 designAdvanced knowledge in Database security, encryption, auditing, backup/restore, replication, and failover clusteringExperience with reporting frameworks (Power BI, SSRS a plus)Strong analytical and debugging abilitiesEffective communication and documentation skillsAbility to collaborate with developers, analysts, and DOE teamsAttention 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.