IT - Consultant IV

Responsibilities

• Execute national production applications on the Client's large, complex and widely distributed Microsoft NT operating system environment and Local Area Network (LAN) infrastructure throughout the United States.
• Develop standards and procedures, both operational and functional.
• Interact with other client organizations and individuals, such as developers and end users, to understand applications and resolve problems.
• Support different shifts to enable 24x7 support; may be required to carry a pager and be on call.
• Supports different shifts to enable 24x7 support; may be required to carry a pager and be on call.
• Carry out other duties in support of the organization's mission as directed by FCSC/DSS management.

Requirements

• Minimum 8-10 years of experience as a SQL Server DBA in production environments.
• Proficiency in SQL Server 2016/2019/2022 (T-SQL, SSMS, Agent Jobs, Maintenance Plans).
• Experience with backup and restore strategies, including full, differential, and transaction log backups.
• Strong understanding of database recovery models and point-in-time recovery.
• Ability to create and maintain database documentation and operational runbooks.
• Disaster Recovery & High Availability: Hands-on experience with Always On Availability Groups and/or SQL Server Failover Clustering.
• Familiarity with backup encryption and offsite retention strategies.
• Participation in and support of DR drills and contingency planning.
• SQL Monitoring & Performance Tuning: Skilled in performance troubleshooting using SQL Profiler, Extended Events, and DMVs.
• Experience tuning indexes, reviewing execution plans, and maintaining stats.
• Familiarity with SQL monitoring tools (e.g., Redgate, SolarWinds DPA, Sentry One).
• Architecture & Design: Understanding of normalized and denormalized schema design.
• Experience with table partitioning, filegroups, and database file I/O planning.
• Supports scalability and performance through smart database design decisions.
• DevOps For SQL Server: Familiar with CI/CD pipelines involving SQL deployments (e.g., Azure DevOps, GitLab, Octopus Deploy).
• Experience with version control for database objects (e.g., Git + SQL Source Control).
• Support for automated database deployments and schema changes.
• Familiarity with Infrastructure as Code (IaC) concepts using PowerShell or ARM templates.
• Legacy SharePoint DBA Support: Experience maintaining backend SQL databases for legacy SharePoint environments (2010/2013/2016).
• Able to support site migrations, database integrity checks, and performance tuning for SharePoint SQL backends.
• Collaborated with SharePoint Admins on patching and upgrade activities.
• NET Application Support on SQL Server: Supported ASP.NET and .NET Core web applications with SQL Server backends.
• Familiar with connection pooling, application-level query performance, and ORM frameworks like Entity Framework.
• Traced SQL calls from web apps and optimized database access patterns.
• Worked with application developers to improve data access performance and scalability.

General Requirements

• Strong documentation skills and adherence to ITSM/ITIL change control practices.
• Effective communicator across DB, application, and infrastructure teams.
• Willingness to support an on-call rotation and occasional after-hours work.
• Works on high-visibility, or mission critical aspects of a given program, and performs all functional duties independently.
• Oversees the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job.

Preferred Qualifications

• Exposure to cloud-based database solutions (e.g., Azure SQL, AWS RDS).
• Experience with hybrid cloud/on-prem SQL architecture.
• Military Service excluded (Exception does not include military family members).

Additional Provisions

• Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.
• All candidates must be a US Citizen or have permanent residence status (Green Card).
• Candidate must have lived in the US for the past 5 years.
• Cannot have more than 6 months travel outside the United States within the last five years.
• Authorized overtime will be reimbursed at straight time.
• The enforced dress code is business casual, i.e. collared shirt with slacks for men, no skirts above the knee for women.