What are the responsibilities and job description for the Database Administrator position at Jobs via Dice?
Description
Robert Half is looking for a DBA to join our client's team in Murietta.
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.
Requirements
Requirements
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.
Education & Experience
Bachelor's degree in Computer Science, Information Systems, or a related technical discipline.
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.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.
Robert Half is looking for a DBA to join our client's team in Murietta.
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.
Requirements
Requirements
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.
Education & Experience
Bachelor's degree in Computer Science, Information Systems, or a related technical discipline.
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.
Technology Doesn't Change the World, People Do.
Robert Half is the world's first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.
Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. Download the Robert Half app and get 1-tap apply, notifications of AI-matched jobs, and much more.
All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit roberthalf.gobenefits.net for more information.
2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking "Apply Now," you're agreeing to Robert Half's Terms of Use.