Data Platform Engineer I (IBM i Db2)

About Penske:Most people know us for our big yellow trucks. But were 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 mannerCollaborate with platform product owners and play a critical role in end-to-end Operations Management of Application/Data Platform as a ServiceCollaborate with technical/business leaders and platform product owners to acquire and understand requirements / acceptance criteria and provide platform stabilityParticipate in capacity planning, disaster recovery and high availability planningRecommend observability standards and enable platform observability through logging and monitoringTriage production issues and work with multiple teams to perform problem analysisRun through query review workflowIdentify poorly running processes in production - CPU, plan cache analysisExecute data fixesHelp with overnight DB deploysPerform on-going research to explore new features, versions, and related technologies, and provide recommendations to enhance our offeringsDocument standard run books and operating procedures and assign/review tasks from junior and offshore associate engineersParticipate in conducting new hire interviewsWork closely with the project team and report clearly and accurately to managementBuild and maintain stable working relationships internallyOther duties as assignedPenske Qualifications:Bachelors degree in Computer Science/Computer Engineering or equivalent years of software development/system administration experience required8-10 years of industry experience with knowledge of IBM i server and Db2 for i platform administration and programming languages required5+ years of hands-on DBA experience working with DB2 for i3+ years of experience with relational database (RDBMS) and OLTP/OLAP conceptsBasic 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 statementsDemonstrated ability to support and administer high volume and high velocity application/data environmentsStrong experience with relational database (Db2 for i, a.k.a DB2/400) administrationExperience with build management and continuous integration tools preferredUnderstanding of DevOps conceptsProfessional demeanor works effectively in a team settingKnowledge and experience of the Agile software development methodologyAptitude and desire for learning new technologies and conceptsAbility to estimate medium to large-sized platform activitiesExcellent verbal and written communication skillsRegular, predictable, full attendance is an essential function of the jobWillingness 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 requiredEEO StatementPenske 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 LeasingPenske 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. Penskes 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 TechnologyJob Family: Information TechnologyAddress: 100 Gundy DrivePrimary Location: US-PA-ReadingEmployer: Penske Truck Leasing Co., L.P.Req ID: 2414451