Sr. ORACLE DBA
10+ years of Relevant Oracle DBA experience that includes leading team of DBA’s, people management, database administration, database design, development and support of oracle 8i/9i/10g/11g/12c (RAC) in production, test and development environment.
Installations and configurations of Oracle database Servers (8i, 9i, 10g, 11g & 12c)/ Grid Control on Linux & Windows servers. As well as manage Oracle DB through SQL PLUS, Grid control, OEM and Putty.
Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, Datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Stats pack and tuning of initialization parameters.
Experience in converting Standalone DB to RAC, as well as converting DB from normal file system to ASM.
Strong in Database design & development, System Analysis, Designer, Linux & Windows server Administration.
Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers.
Experience in database patching, cloning, upgrade, migration & maintaining standby DB server (DR).
Experience in setup and configuration of Oracle Golden-Gate
Experience with database backup, recovery, and setting up disaster recovery Database servers.
Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc.)
Expertise in all the phases of Software Development Life Cycle (SDLC).
Experienced in working with DBVERIFY utility and other method to find Data Corruption.
Involved in Capacity planning for Databases and Server consolidation
Worked closely with application team members to perform SQL Tuning using Explain Plan, SQL Trace, ADDM, AWR, Optimizer Hints, Stats pack and TKPROF utility. Participate in testing and the development of performance standards.
Re-organizing the DB table regularly by removing row migrations and fragmentation Providing the full database dumps and schema/table level dumps to DEV/QA database environments when needed. And also refreshed & migrated full DB using data pump
Estimating Storage requirements, Creation of Table spaces and other Database Primary Objects, increasing the storage parameter values, resizing the data files, adding new data files.
Adding and removing services, databases and instances on oracle CRS using strictly utility and DBCA utility
Testing the deliveries, Releases, and patches before applying them in the production environments.
Design and implement of database backup strategy and performed full, incremental and archive backups using RMAN. Troubleshooting with RMAN backup problem.
Optimization and fine-tuning the database by planning storage requirements, building indexes and altering storage clauses for tables and indexes.
BA – Northeastern IL University Chicago IL
Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003, Windows 2000/NT, Windows XP.
Databases: Oracle 12C/11g/10g/9i/8i, SQL Server 2005
DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Utlbstat, Utlestat, Statspack, AWR, ADDM, QOPATCH, GOLDEN GATE, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA
Monitoring Tools: OEM 11G/12C, Performance and Web Portals, BMC Remedy, HP Quality Center.
Languages: Oracle SQL & PL/SQL, C/C++, Shell Scripting
Client: Wells Fargo, Charlotte, NC Aug 2017 – Present
Senior Oracle DBA
Worked with Linux, Solaris and other flavors of UNIX.
Extensively working with Oracle technologies (Oracle RAC, ASM, Data Guard, partitioning,
security, performance tuning, memory management, SQL tuning, statistics gathering, Application audit logs, Scheduling, etc.)
Utilizing performance tuning tools like Explain plain AWR, Grid control.
Generated reports and resolve performance issues.
Performed backup and recovery, application patching, cloning, maintenance and solved problem within the Oracle 11g and 12c environments.
Support and lead upgrade activities within the Oracle 11g and Oracle 12c.
Worked with Unix and Perl scripting.
Maintained (500G) to (200 TB) sized databases.
Worked with Golden Gate.
Environment: Oracle 10g/11gR2/12C, OEM-12C, RHEL, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Golden Gate, RMAN, EXPDP/IMPDP, EXP/IMP, TOAD,SQL Developer,SVN, ASM, DEVsuite, Net-Backup. MySql, Oracle RAC,ASM,Linux,Windows, Solaris, Powershell,Shell Script,Exadata server,BCP,SSIS,Teradata.
Client: United Health Group Inc, Eden Prairie, MN Jan 2017 to Aug 2017
Senior Oracle DBA
Strong communication skills, driven personality, comfortable communicating with many levels within the organization.
Implemented Oracle database backup and recovery concepts, including RMAN usage.
Worked with Oracle security.
Extensively working on Oracle RDBMS. Diagnose issues and made adjustments to the environment including initialization parameters, O/S parameters.
Performance SQL statements.
Worked with Unix, Linux, and Windows.
Created Unix scripting.
Performed PL/SQL coding.
Monitored Exadata and databases through Oracle Enterprise Manager (OEM).
Worked with Oracle Real Application Clusters and ASM.
Interacted with application teams directly to design solutions.
Worked on Oracle Data Integrator (ODI).
Worked with Exadata.
Troubleshoot users request to diagnose issues, including potentially end or non-technical users.
Performed capacity planning exercises.
Worked with the BAs to understand database requirements for new implementations.
Created stored procedures
Performance tuning to ensure applications are performing optimally.
Troubleshoot escalated issues.
Environment: Oracle 10g/11gR2/12C, OEM-12C, RHEL, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Golden Gate, RMAN, EXPDP/IMPDP, EXP/IMP, TOAD, ASM, DEVsuite, Net-Backup. MySql, Oracle RAC,ASM,Linux,Windows, Solaris, Powershell,Shell Script,Exadata server,BCP,SSIS.
Client: Bank of America Corporation, Charlotte, NC Feb 2016 to Dec 2016
Senior Oracle DBA
Strong verbal and written communication skills.
Provided technical documentation, automation scripting, installation, monitoring, and trouble-shooting across a large enterprise environment.
Involved working in global environment across time zones.
Implemented database server and application sizing and capacity planning.
Implemented database server and application tuning for performance and scalability.
Worked with Golden Gate
Performance testing experience
Worked with Oracle Enterprise Manager (OEM)
Experience in High Availability and Disaster Recovery requirements and solutions
Upgrading databases to Oracle 11g & 12c with RAC, Oracle Dataguard & Dataguard broker.
Worked with RAC One Node (RON)
Worked with database and application server internals
Handle On-call support for 24x7 applications
Strong knowledge and experience with Oracle Golden Gate replication
Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
Supported RDMS platforms namely DB2, SQL Server, or Informix
Project management and oversight with oversea team
Developed Data modelling (both logical and physical)
Worked with Exadata
Environment: Oracle 10g/11gR2/12C, OEM-12C, RHEL, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Golden Gate, RMAN, EXPDP/IMPDP, EXP/IMP, TOAD, ASM, BMC Remedy Ticketing system, Net-Backup. MySql, Oracle RAC,ASM,Linux,Windows,Powershell,Shell Script,SQL server,BCP,SSIS.
Client: State Street Corporation, Boston, MA Jan 2014 to Feb 2016
Senior Oracle DBA
Production support DBA. Responsible for other duties/projects as assigned
Proficient in 10G/11G/12c RAC Installation/Maintenance and Troubleshooting CRS/Grid Infrastructure and ASM issues
Replication using Goldengate, Zero-downtime migrations, setup Uni-directional CDC
Configuration of RMAN backups for databases using TSM /DDBOOST. Design and Optimize backup & recovery strategy, refresh stage databases
Creation of new RAC databases, conversion from single instance to RAC.
Planning and Implementation of upgrades of RAC/standalone and Databases from 18.104.22.168 to 22.214.171.124, Upgrade 126.96.36.199 RAC databases to 188.8.131.52/184.108.40.206
Extensively working on new builds of 11gR2 RAC / RAC-ONE / Data guard environments with
ASM on Linux/AIX platforms.
Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.
Implemented 11g Standby database setups, Active Dataguard
Developed and maintained PL/SQL Stored Procedures, Packages and Functions.
Implementing quarterly patch cycles for databases systems in 12c, 11g RAC/Non RAC databases.
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 and Configuration of OEM 12c, Agent installations using various methods & configuring
target hosts/databases for monitoring. Set up alerts and notifications from 11g OEM
Export and import of tables, schemas and Full DB as per development/Application team req. using Data pump / Exp-Imp
Configure RMAN backups for databases and schedule them through Crontab
Resolve common database issues like Locking, Free Space, connectivity issues, Applying patches etc.
Performance Tuning of problem queries
Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
Environment: Oracle 10g/11gR2/12C, OEM-12C, RHEL, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Golden Gate, RMAN, EXPDP/IMPDP, EXP/IMP, TOAD, ASM, BMC Remedy Ticketing system, Net-Backup.
Client: Seagate Technology, Minneapolis, MN Nov 2012 to Dec 2013
Senior Oracle DBA
Planning hardware and software requirements for installing Real application cluster (RAC) 11gR2.
Extensively working on multiple 10g/11gR2 RAC environments on ASM, 10g/11g DATAGUARD setups & RMAN
Applying quarterly PSU Patches to RAC/Non-RAC databases and CRS Bundle patches/PSU to CRS on RAC clusters.
Upgradation of CRS/ASM/RAC databases from 10.2.0.4 to 10.2.0.5 & 220.127.116.11 to 18.104.22.168, 10.2.0.5 to 22.214.171.124
Performed Upgradation of 10.2.0.4 CRS/ASM to 126.96.36.199 GRID Infrastructure
Implemented Space Management in ASM Diskgroups, Addition of new disks and also troubleshooting RAC, DATAGUARD, and ASM issues
Extensive Performance tuning using the AWR and ADDM reports from time to time to analyze and enhance the database performance.
Expert-level performance monitoring and tuning using OEM, TOAD DBA SUITE, Spotlight.
Implemented Database Backup and Recovery strategies and policies.
Troubleshoot various Database instance tuning issues to maximize the DB performance.
Performed DB Cloning using various methodologies
Implemented GoldenGate replication in Oracle RAC Multimode and Oracle RAC One Node.
Database refreshes using RMAN cloning and extensively used RMAN for all types of recovery/backup scenarios.
Handle Oncall issues and jump into Sev1 /2 calls and ensure timely restoration of database services.
Monitoring of DB growth, performance, health of Cluster on Day to Day Basis using OEM, TOAD.
Implemented Table Partitioning to improve user query performance
Resource monitoring (servers, storage, services) using SiteScope.
Closely work with the developers, performance testing engineers and program managers to recommend the best practices and troubleshoot prodigious problems.
24x7 on-call support for critical database issues to help meet the deadlines.
Environment: Oracle 11g/10g, Red Hat Linux, TOAD, RMAN, Data Guard, OEM, Grid Control, Golden Gate, Data Guard, STATSPACK, AWR, Explain Plan.
Client: Centene Corp, Clayton, MO Jan 2012 to Oct 2012
Senior Oracle DBA
Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux (OEL).
Configured 3-node Real Application Cluster (RAC) and monitored RAC instances with Oracle Enterprise Manager Grid Control.
Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
Done migration of non-ASM database to ASM databases.
Implemented ASM on RAC databases and standalone databases.
Involved in monitoring the database related activities using Oracle Enterpriser Manager 10g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
Performed oracle database refreshes using expdp/impdp from production to test database.
Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
Performed logical backups of schemas and database using DataPump (expdp/impdp) as per requirement.
Cloning of Databases using RMAN.
Written SQL scripting to monitor Tablespaces.
Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
Performed Range Partitioning as a cause to improve the performance of the database.
Daily incremental backup and weekly full backup of databases using RMAN.
Participated in regular on-call support for production databases.
Importing of dumps using impdp/expdp utilities.
Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise Manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).
T-MOBILE, Seattle, WA Oct 2010 – Dec 2011
Installation, configuration and maintenance of Oracle 10g and 11g databases on AIX.
Created Databases on SUSE 10 and SUSE 11 servers.
Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
Installed Oracle 10g, 11g RACdatabase on Red Hat Linux.
Creating and maintaining the Oracle databases.
Installation and maintenance of Oracle 11g Data Guard (Active).
Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
Installation, Configuration and Maintenance of Oracle RDBMS Software.
Experience in applying critical patches and patch sets whenever required.
Applying patches both Server side and Client side.
Coordinate with UNIX administrators for space management on various servers.
Setting up new environments (Development, Production etc.).
Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration
Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
Worked on import/export and SQL- loader.
Setup backup and recovery procedures using RMAN.
Configured and support Oracle middleware applications and Oracle Web Logic Server for Linux x86-64
Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
Involved in I/O tuning by moving data files and redo log files to faster disks.
Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.
Environment: Oracle 11g/10g/, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, Data Guard, OEM, Grid Control, Golden Gate, Data Guard, STATSPACK, AWR, Explain Plan.
Client: Deutsche Bank New York, NY Oct 2009 to Sept 2010
Involved in 24x7 supports for Production database and applications with on-call pager.
Installation and creation of 10g RAC and 9i databases for Testing, Development and Production.
Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
Configured Disaster Recover and Logical standby for Production database in 10G.
Tune databases performance, Schedule backup, jobs using OEM Grid Control.
Involved optimizing database schemas, SQL queries, database procedures, and installation.
Cloned/Refreshed Oracle Databases using RMAN for development and testing.
Worked with Erwin, ER/Studio, Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder, SQL, PL/SQL.
Responsible for setting and managing user accounts, granting required privileges, profiles to users, Auditing Users.
Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
Supported upgrades from oracle 9i to 10g, 9i/10g.
Performed migration from 9i to 10g from AIX to Linux.
Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.
Developed startup/shutdown guides, troubleshooting documents, root cause analysis documents.
Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.
Creating tablespaces sizing the system table space, allocating default tablespaces for users.
Creating tables and indexes, sizing their extent, partitioning and so on.
Creating users with restricted access, with default and temporary tablespaces.
Developed database system build sheets, code review checklists, code promotion process documents, outage reporting documents.
Resolving SQL tuning issues and Tuning Considerations for Different Applications.
Monitoring the table growth, database growth, current users, and system resource usage and so on.
Experience in SQL*Loader, loading data from text files.
Performed scheduling of Change Control-activities and scheduling jobs.
Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
Contact oracle meta link to resolve database issues and to raise SR's.
Environment: Oracle 10g /9i, ASM, Sun Solaris 9, Red Hat Enterprise Linux 4.x, OEM, Explain Plan, Tkprof, SQL*LOADER
Client: Medica, Minneapolis, MN Nov 2008 – Sept 2009
Jr Oracle DBA
Installing 10g/9i for TEST and Development.
Developing shell script to automate the processes.
Create table spaces, tables, and users for custom applications.
Creating and dropping of users, granting and revoking permissions to users/roles as and when required
Applying standalone RDBMS patches
Installed and Implemented Backup & Recovery procedures.
Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
Created PL/SQL procedures (jobs) to automate maintenance tasks.
Write SQL scripts to monitor tablespace and extent growth.
Developed RMAN scripts for database backup and recovery including hot and cold backup.
Using TKPROF, EXPLAIN PLAN for better performance
Data loads using SQL loader utilities
Environment: Oracle 9i, Linux, Solaris, Windows NT/2000, Toad.