Senior Deltek Vantagepoint SQL Database Administrator

Ardurra • Dallas, TX

7d • Remote

About The Position

Ardurra is seeking a senior-level database administrator to provide technical ownership, administration, performance optimization, and advanced database support for its Deltek Vantagepoint environment. The role combines strong Microsoft SQL Server and T-SQL expertise with practical knowledge of Vantagepoint database structures and transactional data. The successful candidate will troubleshoot complex data and performance issues, trace Vantagepoint transactions through the database, support integrations and upgrades, and help ensure the availability, integrity, security, and performance of this financial and project-management platform. The position is open to remote applicants.

Ardurra is a multidisciplinary civil engineering services firm serving public- and private-sector clients. The company describes a people-centric culture that supports employees’ personal and professional development, career growth, engagement, and work-home balance.

Requirements

• 7+ years of Microsoft SQL Server database administration and development experience.
• 3+ years supporting Deltek Vantagepoint, Deltek Vision, or a comparable enterprise ERP/financial database environment.
• Advanced expertise in T-SQL, SQL Server performance tuning, execution plans, indexing, statistics, locking/blocking, transactions, security, backup/recovery, and SQL Server Agent.
• Strong knowledge of relational database architecture, data integrity, and complex transactional systems.
• Experience performing database-level troubleshooting and root-cause analysis for enterprise applications.
• Experience developing and safely executing production SQL data-correction and reconciliation scripts.
• Ability to troubleshoot across application, database, integration, and reporting layers.
• Strong analytical, problem-solving, communication, and documentation skills.

Nice To Haves

• Deep knowledge of Deltek Vantagepoint database architecture and data structures.
• Experience supporting Vantagepoint accounting, billing, labor, expense, AP, AR, and project-accounting processes.
• Experience with Vantagepoint upgrades, migrations, integrations, or Deltek Vision-to-Vantagepoint migrations.
• Experience with Workato, Power BI, Microsoft Azure, APIs, ETL, or other enterprise integration and reporting technologies.
• Experience supporting financial systems with formal audit, security, and change-control requirements.

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 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 handling, documentation, and rollback procedures.
• Partner with Finance, IT, application support, integration teams, and Deltek Support to resolve complex production issues.
• Establish and maintain SQL/database standards, monitoring practices, technical documentation, and production change controls.

Benefits

• Competitive compensation and benefits programs.
• Positive benefits and time-off programs.
• Flexibility to help maintain a healthy balance between work and home.
• Professional and career development opportunities through Ardurra Academy and a leadership program.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed