SUMMARY

• A Certified Oracle Professional (OCP) wif 14 yrs. of experience in analyzing, planning, developing, implementing, testing, maintaining and administrating Oracle OLTP databases.
• Strong noledge over oracle basic concepts and new features.
• In - depth noledge and understanding of Database.
• In-depth noledge and understanding of Database Installation, Support, Development, Implementation, User management, Backup, Recovery and Performance Tuning in all database environments.
• Hands on experience on AWS cloud services like, EC2 instances, S3 buckets, IAM, security groups, VPC, EBS, SNS, Cloud Watch and snapshots volumes.
• Hands on experience on Microsoft Azure Cloud, Creating VM’ Confidential, storage accounts, containers private end points.
• Having noledge of Azure Storage Accounts, Key Vaults and Blob fuse mount points.
• Azure VNET peering
• Building POC infrastructure on AZURE and AWS for both application server and database server to run and test connectivity before cutover.
• Worked on SQL SERVER migrations from On-perm to Azure SQL MI PAAS AND IAAS.
• Worked on Linked servers to connect from Azure cloud to on-perm.
• Created RDS databases on AWS cloud.
• Auditing Database for daily suspicious activities.
• Managed databases (including production and non-production environments) from 100 GB to > 16 TB in size.
• Excellent Administration skills in handling RAC databases.
• Involved in extensive Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environments.
• Bring to the Company, technical expertise, strong and problem solving, effective communication and coordination between all stakeholders, which will facilitate in achieving the corporate goal.
• Developed, implemented and managed database backup and recovery procedures using OS Level, RMAN.
• Strong communication and team skills wif proven ability to work on projects wif minimum guidance and specifications.

TECHNICAL SKILLS

Operating Systems: Linux, Solaris, Unix Windows 200/2003/XP/2019

Database: Oracle 9i/10g/11g RAC/11g, R12.1, 11i, 10gRAC, RDBMS, Oracle12c and Oracle 19c

Tools: & Utilities: RMAN, OEM 12c/13c, SQL* Loader, SQL Server, OEM Grid Control, SQL* Plus, DBCA, Import/Export, Data Pump, Toad for Oracle, Sybase ASE 15,12.5

Programming Languages: SQL, PL/SQL, Linux, Unix, Shell Scripting,, VB scripting, C++, VC++

Office Tools: Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

Other Tools: VMware, Symantec Scheduler, Remote Desktop, Lotus Notes, Back office automation Tools

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA/AWS/AZURE Cloud

Responsibilities:

• Experienced on Migration strategies for database migration to Cloud on both AZURE and AWS.
• Experienced on migrating on-Premises Oracle database to Azure Cloud VM.
• Experienced on migrating on-premises Oracle database to AWS Cloud.
• Worked on AZURE PAAS and migration on-premises SQL SERVER to SQL MI.
• Created Linked servers from Azure to on-premises.
• Migrated Sql server 2016 database to Azure Cloud.
• Working noledge on SSL certs wif application team on cloud environments.
• Successfully migrated critical applications to Azure and AWS environments.
• Worked wif application team to resolve TOMCAT issues.
• Experienced on Networking rules to enable bi-directional to allow the traffic.
• Experienced on migrating on-premises MYSQL server to AZURE MYSQL and installed MYSQL workbench and client to establish the connectivity to AZURE PAAS.
• Extensive Working noledge on Data guard Broker.
• Working wif users to solve the slowness queries.
• Extensive noledge on Data guard both Standby and Logical.
• Experienced on Golden gate.
• Created RDS databases on AWS cloud.
• Experienced in applying PSU7 patches on rolling fashion on 3 node RAC 12c.
• Handling database Jira tickets daily on priority bases.
• Experienced on AWS console.
• Mentoring metrics and logs through Splunk Dashboard.
• Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.
• Migrated On-premises Oracle database to EC2 instances on AWS for Dev, Test and Prod databases
• Worked on EC2 instances, s3 buckets, VPC and IAM groups.
• Created EBS volumes and snapshots. Attached EBS volumes to existing EC2 instances.
• Experienced on AWS cloud Watch to collect metrics and logs.
• Created Alarms through Cloud Watch for PROD EC2 instances and pushed via SNS notifications.
• Worked on Data guard Snapshot and Active databases for the business requirement.
• Have noledge on AWS services through console.

Confidential

Oracle Database Administrator/AWS Cloud

Responsibilities:

• Extensively worked on Real Application Cluster (RAC).
• Created stand by databases.
• Configured S3 bucket to have RMAN backup files to store in buckets.
• Tracing, troubleshooting wif database performance and tuning issues.
• Extensive Working noledge on Data guard Broker.
• Working wif users to solve the slowness queries.
• Extensive noledge on Data guard both Standby and Logical.
• Experienced on Golden gate.
• Created RDS databases on AWS cloud.
• Experienced in applying PSU7 patches on rolling fashion on 3 node RAC 12c.
• Handling database Jira tickets daily on priority bases.
• Experienced on AWS console.
• Mentoring metrics and logs through Splunk Dash board.
• Increasing EBS backed volume storage capacity when the root volume is full using AWS EBS Volume feature.
• Migrated On-premise Oracle database to EC2 instances on AWS for Dev, Test and Prod databases
• Worked on EC2 instances, s3 buckets, VPC and IAM groups.
• Created EBS volumes and snapshots. Attached EBS volumes to existing EC2 instances.
• Experienced on AWS cloud Watch to collect metrics and logs.
• Created Alarms through Cloud Watch for PROD EC2 instances and pushed via SNS notifications.
• Worked on Data guard Snapshot and Active databases for the business requirement.
• Have noledge on AWS services through console.

Environment: Oracle 11g/10g/12c, MSQL 2008R2, Linux, UNIX Shell Script, Incident Management, Change Management, Service now, Golden Gate 11g/12c, AWS Console, S3 bukcets, EC2 instancesData Guard Broker, Service Now tool, AWS, Splunk.

Confidential

Senior Oracle Database Administrator and

Responsiblities:

• Golden Gate up gradation on test, dev, staging and Production
• Extensive noledge on troubleshooting Golden Gate issues
• Worked on Critical issues on Golden Gate and Bug fixes
• Experienced in applying latest Golden Gate patches
• Implemented Golden Gate 12.2 new features
• Experienced on heterogeneous replication from Oracle to SQL Server
• Extensive noledge on Oracle database Performance Tuning
• Installing 10g/11g RAC Oracle databases using response file on Linux/Solaris servers
• Experienced in RAC troubleshooting issues
• Configured Data guard on 3 node RAC for critical production databases
• On support for ExaData databases
• Upgraded classic extract to integrated extracts for all the environments in Golden Gate
• Experienced Golden Gate on Exadata Machine wif DBFS mount points
• Configured XAG Agent on Golden Gate for High Availability
• Configured JAgent on Golden Gate for monitoring and deployed GG plug-in through OEM

Environment: Oracle 11g/10g RAC10g/11g/12c, Exadata X4-2, Exadata X6-2, SQL, MSQL 2008R2, Linux, UNIX Shell Script, Incident Management, Change Management

Confidential

Principal Database Administrator

Responsibilities:

• Installed Golden gate replication for source and target databases
• Extensive noledge on Performance Tuning
• Experienced on Golden gate
• Installing 10g/11g RAC Oracle databases using response file on Linux/Solaris servers
• Experienced in applying PSU7 patches on rolling fashion on 3 Node RAC 11gr2
• On support for Exadata databases
• Applied Patch set for Golden gate from 11.2.0.12 to 11.2.0.24
• Experienced on Golden gate up gradation from 11g to 12c.
• Experienced on both bi directional replications in Oracle Golden Gate
• Having noledge on Oracle Exadata storage sever
• Having noledge on Oracle Exadata OEDA (Oracle Exadata Deployment Assistant)
• Monitoring Exadata storage server through CELLCLI and DCLI
• Monitoring Griddisks from CELLCLI
• Creating Griddisks on all Exadata cells wif the DCLI
• Implemented TDE (Transparent Data Encryption) in Golden Gate for one of our secure the data which is being replicating on target side.

Environment: Oracle 10g/11g RAC on Linux/Solaris wif ASM, GG, Jira Ticketing.

Confidential

Responsiblities:

• Worked on Data guard for protecting the production databases by creating standby database
• Cassandra nodes monitoring and startup and shutdown commands.
• Knowledge on DataStax Ops center for Cassandra.
• Database creation for 11gr2 RAC upon on business request.
• Working wif users to solve the slowness queries.
• Extensive noledge on Data guard both Standby and Logical.
• Experienced on Golden gate.
• Installing 10g/11g RAC Oracle databases using response file on Linux/Solaris servers.
• Upgraded the RAC databases 10g to 11g.
• Experienced in applying PSU7 patches on rolling fashion on 3 node RAC 11gr2.
• Experience in Data guard implementation (Physical standby database) wif ASM storage 3node and handling database Jira tickets daily on priority bases.

Environment: Oracle 10g/11g RAC on Linux/Solaris wif ASM, Golden Gate Databases, Cassandra databases, OEM 11g/12c, Scrum and Jira ticketing tools.

Confidential

Project Lead

Responsibilities:

• Managed DBA team (infrastructure) on site and off site.
• On call support
• Implemented the automation scripts for the disk and mount alerts for the server’ Confidential t ignore alerts
• Team Monitoring and One on One wif individual team members.
• Database migration from Windows to Linux Using RMAN.
• Configured RMAN jobs through OEM and as well command prompt.
• Responsible for the each and every individual tasks and updates from the team.
• Applied CPU patches on various production databases.
• Day to day resolving the incident tickets.
• Implementing and handling issues wif Backup and Recovery strategies for Oracle databases (Logical Export & Import, Physical Online and Offline & RMAN) & disaster recovery procedures.
• Analyze, tuning and optimizing the database by using performance monitor.
• Assist the SQL developer in SQL tuning.
• Worked on creation of user’ Confidential and profiles for all databases.
• Installed two nodes RAC to maintain the production databases safe and balance out the data transactions on session level.

