SUMMARY:

• Over 12 years of experience in Oracle Database Administration and Database Design/Architect as an ORACLE 12c/11g/10g/9i DBA on different Unix/Linux and Windows platforms advanced features including Oracle ASM 11g/10g and Oracle RAC 11g/10g, GRID, Data Guard, WebLogic, OAS applications, AWS
• Perform various tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security, migration
• Installed and configured Oracle 12c.Good knowledge on CDB and PDB databases.
• Handful of experience in Oracle Installations, Upgrades, patching in various environments ranging from 9i to 12c and providing 24/7 production support to various clients.
• Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling RMAN jobs, SQL tuning advisor. worked on Security Technical Implementation Guide STIG for 11g and 12c databases for secret databases
• Expertise in Database Upgrade
• Extensive work on Database Migration
• Build 2 - node and 4-node RAC clusters from scratch.
• Worked on various Performances Tuning cases including SQL Tuning, Instance Tuning and Database tuning.
• Managed Databases on various platforms including Linux, AIX, Windows, Solaris
• Performed various database backup, restore and recoveries via RMAN
• Build, configured and managed multi node RAC Cluster on RHEL and Exadata.
• Strong experience in managing 12c Cloud Control
• Build and managed physical standby Data Guard.
• Intensively used ASH, AWR, ADDM reports to troubleshoot performance issues.
• Worked in operations and build database team.
• Performed various Flashbacks using Flash Recovery Area.
• Configure ASM Volumes and ASM Disk Groups.
• Experienced with tools/utilities: OEM, RMAN, Statspack, TOAD, and SQL* Loader, Data Pump etc.
• Worked as Lead DBA on Data Center Migration.
• Cloned Databases using various techniques
• Supporting development 24/7 production systems.
• Provided on-call support for mission critical applications.
• Monitoring free space in tablespaces, space requirements of tables, indexes. Performing database.
• Written shell scripts in bash and korn.
• Performing tuning of queries using SQLTrace, Tkprof, and Explain plan, Statspack, AWR and ADD etc.
• Setup threshold and alerts via scripts and OEM
• Vast Experience with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of database using RMAN
• Involved in capacity and resource planning.
• Performed various Load test and collected performance metrics.
• Implemented data replication through materialized views.
• Managed database on Exadata
• Build and managed uni-directional GoldenGate replication.
• Good experience in SQL, PL/SQL, stored procedures and Shell Scripting
• Experience in Data modeling using Data modeling tools such as Erwin and Toad.
• Worked on SQL Server 2005 and SQL Server 2008.
• Experience with installing and maintaining Oracle Grid Control.
• Skilled in dealing with ASM environment such as Installation, migration from NON-ASM to ASM environment.
• Experienced in RAID, storage technologies and backup solutions
• Experience in writing documents.
• Coordinated work with offshore team
• Supported the system 24x7.
• Very effective communication skills.
• Build Materialize Views Servers
• Worked on Virtual Databases
• Worked on Amazon Cloud (AWS) (EC2, Snowball, S3, EBS, VIP, Route53, RedShift)
• Experience in implementation of enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i, Oracle 10g/11gR2 /12c Multitenant Databases, Real Application Cluster (RAC), ASM, MS SQL SERVER 2005/2008/2012/2014, AWS, MYSQL 5.7, Teradata, MongoDB

Operating Systems & Administration: Red Hat Linux 4.x,5.x,6.x, AIX 5.1,5.2,6.1, O.E.L 5.8, 6.4,6.7 and windows 2000/XP, HP-UX 10.x,11.x, Sun Solaris 9,10, Exadata x5-2, X3-2, X2-2, x2-8, AWS, Windows Server, VMware.

Languages: SQL, PL/SQL, C, C++, OOPS, JAVA Script, Bash Shell Scripting, UNIX Shell Scripting, Jenkins, uDeploy.

Oracle Tools and Utilities: Data Guard, GoldenGate, Logdump, Defgen, Reverse Utility, Veridata, Web logic server, ODI, OBIEE, WebSphere, RMAN, OEM, Autosys, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, Net Backup, ZERTO, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor

Ticketing Tools: BMC Remedy, JIRA, NEWS, Service Now, HP Quality Center

Others: Concepts and Administration Data Guard (Standby), Real Application Cluster (RAC). Automatic Storage Management (ASM) / RAID configuration. Recovery Manager (RMAN)Oracle Golden Gate / Materialized Views / Database Cloning Oracle Data Guard DR setup / Active Data Guard Oracle OCFS2 / ACFS Database Cloning via RMAN / Data Pump / DB Links etc. MS SQL Server / Log shipping / Mirroring / Replication / Installation 12c Cloud Control,12c Multitenant Databases Database Installation, OMF, Silent Install, DB installation via scripts / DBCA

PROFESSIONAL EXPERIENCE:

Confidential, Plano TX

Senior Oracle DBA

Environment: Oracle 10g, 11g RAC, 12c, ASM, Linux, Solaris, Data Guard, Exadata, Golden gate, SQL Server, AWS (Amazon Web services), RAC, Tibco Spotfire Professional, Web player, Tableau, Element LIM

Responsibilities:

