SQL Database Administrator

- Mid Level

Crane, TX

About the position

Resource Management Concepts, Inc. (RMC) provides high-quality, professional services to government and commercial sectors. Our mission is to deliver exceptional management and technology solutions supporting the protection and preservation of the people and environment of the United States of America. RMC is hiring for a SQL Database Administrator to support one of our government customers at NSWC Crane. The selected applicant will work as part of an integrated team including system administrators, network engineers, software developers, service desk analysts, and other personnel on-site. The successful candidate will perform in a fast pace environment in the capacity of upgrades/migrations; instance/database hardening and supporting system accreditation activities; application and database troubleshooting; code review to include (evaluating the implications of using stored procedures and constraints to implement business rules), database design/development, optimize performance, recommend and implement process improvement technologies.

Responsibilities

• Perform upgrades and migrations of SQL databases.
• Implement instance/database hardening and support system accreditation activities.
• Troubleshoot applications and databases.
• Conduct code reviews, including evaluating stored procedures and constraints.
• Design and develop databases, optimizing performance.
• Recommend and implement process improvement technologies.

Requirements

• Minimum of seven (7) years DBA experience with Microsoft SQL Server (2008R2, 2012, 2014, 2016, 2017, 2019) and Azure SQL Database (PAAS, IAAS, DAAS) in Production Q/A and Test, and Development environments.
• Experience with T-SQL and PowerShell Scripting – query writing, indexing and DB I/O performance tuning, Stored Procedures, functions and views, customization coding, data models & Entity Relationships Diagrams (ERDs).
• Experience implementing and supporting highly available SQL Server environments, including experience with Failover Cluster and Always-On.
• Experience with SQL Server troubleshooting, performance tuning, issues monitoring and resolution, to include extended events and performance monitoring.
• Experience with Azure Cloud and Database Service, to include Windows and Linux environments.
• Experience with reporting, integration, and/or analysis services.
• Knowledge and experience in high availability and disaster recovery (HADR) principles and practices, to include planning, testing, backup/restore using disk-based backup solutions.
• Strong communication, interpersonal and human relations skills to interact with clients.
• Strong analytical and problem-solving skills.
• Ability to pay meticulous attention to detail.
• Ability to work collaboratively on multi-disciplinary teams.

Nice-to-haves

• MS Azure Database Administrator Associate Certification (DP-300) is strongly desired.
• DoD Level 3 (CASP, CISSP, or equivalent) certification is required.

Benefits

• Competitive paid vacation package with 11 paid federal holidays.
• High-quality, low-deductible healthcare plans.
• Pet insurance.
• Competitive 401K package.
• Tuition assistance and certifications for career growth.