Data Oracle

Sundara Raavi

ac1hcl@r.postjobfree.com

Mobile:678-***-****

Sr. ORACLE DATABASE ADMINISTRATOR

Professional Summary

In 8+ years of professional experience as an Oracle Database Administrator, areas of Expertise are in Establishment and Administration of Database, which includes Installation, Migration, Upgradation, Performance Tuning, Patching of Oracle 12c, 11gR2, and 10g. Having Experience in Core DBA Activities like Data Guard Configuring, and setup, Exporting, and importing from databases using Data Pump. RAC data migration from Non-ASM to ASM, and Non-RAC to RAC, ASM security backups with RMAN, installation, and Maintenance, performing all kinds of tasks like backup and recoveries. Excellent, knowledge in using Oracle GoldenGate including replication, maintenance, and performance monitoring. Hands on experience of using centralized repository tool like OEM for automating databases monitoring system.

Experience Synopsis:

•Expertise in with 10g/11gR2/12c database administration, installation, configuration, upgrades, migration, performance tuning, backup, and recovery, cloning, space management, patching, and security, auditing and designing databases.

•Expert Implementing development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

•Implemented parallelism in loads by partitioning workflows using Pipeline, Round-Robin, Hash, Key Range and Pass-through partitions.

•Monitored databases using different Oracle Enterprise Manager OEM 11g/12c/13c and resolved several incidents, implemented Application data Models for Masking and subsetting.

•Using OEM specific types of templates are created to get alerts about happenings on the target database.

•Expert in tuning using automatic database diagnostic monitor (ADDM) and used automatic workload repository (AWR) to gather statistics by collecting, processing, and maintaining performance statistics for database problem detection and self-tuning processes.

•Implemented Coordinated Replicat in GoldenGate with maximum performance depending on threads availability for large transactions replication in 12c

•Experience in Oracle Database Administration including creation and maintenance of the Database (Backup, Recovery, Tuning, Security, and Capacity Planning, Upgradation, Migration) and System Analysis, design, development and implementation of Relational Databases (Oracle, SQL server) and Data Warehousing Systems.

•Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 11g r2 and Oracle Forms builder 11g r2 respectively.

•Expert in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN with VERITAS Net Backup.

•Expert in Implementation of backup strategies with hot, cold & Oracle EXP/IMP utility using UNIX shell scripts, RMAN backups.

•Experience in automating backup strategy using the UNIX shell script CRON UTILITY.

•Extensively worked on large-scale databases with the size of more than 30TB in large system environments. Migrated databases across different platforms using cross-platform transportable tablespaces (XTTS) and datapump export and imports

•Expertise in Oracle 12c/11g/10g/9i Data Guard and standby databases, Snapshot maintenance and creation.

•Experience with case management of DB2 technical support.

•Expert in implementing ORACLE STREAMS, and two types of standby databases supported by DATA GUARD, logical standby, and physical standby databases.

•Experience in basic and advanced replication processes including Oracle Streams, Advanced Replication and materialized views.

•GoldenGate implementation in active-passive and active-active configuration as high availability and technique on 11g and 12c

•GoldenGate implementation with different parameters to resolve conflicts, avoid looping, and to perform batch SQL Implemented GoldenGate downstream capture mode by configuring integrated extract at mining database.

•Advanced Security Features Database vault and created Realms for user to access the data on the database and implemented Data Redaction technique to hide sensitive data, TDE wallet management also implemented. EAS web tool info filled using web conference tools

•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.

•Upgrading GoldenGate from 11g to 12c and troubleshoot the several issues on GoldenGate using ggserrorlog, using log dump utility.

•Extensively worked on RMAN, media management, backup sets, lists and reports, channel allocation, restoring files, media recovery, recovery catalog, and integrity checks.

•Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning, and Designing Databases.

•Experience in managing of schemas, objects & Partitioning the tables & indexes and in creating and optimizing indexes for high-performance applications.

•Installed, configured, and maintained databases on EXADATA X2-2, X3-2, X4-2 Half rack and Full Rack. Migrated databases between different versions using character set scanner utilities.

•Worked on Exadata different features like Hybrid Columnar Compression, Smartscan, Flash logging, Create, and drop flash disks.

•Installed GoldenGate on ACFS and configured automatic failover, Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate.

