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.

• 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