OBJECTIVE:

• My noledge, experience and expertise ca halp you gain the efficiencies and cost savings that organizations are demanding from their IT departments (expenditures and budgets).

SUMMARY

• Around 8 years of professional experience in Oracle Database administration.
• Expert in Migrating 12c/11g/10gOracle Databases to cloud.(e.g. Amazon web services)
• Oracle Certified DBA with experience in installation, configuration, tuning and troubleshooting.
• Expert in areas of Oracle 12c/11g/10g/9i/, PL/SQL, SQL, SQL*Plus, SQL*Loader.
• Expert in Installation of Oracle Database server and clients.
• Expert in Installation and configuration of OEM Grid Control and the Agents.
• Expert in Building RAC, RMAN, and Standby databases.
• Expert in Golden Gate setup and administration.
• Experienced inUNIX, LINUX, Sun Solaris, HP - Unix, AIX, and Windows10/8.1/8/7/XP/2000/NT.
• Expert in SOX, PCI and HIPAA Regulations implementations and compliance.
• Expert in troubleshooting and Performance Tuning of Oracle databases.
• Experience in Configuring, managing and troubleshooting data replication using Oracle Streams.
• Expert at creating and modifying Database objects (e.g. Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages).
• Supported 24/7 Production databases and responsible for round-the-clock database operations.
• Experience in database security strategies by creating database users, user roles, profiles and audits
• Experienced in Planning, Installation, Physical and Logical Database Design, refreshingtest and development databases.
• Experienced Production, Test, and Development DBA.
• Excellent Communication and Interpersonal skills.
• Ability to lead or serve as a major contributor of a team effort.
• Industry concentrations in the following: Application Hosting, Healthcare, Pharmaceutical, Retail and CRM industries.
• Experienced in C, C++, Java, Perl, Shell Scripting, XML, HTML.

TECHNICAL SKILLS

Database: Oracle 12c/11g/10g/9i, SQL Server, MS Access, IBM DB2, MYSQL.

Languages: PL/SQL, SQL, SQL*PLUS, C, C++, Java, Perl, Shell Scripting, HTML

Operating System: UNIX, LINUX, Solaris, HP-Unix, AIX, Linux, Windows

Tools: TOAD, PUTTY, OEM Grid Control, MS Office, Erwin

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Florida

Sr. Oracle Database Administrator

Responsibilities:

• Migrated and updated the databases from existing Oracle 10g to Oracle 12c.
• Installed, implemented and support Active- Active Golden Gate (11.2.1.0.5 ) across two, 2 node RAC servers (11gR2) on EXADATAlocated at two different corners of the country.
• Administered and managed oracle databases on Exadata machines.
• Generated SQL and PL/SQL scripts to run datapump export and import.
• Installed and implemented Oracle 11g/12c Oracle databases.
• Performed I/O tuning, Performance Tuning and benchmarking.
• Worked intensively with Oracle support in identifying and patching the 11gR1 bugs.
• Installed and configured multi node Oracle 11gR1 RAC environment using ASM on Sun Solaris and AIX5L as part of POC.
• Handled multiple 2 node RAC clusters on AIX 6.1 servers.
• Performed instance tuning with AWR/ADDM reports
• Supported and managed Oracle 10g/11g Real Application Clusters (RAC) environment on Red Hat Linux.
• Launched RDS 11g/12c instance and worked on its connectivity in AWS.
• Maintained backups for recovery using RMAN on to tapes and disks.
• Planned and migrated database servers to the new data center.
• Planned and designed 11g/12c instance in AWS environment as a strategic initiative.
• Migrated and updatedOracle 10g on premise databases toAmazon Relational Database Service (Amazon RDS) 11g/12c Oracle Instance.
• Created service accounts, application APPSA schemas in VPCx RDS 11g/12cOracle instance through console.
• Configured Statspack option in RDS instance and performed performance tuning.
• Implemented OEM Grid 11g/12c for performance tunings, monitoring and notification.
• Created and useDB links between Oracle instancesand RDS Oracle instances
• Enabled backups, event notification service (Amazon SNS) to provide notification when an Amazon RDS event occurs in AWS.
• ProvisionedMulti-AZ DB Instance for disaster recoveryin Amazon RDS which creates a primary DB Instance and synchronously replicates the data to a standby instance.
• Created DB parameter group to manage DB engine configuration and security groups tocontrol the access that traffic has in and out of a DB instance in Amazon RDS.
• Configured option groups (OEM, Statspack, TDE, Oracle Time Zone change, Oracle XML DB support, Oracle APEX) for RDS Oracle instances for using additional components of Oracle.

Environment: Oracle 12c/11g/10g, RMAN, Putty, Shell Scripting, Toad, EXADATA, PL/SQL Developer Windows, UNIX, LINUX, Sun Solaris.