•Experience in SQL, PL/SQL, Pro*C and Perl Scripting, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.

•Configured Repository database and installed Oracle Enterprise Manager 12c/13c

•Expert in Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

•Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Metalink and other Support Procedures.

•Participated inappropriate consulting, interfacing, and training for users and delivered associated documentation for user interaction with the database environment.

•Extensively used BMC Remedy and Service Now Ticketing systems for monitoring.

•Strong presentation, troubleshooting, analysis, design, code, unit test, system test, implementation with excellent interpersonal and communication skills.

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS

Oracle 12c/11g/10g/, Oracle 12c/11g Real Application Cluster (RAC), PostgreSQL, ASM, Exadata X3-2, X4-2 Half Rack and Full Rack Clusters, NoSQL

Tools and Utilities

RMAN, OEM 13c/12c/11g/10g, TOAD, SQL*Loader, Export/Import, Data pump, Web logic Server, Logdump, Defgen, GoldenGate 12c, 11g, Oracle Forms 11g r2, reports 11g r2, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting, Perl, Awk Scripting

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Professional Experience:

U.S. BANK, MINNEAPOLIS, MN Aug 2015 - Till Date

Role: SR. Oracle DBA

Responsibilities:

•Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment

•Migrating single Instance Databases to 3 Node RAC environments.

•Installed, configured and maintained Oracle 12C Real Application Cluster (RAC) 3 node RAC

•Migrated Standalone databases to RAC 12c clusters and Supported Applications

•Upgraded RAC Cluster from 11.2.0.3 to 11.2.0.4 and Applied Patches

•Installed STANDALONE servers on ASM, Red hat LINUX, Installation, and maintenance of Oracle 11g, 12c Data Guard.

•Configured Active Data guard 11g & 12c and worked on snapshot standby databases while maintaining existing OUD/EUS configuration for enterprise users.

•Applying PSU Patches and interim patches whenever required to make the database software up to date.

•Configuring Oracle Golden Gate one-way, two-way/bi-directional, active-to-active, and active-to-passive data replication with conflict detection and resolutions.

•Managed 20TB of data across 20 single-instance and clustered databases on RHEL, OEL and CentOS

•Enable DML/DDL data to replicate, set up the heartbeat table to monitor OGG replicate lag and provide a real-time lag report.

• Implementing High Availability Oracle Golden Gate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments.

•Troubleshooting typical OGG technical problems such as unique key violation / long transaction abending by using GGSCI / Logdump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments.

•Developed Shell scripts for monitoring Goldengate processes and their stats running on 60+ servers from one single database repository providing table level granularity with end-to-end replication map and thus maintain a history of all Goldengate processes.

•Installation of EMC(EMCC) 13c on 12.1.0.2 repository database on test environment.

•Configured GoldenGate new features such as integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate. Developed home-cooked GoldenGate lag monitoring scripts, configure Audit Vault, and configure GoldenGate monitoring plug-in in OEM (Oracle Enterprise Manager) 12c.

•Monitoring and Performance tuning of Goldengate sessions at the Database level and GGSCI level and investigate replication failures using ggserr.log, report files, and Log Dump utility.

•Performed Zero Downtime migrations from Non-Exadata machines to Exadata machines using Oracle Golden Gate and Data guard.

•Created scripts in Python to process Images and load them into Oracle DB.

•Worked as a part of AWS team. Launching and configuring of Amazon EC2(AWS) cloud servers using AWI's (Linux/Ubuntu) and configuring the servers for specified applications.

•Good knowledge in front end development using oracle forms/reports10g/11gr2.

•Implementing Oracle TDE (Transparent Data Encryption) in all of our new/existing databases for Tablespace encryption. Setup of OVD to support single sign-on.

•Installing Oracle OEM-11g and 13c Cloud Control to assist with monitoring and leverage support for the over thirty databases, providing .performance tuning solutions, and running nightly jobs. Implemented planned quarterly Disaster Recovery exercises to measure client's SLA requirements.

•Worked On EXADATA X2-2, X3-2 and X4-2 Half Rack and Full Rack servers and Worked on Exadata storage indexes, smart scans, & smart flash cache

•Generated Exachk and Sundiag reports and worked with oracle on issues.

