SUMMARY

• 7.5 years of experience as a Oracle Database Administrator on a variety of UNIX (Solaris, HP - UX, AIX), Linux, Windows with Oracle 10g, 11g, 12c, 19c, RAC, Data Guard, Advanced replication, Installation, Configuration, Migration, Sizing and Space management, Backup and Recovery, Performance tuning and troubleshooting.
• Experience Golden Gate. Experience in OEM configuration, installation, monitoring for the application running environments.
• As a Cloud Engineer having experience in handling EC2 instances.
• Familiar with AWS IAM, S3, DynamoDB and RDS in an enterprise environment.
• Modifying and improving existing systems. Configure, test, deploy, and upgrade software for production EC2 servers in AWS.

TECHNICAL SKILLS

Languages & Program: SQL, Shell Scripting

Database: Oracle 9i, 10g, 11.2.0.3, 11.2.0.4, 12cR1, 12cR2,19c

Cloud Computing: AWS

Operating Systems: Linux, Solaris, Aix,HP, Windows 2000

Tools: Expdp/impdp, Log Miner, Oracle Enterprise Manager Grid Control, Golden Gate

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Environment: ORACLE DATABASE 11g, 12C, 19c, RAC, OEM, Golden Gate, Exadata, AWS

Responsibilities:

• Creating EC2 Instances.
• Creating Users/Roles in AWS.
• Managing Inbound/Outbound traffic
• Knowledge on Migrating Databases to Cloud.
• Environment setup using EC2, S3, EBS, VPN, CloudWatch, Databases.
• Familiar with AWS IAM, S3, DynamoDB and RDS in an enterprise environment
• Network administration and troubleshooting using AWS Security Groups.
• Server and storage backups using AMI’s and snapshots.
• AWS Cost optimization by effective use of AWS resources.
• Managing tags and creating cost reports.
• Offer guidance in application migration from on-prem data centers to AWS Cloud using relevant AWS cloud services.
• Maintaining Data Integrity and access control by making use of the AWS application platform; effectively monitoring charging and cost optimization strategies.
• Working with internal teams to troubleshoot AWS related issues.
• Modifying and improving existing systems.
• Configure, test, deploy, and upgrade software for production EC2 servers in AWS.
• Server upgrade/downgrade activities as per capacity management.
• Applied PSU/CPUand Grid patches for security purpose and covered all issue in 11g/12c/19c.
• Migrating databases across different platforms and standalone servers to EXADATA
• Worked on troubleshooting Golden Gate Replication issues.
• Configured the Uni directional and Bi-directional replication.
• Successfully implemented and managed Physical Standby Database using Oracle DATAGAURD feature for Disaster Recovery.
• Expertise in performing Switch Over and Switch Back activity from production to standby and vice versa and performing Fail Over of live database to standby database during criticalities.
• Create databases for development, testing and production (including RAC databases and NON-RAC databases).
• Patching RAC or Non RAC environments with no downtime on RAC environments in rolling.
• Upgrade databases from Oracle 11g to 12c /19c in RAC Environment.
• Restoring databases from RAC to Non-RAC Environment and Non-RAC to RAC.
• Develop UNIX shell scripts, SQL scripts to carry out routine checks on databases and automation.
• Hands on experience in Migrations of Databases from various versions
• Strong exposure in performing critical production database recoveries.

Confidential

Oracle Database Administrator

Environment: ORACLE DATABASE 11g, 12C, RAC, GOLDEN GATE, OEM

Responsibilities:

• Managing 24/7 production servers
• Configured the Uni directional and Bi-directional replication.
• Experianced in managing the VLDB databases with more than 30TB database size.
• Installations of standalone & RAC databases & configurations of Oracle 10g, 11g, 12c on Linux & Windows
• Oracle RAC configuration & Troubleshooting.
• Appling PSU patches on production databases
• Installation of OEM grid control 12c, 13c agents using silent mode and Pushing Binaries from DB console.
• Analyze and solve performance issues using AWR, ASH and ADDM reports, 10046, 10053 and ORADEBUG traces.
• Expertise in database up gradation from 10g/11g to 11g/12c for Standalone and RAC Environments.
• Upgraded the databases from 10g to 11g, 11g to 12c manually and DBUA.
• Applied PSU, CPU patches on RAC Environment and Non RAC Environment.
• Transporting & Loading data between Oracle Databases using Import/Export & Data pump Utility.
• Provide continuous support to database related activities like monitoring, administration and troubleshooting of multiple standalone databases of different versions on different platforms.
• Installation of Oracle 9i,10g,11g & 12c database Software as well as Clients using GUI & silent mode in Windows, AIX and Solaris.
• Managing database security. Creating users and roles and assigning different roles to users.
• Creation & Rebuilding of Indexes on tables as maintenance activities.
• Performed the Table Re-org and eliminating the Row chaining.
• Performed the RAC Restorations.
• Performed the Switchover and Switchback for RAC Critical databases.
• Analyzing DB level & Schema level statistics at regular intervals.
• Refreshing UAT/ development databases from production databases using export and import & data pump.
• Data Guard configuration, Switchover & Failover.
• Perform SCN Incremental backups to sync the DR database with PRODUCTION if lagging behind.
• Moving or backing up old archives with RMAN, if File System is filled
• Scheduling and managing crontab jobs
• Coordinating with other teams like testing/Developers for fixing up issues
• Executing Code given by developers on Dev as well as Production Systems

Confidential

Oracle Database Administrator

Environment: ORACLE 9i, 10g, 11g RAC

Responsibilities:

• Regular checking of the alert log file, space usage and proper execution of the scheduled jobs
• Creating user schemas, grant privileges as per the requirement.
• Monitoring the sessions and kill if necessary.
• Taking backups using expdp/impdp, hot and moving to the test environment
• Monitoring the CPU and free disk space on the servers
• Daily generating the AWR Reports and ADDM reports and take necessity actions to improve the database performance.
• Monitoring the backend processes at the server level like CPU and memory utilization
• Online rebuilding of indexes
• Identifying and creation of the indexes on tables
• Monitoring the backups regularly
• Creating and altering table spaces
• Monitoring Filesystem usage, CPU Utilization, Tablespace growth
• Database creation and deletion
• Database startup and shutdown
• Oracle installation (Server & Client)
• Creating and deleting users
• Creating roles and assigning it to the users
• Granting and revoking privilege from users
• Controlling & monitoring user access
• Creating tablespaces and assigning to users
• Export and import of database.
• Scheduling and managing crontab jobs
• Backup of Database (Online/offline/Rman)
• Managing Archive logs and Full Back up by RMAN
• Moving or backing up old archives with RMAN, if File System is filled
• Development of necessary tools (Unix Scripts) for monitoring & maintenance of Database