Senior Oracle Programmer AnalystLos Angeles, CA12 monthsMinimum 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 later6 years of experience writing stored procedures, T-SQL, functions, Packages, Triggers, and SQL queriesExperience 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 interfaces6 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 ownersDevelop, Deploy and/or maintain interfaces & reports in accordance with Client requirements and standards using Oracle 12c and/or higher and Microsoft SQL ServerReporting Services (SSRS) 2012 and/or higherDevelop data interface packages, shell scripts in accordance with Client requirements and standards using Oracle and Unix shell scriptsDevelop and maintain database stored procedures, views, functions and/or packagesDevelop SQL queries and support ad hoc requests for dataIdentify and troubleshoot business process or data quality issues that show up in the reports and interfaces and subsequently communicate to resolve and eliminate problemsRegardsNaresh DamagallaWest Advanced Technologies, Inc