SUMMARY:

• An Oracle DBA with over 10 years of experience in Oracle (8i, 9i, 10g, 11g, 12c).
• Comfortable with installation, upgrade, backup, recovery, migration, performance tuning, Dataguard and RAC configurations.
• Worked in a variety of UNIX and Windows environments (Solaris, HP - UX, AIX, OEL & Windows Server 2003/2008). Support Production, Test and Development databases.
• Solid hands on 10+ years of experience with the database from designing, developing, implementing and pplnetworking, monitoring & managing of users, performance tuning of applications and the databases Oracle 11g/10g/9i/8x as well; using SQL, PL/SQL, SQL*Plus, ORACLE RAC (Real Application Cluster), Standby (Data Guard) Database, Exadata, Golden Gate, Oracle Utilities, Oracle Enterprise Manager & Oracle Management Server on Unix (Linux, AIX, SUN and HP) & Windows platforms.
• Experience in supporting and administrating large 24x7 production databases in Oracle 10g and 11g r2 RAC, ASM, GoldenGate and Data Guard environments.
• Expertise in installing, building, configuring, managing, upgrading and patching and trouble-shooting oracle databases in different operation systems environment like AIX, Linux, Sun Solaris, and Windows. Good hands-on knowledge in 10g/11g Real Application Cluster (RAC) with ASM & OCFS2 file systems.
• Experience with SRVCTL, CRSCTL, Oracle Enterprise Manager (OEM) 11g/12c, Grid Control, DBCA, VIPCA, OIFCFG, OCRCONFIG, ASMCMD and SQL* Plus for administration of Services, ASM instances and RAC databases.
• Experienced in GoldenGate 11g installation, configuration of Extract, Pump and Replicate. Managing GoldenGate process, Trouble Shooting and Upgrade of software.
• Installation of Audit Vault Server, configuring agents and collectors for the databases.
• Experience is adding/deleting a Node from an existing RAC Cluster and Load Balancing.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Complete range of Oracle DBA activities including day-to-day production database maintenance and monitoring, Backup & Recovery using RMAN, troubleshooting production issues, performance tuning, export-import, client installation, high availability (HA), disaster, and recovery, management of physical storage of database in Solaris, AIX and Linux platform.
• Experience in creating non-production instances using Export / Import utilities / Data pump Schema and User management.
• Coordinating several tuning efforts using ASH, AWR, Statspack reports, SQL tuning, OSwatcher with Dev and Test team’s that ensued in significant enhancements of response times for both application and data migration modules.
• Experience in backup and recovery, using RMAN, export/import and data pump.
• Migration of databases between Software versions, Platforms and database products.
• Expertise in writing UNIX shell scripts and SQL scripts for database monitoring and administration.
• Installation of MS-SQL instances & databases, Backup & Restore of databases
• Installation, configuration, replication, sharding of MongodB.
• Hands on Knowledge in Mongo DB and Casandra NoSQL DB.
• Knowledge in implementing multi-data center and multi-rack Cassandra cluster.
• Knowledge in configuration of master slave replication servers in Mongo DB and shared MongoDB clusters
• Installation, Configuration & Administration of Hadoop cluster, Name node, Secondary Name node, Job Tracker & Task Trackers.
• Monitoring Hadoop cluster health & Job status using Hadoop Web Interfaces.
• Involved in production DBA support in solving the database problems and co-ordination with Confidential .
• Extensively worked as Team Leader in performing task such as Strategic Planning, Installations, and Configurations.
• Excellent interpersonal, analytical, and problem-solving skills.

TECHNICAL SKILLS:

Databases: Oracle 8i,9i,10g,11g/12c, Ms SQL server 2000-200 5, NoSQL Databases, Cassandra, MongoDB

Database Tools: Oracle Enterprise Manager, SQL*Plus, SQL Loader, DBCA, Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBUA, ADDM, Oracle Migration Workbench, Remedy, Service NOW(SNOW),Open Text Exceed (Humming bird)Operating Systems: Windows Server 2003, 2005 & 2008, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, OEL

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2, Netapp, Fusion IO.

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Sr Oracle Database Administrator

Responsibilities:

