Data Platform Engineer I (IBM i Db2)

Company: Penske
Location: Reading
Posted on: November 10, 2024

Job Description:

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. Going into Winter 2021/2022, 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 I, 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: 2414451

Keywords: Penske, Lancaster , Data Platform Engineer I (IBM i Db2), Professions , Reading, Pennsylvania