Candidates About

 

Sai Naresh Chanamolu

Sr. Oracle Database Administrator

Professional Summary:

Over 8 years of professional experience as Oracle Database Administrator having good experience in Database Administration, Database Installation, Upgradation, Migration, Patching, Performance Tuning, RAC installation and Maintenance, setting up and Configuring Data Guard, performing all kinds of backups and recoveries, Cloning Databases, Automated RMAN backups, replicated using GoldenGate, Advanced Security, Auditing and Production Support.

 

Experience Synopsis:

§  Experienced and Proficient on Oracle (9i/10g/11gR1/11gR2/12C), installing, configuring and maintaining Oracle databases on different operating systems like UNIX (RHEL 4/5, AIX 6.1, OEL 5/6, Solaris10, HP-UX 7) for OLTP & OLAP environment.

§  Experience in configuring high availability systems like Real Application Cluster 10g/11g on RHEL 4/5.8, OEL 6.1.

§  Good Experience in performing health checks of RAC components ocr, voting files and backups using OCRCONFIG and troubleshooting issues using clusterware logs in 12c and 11g RAC Environments and handy in using utilities SRVCTL and CRSCTL.

§  Having good experience in 10g/11g/12c database administration in Real Application Cluster, Standalone and ASM databases.

§  Installed patches using OPatch utility and upgraded databases on 9i/10g/11gR2 and expertise in applying Oracle PSU and CPU patches.

§  Experience in applying Oracle rolling patches on RAC 11g/12c environment using response file.

§  Experience in managing RAC and Standalone environment 11g/12c OEM Grid Control Installing, monitoring and managing of Oracle instances using Enterprise Manager Grid Control 10g/11g/12c.

§  Having good experience in working with World Fastest Machine Exadata (x3-2), (x4-2) and implemented Exadata features.

§  Hands on experience in Planning and Implementing Disaster Recovery databases using Data Guard and configuring, managing, troubleshooting and monitoring Physical standby using Data Guard 10g/11g/12c.

§  Good experience in 11g new features Active Data Guard & snapshot standby.

§  Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and Handy in upgrading GoldenGate from v11 to 12c.

§  Good Experience in Table partitioning using List, Range, Hash, System and Interval partitioning techniques.

§  Experience in upgrading databases from 10g to 11gR2 and 11gR2 to 12c on Solaris, AIX, Linux and Windows platforms and Performed upgradation of grid infrastructure from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2.

§  Expertise in migrating databases with zero downtime using GoldenGate & Data Guard.

§  Good experience in Installing, Configuring and replicating databases using Oracle GoldenGate, implemented unidirectional and bi-directional replication.

§  Good Experience in migrating databases across platforms and migrated databases from Solaris, AIX to Linux.

§  Hands on experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.

§  Implemented User managed cloning and Flashback Technology, Performance Tuning, Experience in SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and Optimizing.

§  Performance Tuning of the database (I/O Tuning, Tuning Contentions) using Oracle 11g tools like AWR, ADDM, ASH, Advisories, TKPROF, EXPLAIN PLAN for achieving better performance.

§  Good Experience in Transparent Data Encryption Operations, Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

§  Good Experience in writing SQL Queries, PLSQL Procedures, functions, packages and used SQL hints to improve the SQL performance and implemented SQL profiles and SQL baselines.

§  Experience in implementation of enterprise databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).

§  Experience using Erwin as a Data Modelling tool & Designing the ETL processes.

§  Good knowledge on Oracle support process for technical requests using MetaLink and other support features.

§  Good written and verbal communication skills, self-motivated team player and good analytical thinking.

§  24 X 7 Production database administration, support and monitoring to ensure Proactive problem recognition and resolution of database issues.

 

TECHNICAL SKILLS:

Databases	Oracle 12c/11gR2/11gR1/10gR2/9i
Oracle Products	Oracle Real Application Cluster 12c/11g/10g, GoldenGate, Data Guard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle EXADATA, RMAN, Oracle Wallet, Transparent Data Encryption.
Operating System	Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008.
Languages	SQL, PL/SQL, Unix shell scripting.
Tools & Utilities	SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, DB Artisan Putty, ERWIN, ETL.

 

PROFESSIONAL EXPERIENCE:

Client: United Missouri Bank, Kansas City, MO                                 June 2015 – Till Date

Role: Sr. Oracle DBA

Responsibilities:

§  Worked in Datacenter migration project and worked in Infrastructure team and designed new environment to Install Oracle and GRID infrastructure on Linux.

§  Performed cross platform Migration from Solaris to Linux as apart of datacenter migration using Golden Gate with Zero downtime.

§  Installed new RDBMS versions 12.1.0.2 and applied patches by the Patch management.

§  Upgraded Oracle databases from 11g to 12c and performed cross platform upgrade using datapump and GoldenGate.

§   Performed database upgrades from 11g to 12c and applied patches in Dev, QA, UAT and production environments.

§  Configured DR databases using Data Guard, Implemented Data Guard Broker and performed various operations like Switchover, Stop and Start MRP.

§  Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.

§  Converted physical standby to snapshot standby and Active Data Guard 11g and 12c

§  Installed goldengate v11 on Solaris 9, AIX 6.1 and RHEL 7.3 from scratch and used Goldengate for database replication during migration.

§  Upgraded GoldenGate from v11 to 12c & also applied patches to GoldenGate environment.

§  Configured Uni-directional and Bi-directional topologies to support datacenter migration.

§  Investigate replication failures using ggserr.log, report files and LogDump utility.

§  Replaced Materialized views with GoldenGate replication and monitoring queries on tables.

§  Planned and implemented DR & high availability solutions using Oracle 12c Standby Database, Oracle Data Guard, 11g/12c RAC.

§  Installed, configured 3 node RAC for the 12c database and administered the 12c databases on the RAC server’s.

§  Added a new node to RAC cluster 11.2.0.4 for load balancing, Performance tuning of Interconnect and resolved contention wait types (gc blocks lost, gc buffer busy, grant 2-way) in RAC environment.

§  Applied patches in Cluster environment using Opatch auto in rolling fashion

§  Created disk groups with different redundancy levels and Created ASM volume using ASMCA and created ACFS for GoldenGate 12c.

§  Implemented GoldenGate heartbeat table for lag monitoring.

§  Configured repository database for setting up OEM 12c, used 11g,12c for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c.

§  Creation of Materialized views and partitioned the database tables to improve reporting performance.

§  Creating and managing database objects such as tables, indexes, partition tables and views.

§  Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups, manage users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager.

§  Performed Zero Downtime migrations from Non-Exadata machines to Exadata machines using Oracle GoldenGate and Data Guard.

§  Implemented 12c IN_Memory features, parallelism, Hybrid Columnar Compression on Exadata Databases.

§  Installed, configured and maintained databases on Exadata X2-2 half rack.

§  Worked on Exadata storage indexes, smart scans & smart flash cache.

§  Refreshing of databases using DataPump Export and Import utilities (expdp/impdp).

§  Proficient in Hot/Cold Backup, Recovery and Cloning of databases using RMAN and shell scripts with VERITAS Net Backup, Export and Import database schema.

§  Performing day-to-day activities of Production database such as monitoring its growth and performance and performed maintenance tasks, rebuilding indexes, gathering statistics, refreshing materialized views etc.

§  Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

§  Performed SQL tuning, System tuning, Database and Instance tuning by analyzing root causes.

§  Configuring and Handling Oracle Network files like Listener.ora, TNSNames.ora and SQLNET.ora.

§  Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption(TDE) 11g,12c and installed Database Audit vault server and database firewall and protected realms.

§  Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.

§  Provided on-call support regarding production-related database problems. 

§  Managing and providing 24X7 supports for various versions of databases.

 

Environment: Oracle 11gR2,12C, Linux 6.3 AIX – 6.1, Oracle Enterprise Manager, Grid Control, RHEL 7.3, Solaris 9, HP-UX, OEM Database control, PL/SQL, Oracle SQL Developer, Autosys, Shell Scripting, TOAD, Exadata, ASM, RAC, GoldenGate, Data Guard.

 

