SUMMARY

• 10 + years Information Technology experience.
• Configured, Installed, Patched, Oracle Database Appliance X4 - 2 Bare Metal and Virtualized Platform.
• Expertise in Oracle Enterprise Manager (OEM) 10g,11g and Enterprise Manager Cloud Control 12c.
• Expertise in installation, setup and configuration of Oracle 11g, 10g, on Oracle VM Manager, SUN SOLARIS, HP-UX, IBM-AIX, WINDOWS, LINUX, VMware ESXi 5.5.
• Installed Linux, Solaris Operating system as part of Unix Administrator. Installed Oracle 11g & 10g RAC software.
• Exposure to Oracle Exadata, configure Exadata monitoring plugin in OEM Cloud Control 12c .
• Configured and implemented Oracle GoldenGate 11g/12c.
• Maintain continuous co-ordination of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business results or strategic intent.
• Implemented RMAN backups (Full, Incremental and Cumulative) and RMAN recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Worked on large-scale databases with size more than 1 TB in large system environments
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and Perl Scripts.
• Good experience in applying security patches and migration of Oracle server from 10g to 11g, 9i to 10g.
• Worked as a Lead member to provide 24x7 on-call production database support.
• Logical and physical modeling using Erwin & DbVisualizer.
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Expertise in maintaining and reinforcing standards for change management, database security plan and auditing
• Worked on different types of storage structures (SAN/NAS)
• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)
• Excellent knowledge of Oracle Architecture, SGA, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views
• Experience in Load and Performance testing of the database servers and application servers, analysis and documentation of results
• Excellent communication and interpersonal skills

TECHNICAL SKILLS

OPERATING SYSTEMS: Oracle Database Appliance X4-2, Exadata, HP-UX 10.x, 11.x, Sun Solaris 9, 10, AIX 5.2,6.1 Red Hat Linux RHEL 4.x, 5.x and Windows 98/NT/2000/2003/XP

RDBMS: Oracle 11g/10g/9i/8i, Oracle 10g (RAC, Data Guard), SQL Server 2005, 2008

LANGUAGES: SQL, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, ERwin, TOAD, Data Pump (expdp, impdp), Autosys, Mainrame CA7, Query Analyzer, Crystal Report, ETL (Informatica 8.5), VERITAS NetBackup, Developer 2000, SQL*Plus, SQL*Loader, ETL, Infomatica. Pentaho, VMware ESXi 5.5

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

WEB TOOLS: HTML, XML

PROFESSIONAL EXPERIENCE

Confidential, Tampa Florida

Sr. Oracle DBA

Environment: Oracle Database Appliance X4-2, Oracle VM Manager, VMware ESXi 5.5, Sun Solaris, Oracle 11g, 10g, Oracle RAC (10g,11g), Oracle Enterprise Manager (OEM 10g, 11g, 12c), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL, Oracle Linux. Oracle Virtual, ETL Pentaho, COGNOS 8

Responsibilities:

• Responsible for co-ordination of six project, production support and software development lifecycle with building credibility rapport, and maintain communication with application with application users, developers and business analysis.
• Accountable for architect & development of new application and best suitable license opportunities.
• Handling oracle database for JD Edwards EnterpriseOne, Vertex Tax System, Ecommerce Webserver, dcLINK® data capture software, MServe, BigMachines data warehouse Projects.
• Responsible for administration and supporting Oracle 11g & 10g databases in DEV, QA, UAT and Prod environments.
• Configured and implemented Oracle GoldenGate 11g/12c. Configured GG plugin in OEM12c.
• Coordinates requirements, solutions, designs and execution with client and business users.
• Unix administration and Oracle DBA daily tasks.
• Designs & Architect Oracle Database Appliance X4-2 from unpacking Box to configure Bare Metal and Virtualized Platform.
• Migrated 10g database to 11g by Goldengate. Configured standby databases by OEM.
• Installation and Setting up of 11g RAC in Linux environment and 11g ASM on RAC databases.
• Administrative activities of project.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager 11g/12c.
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Created UNIX shell scripts to automate batch jobs through Cron and OEM Job scheduler.
• Developed and modified scripts to work efficiently for alerts for error backup and recovery, automatic startup and shutdown databases.
• Performing day-to-day database administration tasks like Data Guard, Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Confidential, Cleveland, OH

Project Leader

Environment: IBM-AIX, Sun Solaris, Oracle 11g, 10g, and 9i, Oracle RAC (11g), Oracle Enterprise Manager (OEM), RMAN, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL

Responsibilities:

• Handling PXP (Politically Exposed Persons), RTS (Real Time Scanning), BIT (Broker Insurance Tracking) PST (Personal Security Transactions), OCL/OFAC (Compliance Link) Projects.
• Responsible for administration and supporting Oracle 11g, 10g databases in DEV, QA, UAT and Prod environments.
• Supervises 10 members in the production, QA and development support teams.
• Coordinates requirements, solutions, designs and execution with client and business users.
• Unix administration and Oracle DBA daily tasks.
• Designs & develops databases and Informatica workflow per client requirements.
• Installation and Setting up of 11g RAC in AIX environment and 11g ASM on RAC databases.
• Re-architecture and re-platforming National City Bank’s Legacy framework and application for Confidential Bank environment
• Build up the TEST and QA environments for above applications as part of re-platforming
• Administrative activities of project.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Worked on Automatic Storage Management (ASM) for managing data in SAN
• Monitoring and resolving tickets in different environments.
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Works on automation of manual tasks by using Shell and Perl Unix script.
• Created UNIX shell scripts to automate batch jobs through Cron
• Developed and modified scripts to work efficiently for alerts for error backup and recovery, automatic startup and shutdown databases
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc

Confidential, New Jersey, NJ

Oracle DBA (Team Lead)

Environment: HP-UX, Windows 2000/2003, and Linux, Sybase, Sql Server 2008, Oracle 9i, 10g, Oracle RAC (10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, Autosys, Clearcase, SQL*Plus, Post Gre SQL, SQL*Loader

Responsibilities:

• Supported Oracle 10g and 9i and Sybase databases as part of 24 X 7 production support.
• Installed and created 1og databases as part of migration.
• Performed upgrades from Oracle 10g (10.2.0.3) on RHEL 4.
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 9i and Sybase over to Linux boxes running Oracle 10g.
• Created new application and target Oracle 10g database environment for QA and UAT testing.
• Installed Perl 5.8.8 and built the application related modules per client requirement
• Shell and Perl scripting and enhancement for automation as per client requirement as part of migration and conversion of Perl and Shell scripts as per new target database and test the results
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations. Migrated database from 9i to 10g supporting various incremental releases
• Query optimization for reporting and ETL
• Created & Managed Jobs using AutoSys Job Scheduler
• Extensive Unix Administration, UNIX Shell scripting in ksh,
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes.
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle
• Taking Hot and Cold Backups, Exports etc
• Data Modeling, Database Design and Creation using Erwin

Confidential, New York

Oracle DBA

Environment: HP-UX, AIX, and Linux, Oracle 10g and 9i, Oracle RAC, TOAD, Enterprise Manager, EXPLAIN PLAN, TKPROF, SQL Trace, Query Analyzer

Responsibilities:

• Provided Primary architectural and administrative support for new projects
• Installed Oracle 9i and 10g RAC database on HP-UX 11.0, Redhat 4
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Shell and Perl scripting and enhancement for automation as per client requirement Like. Disk space alerts, Backup and Archive directories and files, Getting alerts from Oracle, DB2 and Sybase database.
• Performance Tuning i.e., Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same
• Generated Reports using crystal reports
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, database design, database tables, indexes, instance, memory, operating system and java calls
• Worked as a member of production DBA team in perfect coordination with seniors and team members

Confidential, New Port Beach

Oracle DBA & UNIX Administrator.

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, ERwin, STATSPACK

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 10g, 9i on Sun Solaris and Redhat4.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc
• Implementing Database Security, Management of role-based security
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
• Write and modify UNIX shell scripts to manage Oracle environment
• Logical and Physical data modeling using ERwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling
• Used SQL Loader as part of ETL process to populate the operational data store
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Monitored 16 servers 12 Unix flavor 4 windows through BIG BROTHER TOOL
• Took appropriate action on alerts, Dispatch System on Lotus Notes tickets
• Monitored UNIX File System Growth. Automated Job Schedule using Shell Scripting CronTab.

Confidential

Oracle Developer DBA, IT Department

Environment: Oracle 8i/9i, Windows NT/2000, HP-UX, PL/SQL, SQL Server 2000, TOAD, Database Tools/Utilities, Shell Scripting

Responsibilities:

• Installed Linux and oracle software & Created Database.
• Partitioned large tables to increase the performance
• Configured scripts to monitor activity with database
• Responsible for optimizing the queries and application tuning
• Designed backup and recovery procedures for OLTP system
• Designed database tables as per technical specifications
• Used TOAD tool to access the databases