Responsible for designing, planning, implementing, and administering databases, including security, access, and documentation. Also responsible the installation, configuration, administration and management of Microsoft SQL Server 2008R2 /2012 and Microsoft SQL Reporting Services 2008R2 /2012 . Monitor and optimize the performance of the production SQL databases. Provide support to development team throughout the Software Development Life Cycle (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.
Knowledge, Skills and Abilities
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 2012 STIGs
Experience with virtual environments (VMware/Hyper-V)
Solid understanding of Windows AD, DNS and Group Policy
Excellent communication skills including technical writing and the ability to work in a collaborative team environment
Ability and willingness to continue to expand knowledge and experience-base
Detail oriented and able to prioritize and complete assigned tasks within required deadlines
Exceptional problem solving and decision making capabilities, including troubleshooting technical issues, successfully resolving project issues and challenges, and developing creative solutions for process improvement and understanding user requirements
Bachelors Degree or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.
15+ years of related database analysis and/or administration experience.
ITIL v3 Certification preferred
DoDI 8570.01m Certification required
Microsoft SQL Certifications Preferred
" 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.