SUMMARY

• 9+ years of experience of Oracle Database Administration including 12c, 11g, 10g and 9i on platforms Sun Solaris, Unix/Linux, HP - UX and Windows
• Proficient in DBA daily activities including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Experience in migration of Oracle database 11g to 12c on EXADATA X5 platform
• Successful transition of level 1&2 jobs to managed services
• Worked with GoldenGate to move large volumes of data between oracle servers
• Setup bidirectional replication using Oracle GoldenGate
• Laid hands on tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 12c
• Experienced in setting up/Installation and configuration of release 11g R2 RAC with ASM and Raw Devices and 11g CRS
• Planned and implemented DR & high availability solutions using Oracle 11g Standby Database using Oracle Data Guard, 11g and 10g RAC
• Experienced in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment
• Experienced in designing and capacity planning of databases up to terabytes of data
• Experienced in maintaining large Production, UAT, QA and DEV environments
• Creating new Oracle databases using DBCA or database scripts. Installing creating new ASM disk group or raw devices for RAC databases
• Very good experience in installing, configuring and administering 10g and 11g 2/3/4 node RAC databases
• Experienced in using 10g and 11g features like Data pump, Flashback Recovery, ASM and Compression
• Upgrading teh databases from various versions to 11g release 2
• Tuned teh database at various levels such as Application Tuning, Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TK proof, Explain Plan, SQL Trace, UTLSTAT, Stats Pack, AWR and ADDM
• Performed manual recovery using archived logs, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental and cumulative backups
• Experience in installation of Oracle EXADATA server version x-2 with half rack config. accommodating 4 db servers and 7 storage servers
• Worked on Exadata tuning and relevant experience in querying teh SQL statements from teh Smart Flash Cache configuration of teh X-2 server
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating teh daily and historical tables
• Good experience in Oracle 11g/10g RAC, Standby Database (Data Guard), ACTIVE STANDBY, Replication, BCV backups
• Assisted in creating teh data guard physical standby database for 11g production database by configuring FAL server and FAL client parameters
• Established FSFO for teh 11g physical standby through Data guard and assisted in data center migration projects with Data Guard broker DGMGRL
• Experience in various scenarios of Database Recovery and Real application testing (RAT). Good hands on experience in configuring and maintaining 11g/12c ORACLE ENTERPRISE MANAGER (OEM)
• Delivering SQL and Database performance tuning services via V$/GV$views, Explain Plan, TKPROF, AWR (Stats-pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g
• Used PL/SQL (Stored procedures, triggers, packages (DBMS *, UTL *)), SQL* PLUS, SQL* LOADER and SQL tuning of Oracle database
• Extensive experience in Oracle Architecture, I/O tuning, Memory Tuning, Performance Tuning, Backups, Recoveries, RMAN backups, Optimization, Crash/Disaster Recovery, Networking
• Installation and Configuration of Oracle 10g Application servers
• Excellent problem solving skills in dealing with distributed transactions in OLTP systems
• Experienced in managing partitioned tables like creating teh partitioned tables, addition of new partitions, compression, exchange partitioning and carrying out maintenance activities
• Experience in working with teh architect team to model teh structure of teh database through Entity-Relationship diagram models
• Cloning teh Database from Prod to Dev using USER MANAGED and RMAN techniques like ACTIVE DUPLICATE
• Migration of teh user schema using traditional exp/imp and Oracle Data pump utilities
• Proficient with 11g new features: Active dataguard, configuring Snapshot standby database Performance tuning, backup and recovery, space management, database security, Auditing
• Good Written and Verbal Communication skills in a professional manner, with a customer service-oriented attitude
• Good noledge of big data and Data Warehouse concepts
• Ensure timely updates to teh Team Lead and prioritize accordingly, which enables meeting deadlines
• Have proven analytical and problem solving skills as well as ability to multi-task and meet timelines
• Communicate Effectively and clearly displaying goal oriented and great collaboration skills, with a positive attitude
• Experienced in Oracle Support processes for technical requests through Meta-link and other Support Procedures

TECHNICAL SKILLS

Operating System: MS Windows Server 2003 - R2, 2008 - R2, 2012 - R2, 2016 HP-UX 10.x, 11.x, Sun/Oracle Solaris 10, 11,11.3 AIX 5.3, 6.1, 7.1,7.2, VMware ESX Server 3.0.x/3.5.0, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x,6.x,7.x

Programming Languages: C/C++, Java (J2EE), SQL, PL/SQL, Unix Shell Scripting, Perl, Microsoft Batch/Command

RDBMS: Oracle 12c, 11g, 10g, 9i, 8i, MySQL 5.5, 5.6, MS SQL Server 2008,2012,2016, Oracle Real Application Cluster (RAC)

Storage Systems: Oracle ASM (Automatic Storage Management), SAN, NetApp

Oracle Utilities: RMAN, OEM, SQL*Loader, LSNRCTL,STVCTL,CRSCTL, EXP, IMP, EXPDP, IMPDP, DBCA, OLTP, Disaster Recovery and High Availability Oracle Data Guard, Oracle RAC, Oracle Enterprise Manager 10g/11g/12c/13c, Oracle GoldenGate 12c, GGSCIOthers ToolsTOAD, SQL Developer, WinSCP, Putty, SSH Client, Telnet

Database Modeling Tool: serwin Data Modeler, Sybase Power Developer, Microsoft Visio

Ticketing Tool: BMC FootPrints, HPSM, Peregrine

Cloud Computing / CI Tools: AWS Redshift, Simple DB, RDS

PROFESSIONAL EXPERIENCE

Confidential - Pittsburgh, PA

Senior Oracle Database Administrator

Responsibilities:

• Assisted in detailed architecture, consulting, engineering, implementation and support for database availability, backup and recovery, and performance tuning projects
• Support for Oracle Enterprise Manager Grid Control 13c and Agents
• Validation of Privileged accounts and database violation using PL/SQL coding to ensure successful audit on Exadata
• Planning, coordinating and delivering teh migration of Oracle 11.2.0.4 to Oracle 12.2.0.1 on EXADATA X5-2
• Ensure hardening and validation of Oracle database 12c R2 12.2.0.1 on EXADATA X5-2, after migration from 11.2.04
• Implementation and support of 11g and 12c migrations and upgrades from Oracle 9i and 10g databases, including RAC databases on HP-UX and Linux.
• Installed and configure extract, pump, replicate, manager parameter file of GoldenGate
• 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN, trace analysis, service creation, and cluster and system management
• Extensive noledge in configuring Data guard on Linux & multiplexing of control files and redo-logs for disaster recovery scenario
• Performance monitoring and tuning up of teh Database using ASH, STATSPACK, AWR, ADDM.
• Performance tuning of Oracle Database Objects by fixing row chaining, tuning queries.
• Monitoring and tuning system resources associated with teh database performance, hit ratios, I /O, lock, and latch contention
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes
• Data loading using SQL*LOADER and DATAPUMP
• Developed Operation procedures for Managed Service Transition
• Closely worked with MatrixONE and MKS Application support team resolving issues pertaining to teh application & databases
• Provide after hours 24x7(on-call rotation) database support
• Maintained 335 Databases, Implemented 50+ Production database, 60+ Development database, 75+ Test database
• Managed Process using Change control and Cab process and meetings
• Implementation of teh databases of teh Amazon RDS and carried out functionalities for creating instances as per teh requirements
• Implemented and provisioned AWS services like EC2, S3, ELB, RDS, Simple DB, Cloud Front, Cloud Formation templates and heat templates
• Built AWS Cloud Formation templates to create custom sized VPC, subnets, NAT to ensure successful deployment of Web applications and database templates and heat templates

Environment: IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 5.x,6.x, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, OEM 13c, Oracle 12c, Oracle RAC, Data guard, Toad 12.5, AD utilities, SQL server, TKPROF, AWS -RDS, Redshift, Simple DB

Confidential - Plano, TX

Senior Oracle Database Administrator

Responsibilities:

• Installation and configuration of RAC instances in 11g and 12cfor production environments
• Played major role in design and setup of cluster environments for new products
• Designing and configuring 3 node RAC databases with capacity planning
• Implementation of space optimization methods and changing OCR and VOTING disks
• Working on POC with oracle support and designing methods for ROLLOUTS
• Maintaining clusters with utilities like CRSCTL, SRVCTL, OCRCONFIG, and OCRDUMP
• Generating reports from OEM 11g and writing documentation for Cluster-ware installation, RACRDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation Active Duplicate cloning of teh databases using RMAN
• Implemented OEM 12c Repository database, OEM 12c Agents
• Configured teh Oracle EXADATA server X2 for migration from legacy servers for enhanced improvements in hardware I/O performances
• Extensively worked on Hybrid Columnar Compression technique of Exadata X-2, to improve teh storage capacity up to 20-30 %
• Highly experienced in using STATSPACK, AWR to check health of database & hardware
• Documenting various recovery scenarios for DR site and managing teh gaps in archive logs to bring teh standby in sync with primary database
• Building DR environment for teh business critical databases
• Perform refreshes from non-RAC database to a RAC environment
• Tuning teh SQL statement by analyzing teh explain plan and ADDM reports
• Experience in planning and implementing teh maintenance activities to reduce fragmentation and improve performance
• Working with teh solution design team and identifying solutions to teh new business functionalities and preparing teh weekly and monthly status reports to teh management
• Tuning memory parameters and performed logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup
• Deep Knowledge in using tools such as TKPROF; EXPLAIN PLAN, ORADEBUG and TRACEFILE to Tune SQL Queries
• Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.)
• Responsible for Data Center Relocation for migration of standalone databases on AIX/Solaris/Windows and file system to Linux RAC on ASM
• Provide user account administration, optimizing SQL queries; optimizing developer code, manage table partitions, large data sets and provide manual reports using SQL
• Cleanup demographic Data Warehouse tables, develop PL/SQL scripts, monitor data feed and data replication, address/resolve data issues
• Designed teh E-R diagrams based on teh requirement of teh architect teams with teh third Normalized form for object uniqueness and integrity
• Extensively tested teh correctness of teh E-R diagrams through tools like E-R Win and Creately for their logical cohesiveness
• Pearl scripting and Korn scripting for backup jobs and other SQL administered tasks
• Installation of Oracle 10.2.0.4 and upgraded teh database and building load test environments by cloning
• Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving teh performance of teh Query
• Installing Oracle 11g software for 4 node RAC cluster with ASM and resolving issues like re-balancing, disk additions through ASM CMD
• Managing all databases like Critical production, standby, report databases of different platforms like Linux, Sun Solaris

