Charan Reddy

Sr. Oracle DBA

Email: ad42zb@r.postjobfree.com Phone: 316-***-****

PROFESSIONAL SUMMARY:

Over 10+ experience in the IT industry and a strong background as an Oracle Database Administrator in Production, Development, and Test environments. Worked on both UNIX and Windows systems, handling different versions of Oracle (8.0.5, 9i, 10g, 11g, 12c, 19c and 21c) across various operating systems like OEL, RHEL, UNIX, AIX, and Sun Solaris.

Good at boosting database performance and keeping a close eye on it, using a tool called Oracle Enterprise Manager (OEM) Grid Control.

Experienced in setting up and watching over Oracle Real Application Clusters (RAC) and Data Guard, which help keep the database running even if there's a problem.

Skilled in making sure Oracle databases run smoothly and don't go down.

Expert knowledge in installing oracle database server on SOLARIS, HP-UX, AIX, WINDOWS NT, LINUX, and migration of oracle server from 9i to 10g, 10g to 11g,11g to 12c and 12c to 19c.

Proficient in migrating single-instance databases to multi-node environments (10g, 11g R1, R2, and 12c RAC) to enhance high availability and load balancing.

Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema for faster and effective Querying for the Metadata Management solutions.

Successfully migrated legacy Oracle applications to microservices architectures, improving agility, scalability, and time-to-market for new features and updates,

Played a key role in upgrading Oracle EBS modules, enhancing system functionality and user experience.

Strong experience in implementing ORACLE STREAMS and managing two types of standby databases, including logical standby and physical standby.

Expertise in the Enterprise Security Domain with a solid grasp of LDAP and Identity & Access management products, including Oracle Identity Manager (10g, 11g, and 12c), Oracle Access Manager, Oracle Internet Directory (10g and 11g), and Oracle Virtual Directory (11g).

Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).

Knowledgeable in database architecture development and coding standards.

Extensive experience with PL/SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.

Designed and implemented resilient and scalable Oracle 21c databases in cloud-native environments.

Developed database triggers and stored procedures using T-SQL cursors and tables.

Extensive expertise in database backup/recovery strategy (RMAN), Data Pump Import/Export, capacity planning, replication (Streams), standby databases, Oracle configuration management, data guard, database cloning, refresh, and patch management.

Established Disaster Recovery solutions for Oracle 11g, 12c, and 19c RAC databases, working in RAC environments with 2 nodes and 6 nodes Oracle RAC and ASM.

Implemented successful High Availability solutions viz. Oracle Data guard, RAC, Golden Gate and Shareplex.

Proficient in implementing policies and procedures for disaster recovery and archival processing to ensure data protection.

Accomplished Oracle Database Administrator with a strong background in managing and optimizing Oracle databases in Azure and AWS cloud environments.

Proficient in seamlessly integrating Oracle databases with Azure infrastructure, leveraging cloud-native services for enhanced scalability and flexibility.

Proficient in setting up disaster recovery strategies for Oracle databases on Azure, safeguarding critical data and applications against potential disruptions.

Skilled in designing and implementing high availability solutions for Oracle databases on AWS, leveraging Amazon EC2 instances, RDS for Oracle, and other AWS services.

Committed to staying updated with the latest AWS advancements and Oracle database technologies, staying at the forefront of cloud and database trends.

Skillful in pre-patch analysis, documentation preparation, and post-patch installation steps.

Recognized expert in delivering Oracle Database performance-tuning services, using tools such as EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, and ORADEBUG across multiple Oracle versions (10g, 11g, 12c, and 19c) for comprehensive performance analysis.

Generated and analyzed STATSPACK, AWR, ADDM reports, and monitored database statistics to fine-tune database performance effectively.

Proficient in using Ansible to automate configuration management tasks, ensuring consistent and reliable server configurations.

Proficient in SQL coding, including DDL and DML operations, with expertise in optimizing SQL queries for enhanced database performance.

Proficient in designing Logical and Physical data models using Erwin modeler for new projects.

Skilled in various database techniques, including Data Compression, Table Compression, OLAP Compression, Health Check Monitoring, Flashback Data Archive, CRS, and ASM.

