SUMMARY

• 8 years of professional experience in IT industry as an Oracle database administration in Linux, UNIX and Windows platforms.
• Experience includes design, build, test and supporting next - generation database solutions in Oracle enterprise.
• Proficient in Database Administration, Database Installation, Upgradation, Migration, Patching, RAC installation, setting up and configuring DataGuard, Databases clone, Performance tuning and monitoring the database using OEM Grid Control, RMAN backups, GoldenGate replications, product support.
• Extensive experience in working on Shell/Bash/Perl scripts for patch automation in Single-Instance/NON-RAC/RAC using RUNDECK server.
• Design, documented, and deployed many infrastructure projects managed cost and cost avoidance for the client significant. Solutions proposed, architected, deployed include HP-UX to Linux platform migration, New oracle VM farm, disk snapshot and clones, advanced compression, Real Applications Clusters (RAC), Database migrations.
• Expert with planning, creation, administration and troubleshooting of ORACLE 12c/11g/10g OLTP (multiple instances)/OLAP Data Warehouse databases in production.
• Implemented DataGuard with maximum availability, protection and performance configurations and worked with DataGuard Fail over and Switch over cases at the times of up gradation and migration.
• Hands on experience with Banner 8/ Banner 9, ESM, ODS, EDW, App Navigator, Banner upgrades, patching, oracle web-tire and middle tire application, Web-logic server, Tomcat, Apache.
• Implemented Active DataGuard for querying on standby to load balance the databases, snapshot standby databases for testing objects performance. Troubleshooting DataGuard using dynamic views, troubleshooting missing archive log scenario using Incremental backup, patching DataGuard environment.
• Expertise in Installing and configuring transactional level DDL, DML, BI-DIRECTIONAL replication using GoldenGate v11 and v12.
• Expertise in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and configured Goldengate extract and replicate during the database character set conversion.
• Implemented Coordinated Replicat in GoldenGate with maximum performance depending on threads availability for large transactions replication in 12c.
• Experienced in Cross Platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using GoldenGate with Zero downtime.
• Expertise in Oracle spatial scripts (PLSQL/SQL, Javscript): custom PL/SQL scripts and optimized SQL queries for working with oracle spatial, Oracle map builder and Oracle MapViewer.
• Utilized Google Maps API to visualize data delivered by spatial database engine. This effort was implemented using both Maps API for Flex / ActionScript and from a GWT project.
• For confidentiality and security purpose created password Wallet to avoid the password in the GoldenGate parameter file of the process.
• Hand on experience in advanced replication (Oracle Streams) to replicate data between production databases for local and downstream capture architectures.
• Expertise in monitoring database servers and optimized database performance using various tools such as Oracle Enterprise Manager (OEM), Oracle Grid Control.
• Expertise in deploying agents from OEM, patching OEM, performing administrative tasks using OEM, AWR, ASH reports, scheduling jobs using Auto sys, blackout scheduling, SQL tuning advisor to tune sql’s on databases.
• Performed Data Redaction, Data Masking and configured Database Vault in 12c using grid control (OEM) to protect sensitive data.
• Using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for EventWaits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, Creating Views & Materialized Views.
• Expert in Oracle Appliance such as ZFS Storage, Creating Snapshots, Creating Clones.
• Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN, Snap Level backups.
• Expertise in installation, configuration of Oracle in Aws Ec2-Console. Migrated development and production databases from data center to AWS RDS on oracle platforms. Troubleshooting performance related issues in AWS Oracle data warehouse environment.
• Good experience with AWS DMS, database tuning, caching application architecture of cloud computing & administration of EC2, auto scaling, Oracle 12c Cloud Control, BMC Tools.
• Experienced in functional and technical aspects of Oracle E-Business Suite/ Applications 10g and 11i deployment Requirements, Coding and Development. Also, supported EBS Financial, WebLogic Middleware Stack and Oracle Fusion Middleware.
• Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN).
• Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and nocatalog methods. Recovered dropped tablespace using RMAN performed TSPITR on dropped tablespaces.
• Hands on Experience in Data Center Migrations, Disaster Recovery Testing and Migrate/Convert Standalone Databases to RAC Databases and to ASM Storage.
• Performed tasks on RAC like Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover.
• Converted RDBMS and ASM instances to EDT time zone during daylight saving in RAC and stand-alone configurations. Converted data in DATE datatype columns to EDT time zone.
• Experience in applying Oracle rolling PSU and CPU Patches Quarterly on EXADATA RAC 11g/12c environment using response.
• Experience on Oracle Hybrid Columnar Compression with Exadata and ZFS Storage and Oracle Storage in production environments with Oracle Data Warehouses.
• Expertise in Oracle Transparent Data Encryption (TDE) such as Defining Keystore, Creating Wallet, Generating Master Key, Enabling Autologin, Rotating Master Key Encryptions.
• Migrated databases into Exadata Machine with minimal downtime using DataGuard.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics, Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms, OEM GC, Cost Optimizer, SQL analyzer, Performance Manager, Stats pack, scrutinizing the long-running SQL queries.
• Worked on Informatica Data Replicator (IDR) tool to optimized ETL procedures and removed load, query performance bottlenecks by using explain Plan.
• Have Ability to function independently and plan, evaluate and design solutions to problems and Ability to work well in a group environment.
• On-call team rotation and support: investigate, troubleshoot problems related to performance of database under SLA, perform root cause analysis (RCA) for high severity incidents in relation with problem management requirements for corrective actions

