SQL DBA ( USC ) With clearance.

Job Description:

· Proficient in management, availability, security, and performance monitoring and optimization of database solutions.

· Design and implement fault-tolerant SQL Server solutions using highly availability patterns for scalability and stability in on-premises and Microsoft Azure

· Design and deploy Microsoft SQL PaaS solutions in Microsoft Azure Government (MAG)

· Implements Azure infrastructure solutions and may provide oversight and leadership on workstreams across domains.

· Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders.

· Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders.

· Responsible for setting up High-Availability and Disaster Recovery

· Plan and test high availability and disaster recovery.

· Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets.

· Resolve database integrity, performance, blocking, connectivity, and replication issues.

· Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues.

· Perform and manage Database backup/recovery/restore and capacity monitoring.

· Synapse workload management and optimization

· Setup SQL agent jobs, elastic jobs and runbook automation

· Identify and setup alerts and logging in Azure.

· Maintain databases – Statistics, Indexes, fragmentation.

· Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)

· Implement operational automation using scripts.

· Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.

· Design and create databases to support development initiatives.

· Synapse workload management and optimization

· Support release/code deployment activities

· Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders.

Non-Technical Skills:

· Strong self-starter attitude, team-oriented and good communication skills are a must.

· Willingness to commit to maintaining the highest standard of customer service with outstanding written and oral communication.

· Excellent writing, interpersonal, and communication skills.

· Ability to communicate effectively with the team on assigned tasks, expectations, and schedules.

· Sharp attention to detail

· Organized; time management skills to forecast and stay ahead of deliverable/reporting requirements

· Must be well-organized and detail-oriented with the ability to coordinate, prioritize multiple tasks, and be adaptable to change to accomplish assignments.

· Excellent customer focus/satisfaction skills

Education: BA/BS or higher

Experience:

· 10+ years of relevant experience (with a MA/MS)

· 12+ years of relevant experience (with a BA/BS)

Certifications:

· Must hold current or obtain within 90 days of start date IAT Level II (Security+ or higher)

· Applicable Computing Environment (CE) Certification

Clearance Required: Candidate must be a US Citizen, and have at least a SECRET clearance.

Job Type: Full-time

Salary: $90,000.00 - $100,000.00 per year

Benefits:

• Dental insurance
• Health insurance

Schedule:

• 8 hour shift

People with a criminal record are encouraged to apply

Education:

• Bachelor's (Preferred)

Work Location: Remote