SUMMARY:

• Senior Oracle DBA having 9+ years of REAL professional IT experience in Production Support
• Oracle Certified Professional in Oracle RDBMS 9i and 10g and 12c with 99% and 100% score.
• Awarded Best Employee by Tata Consultancy Services (TCS) for Northern Trust, Bank Project, Chicago, IL, USA.
• Understand and provide support to SQL Server and MYSQL databases.
• Good knowledge of Oracle Exadata architecture and Big data.
• Pursuing AWS Certified solution architect associate.
• Familiar with the cloud architecture, it’s benefits and layers(Cloud Controller, Walrus, Cluster Controller, Storage Controller, Node Controller).
• Understanding of cloud computing service models (IaaS, PaaS, and SaaS) and deployment models (Public, private & hybrid cloud).Understand the security aspects provided with cloud.
• Excellent knowledge of AWS services like S3, Glacier, EC2, EBS, ELB RDS, SQS, SNS, Autoscaling, CloudFormation, ElasticCache, CloudWatch and VPC.
• Involved in Installation, Configuration and Maintenance of Hyperion Shared services 11.x/9.x, Hyperion Essbase 11.x/9.x and Administration Services 11.x/9.x
• Experience in performing Essbase adminstrative tasks including managing application and database, essbase architecture, data and dimension loading, Calc scripts, business rules,User security and performance tunning.
• Proficient in a range of Hyperion products including PBCS and EPBCS, Hyperion Essbase, Essbase adminstrative services, Hyperion Planning, FDMEE, Hyperion Planning reporting and smart view.
• RAC: Expertise in the Installation of Oracle 10gR1, 11gR1/R2 and 12cR1/R2 on Oracle Enterprise Linux(5.8/6.2 64 - bit) using VMware Server starting from 1.0.6, 2.0.2 up to VMware Workstation 9.0.0 and 12.5.0.
• Expertise in up-gradation of GRID (Basic 10.2.0.1 upgraded to 10.2.0.5) for High availability (HA) as per the compatibility with 11gR1 RAC Databases on Linux 4.
• Disaster Recovery: Experience in creating a Data Guard (Physical Standby) for 10gR2 and 11gR1 (11.1.6.0) for Single instance/RAC Databases.
• Expertise in upgrading the 11gR1 RAC Databases from version 11.1.6.0 to 11.1.7.0 and 9i Databases to 10g/11g Databases.
• Have been involved in scheduling the RMAN Backup’s for of 10g and 11g individual/RAC Databases. Have understanding of archival, fast incremental and multi section backups.
• Worked on Active database duplication and Creating Catalog Database for storing Rman backups.
• Have Years of experience in enterprise wide Business Data Warehouse Designing, Data Mart, Installation, Configuration, Development and Performance Tuning.
• Good understanding of AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor) reports for monitoring the performance of Databases.
• Extensively used Explain Plan, ADDM, AWR, SQL Tuning Advisor, SQL Profile, SQL Plan management for resolving/improving performance of SQL queries and PL/SQL procedures.
• Understanding of enterprise wide Business Data Warehouse concepts/Design, Installation, Conf., Data Mart, ETL, Star and Snow Flake Schemas using Kimball and Inmon Methodology, Data Modeling using Normalization, Dimensional Data Modeling, FACT & Dimensions tables.
• Excellent knowledge and experience of Data Loading techniques/utilities like expdp/impdp, Golden gate and streams.
• Setup and managed Oracle Streams replication environment and Configuring Streams specific initialization parameters.
• Have experience in the installation and configuration of Golden Gate on 11gR2.
• Good Understanding of NetApp, Veritas Netbackup and SAN Storage Systems.
• Familiar with Oracle Business Intelligence Enterprise Edition, Business Intelligence Applications, and Informatica PowerCentre in data warehouse environment.
• Experienced in the Installation of EBS 11i, R12.2 on 32bit and 64bit Linux, etc.
• Experienced in Installation of BI EE 10gR3, OBI Applications 7.9.x, BI Publisher (XML Publisher), Informatica 7.x, 8.x.
• Recovery of database in event of database crash, disk / media failure etc.
• Monitoring of Database warnings and Backups through BMC Patrol and SQL BackTrack.
• Using DBArtisan, SQL Developer and Rapid SQL for Rapid Database management and navigation.
• Using Remedy software to track internal problems and customer-reported issues (Ticketing System) depending on the severity.

TECHNICAL SKILLS:

Operating Systems: Oracle Enterprise Linux 4/5/6, HP-UX, Sun Solaris 8, 9, Microsoft Windows XP/vista/7/8/10.

