Principal Database Architect

Principal Database Architect | Deltek, Inc

Principal Database Architect

India-Bangalore (Remote)

As the recognized global standard for project-based businesses, Deltek delivers software and information solutions to help organizations achieve their purpose. Our market leadership stems from the work of our diverse employees who are united by a passion for learning, growing and making a difference. At Deltek, we take immense pride in creating a balanced, values-driven environment, where every employee feels included and empowered to do their best work. Our employees put our core values into action daily, creating a one-of-a-kind culture that has been recognized globally. Thanks to our incredible team, Deltek has been named one of America's Best Midsize Employers by Forbes, a Best Place to Work by Glassdoor, a Top Workplace by The Washington Post and a Best Place to Work in Asia by World HRD Congress.

The Deltek Engineering and Technology team builds best-in-class solutions to delight customers and meet their business needs. We are laser-focused on software design, development, innovation and quality. Our team of experts has the talent, skills and values to deliver products and services that are easy to use, reliable, sustainable and competitive. If you're looking for a safe environment where ideas are welcome, growth is supported and questions are encouraged – consider joining us as we explore the limitless opportunities of the software industry.

Position Responsibilities

ROLE SUMMARY The Database Architect is responsible for the design, optimization, and evolution of the database layer supporting enterprise applications in cloud environments. This role focuses on ensuring efficient data access patterns, scalable query workloads, and robust database architecture capable of supporting high-volume and high-concurrency systems. This role goes beyond traditional database administration and requires deep technical expertise in SQL query optimization, database internals, and performance diagnostics. The Database Architect analyzes how applications interact with the database and guides improvements in schema design, data access patterns, and system scalability. As a senior technical leader, the Database Architect helps define long-term strategies for scalable and efficient data architecture while working closely with engineering teams to promote best practices for database design and SQL development.

Key Responsibilities

• Design and evolve database architectures for scalable enterprise systems.
• Define efficient data access patterns that support high concurrency and large datasets.
• Improve schema design, indexing strategies, and query patterns.
• Ensure database designs support both transactional and data consumption workloads.

• Analyze and optimize complex SQL queries and execution plans.
• Improve database performance through indexing strategies, statistics management, and query tuning.
• Investigate workload behaviour and recommend architectural improvements.

• Provide guidance on scalable approaches for retrieving and delivering data for data-intensive application features.
• Recommend architectural strategies such as data aggregation, caching, or pre-computed datasets where appropriate.
• Apply systems thinking to improve how data is modeled, accessed, and delivered across the application.

• Diagnose database behaviour using tools such as Query Store, Extended Events, and execution plan analysis.
• Analyze query performance, wait statistics, and workload patterns to identify optimization opportunities.

• Partner with engineering teams to guide scalable SQL development and data access practices.
• Participate in architecture and design discussions involving database interactions.
• Document best practices and architectural recommendations.

• Use AI-assisted tools to accelerate query analysis, diagnostics, and workload investigations.
• Validate AI-generated insights through empirical testing and database telemetry.

Qualifications

8+ years of experience working with enterprise database systems

Proven expertise in SQL performance tuning and database workload optimization

Strong experience in analysing execution plans and database performance behaviour

Experience collaborating with engineering teams on data architecture and query design

Strong analytical and problem-solving skills

We value engineers who view AI as a productivity multiplier. The ideal candidate actively leverages AI tools to accelerate diagnostics, analyze database workloads, and uncover optimization opportunities while applying strong engineering judgment to validate results.