Microsoft SQL Server
Own your opportunity to work with the largest government agency in the nation. Make an impact by advancing the Department of Defense’s mission to keep our country safe and secure.
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.
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
3 + years of related experience
* may vary based on technical training, certification(s), or degree
Less than 10%
U.S. Citizenship Required
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 does not have a vaccination mandate applicable to all employees. To protect the health and safety of its employees and to comply with customer requirements, however, GDIT may require employees in certain positions to be fully vaccinated against COVID-19. Vaccination requirements will depend on customer site requirements.
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.