We provide IT Staff Augmentation Services!

Oracle Developer Resume

SUMMARY

Senior Database Administrator with over 8 years of experience, Oracle DBA, Database Developer, Programming with PL/SQL in Oracle, Designing Database, MS SQL Server Developer, Data warehouse, Data modeling.

TECHNICAL SKILLS
  • Languages Joomla 5, Html 4, JavaScript 4, VB 5, VB.NET 4, DOT.NET 3:
  • RDBMS Oracle 5, SQL Server 5, MySQL 5 , MS - Access 5 , PostgreSQL 4 , DB2 4:
  • App Servers Oracle IAS 4 , Oracle Form 4 , Oracle Report 4 , Oracle People Soft 3 , Oracle Business Intelligence system 4 , MS-Internet Information Services (IIS) 4 , Win SCP 5:
  • Tools MS office 5 , CVS 4 , MS Visual source safe 4 , Crystal report 5 , Power designer 5 , ETL Tool 4 , Swis tool to convert databases 5 , Aqua data studio tool for databases 5 , TOAD tool for databases (Oracle, SQL Server) 5 , EMS tool for databases (Oracle SQL Server) 5 , Bugzila 4:
  • Environment Windows 5 , MS-DOS 5 , Linux/UNIX 3:
  • IDEs Borland JBuilder 3 , AdobeFlex Builder 3:

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

Oracle DBA, Oracle Developer (PL/SQL), MY SQL DBA Designing web sites (Using Joomla tool and database My SQL)

Oracle Database Administration Responsibilities:

  • Creating an Oracle instance and managing users, roles and Oracle tablespaces
  • Unloading and loading data using Oracle SQL statements and the SQL LOADER utility and external tables
  • Extract, transform, and load (ETL) processing
  • Classical data Export utility and Import utility, new data pump export and import utilities
  • Setting up of an audit trail and basic tuning are also covered
  • Database Backup and recovery using RMAN and logical backups
  • Database cold and hot backup recovery strategy
  • Creating data modeling with Power Designer tool and MS Visio

Oracle Developer (PL/SQL) Responsibilities:

  • Creating store procedures, functions, and triggers
  • Creating object types, packages, and package body
  • Responsible for Debugging and Resolving SQL/PLSQL code issues
  • Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
  • Maintain overall responsibility for global data definitions used in the Data Warehouse
  • Integrate data from multiple source systems into Data Warehouse
  • Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery

MySQL Responsibilities:

  • Designing and modifying database schemas
  • Querying, updating, and tuning databases
  • Design, creation, and enhancement of stored procedures, triggers
  • Backup, restore database
  • Import, export dump file
  • Develop, maintain, enhance, and execute database extraction, database loading, and data purging activities

Confidential, Branch in Vietnam

Oracle DBA, Oracle Developer (PL/SQL)

Oracle DBA Responsibilities:

  • Install, Configure, and maintain Oracle Databases on Window server platform
  • Manage the database Oracle ASM file system on Window server platform
  • Tune Database parameters for optimal system performance
  • Create and maintain Oracle Databases with optimal file layout for data file, rollback, and redo objects
  • Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle environment using Oracle Diagnostic and Tuning packs
  • Unloading and loading data using Oracle SQL statements and the SQL LOADER utility and external tables
  • Database Backup and recovery using RMAN and logical backups
  • Provide backup, restore functions, and migration for Oracle databases
  • Participate in rotational on-call schedule
  • Integrate data from multiple source systems into Data Warehouse
  • Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery
  • Creating data modeling with Power Designer tool and MS Visio

Oracle Developer (PL/SQL), Oracle Forms, and Oracle Reports Responsibilities:

  • Creating store procedures, functions, and triggers
  • Creating object types, packages, and package body
  • Creating Oracle Forms and Oracle Reports
  • Assist in the design, implementation, maintenance, and administration of databases with respect to performance, accessibility, availability, security, and configuration
  • Perform basic database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
  • Establish, instruct, and manage policies and procedures related to database maintenance and administration
  • Work closely with design teams, technical infrastructure teams, and testing teams
  • Provide solutions to a variety of information system technical requirements of moderate scope and complexity
  • Provide technical support for company’s database management systems and related applications
  • Follow standard policies, procedures, and best practices in maintaining and supporting the databases
  • Support all database environments including development, test, and production. Interface with test teams to support test strategies and plans
  • Extract, transform, and load (ETL) processing

Confidential Company,

Oracle DBA, Oracle Developer (PL/SQL), SQL Server DBA and Developer

Oracle DBA Responsibilities:

  • Install, Configure, and maintain Oracle Databases on Window server platform
  • Tune Database parameters for optimal system performance
  • Extract, transform, and load (ETL) processing
  • Create and maintain Oracle Databases with optimal file layout for data file, rollback, and redo objects
  • Unloading and loading data using Oracle SQL statements and the SQL LOADER utility and external tables
  • Provide continuous monitoring, troubleshooting, historical and real time performance monitoring of the Oracle environment using Oracle Diagnostic and Tuning packs
  • Database Backup and recovery using RMAN and logical backups
  • Provide backup, restore functions, and migration for Oracle databases
  • Pro-active and reactive monitoring, troubleshooting and resolution of issues
  • Working closely with software engineers to ensure delivery of database services within the performance targets set
  • Participate in rotational on-call schedule
  • Responsible for improvement and maintenance of the databases to include rollout and upgrades
  • Responsible for implementation and release of database changes as submitted by the development team
  • Maintain overall responsibility for global data definitions used in the Data Warehouse
  • Integrate data from multiple source systems into Data Warehouse
  • Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery
  • Creating data modeling with Power Designer tool and MS Visio

Oracle Developer (PL/SQL) Responsibilities:

  • Creating store procedures, functions, and triggers
  • Creating object types, packages, and package body
  • Responsible for Debugging and Resolving SQL/PLSQL code issues
  • Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships

SQL Server Developer Responsibilities:

  • Creating store procedures, functions, and triggers
  • Responsible for Debugging and Resolving SQL/PLSQL code issues
  • Backup & Restore database

Hire Now