Client: Truven Health Analytics, Greenwood Village, CO                Nov 2012 – May 2015

Role: Sr. Oracle DBA

Responsibilities:

§  Worked on Installation, configuration, and maintenance of Oracle 10g, 11g on RHEL 4 and 11g on RHEL 6.3, HP-UX, AIX and Upgradation from Oracle 10g to 11g.

§  Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure.

§  Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database.

§  Involved in up-gradation of databases from 10g to 11g and applied patch set and interim patches whenever required.

§  Implemented Data Guard with maximum availability and performance configurations for production databases and Performed switchover and monitor using DGMGRL.

§  Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.

§  Using list partitions for large tables and bitmap indexes for the OLAP databases.

§  Scheduled Cumulative Incremental backups using RMAN Cloned databases using RMAN Utility.

§  Installation and configuration of GoldenGate and Replication of data using Oracle GoldenGate.

§  Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux.

§  Configuration of Listener and TNS names using NETCA and NETMGR.

§  Done exports and imports of tables, schemas and tablespaces with Data Pump.

§  Developed and enforced both database and OS-level security policies for data protection.

§  Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting.

§  Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases and Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.

§  Post installation process, kernel upgrade, applying support packs and add-ons.

§  Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

§  Worked on monitoring grid control database, configuration of error notifications, configuring listeners, and adding them to the grid control.

§  Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.

§  Developed Scripts for transferring data from production server to testing/development servers.

§  Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

§  Cloning of databases using RMAN and User managed techniques and Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN.

§  Configured GoldenGate Classic and Integrated components for Active-Passive and Active-Active replication between heterogeneous environments (Oracle/ Microsoft SQL Server/ Sybase) and maintain data synchronization.

§  Developed and configured GoldenGate macros for data conflict resolution, filtering and transformation, exception handlers.

§  Created SQL Loader scripts using Unix shell scripting and PL/SQL. Worked with Java Developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code of optimizations and indexes.

§  Involved in 24x7 production database maintenance and on-call support.

 

Environment: Oracle 10g,11g, Linux 6.3, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, OEM Database control, PL/SQL, Oracle SQL Developer, Shell Scripting, TOAD, ASM, GoldenGate, Data Guard.

 

Client: Oregon Department of Revenue, Salem, OR                            Nov 2011 – Oct 2012

Role: Sr. Oracle DBA

Responsibilities:

§  Installed, configured and maintained databases on high availability systems like Data Guard and Real Application Cluster environments.

§  Performed fresh installation of 11.2.0.3 RAC on Automatic Storage Management and created databases in RAC environment.

§  Installed OEM repository database, deployed agents on hosts and discovered targets and created new Groups, Templates, Incident Rule sets in OEM.

§  Configured Physical Standby, Snapshot Standby and Active Data Guard and performed Troubleshooting in Data Guard environment.

§  Upgradation / Migration of dev/test/prod databases from 10g to 11g.

§  Migrated applications from Unix to Linux using GoldenGate with minimum down time and resolved issues in GoldenGate.

§  Applied patch set and interim patches whenever required to make the database software up to date.

§  Performed upgradation of grid infrastructure from 11.2.0.2 to 11.2.0.3.

§  Performed health checks of RAC instances using CRSCTL and SRVCTL utility.

§  Monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 11g/12C.

§  Configured parameter file, Listener and Net service names manually for production and physical standby databases in Data Guard environment.

§  Migrated databases from File system to ASM & troubleshooting issues in ASM 11g.

§  Used Flashback mechanism for recovering from logical corruption of databases.

§  Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold and Logical backup plans.

§  Performed tasks like Database Sizing, Table space Management and Rollback Tablespace Management, Transaction Management and Security Administration.

§  Cloned databases for development and test environments using RMAN.

§  Taking periodic Backup of the Database using RMAN and supporting VERITAS NetBackup Team.

§  Creation of Users and granting them the required Roles and Privileges accordingly and Involvement in space management, rectification of lock problems, managing quotas.

§  Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects and Rebuilding indexes for better performance of Oracle database.

§  Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

§<span style="fo