What are the responsibilities and job description for the Database Administrator position at Cumming Management Group, Inc.?
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. 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: 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. #LI-SJ1 Cumming Group is committed to providing Equal Employment Opportunity in its personnel policies and practices. It is Cumming Group’s policy to recruit, hire, train and promote Team Members and applicants for employment without regard to race, color, creed, religion, age, sex, marital status, registered domestic partner status, genetic information, sexual preference, sexual orientation, gender (including gender expression and gender identity), pregnancy (including childbirth or related medical conditions, including breastfeeding), military service, national origin, ancestry, citizenship, physical disability, mental disability, veteran status or any other protected classification under federal, state, or local law. All such decisions are based on (1) individual merit, qualifications, and competence as they relate to the particular position, and (2) promotion of the principle of equal employment opportunity. All other terms and conditions of employment, such as compensation, benefits, transfers, layoff, return from layoff, training, education, and social and recreational programs, are administered without regard to the characteristics described above. To this end, Cumming Group complies with all provisions of Title VII of the Civil Rights Act of 1964 as amended, all of the rules, regulations and relevant orders of the Secretary of Labor, and all similar state and local laws. 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 candidate’s 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 Introduce yourself to our recruiters and we'll get in touch if there's a role that seems like a good match. At Cumming Group, we are passionate about helping our clients execute large-scale, complex projects on-time and within budget. Our project and cost-management services are specifically tailored to each client’s needs and add meaningful value at every step of a project’s development. Drawing on deep expertise in the communities and sectors we serve, we anticipate and solve problems, deliver solutions, and drive results. Since opening our doors in 1996, Cumming Group has grown to 50 offices globally, and is now home to more than 1,950 team members – including many of the brightest minds in the industry. Learn more about what a great organization we are at https://www.linkedin.com/company/cumming-group/about/ Cumming Group is committed to providing Equal Employment Opportunity in its personnel policies and practices. It is Cumming Group’s policy to recruit, hire, train and promote Team Members and applicants for employment without regard to race, color, creed, religion, age, sex, marital status, registered domestic partner status, genetic information, sexual preference, sexual orientation, gender (including gender expression and gender identity), pregnancy (including childbirth or related medical conditions, including breastfeeding), military service, national origin, ancestry, citizenship, physical disability, mental disability, veteran status or any other protected classification under federal, state, or local law. All such decisions are based on (1) individual merit, qualifications, and competence as they relate to the particular position, and (2) promotion of the principle of equal employment opportunity. All other terms and conditions of employment, such as compensation, benefits, transfers, layoff, return from layoff, training, education, and social and recreational programs, are administered without regard to the characteristics described above. To this end, Cumming Group complies with all provisions of Title VII of the Civil Rights Act of 1964 as amended, all of the rules, regulations and relevant orders of the Secretary of Labor, and all similar state and local laws.
Salary : $91,000 - $121,333