• Upgrade of clustered database from 11g to 12c.
• Conversion of filesystem storage from NFS to ASM.
• Working with oracle support to resolve issues with database
• Building database with active dataguard setup to support high availability
• Manage databases in a clustered/RAC setup
• Resolving datablock corrupt issues in active dataguard database by copying corrupted datafile from production to DR using RMAN
• Working collaboratively with end-users to resolve data load issues with violation of unique constraints, primary key constraints
• Drop and rebuilding indexes, gathering statistics on tables and table partitions to optimize query execution
• Impdp/expdp command logical transport of data from one environment to the other
• Scheduling online RMAN full, incremental and archival backup in cron and monitoring backup jobs for any failures.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Performing risk assessment for quarterly patches releases by oracle and decide which patch has to be applied in the environment.
• Proactively apply patches when necessary as recommended by oracle.
• Enable flashback for database during major deployments to be able to restore database to restore points in the of a failure
• Recommend end users to use bind variables as against literals to benefit from the performance gain in soft parsing rather than hard parsing which requires a lot of CPU resources
• Working on ASM, adding & dropping of diskgroups.
• Installation, Configuration & Administration of Nosql databases (Mongodb & Cassandra)
• Configuration of Cassandra Clusters and creation of Key spaces.
• Maintenance of Cassandra Clusters, adding/deleting the nodes.
• Scheduling Compaction on Cassandra nodes.
• Installation, Configuration & Administration of Hadoop cluster, Name node, Secondary Name node, Job Tracker & Task Trackers.
• Lead of team 25 members Offshore with 24/7 Operations support.

Environment: RMAN, ASM, OEM, Oracle 11G & 12C, Golden Gate, Putty, OEL, MS-Sql 2005,2008.

Confidential - Midland, Michigan

Oracle Database Administrator

Responsibilities:

• Database point-in-time refreshes to support enhancements in lower environments before implementation in production landscapes
• Creating database users and assigning roles and privileges
• Use of OEM 12c to proactively monitor and resolves issues in all oracle databases
• Work with third party vendors to securely transfer data for resolution of performance issues with the application
• Proactively managing database storages structures and working with Unix and storage teams when necessary to allocate storage
• Ensure Production Databases are up & running 24X7.
• Database up gradations and migration to new platforms & new versions.
• Configuration & maintenance of Grid Control for monitoring databases.
• Attend severity level 1 request from users.
• Export & Import of tables.
• Monitoring Table Spaces & other alerts of database using Grid Control.
• Installation of Grid agent, Audit Vault server and agent.
• Creation & maintenance of Data guard.
• Backup, restore & recovery of databases using both user Managed & RMAN.
• Cloning of databases from Production To UAT servers
• Applying CPU patches released by oracle.
• Installation MS-SQL server instances & databases.
• Backup & Restore of MS-SQL server databases.
• Applying patches & Service pack to MS-SQL instances.
• Implementation of RAC, Installing Cluster software
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Conversion of standalone databases to RAC using rconfig utility.
• Written shell script for creation of databases as per the client standards.

Environment: RMAN, ASM, Oracle 10g & 11g, TOAD, Putty, TSM, OEM, Oracle Audit Vault, Nagios, OEL

Confidential

Oracle Database Administrator

Responsibilities:

• Performing schema and full database refresh using Export/Import data pump utilities and RMAN Duplicate command
• Performed Installation and configuration of Oracle databases on HP-UX platform
• Oracle CPU quarterly patch application to databases
• Create oracle databases on preconfigured servers with established standards to maintain uniformity in the environments
• Create database users and assigning roles and privileges and profiles
• Reestablishing access to databases by unlocking and resetting passwords for users account.
• Migration of databases between servers to meet up with laid down standards
• Recompiling packages, materialized views, views as needed when they fail to pull data from remote databases
• Creating and testing of database links to access data across databases and across platforms
• Monitoring scheduled jobs
• Monitoring databases and tuning for better performance by tracing blocking sessions, inactive sessions, resource intensive sessions with high CPU utilization and offer advice with regards to killing aging and blocking sessions
• Reclaiming disk space by resizing datafiles to their High Water Mark (HWM)
• Database split for better performance by exporting and importing main schemas into different separate databases
• Configuring databases for optimum backup and recovery using RMAN recovery catalog and a nightly scheduled job
• Weekly scheduled statistics gathering on main application schemas objects to improve performance.
• Preparation of documentation for procedures to implement various database administrative tasks.
• Proactively reacting to alerts with regards to memory, CPU and disk utilization to maintain optimal access to the databases.

Environment: RMAN, Oracle 10G and 11.2.0.4, TOAD, Putty, Remedy, ServiceNOW(SNOW), Foglight, Filezilla, WinSCP, Linux & DB2

Confidential

Oracle Database Administrator

Responsibilities:

• Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX, SunOS & HP-UX)
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Create oracle databases on configured servers using both the DBCA & Database creation scripts.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third party tool(TOAD).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 11g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Database refreshes using expdp, impdp, RMAN and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Backup/Recovery monitoring and reporting using Oracle RMAN
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Test environments.
• DC-DR drill is successfully completed (Switch over & Failover).
• Quarterly purging activity of Informix databases. Backup & Restoration of Informix databases.

Environment: Oracle RMAN, Oracle 10g,11g, DBMS STATS, Datapump,, TKPROF, EXPLAIN PLAN, RAC, Informix