SUMMARY

• Oracle database 19c, 18c, 12c, 11g, 10g, 9i, 8i and 7 administration including creating, upgrading, and migration on Linux, Solaris and Windows as well as configuring and administrating Oracle ASM and Grid Infrastructure
• Knowledge of Oracle 12c new features, including multitenant architecture
• Oracle backup and recovery using RMAN on disk and tape, creating Recovery Catalog and creating duplicate databases for non - production purposes and experience of FLASHBACK technology
• Oracle database performance tuning, SQL tuning and monitoring using EM and diagnostics reports
• Installing Oracle patch sets and upgrading Oracle databases
• Knowledge of creating and managing Oracle databases on virtual environments
• Ability to work in challenging environments and to provide support 24x7 as part of a rotation
• Extensive experience in Database design, Implementation, support & administration,
• Problem Solving, Data Gathering / Analysis, Translation of Business Requirements, and
• Experience in Installation and Administration of Oracle Real Application Clusters 9i, 10g, 11g and 12c.
• Working knowledge of installation and administration of Exadata engineered systems
• Working knowledge ofAWS technologiesEC2, S3, VPC, IAM, EBS, ELB, RDS

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Senior Oracle DBA

Responsibilities:

• Built new servers for Grid Infrastructure and Oracle installations. Configured and Installed GI and Oracle 12c Standalone and RAC databases. Implemented Dataguard for the same.
• Migrated Oracle Databases between data centers using Active Dataguard technology.
• Implemented auto refresh database procedures using rman.
• Upgraded container and pluggable databases from 12.1 to 12.2
• Installed and configured OEM13c and migrated targets from OEM 12c to OEM 13c. Configured new targets and alerts.
• Supported different projects from DBA standpoint.
• Provided 24/7 production support.

Confidential

Oracle/Sql Server DBA Consultant

Responsibilities:

• Configured Online RMAN backups for Oracle databases. Recommended Sql Server best practices for better performance and availability. Created new Oracle VMs for QA and Testing. Trained team members to manage Oracle Databases.

Confidential

Project Lead / Senior Oracle DBA

Responsibilities:

• Lead a team of 5 DBAs working 24/7 who delivered a time critical multi million dollars IFRS project. Involved in Design, Architect, Development and delivering the solution from Oracle perspective which include but not limited to creation of multi nodes Oracle RAC Databases 12c, Active DataGuard Setup, Snapshot Standby Databases for incident management, Golden Gate Replication.
• As IFRS project was mostly about Data Transformation and Reconciliation transferred/moved almost Peta Bytes (1000TB) of data using Oracle utilities to provide different teams with the required data.
• Worked with different Project teams as an Oracle SME DBA for migrating Oracle Databases from Aix/HP Unix to Oracle Exadata 12c environment using Expdp/Impdp, Golden Gate, ODI etc.
• Lead to implement complete database Project life cycle migrating various sources in to a homogenous/centralized Database from POC -> DEV-> UAT -> PROD.
• Acted as a main lead to design implementation, test- cases, and impact documents for the migration Projects.
• Architect and design Zero downtime/ 99.9% uptime Oracle Database environment, provided highly available and complete load balancing solution for highly sensitive application.
• Oversee and manage team of DBA’s for day to day production issues and ticket delegation. Distribute and managed available DBA resources based on the availability and support requirements.
• Act as a 3rd level and SME support resource for all the Production database related issues.
• Act as a SME to identify, resolve and prepare RCA (root cause analysis) reports for major Production performance incidents.
• Working with Developers to Analyze, Tune and Refine SQL statements and applications.
• Lead for Database audit process, highly experienced to proactively setting up database environment to comply with external audit policies

Confidential

Senior Oracle DBA / Team Lead offshore DBAs

Responsibilities:

