SUMMARY

• Senior Oracle Database Administrator with over 8 years of experience in database administration, design, development, replication, data modeling, performance tuning, and high availability solutions.
• Exceptional and proven database management skills with experience in managing Oracle builds, upgrades/migrations, database security, disaster recovery, patch management and SuperCluster/Exadata in a large complex Linux/Unix and Windows environment.
• Experience in TDE (Transparent Data Encryption) in both 11g wallet and 12C Keystore.
• DBA and well versed with SQA (Software quality assurance) life cycle, requirement gathering, deploying test cases development
• Hands on experience in Oracle 9i, 10g, 11g, 12c and 19c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN).
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
• Expert in delivering Oracle Database performance - tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience with SQL coding including DDL, DML and fine tuning those sql's for better performance.
• Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc
• Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, or debug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
• Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
• Extensive experience in designing Logical and Physical data models for new developments using ERwin modeler.
• Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 11g&12c Grid Monitoring.
• Skilled in cross platform migrations from Windows to Linux, Solaris, HP and AIX Unix
• Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Experience with My Oracle Support (MOS)/MetaLink for Oracle SR, patch download and software delivery cloud.
• Exceptional skills in evaluating latest Oracle products and state-of-the-art technologies.
• Experience with Oracle Super Cluster/Exadata, database sizing and capacity planning.
• Performed PL/SQL development, Shell scripting and Performance tuning.
• Experience working with VMware and Oracle Virtual Machine (VM).
• Experience with NetBackup RMAN database backups, ASM storage, ACFS, HACMP, Unix/Linux Admin, RAID, SAN storage.
• Experience with Erwin data modeler,Oracle Designer and knowledge of Toad Data modeler.
• Expertise in database security - SOX compliance, database audit, user profiles, security patch updates and PCI layer 3 migration.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Used AWS Management Console EC2 Dashboard and set up your root account.
• Experience in supporting both OLTP/ OLAP database environment, set jobs that archive data from OLTP to OLAP
• Used AWS LightSail to automatically deploys and manages compute, storage and networking capabilities required to run your applications.
• Familiar with AWS S3 (Simple Storage Service), EFS (Elastic File System), Glacier and Storage Gateway
• Good experience in RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like SRVCTL, CRSCTL ASMCMD, CELLCLI and dcli
• Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
• Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
• Collecting performance statistics using Statspack /AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
• Experience with Kubernetes and container, CDB PDB 12c Zero Data Loss Recovery Appliance (ZDLRA) Backup Module
• Experience with configuring ZDLRA Backup Module Oracle DB 10gR2, 11g, and for backup and restore, using standard Recovery Manager (RMAN) commands
• Excellent analytical, problem solving, communication and interpersonal skills.
• Great googling skills to research, learn and find solutions for challenging stuffs.

TECHNICAL SKILLS

Hardware: Oracle SuperCluster T5-8/T4-4, T4/M5000 SPARC, Confidential Power P8/P770/780, P630/P520, RS/6000, Compaq ProLiant 3000, Compaq ProLiant 380/385 G3, Dell PowerEdge, HMC, HP SAN, Microsoft CPS

OS: Oracle SPARC Solaris 10/11, Confidential AIX 6.0/5.3/5.2/4.3.3/4.3.2 , Windows 8/7/Vista/2003/2000/XP/NT/9.x, Red Hat Enterprise Linux 7.0, Oracle Enterprise Linux, CentOS, SCO Unix, MS-DOS, SUSE Linux

RDBMS/Servers: Oracle 12c/11g/10g/9i/8i/7.x, MS Access, SQL Server 2005/2008

Languages: SQL, PL/SQL, HTML, JavaScript

Database/Application Tools: Oracle Exadata, Oracle Enterprise Manager 12c/11g/10g/9i Grid Control, TOAD, RMAN, Oracle Streams and Replication, Golden Gate, SQL Optimizer, Dell Shareplex, Connection Manager, Spotlight on Oracle RAC, Oracle Transparent Gateway for SQL Server, SQL*Loader, SQL Server Management Studio, SQL profiler, IIS, ARCserveIT Backup, NetTerm, Delphix, HUR, Oracle Warehouse Builder, Oracle RAC, Oracle Application Server, WebLogic server, Putty, Xming, Xmanager, MobaXTerm, VNC, CA ManageIT, SQL station, Unicenter TNG,Quest SQLab Vision, BMC Patrol,Developer 2000, ERwin, Oracle Designer, Crystal Reports, WinRunner, MS Vision and Project, VMware vCenter & vSphere, Oracle VM, Virtual Box, Confidential CDC/IIDR, Excel, PowerShell, OpenStack, Puppet, GIT, Eclipse, NoSQL - MongoDB, Couchbase

PROFESSIONAL EXPERIENCE

Sr. Oracle Database Administrator

Confidential

Responsibilities:

• Database administration, architecture, and engineering across Confidential Medicare/Medicaid and related systems on Unix, and Linux (Platform/System) environment.
• Built 2-node RAC, Single instance (ASM) databases and DR (Active Data Guard) systems at Confidential Data Centers.
• Point of Contact for Confidential 250+ databases - Production (25 - 30 TB), Staging, Development, UAT, QA, Parallel Run, Migration, DR.
• Built/Configured Grid Infrastructure/Clusterware for 19c (19.3 &19.11).
• Configure new builds into OEM 13c and configure/test monitoring alerts.
• Used RMAN Duplicate/cloning and EXPORT/IMPORT data from both 11.2.0.4 (11gR2) and 12.2.0.1 (12c R2) to 19.3.0.0 (19c)
• OEM, Splunk and Dynatrace - Monitoring tools, knowledge of tool usage, logs review, and assist in dashboard creation.
• Perform day-to-day database administration tasks - tablespace management, user password management, ASM space/disk addition, privileges and grants etc.
• Coordinate DBA tasks and Developer's requests in rotation with fellow DBA team (size 11 DBAs).
• Implemented RMAN database and archive log TAPE backups using NetBackup.
• Plan Oracle PSU patching and apply patches to Prod and non-prod databases on RAC and Standalone.
• RMAN Backup/Restore/Recovery and Duplication of databases
• Performance tuning - SGA, init parameters, slow database response, re-size redo logs, ADDM and AWR reports.
• Research and review database migration to SAN storage to replace older disk used by ASM
• Built DR systems using Active Data Guard.
• Implemented different configurations - 2-node RAC (Primary) to Single-instance (Standby), Single-instance (ASM/Primary) to Single-instance (ASM/Standby), Single-instance (non-ASM/Primary) to Single-instance (non-ASM/Standby), one primary (PROD) to more than one standby (Reporting and DR).
• Developed scripts for database status, standby log apply, sync check and latency detection.
• Supported go-live of Confidential ’s databases and application databases included but not limited to TMSIS, SIEBEL, Confidential DataStage, Confidential CMOD/FileNet, Maximus, IDASH, SFG, SOA, OIM, etc.
• Component deployment for new releases to non-prod and prod.

Oracle Database Administrator / DevOps support

Confidential, Brentwood, TN

Responsibilities:

