Cumming-posted about 1 month ago
$91,000 - $121,333/Yr
Full-time • Mid Level
Onsite • Murrieta, CA

At Cumming Group, you will work on some of the world's 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! We're 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 company's 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 company's technology ecosystem.

  • 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.
  • 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.
  • 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.
  • 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.
  • Education:  Bachelor's degree in Computer Science, Information Systems, or a related technical discipline.
  • Experience: Minimum 3-7 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.
  • Medical
  • Dental Insurance
  • Vision Insurance
  • 401(k)
  • 401(k) Matching
  • Paid Time Off
  • Paid Holidays
  • Short and long-term disability
  • Employee Assistance Program
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service