About the job
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 World’s 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
Bachelor’s degree in Information Technology or related field required. MCSE or related SQL certification preferred.