SUMMARY:

• Experienced in regular Database Administration activities such as Upgrades, Patches, TAR Support, Cloning (Hot/Cold/RMAN), Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Proficient in server side programming like Procedures, Functions, Database Triggers& Packages.
• Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.
• Hands on experience in installing, configuring, and using Hadoop ecosystem components.
• In - depth knowledge and experience in full life-cycle of Application deployment which includes Data architecture, Logical and physical database design, Data modeling using Erwin, Writing sql,pl/sql codes for application, testing the application Following stage deployment and load testing and finally go live to production.
• Excellent experience in installing and configuring oracle RDBMS and oracle client softwares using SILENT INSTALLATIONS and SOFTWARE CLONING.
• Experience in GOLDENGATE replication and SHAREPLEX for migrating the databases.
• Experienced in installing and configuring UNIDIRECTION and Bi directional replication using oracle GOLDENGATE 11.2 and 12C R2
• Experience in implementing ROLE based security as per SOX and OCC compliance and audit.
• Strong Knowledge in Oracle Data ware house DBA skills relating to administration and management of VLDB environments, Oracle OLAP and Cognos.
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Deep understanding about Exadata specified features such as smart Scan, HCC (Hybrid Columnar Compression), Flash Cache, etc.
• Worked on DB migration to DbaaS (OraaS) from physical servers. Worked on migrating databases to Cloud. Applied DB patches on Cloud and OraaS for both Non - Prod and Prod.
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experienced in troubleshooting for Database related issues like Performance Tuning using ADDM, AWR, ASH and other Oracle Diagnostic Tuning Pack like SQLT, SQL Tuning Advisor, SQL Health check tool. Good knowledge of dynamic performance views in Performance Tuning.
• Used Flashback Database, Flashback table feature to recover the Oracle10g, Oracle 11g Database, also monitored the flashback logs on a daily basis. Responsible for writing Shell Scripts (ksh) in aid to Backup & Recovery, Performance Tuning operations on Oracle Database.
• Experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), Oracle Reports builder, Forms 6i, SQL developer, SQL* Plus, Oracle Enterprise Manager (OEM), and PL/SQL Developer.
• Have a solid understanding of VTL, EDL, Tape Cloning and EMC SAN storage technologies.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Database Admin: Oracle 8i-11g/12c, SQL server 2000-2005, NoSQL Database, Cassandra, MangoDB

Tools: PL/SQL, SQL*Plus, SQL*Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, DBMS SCHEDULER, Toad, VMware, Win SCP, Putty.

Oracle Products: Oracle Real Application Cluster 12c/11g/10g, Golden Gate, Data Guard, Import and Export, Data pump, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle 10g/11g/12c (Grid Control), Oracle EXADATA x3-2/x4-2, RMAN, Oracle Wallet, Transparent Data Encryption.

Platforms: UNIX, Solaris, Linux, Windows 2003-Server 2005, HP-UX, AIX

HighAvailability: Real Application Clusters (RAC) 9i-11g, Data Guard, RMAN, HP Service

Enterprise Data Tools: Oracle Designer, OEM/EM Grid Control (Enterprise Manager)Patrol, Service Manager Toad & Quest Central Suite of Products, Oracle streams, Oracle Warehouse Builder (OWB ):

Middleware Tech: Apache, Tomcat.

Other: Data Integration, Data Modeling, Data Architecture Design, Apache 1.3, APACHE Cassandra 2.1.14, Oracle Streams, Oracle financial application systems (GL, AR, AP, HR), Oracle CRM, TCA, UWQ, Forms, Report Writer, MS Project 2000/2002, ERP Systems, SDLC, EDI, MS Office Suite (Word, Excel, PowerPoint, Outlook, Visio), ODBC, ftp.

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

PROFESSIONAL EXPERIENCE:

Confidential, San Antonio, TX

Senior Oracle DBA

Responsibilities:

