Database Administrator (SQL Server)-Remote
My3Tech, Vermont, WI, United States
Job Title:
Database Administrator (SQL Server)
Duration:
Up to 5-year master contract term (staff augmentation engagement)
State Experience Mandatory
We are specifically looking for candidates with strong experience in
Medicaid Enterprise Systems Project (MESP) Modernization , including:
IE&E (Integration, Eligibility & Enrollment)
MMIS (Medicaid Management Information Systems)
HIT / HIE (Health Information Technology / Health Information Exchange)
Key Responsibilities
Administer SQL Server Database Services (SSDS)
Support SQL Server Reporting Services (SSRS)
Support SQL Server Analysis Services (SSAS)
Support SQL Server Integration Services (SSIS)
Support SQL Server Master Data Services (SSMDS)Manage SQL Server patching and maintenance activities
Configure Windows and SQL Server authentication models
Implement Active Directory integration
Support Windows Server and Group Policy configurations
Configure and maintain database mail services
Perform backup and restore operations
Develop and maintain disaster recovery plans
Implement database, table, and column-level encryption
Configure SQL replication and load balancing
Develop ETL constructs supporting enterprise data workflows
Monitor performance and implement tuning strategies
Maintain indexing and statistics strategies
Configure SQL Agent jobs and alerting mechanisms
Use RedGate SQL Compare and Data Compare tools
Generate technical documentation including data dictionaries, migration plans, data flows, ER diagrams, and deployment plans
Required Qualifications
Experience administering all five SQL Server engines:
SQL Server Database Services (SSDS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
SQL Server Integration Services (SSIS)
SQL Server Master Data Services (SSMDS)
Experience with T‑SQL, XML, VB, C#, and HTML
Experience with Windows Server Operating Systems
Experience with Windows Group Policy
Experience with SQL Server patching and maintenance
Experience implementing ETL constructs
Experience configuring SQL replication
Experience supporting load‑balanced environments
Experience integrating Active Directory authentication
Experience supporting distributed queries
Experience configuring database mail
Experience performing backup and restore operations
Experience implementing database encryption
Experience administering SSL certificates
Experience performing performance tuning and monitoring
Experience implementing indexing and statistics strategies
Experience configuring SQL Agent jobs and alerts
Experience using RedGate SQL Compare and Data Compare tools
Compliance Environment
The role supports systems subject to multiple regulatory frameworks including HIPAA, IRS Pub 1075, FERPA, PCI DSS, MITA 3.0, NIST SP 800-53 Moderate controls, and other State and Federal security standards.
#J-18808-Ljbffr
Database Administrator (SQL Server)
Duration:
Up to 5-year master contract term (staff augmentation engagement)
State Experience Mandatory
We are specifically looking for candidates with strong experience in
Medicaid Enterprise Systems Project (MESP) Modernization , including:
IE&E (Integration, Eligibility & Enrollment)
MMIS (Medicaid Management Information Systems)
HIT / HIE (Health Information Technology / Health Information Exchange)
Key Responsibilities
Administer SQL Server Database Services (SSDS)
Support SQL Server Reporting Services (SSRS)
Support SQL Server Analysis Services (SSAS)
Support SQL Server Integration Services (SSIS)
Support SQL Server Master Data Services (SSMDS)Manage SQL Server patching and maintenance activities
Configure Windows and SQL Server authentication models
Implement Active Directory integration
Support Windows Server and Group Policy configurations
Configure and maintain database mail services
Perform backup and restore operations
Develop and maintain disaster recovery plans
Implement database, table, and column-level encryption
Configure SQL replication and load balancing
Develop ETL constructs supporting enterprise data workflows
Monitor performance and implement tuning strategies
Maintain indexing and statistics strategies
Configure SQL Agent jobs and alerting mechanisms
Use RedGate SQL Compare and Data Compare tools
Generate technical documentation including data dictionaries, migration plans, data flows, ER diagrams, and deployment plans
Required Qualifications
Experience administering all five SQL Server engines:
SQL Server Database Services (SSDS)
SQL Server Reporting Services (SSRS)
SQL Server Analysis Services (SSAS)
SQL Server Integration Services (SSIS)
SQL Server Master Data Services (SSMDS)
Experience with T‑SQL, XML, VB, C#, and HTML
Experience with Windows Server Operating Systems
Experience with Windows Group Policy
Experience with SQL Server patching and maintenance
Experience implementing ETL constructs
Experience configuring SQL replication
Experience supporting load‑balanced environments
Experience integrating Active Directory authentication
Experience supporting distributed queries
Experience configuring database mail
Experience performing backup and restore operations
Experience implementing database encryption
Experience administering SSL certificates
Experience performing performance tuning and monitoring
Experience implementing indexing and statistics strategies
Experience configuring SQL Agent jobs and alerts
Experience using RedGate SQL Compare and Data Compare tools
Compliance Environment
The role supports systems subject to multiple regulatory frameworks including HIPAA, IRS Pub 1075, FERPA, PCI DSS, MITA 3.0, NIST SP 800-53 Moderate controls, and other State and Federal security standards.
#J-18808-Ljbffr