Technical Support Assistant
Resume:
Mouni Chowdary
Oracle Database Administrator
*********@*****.***
Professional Summary
2+ years of IT experience as an Oracle Database Administrator in various fields like banking, insurance, manufacturing and having good experience in Database Administration and performed variety of tasks like Installation, Upgradation, Migration, Patches, Performance Tuning, performing all kinds of backups and recoveries. Experience in the design, maintenance, and administration of ORACLE 12c/11g and Configured Disaster recovery databases using Dataguard and replicating databases using Golden Gate, Automated RMAN Backups, Datapump using Unix Shell scripting.
Good experience in planning, Configuring and troubleshooting of ORACLE 12c/11g/OLAP databases in multiple environments.
Experience in Installation, Configuring and Monitoring of Oracle Server on UNIX, Linux, Sun Solaris, AIX and Windows Environments.
Worked on different environments like HP-UX, AIX and Oracle Linux and Windows.
Installed and Configured GoldenGate components for transaction level DDL, DML, Uni-directional and Bi-directional replication between heterogeneous environments and maintain data synchronization using GoldenGate v10, v11 and 12c
Implemented Golden Gate for Active-Active replication between the servers for high availability.
Experience in troubleshooting Golden Gate issues by using GoldenGate utilities like ggsci, logdump, defgen and investigate replication failures using ggserr.log, report files.
Good Experience in Configuring GoldenGate Integrated Capture, Integrated Replicat and converted Classic Capture to Integrated capture and Classic Replicat to Integrated Replicat.
Experience in implementing and maintaining physical standby databases, logical standby databases, active Dataguard and snapshot databases in 11g/12c.
Configured Dataguard Broker and managed standby databases using DG broker.
Implemented Dataguard with maximum availability, protection and performance configurations and worked with worked with Dataguard Fail over and Switch over cases at the times of upgradation and migration.
Experience in Troubleshooting Dataguard using Views, and dealing with scenarios like missing archive logs, applied logs with delay.
Good experience in configure Service Level Agreements for accessing standby database views and patching Dataguard in Dataguard environment.
Good experience in migrating databases with zero downtime using Golden Gate & Data Guard.
Having good experience in 11g/12c database administration in Real Application Cluster, Standalone and ASM databases.
Installed patches using OPatch utility and upgraded databases on 11gR2 and expertise in applying patches quarterly Oracle PSU and CPU patches and Experience in applying Oracle rolling patches on RAC 11g/12c environment using response file.
Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
Expertise in Designing, implementing and managing Backup strategy using Oracle Utility RMAN, Export/Import and Data Pump
Good Experience in Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 12c features in these utilities.
Solid experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full backup, incremental, cumulative backup, implementing backup and recovery strategies.
Experience in implementing databases on enterprise storage solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
Expert in configuring assistants like Database Configuration Assistant(DBCA) for creating databases, Database Upgrade Assistant(DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
Supported and provided Oracle DBA on-call after hours support for a 24x7 production environment.
Have impeccable communication and interpersonal skills and an exceptional team player.
Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
Technical Skills:
Operating Systems
AIX and windows XP/2003/2008, HP-UX, Solaris 10.
Programming Languages
C, HTML, SQL, PL/SQL,,MYSQL, Unix Shell Scripting.
Tools and Utilities
DataGuard, GoldenGate, LogDump, Defgen, RMAN, RAC, ASM, OEM, TOAD, Export/Import, Data pump, SQL Tuning/Access Advisor, SQL Performance Analyzer, DBCA, Netca.
Tuning Tools
TKPROF, STATSPACK, ADDM, AWR, ASH, SQL Tuning Advisor
RDBMS
Oracle 11g/12c
PROFESSIONAL EXPERIENCE:
Client: Express Scripts Inc, Franklin Lakes, NJ. Dec2016- May 2017
Role: Oracle DBA
Responsibilities:
Performed administrative maintenance, monitoring on Oracle database systems and Provided 24x7 support on call support on rotational basis in operational environment.
Performed Migration of databases from 11g Unix to 12c on Linux. Performed cross platform migrations using Datapump and GoldenGate.
Involved in deploying new application and setting up replication of data between the databases using Golden Gate and configured parameters for Bi-directional Replication and implemented parameters to avoid infinite loops.
Proficient in implementing CDR parameters in GoldenGate, Implemented Uni-Directional, Bi-directional replication using GoldenGate and reviewing the error logs and troubleshooting abend scenarios in GoldenGate with error reports and ggserror.log.
Performed Schema as well as Table Level Replication using Oracle GoldenGate and setup Disaster Recovery solution using GoldenGate as maximum availability Architecture.
Written Golden gate patrolling scripts for lag monitoring, Used GoldenGate utilities ggsci and logdump, defgen for troubleshooting issues.
Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases at the times of upgradation and migration.
Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status.
Configured Active Dataguard 11g & 12c and worked on snapshot standby databases.
Mass deployments of agents and registering databases in OEM 12c/13c in cloud environments.
Restored data file from primary database to standby database using RMAN recovered the standby database from the data corruption.
Performed backup and recovery. Cold backups, Hot backups, Logical backups, RMAN backups performed at different levels of Full backup, Incremental backup, Differential backups, Cumulative backups
Performance tuning of application and database, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plan, Statspack, AWR, ADDM, ASH and monitor the database performance on daily basis.
Creating and dropping of Users, granting and revoking privileges/roles to users as and when required.
Responsible for network configuration and involved in a Client –Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
Performed on-call technical support to minimize the impact of system disruptions.
Environment: Oracle12c/11g, Linux 5.8, Sun Solaris, RMAN, RAC, ASM, Dataguard, Datapump, SQL server, GoldenGate, OEM, AWR, TOAD, TKPROF.
Client: Hilti, Hyderabad, India, Aug 2013 – Sep2015
Role: Oracle DBA
Responsibilities:
Installation, configuration and maintenance of Oracle 11g databases.
Installed agent and involved in registering of databases in OEM and created AWR, ASH, ADDM reports for performance troubleshooting.
Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
Installed Standalone servers on ASM and migrated databases to ASM.
Monitoring Event Viewer, SQL Error logs and Log File Viewer for Blockings, Dead locks, Software and hardware related errors
Always monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
Generated scripts for data manipulation and validation and materialized views for remote instances.
Worked on Performance Tuning Oracle DBA (11g ) on Linux, AIX 5.2.
Responsible for network configuration and involved in a Client –Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases at the times of upgradation and migration.
Configure Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status.
Configured Active Dataguard 11g & 12c and worked on snapshot standby databases.
Performed on-call technical support to minimize the impact of system disruptions
Configured Oracle Dataguard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.
Implemented the Dataguard with delay shipping of the archive logs in order to avoid the logical corruption on the physical standby databases.
Configured disk groups with different redundancy levels and created fail groups and managing and tuning ASM parameters
Responsible for setup and implementation of 2 NODE RAC on 11g.
Used CRSCTL and SRVCTL commands for the stop / start Cluster operation
Supported Database for 24*7 and good experience with on-call rotation.
Environment:
Oracle 11g, Red Hat Linux, Dataguard, Datapump, SQL, RMAN, AWR, ASM, TKPROF, STATSPACK, OEM, Windows, SQL Server 2008, PSL/SQL
Education:
Bachelor’s of Computer Science in Nagarjuna University, India
Contact this candidate