• Responsible for monitoring 100+ SQL Server databases on production, test and development databases
• Microsoft SQL SERVER MANAGEMENT STUDIO 2005, 2008R2, 2012,2014 used for administration and maintenance of SQL server databases
• SQL Server Database Migration, Cloning, detach, attach, restores, mirror were performed with in user requirements
• Responsible for creating maintenance plans for all the SQL Servers like backing up transactional logs, creating backup sets, maintenance cleanup jobs, used in restoring databases during database crash or fail
• Working experience on SQL database cluster, have configured Always ON Availability
• Collect CPU, Memory usage, blocking query reports and troubleshoot and fix the root-cause of the CPU, Memory issues and blocking on a database/server
• Expertise in Oracle and Database Application clients like TOAD, SQL Developer and Spotlight
• Perform Database Refreshes periodically using oracle datapump export/import which could be table level, schema level, Full Database.
• Experience on Oracle Enterprise Manager Cloud Control 13c and Grid Control
• Installed & Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g.
• Responsible for maintenance of around 20 databases combined on all the production, development and testing environments.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Responsible for Restoration and Recovery of databases at the time of occurrence of critical failures.
• Working with ITIL Process (Incidents, Change, Patch and problem Managements, etc)
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Achieved High Availability, Data protection and Maximum performance by maintaining a physical standby database.
• Extensive use of Oracle Data pumps, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• Performed Point in time recovery using RMAN.
• Performed automated backups and scheduling using scripting.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Analyzed Alert Logs and Trace Files to resolve the errors.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Support departmental operations in a high-throughput production environment by proactively managing the performance, optimization, integrity, and security of institutional database and systems like SIS
• Function as the senior technical lead in advising management on matters pertaining to database and technologies to support all users; Assign personnel to various projects and direct their activities
• Provides leadership and mentorship to assigned personnel, Supervise, train, and monitor personnel to ensure work accuracy and efficiency
• Setup, monitor, and maintain disasters recovery solutions for enterprise productions database
• Architect, manage, test, and provide support to multiple enterprise wide database system and applications
• Design, create, install, and maintain highly available and secure enterprise database instances to include database architecture, database backups creation of databases and database objects such as tables, indexes, views, triggers, ad stored procedures to support enterprise level application
• Code database description and specify identifiers of database to database management system to direct other in coding database description
• Maintain reliability of database by developing and implementing standards and/or process for database maintenance, documentation and configuration
• Ensure database re monitored and appropriate measures/actions taken to ensure the integrity of the database to include security and privacy issues
• Modify database programs to increase processing performance, referred to as performance tuning
• Production & Non-Production support for several mission critical/entity essential OLTP systems, which utilize multiple Oracle databases (TB Sizes).
• Responsible for planning pertaining to database environment to include database capacity planning, processing, capacity, storage capacity, backup, capacity, future needs/requirements. Project long-range requirements for data base administration in conjunction with other managers in the information systems function as well as business function managers
• Work as a lead member of the technology team to assist in providing maximum availability and support of information technology systems
• Assure the timely completion of the database project and within estimated cost
• Consult on server design coordinate changes to server applications, lead and manage successful upgrade and implementation of existing and emerging technologies in database environment
• Schedule and perform installation and upgrades of enterprise level databases and applications and maintains them in accordance with established Information technology policies and procedures
• Conduct routine audits of enterprise databases and systems to ensure compliance with established standards, polices and configuration guidelines
• Create and maintain documentation pertaining to the university database environment
• Periodically provide and oversee On Call Support
• Experience working with PeopleSoft environment and ETL tools

Environment: 12c/11g/10g, RHEL 5/6/7, OEM, RMAN, Grid, Data guard, ACFS, RAC, ASM, Golden Gate, TOAD, SQL*LOADER, Performance Tuning, Exports/Imports, Linux (Red Hat), VERITAS, SQL*PLUS, UNIX Shell, RMAN, RAC, PUTTY.

Confidential

Senior Oracle DBA

Responsibilities:

