SUMMARY

• Over 15 years of experience as Oracle Database Administrator. To obtain a consulting/full time position as a IT professional in Database Administration, Replication, Deployment, Data Analysis, Configuration, troubleshooting, Performance Tuning, Development support and testing of Client.
• Wide range of domain experience primarily in Telecommunication, Healthcare and Finance in E - Commerce area. Experienced in Oracle 9i/10g/11g/12c/19c on Windows NT, Sun Solaris 2.X, HP-UX 10.10, Linux 5.7, 6.2.,7, AWS Azure Cloud, Python scripting has Sound Knowledge
• Database Administration, Database Backup &Recovery, Database Network Administration, Data replication, Database Design and database programming (PL/SQL) both in development and maintenance. migration, AWS DMS, AWS KMS, AWS IAM, AWS ADG, AWS RAC, AWS RDS, AWS EC2 and documentation.
• Proficient in supporting databases running on AIX, O.E.L, R.H.E.L, Sun-Solaris and windows platforms.
• Experience in Installation, Configuration and Monitoring of Oracle Server on UNIX, Linux, AIX and Windows Environments.
• Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Performed the 12c Upgrade of RAC cluster ware from 11g.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Configure high availability systems like Data Guard and RAC environments.
• Installed and Administered Oracle 12c, 11g ASM & 10g RAC with ASM & Oracle Clustureware File System(OCFS2).
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Data guard.
• Configured multiple database instances using a single ASM instance.
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control(OEM Grid).
• Experience in Implementing BACKUP and RECOVERY strategies using RMAN.
• Installation and configuration of Recovery Catalog for multiple Database
• Replicated tables using single extract/pump/replicate process, performed many to one replication.
• Having good experience in EXADATA, Storage Loader and Smart Scan.
• Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA and the basic, low, high compression methodologies.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT,AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Attended Developer’s code review meetings and made recommendations to improve Efficiencies.
• Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Applying PSU Patches and interim patches whenever required to make the database software up to date.
• Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, Erwin Data modelling, OLAP, Oracle Data Dictionary - metadata, Logical and Physical Database Design.
• Written shell scripts to monitor Oracle services, Golden Gate processes, to upgrade databases from 10g to 11g, to automate startup /shutdown of Oracle database, to migrate database from one server to another.
• Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views etc
• Worked on AWS DMS for Migrating Oracle databases.

TECHNICAL SKILLS

Operating System: HP-UX, SUN SOLARIS, IBM AIX, RHEL,AWS,Azure,Windows Server 2003/2008/2012

Database: AWS Cloud, Azure, Oracle 9i/10g/11g/ 12c,19c SQL&PL/SQL My SQL,MSSql

Application/WebServer: Oracle 10g Application Server,Weblogic

Script: Unix shell scripting and PERL

Tools: & Utilities: RDS,EWS, Cloud Watch,PL/SQL Developer, Toad, ERWIN, Data Pump, Export/Import, RMAN, HP Open View Data Protector, OEM Grid Control, Goldengate, Servicenow, Jira and SQL Server Management Studio

Languages: Sql, PL Sql, Unix shell scripting

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM, SQLT, SQL TUNING ADVISOR

PROFESSIONAL EXPERIENCE

Confidential, Nashville

Oracle DBA Administartor

Responsibilities:

• Install and maintain the performance of database servers. Develop processes for optimizing database security.
• Set and maintain database standards.
• Manage database access.
• Performance tuning of database systems. Install, upgrade, and manage database applications.
• Diagnose and troubleshoot database errors.
• Recommend and implement emerging database technologies.
• Create and manage database reports, visualizations, and dashboards. Create automation for repeating database tasks.
• Be available for on-call support as needed
• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Clusterware, Oracle 12c two node RAC for the database tier.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• Installing agent 12c on the server. Adding high Available database with CRS, scheduling Backups through OEM12c.
• Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High Availability, Golden Gate Technologies.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Implemented Fast Start Fail Over (FSFO) using Data Guard Broker in Production Environment. Responsible for Implementation of Oracle 11g R1 Grid Control and configured nodes for proactive monitoring and auditing.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Advisor).
• Worked on implementing Advanced Security for PHI/PII data. Hands on experience in building new Encryption Keys to protect PHI/PII data in production environment.

