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

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship