About the position
The KPMG Advisory practice is currently our fastest growing practice. We are seeing tremendous client demand, and looking forward we don't anticipate that slowing down. In this ever-changing market environment, our professionals must be adaptable and thrive in a collaborative, team-driven culture. At KPMG, our people are our number one priority. With a wealth of learning and career development opportunities, a world-class training facility and leading market tools, we make sure our people continue to grow both professionally and personally. If you're looking for a firm with a strong team connection where you can be your whole self, have an impact, advance your skills, deepen your experiences, and have the flexibility and access to constantly find new areas of inspiration and expand your capabilities, then consider a career in Advisory. KPMG is currently seeking a Lead Specialist to join our Federal Advisory practice.
Responsibilities
- Perform comprehensive SQL Server database administration tasks including installations, updates, performance management, and release management
- Monitor and optimize SQL systems in both on-premises and cloud (Azure) environments using tools such as SQL Server Management Studio, SQL Profiler, and customized SQL scripts
- Execute and manage backup/restore processes, ensuring integrity and availability of database systems
- Conduct performance tuning and optimization through re-indexing, statistics updates, and TempDB management to enhance system efficiency
- Implement and maintain high availability solutions including Clustering, Log Shipping, Replication, and Database Mirroring
- Collaborate with various teams to provide SQL development advice, troubleshoot performance issues, and support the deployment of SQL Server updates and patches
- Effectively manage team members tasks / responsibilities, and foster cross functional collaboration to ensure seamless execution of projects / initiatives
Requirements
- A minimum of five years of DevOps / systems administration and/or distributed systems development experience; preferably in cloud hosted environments
- Bachelor's degree from an accredited college/university
- Extensive experience with Microsoft SQL Server (2008,2012, 2016, 2019) and SQL Server in Azure environments
- Proficiency in SQL Administration, including SQL Server installations, updates, performance tuning, and release management
- Deep understanding of SQL security principles, conducting regular security audits, and managing user permissions
- Expert in SQL and PL/SQL development, with capability to create complex SQL scripts, stored procedures, and views
- Excellent technical documentation skills to develop comprehensive guides and best practices; ability to communicate technical concepts to non-technical team members
- Ability to travel as required to support firm engagements
- Applicant must possess a U.S. Government Secret clearance
Benefits
- Comprehensive, competitive benefits package
- Medical and dental plans
- Vision coverage
- Disability and life insurance
- 401(k) plans
- Robust suite of personal well-being benefits to support mental health
- Personal Time Off per fiscal year
- Calendar of holidays to be observed during the year
- Two firmwide breaks each year where employees will not be required to use Personal Time Off
