Senior SQL Database Administrator, Deltek Vantagepoint

This is a fully remote position, open to applicants in Texas.

📋 Description

• Act as the lead SQL DBA and technical database authority for Deltek Vantagepoint.

• Oversee, monitor, maintain, and enhance Microsoft SQL Server databases that support Vantagepoint.

• Diagnose intricate Vantagepoint application and data problems through detailed analysis of tables, relationships, transactions, and SQL processes.

• Create and refine advanced T-SQL queries, stored procedures, views, data validation routines, and controlled data-correction scripts.

• Track and address SQL Server performance challenges, including execution plans, indexing, statistics, blocking, deadlocks, CPU, memory, disk I/O, and database growth.

• Assist with database backup, recovery, security, permissions, SQL Server Agent jobs, maintenance, and disaster-recovery procedures.

• Explore data integrity and reconciliation challenges related to Vantagepoint GL, AP, AR, billing, projects, labor, expenses, employees, vendors, and project accounting.

• Follow transactions from Vantagepoint application screens and reports to the underlying SQL Server records to uncover root causes.

• Facilitate Vantagepoint integrations, ETL processes, APIs, middleware, reporting solutions, and automated interfaces.

• Offer database expertise for Vantagepoint upgrades, migrations, patches, environment refreshes, and production deployments.

• Create controlled production remediation scripts that include validation, transaction handling, documentation, and rollback procedures.

• Collaborate with Finance, IT, application support, integration teams, and Deltek Support to address complex production challenges.

• Set up and uphold SQL/database standards, monitoring practices, technical documentation, and production change controls.

⛳️ Requirements

• Over 7 years of experience in Microsoft SQL Server database administration and development.

• More than 3 years of experience supporting Deltek Vantagepoint, Deltek Vision, or a similar enterprise ERP/financial database environment.

• Advanced proficiency in T-SQL, SQL Server performance tuning, execution plans, indexing, statistics, locking/blocking, transactions, security, backup/recovery, and SQL Server Agent.

• In-depth understanding of relational database architecture, data integrity, and complex transactional systems.

• Experience in performing database-level troubleshooting and root-cause analysis for enterprise applications.

• Proven ability to develop and safely implement production SQL data-correction and reconciliation scripts.

• Capability to troubleshoot across applications, databases, integrations, and reporting layers.

• Excellent analytical, problem-solving, communication, and documentation skills.

• Preferred: Extensive knowledge of Deltek Vantagepoint database architecture and data structures.

• Preferred: Experience in supporting Vantagepoint accounting, billing, labor, expense, AP, AR, and project-accounting processes.

• Preferred: Background in Vantagepoint upgrades, migrations, integrations, or Deltek Vision-to-Vantagepoint migrations.

• Preferred: Familiarity with Workato, Power BI, Microsoft Azure, APIs, ETL, or other enterprise integration and reporting technologies.

• Preferred: Experience in supporting financial systems with established audit, security, and change-control requirements.

🏝️ Benefits

• Competitive compensation.

• Comprehensive benefits programs.

• Access to the internal Ardurra Academy.

• Participation in an industry-leading Leadership program.

• Professional and career development support with diverse career paths.

• Availability of tools and resources to ensure a successful, engaged, and fulfilling work experience.

• Positive benefits.

• Generous time-off programs.

• Flexible work arrangements that promote work-home balance.