Database Administrator

About This Role

This role involves managing and maintaining the integrity of a legacy database system, ensuring data quality, and supporting a modernization project. The position suits a detail-oriented professional with strong SQL and data analysis skills.

Responsibilities

• Identify, validate, and document all existing fields in the LARS legacy system
• Analyze field relationships, dependencies, and usage across extracts, correspondence, certificates, and API data feeds
• Update data mapping documentation when inconsistencies or gaps are identified
• Maintain a centralized data dictionary for agency-wide reference
• Perform recurring SQL-driven data profiling, validation checks, and trend analyses
• Identify data anomalies and quality concerns, document findings, and escalate issues as needed
• Track recurring issues and systemic data risks, and recommend improvements or governance standards
• Collaborate with business units to validate data usage and improve data entry practices
• Respond to help desk and ServiceNow ticket requests within established timelines
• Write and execute SQL queries to deliver accurate reporting outputs
• Ensure all requested data is validated and results are clearly documented
• Store completed reports and SQL scripts in the designated repository
• Participate in vendor meetings and represent legacy system data requirements
• Review vendor mapping documents and validate the accuracy of source-to-target field mappings
• Support data migration cycles through profiling, validation, issue resolution, and testing
• Contribute to new system architecture, dashboards, reports, and long-term data governance frameworks

Requirements

• Advanced SQL skills for querying, data profiling, and data integrity validation
• Strong Microsoft Excel skills, including lookups, pivot tables, and data modeling
• Experience with data mapping and documentation
• Strong analytical and problem-solving skills
• Ability to manage timelines, deliverables, and multiple workstreams
• Effective communication skills with both technical and non-technical stakeholders

Important Details

• Work Schedule: Monday–Friday, 8:00 AM–4:30 PM CST
• Duration: 7 months
• Work Model: In-person, with potential for hybrid work after training

About the Company

At SPECTRAFORCE, the company is committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.