Utilized Oracle 11g features like Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, and 11g Grid Monitoring.

Proficiency in Oracle development tools, including TOAD, Oracle Reports Builder, Forms 6i, SQL Developer, SQL*Plus, Oracle Enterprise Manager (OEM), Crystal Reports, and PL/SQL Developer.

Experienced in cross-platform migrations, such as Windows to Linux and Solaris to Linux.

Proficient in Golden Gate implementation, including software installation, High Availability setup, replication between environments, data filtration, and collision handling.

Implemented modular and reusable Terraform configurations, improving code maintainability and facilitating team collaboration.

Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.

Proficient in SQL and PL/SQL coding, including stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, and both Logical and Physical database design.

Designed and developed database applications and data warehousing solutions for business intelligence.

Strong ability to work both collaboratively in teams and independently.

TECHNICAL SKILLS:

Operating Systems:

LINUX, SOLARIS, MS-DOS, NT, Windows 95/98/XP/7/10/11, Windows Advanced Servers 2000/2003.

Databases:

Oracle 19c,12c,11gR2, 10gR2 RAC, 9i, 8i, SQL Server, MYSQL

DBA Tools:

SQL Developer, SQL*Loader, TKPROF, Toad, Oracle Goldengate, Control-M, Tortoise SVN, Fortify 360, Putty. TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) /12/13C Grid control (RAC), RAT.

Tools and Utilities:

Export/Import, RMAN, Data Pump, Winscp3, ERWIN.

Languages:

C, C++, JAVA, Unix shell scripts, PL/SQL, Perl.

RDBMS Tech:

Oracle 8i, 9i, 10g, 11g,12c,18c,19c RAC and Standby Database, MYSQL

Web Tools:

HTML and XML, APEX, SQL NET, ODBC, TCP/IP. Oracle Agile (9.3.3), OBIEE 10g, Oracle GTM 7.

Terminal Emulation:

Putty, Telnet, FTP

Client: Wellmark, Dallas, TX August 2020 - Current

Role: Sr Oracle DBA

Responsibilities:

Provided round-the-clock support for the production environment, overseeing data extraction, loading, and transformation in the Data Mart. Conducted remote monitoring and optimization of database processes for the client.

Managed schema, tablespace, and user administration tasks, including user creation.

Implemented and maintained security controls within Oracle EBS, safeguarding sensitive business data.

Worked on Oracle database and products administration under AIX, Linux and Windows.

Installed, configured, and managed Oracle Database 21c environments.

Designed and implemented microservices-based architectures for Oracle applications, using technologies such as Oracle Cloud Infrastructure (OCI).

MySQL database backup and recovery strategies and Replication and synchronization.

Created, tested, MySQL programming, forms, reports, triggers and procedures for the Data Warehouse.

Created database application using MySQL as the database to monitor customer profiles and complaints.

Experience supporting both OLTP and Data Warehouse environments.

Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.

Proficient in writing scripts and code for custom ETL processes when the complexity or specific requirements necessitate a tailored approach.

Configured Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data.

Wrote and executed the automated Unit Testing (UT/PLSQL) and String Testing scripts for the ETL files and PL/SQL Reports files.

Experience in supporting ASM instances and provisioning and de-provisioning capacity to ASM.

Experience with EDB Postgres Advanced Server

Applied patches using OPATCH and Patch sets via OUI (Oracle Universal Installer).

Implemented disaster recovery plans for data protection.

Managed daily Oracle Enterprise Manager (OEM) support, including the installation of OEM agent 13.3 and 13.4 using manual clone methods. Upgraded both OMS and OEM agents from 13.3 to 13.4.

Optimized queries and tuned applications for improved performance.

Led the architecture and migration of large Oracle databases.

Conducted SQL tuning and assisted developers with PL/SQL coding.

Used advanced features of T-SQL to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.

Collaborated with Application Database Administrators in database design.

Installed and implemented backup and recovery procedures.

Created and maintained various shell scripts for database maintenance tasks.

Installed Ansible Tower and used it to manage systems.

