Be a part of the men and women that solve some of the worlds most complex technical challenges! General Dynamics Information Technology (GDIT) is seeking a Sr. SQL Database Analyst to support the Navy Surface Warfare Center in Crane, Indiana.
If you are seeking an opportunity to support our nations military, work at one of the largest naval bases in the US, live in a place with low cost of living, low crime and on a program that has many excellent opportunities within a Fortune 100 company - then this position is perfect for you!
Contributes to the improvement and creation of DBA policies, procedures, and standards
Providing technical guidance for integration, testing, design, development, planning of new major, large scale, production systems/databases
Diagnosing highly complex and integrated systems/databases such as system configuration, application design and application code
Structured approach in problem resolution
Conducts research and prepares recommendations for database tools, software, and/or hardware requirements.
Provides database assistance and problem support to application developers, business analysts, and business users.
Analyzes system performance to plan for capacity management and scalability.
Development of SQL procedures, triggers, views, functions, and reports to support enhancement to critical SQL based business systems.
Analyze, troubleshoot, and remediate data integrity issues.
Monitor systems and proactively manages and maintains configurations to ensure performance, availability, and stability.
Submits recommendations for solutions that require the definition of the physical structure and functional capabilities of databases and require data security and data backup and recovery specifications.
BS degree: additional years of experience may be considered in lieu of degree
5+ years of directly related experience in database administration and analysis
Extensive knowledge of Microsoft SQL Server 2016 & 2017 (2019 a plus).
In depth knowledge of SQL internals (latches, system waits, resource allocation, data dictionary, table and index storage and access parameters)
Advanced T-SQL skills
Strong Microsoft SQL query optimization and index management.
Adept at Transactional Replication, including setup, troubleshooting, and creating replication scripts.
Strong understanding of Windows Clustering, Always-On, and Partitioning.
Able to implement Disaster Recovery methods.
Experience with 3rd Party monitoring tools, including but not limited to SQL Sentry Monitoring and SolarWinds Database Performance Analyzer (DPA).
Ability to review developer code to assure SQL best practices and to identify areas of inefficient query structures.
Defining database architectures and strategies to meet application availability, scalability, and performance requirements
Understanding of back end, server, and API development, including application and database/data development and architectures.
SECRET security clearance
This position requires being fully vaccinated against COVID-19 by January 18, 2022 or the start date, if after January 18. Individuals who work in or reside in Texas or Montana or work outside of the United States may be excluded from this requirement.
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.