• Installing centrify (Single Sign on) Suite on Oracle, DB2, Mongo DB, Sybase database servers
• Trouble shooting any issues raised after centrify migration completed
• Performed day to day activities: Such as, daily error checks and database health, monitoring of physical resources (disk space, memory, CPU, etc. Performance parameters adjusted as needed.
• Support Oracle Databases on 4-Node RAC Cluster with Oracle 11.1, ASM and Oracle Cluster ware.
• Perform RMAN Online backup (Full/ Incremental) of Oracle RAC Databases, setting up and monitor standby database.
• Database backup & Recovery performed using RMAN and Data Pump export and Import.
• Database Space management & Capacity Planning
• Management of Production, QA & DEV infrastructure
• Applying Oracle EBS patches using ADOP - online patching
• 24x7 support for production db i.e. performance, backup
• Architect view databases to let developers run Ad hoc queries against real time data with managing PII data access.
• Supported production, development, test, UAT databases. Solved issues as per ITIL methodologies. Provided administrative support for SAP, Tivoli agent and TSM.
• Standby database Maintenance and configuration
• Work with Grid Control and configure multiple instances for monitoring and managing in Oracle Enterprise Manager.
• Worked with performance tuning, cell offloading and smart scan, storage indexes, hybrid columnar compression, OLTP table compression and parallel operation
• Database monitoring & support for more than 150 oracle databases using OEM.
• Creating and maintaining the different database throughout the infrastructure Landscape including performance and tuning analysis using AWR & ADDM, capacity planning, systems support & optimization, Database software upgrade/patches
• Apply Oracle-supplied patches to the databases of each OS. Keep all databases with up to date version and patch level.
• Oracle Internet Directory OID Administration and support
• Support RMAN catalog for backup and TSM for job scheduling
• Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.
• Ran Scripts for Health Check on Exadata Storage Servers.
• Implemented Oracle Patches CPU & PSU on the Compliance databases Device a plan to patch them.
• Setup and tested DR for Oracle EBS using NAS replication for application tier and Data Guard for DB.
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.
• Involved in Production Support for Critical Application Databases when needed.
• Installing agent 12c on the server. Adding High Available Database with CRS, Scheduling Backups through OEM12c.
• Scheduling jobs through oracle JOB SCHEDULAR, Crontab (UNIX)

Environment: Oracle 12C, 11g, Centrify, AIX 7.1.0, RMAN, Toad, Oracle ASM, Oracle Data guard, HP-UX 7.x/11.x, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, DATAPUMP, WEBLOGIC SERVER 8.1/9.0,10G/11G, GOLDENGATE11G, 12C, ORACHK, DEFGEN, LOGDUMP, ASH REPORTS, ORACLE PATCHING OPATCH, PUTTY

Confidential, Boston, MA

Sr. Oracle DBA

Responsibilities:

• Experience in Design, Creating and maintaining the Oracle Databases 10g and 11g from the scratch on UNIX, LINUX and WINDOWS environment.
• Installation, Configuration and maintenance of Oracle Goldengate software on Unix systems, Sybase, Sun Soloes systems, Oracle GoldenGate on Oracle Exadata Database Machine
• Configured DDL replication from Oracle on Sun to Oracle on Linux.
• Performed Uni-directional replication both DDL and DML.
• Troubleshooting Goldengate issues at the replicate end and resynchronizing tables when they go out of sync.
• Troubleshoot and resolve Oracle EBS and databases related issues.
• Replications of public synonyms over dblinks were configured in DDL replication.
• Installation and administrationof Oracle 12c on Linux,OracleGoldenGate on Oracle Exadata Database Machine and Sun Solaris on development databases.
• Developed the Data Quality and Governance Plan that describes how the IE project manages data artifacts, including data design standards, logical and physical data models and the underlying physical databases, as well as the functional, organizational, and technical infrastructure used to support data quality management.
• Performed testing on Oracle GoldenGate 11.2 with Oracle 12c Database.
• Document and communicate changes to the OLTP, OLAP systems and data warehouse teams, including Data Modeling, ETL and Database teams.
• Replication was configured to run even at the time of failover (Data Guard) of the source database.
• Wrote ad hoc scripts for daily DBA activities such as backups, user creations, granting roles and privileges, archiving of alert logs, verifying error entries and checking for space usages/overages.
• Participate in ITIL standards including the use of Service Now change mgt. tool, presenting DBA work at Change Mgt. meetings, and supporting the development life cycle. Provide 24x7 prod support.
• Performing the initial load using (expdp and impdp) from source to target.
• Goldengate performance issues were resolved by splitting the process into subsets, so that performance is improved.
• Troubleshooting Goldengate process abends, analysing report files, error log file and discard files.
• Worked on Logdump utility of Goldengate .
• Performed skipping the transactions which are not necessary using logdump utility.
• Good at altering the Rba for replicatduring the troubleshoot of Goldengatebased on the transaction type and not missing any transactions.
• Maintainenceof Goldengate process during the batch loads.
• Goldengate monitoring was done using the cronjobs, where it does report a mail in case of a process abend or Lag more than threshold and any Checkpoint.
• Worked on Shell Scripts for the Goldengate monitoring and Trail file system size alerts.
• Worked on writing PL/SQL packages that would find any duplicates in the tables, this is as per requirement, where the tables have no primary or unique keys.
• Analysing Goldengate Trace file for any DDL captures by the DDL trigger.
• Worked on comparing the tables from source and target, to find any data discrepancy.
• Performed tests on replication of different oracle objects and behaviour of the Goldengate process during different situations.
• Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in UNIX scripting
• Conducted migration across various platforms like sysbase to oracle and SQL server to Oracle.
• Expertise in installing, configuring and maintaining Oracle databases on various platforms
• Supported Business, Post go-live by Cloning/refreshing Production to DEV, UAT, TEST and PREPROD Database instances, for testing at Scheduled intervals.
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.
• Performed documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.
• Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.
• Expertise in Job Scheduling environments like AutoSys & Cronjobs
• Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Upgraded the database 10gR1 to 10gR2 and applied database patches using opatch utility.
• Configured DATA GUARD to provide high availability by implementing physical stand-by database and worked with various Oracle 10g features: Streams, 10g Grid Control and Automatic Storage Management (ASM
• Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.
• Optimization and tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Delivered Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring, for custom scripts troubleshooting using SQLTRACE utilities
• Automated several scripts to monitor various processes, sessions and taking back up’s using crontab.
• Analyzed the user requirements and designed partitioned tables for improving performance.
• Performing the daily Maintenance tasks and interacting with Oracle Customer service when required.
• Used Oracle Streams for Basic and Advanced Data Replication between oracle database servers.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed VERIDATA tool for comparing data synchronization between SOURCE and TRGET
• Installed and monitored STREAMS one-way replication
• Involved in the 10g 2 Node RAC installation on RHEL 5.4 server
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM), Toad, SQL Developer and PL/SQL Developer.
• Involved in the Migration projects Extensively using Data pump and Rman utilities
• Migrated 100GB database from Windows SQL server to Oracle server using SQL Developer tool
• Excellent in writing SQL scripts using SPOOL command
• Creating physical data models from logical data models using ER Studio adhering with data governance policy.
• Involved in the migration of huge databases of sizes ranging from 100GB to 7TB
• Daily Health Check Up of the Database and SQL Queries using Statspack, AWR, ADDM and TKProf.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Experience in moving the data from one server to another server using SFTP,FTP and SCP
• Building new databases and schemas from the scratch on Linux and UNIX Boxes.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2 and applied patches as required.
• Schema Refreshing of databases using normal copy method and exp/imp utility.
• Cloned database and schemas using Data pump for 10g and 11g versions.
• Cloned 10g and 11g databases using RMAN duplication(with and without backup)
• Involvement in space management, rectification of lock problems, user management.
• Responsible to provide 24 x 7 database administrative activities over different database servers
• Regular Data Refresh from Production to Test and Development environments using RMAN Duplicate Database or Data Pump utility for oracle 10g and 11g servers.
• Configured Oracle Data guard for Oracle Disaster recovery on standalone database
• Troubleshooting ORA errors when occurred
• ASM Disk storage and user Management
• Performance Tuning for the SQL queries by scrutinizing the long running sql queries
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links using sql scripts
• Scheduled Oracle Jobs and Backups using CRONTAB.
• Experience in Online and Offline backups and recovery.
• Experience in backups and recovery using RMAN shell Scripts.
• Performed Schema as well as Table level Replication using Oracle Streams.

Environment: Oracle 11g/10g, HP-UX UNIX, RHEL 4.x/5.x, ASM 10.2.0.4, OEM (Grid Control), RBAC, RMAN and Data Guard, STREAMS, Explain Plan, SQL Developer, PL/SQL Developer, Data Pump, Business Objects, Toad 9.7.2.5, PUTTY,FTP, SFTP,SCP.

Confidential, Wilmington, DE

Oracle DBA

Responsibilities:

• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging And Training.
• Installed and configured 2 Node RAC on 10gR2.
• Installed 13 standalone servers on ASM and migrated databases to ASM environment.
• Configured Oracle Data guard on 10G for Oracle Disaster recovery. Worked on both Physical standby and Logical standby databases and resolved issues in DR environment.
• Converting Physical standby to Snapshot standby for testing purposes.
• Achieved High Availability, Data Protection and Maximum performance by maintaining both physical and logical standby databases.
• Implemented Oracle database backup & recovery solutions using RMAN and export/import.
• Restored and Recovery of databases at the times of occurrence of critical failures.
• Performed cloning and refresh of Database from production environment to test environment using RMAN Duplicate database and Data pump import export.
• Upgraded databases using Database Upgrade Assistance (DBUA).
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Involved in optimizing SQL statements using Indexes and Hints.
• Created and modified PL/SQL objects like Packages, Stored Procedures and Triggers.
• Responsible for configuring and taking level 0 and level1 incremental RMAN backups and resolving issues arising out of those.
• Rebuilt indexes for better performance of Oracle database.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader.
• Developed PL*SQL stored procedures, Indexes, cursors and database triggers to implement business rules.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Developed UNIX shell scripts to perform the above tasks efficiently.
• Responsible to provide 24 x 7 database administrative activities.

Environment: Oracle 9i/10g, Sun Solaris, windows NT/2000/2003, RHEL, RMAN, DBCA, Data guard, Oracle Enterprise Manager, EXPLAIN PLAN, Export/Import, Cloning, OEM, STATSPACK, TKPROF, Putty, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential

Oracle DBA

Responsibilities:

• Implemented Oracle Database 10g R2 Node Real Application Cluster (RAC
• Maintained and troubleshooting cluster-ware components in 10G RAC environment.
• Installed 10g standalone servers on Sun Solaris and installed databases on it.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Configured listener and TNS names manually.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Experience in Installing, upgrading and configuring Red Hat Linux.
• Experience in administering, installation, configuration, support, and maintenance of Linux.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Worked on Cloud Migration project, worked on servers and databases running on VMware
• Alert log Monitoring for critical databases every day in the production environment
• Used BMC Remedy tool for all change management process
• On-Call 24x7 production DBA support and Worked with off-shore and coordinating work with prod support for managing databases

Environment: Oracle /10g/9i, Sun Solaris 5.x, Unix, OEM 10g, Shell Scripting, Oracle 10g RAC, TOAD, putty, STATSPACK, EXPLAIN PLAN.

Confidential

Junior Oracle DBA

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Design Evaluation and Analysis of physical and logicalmodel.
• Involved in Installation and customization of Databases (10g&9i) in Windows, Linux and Solaris environments.
• Involved in Schemamanagement, TablespaceManagement, UserCreation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 8i, 9i, 10g.
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and also having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups i.e. RMAN.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, Involved in writing UNIXshellscripting for automating the jobs.
• Setup audit to report ad hoc. Wrote UNIX shell scripts using awk and sed for batch processing.
• Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 10g database servers using tools dynamic, dictionaryviews, Statspack, ADDM, AWRDiagnostic and tuningpackages.

Environment: Oracle8i,9i, 10g, Linux, AIX5.1, Hp- UX, Sun Solaris, RMAN, EXPORT/IMPORT, CRONTAB, PL/SQL, Shell Scripting