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) wif ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Performed teh 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 wif 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 teh basic, low, high compression methodologies.
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT,AWR, ADDM and Tuning of SGA, Distribution of disk me/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 teh 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, Gloden 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, Glodengate, 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 teh 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 teh database tier.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• Installing agent 12c on teh server. Adding high Available database wif CRS, scheduling Backups through OEM12c.
• Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High Availability, Gloden 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 wif respect to spaces, critical mount points, session waits, CPU and memory consumptions.
• Restoring and recovering teh data whenever demanded.
• Has performed re-organization of tables and indexes by identifying teh fragmentation.
• Performance tuning by SQL profiler, analyzing explain plans, AWR and creating indexes, gathering stats wherever required.
• Has good noledge of working for teh root cause of a problem/incident.
• Administering RAC databases using utilities like crsctl, srvctl, ocrconfig, etc.
• Well versed wif 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 wif 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 teh issues pertaining to ASM, database and listener.
• Has sound working noledge in database backups using exp/imp utilities and data pumps.
• Has worked wif configuring RMAN backups in our environment.
• Has good working noledge of UNIX commands, shell scripting and cronjobs scheduling.
• Has performed re-organization of tables and indexes by identifying teh 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 wif 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 wif 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 teh software and hardware requirements and act accordingly.
• As part of teh GDBA Support team we provided L2/L3 level support to teh application teams during high risk issues (escalations) and wifin 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 teh 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 teh applications
• Upgrading/migrating teh databases from lower version to higher versions. (9i-10g, 10g-11g,)
• Implementing Security features as specified by teh Client’s Security policy.
• Generating stats pack reports on regular basis to identify teh database performance at peak load
• Tuning teh SQL statement by analyzing teh explain plan and ADDM reports.
• Implement Business rules & Security.
• Reorganizing teh database objects by archiving teh data and moving teh tables wifin teh tablespace, rebuilding teh indexes.
• Migrating teh data from one database to teh other using Export / Import, EXPDP and IMPDP Utilities.
• Archiving teh data from teh tables and backing up teh archived data for teh 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 teh 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 teh backup of teh databases implementing backup strategies
• Performing Health check of teh databases.
• Refreshed Test, Development & Quality database wif Production
• Creating look alike accounts for teh database users.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Applied patches to overcome minor bugs based on teh feedback from oracle.
• Decommissioned databases from Unix and windows environments.
• Closely worked wif Oracle Corporation via SRs and OWC to resolve critical issues and unnon 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 teh 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 teh users.
• Worked on Audit test by truncating teh tables in teh 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 teh backup of teh databases implementing backup strategies
• Performing Health check of teh databases.
• Refreshed Test, Development & Quality database wif Production
• Creating look alike accounts for teh database users.
• Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
• Applied patches to overcome minor bugs based on teh feedback from oracle.
• Decommissioned databases from Unix and windows environments.
• Closely worked wif Oracle Corporation via SRs and OWC to resolve critical issues and unnon bugs on priority basis.
• Hands on experience in Amazon Web Services (AWS) provisioning and good noledge 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