FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates advanced expertise in Microsoft SQL Server database administration, T-SQL development, and performance tuning, with a strong focus on Deltek Vantagepoint integrations and troubleshooting. Capable of managing complex database environments, ensuring data integrity, and executing production-level scripts while collaborating with cross-functional teams.
Highest-signal resume keywords
Microsoft SQL Server AdministrationT-SQL DevelopmentPerformance TuningDeltek Vantagepoint SupportDatabase Troubleshooting
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
T-SQLSQL Server Performance TuningDatabase AdministrationData IntegrityComplex Transactional SystemsSQL Data-Correction ScriptsRoot-Cause AnalysisExecution PlansIndexingBackup/Recovery
Soft Skills
Analytical SkillsProblem-SolvingCommunicationDocumentation
Tools & Technologies
Deltek VantagepointWorkatoPower BIMicrosoft AzureETLAPIs
Industry Keywords
Enterprise ERPFinancial DatabaseChange ControlAudit RequirementsProject Accounting
Tech Stack
Tools & technologiesAzureERPETLMS SQL ServerSQL
About the role
Key responsibilities & impact- 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 tables, relationships, transactions, and SQL processes
- Develop and optimize advanced T-SQL 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 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
Requirements
What you’ll need- 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
- Preferred: Experience supporting Vantagepoint accounting, billing, labor, expense, AP, AR, and project-accounting processes
- Preferred: Experience with Vantagepoint upgrades, migrations, integrations, or Deltek Vision-to-Vantagepoint migrations
- Preferred: Experience with Workato, Power BI, Microsoft Azure, APIs, ETL, or other enterprise integration and reporting technologies
- Preferred: Experience supporting financial systems with formal audit, security, and change-control requirements
Benefits
Comp & perks- Competitive compensation
- Rich benefits programs
- Internal Ardurra Academy
- Industry-leading Leadership program
- Professional and career development support with multiple, varied career paths
- Tools and resources to support successful, engaged, and satisfying work
- Positive benefits
- Time-off programs
- Flexible work arrangements supporting work-home balance
