Database Administrator
At Cumming Group, you will work on some of the worlds most exciting projects in a dynamic environment where your success is measured by the impact you make. We are one of the fastest-growing project and cost management consultancies in the United States, as reflected in our top 10 rankings in ENR. With over 60 offices globally, an extremely diverse project portfolio, and double-digit year-over-year revenue growth, the opportunities to make your mark are limitless!
Were seeking an experienced Database Administrator to join our internal IT team, based onsite at our Murrieta, CA or Columbia, SC office. The Database Administrator is responsible for the performance, reliability, and security of the companys database systems, with a primary focus on administering and optimizing the Deltek Vantagepoint ERP backend. This role manages multiple Microsoft SQL Server environments, on-premise and cloud-connected, ensuring data integrity, availability, and alignment with business needs. The ideal candidate is a hands-on technical specialist who thrives on maintaining mission-critical systems while contributing to broader modernization efforts across the companys technology ecosystem.
Essential Duties & Responsibilities :
SQL Server & ERP Administration
- Administer, monitor, and maintain multiple Microsoft SQL Server instances, with the Deltek Vantagepoint ERP database as the primary system of record.
- Write, optimize, and tune complex T-SQL queries, stored procedures, and views for both ad hoc analysis and application logic.
- Create and schedule SQL Server Agent jobs to automate data ingestion, maintenance routines, and reporting pipelines.
- Implement, document, and test backup and disaster recovery strategies to ensure business continuity.
- Manage database indexes, performance tuning, and query optimization to support application efficiency and stability.
- Plan and execute Deltek Vantagepoint upgrades, schema updates, and integrations, working closely with the ERP administrator and IT team.
- Design and publish SSRS reports and datasets to meet business and finance reporting requirements.
Cross-System Data Architecture
Support integration between SQL Server and the Azure Databricks Lakehouse, ensuring consistent and secure data flow.Collaborate with data engineers and analysts to maintain data integrations to other critical systems.Develop and maintain SQL transformations and stored procedures that serve as upstream logic for analytics and reporting layers.Contribute to the management of Unity Catalog, metadata inventory, and data lineage documentation.Partner with Power BI administrators to optimize Fabric dataset refreshes, gateways, and source connections.Data Governance, Security, & Monitoring
Enforce data security and access controls aligned with IT and Data Governance policies.Participate in data issue management and quality improvement processes, ensuring system reliability and integrity.Monitor system performance using both native and custom monitoring tools; proactively identify and resolve issues.Maintain clear, comprehensive documentation for database configurations, schemas, and operational procedures.Knowledge & Skills Required :
Strong proficiency in SQL Server administration, including configuration, optimization, and security management.Expert-level T-SQL skills (CTEs, window functions, MERGE statements, temp tables, and dynamic SQL).Demonstrated experience managing ERP databases, preferably Deltek Vantagepoint or similar enterprise systems.Experience with on-premise SQL Server environments.Knowledge of data warehouse concepts.Familiarity with Azure Databricks and Power BI data connectivity preferred.Working understanding of data governance principles (metadata, lineage, access, and data quality).Scripting experience in PowerShell a plus.Strong communication and documentation skills with an ability to translate technical issues to business impact.Detail-oriented, analytical, and able to manage multiple priorities in a fast-paced environment.Preferred Education and Experience :
Education : Bachelors degree in Computer Science, Information Systems, or a related technical discipline.
Experience : Minimum 37 years of hands-on SQL Server database administration experience. Experience supporting Deltek Vision / Vantagepoint or similar ERP systems strongly preferred. Experience with Databricks a plus.
The salary range for this full-time role is $91,000.00-$121,333.35 per year. Ranges are determined based on the position, geography, client and industry experience and level, and represent a good faith effort to provide a fair and equitable salary. This range reflects base salary only, and not the total compensation package. Cumming Group reserves the right to pay more or less than the posted range, depending on a candidates experience, skills, and qualifications, including client requirements.
In addition to base salary, Cumming Group offers a comprehensive benefits package including : Medical, Dental Insurance, Vision Insurance, 401(k), 401(k) Matching, Paid Time Off, Paid Holidays, Short and long-term disability, Employee Assistance Program.