Participates in the design, maintenance, enhancement, coding, and administration of relational databases
Performs day-to-day SQL administration; maintenance, troubleshooting, repair, ensuring data availability
Performs Database Backup and Recovery functions as needed
Installs SQL SW, Instances and perform upgrades and patching as needed
Writes/maintains SQL scripts and processes as needed
Creates indexes to enhance performance
Designs/implements data transfer processes needed to support upgrades or movement to from different physical/virtual Machine/OS
Authors/maintains System Security Plans, white papers and change management proposals, SOPs
Creates, manages and performs troubleshooting Windows Clustering and SQL Server high-availability solutions
Creates and monitors SQL Server Policy Objects
Analyzes and determines information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.
Coordinates new data development ensuring consistency and integration with existing data warehouse structure.
Monitors Ticketing System queue for DBA assignments
Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.
Assignments may include design of data dictionaries, database structure and layout, installing, upgrading, and managing database applications.
May provide guidance and work leadership to less-experienced Analysts.
Stay current on vendors' best security practices in relation to organizational requirements.
Maintains current knowledge of relevant technologies as assigned.
Monitors SQL Event Logs and use to identify/troubleshoot issues
Creating and managing SQL Server Maintenance Plans for routine tasks and backup solutions as well as ability to create, troubleshoot and monitor SQL Server Agent jobs
Reviews database jobs, backup logs, user connections and system memory
Reviews performance information for SQL instances
Completes STIG Checklists for SQL servers
Bachelor Degree in Computer Science or a related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience required.
Experience with Microsoft SQL Server in Microsoft clusters.
Hands-on STIG/SCAP experience required.
Active DOD Secret clearance required; SSBI required.
Current Security+ certification required.
Microsoft SQL 2012+ and MySQL administration
Microsoft Operating Systems (Windows Server 2008/2012, Windows 10 SHB, etc.) a plus
T-SQL scripting knowledge
PowerShell a plus
Understanding of IT Security best practices to meet DOD STIGs
EDUCATION AND EXPERIENCE: BA/BS or equivalent, 5+ years of experience
About Our Work
We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.
GDIT does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.