PROFESSIONAL SUMMARY:

• I am a hardworking, diligent and extremely meticulous Oracle Database Administrator wif over six years of experience. I believe these three characteristics are teh most important qualities of a good DBA.
• Throughout my tenure I have dealt wif almost every possible aspect of my field. I have a wealth of noledge and experience, but most importantly, I am always willing to learn and share my noledge wif others
• I also pride myself in taking excellent notes and documenting steps and procedures.
• I am a good communicator; am highly personable and amicable, am excellent at juggling multiple tasks and working under pressure. I have worked on projects as a team member and individually. I am resourceful, honest, and respectful, and for these reasons I firmly believe I will be an asset to you're company.
• Accomplished Oracle - certified DBA wif over 7 years of experience in development and production environments.
• Ensure Oracle database systems operate efficiently and securely.
• Skilled in designing and implementing complete life cycle client servers and database applications wif various development tools and languages.
• Manage internal databases, from planning and testing stages through implementation and support.
• In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices.
• Superior communication, presentation, analytical and problem solving skill. Work well wif all levels of business.
• Experience in performance tuning, crisis management, and high availability to increase reliability, maximize productivity, database installation, administration, configuration, production support, upgrades, patches, database security, cloning, migration, RAC, Gloden Gate, Data Guard and documentation.

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.3, 6.1 RHEL 6&7.Linux Enterprise Server 9, 10. Windows 2012

RDBMS: Oracle 10g, 11g, 12c, Exadata

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, Gloden Gate, Data-Broker, Data Guard, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import

Tools: Explain-Plan, ASH TKPROF, STATSPACK, AWR, and ADDM. TOAD, Putty, NX client, WinSCP, VNC and Cisco VPN Client

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Oracle Database Administrator

Responsibilities:

• Provided 24X7 support for all teh production and development databases.
• Other duties include applying oracle database patches, and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting, backup and recoveries.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to teh development team in identifying SQL queries that are consuming high resources and interact wif teh development team to see if these queries can be fine-tuned further.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Extensively worked on cloud-based databases. Preferably OCI and AWS cloud.
• Migrated traditional Linux environments to AWS/RHEL Linux environment and used auto scaling feature.
• Increasing EBS backed volume storage capacity when teh root volume is full using AWS EBS Volume feature.
• Create alarms in CloudWatch service for monitoring cloud servers performance, disk space and CPU utilization.
• Created and deleted IAM accounts in AWS for security purposes and provided access to users per company requirements.
• Migrated different servers to AWS platform
• Managed multiple databases residing on EC2 servers in RDS
• Experience wif setting up of databases on Oracle Cloud Infrastructure (OCI), managing cloud accounts/access, cloud storage container for automated and on-demand backups.
• Created SSH key pairs, created and deleted administrative accounts via OCI console, granted and revoked roles under different groups.
• Worked extensively wif network teams to configure VCN’s Public and Private IP’s Subnets, Dynamic Routing Gateways (DRG), Route Tables, Subnets and Security etc., for Oracle Cloud Infrastructure (OCI).
• Installed and Implemented Backup & Recovery procedures.
• Implement Hot, Cold and Logical backup plans.
• Experience in Exadata fresh installs (configuring databases and cell nodes on appropriate servers and running teh One Command) exadata re-imaging and general administration of exadata systems.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc
• Experience wif all steps involved in exadata patching and upgrade including but not limited to running downloading teh right bundle, patchmgr, running pre-checks, upgrading grid and db nodes etc.
• Extensive experience in performing database and system health checks on (Oracle EXAchk) on exadata.
• Handle all Client Requests, Work closely wif Clients for New Projects from Initiation to Production cutover Identify cost saving opportunities & implement innovative DB solutions for clients (collaborate wif Infrastructure Delivery team as needed).
• Involved wif installation and maintenance of ORACLE 11g RAC/oracle 12cRAC and Standby databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.
• Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate TEMPeffectively wif technical and non-technical customers.
• Applied database patches using Opatch utility for RAC and Non RAC databases & building Clone instances for Development and Test teams.
• Responsible for using Flashback query mechanism along wif automatic undo management.
• Extensively worked on Oracle Multi-tenant architecture/container/pluggable databases wif local and cloud storage options.
• Migrated 10g and 11g databases to 12C and managed them as a container wif up to 150 pluggable databases per container.
• Experience wif applying patches and upgrades in Multi-tenant environment.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, SQL Developer.
• Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Worked on Active data guard, Fail over and Switch over cases.
• Refreshed/cloned databases using RMAN utility.
• Responsible for installing, upgrading, patching and configuring teh Oracle environment.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive uses of Oracle Data pump Exports/Imports utility for moving data among teh servers.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to teh users.
• Partitioning and re-organization of table and indexes.
• Performance in daily transforms by identifying and reorganizing indexes on major tables.
• Alert monitoring and Ticketing
• Managed, trained, and mentored staff.

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Worked as a team member for 24x7 support wif on call rotation in all prod, QA and dev environments.
• Supported 50+ databases including RAC production database, and alot of Development and Test databases and upgraded from 11g to 12c.
• Provided Production & test environment support while coordinating wif Linux Team and storage team to configure teh OS infrastructure for Oracle Databases.
• Performance tuning of teh database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, AWR, ADDM.
• Experience in Cloning, copying an existing Oracle installation to a different location and updating teh copied bits to work in teh new environment.
• Database Upgradation, Migrations using traditional way (DBUA, Manual and export/import) as well as non-traditional way (Transportable table spaces).
• Setup New databases on Clustered and Non-clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Gloden Gate.
• Identified and reduced/ eliminated non-idle wait events such as scattered file read, sequential file read wait event, log file completion, in queue, and buffer latch waits.
• Strong customer facing technical presence wif teh ability to solve complex problems
• Good noledge on all incident, change, problem management process & compliance process
• Responsible forinstalling, upgrading and configuringthe Oracle environment bycreating databases, database backup and recovery, monitoring and optimizing database performance.
• Installed and configured Gloden Gate for replication.
• Involved in Oracle Gloden Gate installation, configuration, troubleshooting
• Gloden Gate EXTRACT and REPLICATE issues.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Worked wif Data Pump to take teh logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Full database, Schema refresh using RMAN, Data Pump and Implemented teh Backup strategies using RMAN catalog and non-catalog methods.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security.
• Alert monitoring and Ticketing.
• Moving data between databases using Data Pump.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to teh database based on teh applications they are accessing.
• Coordinated wif developers and users connecting to different databases
• Export and Import Data according to teh user’s request
• Responsible for tuning teh database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned teh tables and indexes for better performance.