SUMMARY:

• I have 14 years of Experience as an Oracle DBA. I have worked on different Oracle version starting from 8i, to 9i, 10g, 11g and 12C. I have worked in different kind of project like 24x7 Production Support, Database Migration, in PROD, Test and Development environment. I have hands on Exadata servers, RAC, Golden Gate and Standby databases. I am Oracle 9i and 10g DBA Certified Professional, Oracle Exadata Certified Expert - X3 and X4 Administration. I am looking for Senior Oracle DBA role to apply my knowledge and experience to benefit the organization
• Setup and Configured more than 10 RAC clusters with ASM
• Setup and Configured more than 25 Standby databases with Maximum Availability Architecture
• Coordinated with Oracle to configure more than 4 Exadata clusters
• Migrated (upgraded when required) more than 200 databases using different methods like RMAN Duplicate, RMAN restore, Manual restore, Data Pump, Export-Import, CATS with DB links, Golden Gate
• Configured several Standby database with conventional and Active database mode with or without Data Guard broker
• Migrated more than 30 databases to Exadata platform and tuned them
• Configured ASM disk groups with different redundancy
• Led Database Consolidation project & Database Technologies standardization by standardizing software stack for database
• Configured Unidirectional/ Bidirectional Golden Gate on more than 5 databases
• Database Migration along with its bi directional Golden Gate Setup
• Monitoring and resolving Golden gate issues/ Restarting Golden Gate services
• Tuned and resolved several database performance issues with help of AWR, ADDM, Statspack
• Administered databases of various sizes from 5GB to 6TB
• Experience in UNIX shell scripting

TECHNICAL SKILLS:

Operating System: Sun Solaris 10, Red Hat Linux, HP UX, and Windows 2000

RDBMS: Oracle 12c/ 11g / 10g, Oracle (9.2.x, 8.1.x), MySQL, Exadata. Golden Gate

Middle-tier: Oracle9iAS, Ja99sper 3.1/ 3.5, Tomcat 6.1, Weblogic

Languages: SQL, PL/SQL, UNIX shell scripts

DatabaseTool: Oracle OEM, PL/SQL Developer, Quest TOAD, Golden Gate

InterfacingTools: SSH, Putty, X-window, Exceed, WinSCP, FileZilla

Utilities: STATSPACK, OEM, TOP, DATAPUMP, Imp/Exp, SQL*Loader, TRANSPORTABLE TABLESPACE, DBCA, TKProf, DBUA, SQL Trace, DBVerify, RMAN, SCP, Duplica, DBdiff, TFS, Netterm, SVN, JIRA, Sharepoint, BRTOOLS

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Senior (L3) Oracle & Exadata DBA

Responsibilities:

• Installed DB software on hundreds of servers using Automated DP in OEM
• Configured more than 20 databases as per business need
• Migrated more than 10 databases to Exadata platform
• Tuning databases on Exadata to get expected performance
• Storage cell administratin using CellCLI, DCLI commands
• Monitor Exadata alerts/ metrics and perform Exachk
• Coordinated with Oracle for Exadata patching
• Created 5 Standby databases along with Data guard Broker setup
• Converted many Standby databases to SNAPSHOT STANDBY temporarily as part of BCP exercise
• Closed Archive gap by applying incremental backup
• Tuned several databases as part of proactive or reactive work with help of AWR report
• Performed Automated and Manual Database patching for Oracle 11g and 12C using OEM or DMA tool
• OEM 11g and 12c administration - On-boarded targets like DBs, Serves, Listeners, Clusters, Troubleshooting DP executions, Pushed Gold Build using DP
• Restored 3 databases using RMAN from tape backup
• Wrote and implemented DB triggers to monitor DB logins
• Configured Bi directional Golden Gate replication for 5 databases
• Handled Golden Gate replication issue like ABEND processes, Structure mismatch between source and target tables
• Minimized migration downtime for one critical database using Golden Gate replication method. Also used Incremental backup-restore method to minimize downtime for 2 databases
• Configured LDAP alias of hundreds of servers
• Tuned several databases as part of proactive or reactive work
• Migrated 6 databases using RMAN DUPLICATE
• Health check and proactive maintenance for critical RMAN catalog, OEM databases
• Refreshed several schemas with using Data Pump as part of ongoing activity
• Decommissioned or Consolidated identified databases as part of Lifecycle project
• Carried out deployments and DBA tasks on databases requested by other teams as part of Change
• Followed ITIL processes like Ticket & Change Management, Problem and Known Error management, Knowledge management

Environment: Oracle 10G, 11g,12C, RAC, Dataguard, Golden Gate, Exadata, Oracle Enterprise Manager, Linux, Solaris 10, ASM, RMAN, WinSCP, SQL Developer, Remedy, SharePoint, Putty, SSH, AWR, ADDM, DATAPUMP, EXPORT/ IMPORT, Shell Scripts

Confidential, Minneapolis

Senior Oracle DBA cum lead, Exadata DMA

Responsibilities:

