Database Administrator
Company: Cumming Group
Location: Murrieta
Posted on: April 15, 2024
|
|
Job Description:
Overview
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. -
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.- 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 as a Database Administrator-
Experience working with Deltek Vision/Vantagepoint a plus-
Experience in Azure databases a plus
Keywords: Cumming Group, Poway , Database Administrator, IT / Software / Systems , Murrieta, California
Click
here to apply!
|