SUMMARY

• Over all 11 years of IT experience as a Oracle Database Administrator providing 24/7 production and development support of Oracle 12c, 11g RAC,10g RAC
• Expertise and migrating data bases from premise to AWS RDS and EC2 using DMS
• Upgraded CRS home and RDBMS home to 19c and supporting 19c database.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Wide experience in infrastructure layout, provisioning. Experience in Amazon AWS cloud infrastructure with particular reference to provisioning, security, and management.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP - UX, AIX, Red Hat Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database(Data Guard), Materialized views, Streams Replication, Golden Gate.
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modeling.
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.
• Worked on multiple nodes in clustered Solaris, Linux, AIX environments on RAC with ASM.
• Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Years of extensive hands on experience with designing, building and automating cloud infrastructures on Amazon Web Services also familiar with Windows Azure and Open Stack.
• Excellent knowledge of Amazon EC2, S3, VPC, RDS, Elastic Load Balancing, Autoscaling, IAM, SQS, security groups, Lambda, Cloud Watch and other AWS services.
• Experience with Monitoring tools such as Cloud Watch, solarwinds, Splunk and Nagios.
• Extensive experience with data center infrastructure, automation initiatives, web site migrations and network migrations.
• Well-versed in DevOps principles and Agile software development practices.
• Hands on experience on development of utilities using Shell, Powershell, Python and Ruby scripting to automate processes.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS.
• Worked on different types of storage structures (SAN/NAS).
• Extensive hands-on experience with Oracle Database Administration Oracle Application Server.

TECHNICAL SKILLS

SOFTWARE and UTILITIES: Amazon AWS, RDS, EC2, Oracle 12c,11g/10g/ Oracle Golden Gate, Oracle Data Guard, Oracle Developer Suite ( Forms and Reports) 6/10g, Oracle Application Server 10g, RMAN, TOAD, PL/SQL, Windows, Oracle Enterprise Linux, Red Hat Linux, Sun Solaris.

HARDWARE, SERVERS AND NETWORKS: Windows Server, Oracle Enterprise Linux, Red Hat Linux, UNIX, Sun Solaris, VMware.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

• Migrating on-premise database to cloud infrastructure using Oracle Golden Gate
• Involved in Design and implementation of oracle 11g Data Guard both physical/logical Standby databases for high availability and disaster recovery.
• Database design, database systems design, architect the full SDLC complaint database infrastructure. Provisioned servers, involved in setting up VPNs, VPCs, and provisioned database servers include RDS instances. Established Standards of Operating Procedures to migrate, and manage applications to cloud. Established security policies in the AWS cloud. Provided disaster recovery processes in the hybrid and public cloud
• Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC, Standby Database (Active Data Guard), Replication.
• Responsible for Installation of RAC and Managing RAC Environment efficiently
• Migrated on-premise databases to Amazon cloud RDS and EC2 instances.
• Upgrade and Migration of Databases from 11g to 12c and from 10g to 11g and applying patches whenever required.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c
• Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views & Query Re-Write.
• Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.
• Implemented classic Golden gate replication as well as integrated replication. Implementing and maintaining database security (create and maintain users, roles and assign privileges)
• Monitored the Applications and database using OEM.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Built 2 node RAC 11gr2 Standby database and set up DG Broker
• Setup of High Availability of the database using RAC, Standby, Data guard.
• DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and troubleshooting performance issues.
• Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases
• Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in a production environment via Kornshell scripting.
• As part of a team, responsible for the maintenance of MySQL and MongoDB.

Environment: Amazon Cloud, RDS, EC2, ORACLE,SQL*Plus,OEM/12c/13c, Oracle 12c,11g/10g,RAC, Golden gate, Red Hat Linux 5,Solaris 10/11,Unix, Oracle Enterprise Manager, Data guard, ASM, RMAN, Toad

Confidential

Oracle DBA

Responsibilities:

• Worked with Interns in installing Oracle database server on the UNIX and LINUX platforms
• Help in creating/opening cases and closing them when the issue is resolve.
• Learned how to use Solarwinds for monitoring database components
• Assisted in generating standard of operation manuals for the entire organization
• Assisted in the design of backup and recovery program for this organization
• Trained interns in installing and configuring Oracle ASM and RAC
• Assisted in configuring Red Hat file servers and other Linux appliances for this client
• Provided technical direction, development, training and mentoring to team members and clients as needed
• Assisted in writing technical manuals for on-site Linux and Oracle Administrators
• Developed hardware requirements specification and assisted in other sizing activities
• Part of a team that planned, designed and implemented multi-terabyte database warehouse migration effort from one data center to another. This effort included same platform migration as well as cross platform migrations
• Practical experience using Oracle technologies like Datapump, transient logical standby, RMAN duplication, transportable tablespaces as well as transportable database to migrate different oracle database versions across data centers.
• When necessary, I restructure Oracle RAC configuration by adding and or removing nodes to take advantage of scalability and high availability of Oracle’s RAC architecture
• Daily interaction, exposure and understanding of different types of Oracle database queries - DDL, DML, DCL, TCL. Also have broad working knowledge of Oracle PLSQL language.