Support Oracle
Resume:
KantiKiran Vajrala
San Antonio, TX - *****
USA
adg82v@r.postjobfree.com
SUMMARY:
●Over 10+ years of experience as an Oracle Database Administrator having experience in the database administration, production support, installation, configuration, upgrades, patches, data guard, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, UNIX shell scripting and documentation.
●Configuration, Supported, troubleshooting OLAP and OLTP RAC and Non-RAC databases 8i/9i/10g/11G,12C and 18c versions.
●Supporting Half and Quarter Rack EXADATA servers in OCI cloud.
●Build and Configured Physical Standby for 11G/12C Production databases.
●Redirect on-premises RMAN Backup directly to AWS S3 Bucket.
●Troubleshoot and maintain 8 node 10G and 11GR2 RAC Production and Development Clusters.
●Installation, Configuration, Troubleshooting Golden Gate Replication for Oracle-to-Oracle.
●Expertise in database upgrades from 9i to 10g,11g and 12C.
●Expertise in installation, configuration of DataGuard both in standalone/RAC in both 10g/11g.
●Experience in database recovery techniques and implementation of those recovery techniques to ensure business continuity.
●Expertise in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
●ERWIN Data modeling for creating reverse Engineering schema design.
●Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
●Knowledge on Oracle Support processes for technical requests with Metalink.
●Proactive monitoring, identifying areas that need to be improved in the application and database
●Strong analytical and problem-solving skills with ability to work within team environment and independently when needed.
TECHNICAL SKILLS:
Operating Systems
HP-UX 10.x, 11.x, Solaris 8, 10, AIX 5.3, 6.1, RHEL 4, 5,6,7 Windows 2000/2003, Oracle Enterprise Linux
RDBMS
Oracle 19C,18C,12C/11g/10g/9i/8i
Languages
SQL, UNIX Shell Scripting
Tools
RMAN, ASM, ACFS, OEM 10/11/12/13c, SQL*Loader, EXP, IMP, Expdp, Impdp, DBVerify, Dbca, Asmca, Dbua,Srvctl,Crsctl,opatch,Datapatch,Exapatch,Exawatcher,TFA
Golden Gate and Golden Gate Veridata
Backup Tools :- EMC-Networker,AWS Secure Backup to S3
Knowledge on Other Database systems
PostgreSQL, Vertica, MS-SQL, MongoDB
EDUCATION:
Master’s in Computer Science from Texas A&M University – commerce
Certifications :
Oracle Autonomous Database Cloud 2019 Certified Specialist
PROFESSIONAL EXPERIENCE:
Capital Group of Companies April 2020 – Current
San Antonio, TX
Role: - Sr Oracle DBA
Responsibilities:
24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
RMAN Backups using OEM Jobs.
Upgrade catalog databases.
Configure RMAN DDBoost configurations for new databases for backups.
Apply Security patches on 13c OMS servers using omspatcher.
Upgrade databases to 19C from 18c and lower versions.
Support AWS oracle instances.
Support bi-directional Golden gate setup.
Configuration of golden gate process in OEM for monitoring replication.
Refresh lower environments from production using RMAN clone.
Maintain Centralized oracle tnsnames using Oracle Internet Directory(OID).
Upgrade OEM agents using Gold image.
GAP INC, San Francisco, CA June 2019 – April 2020
Role: Sr Oracle DBA Exadata
Responsibilities:
●Production database Support for 12C and 18C on Half and Quarter Rack Exadata RAC Cluster on OCI Cloud.
●Configuring of ACFS on Exadata servers
●Rolling Patch databases environment with latest RUR.
●Supporting and configure Multi-Tenancy database architecture.
●Expertise in install and upgrade APEX, Oracle Message Gateway on databases for ORDS setup.
●Configure and setup Oracle Message Gateway Agent on RAC database with no single point of failure.
●Setup and configure Row Level Security for API secret keys.
●Setup and configure Oracle Label Security on PCI data.
●Tuning RMAN Backup performance.
●Upgrading databases from 12c to 18c.
●Installed and Configured Golden Gate Micro-service for OCI to On Premises DB.
●Used RMAN for backup and recovery. Performed backup validations using RMAN.
●Configured ASM disk groups to store Data files, redolog files, and control files.
●Developer Environment Setup, Support, Cloning and Refreshes.
●Taking RMAN Backups on scheduled time and monitoring scheduled Backups
●Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
●Integrated multiple logical data models into a single data model.
●Modeled the logical and physical diagram of the future state, Delivered BRD and the low level design document.
Environment: Oracle Server 18C/12C/11g,, Red Hat UNIX, AIX, Oracle Enterprise Linux 6,7
General Electric (GE), Louisville, KY Oct 2014 – June 2019
Role: Sr. OracleDBA
Responsibilities:
●24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
●Duplicate databases using RMAN Active Database commands.
●Patching and monitoring EBS,Demantra(VCP) and SOA large databases.
●Migration of 9i/10/11g databases to 12C using Golden Gate and EXPDP/IMPDP utility.
●Installed and configure 12C database for Pre-Production on Oracle Enterprise Linux 6.
●Establish and Document Backup and Recovery strategies and procedures for High Dedupe at storage using RMAN backup.
●Installed and implemented 12 Oracle Internet Directory for tnsentry Repository.
●Migration of RMAN Catalog Clients to higher RMAN Versions.
●Upgrade RMAN Catalog Schemas.
●Used Dev/Test/Stage Cloneing activity using Active RMAN clone and RMAN backups from Production.
●Performed 9i,10G,11G to 12C database migration.
●Apply Critical Patches and PSU’s on 11g and 12C.
●Implemented on RMAN on-premises backups directly to AWS S3 Buckets.
●Refresh databases from Prod to Test and Cert environments for performance testing.
●12C Grid Server and applied latest bundle patch to plugins.
●Setting Monitoring templates in OEM 11G/12C/13C.
●Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN
●Configured ASM disk groups to store Data files, redolog files, and control files.
●Developer Environment Setup, Support, Cloning and Refreshes.
●Taking RMAN Backups on scheduled time and monitoring scheduled Backups
●Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
●Implemented range, list and hash sub partitions.
●Tuning heavy data loads. Monitoring and Performance tuning.
●Handling day-to-day activities.
● Integrated multiple logical data models into a single data model.
●Designed the Merchant Conceptual, Logical and Physical Data Models.
Environment: Oracle Server 12C/11g/10g/9i/8i, Red Hat UNIX, HP Linux, AIX, Oracle Enterprise Linux 5, 6, 7
T-Systems North America Feb'2012 - Oct’2014
Role: Sr. Oracle DBA
Client: SHELL, Houston, TX
Working at shell customer site for supporting Shell Trading RAC and Non-RAC Databases Oracle 10G/11G.
●Migration of 2 Critical 10TB & 8TB OLAP Databases from RAC 10G (UNIX) to Non-RAC 11G (AIX) using Golden Gate (Uni-Directional).
●Migration of databse from 10G to 11G using netapp snap mirror technology/RMAN between RAC clusters.
●Installing/un-installing RAC Databases.
●Support to Shell Trading During North America Business hours.
Responsibilities:
●24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
●Creating, maintaince of databases in 8 Node Oracle 11gR2 RAC.
●Cloning Test/Development database from Production database using Net App Snap Shot Technology.
●Migration of RAC databases from 10G 8 Node RAC Cluster to 11G 8 Node RAC cluster using Net App Snap Shot.
●Configured Physical DataGuard for Disaster Recovery.
●Performed Cross Platform Migration of 10TB RAC database from Unix (10G) to AIX standalone (11GR2) using Golden Gate Replication.
● Performed 10G to 11G upgrade of Standalone and OLTP and OLAP RAC databases.
●Participated in Data-Center Fail-over exercise.
●Configure and troubleshoot Net App Snapshot Backups for RAC and Non RAC databases.
●Analyze alert Log and User trace Files and Diagnosing the Problem.
●Providing Solutions to the problem paced by end users or programmers.
●Scheduling jobs through Oracle job Scheduler.
●Providing Solutions to the problem paced by end users or programmers.
●Automation of Startup Shutdown on database servers.
●Developed scripts for Health Check of Databases, Analyzing of Tables, Cold Backups, ASM reports and ASM metadata backups.
●Pull AWR, ADDM ASH reports for performance monitor and tuning.
Client DHL, Phoenix, AZ
●Installed 12C OEM for monitoring PROD and Non-Prod Environments.
●Patching 11G 2-node RAC database running on ASM.
Responsibilities:
●24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
●Experience in setup and maintenance of a 2 Node Oracle 11gR2 RAC.
●Running RAC CHECK UTILITY for RAC servers.
●Implemented OS Watch scripts on Oracle servers for monitoring logs.
●Upgrade databases from 10.2.x to 11.2.0.3 on Linux platforms.
●Apply Critical Patches and PSU’s on 11gR1/11gR2.
●Refresh databases from Prod to Test and Cert environments for performance testing.
●Installed and implemented 12C Grid Server and applied latest bundle patch to plugins.
●Used RMAN for backup and recovery. Performed backup validations using RMAN.
●Configured ASM disk groups to store Data files, redolog files, and control files.
●Developer Environment Setup, Support, Cloning and Refreshes.
●Involved in developing a disaster recovery plan.
●Periodic Index maintenance to avoid performance issues due to fragmentation.
●Conducting sizing & capacity planning for Oracle databases.
●Analyze alert Log and User trace Files and Diagnosing the Problem.
●Scheduling jobs through Oracle job Scheduler.
●Providing Solutions to the problem paced by end users or programmers.
●Automation of Startup Shutdown on database servers.
●Refreshing Dev/Test database from Prod using RMAN duplicate, Import/Export commands.
Environment: Oracle Server 11g/10g/9i, RedHat Linux 4.x, 5.x, 6.x, AIX 6
C&S Wholesale Grocers, NH Mar’2011 - Jan 2012
Role: Sr. Oracle DBA
Responsibilities:
●24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
●Involved in migration of 9i database from HP-Unix to 10g IBM AIX servers.
●Used RMAN for backup and recovery. Performed backup validations using RMAN.
●Refresh databases from Prod to Test and Dev environments for Application testing using RMAN.
●Performed daily maintance and user requests.
●Applied Patches 10.2.0.3 to 10.2.0.5 to ASM, CRS and DATABASE home on 2-node RAC.
●Installed 11gR2 for Production environment on 2-node RAC.
●Installed and configure the 11g GRID server.
●Implementation of Logical standby for OLAP database for reporting purpose on 10g/11g.
●Implementation and maintained Physical Standby for DR Senario.
●Installed the grid control agents in the RAC and Non-Rac database for monitoring.
●Applied bug Patches on the grid Control servers.
●Configure the RAC database, ASM instances in the grid servers.
●Implemented Shell scripts to Purge the log, trace, trim, audit files on Prod, Dev servers.
●Continuous Performance monitoring and Tuning of the databases and application using OEM, AWR, ASH, ADDM etc
●Performed partitioning of tables, indexes to improve the Sql performance and oracle maintenance.
●Scheduling jobs through Oracle job Scheduler.
●Providing Solutions to the problem paced by end users or programmers.
●Developed scripts for Health Check of Databases, Analyzing of Tables, Cold Backups, ASM reports and ASM metadata backups.
●Pull AWR, ADDM ASH reports for performance monitor and tuning.
●Perform node deletion in 3-node RAC database server.
Environment: Oracle Server 11g/10g/9i, SQL, AIX 5, 6, RedHat Linux 5.x
Contact this candidate