What are the responsibilities and job description for the Programmer/Analyst - Oracle/SQL position at The Timberline Group?
Qualifications
Responsibilities
- B.A./B.S. or equivalent experience required.
- M.S./MBA desirable
- Three (3) years minimum experience required
- Experience implementing and maintaining 3rd party information technology systems (on-premise and SaaS).
- Experience with problem identification and correction in complex applications and environments.
- Experience with Oracle relational databases and SQL. Experience with SQL Server a plus.
- Ability to write and debug SQL. Evaluate data quality/issues in large databases.
- Understanding of administrative and operational business systems and applications.
- Experience with design and development of reports for business users. Tableau a plus.
- Knowledge of the transit industry or previous experience with transit information systems a plus.
- Understanding of information technology standards, procedures, and best practices.
- Understanding of how to analyze and solve business problems.
- Knowledge of current computing equipment, software, and communications technology.
- Ability to analyze and assess business needs to recommend appropriate information technology solutions.
- Ability to interact and communicate effectively, both orally and in writing, with groups from diverse backgrounds and technical abilities.
- Ability to work independently, set priorities, work under pressure, adapt to demanding situations, and maintain schedules.
- Ability to troubleshoot a variety of application hardware, configure firmware and upload updates.
- Experience with the following technologies/applications: Microsoft Windows 10; Microsoft Office Suite, Microsoft Visio; SQL; Oracle; SQL, Tableau; Client/Server applications; Trapeze Software modules (PASS, FX, INFO-Web, others), Revenue related applications.
Responsibilities
- Meet with decision makers, systems owners, and end users to define business and technical requirements, systems goals, and identify and resolve systems issues.
- Formulate and define system scope and objectives.
- Devise or modify procedures to solve complex problems considering available infrastructure, requirements, and required results.
- Implement and verify new applications and changes to existing applications.
- Determine application and process changes that enhance business processes, operations, and information process flows.
- Assist in developing strategies for improving or further leveraging these systems.
- Prepare and deliver reports, recommendations, or alternatives that address existing and potential trouble areas in applications assigned to you.
- Collaborate in the planning, design, development, and deployment of new applications and enhancements to existing applications.
- Assist with cost/benefit analysis for proposed systems to aid management in decision-making.
- Ensure compatibility and interoperability of computer systems.
- Create systems models, specifications, diagrams, and charts as needed for communication and support.
- Prepare detailed program specifications using company standard application methodology
- Fully understand and adhere to application implementation standards as defined by company.
- Provide orientation and training to end users for all modified and new systems.
- Conduct research on software and hardware products to justify recommendations and to support purchasing efforts.
- Provide guidance and/or instruction to other IT staff members to enhance department capabilities.