•Applied patch set and interim patches whenever required to make the database

•Configure error handling for the restart, skipping transactions, handling collisions, logging, production support, and status reporting in GoldenGate.

•Monitor DB2 UDB processes and logs for any anomalies, provide corrective actions

•Implemented OLTP COMPRESSION, PARTITIONING, Hybrid Columnar Compression for databases on EXADATA, and the basic, low, high compression methodologies

•Managed testing, created backups by Exporting and Importing tables when needed

•Duplicated issues and tested solutions to make sure problems were resolved properly

•Worked on Installation and Configuration of SQL server 2008R2 and 2012.

•Successfully migrated data to a new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.

•Configured Transactional replication between Primary Server and three Read–Only servers, with separate Distributor server and troubleshooting replication problems.

•Performed Database and SQL tuning by using SQL Tuning/Access Advisor, AWR, ADDM, ASH, and STATSPACK, TRACE, TKPROF utilities.

•Used Oracle Application Express (Oracle APEX) for rapidly development of web application for the Oracle databases. Supported database using Oracle Enterprise Manager and Toad.

•Migrated databases using GoldenGate involved in implementing Brand New setup replication and migrated databases using GoldenGate

•Replicated tables to Different Instances for load balancing and configured GoldenGate to support application 24x7 environment.

•Handy in implementing CDR parameters in GoldenGate, Implemented Bi-directional replication using GoldenGate

•Troubleshooting GoldenGate issues with error reports and ggserror.log

•Developed Shell scripts for monitoring Goldengate processes and their stats running on 60+ servers from one single database repository and thus maintain a history of all Goldengate processes.

•Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM 11g/12c

•Upgraded Oracle databases from 10g/11g to 12c and applied PSU’s when required

•Established performance tuning best practices used by the DBA and Development teams

•Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN and TKPROF.

•Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing, and use of Statistics.

•Implemented Oracle Advanced Security Option ASO (Native, SSL) using Oracle Wallets and Certificates for securing data in transit.

•Provided appropriate security for users of databases, applications, servers, and systems, by setting and managing accounts, keeping sensitive data secure, Virtual Private Database (VPD), Table space Encryption, TDE (Transparent Data Encryption), data reduction, and data masking

•UNIX shell scripting as and when required based on the requirement.

•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

•Worked with Oracle Support on more complex and unresolved issues

Environment:

Oracle12c/11g/10g, Oracle EXADATA X2-2, X3-2, X4-2 HALF RACK and FULL RACK, Golden Gate, Linux 5.8, Sun Solaris, Red Hat Linux, APEX, RMAN, SQL server, NoSQL, Data Guard, OEM 12c,13c, Grid Control, Oracle Forms 11g r2, NoSQL, Fusion Middleware, STATSPACK, AWR, ASH, ADDM, Explain Plan.

TIAA Charlotte, NC Oct 2013-Apr 2015

Role: Oracle DBA

Teachers Insurance and Annuity Association is a leading retirement provider for people who work in the academic, research, medical and cultural fields. It serves 5 million active and retired employees participating at more than 16,000 institutions. TIAA operates on a not-for-profit basis, with surplus returned to participants. Their investments are majorly in agriculture. Internally it has focused on developing customer support IT infrastructure and leadership development.

Responsibilities:

•Installed and Configured Oracle 11g databases on Linux and also Upgraded Oracle databases from 10g to 11g version using OPatch.

•Maintenance of around 200 databases combined on all the production, development, and testing environments on various databases (DB2, SQL servers 2005). These are large-scale databases with the size of more than 15TB in large systems in a 24/7 environment.

•Converted a single instance database to Oracle RAC 10g.

•Installation, Configuration and Administration of Oracle 10g RAC.

•Involved in RAC administration including 10g Database cloning, tuning, patching, and monitoring concurrent manager processing etc.

•Design and implement Oracle middleware components for system integration in oracle 12c platforms.

•Strategic Incident Management planning, Change Management Planning, Major Incident outage, ITIL, Highly Reliable Organization Implementation ( HRO ), DB2 to Teradata Data Movement using DB Synch. Complete DB2 BLU Set-up and ure.

•Configured Oracle Data guard for Oracle Disaster recovery.

•Converted databases from ZFS filesystem to ASM filesystem. Supported Oracle Cluster series using ZFS Storage Subsystem.