Environment: Oracle 11g/10g, RAC10g/11g, SQL, Data Gaurd 10g, Linux, UNIX Shell Script, Incident Management, Change Management, Net Cool tool, Net backup, Veritas Clusters.

Confidential

Oracle and Sybase Primary Production DBA

Responsibilities:

• Worked as Oracle and Sybase DBA across all Fannie Mae databases approximately 1100 Oracle and 400 Sybase databases.
• Worked wif application team on database requirements and designed the database as per the application requirements.
• Performed all phases of administration support like user administration
• Upgraded 10g to 11g on many production and acceptance databases and applied CPU patches
• Setup Data guard Configuration using Physical Standby Configuration.
• Setup active standby using 11g.
• Installed and Configured RAC on Oracle 10g/11g on Linux and Solaris
• Extensively worked performance tuning
• Used Data Pump Export/Import and RMAN for Backup and recovery.
• Used RMAN tool for Backup/Recovery of Databases.
• Improved the performance of the existing system by re-sizing the Database objects such as Tables, Indexes and Rollback segments to make the performance at optimal levels.
• Tuning memory areas wif Emphasis on Tuning Rollback segments, Buffer cache, library cache, Dictionary cache and shared pool to obtain optimal System performance.
• Capacity planning - Based on volumetric from a data model, calculate size of tables and associated indexes, accounting for fragmentation and growth.
• Applied Security Patches (CPU) to Databases.
• Wrote Unix Shell Scripts to monitor system status.
• Deciding on Logical Structures such as Table spaces, Number and Size of Rollback Segments
• Tuning the SQL, stored procedures and instances using AWR reports.
• Database Backup Strategy Design and Implementation.
• Backup and Recovery of databases including use of export/import.
• Monitor and set up replication between production and contingency database
• User and security maintenance creating users, dropping users, alter users etc
• Perform backup and recovery of user databases
• Health checking
• Creating databases and perform space management
• Trouble shooting performance issues.
• Monitor DSI threads and resolve any thread failures
• Performed Sybase upgrade from 12.5 to 15
• Performed backups and restorations and re-syncing data

Environment: Oracle 11g/10g/9i OEM, TOAD, SQL, PL/SQL, UNIX (Solaris, HP), Linux 3.x/4.x,Veritas VCS clusters. UNIX Shell Script, Windows NT/2000/2003.

Confidential, Maryland

Oracle DBA

Responsibilities:

• Assisted in Database Installations (all versions up-to 10g and 11g).
• Work wif software developers to develop and enhance applications.
• Maintain the Oracle 10g RAC environment and troubleshoot performance problems.
• Conducted optimization and performance tuning of database, SGA.
• Managed archived redo files, DB-links & Partitions, loading data for users by using SQL*Loader.
• Effective troubleshooting of Performance and tuning problems in Oracle databases by taking 10046 and 10053-errorstack traces.
• Handling issues related to Database Upgrade/Migrate and Patching.
• Handling RAC, DATAGUARD, and ASM issues.
• Installed Oracle 10G RAC on Linux platform using ASM & OCFS2.
• Implementing and handling issues wif Backup and Recovery strategies for Oracle databases (Logical Export & Import, Physical Online and Offline & RMAN) & disaster recovery procedures.
• Monitoring the database growth, checking for the performance bottlenecks and taking backups for disaster recovery.
• Finding fragmented objects & reorganizing them.
• Gathering optimizer statistics using dbms stats procedure.
• Creating & rebuilding the indexes.
• Support developers in tuning Database and applications for optimal performance.
• Upgrade, analyze and testing of the test and production database.
• Analyzing STATSPACK, AWR, ADDM and TKPROF and 10046 traces for diagnosing the root cause of the issues.
• Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security.
• Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
• Wrote packages, functions and procedure for reporting.
• Experience in installation and configuration of Oracle 10g RAC software.
• Used table partitioning to store year to date transactions in the database.

Environment: Sun Solaris 9/10, RedHat Linux, Oracle 9i, Oracle 10gR2, Oracle 11g, oracle 11i,PL/SQL Developer, TOAD, Data Pump, SQL*Loader, RMAN.

Confidential

Developer/Jr. DBA

Responsibilities:

• Requirement capture, analysis of requirements, design solution based on clients needs.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
• Used PLSQL Records, Collections (Nested Tables and Arrays) in complex backend packages.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Involved in the management of customer logged issues by providing priority based timely resolution.
• Assisted in design of tables, databases, forms and reports.
• Coded, tested debugged, documented, and maintained programs.
• Documentation of user manual and other generic documentation required for the module.

Environment: Oracle 9i, SQL, PL/SQL, SQL Loader, Linux, UNIX, Toad.