• Worked 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
• Supports both Standalones and a 4 Node Exadata on X6s for Confidential from Dev,, Test, UAT to Production environments, involving daily configuration, administration, all running on Red Hat Linux 7.0. Database sizes range from 1TB to 15TB.
• Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4 and from 9i to 12,2,0.1
• Create baseline statistics to optimize the database performance
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Upgraded OEM12C to 13C.
• Managed agents using emctl utility and creating incident rules in enterprise manager 12c & 13c
• Configuring administration groups and creating template collections in oem 12c.
• 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).
• Work closely with the Oracle developers for the better performance in Applications, in writing the Packages, Triggers and Indexes on the tables.
• Use Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
• Responsible for implementation & administration Oracle 11g R2 (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
• Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Created database Objects, Tablespaces, Schemas as needed.
• Database refresh from Production to dev, test and uat.
• Worked with Oracle support on changing IPs from old domain to new domain.
• Assist to Install, Configure and Deploy Linux, Apache, MySQL/MariaDB, PHP (LAMP) stack web server.
• Installed, maintained and finetuned the Apache-Tomcat server and Websphere Application Server in Linux Platform
• Establishing a complete DevOps pipeline (Git - Jenkins - Ansible-Docker-Kubernetes)
• Building Docker images and pushing them to Docker registry
• Creating Ansible Play-books (yaml file) and Ansible roles for application deployments
• Collaborating with Development and Production teams to ensure smooth running of the pipeline
• Automating the deployment docker images to docker registry using Jenkins (CI/CD)
• Automating the deployment of developer codes and applications using Git, Git hub and Jenkins
• Deploying codes to tomcat server through maven projects using Git and Jenkins.
• Build Aws infrastructure in the AWS cloud using VPC, EC2, IAM, Route53, S3, ELB etc
• Investigate and resolve all daily assign tickets with Jira
• Participate in daily scrum to improve system performance, and automation capabilities.
• Install and configure HAPROXY and Teams Load balancer for servers high availability and redundancy
• Perform software installation, upgrades/patches, troubleshooting, and monitoring on LINUX/UNIX servers
• Write Dockerfile to build and manage customized docker images.
• Manage services such as LDAP for user’s authentication, Nginx and HTTP for proxy, Autofs and NFS for volume sharing, SSL and SELinux for security, SMTP for mail, DNS for hostname resolution, and DHCP for IP address

Oracle Database Administrator

Confidential, St. Louis, MO

Responsibilities:

• Supported many databases for Confidential running Oracle 11g & 12.2.0.1, 18c on Standalones & Exadata environment, running on X6s with the use of Cloud Control 12C in monitoring.
• Created documentation to support the business and satisfy regulatory requirements.
• Planned and executed disaster recovery for company production systems.
• Researched and solve Oracle problems with Oracle Support.
• Provided senior level DBA support for applications, including developing data migration scripts, data validation queries, and a maintenance plan for the various development versions of these applications.
• Provided documentation and support for all aspects of maintenance and development.
• Worked with application development team staff to develop & test database architecture and approve all production schema changes.
• Managed movement of data between Dev Test. UAT and Production.
• Tuned database instances and applications and recommend changes to improve database performance.
• Migration of data from sql-server to Oracle12C.
• Planned and implement backup and recovery strategy and write scripts to do nightly RMAN backup.
• Installed, patched, and managed Oracle Database versions 11g on Red Hat Linux
• Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature. implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 .
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for the Production databases.
• Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents.
• Implemented Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
• Migration of databases to 12C from Oracle 10g&11g.
• Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
• Also, worked on Network data encryption to improve the security and implemented SSL wallet to secure the connections.
• Migrated OLAP databases close to 8TB with minimal downtime using GoldenGate and verified data integrity using Goldengate Veridata tool for Linux 3 Node RAC.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
• Implemented Range, list and interval Partitioning for monthly partitioning of large tables.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
• Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
• Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS JOBS, DBMS SCHEDULER, Crontab.
• Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
• Handled Chained Rows and Row migration and solved the database performance issues.
• Experienced with ASM, adding, deleting disks to the disk group.
• Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries
• Coordinated maintenance activities including shutdown and startup of db's and ec2 instances
• Completed RDS backups before and after maintenance activist including upgrades and patching
• Tools Used: Oracle RMAN, Oracle 11g (11. 2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Oracle Database Administrator

Confidential, Tampa, FL

Responsibilities:

• Provided 24X7 support for all the production and development databases for Harmony.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Worked on Installation and maintenance of Oracle 11g, 12C RAC databases including Golden gate, ASM and CRS.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.
• Successfully upgraded the databases from 11g to non CDB 12c.
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Created Oracle Wallets and implemented Tablespace level TDE security.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Perform day-to-day database administration tasks - tablespace management, user password management, ASM space/disk addition, privileges and grants etc.
• Created database Objects, Tablespaces, Schemas as needed Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant