Los Angeles County Metropolitan Transportation Authority (CA)
SENIOR SOFTWARE ENGINEER (ORACLE)
Los Angeles County Metropolitan Transportation Authority (CA), Los Angeles, California, United States, 90079
Overview
Provides lead technical, administrative, and programming support to key organizational functions in performing system analysis, design and programming, troubleshooting, modifications, maintenance, implementation, and integration of one or more systems comprising large and/or highly complex application areas and processes; recommends new technologies to improve efficiency and ensure quality. This position serves as a lead developer and supports Payroll and HR systems, requiring strong technical skills. The role is responsible for the full lifecycle of system support, including analysis, design, development, integration, implementation, and maintenance of enterprise applications. The incumbent will work with technologies such as Oracle HCM (Human Capital Management) Suite, Oracle E-Business Suite (EBS), and Microsoft platforms to build custom applications and system integrations. In addition to hands-on development, this position will provide technical guidance, troubleshoot complex issues, and collaborate with stakeholders to recommend solutions that improve efficiency, ensure compliance, and support evolving business needs. Responsibilities
Analyzes issues, designs and develops solutions, and implements complex application information systems using change control procedures based upon user priorities Develops systems and/or applications native to Oracle EBS (E-Business Suite), or other computer applications for ERP, CRM, and SCM processes Provides status of ongoing projects regarding upgrades and issues Supports system maintenance coordinating with Database group Estimates the efforts required for each task and updates supervisors Develops interfaces for different systems to communicate with each other Advises user departments and other Information Technology Services (ITS) support teams on system requirements, enhancements, and new technologies Provides technical direction for a team of technical staff; sets guidelines and exercises leadership skills to establish and meet target dates on large and highly complex projects involving multiple systems Recommends approval of system designs and interacts with user managers and department users in a senior leadership capacity Researches, identifies, and refers complex technical problems related to platform management, database administration, network connectivity, and desktop support to the appropriate ITS operating unit for resolution Advises user departments and other ITS support teams on system requirements and enhancements Oversees the preparation of project reports, such as technical overviews, client recommendations, alternatives to business requirements, feasibility studies, project proposals, and requests for proposals for the purchase of new software and hardware Monitors and leads consultants in the analysis, design, implementation, and integration of application business systems Leads in the evaluation of commercial off-the-shelf (COTS) software Oversees the configuration, implementation, and integration of COTS software Develops software and hardware specifications and standards Ensures that clients have the necessary training and documents to properly utilize computer systems Leads the department's information security, disaster recovery, and safety programs Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out May be required to perform other related job duties Education and Experience
A combination of education and/or experience that provides the required knowledge, skills, and abilities to perform the essential functions of the position. Additional experience, as outlined below, may be substituted for required education on a year-for-year basis. A typical combination includes: Education Bachelor's Degree in Computer Science or a related field Experience Four years of relevant experience in designing, implementing, and maintaining complex information systems in a relational database network environment Certifications/Licenses/Special Requirements A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions Based on assignment, Microsoft Certified Solutions Associate (MCSA) certification, Microsoft Office Specialist (MOS) on SharePoint 2010, Microsoft Certified Technology Specialist (MCTS) for Office 365, or Adobe Certified Associate (ACA) preferred Preferred Qualifications Preferred Qualifications (PQs) are used to identify relevant knowledge, skills, and abilities (KSAs) as determined by business necessity. These criteria are considered preferred qualifications and are not intended to serve as minimum requirements for the position. PQs will help support selection decisions throughout the recruitment. In addition, applicants who possess these PQs will not automatically be selected. The following are the preferred qualifications:
Experience developing and supporting applications using SQL, PL/SQL, Oracle Forms/Reports, Oracle APEX, BI Publisher, and Workflow, with a strong understanding of relational database design to deliver scalable, high-performing solutions in production environments Experience developing and customizing Oracle ERP and/or HCM solutions, including system integrations and extensions Experience analyzing complex business requirements, particularly in Human Resources and Payroll domains, and designing scalable, efficient technical solutions Experience developing reports and dashboards using Power BI, Tableau, and OTBI Knowledge
Theories, principles, and practices related to information systems and supported business areas Applicable local, state, and federal laws, rules, and regulations governing information systems for a public agency Transit data, schedules, routes, patterns, and best practices Oracle ADF programming and Oracle applications Microsoft Office 365 and SharePoint Mobile application technology Programming languages, including PL/SQL, Java, and Visual Basic Software and computer operating systems, including Linux, Unix, and network technology Project management techniques and tools Mathematics used in complex business applications Business process and system process modeling and problem-solving techniques Skills
Developing and implementing complex information systems using software engineering techniques Developing and implementing web-based computer applications Windows server administration Programming using .Net Clearly defining system integration and interface requirements Data analysis and data modeling Creative problem solving Using a personal computer and associated applications Effective oral and written communication Training non-technical users in a variety of applications Identifying opportunities for innovation Abilities
Function as a technical lead, providing technical project management across multiple projects and concurrent tasks Understand current customer needs, resolve conflicting project and/or client requirements, and plan for future growth Analyze and evaluate system changes to determine feasibility Analyze situations, identify problems, and recommend and implement solutions in a cost-effective manner Identify and resolve conflicting project and/or client requirements Manage systems that are in production Identify errors and resolve issues in a timely manner Understand, interpret, and apply laws, business rules, regulations, policies, procedures, and contracts to support business processes Prepare reports, proposals, presentations, and correspondence in a professional manner Interact professionally with various levels of employees and outside representatives Learn new technology and complex systems Meet tight time constraints and project deadlines Maintain confidentiality regarding sensitive information Read, write, speak, and understand English Special Conditions
The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job. Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions. Working Conditions
Typical office situation Close exposure to computer monitors and video screen Physical Effort Required
Sitting at a desk or table Operate a telephone or other telecommunications device and communicate through the medium Type and use a keyboard and mouse to perform necessary computer-based functions Communicating through speech in the English language required (JC)
#J-18808-Ljbffr
Provides lead technical, administrative, and programming support to key organizational functions in performing system analysis, design and programming, troubleshooting, modifications, maintenance, implementation, and integration of one or more systems comprising large and/or highly complex application areas and processes; recommends new technologies to improve efficiency and ensure quality. This position serves as a lead developer and supports Payroll and HR systems, requiring strong technical skills. The role is responsible for the full lifecycle of system support, including analysis, design, development, integration, implementation, and maintenance of enterprise applications. The incumbent will work with technologies such as Oracle HCM (Human Capital Management) Suite, Oracle E-Business Suite (EBS), and Microsoft platforms to build custom applications and system integrations. In addition to hands-on development, this position will provide technical guidance, troubleshoot complex issues, and collaborate with stakeholders to recommend solutions that improve efficiency, ensure compliance, and support evolving business needs. Responsibilities
Analyzes issues, designs and develops solutions, and implements complex application information systems using change control procedures based upon user priorities Develops systems and/or applications native to Oracle EBS (E-Business Suite), or other computer applications for ERP, CRM, and SCM processes Provides status of ongoing projects regarding upgrades and issues Supports system maintenance coordinating with Database group Estimates the efforts required for each task and updates supervisors Develops interfaces for different systems to communicate with each other Advises user departments and other Information Technology Services (ITS) support teams on system requirements, enhancements, and new technologies Provides technical direction for a team of technical staff; sets guidelines and exercises leadership skills to establish and meet target dates on large and highly complex projects involving multiple systems Recommends approval of system designs and interacts with user managers and department users in a senior leadership capacity Researches, identifies, and refers complex technical problems related to platform management, database administration, network connectivity, and desktop support to the appropriate ITS operating unit for resolution Advises user departments and other ITS support teams on system requirements and enhancements Oversees the preparation of project reports, such as technical overviews, client recommendations, alternatives to business requirements, feasibility studies, project proposals, and requests for proposals for the purchase of new software and hardware Monitors and leads consultants in the analysis, design, implementation, and integration of application business systems Leads in the evaluation of commercial off-the-shelf (COTS) software Oversees the configuration, implementation, and integration of COTS software Develops software and hardware specifications and standards Ensures that clients have the necessary training and documents to properly utilize computer systems Leads the department's information security, disaster recovery, and safety programs Contributes to ensuring that the Equal Employment Opportunity (EEO) policies and programs of Metro are carried out May be required to perform other related job duties Education and Experience
A combination of education and/or experience that provides the required knowledge, skills, and abilities to perform the essential functions of the position. Additional experience, as outlined below, may be substituted for required education on a year-for-year basis. A typical combination includes: Education Bachelor's Degree in Computer Science or a related field Experience Four years of relevant experience in designing, implementing, and maintaining complex information systems in a relational database network environment Certifications/Licenses/Special Requirements A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions Based on assignment, Microsoft Certified Solutions Associate (MCSA) certification, Microsoft Office Specialist (MOS) on SharePoint 2010, Microsoft Certified Technology Specialist (MCTS) for Office 365, or Adobe Certified Associate (ACA) preferred Preferred Qualifications Preferred Qualifications (PQs) are used to identify relevant knowledge, skills, and abilities (KSAs) as determined by business necessity. These criteria are considered preferred qualifications and are not intended to serve as minimum requirements for the position. PQs will help support selection decisions throughout the recruitment. In addition, applicants who possess these PQs will not automatically be selected. The following are the preferred qualifications:
Experience developing and supporting applications using SQL, PL/SQL, Oracle Forms/Reports, Oracle APEX, BI Publisher, and Workflow, with a strong understanding of relational database design to deliver scalable, high-performing solutions in production environments Experience developing and customizing Oracle ERP and/or HCM solutions, including system integrations and extensions Experience analyzing complex business requirements, particularly in Human Resources and Payroll domains, and designing scalable, efficient technical solutions Experience developing reports and dashboards using Power BI, Tableau, and OTBI Knowledge
Theories, principles, and practices related to information systems and supported business areas Applicable local, state, and federal laws, rules, and regulations governing information systems for a public agency Transit data, schedules, routes, patterns, and best practices Oracle ADF programming and Oracle applications Microsoft Office 365 and SharePoint Mobile application technology Programming languages, including PL/SQL, Java, and Visual Basic Software and computer operating systems, including Linux, Unix, and network technology Project management techniques and tools Mathematics used in complex business applications Business process and system process modeling and problem-solving techniques Skills
Developing and implementing complex information systems using software engineering techniques Developing and implementing web-based computer applications Windows server administration Programming using .Net Clearly defining system integration and interface requirements Data analysis and data modeling Creative problem solving Using a personal computer and associated applications Effective oral and written communication Training non-technical users in a variety of applications Identifying opportunities for innovation Abilities
Function as a technical lead, providing technical project management across multiple projects and concurrent tasks Understand current customer needs, resolve conflicting project and/or client requirements, and plan for future growth Analyze and evaluate system changes to determine feasibility Analyze situations, identify problems, and recommend and implement solutions in a cost-effective manner Identify and resolve conflicting project and/or client requirements Manage systems that are in production Identify errors and resolve issues in a timely manner Understand, interpret, and apply laws, business rules, regulations, policies, procedures, and contracts to support business processes Prepare reports, proposals, presentations, and correspondence in a professional manner Interact professionally with various levels of employees and outside representatives Learn new technology and complex systems Meet tight time constraints and project deadlines Maintain confidentiality regarding sensitive information Read, write, speak, and understand English Special Conditions
The physical demands described are representative of those that must be met by the employee to successfully perform the essential functions of this job. Metro provides reasonable accommodation to enable individuals with disabilities to perform the essential functions. Working Conditions
Typical office situation Close exposure to computer monitors and video screen Physical Effort Required
Sitting at a desk or table Operate a telephone or other telecommunications device and communicate through the medium Type and use a keyboard and mouse to perform necessary computer-based functions Communicating through speech in the English language required (JC)
#J-18808-Ljbffr