Geospatial And Cloud Analytics Inc
SQL Database Administrator Secret clearance
Geospatial And Cloud Analytics Inc - Quantico, Virginia, United States, 22134
Work at Geospatial And Cloud Analytics Inc
Overview
- View job
Overview
Transform technology into opportunity as a SQL Database Administrator with GCA. A career in enterprise IT means connecting and enhancing the systems that matter most. At GCA youll be at the forefront of innovation and play a meaningful part in improving how agencies operate.
Our work depends on a SQL Database Administrator joining our IT Technology Development division in Quantico, VA.
HOW OUR SQL DATABASE ADMINISTRATOR WILL MAKE AN IMPACT:
As the SQL DBA Administrator, you will manage all current and planned SQL Server databases that support our customers COTS applications. You will also be part of a team of systems administrators managing Windows Server 2016-2019, desktops, and printers. In addition: You will be responsible for the operations and maintenance of these databases. If additional databases are required in the future, you will be responsible for designing, planning, and implementing those databases, including database creation, security, access, backup and recovery, and documentation. You must be experienced with applying STIGs to SQL Server databases and be familiar with the impacts on the related applications. You must have excellent documentation skills, and will be responsible for creating related standards, operating procedures, and security documentation. Database monitoring, maintenance, troubleshooting, and tuning. Perform administration and management of Microsoft SQL Server 2012-2019 and Microsoft SQL Reporting Services. Familiar with SQL Always-on setup and management and Microsoft Failover Clustering. Perform day-to-day monitoring and maintenance of SQL Server databases. Perform database and system performance monitoring and troubleshooting. Database backup and recovery - Develop, document, and apply procedures for database backup and recovery. Perform scheduled and nonscheduled database backups and recovery with Microsoft SQL Server SSMS, or SQL CMD. Participate in the analysis of database solutions - Responsible for the definition, design, creation, and implementation of a database environment with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security. Evaluate and install new software releases, patches, and system upgrades. Identify and troubleshoot system issues. Develop, document, and apply procedures for systems backup and recovery. May program in an administrative language (PowerShell, VBS, etc.). Perform ACAS and SCAP scans and remediation. Assist Tier 2 help desk with issues elevated to systems administrators. Create and update user accounts, perform accounts management in Active Directory. Support the Certification and Accreditation process - run scans; resolve findings; document solutions, workarounds or provide justifications for exceptions. Document, implement, and maintain database security policies in accordance with DISA STIG requirements. Define and oversee database standards, controls, procedures, and documentation. Create all documentation required for Release Management Framework (RMF). Complete planning and documentation prior to new integration or implementation. Other SQL DBA duties as assigned. WHAT YOULL NEED TO SUCCEED (Required):
Security Clearance Level: Active Secret clearance; Must be able to obtain a Top Secret clearance. 5+ years of work experience administering MS SQL Server databases (SQL 2012 or newer). Experience with Transparent Data Encryption (TDE) and Secure Socket Layer (SSL) encryption in SQL Server. Experience administering SQL Server 2012-2019. Required Certifications: Security+ CE. Education: BS degree; additional years of experience may be considered in lieu of degree. Location: Onsite at Quantico, VA. US Citizenship required. WHAT WE'D LOVE FOR YOU TO HAVE (Preferred):
Active Top Secret clearance. Microsoft Server 2016 or higher. Microsoft SQL 2016 -2019. GCA is a Small Disadvantaged Veteran Owned company supporting several government contracts. GCA is pleased to offer a competitive benefits package to all full-time employees. Below is a brief overview of our benefits package: Competitive Compensation Paid Time off includes 10 federal holidays and 15 additional days. Bereavement Leave Parental Leave PTO Cash out Company Paid STD and LTD Life and AD&D Insurance Medical, Prescription, Dental, and Vision Coverage 401k Savings and company match Employee referral program GCA is committed to a safer tomorrow. The challenges facing our Nation and the World grow ever more complex and require the highest level of dedication, integrity, and service. These core values are the backbone GCA builds upon to provide our customers with exceptional service within the dynamic intelligence community and ever-changing Information Technology sector. #J-18808-Ljbffr
As the SQL DBA Administrator, you will manage all current and planned SQL Server databases that support our customers COTS applications. You will also be part of a team of systems administrators managing Windows Server 2016-2019, desktops, and printers. In addition: You will be responsible for the operations and maintenance of these databases. If additional databases are required in the future, you will be responsible for designing, planning, and implementing those databases, including database creation, security, access, backup and recovery, and documentation. You must be experienced with applying STIGs to SQL Server databases and be familiar with the impacts on the related applications. You must have excellent documentation skills, and will be responsible for creating related standards, operating procedures, and security documentation. Database monitoring, maintenance, troubleshooting, and tuning. Perform administration and management of Microsoft SQL Server 2012-2019 and Microsoft SQL Reporting Services. Familiar with SQL Always-on setup and management and Microsoft Failover Clustering. Perform day-to-day monitoring and maintenance of SQL Server databases. Perform database and system performance monitoring and troubleshooting. Database backup and recovery - Develop, document, and apply procedures for database backup and recovery. Perform scheduled and nonscheduled database backups and recovery with Microsoft SQL Server SSMS, or SQL CMD. Participate in the analysis of database solutions - Responsible for the definition, design, creation, and implementation of a database environment with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security. Evaluate and install new software releases, patches, and system upgrades. Identify and troubleshoot system issues. Develop, document, and apply procedures for systems backup and recovery. May program in an administrative language (PowerShell, VBS, etc.). Perform ACAS and SCAP scans and remediation. Assist Tier 2 help desk with issues elevated to systems administrators. Create and update user accounts, perform accounts management in Active Directory. Support the Certification and Accreditation process - run scans; resolve findings; document solutions, workarounds or provide justifications for exceptions. Document, implement, and maintain database security policies in accordance with DISA STIG requirements. Define and oversee database standards, controls, procedures, and documentation. Create all documentation required for Release Management Framework (RMF). Complete planning and documentation prior to new integration or implementation. Other SQL DBA duties as assigned. WHAT YOULL NEED TO SUCCEED (Required):
Security Clearance Level: Active Secret clearance; Must be able to obtain a Top Secret clearance. 5+ years of work experience administering MS SQL Server databases (SQL 2012 or newer). Experience with Transparent Data Encryption (TDE) and Secure Socket Layer (SSL) encryption in SQL Server. Experience administering SQL Server 2012-2019. Required Certifications: Security+ CE. Education: BS degree; additional years of experience may be considered in lieu of degree. Location: Onsite at Quantico, VA. US Citizenship required. WHAT WE'D LOVE FOR YOU TO HAVE (Preferred):
Active Top Secret clearance. Microsoft Server 2016 or higher. Microsoft SQL 2016 -2019. GCA is a Small Disadvantaged Veteran Owned company supporting several government contracts. GCA is pleased to offer a competitive benefits package to all full-time employees. Below is a brief overview of our benefits package: Competitive Compensation Paid Time off includes 10 federal holidays and 15 additional days. Bereavement Leave Parental Leave PTO Cash out Company Paid STD and LTD Life and AD&D Insurance Medical, Prescription, Dental, and Vision Coverage 401k Savings and company match Employee referral program GCA is committed to a safer tomorrow. The challenges facing our Nation and the World grow ever more complex and require the highest level of dedication, integrity, and service. These core values are the backbone GCA builds upon to provide our customers with exceptional service within the dynamic intelligence community and ever-changing Information Technology sector. #J-18808-Ljbffr