Senior SQL Server Database Administrator
Senior SQL Server Database Administrator
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Senior SQL Server Database Administrator
Ft. Belvoir VA
CCHR24037The Senior SQL Server Database Administrator will administer the Microsoft SQL Server production and databases and perform Windows system administration in support of the SQL Database environment. The Senior SQL Server Database Administrator shall have the ability to follow and understand technical documents strong troubleshooting skills strong oral and written communication and attention to detail.
Duties and Responsibilities:
- Install configure maintain and troubleshoot Microsoft SQL Serverand above production and development databases and client interfaces.
- Configure and maintain security and settings on SQL Servers by 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 and maintain uptodate documentation of SQL Serverrelated procedures and processes.
- Ensure 90 data availability of the production and development databases.
- Assess and deploy appropriate patches to the SQL Server database.
- Troubleshoot and resolve various problems concerning the 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 any issues.
- Provide technical support for critical database failures on a 24hour sevendayaweek basis as defined in the local SOP and as directed by the COR.
- Maintain RMFrelated artifacts and documents updated in eMASS.
- World Wide Web (WWW) Server Support.
- Provide technical support for SharePoint Online portal and web collaboration access in the areas of systems administration. Web access shall be established via military NIPRNET and/or SIPRNET connectivity and other governmentprovided WAN connections. Allaccess to sensitive defense information will utilize the SSL and will require user authentication utilizing the DoD PKI.
- Follow Army directives in developing and deploying single signon technology.
- Other duties as assigned.
- BS in a related field
- 10 years of directly relevant experience may be substituted in lieu of education.
- Possess Baseline and Full Computing Environment Certifications for IATII IAW DoD 8570.01M and BBP 05PRM0002. MCSA: SQL 2016 Database Administration Certification required.
- Windows Server Administration Fundamentals certification required.
- Secret clearance Tier 5 investigation required.
Knowledge Skills and Abilities
- Knowledgeable of DISA STIGs for Windows Server and database servers (SQL Server and/or Oracle).
- Have experience with virtualized environments specifically with VMware.
- Have experience with Transact structured query language (TSQL) including implementing STIG and custom solutions for index maintenance.
- Have extensive knowledge of and experience with MS Access (relational database) design to include database definitions data models form/reporting/dashboard creation VBScript skills currently used in support of RNECNCR Resource Management (Billing Telephones EKMS etc.
- Have an extensive working knowledge of Adobe LiveCycle Designer including the creation and modification of forms and JavaScript.
Required Experience:
Senior IC
Employment Type
Full Time
