Database Administrator 3
PACCAR Inc.
Company Information
PACCAR is a Fortune 500 company established in 1905. PACCAR Inc is recognized as a global leader in the commercial vehicle, financial, and customer service fields with internationally recognized brands such as Kenworth, Peterbilt, and DAF trucks. PACCAR is a global technology leader in the design, manufacture and customer support of high-quality light-, medium-, and heavy-duty trucks under the Kenworth, Peterbilt and DAF nameplates. PACCAR also designs and manufactures advanced diesel engines, provides financial services and information technology, and distributes truck parts related to its principal business.
Kenworth Truck Company
Kenworth Truck Company, founded in 1923, is the manufacturer of The Worlds Best heavy and medium duty trucks. With an excellent heritage of quality, innovation and technology, Kenworth has played an essential role in the development of trucks that are more fuel efficient, productive, and economical to operate. Today, Kenworth is leading transportation innovation with the introduction of battery-electric vehicles, exploration of fuel cell electric powertrains, and autonomous driving systems. Kenworth is committed to fostering an environment of diversity, equality and inclusivity in the workplace.
Job Functions / Responsibilities
PACCAR is seeking a Database Administrator 3 to manage and maintain the company databases of simple to high complexity. This position will help optimize database configuration and access, resolve database performance and capacity issues, and perform database recovery and back-ups. Database development and SSIS package creation and maintenance will be required.
Manage SSIS Package/Job schedules and troubleshooting
Manage Backups and Restores
Build and Manage Databases/Instances
Manage Instance and Database Security
Performance tuning
Maintain Test, Cert and Production Environments
Comply with the change control process
Maintain Patching Compliance
Maintain Audit Compliance
Manage Reporting Services (SSRS)
Manage Power BI
SQL Design and Development Consulting
Create and maintain detailed standard work/procedure documents
Provide technical support and guidance to end users
Complete daily operating system health checks
Support scheduled after-hours maintenance
Ability to be on call for 24/7 support
Skills Required
5 years experience required
2 – 5 Years experience administering SQL Server databases/instances required
In-depth knowledge of installing, troubleshooting, and administering SQL Server 2014
Proven experience with SQL Server Reporting Services (SSRS)
Proven experience with SQL Server Integration Services (SSIS)
Proven experience with Power BI Server
Strong documentation, organizational, and administration skills
Strong oral and written communication skills
Experience with Windows Server considered a plus
Experience with SharePoint considered a plus
Experience with visualization software considered a plus (Tableau, Power BI, etc…)
Experience with AWS, S3, Redshift, Aurora, Azure considered a plus
Experience with data warehousing considered a plus
Experience with Agile methodology
Education/Training
Bachelors degree in Information Technology or related field required. MCSE or related SQL certification preferred.
Why work for PACCAR/Kenworth?
Global Fortune 500Company with a wide array of growth and development opportunities
Work alongside experienced goal-oriented colleagues recognized as experts in their fields
Support and/or design the commercial vehicles of the future with a focus on emerging technologies such as electric and autonomous trucks
As a U.S. PACCAR employee, you have a full range of benefit options including:
401k with up