TECHNICAL SKILLS

Databases: Oracle 12c/11gR2/11gR1/10gR2/9i, SQL 2012/2008R2, MYSQL 5.7

Oracle Products: Oracle Real Application Cluster 12c/11g/10g, GoldenGate, DataGuard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle Streams, Oracle 10g/11g/12c (Grid Control), Oracle EXADATA, RMAN, Oracle Wallet, ZFS, Transparent Data Encryption, Oracle Enterprise Manager (OEM) 11g,12c,13c.

OperatingSystem: Red Hat Enterprise Linux (RHEL) 4.x, 5.x, 6.x, Oracle Linux, HP UNIX 11i, AIX 6.1, Sun Solaris 5.8, 5.9, 5.10, Windows XP/2003/2008

Languages: SQL, PL/SQL, Unix shell scripting, Java, C, .Net, Python.

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, TKPROF, AWR, ASH, Toad, Oracle SQL Developer, ERWIN, ETL

PROFESSIONAL EXPERIENCE

Confidential - Cleveland, Ohio

Responsibilities:

• Completely automated the patching process for more than 300 single instance Oracle 12cR1 databases by using shell scripts/bash scripts/python/Rundeck server (out-of place approach).
• Completely automated the patching process on all 12c Dataguard sites (Including Active Dataguard) by using shell scripting and rundeck.
• Performed RAC/NON-RAC with ASM and grid home patching is automated by one shell script.
• Working with QAD team for Valspar integration of sites in to the client EXADATA systems.
• Performed latest Oracle 12cR2 upgrades on production sites.
• Worked on MYSQL database issue and maintained cloud control of mysql. Also, contributed the MYSQL performance tunings and optimization.
• Worked on APEX upgrades and issues. Also, Implemented job schedules using RUNDECK.
• Extensive experience in authentication of oracle12c database using the existing Active Directory. Also, performed Enterprise user security (Advanced security).
• Implemented 12c new features more than 200 sites.
• Working on 18c autonomous data driven system and preparing the blue print for upcoming upgrades.
• Maintained and fixed the issues related to the Dataguard and Goldengate that supports EBS.
• Involved in Production Support call 24/7 for more than 300 sites.

Confidential - Maitland, Florida

Senior Oracle/Cloud Solution Engineer

Responsibilities:

• Installed, configured, and maintain Oracle based technologies and any required technologies in support of Banner and its components.
• Good knowledge in performing Banner upgrades on all modules general, finance, human resources, from lower version to higher versions.
• Used NX-client, Remote desktop, CISCO any connect to access the customer sites to resolve there issues on time.
• Performed Banner 8 to Banner 9 upgrade on all modules like student, finance, general etc.
• Worked on Banner 8 and Banner 9 issues and troubleshot the issues related to Job sub server and Banjob. Also, worked on banner 8 administrative forms, banner self-service.
• Installed ODS, ESM and maintained the entire process for Confidential AMS and AHS and TM clients. Also, worked on Ansible Setup, Juniper access, Any connect CISCO.
• Worked on Service now (SNOW) ticketing tool for Incident management integration and generating CR (change requests) for PROD environment tickets.
• Experience with Database schema management through DDL and DML, work on db support (oracle and mysql). Experience working with Linux servers and windows servers depending on the AMS or AHS for the Confidential clients.
• Maintain the Cloud components of the Unified Digital Campus (UDC) technologies such as: Banner XE, ESM, Degree works, ODS, EDW, Workflow, Touchnet, BEP, eTranscripts.
• Worked on implemented Cloud Solutions on AWS utilizing EC2, creating & configuring the S3 buckets, IAM, ECS, RDS etc.
• Responsible to maintain the networking from the AWS cloud back to connectivity.
• Managing the process and tools used for the process used for builds to ensure the organization's CM process.
• Worked with team on Weblogic 11g application servers and HTTP servers and OHS for enabling the admin UI for clients.

Confidential - New York