Implemented modular and reusable Terraform configurations, improving code maintainability and facilitating team collaboration.

Successfully migrated standalone databases to RAC on Exadata.

Worked with AWS cloud-based database environments, demonstrating expertise in both physical and logical database structures.

Provide and implement performance tuning recommendations of all components in Exadata database machine.

Monitored performance metrics using Amazon CloudWatch.

Implemented monitoring and observability solutions for microservices and Oracle 19c and 21c databases.

Integrated Oracle databases with microservices using efficient data access patterns and messaging protocols, reducing coupling between services and improving overall system performance.

Migrated On-premises Oracle database to EC2 instances on AWS for Dev, Test and Prod databases.

Worked on EC2 instances, S3 buckets, VPC and IAM groups.

Use Amazon RDS to manage, create snapshots, and automate backup of database.

Written automation scripts for creating resources in OpenStack cloud terraform modules.

Participated in designing and deploying multiple applications utilizing AWS technology stacks.

Proficiently managed security administration and effectively utilized available storage space.

Applied expertise to optimize and fine-tune SQL queries through TRACE FILE analysis.

Developed "Stored Procedures and Triggers" based on business plans using PL/SQL.

Automated data loading processes using Korn shell scripting and SQL*Loader.

Configured Oracle GoldenGate for various data replication scenarios, including one-way, two-way, active-to-active, and active-to-passive setups.

Skillfully upgraded Oracle GoldenGate from 19c to 21c, including configuration for high availability in RAC environments.

Installed Jagent and configured Oracle GoldenGate targets within Oracle Enterprise Manager (OEM) for streamlined monitoring and management.

Actively contributed to the analysis and design phases of Oracle Exadata Server implementations to optimize infrastructure performance.

Environments: Oracle 19c/21c, TOAD, RMAN, T-SQL, SQL server, Goldengate OEM, AWS, ETL, Aurora, EC2, S3, RDS, Grid Control, Golden Gate, Citrix, windows, Terraform, Exadata and ASM.

Client: Navient, Indianapolis, IN April 2017 – July 2020

Role: Sr Oracle DBA

Responsibilities:

Created scheduled backup scripts and standardized backup processes.

Performed database installations and upgrades.

Proficiency with scripting languages such as BASH, KSH, PowerShell or Python

Proficient in cold and hot backups and recovery procedures.

Installed and set up databases from scratch.

Managed user accounts, granting privileges, roles, and profiles.

Highly proficient in active data guard, RMAN, RAC, GDS.

Implemented multi-model database solutions using Oracle 21c.

Decomposed monolithic Oracle applications into microservices, defining service boundaries.

Experience supporting both OLTP and Data Warehouse environments.

Designed and developed SQL procedures, focusing on optimizing query performance.

Experience in implementing Oracle wallet TDE for data security for single and RAC databases.

Designed Conceptual Model as an architectural migration target for new LRT ODS model and redesigned the key structures of the Data Warehouse (tables, MVs, Indexes).

Created materialized views, rebuilt indexes, and managed partitioned tables and Index-organized tables.

Established new development and QA environments, including deployments and migrations. Also, conducted database cloning for development and testing purposes.

Collaborated with cross-functional teams to analyze, design, and implement enhancements to Oracle EBS.

Involved in ETL Development using native Oracle tools (Oracle PL/SQL).

Experience in Configuring and Integrating the Servers with different environments to automatically provisioning and creating new machines using Ansible.

Managed and administered geospatial databases, optimizing performance, and ensuring data security and backup procedures.

Implemented robust backup and recovery procedures for geospatial databases, ensuring data integrity in the event of system failures.

Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.

Utilized Oracle EBS reporting tools for generating actionable insights and performance metrics.

Provided maintenance for user accounts, privileges, profiles, and roles, including the creation of materialized views and index rebuilding.

Hands-on experience in configuring snapshot and incremental backups for Cassandra databases.

Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.

Used terraform to write Infrastructure as code and created Terraform scripts for EC2 instances, Elastic Load balancers and S3 buckets.

Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.

