We provide IT Staff Augmentation Services!

Oracle Dba / Aws Solution Architect Resume

Austin, TexaS

EXPERIENCE SUMMARY:

  • Over 6 years of hands - on experience as an Oracle DBA, having professional experience in oracle database administration (10g, 11g, 12c) on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform and Over 2+ years' experience working as AWS Solution Architect and have successfully designed and delivered secure cloud solutions for some of the Major organizations on AWS Cloud Operating Systems CentOS 5.x 6.x 7.x, RHEL 5.x, 6.x, Sun Solaris 8,9,10, Windows NT 4.0, 2000 Servers, Workstation, and various flavors of UNIX and LINUX
  • Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
  • Have ample knowledge in implementing policies, and procedures for disaster recovery and archival processing to ensure data protection.
  • Expert in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
  • Experience with SQL coding including DDL, DML and fine-tuning those SQL's for better performance.
  • Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring. Expert in RMAN backups including full, incremental and cumulative.
  • Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
  • Extensively worked on Import/Export and Data Pump Import/Export tools.
  • Knowledge in configuring ASM (Automatic Storage Management)
  • UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
  • Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
  • Perform database monitoring and tuning to ensure databases run at peak performance; troubleshooting production performance issues.
  • Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
  • Excellent communications and interpersonal skills.
  • Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.
  • Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
  • Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 2 TB.
  • Experience in Installation of Oracle Databases 9i, 10g, 11g and 12c versions.
  • Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
  • Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.
  • Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.
  • Configuration and Management of Data Guard on RHEL, OEL.
  • Experience in creating and managing control files, redolog files, data files and archive redo log files.
  • Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS).
  • Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).
  • Proactively monitoring the database's health and taking preventive or corrective actions
  • Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).
  • Proficient in using various database Utilities like EXPORT/IMPORT, Data Pump, TOAD.
  • Programming skills with strong SQL knowledge

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 10g, 11g, 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL.

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, NX client, WinSCP.

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

TWS Scheduler: ADF, AWS S3, EC2, Lambda, IAM, AMI, VPC, Security Group, Cloud Formation, Cloud Watch, Redshift etc.

APPLICATIONS: HR, FIN, PEOPLESOFT

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

ORACLE DBA / AWS SOLUTION ARCHITECT

  • Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
  • Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases
  • Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
  • Setting up High Availability Oracle Golden Gate systems on Oracle 11gR2 RAC environments
  • Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.
  • SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
  • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, and DBV.
  • Performed Data file recovery from logical and physical block corruptions
  • Work with Oracle Data Pump (expdp and impdp) which provides high data and metadata movement of Oracle database contents. speed, parallel, bulk
  • Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
  • Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Used GOLDEN GATE for Zero Downtown Upgrade and Migration
  • AWS Certified Solutions Architect with excellent proven track record in providing solutions
  • In-depth knowledge on various AWS Services including EC2, VPC (NAT, Peering, VPN), IAM, EC2 Container service, Elastic Beanstalk, Lambda, S3, Cloud Front, Glacier, RDS, Dynamo DB, Elastic Cache, Redshift, Direct Connect, Route 53, cloud watch, Cloud Formation, Cloud Trail, Opsworks, Amazon Elastic Map Reduce (EMR), AWS IoT, SNS, SQS, Lambda, API Gateway, AWS Alexa etc.
  • Good knowledge and experience using AWS Lambda for Server-less computing using Python and Java.
  • Experience working on administering various AWS Services using AWS Console, AWS CLI and using Amazon Api using python, Node.js & Java.
  • Experience implementing Security using ACL, Security groups, Private-subnets, Encryption on Transit and Encryption at rest.
  • Experience working on Migrations from On-prem to AWS Cloud
  • Experienced in automating, configuring and deploying instances on AWS, Oracle cloud environments and in Data centers.
  • Expertise in scripting for automation, and monitoring using Shell, PHP, Python & Perl scripts.
  • Worked with Custom AMI's, created AMI tags modified AMI permissions.
  • Created Security Groups, configuring Inbound /Outbound rules, creating and importing Key Pairs.
  • Leveraged AWS S3 service as Build Artifact repository and created release based buckets to store

Confidential, New York City, NY

ORACLE DATABASE ADMINISTRATOR

  • Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.
  • Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
  • Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
  • Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration
  • Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases
  • Upgraded databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades
  • Setting up High Availability Oracle Golden Gate systems on Oracle 11gR2 RAC environments
  • Installation and creation of 11g databases for Testing & Development on both IBM-AIX and Linux environment in OLTP, Decision Support System Data Warehousing environment.
  • SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.
  • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, and DBV.
  • Performed Data file recovery from logical and physical block corruptions
  • Work with Oracle Data Pump (EXPDP and IMPDP) which provides high data and metadata movement of Oracle database contents. speed, parallel, bulk
  • Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.
  • Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
  • Used GOLDEN GATE for Zero Downtown Upgrade and Migration

Hire Now