SUMMARY

• me have over 12 plus years of experience as DBA and managing databases providing 24/7 support of both development and production Oracle 19c/18c/12c/11g/10g/9i databases on Various Platforms.
• Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Conducted interviews and made recommendations for new hires, consultants or replacement for the personnel.
• Managed a team of 25+ onshore and offshore DBAs.
• Excellent leadership skills and team building abilities.
• Motivated the team, helped improve the performance of the team.
• Coached and mentored the team for day to day activities.
• Goal Setting and Achievement - Set goals for DBAs individually and for the team and did year end reviews.
• Developed and executed strategic plans and training to achieve goals, and improve SLAs.
• Built and maintained strong, long lasting customer relationships.
• Communicated, presented and influenced all levels of the organization, including executive.
• Strong at maintaining, automating and improving the processes for database administration.
• Excellent experience in Installation, Setup and configuration of Oracle 9i, 10g, 11g, 12c, 18c, 19c in Confidential -UX, SUN SOLARIS,IBM AIX and UNIX/LINUX EXADATA environment.
• Poses strong Administrative skills in RHEL and EXADATA.
• Provided DBA support with proactive monitoring, identifying areas that need to be improved in the application and databases using Statspack, AWR, ADDM, and OEM Grid Monitoring.
• Over 8 years of experience working with Oracle Dataguard & have successfully completed projects using Oracle Dataguard and GOLDENGATE - Implement & support.
• Good experience working with Cluster Server Management (Real Application Cluster) & have successfully completed projects on Oracle RAC - Install, Configure, implement, and support.
• Good experience in performance tuning of production and development databases.
• Strong experience in database backup & recovery procedures using conventional cold, hot & RMAN backups
• Highly proficient in SQL, PL/SQL, bash and korn scripting
• Experience in Installation and configuration of Oracle 10/11g/12c/18/c/19c on SUN-Solaris, Confidential -UX, IBM AIX, Linux, Exadata and Windows
• Experience in Installation, configuration of Oracle 11g, 12c, 19c RAC & also used Oracle features like - Memory Management, Reorganization / Rebuild Indexes, Gather statistics / Automatic Statistic Collection, SQL Baselines, SQL Profiles, invisible indexes.
• Excellent experience in using OEM, TOAD, Data Migrations using export/import
• Excellent experience in cloning of databases using RMAN duplicate database feature.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery support
• Management of schemas, objects & Partitioning the tables & indexes.
• Proficient in performance tuning using Explain Plan, STATSPACK, SQL TRACE, TKPROF, ADDM
• Good Interpersonal communication skills and Documentation skills.
• Provided On-Call support.
• Good experience in User and security management using Grants, roles, privileges.
• Experience in setting up DR solutions using RMAN, scripts, DataGuard
• Setup Oracle 11g, 12c GlodenGate for replication needs.
• Poses strong DBA knowledge on SQL Server 2005 and 2008.
• Poses strong knowledge on RAID levels, NAS and SAN.
• Worked extensively with SAN admins for ASM disks and Diskgroups.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Developed and implemented Materialized views for better performance of daily reports.
• Expertise in using Oracle Enterprise Manager (OEM) and Grid control and its components.

TECHNICAL SKILLS

Programming: SQL, PL/SQL, T-SQL, UNIX Python and Shell Scripting, bash, ksh

Database: Oracle 9i/10g/11g, 12c,18c, 19c Microsoft SQL Server 2005, 2008, 2012

Operating Systems: Windows Server 2003, 2008, 2012, RHEL, IBM AIX, Confidential -UX, Sun Solaris, Ksh, Bsh, VMware, X8 & X5 Exadata

Tools: SQL*Plus, PL/SQL, Oracle Enterprise Manager (OEM) 13c, SQL*Loader,, data pump, export, import, DBVerify, SQL loader, statspack, tkprof, DataPump, Grid-control, Database control, RMAN, Toad, Exceed, confio, SQL Developer, Glodengate, RAC, Patching Exadata & Linux, Performance tune, systems engineering.

