The Database Administrator supports database design, data migration, ETL processes, reporting systems, data quality validation, and data analysis to ensure accurate, reliable, and scalable data solutions. This position collaborates with business stakeholders, analysts, developers, and system owners to analyze data requirements, design and implement SSIS data migration processes, identify data relationships and structures, and support reporting initiatives. The Database Administrator helps ensure database solutions meet organizational requirements, promote data integrity, and support secure, efficient, and well-structured data management practices.
- Administer, monitor, and support SQL Server database environments used for enterprise operations, reporting, analytics, and business intelligence.
- Administer, support, and maintain Deltek Costpoint database environments, including user support, data integrity, reporting support, troubleshooting, and coordination of system-related database activities.
- Develop, execute, and validate data migration, transformation, and ETL processes, including processes developed through SQL Server Integration Services (SSIS).
- Design, review, and maintain relational database structures, including tables, primary keys, foreign keys, indexes, relationships, views, and supporting database objects.
- Monitor database performance, data quality, and data integrity; identify issues and coordinate appropriate corrective actions.
- Write, review, and optimize SQL queries, stored procedures, datasets, and reporting objects to support operational, compliance, and executive reporting needs.
- Support database architecture planning and provide recommendations to improve scalability, performance, reliability, and data integrity.
- Collaborate with business analysts, developers, system owners, and stakeholders to translate business requirements into database, reporting, and data management solutions.
- Support business intelligence and reporting platforms, including Power BI, Tableau, SQL Server Reporting Services (SSRS), and related reporting tools.
- Prepare and maintain technical documentation related to database structures, data relationships, workflows, reporting requirements, migration activities, and implementation plans.
- Participate in system testing, user acceptance testing, troubleshooting, data validation, and continuous improvement activities related to enterprise data environments.
- Maintain awareness of applicable data governance, security, privacy, and organizational standards when supporting database and reporting activities.
- Bachelor’s degree in Business, Information Systems, Computer Science, Data Analytics, or a closely related field; equivalent education, training, and experience may be considered.
- Demonstrated experience working with SQL Server databases, relational database structures, database design, and SQL-based reporting.
- Experience supporting ETL processes, data migration, data validation, and data quality troubleshooting.
- Experience analyzing business requirements and translating them into technical specifications, database structures, reports, or data solutions.
- Experience supporting reporting and analytics tools such as Power BI, Tableau, SQL Server Reporting Services (SSRS), or comparable platforms.
- Working knowledge of data modeling concepts, database relationships, indexing principles, and data integrity practices.
- Strong analytical, organizational, documentation, communication, and problem-solving skills.
- Ability to work collaboratively with technical and non-technical stakeholders in a professional environment.
- Microsoft T-SQL Programming certification or comparable SQL development experience.
- SQL Server Reporting Services certification or equivalent reporting experience.
- Experience supporting enterprise software migrations, data conversion efforts, or system modernization initiatives.
- Experience with Deltek Costpoint or comparable enterprise resource planning (ERP) database platforms.
- Experience developing dashboards, performance reports, automated audit processes, KPI reporting solutions, or executive-level reporting products.
- Knowledge of artificial intelligence concepts, tools, or applications as they relate to data management, analytics, automation, or decision-support solutions.
- Coursework, certification, or demonstrated experience in data engineering, data pipeline development, or enterprise data platform support.
- Knowledge of SQL Server relational database design, data modeling, and database support practices.
- Skill in developing SQL queries, supporting ETL processes, validating data, and troubleshooting data quality issues.
- Ability to support reporting and business intelligence needs through accurate, reliable, and well-documented data structures.
- Ability to analyze complex business and technical requirements and convert them into practical data management solutions.
- Ability to communicate effectively with internal stakeholders, technical teams, business users, and leadership.
- Ability to manage multiple priorities, maintain attention to detail, and produce accurate work in a deadline-driven environment.
- Ability to exercise sound judgment, maintain confidentiality, and follow applicable organizational policies and data handling requirements.
This position primarily operates in a professional office or hybrid work environment and routinely uses standard office equipment, computers, database platforms, and business applications. The role may require extended periods of computer-based work, participation in meetings, and collaboration with cross-functional teams. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of the position.
The organization is an Equal Opportunity Employer and considers all qualified applicants for employment without regard to legally protected status. Employment decisions are based on qualifications, merit, business needs, and applicable law.