Job Description
Description CLGT Solutions, LLC dba CLOVEHITCH is a Service-Disabled Veteran-Owned small mission-focused business that provides professional solutions in the areas of intelligence, financial management, linguistics and administrative functions.
CLOVEHITCH is seeking a Senior SQL Database Administrator to manage and maintain Microsoft SQL Server environments supporting enterprise .NET applications, ensuring high availability, performance, security, and data integrity across production, staging, and integration systems. This individual will monitor daily operations, implement compliance and backup/recovery processes, optimize databases, support development teams, and provide documentation, reporting, and rapid incident response to meet organizational uptime and security requirements. This position is contingent upon contract award.
Supervisory Responsibilities: N/A
Principal Duties and Responsibilities: - Provide database administration and management support for Relational Database Management Systems (RDMS) in a Microsoft SQL Server-based environment hosting databases across the supported networks for various .NET applications.
- Maintain quality of service and availability of client RDMSs by establishing and enforcing organizational defined standards ensuring the performance, integrity and security of databases through daily system checks with 100% of findings and statuses being recorded to client IT Portal.
- Ensure all SQL servers and instances have the latest Defense Information Systems Agency (DISA) STIGs applied within 30 days.
- Manipulate database objects and develop stored procedures, stored functions, and packages when needed based on customer requirements.
- Ensure healthy and reliable data replication is maintained using technologies such as availability groups, etc.
- Monitor performance and manage parameters to provide fast query responses to ‘front end’ users optimizing code and stored procedures while assisting application developers with database requirements.
- Configure and utilize database connectivity tools and utilities while supporting developers, programmers, and engineers during software development.
- Map out a conceptual design for database enhancements, considering both ‘back end’ organization of data and ‘front end’ accessibility for end user.
- Research, test, and implement new versions of the Database Management System (DBMS) for inclusion into client infrastructure as they become available.
- Implement security requirements for least privileged access to organizational databases and monitor user access and security.
- Develop and maintain database documentation to include updating existing and creating new Standard Operating Procedures, TTPs, logical architecture diagrams, entity relationship diagrams, server lists, and other database administration related documentation on monthly basis adhering to organizational templates and policies.
- Produce entity relationship and data flow diagrams, and database normalization schemas that are logical to physical data maps and data table parameters.
- Develop, manage, and test backup and recovery plans, ensuring that storage, archiving, backup, and recovery procedures are functioning correctly.
- Conduct capacity planning and assist with storage and architecture design.
- Review “Database Daily Checks” list on the client IT Portal and complete the Daily System Checks assigned.
- Review “Database Restore Checks” list on the client IT Portal and complete random testing.
Required Experience, Skills and Abilities: - Eight years of experience in SQL database administration supporting and managing databases in a production environment.
- Five years of experience installing, configuring, and supporting Microsoft SQL Server in High Availability Group configurations.
- Five years of experience with T-SQL and ability to write scripts, stored procedures, triggers, and views to automate maintenance functions.
- Three years of experience serving as a team leader working as both part of a team and independently to assign/review immediate tasks, set priorities, maintain task progress, validate team members’ work consistent with the organizational goals and deadlines.
- Three years of experience mentoring junior personnel on proper practices and procedures.
- Three years of experience planning and implementing security measures to safeguard information against accidental or unauthorized damage, modification or disclosure in accordance with industry best practices and DISA STIGs.
- Must have Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 or SQL Database Administration certification.
- Must have DoD 8140.03 IAT Level II / Intermediate certification.
Education and Other Requirements: - Due to federal contract requirements, this position is restricted to U.S. citizens who have an active TS/SCI clearance with ability to obtain a CI polygraph.
Preferred Qualifications: N/A Physical Demands N/A
Position Environment, Type & Hours of Work Full-time, Exempt
Travel This position may require travel.
CLOVEHITCH is an Equal Opportunity Employer. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, veteran status, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.
Job Tags
Full time, Contract work, Local area, Immediate start