Senior Technology Engineer - Database Administrator (DBA) [SQL Server & Oracle]

Brookhaven National Laboratory is committed to employee success and we believe that a comprehensive employee benefits program is an important and meaningful part of the compensation employees receive. Review more information at BNL | Benefits Program

Overview

Brookhaven National Laboratory is seeking an experienced and detail-orientedSenior Technology Engineer with emphasis on database administration skills and experience. As a member of the Applicationsdepartment within the Information Technology Division (ITD), this role is ideal for a candidate who thrives in a dynamic environment and has a strong track record of managing, optimizing, and securing enterprise-level databases.

Reporting to a group manager within the ITD Applications department, the DBA will support multiple development and production environments across bothMicrosoft SQL Server and Oracledatabase platforms. Broad responsibilities include managing database performance, ensuring data integrity and availability, and collaborating with software development teams to support application needs. The DBA will also contribute to strategic planning and execution of database and application-related projects and modernization initiatives.

ITD Mission

Brookhaven Lab's Information Technology Division's (ITD) mission is to deliver safe, efficient operations that ensure the delivery of the Lab's research mission by:

• Developing and deploying state-of-the-art information and computing systems in support of scientific research and business operations
• Providing a reliable and secure, high-speed network infrastructure for scientific and business computing
• Developing a scientific computing infrastructure that can support the computing needs that are common among the scientific departments
• Providing support to scientific and administrative programs to help them address their unique computing problems
• Providing a cost-effective, highly reliable, secure, and standardized computing infrastructure
• Promoting best practices in the areas of platform support, application development, and customer service
• Providing cost-effective information services to the Brookhaven Lab community including Research Library, publications, records management, and technical editing services, in support of the research mission and in compliance with contractual requirements

ITD includes experts in information technology (IT) infrastructure and operations, cyber security, business systems, data information, and information services, including records management and the Research Library. The ideal candidate is an excellent communicator who is resourceful and innovative, and who understands that collaboration with stakeholders from across the Laboratory is critical to ensure the right expertise and technology are in place to advance our mission of bringing science solutions to the world.

Essential Duties and Responsibilities

• Administer, monitor, and maintainSQL Server and Oracledatabases in development, test, and production environments
• Perform installation, configuration, tuning, security hardening, capacity planning, and performance optimization of databases in conjunction with application developers and vendors
• Implement and maintain database backup and recovery strategies
• Collaborate with application developers to design and optimize database schemas, queries, and stored procedures
• Collaborate with application developers and vendors on debugging, performance management, and scalability issues
• Support data integration and migration efforts across multiple systems
• Implement strategies to ensure high system availability and redundancy, including disaster recovery testing and readiness
• Act as a strategic leader for database and data management technologies, providing technical insight and guidance to senior leaders and team members
• Maintain strong documentation practices, including database configuration, procedures, and standards
• Stay current with emerging database technologies and best practices
• Participate in audits and compliance reviews as needed

Required Knowledge, Skills, and Abilities

• Bachelor's degree, preferably in Computer Science, Information Systems, or related field (or equivalent experience on a basis of 2:1)
• 8+ years of relevant experiencein database administration
• Proven experience withMicrosoft SQL ServerandOracledatabase management and administration
• Strong understanding of database architecture, indexing, and performance tuning
• Experience with backup and recovery tools
• Proficiency in writing and optimizing SQL queries, stored procedures, and triggers
• Experience with database monitoring tools and automation scripts
• Ability to manage multiple priorities and work collaboratively with cross-functional teams
• Strong problem-solving and analytical skills
• Excellent verbal and written communication skills and documentation abilities
• Strong time management and project organization skills
• Ability to manage and prioritize multiple projects simultaneously

Preferred Qualifications

• Certifications such asMicrosoft Certified: Azure Database Administrator Associate,Oracle Certified Professional (OCP), or equivalent
• Experience withcloud-based database services(e.g., Microsoft Azure SQL, Oracle Cloud)
• Experience supporting enterprise applications and integrations
• Experience usingAzure DevOpsfor collaboration, work tracking, and deployment pipelines
• Exposure to Agile methodologies

Other Information

• This is a remote position with on-site presence available at BNL in Upton, NY

• Visa Sponsorship is not available for this position

Brookhaven Laboratory is committed to providing fair, equitable and competitive compensation. The full salary range for this position is $109150 - $182000/year. Salary offers will be commensurate with the final candidate's qualification, education and experience and considered with the internal peer group.

Brookhaven National Laboratory requires all non-badged personnel including visitors to produce a REAL-ID or REAL-ID compliant documentation to access Brookhaven National Laboratory - view more information atwww.bnl.gov/real-id. This is due to nationwide identification requirements for federal site access as required by the federalREAL ID Act. Those not in possession of a REAL ID-compliant document will not be permitted to access the site which includes access to the Laboratory for interviews.

About Us

Brookhaven National Laboratory (www.bnl.gov) delivers discovery science and transformative technology to power and secure the nation's future. Brookhaven Lab is a multidisciplinary laboratory with seven Nobel Prize-winning discoveries, 37 R&D 100 Awards, and more than 70 years of pioneering research. The Lab is primarily supported by the U.S. Department of Energy's (DOE) Office of Science. Brookhaven Science Associates (BSA) operates and manages the Laboratory for DOE. BSA is a partnership between Battelle and The Research Foundation for the State University of New York on behalf of Stony Brook University. BSA salutes our veterans and active military members with careers that leverage the skills and unique experience they gained while serving our country, learn more at BNL | Opportunities for Veterans at Brookhaven National Laboratory.

Equal Opportunity/Affirmative Action Employer

Guided by our core values of integrity, responsibility, innovation, respect, and teamwork, Brookhaven Science Associates is an Equal Employment Opportunity Employer-Vets/Disabled. We are committed to fostering a respectful and collaborative environment that fuels scientific discovery. We consider all qualified applicants without regard to any characteristic protected by law. All qualified individuals are encouraged to apply. We ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation. *VEVRAA Federal Contractor

BSA employees are subject to restrictions related to participation in Foreign Government Talent Recruitment Programs, as defined and detailed in United States Department of Energy Order 486.1A. You will be asked to disclose any such participation at the time of hire for review by Brookhaven. The full text of the Order may be found at:https://www.directives.doe.gov/directives-documents/400-series/0486.1-BOrder-a/@@images/file