ORACLE PL/SQL

Sep 2015 to Jan 2018: (Contractor) REMOTE Senior DBA/Developer/Architect (Oracle/PostgreSQL/SQLserver) for Cast and Crew, Burbank, CA. Performed DBA and Developer duties included monitoring OLTP systems for E-Business Suite (EBS 12.1) and in-house applications, Data Guard, participating in On-Call rotation, working with QA/Development team members, adding indexes and Materialized Views to improve application performance, resolving Service Desk tickets, adding/removing EBS users and roles, promoting code releases between Dev/Test/UAT/Production, providing data models(Erwin) and DB documentation, executing SQL fixes for Production data, writing SQL queries to resolve issues, pulling reports to analyze the data, DB/SQL tuning, and data cleansing. Additional duties include developing a web-based Self-Service application allowing QA/Analysts/Developers to move data/files between systems as needed and generate ad-hoc web-based reports. Development of Oracle PL/SQL (dynamic SQL)..

Primary location: Cypress United States