Environment: Solaris IBM AIX 6.3,7.1, Sun Solaris 2.6/7/8, Red Hat Linux 6.0, Oracle 10g/11g/12c, PL/SQL, SQL*PLUS, VNC, ORACLE ENTERPRISE MANAGER 11.2.0, Oracle 12c GRID, QUEST SOFTWARE (5.0), Oracle RAC, Data guard, Toad 8.6, AD utilities, SQL server, TKPROF, Perl, PL/SQL

Confidential - Los Angeles, CA

Senior Oracle Database Administrator

Responsibilities:

• Designing and migrating applications among different environments and providing 24*7 production Support
• Installation and configuration of Oracle databases (single instance) as well as 3 node RAC instances in 11g
• Resolving ASM multi-pathing issues
• Active duplicate cloning of teh databases using RMAN
• Cloning from cold backup using RMAN
• Perform refreshes from non-RAC database to a RAC environment
• Upgrading production environments from 11g to 12c
• Monitored teh SQL and Oracle RDBMS through teh integrated Enterprise Manager of teh 12-c Grid Control software
• Involved in testing several 11g release 2 features in Oracle and upgraded several instances from 10g to 11g
• Moving PL/SQL-codes into production and validating teh codes and tuning teh SQL statements before using them in production environments
• Responsible for moving data from Production to lower environments for various testing cycles using Oracle data pump and also refresh teh UAT and Test environments with Prod data
• Supported large data warehousing systems with a capacity ranging from 2 TB to 15 TB
• Writing scripts in BOURNE and KORN shells for executing backups and other DML triggers
• Monitoring teh bash scripts and profile parameters in teh UNIX and RHEL Linux environment for setting teh ORACLE environmental variables
• Configure and manage RMAN backup using OEM GRID
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning
• Resolve issues during migration from different ASM disk groups following up with Oracle
• Administrate RAC service with SRVCTL
• Manage teh Cluster Services in case of any abnormal failures
• Worked with users in tuning their bad SQL and high load SQL queries
• Data guard setup and configuration for physical standby with consistent switchover and failover drills for maximum availability
• Generating AWR reports on regular basis to identify teh database performance at peak load
• Making use of 11g Release 2 features like ADRCI
• Worked with teh storage teams to monitor and administer teh storage plans for teh DBs through VERITAS volume manager and Linux volume manager for RHEL 4.0
• Worked on HP UX platform and logically migrated data from UNIX to Linux (OEL 5.4) through Data Pump
• Strong noledge and experience of managing Oracle 9i and 10g RAC environments using teh OEM Grid Control tools

