Description

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
• 2 – 5 Years’ experience administering SQL Server databases/instances
• 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.

Why work for PACCAR/Kenworth?
• Global Fortune 500 Company 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 to a 5% company match
• Fully funded pension plan that provides monthly benefits after retirement
• Comprehensive paid time off – minimum of 10 paid vacation days (additional days are provided with additional seniority/years of service), 12 paid holidays, and sick time
• Tuition reimbursement for continued education
• Medical, dental, and vision plans for you and your family
• Flexible spending accounts (FSA) and health savings account (HSA)
• Paid short-and long-term disability programs
• Life and accidental death and dismemberment insurance
• EAP services include wellness plans, estate planning, financial counseling and more

Additional Job Board Information

At PACCAR, we value talent and promote growth and development. We carefully consider numerous compensation factors including your education, training, or experience. The salary range for Database Administrator is $93,00-$145,500 annually. This position is also eligible for a holiday gift. Additionally, this role is eligible for the full range of benefit options listed above.

PACCAR promotes equal employment opportunities by implementing policies and practices that ensure employees and applicants are not discriminated against because of their race, color, religious creed, national origin, ancestry, sex, gender, gender identity or expression, sexual orientation, age, mental or physical disability, medical condition, genetic information, military or veteran status or other legally protected status. This applies to recruitment, selection, placement, promotion, termination, rates of pay, and other conditions of employment.

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

Qualifications

• 2 – 5 Years’ experience administering SQL Server databases/instances
• 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 Agile methodology
• Bachelor's degree in Information Technology or related field required

Benefits

• Global Fortune 500\u202fCompany with a wide array of growth and development opportunities
• As a U.S. PACCAR employee, you have a full range of benefit options including:
• 401k with up to a 5% company match
• Fully funded pension plan that provides monthly benefits after retirement
• Comprehensive paid time off – minimum of 10 paid vacation days (additional days are provided with additional seniority/years of service), 12 paid holidays, and sick time
• Tuition reimbursement for continued education
• Medical, dental, and vision plans for you and your family
• Flexible spending accounts (FSA) and health savings account (HSA)
• Paid short-and long-term disability programs
• Life and accidental death and dismemberment insurance
• EAP services include wellness plans, estate planning, financial counseling and more
• We carefully consider numerous compensation factors including your education, training, or experience
• The salary range for Database Administrator is $93,00-$145,500 annually