Senior Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintainedOracle11gR2, 12c on Linux and also Upgraded from11g to 12c, and refreshedOracle11gR2 andOracle12c databases using file system for storage to ASM.
• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, DataGuard and also, responsible for setup and implementation of 3 Node RAC on Linux in 12c.
• Hand on experience with Oracle Spatial Data Management.
• Installed OEM 13c cloud control Agents on database 12.1.0.2 and Monitoring databases using Grid Control 12c and 13c for Configuration of error notifications. Database monitoring/health check alert scripts for database uptime/down status, and sizing issues using grid control (OEM).
• Configured Oracle Streams in One Way Setup and Bi Directional Setup. Implemented Disaster Recovery database 12c DataGuard on physical standby database in maximum performance mode.
• Configured DataGuard Broker, fast start failover and used for switchover and stopping and Starting Media recovery process, Instance status, check queries, Top wait events, redo transport status and Performed Disaster Recovery testing.
• Upgraded databases in Dataguard Environment from 11gR2 to 12c for primary and standby.
• Installed GoldenGate for replication of database on 12c RAC environment and Configured parameters for the Bi-directional replication to provide uninterrupted service in case of RAC instance/ node failure.
• Converted databases from ZFS filesystem to ASM filesystem. Supported Oracle Cluster series using ZFS Storage Subsystem.
• Introduced Oracle Advanced queuing technique in the database for the Java based applications to trigger the processes based on Oracle Advanced Queueing Technique.
• Configured a real-time downstream capture processes using GoldenGate and Active DataGuard.
• Used Logdump Utility to Investigate data on the trail and fixed the abended process by outer repositioning the process, defgen utility to create definition files in GoldenGate.
• Configured GoldenGate as CRS resource to provide uninterrupted service of RAC instance node failure and Implemented basic tasks on RAC like Mirroring OCR on different ASM diskgroups, Tuning Node Evictions by setting disktimeout, reboot time, miscount.
• Upgraded 11g RAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL.
• Implemented GoldenGate Replication 11g/12c on ACFS and configured for Automatic failover of GoldenGate process and upgraded GoldenGate from v11 to v12. Configured Integrated Extract, Integrated replicat and coordinated replicat on Oracle multitenant database 12.1.0.2.
• Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied patches to GoldenGate environment 12.1.0.2.
• Upgrading GoldenGate from 11g to 12c and troubleshoot the several issues on GoldenGate using ggserrorlog, using log dump utility. Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate.
• Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault, and Database Firewall.
• Configure and build heartbeat monitoring in GoldenGate and process improvement for GoldenGate by proactive monitoring using Shell scripts.
• Experience in Metadata Modelling at three layers (Physical, Business and Presentation) using the Oracle BI Administration in OBIEE
• Performed EBS R12 plaftform migration from AIX to Oracle Linux
• Have a good experience in administering Oracle Aws RDS components. Installed Oracle 12C on Linux platform in a data warehouse in AWS environment.
• Monitored databases performance usingOracleEnterprise Manager (OEM) 11g/12c Grid control.
• Implemented ASM on RAC and stand-alone databases, managed disk groups with ASM.
• Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.
• Used Different RAC utilities: raccheck, orachk, oratop, TFACollector, ocrconfig, OSWatcher, Srvctl and Crsctl and resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Configured AWS EC2 redshift Instances using AMIs and launched instances. Created highly available and scalable infrastructure in AWS cloud by using various AWS services like EC2, VPC, RDS.
• Expertise with EXADATA(X5-2) RAC and having good Experience with Oracle for Exadataor Database Appliance hardware issues. Expertise in Oracle forExadata.
• Worked on single Command configuration on Exadata Machines. Knowledge to support Oracle Cluster machines using ZFS Shared Storage Subsystem.
• Worked with Informatica Data Replicator (IDR) tool during Extraction/Transformation/Loading using Informatica Power Mart/Power Center with flat files, Oracle, Exadata and Teradata. Good understanding of ETL/Informatica replication. Worked with Informatica developers to export utilities in exadata.
• Created volumes on ASM disk groups and maintaining ACFS Cluster File system in RAC.
• Applied rolling patches to fix known bugs as well as PSU.
• Implemented advanced features of Oracle 11g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning
• Extensively worked on Enterprise Data Warehouse (EDW) to ensure that Extract Transfer and Load (ETL) processing was completed. Participate and assist in meetings as a member of the Data Warehouse team and completed tasks in specified sprints.
• Efficient in using theOracleTools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Use Oracle Metalink Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support.
• Developed UNIX shellscripts to monitor various events in the database and also to maintain and cleanup oraclegenerated files/logs.
• Monitoring Locking Activity/Long Running Transactions/Temp issues/UNDO Issues/RMAN Backup Issues/Tape Issues/DR Recovery Issues/monitor ORA errors like ORA-7445 and ORA-600 and apply patches if required or contact Oracle Support for Additional Information (by raising SR) Replication Maintenance.
• Worked on databases ranging from 2TB to 10TB and participated in monthly on-callDBAschedule.
• Generating Weekly Adhoc reports. Tasked to complete Adhoc & weekly data requests for a variety of quality assurance processing.
• Provided on-call support 24x7 for any issues with system by receiving text messages when an issue arose and logging in remotely to resolve those issues.

Environment: Oracle12c/11g, Oracle EXADATA X5-2 HALF RACK, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, Oracle ZFS NAS, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL GoldenGate, Linux 5.8, Sun Solaris, Red Hat Linux, RMAN, SQL server, DataGuard, GoldenGate, OEM, Grid Control, STATSPACK, AWR, Exports/Imports, Oracle-Wallet-Management, WebLogic server, Fusion Middleware, PL/SQL Tuning, Data Pump, Business Objects, putty, TOAD 11.6.

Confidential - Boston, MA

Senior Oracle Database Administrator

Responsibilities:

• As an Oracle DBA, Supported Educational Testing Center by implemention of High Availability solutions withOracle11g RAC, Standby Database (Active DataGuard) to ensure high availability, data protection and disaster recovery for enterprise data.
• Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database.
• Implemented and Installed Level 3 OEM Cloud Control 12c on Linux machine. Installed WebLogic server 10.3 during the Installation of Cloud Control 12c. OEM Cloud Control 12c Agent installations, plug-ins installations and adding targets to OEM, configure new databases for monitoring, Setup jobs, alerts, notifications etc.
• Supported University systems with Confidential Banner ERP systems within and outside of the organization. Upgraded all databases from 11.2.0.4 to 12.1.0.2 using Banner application in Oracle Databases by following Confidential schedule.
• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Configured RMAN backups using NetBackup and DDBoost, Experience in backup and recovery. Cold backups, Hot backups, Logical backups, RMAN backups performed at different levels of Full backup, Incremental backup, Differential backups, Cumulative backups.
• Design and implement Oracle Fusion Middleware components for systems integration on WebLogic 11g and OAS 12c platforms.
• Missing archive log scenarios in Dataguard environment resolved by restoring archive logs from backup and incremental backups through RMAN
• Implemented the DataGuard with delay shipping of the archive logs in order to avoid the logical corruption on the physical standby database.
• 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.
• Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Planning Recovery Procedures and Performing backups in both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
• Expertise in upgrade process from 10g to 11g and 11g to 12c and data migration using Expdp and Impdp. Identified and fixed the logical block corruption using RMAN & logical backup using Data pump Expdp and Impdp Utility.
• Knowledge in Oracle Retail suite of Merchandising and Store level applications such as RMS, RPM.
• 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.
• Performed cross platform migration of databases from IBM - AIX, Solaris, HP-Unix to Linux 11g using RMAN, FLASHBACK and Data Pump.
• Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.
• Worked with developers on preparing, testing and deploying application releases to non-production and production environments.
• Worked closely with application and development teams to resolve production issues. Created database services for different applications. Applied one-off patches to fix problems, upgraded Grid and RDBMS software to higher versions.
• Participated in installation and support of Oracle Financial Accounting Hub (FAH) application.
• Attended Developer’s code review meetings and Iteration meetings made recommendations to improve Efficiencies.
• Expertise in optimizing SQL queries by reading Explain Plan Statistics, developed backend interfaces using PL/SQL Packages, Stored Procedures, Collections.
• Upgraded the Oracle 11g database to 12c version and also applied patch set and interim patches whenever required to make the database software up to date.

Environment: Oracle11g/12c, BANNER- ERP, DataGuard, ASM,Banner, OracleEnterprise Manager(OEM) Grid Control 12c, 11g, GoldenGate, RMAN, SQL PLUS, PL/SQL, Toad 9.5, LINUX 4,5 and 6, Solaris.

Confidential - Harrisburg, PA

Oracle Database Administrator

Responsibilities:

• Configured and tested Replication using GoldenGate where Source Database on Sun Solaris 10 SPARC 64 bit withOracle11g and Target Database on Linux with Red Hat Enterprise Linux Server release 5.4 withOracle11g Database with 2 nodeRACon ASM.
• Created Oracle package for roadmap Generalization using Oracle Spatial that produces smoother map borders that corrects data errors.
• Installed and configured Oracle spatial database application simulating a system to keep track of all the transport services, for department of transportation and performed backup files, point in time recovery and remote backup of spatial databases.
• (SAN/NAS). Used Oracle utilities like IO Calibration to understand the response time of storage and report to SAN if response time is more.
• Deployed agent and implemented GoldenGate plugin in the OEM to monitor the GoldenGate.
• Configured integrated replicat by converting the classic replicat to improve the performance of the process in the GoldenGate.
• Adding a new node to RAC cluster and installed Oracle RDBMS software on new node of cluster and created ASM volume using ASMCA and created ACFS for GoldenGate 11g.
• Divided replicated tables among multiple GoldenGate processes to speed up performance.
• Troubleshooting typical Oracle GoldenGate technical problems such as unique key violation long transaction abending by using GGSCI, Logdump, discard file analysis etc.
• Installed configured and maintained databases on high availability systems like DataGuard and Real Application Cluster environments. Setup and maintain Oracle DataGuard (Physical) with Fast Start Failover, Active DataGuard.
• Configured Oracle DataGuard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing.
• Setup multiple DataGuard Setups (DataGuard Broker-DGMGRL) for 2 Node 11g RAC Clusters.
• Managed the centralized storage technologies including the various SAN and NAS environments.
• Involved in Configuration of 2 nodesRACon Red Hat Enterprise Linux Server release 5.4 with Oracle11g on ASM and performing health checks on RAC using SRVCTL and CRSCTL.
• Extensive experience with Database Cloning and Refreshing pre-prod databases.
• Managed and monitored the Oracle Real Application Cluster running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Worked closely with system administration and network teams to ensure standard and consistent platform, storage provisioning and configuration. Apply patches and bug fixes. Design and implement new functionality. Converted standalone databases to RAC.
• UsingOracleData Pump utility and performed Database Migration and Upgradation of databases.
• Developed Recovery Manager (RMAN) scripts for database backup and recovery for hot and cold backup options for bothRACand standalone instances.
• Trouble shooting various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, instance, memory, OS and java calls.
• Expertise in analyzing database objects, creating indexes, creating materialized views, Store Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.
• Experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups and data transfer using Data Pumps and Export/Import utilities.
• Experience in Data migration Projects which uses SQL Developer, PL/SQL programming, coding Procedures, triggers and functions.
• Good Knowledge in Installing, Configuring, Upgrading MySQL 5.0/5.6/5.7 databases running on OEL
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Maintenance: Setup cron jobs to monitor database status and to alert on-call DBA, to backup databases, to monitor space usage, and to generate status reports. Refresh non-production databases using Oracle export and import, using RMAN restore and recovery. Provide 24/7 general database support.

Environment: Oracle 11g RAC& 11gRAC, SAN/NAS, OEM Grid Control, Sun Solaris, HP-UX, RHEL,Windows 2000/XP, RMAN, TOAD, RATIONAL ROSE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM.

Confidential

Junior Database Administrator

Responsibilities:

• Installation, Maintenance and administration of Oracle 10g on Red hat Linux, Windows, AIX,
• Used Enterprise Manager for diagnostic summary, CPU utilization, wait events, alert log errors etc.
• Installation and maintenance of Oracle 10g DataGuard and Standby database setup via DataGuard.
• Experience in Creating Physical Design Data Models using Erwin Tool.
• Worked with securing database environments with network protocols.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links.
• Developed PL/SQL programs for the conversion of Org Level item Update into Oracle database. PL/SQL programs for the conversion of Master level item update and Lot status Update
• Administered, maintained, developed and implement policies and procedures to ensure the security and integrity of all Oracle and some SQL Server databases.
• Worked extensively on monitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.
• Performed Block Recovery and Data file recovery using RMAN. Assisting in implementation of change control process in production. Identified and fixed the logical block corruption using RMAN Involved in taking logical backup using Datapump Expdp and Impdp Utility.
• Performed Data load on different databases from flat file using SQL*Loader.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL
• Pitched in help in other areas of the EBS such as fixing issues with the customer extensions in Oracle Project.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM for Generating reports.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Installed Standalone servers on ASM and migrated databases to ASM.
• Implemented data transfer using Transportable Table Spaces (TTS), Data Pump and Export/Import.
• Collected ADDM recommendations using OEM 10g/11g to tune the top running SQL Queries.
• Experienced in performing Point-in-Time Recovery.
• Monitoring tablespaces issues, creation tablespaces and adding datafiles.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Tuning heavy data loads. Monitoring and Performance tuning.
• On-Call 24x7 DBA support for production databases.

Environment: Oracle 10g/9i, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix, Data Modeler, RMAN, DataGuard, RAC