Knowledgeable in Oracle Golden Gate, including its internal mechanisms and new features such as Integrated Capture, native DDL capture, coordinate apply mode, and multi-threaded replicate.

Developed lag monitoring scripts and configured Golden Gate monitoring plug-ins in Oracle Enterprise Manager (OEM) 19c.

Created and maintained Ansible playbooks and roles for various tasks, including application deployment, system updates, and security hardening.

Installed and configured High Availability Oracle Golden Gate (OGG) systems in Oracle 12c and 19c RAC environments.

Implemented high availability solutions using Oracle RAC and managed Physical and Logical Standby databases (Data Guard).

Conducted database recovery from media failures, accidental drops, and data block issues.

Successfully implemented Backup and Recovery using RMAN, including hot and cold backups to various storage media.

Environments: ORACLE 11g, 12c, SQL, ETL, T-SQL, PL/SQL, Ansible, Goldengate Import/Export, RMAN, RAC and ASM, Kornshell.

Client: Principal Financial Group, Des Moines, IA Jan 2016 – March 2017

Role: Sr Oracle DBA

Responsibilities:

Configured and supported Exadata and clustered Linux servers hosting Oracle 11g and 12c RAC databases. Managed upgrades and maintenance of Exadata hardware.

Implemented Enterprise Manager Grid Control (11g and 12c) for monitoring and established Physical Data Guard in Maximum performance mode for disaster recovery.

Installed and maintained Oracle 11g on LINUX and Windows platforms, introducing new features like Automatic Storage Management, RAC, Flashback features, and ASMM for improved performance.

Administered single-node and RAC 11g and 12c Oracle databases on Linux and Solaris, executing cross-platform migrations.

Utilized Grid Control to manage multi-node RAC databases, including redo and undo management and load balancing.

Implemented and analyzed Oracle CRS, MSSQL database refresh, and migration processes.

Established High Availability 11g and 12c RAC Linux clusters and monitored database backup using RMAN.

Performed database restores using RMAN, hot backups, cold backups, and Export/Import. Developed, documented, and tracked test cases.

Applied patches to RAC and Standby databases as needed and conducted SQL procedure development and query performance tuning.

Implemented high availability solutions with Oracle 11g RAC and Physical and Logical Standby databases using Data Guard.

Participated in deployments, migrations, database cloning for development and testing, and table partitioning.

Investigated recent SR (Service Request) reports and managed SR filing, tracking, and reporting.

Managed Oracle RAC database configurations with Veritas Cluster Server (VCS), Golden Gate, and Data Guard.

Evaluated backup and recovery methods based on organizational needs, implemented various scenarios, and documented them for reference.

Developed and implemented OIM (Oracle Identity Manager), OVD (Oracle Virtual Directory), OID (Oracle Internet Directory), and some Oracle databases provisioning from OIM to OVD.

Installed OEM agents and managed databases using GRID Control 11.1 or 12c EM. Conducted database monitoring and performance tuning using OEM.

Migrated databases to Exadata and monitored Exadata using EM12c.

Maintained user accounts, privileges, profiles, and roles, while also creating materialized views and rebuilding indexes.

Established new development and QA environments and used Flashback table for table restoration.

Developed and maintained several shell scripts for database activities and provided weekly server memory reports.

Implemented "Stored Procedures and Triggers" based on business plans using PL/SQL and conducted SQL tuning, assisting developers with PL/SQL coding. Performed SGA tuning.

Led database security audit vulnerability assessment and remediation projects, as well as architecting Golden Gate.

Installed, configured, and supported uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing Golden Gate.

Environments: Oracle 11g,12c with RAC and ASM, Pl/SQL Developer, Data Guard, AWR, ADDM, OIM,

Exadata, UNIX, OVD, Oracle CRS, OEM, RMAN, Export/Import, ASM Packages VERITAS Cluster Windows

2003.

Client: Cisco RTP, Hyderabad, India September 2014 – December 2015

Role: Oracle DBA

Responsibilities:

Acted as Subject Matter Expert (SME) for SAP application database datacenter migration, overseeing more than 100 databases.

Gathered information from clients about their Oracle database environment in preparation for migration and transition.

