Database Management Specialist

General Dynamics Information Technology•Washington, DC

7d•$122,275 - $165,431•Hybrid

About The Position

General Dynamics Information Technology (GDIT) is seeking a senior database management specialist to support a critical enterprise application for the Administrative Office of the US Courts. The application includes more than 100 sub-applications. The role also supports other applications and development efforts as needed, as part of a 76-person team providing systems development, operational and infrastructure support, and application support. The specialist provides dedicated operations and maintenance and technical support, including Tier III critical-issue response and resolution, database and production monitoring, and daily operational support for system components and ancillary environments. The role includes diagnosing application and system issues, coordinating with technical subject-matter experts, maintaining system documentation, communicating system changes to varied audiences, and providing recommendations for technical best practices, cost savings, and process improvements. The position uses shared AO software development lifecycle resources, including Jira and Confluence, and may provide Tier II support as required.

Requirements

At least five years of related experience.
At least five years of database administration experience with Microsoft SQL Server and MySQL relational database management systems.
At least five years of experience designing, creating, and supporting data warehouses.
At least five years of relevant operations and maintenance support experience with a major federal IT system.
BA/BS degree with 10 or more years of directly related IT experience, or MA/MS degree with 7 or more years of directly related IT experience.
Proficiency installing, configuring, upgrading, and migrating SQL Server instances.
Advanced Transact-SQL skills for querying, scripting automation, and writing stored procedures and triggers.
Experience designing backup and recovery strategies to meet Recovery Time Objectives and Recovery Point Objectives, including full, differential, and transaction-log backups.
Expertise in query optimization, index management, and execution-plan analysis to resolve performance bottlenecks.
Experience implementing role-based access control, managing permissions, and ensuring data encryption at rest and in transit.
Proficiency with SQL Server Management Studio (SSMS), MySQL Workbench, SQL Server Integration Services (ETL), SQL Profiler, Performance Monitor, Activity Monitor, Dynamic Management Views, and Extended Events.
Knowledge of software development lifecycle (SDLC) principles and practices and Agile methodologies.
Excellent written and verbal communication 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.

Nice To Haves

Experience with pay or budgeting and financial business rules and systems.
Familiarity with Linux administration, including permissions, SELinux, running scripts, cron jobs, mounting drives, and firewall rules.
Familiarity with code editors such as Microsoft Visual Studio Code and creating SSIS packages.
Windows administration and Veritas NetBackup experience, including file shares and mounted drives.
Proficiency with business tools such as Word, Excel, PowerPoint, Visio, SharePoint, and Teams.
Familiarity with open-source applications such as LAMP.
Familiarity with Ansible and Git.
Familiarity with Bash, YAML, Python, and PHP.
Experience with Extract/Transform/Load (ETL).
Experience working in a load-balanced environment.
Understanding of IT practices, service management, governance frameworks, and industry standards such as ITIL, ITSM, COBIT, and ISO.
Working knowledge of IT tracking tools, preferably ServiceNow and Jira.

Responsibilities

Respond to and resolve critical Tier III issues by identifying, researching, and diagnosing reported application problems, and coordinating with development, database, network, and other Tier III resources.
Monitor database servers daily for performance and health, full and transaction-log backups, scheduled-job status, available disk storage, and database availability.
Monitor production schedules, interfaces, outputs, process and system exceptions, and other operational activities to verify correct operation.
Provide daily operations support for system components, including the web application, operating system, and file management.
Maintain ancillary environments, including Production, Development, Stage, UAT, Demo, and Help desk.
Update existing system and technical documentation and create business process flow documents, as-is and to-be process flows, technical write-ups, and standard operating procedures.
Recommend and update system functional requirements based on process analysis.
Create communications about system changes for audiences including ASO management, other Directorates, court unit management, and end users.
Coordinate resolution of security-scan findings to meet defined and evolving standards.
Develop solutions in accordance with US Courts and ASO policies and procedures.
Recommend technical best practices and identify opportunities for government cost savings and process improvements.
Use shared AO SDLC resources, including Jira and Confluence.
Document status and report task work hours daily.
Provide Tier II support as required and perform other duties as assigned.
Interact with end users on a case-by-case basis.