Database Administrator at Cumming in Columbia, South Carolina

Job Description:

Position Title: Database Administrator

Location: Aliso Viejo, CA | Columbia, SC

Req Id: JR100479

Time Type: Full time

Description:

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 20 rankings in ENR. With over 50 offices globally, an extremely diverse project portfolio, and double-digit year-over-year revenue growth, the opportunities to make your mark are limitless!

We are currently hiring for a Database Administrator to work out of our Aliso Viejo, CA, Murrieta, CA or Columbia, SC office supporting our internal employees who are located at 30+ offices across the US.

The Database Administrator is a specialist that will have a focus on managing various Microsoft SQL Server instances and databases. The ideal candidate will have a strong proficiency in SQL querying, writing stored procedures, database management, performance tuning, and ensuring the reliability and security of system. The Database Administrator reports to the Director of Data Architecture and is part of the company’s IT Data and Applications team which focus on supporting strategic business initiatives using custom built solutions.

Responsibilities

- Administer, monitor, and maintain the health of various Microsoft SQL Server databases (ERP database being the largest) and accompanying server infrastructure.
- Write and optimize complex SQL queries for ad hoc and routine data analysis.
- Design, develop, and maintain stored procedures to support data manipulation, validation, and business logic.
- Create and schedule SQL Server Agent jobs to automate routine database maintenance tasks, data imports/exports, and other batch processes.
- Monitor job execution and troubleshoot issues to ensure successful completion and data integrity.
- Develop and maintain backup and recovery strategies to safeguard ERP data against loss or corruption.
- Conduct regular testing of backup and recovery procedures to validate data integrity and restore capabilities.
- Plan and execute ERP system (Deltek Vantagepoint) application updates/upgrades.
- Collaborate with ERP system administrator and IT to troubleshoot and resolve database-related issues.
- Maintain comprehensive documentation of database configurations, procedures, and system changes.
- Author custom reports via SSRS for Deltek Vantagepoint.
- Assist with other database related tasks.

Qualifications

- Strong understanding of SQL and experience writing complex queries.

- Strong proficiency in database management and performance tuning.

- Experience setting up and working with on-premise Microsoft SQL Server required.

- Experience working with ERP systems required.

- Excellent communication and problem-solving skills.

- Ability to work independently and with others.

- Ability to work well under pressure.

- Bachelor’s degree in computer science, information technology, or a related field.

- Proven 2+ years' of experience as a Database Administrator.

- Experience working with Deltek Vision/Vantagepoint a plus.

- Experience in Azure databases a plus.

Cumming Group provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

About_Us:

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 provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

PI256000608

Apply Now