Installed and maintained Oracle databases, including versions 11g, 10g, and 9i on Aix 7.2 and Oracle 11g on Windows 2008.

Configured and implemented both Bi-directional and Uni-directional replication using Golden Gate for data replication, resolving replication issues as they arose.

Successfully upgraded Oracle databases from 9i to 10g and 10g to 11g using manual methods and the DBUA (Database Upgrade Assistant).

Migrated Oracle 10g to 11g databases from HP-UX to AIX servers using Datapump, RMAN (Recovery Manager), and Golden Gate.

Implemented data guard for maximum availability, protection, and performance configurations, managing Data guard failovers and switchovers.

Administered and supported Oracle databases post-migration.

Provided developer support, troubleshooting, and performance tuning, including analysis of the System Global Area (SGA), resolving latch contention issues, optimizing disk subsystems, and tuning SQL queries and custom views.

Refreshed data from production to non-production environments at the request of the application team using Datapump utility.

Conducted application tuning by optimizing queries, identifying problematic code, creating indexes, rewriting queries, and using materialized views while gathering essential statistics on objects.

Implemented database security measures and managed role-based security.

Applied the latest Patch Set Updates to Oracle databases.

Developed and modified UNIX shell scripts for Oracle environment management, including RMAN backups.

Managed database and transaction log backups and restorations, backup scheduling, and user security. Conducted system and user database backups and restorations as required, creating database users and roles, and implementing appropriate security measures.

Environments: Oracle 11g,10g and 9i, SAP, Performance Tuning, Golden Gate, Data Guard, AIX 7.2,

Windows 2008 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader,

TOAD, Avamar, Datapump, Shell Scripting.

Client: Polaris, Hyderabad, India June 2013 to August 2014

Role: Oracle DBA

Responsibilities:

Migrated Oracle 11g databases from on-prem IBM AIX servers to AWS RDS 12C and 19c using Datapump utility.

Configured and provided support for 12C databases on Amazon RDS, creating instances based on requirements.

Supported 4-node Oracle 12C and 19c RAC on Linux.

Troubleshot performance issues in RAC instances.

Provisioned and supported databases on AWS RDS in a multi-Availability Zone (AZ) environment for automatic failover and high availability.

Archived historical data in Amazon S3 buckets.

Actively participated in quarterly RDS switchover activities for disaster recovery compliance.

Conducted backup and restore of snapshots in RDS instances.

Explored Attunity replication technology as a replacement for Golden Gate in a proof of concept.

Implemented Amazon RDS multi-AZ for automatic failover and high availability.

Proficient in writing Cloud Formation Templates (CFT) in YAML and JSON formats for AWS service provisioning as Infrastructure as Code.

Implemented Oracle Physical Data Guard in Maximum performance mode for disaster recovery and maintained primary and standby databases.

Conducted performance tuning using AWR, ADDM, ASH, TKPROF, SQL TRACE, and EXPLAIN PLAN reports.

Monitored performance metrics using Amazon CloudWatch.

Resolved SQL performance degradation issues in RDS instances using SQL plan baselines.

Utilized JIRA in an agile work environment.

Configured and supported various Golden Gate topologies, including Broadcast and Cascading.

Supported Oracle 12C Active Data Guard in Maximum performance mode for production disaster recovery and maintained primary and standby databases.

Applied patches, patch sets, critical patch updates (PSUs), and updates to multiple databases.

Investigated and provided solutions for Golden Gate abend processes or lag seen in Extract, pump, and replica processes.

Monitored database-related activities using Oracle Enterprise Manager (OEM) 12C.

Environments: AWS, RDS, EC2, IBM-AIX 7.1, HP-UX 11.31& 11.23, Oracle 12C,19c Oracle RAC

, Golden Gate, Active Data Guard, Oracle Enterprise Manager 12C (OEM), RMAN, Import/Export, ASM, AWR, TOAD, Unix Scripting, SQL*Plus, PL/SQL

EDUCATION:

Bachelors in computer science, from Sri Indu Institute of Engineering and Technology.

Contact this candidate