Senior Deltek Vantagepoint SQL Database Administrator

Ardurra Group, Inc.; Dallas (TX); Remoto; USD 120.000 - 160.000; Tempo pieno

Descrizione del lavoro

Ardurra is seeking a Senior Deltek Vantagepoint SQL Database Administrator to own and optimize the Deltek Vantagepoint environment. You will leverage MS SQL Server and T-SQL expertise to ensure availability, integrity and performance of critical financial and project management data.

The role emphasizes enterprise data stewardship, production support, and collaboration with Finance and IT. This is a remote-friendly, senior-level position within the Information Technology team.

Competenze

• 7+ years of Microsoft SQL Server administration and development experience.
• 3+ years supporting Deltek Vantagepoint or similar ERP/financial DB environments.
• Advanced T-SQL, performance tuning, indexing, and security expertise.
• Strong relational database architecture and data integrity knowledge.
• Experience in production SQL data-correction and reconciliation scripts.
• Ability to troubleshoot across apps, DB, integration, and reporting layers.
• Excellent communication and documentation skills.

Mansioni

• Serve as senior SQL DBA for Deltek Vantagepoint and act as SME.
• Administer, monitor, and optimize MS SQL Server databases supporting Vantagepoint.
• Troubleshoot complex Vantagepoint data issues by analyzing tables and transactions.
• Develop advanced T-SQL queries, views, procedures, and data validation scripts.
• Monitor performance: execution plans, indexing, blocking, CPU, memory, I/O.
• Support backup, recovery, security, permissions, and disaster Recovery.
• Investigate data integrity and reconciliation across GL, AP, AR, and projects.
• Trace transactions from Vantagepoint screens to DB records to find root causes.
• Support Vantagepoint integrations, ETL, APIs, and reporting solutions.
• Provide DB expertise for upgrades, migrations, and production deployments.
• Develop production remediation scripts with validation and rollback procedures.
• Collaborate with Finance, IT, and Deltek Support to resolve issues.
• Establish and maintain SQL standards, monitoring, and change controls.

Conoscenze

SQL performance

Root cause analysis

Data integrity

Documentation

Communication

Strumenti

Deltek Vantagepoint

Microsoft SQL Server

T-SQL

SQL Server Agent

ETL/APIs/integration tools

Power BI

Azure

Descrizione del lavoro

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 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.

Qualifications

Required

• 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 applications, database, integration, and reporting layers.
• Strong analytical, problem‑solving, communication, and documentation skills.

Preferred

• 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.

Why Ardurra?

While Ardurra offers competitive compensation and rich benefits programs, it is our culture that truly sets us apart from our peers. We nurture a family‑like culture, striving to create a work environment that is enjoyable, challenging and rewarding but also fun. We are acutely focused on developing our staff, whether through our internal Ardurra Academy or through our industry‑leading Leadership program. We have made a deliberate and focused commitment to nurture a people‑centric culture where people are: valued as individuals; supported in their professional and career development with multiple, varied career paths; provided the tools and resources to be successful, engaged, and satisfied in their work; and positive benefits, time‑off programs, and flexibility to help maintain a healthy balance between work and home.

Ardurra is an Equal Opportunity/ Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, protected veteran status, gender identity or sexual orientation.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.