Confidential, Charlotte, NC

Professional Services DBA

Responsibilities:

• Active support to database (10gR2). Support includes performance tuning, database backup and recovery (RMAN, export/import), UAT and Dev. database refreshes, application development support (SQL and PL-SQL), testing Data Guard setup periodically and database maintenance tasks.
• Partitioned huge tables to improve the performance. (Mostly Range partitions on dates).
• Used and maintained Materlized views and DB Links.
• Upgrade the databases from existing 10gR2 DB to 11gR2.
• Support Active-Passive and Active-Active Golden Gate across two, 4 node RAC servers (11gR2) for another major retailer company.
• Developed Shell scripts and cron jobs to perform various jobs as requested by the client.
• Installed OSWATCHER to monitor Oracle RAC 11gR2.
• Installed and configured Oracle 11gR2 RAC using ASM on 2 node RHEL servers and Solaris servers.
• Designed and implemented a high availability system to support multiple daily and weekly data refreshes with no outages.
• Implemented Data Guard and involved in periodical testing of the data guard .
• Experience with installing and configuring Database Vault with oracle database 11g.
• Involved in load tests for various clients and provided reports and suggestions for improving the performance of the database using AWR/ADDM reports, SQLTRACE, TKPROF and EXPLAIN PLAN.
• Load Tests were monitored using OEM Grid Control and Toad.
• Developed Perl script to load the data outputted from Jmeter for performance testing into MySQL DB for a major banking company. Also, analyze the data loaded and developed SQL scripts to provide the required data analysis.
• Database Migration (DB2 to Oracle 11gR2) for project.
• Involved in collecting requirements, develop object model and data model.
• Performance monitoring for a load test for aSQL Server DB.
• Supported Production Database as and when required.

Environment: Oracle 11g/10g, DB2, SQL, PL/SQL, SQL*Loader, RMAN, RAC, DATAPUMP, OEM Grid Control, SQL Plus, TOAD, Linux, AIX, Solaris.

Confidential, Lakeland, Florida

Sr. Database System Engineer

Responsibilities:

• Installation, configuration and upgrading of Oracle 11g/10g Database Server
• Upgrade the database’s from existing Oracle 10g to Oracle11g
• Responsible for applying Oracle Patches and CPU patches.
• Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
• Installed and configured Oracle 11g RAC using ASM on 2 node AIX server. Supported and managed Oracle 10g Real Application Clusters (RAC) environment.
• Planning and designing databases including designing local structures and forecasting further expansions.
• Maintained backups for recovery using RMAN on to tapes and disks. Built and configured RMAN Catalog server.
• Schema Refreshes using export/import and oracle Data pump Export (DPE) and Data Pump Import (DPI).
• Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, EXPLAINPLAN, SQLTRACE, and TKPROF.
• Run performance monitoring scripts to check the status of the database.
• Replicated few tables of a Schema using Oracle Streams with two oracle databases in 10g.
• Supported Production databases on 24/7 on call rotation.
• Monitoring and Following up SR/TAR’s raised with Oracle.
• Controlling and monitoring user access to the database.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Implemented Security administration by creating of roles, views and granting the necessary object/system privileges to users.
• Aided developers in writing efficient code and making efficient use of resource leading to better performance and optimization.
• Interacted with the users and troubleshooting the problems involved with the development of stored procedures, triggers and problems related to the privileges & resources.
• Analyze schemas on all the databases on a regular basis.
• Support for the development, pre-production and the production databases.

Environment: Oracle 10g/9i, RMAN, Putty, Shell Scripting, Toad, PL/SQL Developer WindowsUNIX, LINUX, Sun Solaris.

Confidential, Plantation, FL

Oracle DBA

Responsibilities:

• Migration of all Oracle 9i databases/clients to 10g in a heterogenic environment on HP-UNIX.
• Applying Quarterly patches and Version change patch bundles for the current 10gR1.
• Implemented backup and recovery procedures using RMAN & Import/Export in 10g.
• Planned and Implemented Business Continuity Planning (BCP, Disaster recovery) sites for 10g.
• Installed and configured Oracle 10g RAC using ASM on 2 node Sun Solaris server.
• Installed, Configured and administrated OEM Grid Control to monitor all the databases at a centralized location.
• Intensively used 10g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Intensively used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Modified the existing scripts to monitor the new 10g instances.
• Monitoring activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.
• Implemented backup and recovery procedures using RMAN & Import/Export in 10g.
• Migrating schemas from development to test and test to production databases.
• In charge of the entire day-to-day database administrative activities for the Oracle 10g Production, Stage, Firefight, Development and Test databases.

Environment: Oracle 10g/9i, RMAN, Putty, Shell Scripting, Toad, PL/SQL Developer WindowsUNIX, LINUX Sun Solaris.