Databases: Oracle 9i/10g/11g/12c Databases(RAC), MySQL and SQL Server 2000/2005/2008 Databases, OLAP, OLTP, Relational and Dimensional Data Modeling, Data Warehouse Design.

Database Tools: Rapid SQL, SQL Developer, OUI, DBCA, DBUA, NETCA, OEM, RMAN, DBVERIFY, Oracle Net Manager/Configuration Assistant, SQL*Plus, Expdp/Impdp, SQL*Loader, Toad, ADDM EXPLAIN PLAN, AWR, EM Database Express, Grid Control, Database Control, Real-Time SQL Monitor, ASH.

Languages: C, C++, PL/SQL, Java, JavaScript, C, PERL, Unix Shell scripting.

Others: EMC Veritas Netbackup 6.X, Hyperion Shared services 11.x/9.x, Hyperion Essbase 11.x/9.x., IBM Cognos, Informatica 8.6.

Database Modeling:: Erwin 8, Toad 10, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Database Administrator.

Responsibilities:

• Provide DBA support for multiple large databases in production(24x7 with 99.99% uptime), development and test environments including 12c databases to end Users.
• Responsible for Designing & creating the databases on Production servers.
• Develop, install, maintain and monitor company databases in a high performance/high availability environment while supporting enterprise projects.
• Database expertise to include support for application development; batch processing, reporting, security, Data Warehouse and technical services.
• Ability to work in Oracle 12c (Multi-tenant) RAC environments for Enterprise applications and Enterprise Data Warehouse in a 24/7 production environment.
• Configured/created the virtual private catalog Prod DB in an existing recovery catalog database.
• And granting virtual private catalog specific priviledges to the user.
• Creating and altering FlashBack Data Archive and assigning them to tables.
• Help in scheduling the RMAN backups(Level 0 and Level 1) and customized other automated maintenance tasks like SQL Tunning Advisor task.
• Created partition tables for large tables with appropriate indexes.
• Generating ADDM reports, viewing ADR diagnostic data, package the incident and problem data and send it to oracle support using IPS.
• Sometime refreshing development/test database from production using Expdp/Impdp.
• Maintaining the Oracle 10g/11g RAC Databases.
• Making structural changes to the databases. Sizing database objects for effective space management and optimal performance.
• Using Golden gate for replicating data from production to downstream databases as well as for ETL boxes.
• Worked on the performance Tuning of SQL Queries/PL/SQL Procedures.
• Created database link to transfer application specific data.
• Performed other Oracle DBA responsibilities e.g. performance tuning, monitoring tablespaces, monitoring users, etc.

Environment: Oracle 10g/11g/12c RAC Databases on Linux 6.2. Oracle Enterprise Manager grid control, Remedy for ticketing system, Golden Gate etc.

Confidential

Sr. Oracle Database Administrator.

Responsibilities:

• Performed other Oracle DBA responsibilities e.g. performance tuning, monitoring tablespaces, monitoring users, etc.
• Development and design of database strategies, database products/tools integration, system monitoring, improving database performance, active capacity planning and management.
• Co-ordinating and applying Oracle patches and performing database upgrades Backup and recovery policies and procedures.
• Supporting database issues in production, including on-call support as needed.
• Planning and scheduling database backups using OEM and RMAN.
• Automating routine backup and monitoring tasks using Scheduler, Unixshell scripting, RMAN local/global stored scripts.
• Creating, configuring, and utilizing Recovery Manager Catalog.
• Installing patches and upgrades of Oracle database software.
• Data Refresh from Production to UAT and Development environments using RMAN Duplicate Database.
• Support multiple instances (Production, Test, and Development ) of Oracle 10g/11g/12c Databases.
• Support and implement high availability environment using Oracle Real Application Clustering, Data Guard, RMAN, Parallel Concurrent Processing, ASM, OEM, Diagnostics, Tuning, Configuration and Provisioning Pack.
• Ensure enterprise database environments are in optimal condition, manage production databases in Client environments, and support complex problem-solving challenges.
• Improve the quality and reduce defects in all database environments and Application server environments by providing performance and tuning.

Environment: Oracle 10g/11g RAC Databases Using OEM on Linux 5,6, Automatic Storage Management, SAN Storage System, Solaris 9/10.

Confidential, San Francisco, CA

Sr. Oracle Database Administrator

