Database Management Specialist

General Dynamics Information Technology (GDIT) is a premier provider of high‑tech IT solutions to the federal government IT market. Duties and Responsibilities Critical issue (Tier III) response and resolution services. Identify, research, and resolve reported application issues, including diagnosing the nature of the user or system issue and coordinating additional Tier III resources such as development, database, and network SMEs. Daily monitoring of all database servers for performance, system health status, backup processing, scheduled job status, disk storage, and database availability. Daily monitoring of production schedules, interfaces, outputs, process/system exceptions, and other operational activities to verify correct operation. Problem‑solving: diagnose complex system failures under pressure. Communication: explain technical concepts to non‑technical stakeholders and document procedures clearly. Daily operations support for all system components (web application, operating system, file management). Daily maintenance of all ancillary environments (Production, Development, Stage, UAT, Demo, Help desk). Update system and technical documentation; create new business process flow documents and as‑is/to‑be process flows. Recommend and update system functional requirements based on process analysis. Provide technical write‑ups and SOPs. Create communications about system changes tailored to various audiences including ASO management, other Directorates, court unit management, and end users. Coordinate to resolve security scan findings to adhere to defined and evolving standards. Develop solutions in accordance with US Courts and ASO policies and procedures. Provide subject‑matter expertise recommendations for technical best practices, cost savings, and process improvements to the government. Use the shared SDLC resources provided by the AO, including Jira and Confluence. Document status and report work hours on tasks daily. Provide Tier II support as required and other duties as assigned. Interact with end users on a case‑by‑case basis. Desired Qualifications, Experience, and Competencies Five (5) plus years of experience with Database Administration in Microsoft SQL Server and MySQL relational database management systems. Five (5) plus years of experience with design, creation, and support of data warehouses. Five (5) plus years of relevant operations and maintenance support experience with a major federal IT system. Experience with pay or budgeting and financial business rules and systems. Experience and knowledge in principles and practices of SDLC and Agile methodologies. Familiar with Linux administration (permissions, SE Linux, scripts, cron jobs, mounting drives, firewall rules). Familiarization using code editors such as Microsoft Visual Studio Code and creating SSIS packages. Windows administration and Veritas NetBackup experience (file shares/mounted drives). Proficiency in business tools such as Word, Excel, PowerPoint, Visio, SharePoint, Teams, etc. Excellent written and verbal skills. Ability to work independently and as part of a larger team. Ability to analyze complex data and present findings clearly and understandably. Ability to present recommendations for consideration and influence as needed. Familiarization with open‑source applications, e.g., LAMP. Familiarization with Ansible and Git. Familiarization with Bash, YAML, Python, and PHP. Windows administration experience (file shares/mounted drives). Experience working with MySQL database. Experience with ETL. Experience working in a load‑balanced environment. Understanding of IT practices, service management, governance frameworks, and industry standards (ITIL, ITSM, COBIT, ISO). Proficiency in business tools such as Word, Excel, PowerPoint, Visio, SharePoint, Teams, etc. Core Technical Skills Database Administration: proficiency in installing, configuring, upgrading, and migrating SQL Server instances. T‑SQL Proficiency: advanced knowledge of Transact‑SQL for querying, scripting automation, and writing stored procedures and triggers. Backup & Recovery: designing strategies to meet RTO and RPO through full, differential, and transaction log backups. Performance Tuning: expertise in query optimization, index management, and analyzing execution plans to resolve bottlenecks. Security Management: implementing role‑based access control, managing permissions, and ensuring data encryption (at rest and in transit). Essential Tools: mastery of SSMS, MySQL Workbench, SSIS, SQL Profiler, Performance Monitor, Activity Monitor, Dynamic Management Views and Extended Events. Specialized Experience Working knowledge of IT tracking tools, preferably ServiceNow and Jira. Education and Experience Requirements BA/BS with 10+ years of directly related IT experience (or MA/MS with 7+ years of directly related IT experience). #J-18808-Ljbffr General Dynamics Information Technology