• Real Application Cluster, worked on RAC and ASM, building and supporting 11GR2 and 12C RAC clusters using ASM storage, Up-gradation of GRID infrastructure from 11g to 12c.
• Manage day-to-day database operations and DBA charters for production databases and projects. This includes database administration, planning, design, build/delivery, deployment, monitoring, standards, compliance, etc. for production, production operations, monitoring, project builds & delivery, deployments, etc.
• Performed health checks of RAC Clusterware components ocr, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C and 11g RAC.
• Oracle database migration using Datapump export/import, Dataguard, RMAN cloning and Oracle GoldenGate with zero down time based on the database size and Tier level.
• Installing and configuring Oracle GoldenGate 12c for migration and also for the data replication for business use from multiple sources to target databases and troubleshooting issues.
• Experienced in setting up unidirectional and Bi-directional replication using Goldengate 12.2 for high availability, reporting projects and alerts on Exadata.
• Expertise in writing Goldengate parameter files extract, extract pump and replicate data replication requirements.
• Experience in creating Complex Spotfire Dashboards or Reports Using Tibco Spotfire Professional.
• Experience with the BI tools Tibco Spotfire Professional, Web player, Tableau and Business Objects.
• Installing, configuring, upgrading and troubleshooting Element Lims application.
• Tuning Node evictions using disk timeout, reboot time, miscount and Finding Query’s involved in clustered wait events and tuning queries to avoid clustered waits in the environment.
• Strong Exposure in creation on an Oracle 12c Multi-tenancy RAC database with 2 node cluster and instances using ASM storage.
• Adding a New Node to RAC cluster and Installed Oracle RDBMS software on a new node of the cluster, Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c.
• Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c.
• Configured Active Data Guard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Data Guard Broker, fast-start failover and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.
• Configured SLA for Query’s accessing standby database and managed Active Data Guard.
• Worked with VMWARE team in building new servers, performed Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g, 12c Data Guard Standby, GoldenGate v11 and 12c.
• Upgradation of GRID infrastructure from 11g to 12c.
• Installed WebLogic server 12c and Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances.
• Involved in 24x7 support for production RAC databases with on-call pager
• verall Exadata hardware maintenance
• Assisted in management and database administration of Oracle databases on Exadata platforms
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 11g, 12c clients/databases on Solaris and Linux.
• Complete Build of 4-node 11g and 12c RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2 to 12c.
• Build and administer SQL Server 2008, 2012 standalone and cluster databases.
• Skilled with Statspack, AWR, ADDM, SAR, ADRCI to check health of database & hardware.
• Used Performance tuning tools such as Tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Data Guard build
• Build GoldenGate on ACFS and DBFS
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Responsible for administration and supporting oracle 11g, 10g and 9i databases
• Created, upgraded, and cloned Oracle databases for Development and testing 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.
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• Provided System support for both development and 24*7 production environments.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future .
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Working Experience with Latest TOAD having new features PLSQL & SQL Script Debugger, Database Health
• Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace and Query Builder.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM),
• Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Full fill developers request to refresh schemas on a daily basis.
• Resolved DB performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Worked on (DoD) Security Technical Implementation Guide STIG requirements across multiple different Oracle database environments with all environments passing approval process.
• Worked with AWS (Amazon Web Services ((EC2, Snowball, S3, EBS, VIP, Route53, RedShift)
• Designed and implemented scalable, secure cloud architecture based on Amazon Web Services. Leveraged AWS cloud services such as EC2; auto-scaling; and VPC (Virtual Private Cloud)
• Configure and monitor numerous MongoDB instances and replica sets
• Study the database needs of our applications and optimize them using MongoDB
• Maintain MongoDB database performance and capacity planning

Confidential, Chicago IL

Sr. Oracle DBA

Environment: Oracle 9i /10g, ASM, Linux, Solaris, Data Guard, RAC, SQL Server

Responsibilities:

• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Build and administer SQL Server 2005 and 2008 standalone and cluster databases.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farm house.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Tuning high - resource queries introducing hints and creating indexes/parturitions, changing the query if necessary
• Configured and Maintenance of SQL Server databases
• Implemented 10g, 11g Physical Data Guard.
• Implemented Oracle high availability solution using oracle RAC, Physical Standby and GoldenGate.
• Importing data from flat files into database using SQL loader and External Tables
• Written shell scripts to automate the tasks
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Worked on relational modeling using ERWIN.
• Worked very closely with development team
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Created users, roles and granted privileges according to the business requirements.
• Data Modeling, Database Design and creation using Erwin.
• Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
• Automated the replication process using materialized views for reporting databases.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth.
• Applied latest patches as per evaluation requirement.
• Performing tuning of application with RBO, CBO, using Trace, Tkprof, Explain plan, Statspack, AWR and ADDM.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic
• Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global
• 24x7 operational environments.
• Involved in gathering requirements from end users.
• 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.
• Involved in 24x7 support for production RAC databases with on-call pager
• verall Exadata hardware maintenance
• Assisted in management and database administration of Oracle databases on Exadata platforms
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g, 12c clients/databases on Solaris and Linux.
• Complete Build of 4-node 10g RAC Cluster on RHEL 4 from scratch.
• Migrated 10g database to 11g R2.
• Skilled with Statspack, AWR, ADDM, SAR, ADRCI to check health of database & hardware.
• Used Performance tuning tools such as Tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Performed database Cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC and 11g RAC
• Handled RAC Node hangs and node eviction issues.