Environment: Oracle Database 19c/12c/11gR2/10g, Red Hat Linux, UNIX, OEM Grid Control, RAC, ASM, Amazon Webservices (AWS), OEM 13c, ERP, Oracle Advanced Security

Confidential, OH

Oracle DBA Administarator

Responsibilities:

• 24*7 production Support for mission critical production systems
• Performing health check of databases with respect to spaces, critical mount points, session waits, CPU and memory consumptions.
• Restoring and recovering the data whenever demanded.
• Have performed re-organization of tables and indexes by identifying the fragmentation.
• Performance tuning by SQL profiler, analyzing explain plans, AWR and creating indexes, gathering stats wherever required.
• Have good knowledge of working for the root cause of a problem/incident.
• Administering RAC databases using utilities like crsctl, srvctl, ocrconfig, etc.
• Well versed with adding disks in ASM and tablespace management in ASM.
• Installing, configuring Oracle 10g and 11g databases in single node and RAC setup on different flavors of UNIX
• Hands on experience in providing Oracle Net traffic encryption among databases and application servers using Oracle Advanced Security utility.
• Worked on AES (Advanced Encryption Standard) for protecting Oracle Network Traffic Services.
• Hands on experience in using MMIS tool for all upgrades on application servers.
• Worked on configuring and installing Oracle Security features in MMIS.
• Hands on experience in Data Import/Export and backup using fullfile Import/Export using MMIS. Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c. Implemented Data Guard with maximum availability and performance configurations for production databases.

Environment: Oracle Database 9i/10g/11g, HP-UX/PA RISC, SUN Solaris & RHEL, TOAD, OEM, PUTTY, AWR &ASH

Confidential, Wilmington

Oracle DBA Administrator

Responsibilities:

• Installing, configuring Oracle 10g and 11g databases in single node and RAC setup on different flavors of UNIX.
• Troubleshooting the issues pertaining to ASM, database and listener.
• Have sound working knowledge in database backups using exp/imp utilities and data pumps.
• Have worked with configuring RMAN backups in our environment.
• Have good working knowledge of UNIX commands, shell scripting and cronjobs scheduling.
• Have performed re-organization of tables and indexes by identifying the fragmentation.
• Performance tuning by SQL profiler, analyzing explain plans, AWR and creating indexes, gathering stats wherever required.
• Administering RAC databases using utilities like crsctl, srvctl, ocrconfig, etc. Well versed with adding disks in ASM and tablespace management in ASM.
• Huge archival and restorations done through export and import utilities.
• Monitored database systems through 10g, 11g and 12c Oracle Enterprise Manager
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c. Implemented Data Guard with maximum availability and performance configurations for production databases.
• Performance tuning of oracle databases using Sql Access Advisor, Sql Performance Analyzer, sql Tuning Advisor.
• Upgraded oracle 10g databases to oracle 11g R1 (11.1.0.6, 11.1.0.7) and 11g R2 (11.2.0.2).
• Upgraded oracle RAC databases from 10g to 11g.
• Hands on experience in Cross Platform migration from Unix 10g to Linux 12c databases.
• Worked on migrating databases from windows platform to Linux platform.
• Hands on experience in Oracle Fusion Migration from Oracle 9i to 11g and 12c Fusion databases. Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.
• As part of the GDBA Support team we provided L2/L3 level support to the application teams during high risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments.
• Implemented Oracle Transparent Data Encryption (TDE) Oracle backups. Worked on wallet and TDE (transparent data encryption) for encrypting the sensitive data, using column encryption and tablespace encryption

Environment: HP-UX B11.11, Red Hat Linux Languages: SQL, PL/SQL, VB, JAVA, Unix Shell Programming, AWK, PERL, Forms 3.0/4.5/6i.Database: Oracle 10g RAC

Confidential, Georgia, GA

Oracle DBA Administrator

Responsibilities:

