What are the responsibilities and job description for the SQL Server Database Administrator//12 Months Contract//Only SC Residents - No relocation allowed position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Golden Resources. Inc., is seeking the following. Apply via Dice today!
Our client is looking for a SQL Server Database Administrator to join their team!
Top skills you need to have:
Required Skills
Golden Technology was founded in 1997 with the goal of developing people and driving innovation. In other words, our aim is to pair world-class technologists like you with amazing companies that are doing impactful work.
After an initially slow start, and way too many late nights playing Final Fantasy 7, Golden Technology built a unique recruiting engine that would quickly prove itself to deliver top-tiered talent to fortune 500 clients across the US, time and time again.
Golden Technology has built a culture around family and helping the people we touch succeed in both their work and personal lives. Oh, everyone says that? Try us, you ll see it.
We re helping people find their calling and their dream jobs; and through our Golden Community initiatives we are actively working to improve the communities in which we work, live, and play.
Title: SQL Server Database Administrator
Location: Columbia, South Carolina - Hybrid
Duration: long term Contract
Responsibilities:
Our client is looking for a SQL Server Database Administrator to join their team!
Top skills you need to have:
Required Skills
- 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
Golden Technology was founded in 1997 with the goal of developing people and driving innovation. In other words, our aim is to pair world-class technologists like you with amazing companies that are doing impactful work.
After an initially slow start, and way too many late nights playing Final Fantasy 7, Golden Technology built a unique recruiting engine that would quickly prove itself to deliver top-tiered talent to fortune 500 clients across the US, time and time again.
Golden Technology has built a culture around family and helping the people we touch succeed in both their work and personal lives. Oh, everyone says that? Try us, you ll see it.
We re helping people find their calling and their dream jobs; and through our Golden Community initiatives we are actively working to improve the communities in which we work, live, and play.
Title: SQL Server Database Administrator
Location: Columbia, South Carolina - Hybrid
Duration: long term Contract
Responsibilities:
- 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:
- Stored procedures
- Dynamic SQL
- Cross-database queries
- CTE-heavy workloads
- 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:
- Referential integrity enforcement
- Foreign key reconciliation
- Identity reseeding
- Data remediation & cleanup
- Support statewide standardization of:
- County codes
- Circuit mappings
- Court type alignment
- 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:
- Indexed views
- Aggregation tables
- 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:
- Judicial confidentiality standards
- CJIS considerations (where applicable)
- Monitor audit logs and security events.
- Support WAF/SQL visibility requirements for secure application traffic.
- Imperva or similar security appliances
- Assist in scripting deployment pipelines for:
- Schema changes
- Stored procedure deployments
- Data migration scripts
- Support version control integration.
- Create reusable administrative scripts for:
- Multi-database updates
- Password rotation
- Security audits
- Cross-environment validation
- 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