AMtec Industries, Inc. Logo

AMtec Industries, Inc.

PL/SQL Developer

Posted Yesterday
Be an Early Applicant
In-Office
La Verne, CA, USA
Mid level
In-Office
La Verne, CA, USA
Mid level
Provide technical support and development for Banner enterprise applications: review, test, and implement code changes and upgrades; develop reports, dashboards, and interfaces; collaborate with BI analysts to ensure ODS/EDW feeds; document and manage software library deployments; troubleshoot, escalate, and maintain system availability while ensuring data security and user access.
The summary above was generated by AI
Job Description

Job Title: Programmer Analyst

Job Location: La Verne, CA

Type of Work/Duration: Contract-to-Direct Hire


Provide technical Enterprise Application Software support for Banner systems: review and test code changes / upgrades to determine impact on users; plan and conduct upgrades / updates into Development and Test environments; help to ensure maximum availability of Banner systems; assist Lead Programmer Analyst with Banner related updates, changes and upgrades; document, insert into Software Library, and implement in Development, Test, and then Production new reports, listings, dashboards and interfaces developed by OIT and non-OIT personnel. Liase with Business Intelligence analyst to help ensure ODS and EDW feeds are working properly and correct; Aid in the definition and design of any business cube design/re-design


Review of issues/problems, assess situations, and escalate to lead OIT personnel and even third parties as appropriate. Review and assess policies and practices for the improvement and maintenance of the Banner systems to include rollout, updates, code changes and upgrades. Establish and maintain cooperative working relationships with those contacted in the performance of duties.


In support of Enterprise Applications Department, work directly with users to: conduct feasibility studies of new programming requests; identify and document software purpose, workflow issues, and output needs; develop alternative solutions; write up programming specifications and system flow charts; develop prototypes; design user-friendly interfaces to systems, applications, reports and databases; identify current operating procedures; and clarify program objectives.


Work closely with user department representatives and vendors on their day-to-day support and development assignments with regards to the University's Banner systems. Ensure appropriate access is provided to them to perform their duties yet maintain University data security and confidentiality. Monitor work quality and provide testing of all processes before moving code into Production.


Other technology-related duties as assigned.

Qualifications

Bachelor's Degree required

3+ years of experience

PL/SQL (must)

Oracle Forms

Oracle 11g

Programming Logic


Preferred:

Master's Degree

Cognos

ODS

EDW

Additional Information

All your information will be kept confidential according to EEO guidelines.

Similar Jobs

12 Days Ago
In-Office
Senior level
Senior level
Information Technology • Professional Services • Consulting
Develop and maintain Oracle PL/SQL database objects (procedures, functions, packages, triggers, types). Design, construct, test, and document normalized relational database models and physical designs. Create DDL/DML scripts, stored procedures, data migration/import/export routines, and workflows. Troubleshoot data integration and performance issues, implement access controls, and perform change impact analysis. Work in an Agile environment and must pass background and drug screening.
Top Skills: Oracle DatabaseOracle Pl/SqlSQL
4 Days Ago
In-Office or Remote
United States
40K-142K Annually
Senior level
40K-142K Annually
Senior level
Agency • Information Technology
Design, develop, and maintain web applications and RESTful APIs using Java/Spring Boot. Develop and maintain PL/SQL stored procedures and Oracle database logic. Participate across the SDLC, troubleshoot backend and database issues, collaborate with cross-functional teams, and improve development processes and tooling.
Top Skills: GitJavaOraclePl/SqlRestSpring BootSQL
11 Days Ago
In-Office
Torrance, CA, USA
Senior level
Senior level
Information Technology • Professional Services • Software • Consulting
Support and enhance a CRM analytical repository: design, develop and tune Informatica ETL mappings, write efficient PL/SQL for large datasets, perform ETL performance tuning and root-cause analysis, maintain Unix/AIX scripts, and provide 24/7 production support for CRM analytics and campaign operations.
Top Skills: Data WarehousingETLInformaticaOracleOracle Parallel ExecutionOracle PartitioningPl/SqlShell ScriptingSQLUnix Aix

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account