NEW Sr. Associate, SQL Server Administrator
NJ - Montvale
The fastest growing Big Four professional services firm in the U.S., KPMG is known for being a great place to work and build a career. We provide audit, tax and advisory services for organizations in today’s most important industries. Our growth is driven by delivering real results for our clients. It’s also enabled by our culture, which encourages individual development, embraces an inclusive environment, rewards innovative excellence and supports our communities. With qualities like those, it’s no wonder we’re consistently ranked among the best companies to work for by Fortune Magazine, Consulting Magazine, Working Mother Magazine, Diversity Inc. and others. If you’re as passionate about your future as we are, join our team.
KPMG is currently seeking a SQL Server Administrator to join our KPMG Technology Organization.
Responsibilities:
- Provide technical support of database environments/applications, including software installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations; develop, implement and support backup/restore, disaster recovery, and data replication procedures and exercises
- Participate in all aspects of the lifecycle for database environments; and in the implementation of application requested database code and configuration changes in supported database environments
- Participate in the creation of new policies, procedures, projects, and processes; evaluate, document, and recommend database-related software products within technical architecture framework
- Interact with various technology teams regarding work requests submitted, participate in the creation of new policies, procedures, projects, processes and participate in all aspects of the lifecycle for database environments
- Provide technical guidance for junior members of the team and create periodic status reports for management
- Provide on call 24/7 emergency off-hours support of critical systems for database problem resolution and recovery, as well as production applications
Qualifications:
- Minimum three years of experience in administering and managing large databases in a complex enterprise environment
- Bachelor's degree from an accredited college/university or equivalent work experience
- Experience with the SQL Server Log Shipping, clustering, replication and database mirroring features; and installing and supporting SQL Server 2008, 2008 R2, 2012, 2014 and 2016 particularly with features such as Integration Services, Reporting Services and Analysis Services; installing and managing 3rd party vendor applications and dependent components, including packages that utilize IIS, Microsoft Reporting Services
- At least 3 years of SQL Automation with PowerShell needed; any knowledge in Jenkins, GitHub or any source repository is an added benefit
- Experience with automating database tasks: installations, refreshing databases from backup; able to install and troubleshoot client connectivity software, such as ODBC
- Strong written and verbal communications skills a must; able to interact with clients at all levels, both technical and non-technical; able to work off-hours as needed
KPMG offers a comprehensive compensation and benefits package. KPMG, an equal opportunity employer/disability/veteran. KPMG maintains a drug-free workplace. KPMG will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable local, state or federal law (including San Francisco Ordinance number 131192). No phone calls or agencies please.
Requisition# 65251