• Working in a team of 8 DBA’s as a Lead for 6 offshore DBAs.
• Worked on Latin America Migration Project which includes Analysis of current enterprise application environment and hosting infrastructure in ITLA and implementation of a new commodity hardware based and consolidated environment in Ashburn, VA based on current LNA standards.
• Migration of data from current ITLA systems (JDE, Cognos, Maximo, Web Methods, Intranet Reports) into new environment hosted in Ashburn, VA.
• Support plan for replacement of knowledge and support, change management, project management and system administration functions performed by current ITLA staff
• Involved in Production Support DBA activities and provided 24x7 on-call support in rotating shift for highly intensive environment with more then 300 oracle instances with over 100+ Production Databases (OLTP/DWS) on HP/Linux/NT/W2k. Sizes Ranging from 10GB to 12TB.
• Involved in GL Migration project as a single resource where multi terabyte 9i database was moved from Oracle Financials on HP UNIX to 10g Cluster database on Linux.
• Performed several database upgrades from 8i to 9i/10g and from 9i to 10g.
• Installed, Configured and Maintained 9i - 10g Dataguard / Standby databases.
• Involved in ERP upgrade (from oracle 9i to 10g) as a secondary resource to the project and performed upgrade of about 12 Tera Byte database and all application related (JDEdward) servers.
• Implemented backup-recovery strategy for ERP as a part of this project and for other databases on HP and Linux using Data Protector and Networker.
• Performed storage migrations for various Oracle databases across SAN (from XP-9000 to XP-12K and CX380).
• Working on Consolidation and Migration of Oracle 8.1.7.4 databases from True 64 to Oracle 11G on Oracle Enterprise Linux 5.6.
• Provided proof of concept for Oracle Database Appliance X4-2
• Working on Upgrade and Migration of databases for BI DW and ETL ranging from 10 GB to 1 TB databases from HP-Unix to Oracle 10G on Oracle Enterprise Linux 5.6 .

Confidential

Database Administrator

Responsibilities:

• Providing 24/7 Support on over 100+ Production Databases (OLTP/DWS), on Sun Solaris/NT/W2k. Sizes Ranging from 10GB to 800GB.
• Co-coordinating Production rollout activities of Database Projects and Maintenance.
• Installed, Configured and Maintained Oracle RDBMS 8i-10g and Oracle Application Server 9ias.
• Installed, Configured and Maintained 9i - 10g Dataguard / Standby databases.
• Migration from 8i to /9i/10g on Sun Solaris Platform.
• Helping users to test Application in order to define a bug free Migration Strategy.
• Working with Unix Administrators to design, optimize and architect new and existing Database configurations.
• Working with SAN (storage area network) administrators to identify IO bottlenecks and to distribute/balance IO across disks.
• Working closely with Informatica ETL developers to covert and load 2.2 million claims into Oracle databases from different sources like AS 400, mainframe, DB2, SqlServer and text files.
• Implemented Read Only Snapshot Replication (Materialized Views).
• Implementing policies/processes of Technology security to create new and existing Users, Roles, Quotas and to monitor, control access to database.
• Working with technology security to audit Database user access.
• Using Oracle Enterprise Manager and Big Brother for monitoring and performing day to day activities on the database.
• Working with Developers to Analyze, Tune and Refine SQL statements and applications.
• Restoring database after a crash, with the help of available backups with minimum down time.
• Maintain a restore exercise on a regular basis to check the validity of backups.
• Doing point in time recoveries for audit of historical data as required by finance and legal departments.
• Designing backup strategies of cold, hot and logical backups using RMAN, conventional and export/import utilities depending upon client requirements.

Confidential, Florida

Database Administrator

Responsibilities:

• Involved in implementation of 9i RAC on Linux.
• Involved in moving data centre from AIX to Linux.
• Implemented, tested and documented backup and restore procedures using RMAN on 9i RAC.
• Applied patches for Oracle software upgrade from 9.2.0.1 to 9.2.0.2/3/4/5. On 9i RAC on Linux and databases on AIX.
• Wrote packages and procedures for gathering data in case of rollback.
• Refreshed databases from dev to UAT and prod to UAT for testing.
• Moved packages and objects into production.

Confidential

Database Administrator

Responsibilities:

• Assisted Oracle Applications upgrade from 11.03 to 11i (11.5.8).
• Performing applications DBA and Sys Admin duties which include creating users, responsibilities, setting up printers, applying patches, cloning and resolving performance tuning issues after the upgrade.
• Working closely with Users and Oracle technical support to resolve issues after the upgrade.
• Upgraded 8i databases to Oracle 9i (9.0.2)
• Performing daily routine DBA activities.

Confidential

Database Administrator

Responsibilities:

• Migration from 7.3.4 to 8.1.7.2 /9.0.2 on NT, AIX and Red Hat Linux Platforms.
• Helping users to test Application in order to define a bug free Migration Strategy.
• Application and Performance tuning to improve transaction/second response time.
• Implemented Read Only Snapshot Replication (Materialized Views).
• Capacity planning to forecast Database Growth.
• Designed and Implemented Disaster Recovery strategies using Standby Database.