PROFESSIONAL SUMMARY.

• Excellent work ethic, professionalism, attention to detail, ability to work in a highly collaborative, collegial, and multidisciplinary team environment.
• Has impeccable communication and interpersonal skills and an exceptional team player.
• Ability to quickly understand complex problems and devise effective solutions.
• Oracle certified Database Administrator (DBA) wif over 8 years of extensive experience designing, testing and supporting next - generation database solutions in Oracle enterprise and SQL Server environments.

TECHNICAL SKILLS

Database utilities: Data Pump, SQL* loader, ETL, SSIS, RMAN, OEM, SQLplus, TOAD, SQL profiling.

Operating Systems: Windows, UNIX, Linux, Solaris.

Languages: SQL, PL/SQL, Shell scripting.

Databases: ORACLE 10g/11g/12c/18c/19c, MYSQL

ServerTuning Tools: AWR, ASH, ADDM, Explain Plan, Tuning Advisor.

PROFESSIONAL EXPERIENCE:

Confidential, Bridgeton, MO

Oracle Database Administrator

Responsibilities:

• Involved in upgrade/migration of databases from Oracle 11g to Oracle 12c, 18c and 19c.
• Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using runInstaller, OPatch utility and OEM 12c/13c.
• Worked on Microsoft SQL Server Database, including Always-On Availability Groups, SSIS, SQL Replication, SQL performance tuning
• Involved in developing and maintaining Data Warehouse solutions, and Oracle partitioning.
• Carried out database design, development, configuration, data architecture, and ETL functions (SSIS).
• Deployed and utilized packages, stored procedures, function, and triggers.
• Automated refresh from production to lower environments, RMAN jobs using shell scripts scheduled on linux crontab utility and OEM cloud control.
• Planned, installed, configured, and administered multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX.
• Worked extensively wif AWS services such as EC2, RDS, S3, VPC, ELB, Auto scaling, Route 53, IAM, CloudTrail, Cloud Watch, SNS, Lambda, Amazon Simple Queue Service (SQS), Amazon Simple Notification Service (SNS), and Amazon Simple Workflow Service (SWF) etc.
• Designed, implemented and maintained all AWS infrastructure and services wifin a managed custom VPC and service environment.
• Implemented database backup and recovery using RMAN (scheduled full, incremental, cumulative, hot, cold backups by writing UNIX shell scripts for RMAN)
• Extensively used AWR, ADDM, ASH, and Explain Plan for periodic performance tuning of various critical terabyte size OLTP and OLAP databases.

Confidential, Oklahoma City, OK

Oracle Database Administrator

Responsibilities:

• Worked in a heterogeneous environment (Oracle, MySQL, SQL Server and Postgres) comprising of over 150 databases wif teh larger databases ranging from 1 to 12 TB in a RAC environment.
• Helping developers in Oracle PeopleSoft Administrator/DBA skills in creating Oracle users, granting roles, executing SQL scripts, refreshing PeopleSoft databases using RMAN export/import.
• Create and configure databases and other components of PeopleSoft environment.
• Planned and migrated multiple databases across platforms using different migration approaches and techniques based on database or platform requirements.
• Planned, implemented policies, and procedures for disaster recovery. Setup and administered Physical, Snapshot, Logical and Active standby databases using Oracle Data Guard.
• Backup and Recovery - RMAN, User-managed backup (hot and cold), full and incremental.
• Designed, architected, and implemented projects to migrate services from on-premises servers to Oracle cloud.
• Performed frequent refreshing/cloning of production databases to development & testing environments using RMAN and DATAPUMP.
• Performed Hot and Cold RMAN backups using RMAN and OEM 11g/12c/13c
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.
• Automated alert log management, database health checks and efficient backup by developing UNIX shell scripts.
• Managed database migration using data pump, transportable tablespaces, RMAN, Dataguard, Golden Gate.

Confidential, Sunnyvale, CA

Oracle Database Administrator

Responsibilities:

• Performed database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, database backup, performance tuning, table reorganizations, online segment shrink, index rebuilds.
• Created shell scripts for managing day-to-day activities and incremental and full image backup automatically.
• Monitored and tuned performance using OEM (Oracle Enterprise Manager).
• Automated teh processes like moving files, managing alert log, database health checks and efficient backup by developing UNIX scripts.
• Worked wif application developers to address and clarify data requirements to resolve technical and functional issues.
• Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using runInstaller, OPatch utility and OEM 12c/13c.
• Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).
• Planned and performed daily Backup and Recovery using RMAN.
• Extensively worked on physical standby database on different versions 10/11g/12c DATAGUARD wif Data Guard Broker configuration.
• Created database objects, Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.