Deliver insights to help our clients turn data into action as a Database Analyst Advisor at GDIT. Your work will provide transformative solutions to our clients big-data obstacles and help advance the mission. Here, you can make a meaningful impact on our clients mission and on your career.
Will be responsible for theinstallation, configuration, administration and management of Microsoft SQL Server 2005/2008R2/2012and Microsoft SQL Reporting Services 2005/2008R2/2012.
Musthave a strong understanding of database schema object management, data modeling and architecture.
Willfacilitate, implement, monitorandtestdatabase backups andrecoverymethodologies and processes.
Will monitor and optimize the performance of the production SQLserverdatabases.
Responsible for database security, integrity, reliability,highavailabilityand disaster recovery solutions
Identify and troubleshoot database issues and the ability to analyze, design, build, test and implement solutions.
Implement and troubleshoot triggers, views, stored procedures and data integrity constraints.
Monitor file system space, database allocation;verifyefficient use of disk storage; optimize spaceallocation;preventout-of-space situations;and proactively plan for increased capacity and scalability.
Participate in non-core business hours monthly patching.
Provide 24/7 on-call supporton arotational basis.
WHAT YOULL NEED TO SUCCEED:
CITIZENSHIP: Must be a US Citizen
SECURITY CLEARANCE LEVEL: Must have a Secret to start and be able to obtain a TS/SCI
EDUCATION: BA/BS in computer science, information systems, or equivalent related field preferred
YEARS' EXPERIENCE: 5+ years of relevant experience
TECHNICAL SKILLS:
Expert understanding of Structured Query Language (SQL) and Transact-SQL (T-SQL).
Experience with virtual environments (preferably Hyper-V) and SQL clustered environments.
Experience with SQL server replication topologies.
Exposure to Resource Governor, Tuning Advisor, SQL Profiler and Windows Reliability and Performance Monitor
Shouldhave the ability to work in a dynamic fast paced environment that requires team interaction and coordination across multiple information technology teams.
Should have excellent communication skills to includetechnical writing and the ability to work in a collaborative team.
Ability and willingness to continue to expandknowledge and experience;be detail oriented;and prioritize and complete assigned tasks within required deadlines.
Exceptional problem solving and decision making capabilitiestoincludetroubleshooting technical issues, resolving project issues and challenges,understanding user requirementsand developing creative solutions for process improvement.
GDIT IS YOUR PLACE:
At GDIT, the mission is our purpose, and our people are at the center of everything we do.
Growth: AI-powered career tool that identifies career steps and learning opportunities
Support: An internal mobility team focused on helping you achieve your career goals
Rewards: Comprehensive benefits and wellness packages, 401K with company match, competitive pay and paid time off
Community: Award-winning culture of innovation and a military-friendly workplace.