•Developed new job for transferring data between Oracle, Netezza and Red shift and scheduling for daily execution

•Created numerous UNIX shell procedures to increase ease of maintenance and monitoring of critical tasks.

•Maintaining, monitoring RMAN backup with DD boost

•Database Backup & Recovery (RMAN) with EMC Data Domain and DD Boost

•Configured Disaster recovery databases using Data guard: configured Active Data guard, Data guard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing

•Achieved High Availability, Data protection, and Maximum performance by maintaining both physical and logical standby databases.

•Install the Oracle Goldengate (OGG) software to implement one-way/two-way data replicate the process, enable DML/DDL data to replicate, setup the heart-beat table to monitor OGG replicate lag and provide a real-time lag report.

•Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures

•Restoration and Recovery of databases at the times of occurrence of critical failures.

•Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, monitoring and optimizing database performance.

•Implemented Oracle database backup & recovery solutions using RMAN.

•Extensive uses of Oracle Data pump utility for moving data among the servers.

•Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

•Responsible for configuring and backing up the database using RMAN, Hot backups, Cold backups and Logical backups.

•Performed automated backups and scheduling using scripting.

•Written Stored Procedures and Triggers for database maintenance and management using PL/SQL

•Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS).

•Attended Developer’s code review meetings and made recommendations to improve Efficiencies and Kept team members and management updated on major issues so they have a clear picture of situation. Involved in gathering requirements from end users.

•ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 8.x/7.x/6.x and PowerMart 8.x/7.x.

•Creation of new scripts to automate the procedures to generate statistics on database space management for proactive monitoring and UNIX Shell Scripts are used for backups.

•Managed and monitored the Oracle Real Application Cluster (4 node RAC) running on ASM Storage and Supported more than 150 production and development databases

•Experienced in performing Point in time recovery using RMAN.

•Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment-using Listener, TNS names etc.

•Management of schemas, objects partitioning the tables & indexes.

•Automation of data load and data parsing using Pl/SQL procedures, shell scripting, and Sql*loader.

•Tested database performance issues (monitoring and tuning) to ensure database optimization.

•Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.

•Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment:

Oracle 11g/10g, Red Hat Enterprise Linux 4.x, and 5.x, AIX 5.2, OEM, Oracle 10g RAC, Sybase, Exadata x3-2, STATSPACK, EXPLAINPLAN, Informatica Power Center 8.x/7.x/6.x, PostgreSQL, IBM Data stage, SQL Server 2005.

Government Employee Health Association, Kansas City, MO Nov 2011-July 2013

Role: Oracle DBA

GEHA (Government Employees Health Association) is a self-insured, not-for-profit association providing health and dental plans to federal employees and retirees and their families through the Federal Employees Health Benefits Program (FEHBP) and the Federal Employees Dental and Vision Insurance Program (FEDVIP). GEHA provides benefits to nearly 1.8 million people worldwide

Responsibilities:

•Implemented Oracle Database 11gR2 2,3,4 node RAC Clusters on RHEL Linux Severs

•Performed health checks of OCR, voting-disk, Interconnect and RAC instances and managed resources using Crsctl & Srvctl, creating services using Srvctl, relocating services and patching RAC cluster and troubleshooting 10g, 11gR2 cluster

•Worked on Exadata X2-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Data guard

•Worked on different Features on Exadata x3-2: Hybrid column compression, Smart scan, Flash Logging, DCLI, create and drop Flash disks, Flash Logging, Enabling Flash Cache Compression, Cell monitoring and Alerts, Cell Offload Efficiency, Hybrid columnar compression, controlling database resources using IORM plan

•Installed and configured new middleware instances(Weblogic, Tomcat, Apache) required by project and provided support.

•Installed and configured Oracle Database Vault in 11gR1 & R2 for fine-grained access control and for separation of duties in the database.

•Performed various tasks on ASM, Installed standalone servers on ASM, used asmcmd to manage disk groups in ASM environment and Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM, tuning ASM parameters for better performance

•Maintaining the Wallet files, and backing them up using automated scripts/jobs to eliminate the loss of wallet files.

•Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases

•Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate

•Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicat and replicated tables to different Instances using GoldenGate

