Database Administrator - Aliso Viejo, United States - Cumming Group

Cumming Group

Verified Company

Aliso Viejo, United States

2 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Overview:

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 ranking 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

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.
Collaborate with ERP system administrator and IT to troubleshoot and resolve databaserelated 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 onpremise Microsoft SQL Server required.
Experience working with ERP systems required
Excellent communication and problemsolving 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 as a Database Administrator
Experience working with Deltek Vision/Vantagepoint a plus
Experience in Azure databases a plus