DCS is seeking an experienced Database Engineer to join our team supporting the Army SMART software suite.
Essential Job Functions:
Lead performance monitoring and tuning of assigned projects and communicate with other teams for identifying root cause of all database related issues. Proactively support ongoing maintenance, backup/ recovery, security, auditing and production support.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
Assist developers with complex query tuning and schema refinement.
Routinely evaluates/ implements improved methods or processes for administering and maintaining databases and servers.
Perform scheduled maintenance and support release deployment activities after-hours.
Participate in design and architecture review of the databases and applications. Lead efforts with database topology review and communicate with multiple teams to finalize optimal design for databases and applications.
Serve as escalation point for troubleshooting minor to major problems on an as-needed basis; often requiring time sensitive response and proactive communication to different groups within the organizations’ Requirements.
Contribute to the creation of processes, procedures and standards for SQL Server database administration that supports the use of optimal database server resources and performance to minimize potential downtime scenarios.
Defining requirements for automating routine database service delivery processes and collaborating with peers to develop and enhance existing database service delivery automation solutions.
Implements and maintains automated database maintenance plans and backup routines using standard methodologies.
Travel periodically to customer sites to interface directly with customer / users, maintain databases, and resolve database issues.
Due to the sensitivity of customer related requirements, U.S. Citizenship is required.
Bachelor's degree plus 8 years of experience administering Microsoft SQL Server databases.
Ability to obtain Secret Clearance within 6- 9 months of hire date.
Ability to work with a geographically-distributed team.
Advanced skills in resolving database locking conflicts/blocking and resource utilization contention.
Ability to work with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics. Demonstrate ability to solve complex database administration problems.
Software development experience beyond Microsoft SQL is a plus
Knowledge and familiarity with Git
Knowledge and familiarity with Microsoft Azure DevOps
Knowledge and understanding of logistics and fielding equipment needs of US Army soldiers