Senior Deltek Vantagepoint SQL Database Administrator

Ardurra is looking to hire a Senior Database Administrator (Deltek Vantagepoint) to join our Information Technology team.

This position is open to remote applicants.

Ardurra is a multidisciplinary civil engineering services firm which provides broad-based solutions tailored to the specific needs of the public and private sector.

We leverage the depth of our professional and technical expertise, as well as our integrated structure, to deliver practical, innovative solutions for our clients.

We have been creating opportunities for our employees to develop both personally and professionally.

As a result, our team has contributed to some of the nation’s most important infrastructure projects.

These are projects that can positively impact people’s lives.

Position Summary

We are seeking a Senior Deltek Vantagepoint SQL Database Administrator to provide technical ownership, administration, performance optimization, and advanced database support for our Deltek Vantagepoint environment.

This position requires strong Microsoft SQL Server and T-SQL expertise combined with hands-on knowledge of Vantagepoint database structures and transactional data.

The ideal candidate is a senior-level DBA who can trace Vantagepoint transactions through the database, troubleshoot complex data and performance issues, support integrations and upgrades, and ensure the availability, integrity, security, and performance of this critical financial and project management platform.

Key Responsibilities


* Serve as the senior SQL DBA and technical database subject-matter expert for Deltek Vantagepoint.


* Administer, monitor, maintain, and optimize Microsoft SQL Server databases supporting Vantagepoint.


* Troubleshoot complex Vantagepoint application and data issues by analyzing underlying tables, relationships, transactions, and SQL processes.


* Develop and optimize advanced T-SQL, including queries, stored procedures, views, data validation routines, and controlled data-correction scripts.


* Monitor and resolve SQL Server performance issues involving execution plans, indexing, statistics, blocking, deadlocks, CPU, memory, disk I/O, and database growth.


* Support database backup, recovery, security, permissions, SQL Server Agent jobs, maintenance, and disaster-recovery processes.


* Investigate data integrity and reconciliation issues involving Vantagepoint GL, AP, AR, billing, projects, labor, expenses, employees, vendors, and project accounting.


* Trace transactions from Vantagepoint application screens and reports through the underlying SQL Server records to identify root causes.


* Support Vantagepoint integrations, ETL processes, APIs, middleware, reporting solutions, and automated interfaces.


* Provide database expertise for Vantagepoint upgrades, migrations, patches, environment refreshes, and production deployments.


* Develop controlled production remediation scripts with appropriate validation, transaction ha...