Job DescriptionCompany 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 designs and manufactures advanced diesel engines andalso provides customized financial services, information technology and truck parts related to its principal business.
Whether you want to design the transportation technology of tomorrow, support the staff functions of a dynamic, international leader, or build our excellent products and services - you can develop the career you desire with PACCAR. Get started!
Division Information
PACCAR's Information Division (ITD), located in Renton, WA utilizes cutting-edge technology to provide systems development, consulting, voice and data communications services to the entire Corporation, which has high visibility in the technology sector.
Requisition Summary
PACCAR is a global truck technology leader with operations around the world. The Digital Solutions team is helping PACCAR make better decisions faster by moving to the cloud, adopting DevOps/CICD best practices, and unlocking a new level of productivity & value. We are looking for technology leaders to drive this evolution.
We are looking for an experienced Database Administrator of SQL and PostgreSQL databases to manage thousands of enterprise-level databases in a scalable database solution. The ideal candidate is enthusiastic about learning new technologies and implementing them to empower internal customers and scale the existing platform. The ideal candidate demonstrates reliable business and communication skills and works with business and technical teams. In this role, you would serve as the expert at designing, implementing, and operating stable, scalable, and low-cost database solutions. The Database Administrator would design, develop, implement, test, document, and operate large-scale, high-volume, high-performance database structures. Implement data structures using best practices in data modeling. Will provide operational database services to the organization, and own, track, and resolve database-related incidents and requests. On a day-to-day level, there will be database backups, maintenance, monitoring, and responding to database-related alerts and escalations.
The DBA would be tuning performance on queries running over millions of rows of data. The person in this position should be analytical, have a high customer focus, and have a passion for process improvement. The Database Administrator should be a motivated self-starter who can work independently in a fast-paced, ambiguous environment and have excellent business acumen and communication skills to work with business owners to develop and define key business questions.
Job Functions/Responsibilities
Design, implement and support SQL Database transactional and data warehouse infrastructure on-prem and in the Cloud, such as AWS and Azure.
Installation, administration and configuration of PostgreSQL.
Performing PostgreSQL and SQL DB patching, investigate and remediate vulnerabilities.
Support for Microsoft SSIS, SSRS, and SSAS.
Conduct performance tuning for SQL Server in various aspects such as Server, database, and stored procedure.
Generate scripts for database deployment. Familiar with DevOps methodology to automate the database deployment.
Provide database support estimates for new projects.
Support multiple RDBMS engines and work in the AWS Cloud or Azure environment.
Support for Agile projects related to databases.
Contributes to and maintains database standards.
Ensures security is integrated into all data solutions to meet compliance standards.
Perform database backup and restore procedures. Have experience with Disaster Recovery procedures and validation.
Support SQL Server database migrations or upgrades.
SQL Azure or SQL Server on AWS management experience.
Experience in SQL Azure or SQL Server on AWS to perform DB maintenance without direct access to server infrastructure.
Experience in SQL Azure database or SQL Server on AWS backup and point in time recovery using best practices.
SQL Azure or SQL Server on AWS performance tuning experience and how to analyze log events to log analytics.
Experience in Attunity/Qlik Replication Tool to bring data from source to target is a plus.
Qualifications
5+ years' relevant experience in data modeling and data architect.
Expertise with SQL and relational database systems.
Experience with SQL and/or PostgreSQL development.
Previous experience migrating an environment to PostgreSQL.
Knowledge of data warehousing concepts.
Knowledge of data mining, ETL, and using databases in a business environment with large-scale, complex datasets.
Experience in SQL Azure or SQL Server on AWS to perform DB maintenance without direct access to server infrastructure.
Experience in generating scripts for physical database deployment.
Familiarity with ETL tools and techniques.
Knowledge of more than one database platform, such as MySQL, PostgreSQL, and Oracle.
Knowledge of CI/CD pipelines and automating Database deployments.
Knowledge of standard data model reports.
Must know data normalization and denormalization techniques.
Excellent interpersonal and organizational skills, including active listening, problem-solving when under pressure, and facilitation.
Strong troubleshooting and problem-solving skills.
Strong scripting skills preferred, such as Python programming language or PowerShell.
Education
Bachelor's degree in Computer Science, or related field
PACCAR Benefits
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 including wellness plans, estate planning, financial counseling and more
Diversity and Inclusion
corporation. Having a diverse and inclusive work environment ensures PACCAR has the talent needed to conduct business today and in the future by leveraging different backgrounds, skills, and viewpoints. We believe diversity in the workplace increases innovation, results in better decisions, and increases employee engagement.
PACCAR's IT Division promotes Diversity and Inclusion through mentorship, events, celebrations, and affinity groups. The IT Division has an active Diversity Council and supports initiatives and activities for all. PACCAR supports women through the PACCAR Women's Association (PWA), Women in Trucking, and Women in Technology International (WITI). Educational awareness programs such as Unconscious Bias, Male Allyship and Inclusive Leadership are just a few of many trainings offered. PACCAR is a supporter of PRIDE and celebrates many different multi-cultural events.
Additional Job Board Information
PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability. 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 theDatabase Administrator is $93,000 - $145,500 annually. Additionally, this role is eligible for a full range of benefit options listed above.This position is also eligible for a holiday gift.
PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability.