Summary

• Certified Oracle database administrator with significant experience in Oracle database administration. Designing, developing and implementing database systems using Oracle 7, 8i, 9i, 10g and 11g R2. and Microsoft SQL-Server.
• Extensive experience in configuring the data
• Extensive experience as Oracle DBA, performing configuration, installations, upgrades, backup and recovery, patching, trouble shooting and performance tuning in multi-database environments.
• Production and development DBA. Creating and maintaining RAC, Data Guard and MS-SQL Databases.
• Manage user access and use Oracle security mechanism to secure data and ensure data integrity.
• Monitor and tune databases using Statspack, AWR and Oracle Enterprise Manager 10g.
• Create, test and implement backup and recovery plans. Scheduling daily, weekly and monthly Hot/Cold Backup solution utilizing RMAN via a recovery catalog incorporating incremental backups, intraday archive log backups using Veritas Netbackup 4.5.
• Four years experience in the installation, configuration and maintenance of Oracle Enterprise Manager OEM 9i, 10g and 11g grid control. Configuring and scheduling OEM jobs and proactively monitoring Oracle databases, detecting and resolving bottlenecks and tuning poor performing SQL statements.
• Lead DBA for OEM 10g implementation team.
• Lead DBA for 9i Data Warehouse, creating partitioned tables, materialized views, indexing, timely analyze of partitions and tables.
• Patching and upgrading database and tuning long running SQL statements using Stats pack, TKPROF and OEM 10g.

Technical Skills

HP-UX, HP Tru64, Sun Solaris, DELL Power Edge server 2300, Windows Server 2003/8, Windows Advanced Server, Red-hat Linux, DBArtisan, TOAD, Oracle Developer, Oracle Application Express APEX , Oracle BI Publisher, Build and repair PCs. Install and configure peripheral and internal devices. Install and configure operating systems including Windows and Linux

Professional Experience

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Create and maintain Oracle 10g and 11g database including RAC and Data Guard database.
• Interview business users requesting new applications to assess system need.
• Evaluate applications software for businesses
• Interface with external vendors to acquire licenses and purchase needed components.
• Create and maintain Microsoft SQL-Server 2008 Database.
• Determine storage requirement, monitor file system space usage, ensure efficient use of storage. Re-organize tablespaces to reclaim storage
• Provide end-user support and co-ordinate implementation of application with database team and application team.
• Gather, analyze data and build data model/schema using SQL Developer/Data Modeler.
• Create application using Oracle Application Express APEX with SQL and PL/SQL code
• Maintain, troubleshoot, backup and tune Oracle databases.
• Install and configure new peripheral and internal devices to work with client computers
• Install and configure new applications in 2-tier environment
• Create virtual servers/machine using VMware.
• Backup and migrate user data from old to new computers
• Tune computers to improve performance

Confidential

Oracle Database Administrator

Responsibilities:

• Work as primary 24/7 production DBA and development DBA with team of DBAs having individual tasks to accomplish. I also worked on projects as the sole DBA without supervision.
• On-call DBA responding to incidents, troubleshooting and resolving database problems and coordinating resolution effort with system engineers, network team and system monitoring team
• Create production, disaster recovery and development databases on HP-UX and Linux clusters using RAW device and file system.
• Monitor and tune databases using Statspack, AWR and OEM 10g Grid Control.
• Create, test and implement backup and recovery plans. Scheduling daily, weekly and monthly Hot/Cold Backup solution utilizing RMAN via a recovery catalog incorporating incremental backups, intraday archive log backups using Veritas Netbackup 4.5.
• Create storage requirement document requesting storage for database creation and backup on both Linux and HP-UX cluster servers.
• Maintain 3 node RAC database on Red-hot Linux cluster.
• Extract data definition language DDL from physical data model using ERWIN data modeler and create objects in development and production databases.
• Implement changes in development environment promote changes to disaster recovery and production databases, synchronizing production and disaster recovery databases.
• Design and code SQL/PLSQL shell scripts to analyze schemas, export schemas/database and modify database/objects, SQL Loader data loads and file system monitoring.
• Automate shell scripts using CRON to analyze schemas, export schemas/database and modify database/objects, SQL Loader data loads and file system monitoring.
• Automate shell scripts using init.d to shutdown and restart multiple databases during server reboot or after a server panic.
• Database/schema refreshes to disaster recovery database from production databases.
• Upgrading multiple databases from 8i and 9i to 10g.
• Performing database backup audit.
• Installing and configuring oracle executables and SQLnet for internally developed and vendor off the shelf applications.
• Take client request for service RFS , create statement of service SOS document, prepare requirements document and co-ordinate the efforts of DNS, system engineers, storage and database teams with application vendor or client application team to implement client request.
• Work with developers in diagnosing and resolving database related application problems
• Tune SQL statements running in the database at scheduled maintenance intervals.
• Proactively monitor database and SQL performance using Oracle enterprise Manager and schedule and co-ordinate maintenance downtime for production databases to tune database parameters and SQL statements for improved database performance.

Confidential

Oracle Database Administrator

The primary function of the database administrator at Cable Wireless Jamaica Limited was to install, configure, optimize, maintain and backup production databases in a multi-database environment across the Caribbean region.

Responsibilities:

• Install and configure Oracle RDBMS software and supporting software. Upgrade and/or apply patches to RDBMS and supporting software. Oracle 8i, 9i and 10g production and development environments.
• Create, maintain, tune and backup development, test and production databases. Currently 8i, 9i production databases and 8i, 9i and 10g test and development databases.
• Configure security for database listener, setup access control for database users using roles and synonyms, while auditing table data modification.
• Routine job like helping users to resolve PeopleSoft issues, maintaining extents of indexes, tables and tablespaces, taking backup and exports of the tables and restoring and importing it, creating batch scripts for automation of the processes, as a single point of control moving sqr's, projects, fixes, updates and new functions into test, QA and production systems.
• Created database tuning scripts which were scheduled by Oracle Enterprise Manager or CRON to run automatically. Which enhanced the performance of the production and development databases.
• Create Unix shell scripts and Windows script for backup and recovery of databases.
• Install and configure Veritas Netbackup client software on database servers to interface with Oracle's RMAN and write backup to tape.
• Created scripts to automate startup and shutdown of databases, process schedulers and application servers.
• Install and configure Oracle Enterprise Manager 8i, 9i and 10g and install agents on database servers. Use OEM to configure performance maintenance jobs and monitor database and server performance, resolve bottlenecks and tune SQL statements.
• Clone Oracle 8, 8i, 9i databases using import/export, datafile copy, backup and restore and Oracle Enterprise Manager 10g.
• Perform proactive maintenance, performance analysis, capacity planning, trouble shooting and problem resolution
• Create SQL and PL/SQL scripts
• Provide after hours support and respond to pages and alerts for 24/7 production database operations.
• Work with developers in diagnosing and resolving database related application problems
• Work with Warehouse Administrator to do optimizations for data warehousing, indexing, materialized views and partitioning.