Database Expert (DoD Secret | Remote)

Strong background in enterprise-level database design and administration. Extensive hands-on experience with SQL databases as the primary data store. In-depth knowledge of SQL Server features, including Performance Monitor, Query Analyzer, and related tools. Experience working with clustering and replication technologies (e.g., SQL Server Always On Availability Groups). Proficiency in database replication, load-balancing, and high-availability architectures. Experience implementing backup strategies and conducting recovery testing. Familiarity with disaster recovery planning and RMF-aligned security controls. Hands-on experience with data integration and ETL tools.

Design and implement database schemas and features, including complex SQL queries and stored procedures. Monitor and optimize database performance through query tuning, indexing, and resource management. Perform database optimization, performance tuning, and configure high-availability solutions. Oversee routine maintenance tasks such as backups, recovery procedures, and patching. Implement and maintain robust disaster recovery strategies and backup policies. Enforce database security controls, including access management, encryption, and hardening. Collaborate with data engineers and integration developers to ensure database structures support ETL/ELT processes. Validate that database schemas align with incoming data feeds and ensure smooth operation of interfaces.