What are the responsibilities and job description for the Database SME position at ECS Federal, LLC?
ECS is seeking a Database SME to work in our Quantico, VA office.
Are you ready to play crucial role in supporting cutting-edge technology for federal law enforcement and scientific organizations with IT services and support for hardware, IT systems, applications, and operational technologies that support mission critical operations? ECS is seeking a highly skilled and motivated Database SME to support a strategic laboratory program in support of our DOJ FBI Client. The scope of this program is to enhance enterprise services and solutions to this FBI component, as part of an integrated evaluation, integration, strategy, design, implementation, and operational maintenance program.
This position is located in Quantico, VA.
This position is responsible for administering, troubleshooting, and maintaining databases. The ideal candidate will have experience in various database technologies and have a strong understanding of on-premises solutions such as Microsoft SQL Server and cloud-based database solutions within AWS. Additionally, the successful candidate will be an active contributor to our database operations and use technology to continuously improve the team's performance.
Responsibilities
- Manage and monitor the performance of SQL databases, seeking improvements through performance and query tuning
- Create, manage, and continually improve SQL Server maintenance plans through monitoring of queries, indexes, and SQL statistics
- Create, manage, maintain, and improve backup, restore, and replication schedules driven by end user events and processes
- Manage and monitor Windows server failover clusters
- When required, manage and monitor the performance of cloud-based databases within AWS.
- Support the deployment of new databases and schema objects as needed in the on-premises and cloud environment.
- Monitor and maintain databases to ensure stability and optimal performance.
- Ensure that databases are secure and adhere to industry standards.
- Analyze and troubleshoot database issues and take necessary actions to resolve them.
- Generate reports to measure database performance, utilization, and growth.
- Plan and implement database activities including upgrades and patching.
- US citizenship with active Top-Secret clearance
- Minimum of 10 years' experience recommended. In absence of years of experience, certifications or past work may be used to show the level of experience needed to perform at this level.
- Strong understanding of database architecture and design.
- Knowledge of database security and access controls.
- Advanced knowledge of SQL and database query languages.
- Expertise in troubleshooting, performance tuning, and query optimization.
- Excellent communication, problem-solving, and organizational skills.
- Ability to work independently and as part of a team.
- Experience monitoring, performing updates, upgrades, testing, and other associated preventative maintenance and support functions related to Database Platforms
Req Benefits:
https://ecstech.com/careers/benefits/">https://ecstech.com/careers/benefits/