Environment: Oracle 10g RAC, Oracle 9i, HP-UX 10.x, AIX, Red hat Linux, TOAD, OEM, STATSPACK, TKPROF, SQL, Erwin 4.0, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts

Confidential - Indianapolis, IN

Oracle DBA

Responsibilities:

• Implemented 10g and 11g new features
• Migration of teh data from SQL database to Oracle database
• Dealt with Interconnect issues from different systems to oracle databases
• Participated in data center management for setting up teh database backups
• Removing teh fragmentation from core objects with minimal downtime
• Maintenance of partitioned tables and archiving. Installing and configuring CRS on all cluster nodes
• Load data into Oracle using SQL *Loader, RMAN backups, Export/Import database objects/schema, Enforce database accuracy and integrity
• Installing Oracle 10g software for RAC with ASM
• Monitoring and optimizing system performance using index tuning, disk optimization, advanced database techniques and other methods, including teh use of automated tools
• Managing partitioned tables
• Planning and implementing teh maintenance activities to reduce fragmentation and improve performance
• Upgraded databases from 9.2.0.6 to 10.2.0.4
• Working with online record management systems for SQL tuning
• Tuning teh SQL statements and moving them to teh production for district wise modules
• Worked on resolving distributed transaction issues
• Scheduling and troubleshooting teh materialized view refreshes
• Worked on configuring backups using Net-backup
• Installing and creating teh databases of enterprise versions
• Worked on configuring teh suitable adapters in coherence with oracle databases for front-end police devices
• Working with teh solution design team and identifying solutions to teh new business functionalities
• Performed REDO logs management and tuning by creating new members and re-sizing them
• Partitioning tables to improve performance
• Dealt with database cloning, Migration, Data Guard and Patching of Oracle Databases
• Cloning teh databases using RMAN DUPLICATE and manual methods
• Configuring teh jobs with shell scripting and usage of Cronjobs
• Analyzed teh performance of teh SQL queries and created teh scripts for indexes
• Usage of log-on triggers for core level auditing
• Experienced in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating teh daily and historical tables
• Automated Rebuilding indexes, Partition additions and space additions

