This job offer is no longer available
About
• 7+ years of experience with SQL Database Administration & Operations
• 3+ years of experience with Performance Tuning & Optimization
• 3+ years of experience with Data Integrity & Governance Support
• 3+ years of experience with Data Warehouse Architecture & Reporting Support
• 3+ years of experience with Security & Compliance
• 3+ years of experience with Automation & DevOps Support
Preferred/Nice to Have Skills:
Experience in judicial, government, or public sector environments Power BI backend optimization .NET application data access patterns Always On Availability Groups Azure DevOps Experience cleaning legacy data structures across multiple counties or jurisdictions Responsibilitie:
• Working on SQL Server (v 2016+)
• Administer and maintain SQL Server instances across multiple judicial environments.
• Manage contained users, authentication models, and database-level security.
• Configure and monitor SQL Agent jobs, maintenance plans, and index strategies.
• Implement and validate backup/restore procedures and disaster recovery plans.
• Support high availability configurations (Always On, clustering where applicable).
• Optimize large-scale tables supporting court case data.
• Analyze and tune:
o Stored procedures
o Dynamic SQL
o Cross-database queries
o CTE-heavy workloads
o Index fragmentation and statistics
• Review and optimize ETL loops across multiple CMS databases.
• Reduce blocking, deadlocks, and long-running transactions.
• Implement partitioning strategies where appropriate.
• Assist with:
o Referential integrity enforcement
o Foreign key reconciliation
o Identity reseeding
o Data remediation & cleanup
• Support statewide standardization of:
o County codes
o Circuit mappings
o Court type alignment
o Roster type consistency
• Ensure alignment with the Chief Justice's data initiative and reporting aggregation standards.
• Optimize fact/dimension loading processes
• Support performance tuning for Power BI reporting back-end queries.
• Assist with:
o Indexed views
o Aggregation tables
o Incremental load strategies
• Collaborate on data quality validation routines.
• Harden SQL Server instances against unauthorized access.
• Review role-based security for judicial data.
• Ensure compliance with:
o Judicial confidentiality standards
o CJIS considerations (where applicable)
• Monitor audit logs and security events.
• Support WAF/SQL visibility requirements for secure application traffic.
o Imperva or similar security appliances
• Assist in scripting deployment pipelines for:
o Schema changes
o Stored procedure deployments
o Data migration scripts
• Support version control integration.
• Create reusable administrative scripts for:
o Multi-database updates
o Password rotation
o Security audits Cross-environment validation
What Makes HTC A Great Place To Build Your Future
HTC Global Services wants you to join our team. Come build new things with us and advance your career. At HTC Global, you'll collaborate with experts, work alongside clients, and be part of high-performing teams driving success together. You'll have long-term opportunities to grow your career and develop skills in the latest emerging technologies.
At HTC Global Services, our employees have access to a comprehensive benefits package. Benefits can include Group Health (Medical, Dental, and Vision), Paid Time Off, Paid Holidays, 401(k) matching, Group Life and Disability insurance, Professional Development opportunities, Wellness programs, and a variety of other perks.
Our success as a company is built on inclusion and diversity. HTC Global Services is committed to providing a workplace free from discrimination and harassment, where every employee is treated with dignity and respect. We celebrate differences and believe that diverse cultures, perspectives, and skills drive innovation and success. HTC is an Equal Opportunity Employer and a proud National Minority Supplier. We seek to empower each individual, fostering an environment where everyone feels valued, included, and respected.
#LI-SB1
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.