•Upgradation of databases from 10.2.0.4 to 11gR2 and Applied patches to databases 10g/11g

•Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database

• Installed and administered, NIS, NIS+, NFS, and Send mail for centralization and firewall setup with iptables on Red Hat

•Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery

•Created User accounts, Roles and granting required access permissions and privileges

•Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes

Environment:

RHEL-4.x,5.x, Sun-Solaris 9, OEM 10g-11g, Oracle 10g,11g, RAC 10g,11g, Srvctl, Crsctl, ocr config, ASM, ASMCA, Dataguard, Active Dataguard, snapshot standby, GoldenGate v10, v11, Exadata x3-2, x2-8, Migration, TKPROF, AWR, ADDM, ASH, RMAN, Data pump, OPatch, Materialized views, Toad, Putty

Kotak Mahindra Bank -MUMBAI, INDIA May 2009-Aug 2011

Oracle DBA/Developer

Responsibilities:

•Design, document, implement, and maintain all backup, recovery including disaster recovery procedures.

•Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.

•Configured Oracle data-guard (ADG) for Oracle Disaster recovery on standalone databases using11g Active Duplication. Setup backup procedures for various PRODUCTION databases based upon SLA.

•Created physical standby database (for disaster recovery) from hot backup of primary database.

•Resolved gaps between primary and standby databases (Gap Resolution).

•Responsible for purging and archiving the production databases. Creating Tables, indexes, & triggers to assist developers.

•Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and DR databases. Involved in 24x7 Oracle Production Database Administration.

•Involved in installation, configuration, and support of Oracle 11g RAC.

•Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI

•Detected locks and resolving in-doubt transactions manually. Tuned oracle SQL statement by tracing.

•Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.

•Took Full/Incremental backups using ORACLE Recovery Manager (RMAN).

•Applied various patches on regular basis to oracle software homes.

•Refreshed PROD, DEV, UAT databases using Data pump, RMAN, Transportable Tablespaces etc.

•Developed Shell Scripts and SQL scripts to carry out routine checks on databases and perform various tasks on the database.

•Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g.

•Performing Backup/Recovery of all the Oracle databases using RMAN.

•Extensive Experience with Change Control Management for all database changes. Scripts for Health Check of Databases. Reading Alert Logs and User Trace Files and Diagnosing the Problem.

Environment:

Oracle 9i, 10.2.0.2, 11.1.0.7, Maestro 7.0, HP service desk, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3.

Fortech Soft, Hyderabad, Andhra Pradesh Jan 2008-Mar 2009

Role: Oracle DBA

Fortech Soft is a IT service based company, it is a state of art IT solutions for Various Industry Sectors like, fortech caters to the Information Technology needs of the Manufacturing, Healthcare, and Semi-Conductor companies serves in India and well as in USA.

Responsibilities:

Normal application database to Cluster application database.

Applied interim patches using OPatch utility.

Made policies for database hot backup, cold backup, and RMAN backup.

Resolved the concurrent request log/out files view and concurrent manager's startup issues. .

Proactive monitoring and health checking of all DEV/STAGING/PROD databases.

Applied database patches using OPatch utility. Applied oracle application patches using ad patch.

Performed OCR & CSS files backup and Administrated RAC database using SRVCTL.

Applied interim patches using the Opatch utility on RAC RDBMS HOME.

Generated Stats pack as per the requirement. Performance Tuning: Explain plan, TKPROF, STATSPACK, and Explain Plan.

Data pump including database links and network links. Upgrade the binaries by applying patch set and interim patches using OPatch and OPatch Auto

Cloned and refreshed of Database. Performed different methods of backups like hot, cold. Applied patches using OPatch Utility.

Backup and recovery strategy databases using RMAN.as well as standby, up gradation, migration, Disaster recovery.

Oracle Configuration. Oracle Tuning. Oracle Patch Administration.

Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability.

Performing Daily, Weekly and Monthly Oracle monitoring and maintenance tasks.

Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.

Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.

Responsible for writing database programming to Store/Retrieve the information from the database using SQL.

Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.

Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.

Monitoring the data loading jobs and tuning the SQL queries.

Environment:

IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, RAC 9i/10g, Quest Software (5.0), RMAN, UNIX Shell Scripting.

Education:

Bachelors of Engineering, MAHER University Chennai, TN -India

Contact this candidate