Data Platform Engineer II (IBMi and DB2)

Penske Truck Leasing and Logistics • Full-time • Reading, Pennsylvania, United States • $89.50k - $125.69k / year • 3m ago

About Penske:

Most people know us for our big yellow trucks. But we’re so much more than that. At Penske we have a 50-plus year history of leading the transportation and supply-chain industry, delivering world-class and award-winning technology solutions and the key to our success is our people.

We are experiencing rapid business growth and have added headcounts to IT teams across the organization to keep up with this expansion. We are hiring immediately for full-time, long-term roles. At Penske you will ensure our technology solutions keep our company and our customers moving forward.

What You Will Be Doing:

As a Penske Data Platform Engineer II, you will participate in all aspects of guiding and supporting development teams as they implement and deploy their applications on cloud or on-premise platforms. In this role, you will specifically be responsible for the DB2 environment. You will work with the software development teams to troubleshoot issues as they occur while also building, scaling, and maturing the DB2 for i (a.k.a. DB2/400, IBM i, iSeries) platform. You will have an opportunity to lead the design of certain platform components and suggest new technology/tools based on industry and technological trends and advances. You will also consult with product owners and senior members of the staff to understand the business and application requirements and provide suggestions based on platform best practices. Focusing on high-level and technical systems design you will collaborate with Architects and Engineers to help build and maintain a robust environment for application development, deployment, hosting, data storage and ingestion.

Penske Responsibilities:

Act as the primary contact and lead support associate for multiple critical components of the platform and help resolve customer issues in a timely manner
Collaborate with platform product owners and play a critical role in end-to-end Operations Management of Application/Data Platform as a Service
Collaborate with technical/business leaders and platform product owners to acquire and understand requirements / acceptance criteria and provide platform stability
Participate in capacity planning, disaster recovery and high availability planning
Recommend observability standards and enable platform observability through logging and monitoring
Triage production issues and work with multiple teams to perform problem analysis
Run through query review workflow
Identify poorly running processes in production - CPU, plan cache analysis
Execute data fixes
Help with overnight DB deploys
Perform on-going research to explore new features, versions, and related technologies, and provide recommendations to enhance our offerings
Document standard run books and operating procedures and assign/review tasks from junior and offshore associate engineers
Participate in conducting new hire interviews
Work closely with the project team and report clearly and accurately to management
Build and maintain stable working relationships internally
Other duties as assigned

Penske Qualifications:

Bachelor’s degree in Computer Science/Computer Engineering or equivalent years of software development/system administration experience required
8-10 years of industry experience with knowledge of IBM i server and Db2 for i platform administration and programming languages required
5+ years of hands-on DBA experience working with DB2 for i
3+ years of experience with relational database (RDBMS) and OLTP/OLAP concepts
Basic IBM i navigation - ACS, Schemas, Run SQL, plan cache, calling a program, stored procedure, creating UDF, etc.
Writing complex SQL queries that use joins, sub-selects, with statements
Demonstrated ability to support and administer high volume and high velocity application/data environments
Strong experience with relational database (Db2 for i, a.k.a DB2/400) administration
Experience with build management and continuous integration tools preferred
Understanding of DevOps concepts
Professional demeanor works effectively in a team setting
Knowledge and experience of the Agile software development methodology
Aptitude and desire for learning new technologies and concepts
Ability to estimate medium to large-sized platform activities
Excellent verbal and written communication skills
Regular, predictable, full attendance is an essential function of the job
Willingness to travel as necessary, work the required schedule, work at the specific location required, complete Penske employment application, submit to a background investigation (to include past employment, education, and criminal history) and drug screening are required.

EEO Statement

Penske is an Equal Opportunity Employer.

Physical Requirements:

The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
The associate must regularly lift and /or move up to 25lbs/12kg.
Specific vision abilities required by this job include Close vision, Distance vision, Peripheral vision, Depth perception and Ability to adjust focus.
While performing the duties of this Job, the associate is regularly required to stand; walk; sit and talk or hear. The associate is frequently required to use hands to finger, handle, or feel and reach with hands and arms.

About Penske Truck Leasing

Penske Truck Leasing Co., L.P., headquartered in Reading, Pennsylvania, is a partnership of Penske Corporation, Penske Automotive Group and Mitsui & Co., Ltd. A leading global transportation services provider, Penske operates a premier fleet of vehicles and serves its customers from locations in North America, South America, Europe, Australia, and Asia. Penske’s product lines include full-service truck leasing, contract maintenance, commercial and consumer truck rentals, used truck sales, transportation and warehousing management and supply chain management solutions. Visit www.GoPenske.com to learn more.

Job Category: Information Technology

Job Family: Information Technology

Address: 100 Gundy Drive

Primary Location: US-PA-Reading

Employer: Penske Truck Leasing Co., L.P.

Req ID: 2505680