Environment: Oracle 10g RAC, Oracle 9i, HP-UX 10.x, AIX, Red hat Linux, TOAD, OEM, STATSPACK, TKPROF, SQL, Erwin 4.0, Oracle Enterprise Manager (OEM), SQL*Loader, TKPROF, Data Guard, Shell Scripts

Confidential

Junior Oracle Database Administrator

Responsibilities:

• Installing new versions of database software and perform maintenance functions of teh database
• Compiling and debugging packages with in-house code, and assisting teh developers with optimizing and tuning teh PL/SQL code
• Upgraded teh RMS database from 8i to 10gr2
• Analyzed teh performance of teh SQL queries and created teh scripts for indexes
• Cloning/Refreshing databases from hot/cold backups
• Setup connectivity to databases using NET 8 for clients and server side
• Developed and maintained teh system using Oracle Forms, Oracle Reports, SQL*Plus and PL/SQL
• Creating database objects such as tables, views, procedures and functions and executed them using SQL*Plus
• Created indexes to improve teh system performance
• Involving in creation of triggers and handling exceptions
• Developing various Business and ad-hoc Reports
• Creating Data Flow Diagram, Entity Relationship Diagram from Designer
• Involving in writing PL/SQL Triggers, Procedures, Functions and Packages
• Analyzed performance bottlenecks and provides appropriate solutions
• Wrote various scripts in PERL and SHELL for database health and space checks
• Providing Production support and troubleshooting user issues
• Administration of databases- Physical and logical structures
• Export/Import data to/from Production and Non Production systems as required
• Database backup and recovery management (Hot/Cold, Exp/Imp) using scripts
• Identifying and resolving resource contention issues and monitoring database performance
• Maintaining of Space requirements on teh Tablespaces by adding/re-sizing data files based upon teh space available on teh file systems
• Creating and Managing Users, Granting, Revoking privileges for teh users in order to ensure teh Database security
• Monitor teh operating system response in terms of CPU usage, disk space, and swap space by using various like VMSTAT, ISOSTAT and TOP

Environment: Oracle 9i, 10g, HP- UX 10.x, AIX, Linux, TOAD, STATSPACK, TKPROF, SQL, Erwin 4.0, SQL*Loader, TKPROF, Data Guard, Shell Scripts