• 24*7 production Support for mission critical production systems
• Installation of Oracle 9i/10g and 11g database creation
• Installation of 10g Application servers and deployment of the applications
• Upgrading/migrating the databases from lower version to higher versions. (9i-10g, 10g-11g,)
• Implementing Security features as specified by the Client’s Security policy.
• Generating stats pack reports on regular basis to identify the database performance at peak load
• Tuning the SQL statement by analyzing the explain plan and ADDM reports.
• Implement Business rules & Security.
• Reorganizing the database objects by archiving the data and moving the tables within the tablespace, rebuilding the indexes.
• Migrating the data from one database to the other using Export / Import, EXPDP and IMPDP Utilities.
• Archiving the data from the tables and backing up the archived data for the Business requirement.
• Worked on Transparent Data Encryption for specific columns in Logical Standby. Configure Oracle Advanced Security to implement Transparent Data Encryption at table space, table and column levels. Also configured Redaction using OEM's Policy expression builder.
• Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes.
• Worked on AWS Oracle databases for App migration into private cloud.
• Worked on AWS Database Migration Services for migrating data from Oracle to RDS. Hands on experience in Implementing DataGuard High Availability Environment on RDS Oracle Databases.
• Worked on Configuring and installation of DataGuard Broker on AWS Servers. Worked on configuring and installing Data Guard Broker and implemented FSFO in Higher Environment.
• Supported Main DBA functions in RDS and documenting in confluence page

Environment: . Oracle Database 9i/10g/11g, oracle 12c/11gR2/10g, Red Hat Linux, UNIX, OEM Grid Control, RAC, ASM, Amazon Webservices (AWS), OEM 13c, ERP, Oracle Advanced Security

Confidential

Oracle Database Administrator

Responsibilities:

• Managed database space related issues
• Monitoring and Handling data guard related issues.
• Performed switch over and failover of data guard.
• Managed the backup of the databases implementing backup strategies
• Performing Health check of the databases.
• Refreshed Test, Development & Quality database with Production
• Creating look alike accounts for the database users.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Applied patches to overcome minor bugs based on the feedback from oracle.
• Decommissioned databases from Unix and windows environments.
• Closely worked with Oracle Corporation via SRs and OWC to resolve critical issues and unknown bugs on priority basis.
• Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes.
• Worked on AWS Oracle databases for App migration into private cloud.
• Worked on AWS Database Migration Services for migrating data from Oracle to RDS. Hands on experience in Implementing DataGuard High Availability Environment on RDS Oracle Databases.
• Worked on Configuring and installation of DataGuard Broker on AWS Servers. Worked on configuring and installing Data Guard Broker and implemented FSFO in Higher Environment.
• Supported Main DBA functions in RDS and documenting in confluence page.
• Worked on Developing a Lambda Function script for copying Audit files to S3 buckets.
• Developed a shell script for Audit enable/disable on RDS Oracle Tables in multiple databases.
• Worked on documenting Audit functions into confluence page.
• Published RDS capabilities and limitations documentation into confluence page.
• Worked on FGA for new RDS Oracle databases and created IAM policies to the users.
• Worked on Audit test by truncating the tables in the Oracle database and validated results.
• Supporting High Availability Environment and monitoring those databases for performance tun

Environment: Oracle Database 9i/10g/11g, HP-UX/PA RISC, SUN Solaris & RHEL, TOAD, OEM, PUTTY, AWR &ASH

Confidential

Oracle Database Administrator

Responsibilities:

• Performed switch over and failover of data guard.
• Managed the backup of the databases implementing backup strategies
• Performing Health check of the databases.
• Refreshed Test, Development & Quality database with Production
• Creating look alike accounts for the database users.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Applied patches to overcome minor bugs based on the feedback from oracle.
• Decommissioned databases from Unix and windows environments.
• Closely worked with Oracle Corporation via SRs and OWC to resolve critical issues and unknown bugs on priority basis.
• Hands on experience in Amazon Web Services (AWS) provisioning and good knowledge of AWS services like EC2, S3, Elastic Beanstalk, ELB (Load Balancers), RDS, VPC, Direct Connect, Route53, Cloud Watch,Cloud Formation, IAM, SNS etc.
• Configured and installed, involved using AWS services such as EC2, Data Pipeline, S3, RDS and EMR.Architecting new DBA solutions in AWS.
• Provide domain expertise of open-source and commercial relational DBMS products and services
• (Oracle 11g/12c, SQL Server, PostgreSQL, AWS RDS) and NoSQL databases (e.g. MongoDB, Cassandra)

Environment: HP-UX B11.11, Red Hat Linux Languages: SQL, PL/SQL, VB, JAVA, Unix Shell Programming, AWK, PERL, Forms 3.0/4.5/6i.Database: Oracle 10g RAC