Database Administrator

Job Title:Database Administrator

Location: Nashville, TN 37243 Onsite
Work Address: 665 Mainstream Drive, Nashville, TN 37243
Work Mode: Onsite; potential for hybrid work after training

Job Summary

We are seeking a detail-oriented Data Mapping & Integrity Analyst to support legacy database documentation, data quality assessments, reporting, and modernization initiatives. The consultant will work with the Licensure and Regulation System (LARS), identifying and documenting database fields, validating data integrity, developing SQL queries, and supporting data migration and system modernization activities.

The ideal candidate will have strong SQL expertise, advanced Excel skills, and hands-on experience with data mapping, data profiling, data validation, and technical documentation. Excellent analytical, communication, and stakeholder collaboration skills are essential.

Key Responsibilities

Data Mapping and Documentation

• Identify, analyze, validate, and document existing fields within legacy database systems.

• Develop and maintain comprehensive field mapping documentation and a centralized data dictionary.

• Analyze field relationships, dependencies, and usage across data extracts, correspondence, certificates, and API feeds.

• Identify documentation gaps and resolve inconsistencies in field definitions and mapping.

Data Integrity and Quality Assurance

• Develop and execute SQL queries for data profiling, validation, and integrity assessments.

• Identify data anomalies, inconsistencies, structural issues, and recurring quality concerns.

• Document findings, track data risks, and recommend corrective actions and governance improvements.

• Collaborate with business stakeholders to validate data requirements and improve data quality.

Reporting and Database Support

• Respond to help desk and ServiceNow tickets related to data requests, reporting, and system administration.

• Prepare accurate reports and data extracts using SQL.

• Validate reporting outputs and maintain clear documentation of query logic and results.

• Store SQL scripts, reports, and supporting documentation in designated repositories.

System Modernization and Data Migration

• Support legacy system modernization and database transition initiatives.

• Review and validate source-to-target data mapping documents.

• Participate in vendor meetings and communicate legacy data requirements.

• Assist with data migration testing, reconciliation, validation, and issue resolution.

• Support the development of future-state reporting, dashboards, database structures, and data governance standards.

Required Skills and Qualifications

• Strong SQL skills, including complex queries, data profiling, and validation.

• Advanced Microsoft Excel skills, including VLOOKUP/XLOOKUP, pivot tables, and data analysis.

• Experience with data mapping, field-level documentation, and data dictionaries.

• Experience performing data quality assessments and resolving data discrepancies.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Ability to manage multiple assignments, timelines, and deliverables.

• Excellent written and verbal communication skills.

• Ability to communicate technical findings to technical and non-technical stakeholders.

Preferred Qualifications

• Experience supporting legacy database systems and modernization projects.

• Knowledge of source-to-target mapping and data migration testing.

• Experience with ServiceNow or similar ticketing systems.

• Familiarity with API data feeds, reporting extracts, and data governance practices.

• Experience working with government, healthcare, licensing, or regulatory data systems is an advantage.

Work Environment

This is an onsite position based in Nashville, Tennessee. The selected candidate must be available to work Monday through Friday, from 8:00 AM to 4:30 PM CST. Some hybrid flexibility may be considered after successful completion of training.