DUTIES AND RESPONSIBILITES:
• Responsible for elicitation, analysis, and documentation of business requirements.
• Research and exploration of user requirements, costs, and benefits in support of documentation required for the demand management process.
• Responsible for analyzing the business needs to identify new processes and process improvements that will meet those needs.
• Documents current business processes and models to define requirements and/or gaps.
• Analyze detailed system factors including input/output requirements, information and paper flow, hardware, and software needs.
• Analyze “soft" system factors including roles, responsibilities, policy, culture, etc.
• Evaluate the impact of potential software and process changes on the organization.
• Develop and facilitate groups as necessary in pursuit of eliciting and defining requirements.
• Assist in the creation of the business case documentation.
• Understanding of architectural consistency and usability standards.
• Defines and develops user test cases and validates test results during testing.
• Executes unit and functional test cases.
• May conduct system demonstrations and training sessions, as well as participate in design/review of training content.
• Plays a third level support role by helping to troubleshoot and resolve issues with production systems.
• Participates in associate meetings and communicates any concerns to management.
QUALIFICATIONS AND REQUIREMENTS:
• Bachelor’s degree in computer science, Information Systems, Business, or another related field or equivalent work experience.
• Proven experience leading data migration requirements from legacy systems into a new ERP (Sage X3) environment
• Strong hands-on expertise in requirements elicitation, documentation, and management, with emphasis on data mapping, transformation rules, and validation
• Deep understanding of data structures, data quality, and migration best practices, with the ability to identify gaps and risks early
• Self-driven and accountable professional with strong stakeholder management and communication skills, able to drive outcomes with minimal oversight
• Working knowledge of Confluence and JIRA.
• Experience in any of the following business areas is desired: Sales operations, order entry, accounting, finance, procurement, warehouse operations, order management, and order fulfillment.
• Minimum of 3-5 years’ business analysis or systems analysis experience is preferred.
• Bonus: Sage X3 experience (ERP).
Associate is expected to operate at a proficient level across the following areas of technical knowledge and skill:
• Ability to organize and prioritize work.
• Detail oriented, proactive, creative, and efficient
• Intermediate level abilities in Excel, Outlook, PowerPoint, Visio, and Word
• Familiarity with application integration methods to include understanding of data mapping process.
• Ability to effectively work both independently and collaboratively in a team environment
• Ability to work on simultaneous and complex projects, with domain expertise in at least one business area.
• Expertise in ERP solution selection and implementation is a plus
• Ability to communicate effectively to both technical and non-technical audiences in written and non-written format
• Ability to work with all levels of associates
• Ability to work with minimal supervision in a very dynamic environment
• Ability to learn new systems and tools
• Knowledge of software development life cycle methodologies, processes, and procedures.
• Active listener
• Effective in a variety of formal/informal presentation settings: one-on-one, small, and large groups.
Job Title: Senior SQL DBA
Location: Columbia, SC (Hybrid)
Duration: 12 Months
Job Description
The Client seeks a highly skilled Database Administrator (DBA) to support mission-critical Client systems, Client case management databases, data warehouse platforms, and reporting environments.
This position will provide advanced database administration, performance tuning, security hardening, disaster recovery planning, and cross-database standardization support for enterprise SQL Server environments supporting:
- Client Case Management Systems (CMS environments)
- Client Data Warehouse (DW)
- Public Index & Reporting Systems
- Power BI and Interactive Data Dashboards
- Cross-county reporting standardization initiatives
- Integrated court and justice partner systems
The DBA will work closely with the Deputy Director of Applications, IT Applications Development Manager, developers, data analysts, and infrastructure teams to ensure data integrity, high availability,
performance optimization, and compliance with statewide data governance initiatives.
Responsibilities:
Working on SQL Server (v 2016+)
- Administer and maintain SQL Server instances across multiple client’s 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 client 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 client standardization of:
- County codes
- Circuit mappings
- client alignment
- Roster type consistency
- Ensure alignment with the Client’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:
- Client confidentiality standards
- Client 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
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
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
Never miss an opportunity! Create an alert based on the job you applied for.
