Database Administrator - Aliso Viejo, United States - Cumming Group
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 limitlessResponsibilities:
- 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
More jobs from Cumming Group
-
Database Administrator
Aliso Viejo, United States - 1 week ago
-
Assistant Project Manager
Mountain View, United States - 1 week ago
-
Project Engineer
San Jose, United States - 1 week ago
-
Scheduler
Los Angeles, United States - 1 week ago
-
Project Manager
Austin, United States - 2 weeks ago
-
Senior Project Manager
Charleston, United States - 1 week ago