Senior Oracle Programmer Analyst

Los Angeles, CA

12 months

Minimum Qualifications:

Bachelor of Science (BS) degree in computer science or closely related field.

6 years of experience with Oracle utilizing PL-SQL programming objects, Oracle database objects, Unix scripting and experience with Toad/Oracle SQL Developer, Data Modeler, Oracle 12c and/or later

6 years of experience writing stored procedures, T-SQL, functions, Packages, Triggers, and SQL queries

Experience utilizing report writing best practices (optimization, use of joins and sub-queries)

Experience pulling data from Oracle 12c and/or higher databases for reports and interfaces

6 years of experience with MAPPER (Maintain, Prepare, and Produce Executive Reports)/ BIS (Business Information Server)

Responsibilities:

Maintain and provide support for a critical application running on MAPPER (Maintain, Prepare, and Produce Executive Reports)/BIS (Business Information Server)

Provide support to Business Analyst(s) in gathering and/or clarifying data and functional requirements from business owners

Develop, Deploy and/or maintain interfaces & reports in accordance with Client requirements and standards using Oracle 12c and/or higher and Microsoft SQL Server

Reporting Services (SSRS) 2012 and/or higher

Develop data interface packages, shell scripts in accordance with Client requirements and standards using Oracle and Unix shell scripts

Develop and maintain database stored procedures, views, functions and/or packages

Develop SQL queries and support ad hoc requests for data

Identify and troubleshoot business process or data quality issues that show up in the reports and interfaces and subsequently communicate to resolve and eliminate problems

Regards

Naresh Damagalla

West Advanced Technologies, Inc

E: naresh.d@wati.com D: 279-666-5838 M: 916-694-5317

Serving government agencies for 22 Years

www.wati.com