SQL DBA

Database Analyst Advisor

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.
 

Responsibilities 

• Will be responsible for the installation, configuration, administration and management of Microsoft SQL Server 2005/2008R2/2012  and Microsoft SQL Reporting Services 2005/2008R2/2012.  

• Must have a strong understanding of database schema object management, data modeling and architecture. 

• Will facilitate, implement, monitor and test database backups and recovery methodologies and processes. 

• Will monitor and optimize the performance of the production SQL server databases. 

• Responsible for database security, integrity, reliability, high availability and 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; verify efficient use of disk storage; optimize space allocation; prevent out-of-space situations; and proactively plan for increased capacity and scalability. 

• Participate in non-core business hours monthly patching. 

• Provide 24/7 on-call support on a rotational basis. 

Knowledge, Skills and Abilities 

• 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  

• Should have 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 include technical writing and the ability to work in a collaborative team. 

• Ability and willingness to continue to expand knowledge and experience; be detail oriented; and prioritize and complete assigned tasks within required deadlines. 

• Exceptional problem solving and decision making capabilities to include troubleshooting technical issues, resolving project issues and challenges, understanding user requirements and developing creative solutions for process improvement. 

• GDIT IS YOUR PLACE:
  ● 401K with company match
  ● Comprehensive health and wellness packages
  ● Internal mobility team dedicated to helping you own your career
  ● Professional growth opportunities including paid education and certifications
  ● Cutting-edge technology you can learn from
  ● Rest and recharge with paid vacation and holidays