SQL Database Administrator – SQL 2019, Azure SQL, Azure Data Factory

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in the modernization initiatives of CNIC Enterprise Business Solutions as part of the DEOS Task Order.

• Offer database engineering, modernization, migration, performance enhancement, and cloud transformation assistance across environments such as SQL Server 2019, Azure SQL, and Azure Data Factory.

• Ensure operational continuity throughout the modernization process.

• Work in close collaboration with cloud engineers, application teams, cybersecurity experts, and data architects to facilitate CNIC’s migration strategy.

• Administer, configure, sustain, and optimize SQL Server 2019 database environments that support CNIC applications.

• Construct, manage, and enhance Azure Data Factory pipelines, orchestrations, and data flows.

• Assess existing legacy databases and propose modernization tactics, cloud migration strategies, and performance enhancements.

• Create stored procedures, scripts, tuning plans, and solutions for database automation.

• Provide Tier II/III troubleshooting and escalation assistance for database-related issues.

• Generate engineering documentation, which includes procedures, architecture diagrams, migration plans, and knowledge articles.

⛳️ Requirements

• Active Top Secret clearance is required.

• A minimum of 8 years of experience as a SQL Database Administrator.

• Practical experience with SQL Server 2019, Azure SQL (SQL Online), and Azure Data Factory.

• Experience in database migration and modernization processes.

• Familiarity with database security, auditing, RBAC, patching, and compliance.

• Experience in performing database performance tuning, monitoring, index optimization, and troubleshooting.

• Background in supporting large-scale modernization or cloud migration projects.

• Bachelor's Degree or an equivalent in Computer Science or a related IT field.

• Must be DoD 8570 IAT II compliant - Security+ CE.

🏝️ Benefits

• Comprehensive benefits and wellness packages.

• 401K plan with company matching.

• Paid time off.

• Flexible work weeks where feasible.

• Vacation, sick leave, personal time, holidays, paid parental leave, military leave, bereavement leave, and jury duty leave.

• 15 days of paid leave each calendar year.

• 10 paid holidays annually.

• Paid Family Leave program offering up to 160 hours of paid leave within a rolling 12-month period.

• Short-term and long-term disability benefits.

• Life insurance, accidental death and dismemberment insurance, personal accident insurance, critical illness insurance, and business travel accident insurance.