Database Administrator - SQL (Intermediate)

Oneida Technical Solutions•Fort Belvoir, VA

15h

About The Position

Oneida Technical Solutions, LLC (OTS), was founded in 2014 and quickly established itself as a reliable partner capable of providing a variety of information technology and cyber solutions across highly complex, highly regulated and highly secure environments, including the U.S. Department of Defense (DoD), healthcare, higher education, law enforcement, retail, casino gaming and more. Our innovative cyber capabilities and programs have made us trusted partners for IT modernization projects, implementing upgrades and accelerating the delivery of new solutions for the DoD and commercial industries with consumer-driven technology. In support of the U.S. Army Network Enterprise Technology Command (NETCOM) and the Regional NetworkEnterprise Center for the National Capital Region (RNEC-NCR), we are currently seeking a Database Administrator - SQL (Intermediate). Qualified candidates will possess a Bachelor's degree in a related field and a minimum of 4 years relevant experience. A combination of experience and training may be considered in lieu of a degree. Prior to hire you must provide evidence of an MCSA: SQL 2016 Database Administration Certificate, a Windows Server Administration Fundamentals Certification as well as a qualifying IAT-Level II Certification. Secret Clearance is required for this role. Duties surrounding this role include, but are not limited to: Administer the Microsoft SQL Server production and databases and perform Windows system administration in support of SQL Database environment. The Contractor shall have the ability to follow and understand technical documents, strong troubleshooting skills, strong oral and written communication, and have attention to detail. Install, configure, maintain, and troubleshoot Microsoft SQL Server 2016, 2019 and above production and development databases and client interfaces. Configure and maintain security and settings on SQL Servers in accordance with best practices, Army policies, and DoD standards (Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs)). Be knowledgeable in DISA STIGs for Windows Server and database servers (SQL Server and/or Oracle). Install, configure, and maintain SQL Server Failover Clusters. Research, test, and install SQL Server service packs and cumulative updates. Have experience withTransact structured query language (TSQL), including implementing STIG and custom solutions for index maintenance. Maintain, monitor, and troubleshoot performance - SQL Server and database performance tuning. Monitor, troubleshoot, and repair software and hardware issues. Have experience with virtualized environments, specifically with VMware. Create, maintain up-to-date documentation of SQL Server related procedures and processes. Ensure 90% data availability of the production and development databases. Assess and deploy appropriate patches to SQL Server databases. Troubleshoot and resolve various problems concerning production and development of enterprise databases. Plan, coordinate, and perform the backup, restoration, and recovery of production enterprise databases utilizing the SQL backup utilities. Monitor system storage and resolve storage issues affecting database performance. Provide input into plans for infrastructure growth. Identify and mitigate security vulnerabilities and risks concerning production databases. Operate and administer data warehouse systems. Administer and maintain all aspects of the production MS SQL Server and/or ORACLE, databases, and any updated software versions. Apply Microsoft updates to assigned servers to maintain OS security and integrity; update virus software as required. Check server event logs daily and resolve issues. Provide technical support for critical database failures on a 24-hour, seven-day-a week basis as defined in the local SOP and as directed by the COR. Maintain RMF related artifacts and documents updated in eMASS Oneida Technical Solutions, LLC. is an equal opportunity employer and will consider all qualified applicants for employment without regard to race, color, religion, sex, national origin, age, disability, marital status, veteran status, sexual orientation, gender identity, genetic information or any other protected characteristic under applicable law.

Requirements

Bachelor's degree in a related field and a minimum of 4 years relevant experience. A combination of experience and training may be considered in lieu of a degree.
Prior to hire you must provide evidence of an MCSA: SQL 2016 Database Administration Certificate, a Windows Server Administration Fundamentals Certification as well as a qualifying IAT-Level II Certification.
Secret Clearance is required for this role.
The Contractor shall have the ability to follow and understand technical documents, strong troubleshooting skills, strong oral and written communication, and have attention to detail.
Be knowledgeable in DISA STIGs for Windows Server and database servers (SQL Server and/or Oracle).
Have experience withTransact structured query language (TSQL), including implementing STIG and custom solutions for index maintenance.
Have experience with virtualized environments, specifically with VMware.

Responsibilities

Administer the Microsoft SQL Server production and databases and perform Windows system administration in support of SQL Database environment.
Install, configure, maintain, and troubleshoot Microsoft SQL Server 2016, 2019 and above production and development databases and client interfaces.
Configure and maintain security and settings on SQL Servers in accordance with best practices, Army policies, and DoD standards (Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs)).
Install, configure, and maintain SQL Server Failover Clusters.
Research, test, and install SQL Server service packs and cumulative updates.
Maintain, monitor, and troubleshoot performance - SQL Server and database performance tuning.
Monitor, troubleshoot, and repair software and hardware issues.
Create, maintain up-to-date documentation of SQL Server related procedures and processes.
Ensure 90% data availability of the production and development databases.
Assess and deploy appropriate patches to SQL Server databases.
Troubleshoot and resolve various problems concerning production and development of enterprise databases.
Plan, coordinate, and perform the backup, restoration, and recovery of production enterprise databases utilizing the SQL backup utilities.
Monitor system storage and resolve storage issues affecting database performance.
Provide input into plans for infrastructure growth.
Identify and mitigate security vulnerabilities and risks concerning production databases.
Operate and administer data warehouse systems.
Administer and maintain all aspects of the production MS SQL Server and/or ORACLE, databases, and any updated software versions.
Apply Microsoft updates to assigned servers to maintain OS security and integrity; update virus software as required.
Check server event logs daily and resolve issues.
Provide technical support for critical database failures on a 24-hour, seven-day-a week basis as defined in the local SOP and as directed by the COR.
Maintain RMF related artifacts and documents updated in eMASS