• Provided 24x7 Production Support to end Users.
• Maintaining 99.999% uptime as per the requirements of Service Level Agreement (SLA) with the clients.
• Working on many payment(Conversion) impacting applications.
• Upgraded Oracle databases from version 10.2.0.3 to 11.1.2.0.
• Using Streams for replicating data from production to downstream databases.
• Handling the Oracle 10g/11g Databases with RAC (4 nodes).
• Configuring Streams specific initialization parameters, creating Streams administrator, create seperate tablespace.
• Worked on the Performance Tuning of SQL Queries.
• Monitoring the performance of all Databases through Database Control / Grid Control.
• Using Remedy for handling the Problems (Ticket System) depends on severity.
• Refreshing development schemas from production schemas to ensure that the latest data is available in the development database.
• Using various tools like SQL Developer,Toad and SecurtCRT for easy Database management and navigation.
• Implemented Oracle Corp. recommended best practices resulting in error free, consistent & coherent service.
• Installed Oracle 11gR1 on REHL 5.
• Planned RMAN backups like full/incremental backups with the recovery methodology for the organization.
• Monitoring of Database warnings and Backups through BMC Patrol and OEM.

Environment: Oracle 10g/11g RAC Databases (Using Oracle Enterprise Manager) on Linux 5,6 ASM(Automatic Storage Management) on SAN Storage System, Solaris 9/10.

Confidential, San Jose, CA

Responsibilities:

• Providing 24x7 Production Support to end Users.
• Max. Database size working with is 25 TB.
• Maintaining High Availability for Mission Critical Payment impacting Application(s) and avoided possible revenue loss because of downtime.
• Maintaining 99.999% uptime as per the requirements of Service Level Agreement (SLA) with the clients.
• Working on many direct payment impacting applications, their wire on or wire off features.
• Working on bank completion projects and there isolated biweekly releases.
• Working on payflow migration, payflow schema changes and related isolated releases.
• Using Golden gate for replicating data from production to downstream databases as well as ETL boxes.
• Using Erwin 7.2.x for Data Warehouse Design.
• Working with Capacity team to estimate the additional space required for newly added tables and related objects.
• Handling the Oracle 9i/10g/11g Databases with RAC having 2 nodes.
• Using Pserv for handling the Ticket System depending on the severity/priority of the request.
• Using DB based wowo/throttle to control a feature wire-on. Feature is like Pending payment Completion or Unilateral payment completion etc.
• Created Jive Analytics database specially for reporting purpose.
• Created partition tables with indexes and granted privileges and collected fake statistics on them.
• Worked on the Performance Tuning of SQL Queries and PL/sql procedures.
• Refreshing development schemas from production schemas using Logical backup.
• Maintaining and creating application specific roles including all related privileges.
• Using various tools like SQL Developer and SecurtCRT for easy Database management and navigation.
• Closely worked with Informatica Team in order to resolved there performance related issues.Generated execution plan and created missing indexes to optimize queries and improve performance.
• Performed Extensive query Performance Tuning for SQLServer Databases; Enhanced application response time, saved system resources resulting in more transactions per second, increasing the profits/bottom line of the company.
• Also working with MySQL Databases, Query Browser, Migration Toolkit, and SQLYog.
• Working on physical standby’s(shared standby’s) and Disaster Recovery solutions.

Environment: Oracle 9i/10g/11g RAC Databases,OEM(Using Oracle Enterprise Manager) on Solaris 9/10, ASM(Automatic Storage Management) on SAN Storage System, GoldenGate 9.0.2.43,SQLServer 2005, MYSQL 5.0, Erwin 7.2.

Confidential, Los Angeles, CA

Responsibilities:

• Implemented Clusterware and 11gR1 (11.1.6.0) RAC on Red Hat Enterprise Linux 5.2 with Automatic Storage Management (ASM) for High Availability to avoid downtime.
• Installation of Grid Control on remote server to monitor all including targets/Databases.
• Worked on Disaster Recovery Solution by creating a Physical Standby (Active Data Guard) on remote Server in Dallas for the Critical Production environment to avoid impact on Business.
• Build up a Production Data Warehouse with appropriate Star schema and Materialized views for the ease of Cognos Reporting to make reports more understandable for management.
• Used Erwin 7.2.x for Data Warehouse Design.
• Setup the RMAN Full and Incremental Backup for all Databases. Good understanding of Maintenance of FLASH RECOVERY AREA.
• Used streams for table replication from primary to replica database.
• Configuring Streams specific initialization parameters, creating Streams administrator, create seperate tablespace, configuring tnsnames.ora at source and destination Databases.
• Provided 24x7 Production Support to end Users.
• Worked on the Performance Tuning of SQL Queries.
• Monitoring the performance of all Databases through Database Control as well as Grid Control.
• Using BMC Service Desk Express for handling the Problems (Ticket System) depends on severity.
• Refreshing development schemas from production schemas using Exp/Imp to ensure that the latest data is available in the development database.
• Maintaining and creating application specific roles including all related privileges.
• Created application specific DATA and INDEX tablespaces and maintaining the quotas as per demand.
• Moving of Datafiles from one ASM Disk Group to another ASM Disk Group.
• Used various tools like SQL Developer and DB Artisan for easy Database management and navigation.
• Maintained High Availability for Mission Critical Application(s), avoided possible revenue loss because of downtime, achieved maximum uptime in the history of the Mission Critical Application.
• Performed Extensive Performance Tuning; Enhanced application response time, saved system resources resulting in more transactions per second, increasing the profits/bottom line of the company.
• Implemented Oracle Corp. recommended best practices resulting in error free, consistent & coherent service.
• Installed Oracle 11gR1 on REHL 5 by using VMware Server 2.0.2.

