We provide IT Staff Augmentation Services!

Oracle Developer (pl/sql)/sub Version Management Resume

Washington, DC

PROFESSIONAL SUMMARY:

  • Expertise in Oracle: PL/SQL, SQL, Database Administration, Database Development and Design, BRM (Business revenue management) deployment, Data integrator, Oracle Data Warehouse Builder (OWB), OLAP, fusion middleware, BI publisher, Golden Gate, Data guard, Slack and RMAN.
  • Created and supported ETL and BI functions to complete performance tuning for COTS SQL for improvements.
  • Managed Extract, Transform, and Load (ETL) processing by using the Talend and Oracle (OWB) ETL tools to seamlessly integrate all data functionality.
  • Created new ETL (OWB) and PL/SQL scripts to support the Oracle Data Warehouse.
  • Coded using PL/SQL and Talend ETL to create and maintain stored procedures and triggers.
  • Well versed in System operations on AWS (Amazon Web Services).
  • Experienced with Talend and OWB ETL Tools, Gird control, RAC, GitHub, Git, SVN, Wiki, JIRA, Bit bucket, VMware, VMWare ESXI, Virtual Box, SQL/ Server Developer, and Data modeling.

TECHNICAL SKILLS:

  • PL/SQL
  • Oracle
  • SQL Server
  • MySQL
  • MS - Access
  • PostgreSQL
  • DB2
  • Sybase
  • Oracle BI publisher 11g
  • AWS (Amazon web services)
  • SAS
  • Joomla
  • Html
  • JavaScript
  • VB
  • VB.NET
  • DOT.NET
  • Oracle Golden Gate
  • Oracle Data Guard
  • Oracle Warehouse Builder
  • Grid Control
  • RAC
  • Oracle IAS
  • Oracle Forms
  • Oracle Reports
  • Oracle People Soft
  • Oracle Business Intelligence
  • MS-Internet Information Services (IIS)
  • Win SCP
  • Oracle SQL
  • Oracle SQL Developer (Oracle
  • SQL Server)
  • Oracle data integrator
  • Talend ETL (Extract transform and loading)
  • Oracle SOAPUI
  • Postman
  • Oracle Slack
  • Wiki
  • JIRA
  • GitHub
  • Git
  • SVN
  • Bit bucket
  • UNIX Commands & Shell Scripts
  • VMware ESXI
  • VMware
  • Virtual Box
  • MS office
  • CVS
  • MS Visual source safe
  • Crystal report
  • Power Designer
  • ETL Tool
  • Swis tool to convert databases
  • Aqua data studio tool for databases
  • TOAD tool for Databases
  • EMS tool for databases (Oracle
  • SQL Server)
  • Bugzilla
  • Linux/UNIX
  • Sun Solaris
  • Windows
  • Borland JBuilder
  • AdobeFlex Builder

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Oracle Developer (PL/SQL)/Sub version Management

Responsibilities:

  • Created stored procedures, functions, triggers, and views
  • Updated and modified existing stored procedures, functions, triggers, and views
  • Created object types, packages, and package body
  • Developed and tuned SQL and PL/SQL code
  • Responsible for writing database DML (SQL) scripts
  • Designed, built and developed ETL procedures
  • Created Explicit Cursor, Ref Cursor, V-Arrays, Nest Tables, Collection Records, and Bulk Collections
  • Debugged and Resolved Oracle SQL/PLSQL code issues
  • Utilized Oracle SQL commands to retrieve data from table, view
  • Built PL/SQL stored procedures, data modeling, dictionary and entity relationships
  • Completed performance tuning of complex stored procedures, functions, triggers, and views
  • Created logical and physical database design
  • Created multiple scripts
  • Participated in code reviews and ensured that code complied with company standards and policies

Confidential, Herndon, VA

Oracle Developer (PL/SQL)

Responsibilities:

  • Responsible for debugging and resolving SQL/PLSQL code issues
  • Managed PL/SQL stored procedures, data modeling, dictionary, entity relationships
  • Supported Extract, Transform, and Load (ETL) processing
  • Utilized ETL and BI to tune COTS SQL for performance improvements
  • Created stored procedures, functions, and triggers
  • Created Explicit Cursor, Ref Cursor, VArrays, Nest Tables, and Bulk Collections
  • Documented, maintained and supported data standards for the Data Warehouse, including security, archiving, backup and recovery
  • Performed database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
  • Supported all database environments including development, test, and production. Interface with test teams to support test strategies and plans
  • Used Git to checkout, push, and pull projects source code

Oracle DBA / AWS

Responsibilities:

  • Created database, schemas on Oracle server
  • Created Oracle instances and manage users, roles and Oracle table spaces
  • Managed Extract, Transform, and Load (ETL) processing by using the Talend tool
  • Performed Database Backup and recovery using RMAN, Data Guard, logical backups, and Oracle Enterprise Manager
  • Utilized AWR and ADDM for performance tuning databases
  • Configured and managed the Oracle Golden Gate Environment including two servers (host and target)
  • Established the Oracle BI Publisher to connect to Oracle database server
  • Hosted applications with the AWS Cloud
  • Configured AWS account and management tools
  • Configured Command-Line tools on EC2
  • Configured and Launched EC2 Instances
  • Managed AWS Access with IAM
  • Created Database link and transfer dump file from EC2 Oracle database instance to Oracle database on RDS

Confidential, Fairfax, VA

Oracle Developer (PL/SQL)

Responsibilities:

  • Designed web sites (Installing and using Joomla tool and database My SQL on Linux)
  • Created and supported PL/SQL stored procedures, data modeling, dictionary, entity relationships
  • Maintained overall responsibility for global data definitions used in the Data Warehouse
  • Documented, maintained and supported data standards for the Data Warehouse, including security, archiving, backup and recovery
  • Assisted in the design, implementation, maintenance, and administration of databases with respect to performance, accessibility, availability, security, and configuration
  • Provided technical support for company’s database management systems and related applications
  • Experienced with Agile methodologies

Confidential

Oracle Developer (PL/SQL)

Responsibilities:

  • Created Oracle Forms and Oracle Reports
  • Responsible for Debugging and Resolving SQL/PLSQL code issues
  • Created new ETL and PL/SQL scripts to support the data warehouse

Oracle Application Server (Oracle Forms, and Oracle Reports)

Responsibilities:

  • Coded and wrote applications using Oracle PL/SQL, Oracle Forms, Oracle Reports
  • Designed and enhanced applications ranging from minor enhancements, bug fixes, through to forms personalization and design and develop new reports to serve the business needs

Confidential

Oracle Developer (PL/SQL)

Responsibilities:

  • Responsible for debugging and resolving SQL/PLSQL code issues
  • Development and design of an Oracle Data Warehouse written in Oracle PL/SQL
  • Enhanced existing Oracle DW application to integrate with new financial data sets
  • Coded PL/SQL, ETL, using packages, stored procedures and triggers

Hire Now