• Installed, Configured, Managed Oracle 12c on Linux
• Have good understanding of Exadata features like Smart Scan, Flash cache, Storage Index, HCC and IORM
• Used CellCLI and DCLI commands to manager Exadata systems and its metrics
• Planned and implemented consolidation on Exadata machines
• Managed Storage Cell servers. Created Grid disks and Diskgroups. Configured ASM scoped and DB scoped Security
• Tuned migrated databases on Exadata system using advanced Flash cache configuration, analyzing GC and other wait events, proper indexing strategy, smart scans and storage indexes
• Involved in Capacity planning for consolidation project to migrated DBs to cloud
• Planning for and Patching Exadata machines
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC
• Setup STANDBY database setup, troubleshooting, maintenance, switchover, switchback and Failover using OEM, Broker or command line
• Installed and on-boarded 2-3-4 node RAC cluster
• Configured Golden Gate on 2 databases
• Migrated Database along with its Golden Gate setup
• Tuned and resolved more than 20 database performance issues
• Monitoring daily Health check reports and resolving issues found for more than 2100 databases
• To lifecycle identify databases (migration, decommission, consolidate)
• To carry out deployments on databases requested by application and other teams
• Security management through user, role, grants and audit triggers
• Day to Day General Administration Tablespace Management, Undo Management, Managing Users, Resources, Managing User Privileges and Roles.
• To be in compliance with strong ITIL processes like Ticket & Change Management, Problem and Known Error management, Knowledge management
• Ensured SLA targets are met (Response and Resolution SLAs, CSI, Change success rate)
• Implemented Process improvement projects to save on cost, improve on productivity and customer satisfaction

Environment: Oracle 10G, 11g,12C, RAC, Dataguard, Golden Gate, Exadata, Linux, Solaris 10, OEM, SQL*LOADER, ASM, RMAN, Exceed, WinSCP, SQL Developer, Remedy, Netashtra, SharePoint, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, MViews, Shell Scripts

Confidential

Oracle DBA Lead

Responsibilities:

• Installed, Configured, Managed, and Patched Oracle 9i, 10g and 11g on Linux
• Supported MYSQL servers as additional responsibility
• Configured DB backups using BRTOOLS

Environment: Oracle 10G RAC Oracle 11.1.x/10.2.x/9.2.x,MySQL, Dataguard, Linux, SAP Basis, SQL*LOADER, RMAN, WinSCP, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, Shell Scripts

Confidential

Senior Oracle DBA

Responsibilities:

• Ensured RMAN and logical backups for all databases
• User and space management including capacity planning for existing and new databases
• Carried out various deployments and supported application development projects
• Maintained RAC multi-node environment
• Supported STANDBY database configuration and resolved related errors
• Ensured the process compliance like Ticket and Change management

Environment: Oracle 10G RAC Oracle 11.1.x/10.2.x/9.2.x, Linux, OEM, SQL*LOADER, RMAN, Exceed, WinSCP, Toad for DBA, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, MViews, Shell Scripts

Confidential, Minneapolis

Oracle Database Architect

Responsibilities:

• Basic Oracle database administration
• Planned and execute the backup strategy for Oracle databases
• Analyzed, developed and maintained data architectures, process models
• Worked with Application Team for database loading, development and management of operational procedures
• Data Normalization
• Created Physical Data Model from Logical Data Model
• Worked with app team to redesign data models along with Application flow
• Develops strategies for archival policy, recovery, and implementation of a database.
• Review architectural documents for potential conflict with all discipline
• Impact and capacity analysis for any change or enhancement
• Conduct meetings with all stake holders for design or architectural changes
• Analyzed different approaches enhancements
• Oracle 10g and 11g database basic administration on Linux platform
• Database design, Created physical database model from LDM
• Multiple schema design for Data planning and Security
• Optimized database performance by analyzing database objects, gathered statistics, created indexes
• Maintained Oracle security through users, roles and Oracle profiles
• Improved performance of batch jobs, many reports. Performance fixes typically reduced batch runtime by hours. Recommended and implemented partitioning adjustments, materialized views, summary tables, Oracle parallelism, indexing improvements, as well as improved SQL techniques. Coordinate developers on more efficient ways to write database queries. Tracked down the source of troublesome locking problems
• Identified and tuned SQLs in production databases
• OS Monitored of CPU Utilization & performance with tools like (TOP, VMSTAT, SAR, IOSTAT, MPSTAT etc)

Environment: Oracle 10G RAC Oracle 11.1.x/10.2.x/9.2.x, ErWin, PowerDesigner, Linux, Solaris 10, OEM, SQL*LOADER, RMAN, Exceed, WinSCP, Toad for DBA, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, MViews, Shell Scripts, SVN, Eclipse, JIRA

Confidential, Philadelphia

Sr. Oracle DBA/Architect

Responsibilities:

• Installed, Configured, Managed, and Patched Oracle 9i, 10g and 11g on Linux
• Develop database design ideas and created design presentation
• Worked with App team for database and application design
• Backup configuration and management with Oracle RMAN
• Worked on RMAN backup, Cold/hot backup and export/import
• Installed and configured Oracle Grid 10g control server and its agents on the server and all client machines
• Implemented and managed 2 Node Oracle 10g RAC database using ASM
• PARTITIONED non partitioned tables into PARTITIONED TABLES using range partition method
• Automated export and import for development database backup
• Identified and tuned SQLs in production databases. AWR reports were used during high workload
• SETUP LOGICAL BACKUPS of database using EXPORT/IMPORT and 10g DATAPUMP
• Automated database Schema refresh and Linux administration
• Installed and Configured of Tomcat and Jasper Server
• Port configuration, User configuration for Tomcat and Jasper
• Did production and non production deployments within defined timeframe and SLA’s
• Quality Documentation for all database administration and the code deployment activities

Environment: Oracle 10G RAC Oracle 11.1.x/10.2.x/9.2.x, Linux, Solaris 10, OEMSQL*LOADER, RMAN, Exceed, WinSCP, Toad for DBA, Putty, SSH, TKPROF, AWR, ADDM, STATSPACK, DATAPUMP, EXPORT/ IMPORT, MViews, Shell Scripts, SVN, Eclipse, JIRA

Confidential, New York Philadelphia

Oracle Consultant

Responsibilities:

• Defined and implemented technical processes for DB support
• Set up team at offshore and provided them detailed Knowledge transfer sessions
• Provided DB support and daily DBA activity like DB maintenance, user creation, addressing developers’ concerns
• Solved DB requests which are raised through Migration Request queue mechanism
• Implemented application enhancements and changes
• Tuned SQL statements and memory as required
• Coordinated with offshore DBA team to ramp-up the hand-over

Environment: Oracle 10G, Oracle 10.2.x/9.2.x, LinuxSQL*LOADER, RMAN, Exceed, WinSCP, Toad for DBA, Putty, DATAPUMP, EXPORT/IMPORT, Shell Scripts, SVN, Eclipse, JIRA

Confidential, New York

Oracle Architect

Responsibilities:

• Led Datacenter closure project from DBA team prespective
• Defined technical processes for each DB server installation, configuration, qualification
• Defined technical processes & database migration for different oracle versions and on different OS platforms
• Ensured application-database interfaces and outages are as per SLA for all applications
• Involved in PLANNING and database UPGRADATION from 9i to 10g (version 10.2.0.3) on Solaris/ Linux machines
• Oracle 9i/ 10g installed on more than 10 servers with exact naming convention and following all required prototypes and company standard
• Migrated more than 80 databases on same or cross-platform
• Used different migration strategies like Export-import, Cold backup- restore, Manual upgradation
• Successfully installed, maintained, 10g RAC on red Hat Linux in development env
• ASM instance setup, Creation of DISKGROUPS, adding CANDIDATE DISKS to the disk groups
• Migrated NON ASM database to ASM DATABASE
• Moved tablespaces from one DISKGROUP to another DISKGROUP as and when need arises
• Written SHELL SCRIPTS for MONITORING, REPORTING, ALERTING, PURGING, BACKING UP and scheduling the same through CRON
• Installed Enterprise Manager’s DATABASE CONSOLE with EMCA for newly created databases
• Installed DST patches on all production and non production
• Maintained large databases around (Data Warehouse DBA activities like Oracle Partitioning
• Resolved database problems faced by developers and QA team with tools and utilities like TKPROF, AWR report and STATSPACK
• Optimized database performance by analyzing database objects, gathering statistics, creating indexes
• Configured FAST/ COMPLETE MATERIALIZED VIEWS for table data refresh across databases as per business need
• Identified and tuned SQLs in production databases
• SETUP LOGICAL BACKUPS of database using EXPORT/IMPORT and 10g DATAPUMP
• Code/ SQLs script deployment for all environments including Production
• Quality Documentation for all DBA and deployment activities

Environment: Oracle8/8i, Oracle9i, Oracle10g, Sun Solaris. Red Hat Linux, Windows, Citrix, Toad, X-window, Exceed, Putty, Data Pump, Sharepoint, Oracle8/8i, Oracle9i, Oracle10g, Sun Solaris, Red Hat Linux, Windows

Confidential

Oracle DBA

Responsibilities:

• DATABASE TUNING for slow response time and performance with the help of AWR, TKPROF
• Wrote SHELL SCRIPTS for MONITORING, ALERTING, PURGING
• Managed HP Clusterware services to main 2 node cluster
• Moved Cluster packages from one node to other as and when needed
• Migrated Oracle 8i Production database to Oracle 9i In very short time as per urgent business need
• Configured and maintained backup using HP Omani backup tools (RMAN)
• Involved in changing DATABASE CHARACTERSET for in-house project as per business need
• Taking logical backup’s of database using EXPORT/IMPORT
• Monitored OS resource CPU Utilization and its performance with tools like (TOP, VMSTAT, SAR, IOSTAT, PRSTAT, MPSTAT etc) and essential UNIX administration
• Monitored indexes, Dropped unused indexes, Created required indexes after analyzing SQLs
• RMAN Backup & Recovery from Tape using Catalog DB (HP Omni backup tool)

Environment: Oracle DB 9.2.x, AIX, Oracle 9i AS, HP Clusterware, HP Omani backup