Environment: Oracle 10g/11g RAC Databases (Using Oracle Enterprise Manager) on Linux 4/5, ASM(Automatic Storage Management) on SAN Storage System, Oracle clusterware, MYSQL 5.0, GoldenGate 9.0, Erwin 7.2, VMware Server 2.0.2.

Confidential, Pasadena, CA

Sr. Oracle DBA

• Worked on Legacy systems (for Production and Development Databases).
• Responsible for Designing & Creating the databases on Production and development servers.
• Using Remedy for handling the Problem (Ticket System) depends on severity.
• Used tools like Rapid SQL and SQL Developer for Rapid database management and navigation
• Worked on Performance Tuning of SQL Queries (Reporting queries).
• Handled the Oracle Databases 10g/11g R2 on Real Application Cluster having 3 nodes.
• Data Refresh/Replication as per Development team requirement.
• Provided 24x7 Production Support for Oracle OLTP and OLAP Databases with 99% uptime.
• Worked with Oracle Business Intelligence Enterprise Edition, Business Intelligence Applications, and Informatica PowerCentre in data warehouse environment.
• Refreshing development/test database from production using Export/Import to ensure that the latest data is available in the development/test database.
• Created staging and reporting tables their indexes, primary keys and related views.
• Planned database backups like full/incremental and logical backups with the recovery methodology for the organization.
• Actively involved in Relational Data Modeling, Dimensional Data Modeling, FACT & Dimensions tables design with Physical & Logical Data Modeling.

Environment: Oracle 10g/11g RAC, OEM, HP AIX Solaris 8/9, Linux 5,6.

Northern Trust Bank

Oracle Database Administrator

Responsibilities:

• Provided 24x7 Production Support to end users.
• Managing tablespace and datafiles (creating & dropping tablespaces & adding dropping renaming/ relocating data files).
• Handling the Oracle Databases 10g R2 on Real Application Cluster having 4 nodes.
• Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.
• Actively involved in Relational Data Modeling, Dimensional Data Modeling, and FACT and Dimensions tables design with Physical & Logical Data Modeling.
• Taking preventive maintenance of the database & checking user quotas & allocating whenever required.
• Setup and managed Oracle Streams replication environment for copying the table from primary to target database.
• Extensively used SQL Trace, SQL*Loader, Explain Plan, ADDM, AWR for Performance Tuning.
• Worked extensively on performance tuning of PL/SQL Procedure.
• Worked on SQL Query Optimization by creating appropriate indexes, including hints and analyze table and indexes.
• Monitoring of Database warnings and Backups through BMC Patrol and SQL BackTrack, Rapid SQL for Rapid database management and navigation.

Environment: Oracle 10g/11g(RAC), Sun Solaris 8/9, Linux 4/5, OEM, SQL Server 2005.

Confidential

Database and UNIX Administrator

Responsibilities:

• Created Databases in Production and development environment.
• Design Database Backup Strategy and Implementation.
• Available 24 X 7 to support. Handling Remote administration also.
• Simulated and Tested Complete Recovery and Point-in-time recovery.
• Database Performance Monitoring and Tuning.
• Using Remedy for handling the Problem (Ticket System) depends on severity.
• Planned System Security and user security policy and implemented them. Created users and roles as per applications security requirement.
• Created database link between two databases to access the table data from one local database to remote database.
• Upgrading an Oracle 9.x databases to 10.x. on Sun Solaris 8 and windows Server 2003.
• Implemented table partitioning to improve performance and data management.
• Performed SQL tuning by using Explain Plan and Tkprof.

Environment: Oracle 9i/10g/11g, Linux 5, Sun Solaris 8/9, DB2, SQL, Server 2003.