We provide IT Staff Augmentation Services!

Oracle Dba, 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

Oracle DBA, Oracle Developer

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

Confidential

Oracle DBA, Oracle Developer (PL/SQL)

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

Confidential

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

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

Hire Now