Responsible for designing, planning, implementing, and administering databases, including security, access, and documentation. Responsible the installation, configuration, administration and management of ServiceNow and Microsoft SQL Server and Microsoft SQL Reporting Services .
Other responsibilities include:
Monitor and optimize the performance of the production SQL databases. Provide support to development team throughout the Software Development lifecycle (SDLC).
Implement and troubleshoot triggers, views, stored procedures and data integrity constraints.
Ability to implement, maintain and troubleshoot SQL Server HA and database monitoring.
Identify and troubleshoot database issues and the ability to analyze, design, build, test and implement solutions.
Perform scheduled and nonscheduled database backups and recovery with Microsoft SQL Server SSMS, or SQL CMD.
Strong understanding of database schema object management, data modeling and architecture.
Expert understanding of Structured Query Language (SQL) and Transact-SQL (T-SQL).
Experience with SQL clustered environments.
Exposure to Resource Governor, Tuning Advisor, SQL Profiler and Windows Reliability and Performance Monitor.
Experience with applying DISA SQL STIGs. Experience with virtual environments (VMware/Hyper-V).
Solid understanding of Windows AD, DNS and Group Policy.
Three years of experience SQL Server 2016 in the High Availability Groups (HA)
Three years of experience with SQL Server 2016 Failover Cluster Instances (FCI)
Experience building SQL Server 2016 HA and FCI Instances remotely
Experience maintaining SQL Server 2016 databases that support SharePoint
Experience maintaining and installing database that support third party applications like SolarWinds, System Center (SC) Configuration Manager, and MS SC Operations Manager
Experience with network storage solutions
ServiceNow certifications a plus:
Certified Systems Administrator (CSA)
Certified Implementation Specialist (CIS)
Certified Application Developer (CAD)
Experience with MS Power BI and ability to extract data from MS Excel Workbooks and query SQL server databases
Education Requirements: Higher Education Degree in Information Technology, or related field; or commensurate level of experience based on position level (Associate, Journeyman, Senior, etc….)
Initial Clearance: Secret
Clearance: Top Secret with SCI eligibility
Shift Work: No; however, may be required to provide after-hours support
Travel: Less than 10%
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 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.