Networking: LAN, WAN, TCP/IP, DNS, AD Server

Cluster: Real Application Cluster (RAC), Windows Cluster

PROFESSIONAL EXPERIENCE

Senior Database Administrator

Confidential, IL

Responsibilities:

• Lead and developed high-performing Oracle and SQL DBA team.
• Collaborated with the IT Infrastructure team, the IT Planning & Execution team, Oracle and third-Party Vendors, and other Business Groups in the development for project deliverables.
• Developed and executed an appropriate delivery team model (e.g., resources, skills, process management) to meet current and projected needs/constraints.
• Participated in the development and maintenance of an Oracle Enterprise Manager 13c as it related to the Oracle databases for graphical user interface.
• Ensured Oracle Application DBA team delivers on-time, on-budget, and high-quality.
• Developed an TEMPeffective resource planning process for the Oracle and SQL DBA team; providing headcount planning.
• Developed and implemented a strong Oracle DBA techniques and TEMPeffective methodologies.
• Participated in the maintenance of the various Oracle instances.
• Built strong analytical and problem-solving skills.
• Managed, and resolved Oracle SR's support system.
• Responsible for providing backend support for the development, testing and Production environments for Oracle and SQL databases as well as other new projects.
• Managed the deployments for Coding, Cloning, Refreshing, Patching, Backups, and Purges.
• Implemented RMAN for Cold and Hot backups and Recovery including Point in time recovery.
• FRA and Flashback Technology were implemented. Implemented Data Guard for backups.
• Security and Privacy of database: - Audit.
• Applied CPU and PSU patches.
• Managed Disaster recovery exercises.
• Implemented Oracle GlodenGate replication project on production databases for DR and replication purposes.
• Introduced advanced queuing in oracle 12c and 11g for the performance enhancement.
• Installed 12c and 11g Oracle Software Release 2 on their UNIX and Windows platforms.
• Extensive experience in the architecture of Data warehouse, VLDB (over 20 TB), OLTP, DSS and OLAP. Implemented ETL tools informatics and Ascential.
• Experienced in Oracle versions from Oracle 19c\18c\12c\11G\10g\9i\8i.
• Implemented the ticketing system to support Database system 24 by 7 and track the activities for Pro-active approach solutions.
• Upgraded 11g to 19c grid infrastructure and oracle databases with physical and transportable tablespaces.
• Successfully migrated X2, X3, X5 Exadata machines to X8 Exadata machine on 19c upgraded database versions.
• Worked with TDE and configured production databases.
• Upgraded 11g, 12c to 19c RAC having dataguard. Used physical, logical and using transportable tablespaces.
• Worked on Glodengate replication architectures and performance tuned the processes.
• Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects.
• Defined Outsource model across continents for rapid DB service requests.
• Managed team of DBA’s (infra structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, NOC, On-call support and performance optimization.
• High Availability: Implemented Data Guard (physical) for maximum protection, performance and availability.
• Involved in vital planning for infrastructure setup.
• Managed Rackspace database environment.
• Scheduled crontabs to automate jobs as required.
• Managed 13c OEM migration project.
• Managed on-call rotation for DBAs.
• Planned and built 8 nodes RAC cluster on Exadata X7 servers.
• Built excellent communication skills and customer relation.
• Built solutions on cloud AWS with oracle 19c databases.
• Worked with Horton work for Hadoop.
• Worked on Devops technologies and AWS cloud.
• Performed multiple AWS migrations on EC2, VPC, EBS, RDS installed O/S configured storage and installed oracle databases.
• Worked on python scripting for setting up email alerts and automating jobs using crontab.

Senior Oracle Database Administrator

Confidential, OK

Responsibilities:

• Installed 11g Oracle Software Release 2 on their UNIX and Windows platforms.
• Build 2 node RAC cluster on Linux.
• Upgrade databases from 10g to 11g R2
• Cloned Databases
• Used Oracle GlodenGate for Basic Data Replication.
• Worked on Uni-Direction GlodenGate setup.
• Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose
• Handled Administration, Backup & Recovery using Recovery Manager (RMAN) tool.
• Implemented Oracle 11g RAC within the Organization for various departments, Migrated existing single instance databases to RAC environment
• Extensively used Oracle 11gR2 new features Data Guard, Replication, automatic SGA tuning, enhanced RMAN with flash recovery area, Oracle data pump, Database Control, AWR, ADDM, SQL Tuning/Access Advisors, Flash Back Database and several others.
• Performance Tuning and monitoring statistics of production databases and doing capacity planning for database growth and load.
• Administered the database and its users through Oracle Enterprise Manager (OEM) Tool.
• Technically reviewed, developed, tested & documented all the batch scripts that update the database on their scheduled run in the UNIX CRON.
• Shouldered a project which dealt with documenting the data sources and the architecture of Oracle database.
• Developed UNIX Shell Scripts and modified the existing ones to meet the organizations specific requirements.
• Extensively worked on 11g Grid Control.
• Familiar with 12c Grid Control setup an implementation.
• Documented new procedures and added to SharePoint.
• Provided support to Development team in SQL tuning and database design.
• Worked in on-call rotation and provided off hours support to both production and non-production databases.
• Worked with UNIX, Firewall and storage team for DR migration.
• Installed and configured SQL Server 2000/2005 components.

Environment: Oracle DB 10g/11g R2 with RAC, RMAN, 12c Cloud Control, 11g Data Guard, TOAD

Senior Oracle DBA

Confidential, Ridgefield Park, NJ

Responsibilities:

• Installed Oracle Software 10g Release 2
• Created and designed database for new projects
• Provided 24/7 support for all production databases
• Database Cloning & Advanced Queuing Concepts
• Created shell scripts for automating various database tasks in UNIX platform
• Performance and Tuning of databases
• Creation and maintenance of standby databases
• Creating new users and manage roles and privileges
• Managing Rollback Segments, Redo logs, Control files, and Tablespaces.
• Developed and fine tuned PL/SQL & UNIX shell scripts that update the data warehouse on their scheduled run
• Generated reports in Oracle Reports 9i by analyzing the database based on the specific business requirements
• Installation and configuration of Oracle Database Software 10g.
• Creation and Configuration of Oracle database.
• Performed the Pre-migration task for RAC & Standalone Database.
• Extensively involved in Real Application Cluster (RAC) nodes 10g database migration
• Migration of database (from 9.2.0.5 to 10.2.0.1)
• Involved the Post-migration task (Unit-testing) for every RAC & Standalone servers migrated to Canada.
• Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management
• Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
• Involved in performance monitoring and tuning of the database by fine tuning the database implementation.
• Designed and Implemented database security using Oracle roles and privileges.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using Confio
• Managed Data Guard between Primary and Standby
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Successfully configured the databases to switchover, failover and fallback scenarios.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.
• UNIX Shell scripting for backup and monitoring of databases.
• Written scripts to automate repeated tasks

Environment: Oracle DB 9i/10g, Sun Solaris 10, AIX, Linux, Windows Server, RAC, 10g DATAGUARD, TOAD

Oracle DBA

Confidential, Ridgefield Park, NJ

Responsibilities:

• Install Databases using scripts
• Ran deployment scripts
• Installed Oracle client
• Installed OEM clients on Windows XP
• Worked on TNS networking issues
• Created users
• Setup backups via RMAN
• Created documents and put on SharePoint.
• Shadow Sr. DBAs to learn new topics in DBA word
• Created Database links
• Used export import to clone users
• Worked on grants, permissions, roles and user security.
• Used TOAD
• Used Putty, Secure CRT and exceed
• Unlock users
• Installed databases using DBCA.
• Good exposure on RAC clusters
• Learn how to manage databases using 11g Grid Control.
• Worked on Memory management
• Worked on Tablespace management.

Environment: Oracle DB 9i/10g, Sun Solaris 10, AIX, Linux, Windows Server, RAC, 10g DATAGUARD, TOAD