SUMMARY

• Over 8 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g,12c on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
• Experience in Migration Projects. Hands on experience in-migrating from Oracle9i to 10g 10.2.0 , 10g to 11g and applied oracle patches.
• Hands on experience in Cloning, Oracle Streams, Space Management, Database Security.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms
• Installed Oracle 10g RAC software with ASM OCFS2 File systems.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery RMAN .
• Created development, testing, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
• Co-ordinate with UNIX administrators for space managements on various servers.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup, IBM TSM LEGATO Storage Manager.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL LOADER.
• Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps.
• Hands on experience using Oracle Enterprise Manager OEM , SQL PLUS, TOAD and Grid Controlling using OEM

• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Designation: Sr. Oracle DBA

Responsibilities:

• Worked as an Oracle DBA 9i/10g/11g/12c on Linux, Sun Solaris, HP-Unix, AIX and Windows servers.
• Installed and configured Oracle RAC 11g 4 nodes cluster on ASM file system.
• Implemented SCAN VIPs for application connectivity.
• Administer and monitor databases, services using srvctl and crsctl.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance and managing data lifecycles.
• Involved in extracting data from source interface systems data warehouse system ETL process using DTS SQL Loader.
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer CBO , SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Stats pack. Installed and configured OEM GC and intensively used for Diagnostic tuning activities.
• Maintained Production databases up to 10TB.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, database growth.
• Major activities were deploying the scripts in Oracle, SQL and Sybase platforms and troubleshooting the errors by coordinating with developers and other related teams.
• Cloning/replication of application database environments database related troubleshooting.
• Working on performance tuning of queries and database performance improvements.
• Worked in a team where upgrade of database from 10.2.0.4 to 11.2.0.3 by applying patches using Opatch utility was done.
• Transportable Table spaces TTS , Export/Import and Data pump expdp/impdp .
• Work on Run and Change activities in a 24x7 environment on-call.
• Exposure and working Knowledge of SQL and Sybase database.
• Worked on dba activities which include Creating Users, Roles and Profiles, Privilege management with role-based security of databases, table spaces, indexing, data maintenance and user management.
• Performed performance tuning using Explain Plan SQL Trace.
• Applied High priority patches downloaded from Metalink.
• Generate AWR, ADDM reports and analyze it.
• Study the Explain plans and try to troubleshoot where query taking long time.
• Troubleshooting and Investigation of application Bugs, Oracle Bugs and Job failures.
• Working with different tools like OEM, SQL DEVELOPER, MS SERVER MANAGEMENT Studio for SQL databases and DB artisian for Sybase databases.

Environment: Oracle 10g, 11g, 11gR2, 12c, HP-Unix, Linux/5, OEM, RMAN, Golden gate, Grid, RAC, ASM, Dataguard, putty, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential

Designation: Oracle Database Administrator

Responsibilities:.

• Involved in database designing, creation and maintenance of Oracle 10g/11g on UNIX/Linux platform.
• 24X7 production Oracle database and administration.
• Export and Import of database objects from one database to another database.
• Created and Implemented database backup strategies and recovery strategies using RMAN.
• Refresh/cloning the test development databases from the source production databases on a regular basis using data pumps, hot/cold back strategies.
• Involved in tuning of databases, Oracles Application and Custom Build Application.
• Physical database creation data files, control files redo logs, rollback segments
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Done Installation and configuration of Golden Gate on 11g database for the replication.
• Monitoring Database performance with SQL Trace, TKPROF.
• Upgrade of Database versions from 10g to 11g and applying security patches according to the requirement.
• Worked with Developers on DDL and DML changes in the databases.
• Creating database indexes, constraints and procedures and triggers.
• Good knowledge on dba views, and v views.
• Implementing database security, design and security.
• Working on Oracle 10g New features Data pumps, OEM, flashbacks.
• Experienced in setting up and configuration of RAC database environments.
• Applying Patches in a RAC Environment and making sure of availability of database to users.
• Extraction of data from different flat files into Oracle Database using SQL Loader and automated the process by using Basic Replication using materialized views.
• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data.

Environment:

Oracle 11g/10g , HP-UX, Sun Solaris , Red Hat Linux, IBM-AIX, Oracle Enterprise Manager, RAC, SQL, PL/SQL, TOAD, RMAN, AWR, TkPROF, Explain plan, STATSPACK, SQL Loader, Golden Gate

Confidential

Designation: Oracle DBA

Responsibilities:

• Installed and Monitored the Oracle database on 10g RAC in Solaris Servers using ASM.
• Involved in performing migration from Oracle 10g to Oracle 10g RAC database.
• Involved in installation of Oracle 11gRAC on AIX.
• Involved in performing migration from Oracle 10g on Solaris to 11g on AIX.
• Provided technical support for Oracle Server to customers for Production Database
• Supported Remote DBA Support for Oracle 9i/10g.
• Involved in the installation of DB2.
• Installation and maintenance of Oracle 10g Data Guard 24 7 Production Environment.
• Implemented Oracle Streams for the replication of data in Development to Production.
• Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches whenever required.
• Responsible for around 60 Oracle databases on 11 servers.
• Maintained instances of around 750GB with 500 Users and around 60 Production and Development instances.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager OEM Grid Control and Enterprise Security Manager ESM .
• Used Oracle Retek Extract, Transform and Load supporting replication and de-normalization for OLAP.
• Monitoring experience includes Oracle Enterprise Manager Grid Control and Quest Fog light.
• Troubleshooting on the databases for Application Server and Oracle database related issues.
• Setting up cronjob for backup and Recovery using autosys.
• Used ERWIN for logical and Physical database modeling.
• Developed PL/SQL packages, Dynamic SQL, DML, DDL, Oracle tables, stored procedures, functions, Cursors, triggers and UNIX Shell scripts.
• Developed Perl Scripts in order to provide reports.
• Wrote PL/SQL Scripts, Packages and views to extract load and create data files using DTS and Sql server integration services SSIS in the Sql server 2000 and 2005.
• Involved in SAP ERP support and system administration.
• Involved in development and implementation of Data ware house and Data mart Design.
• Performed Data conversion from DB2 to Oracle.
• Used SAS and SQL to implement source to target ETL modules for loading into Oracle database.
• Used XML to communicate with web services.
• Administration of Oracle networking using Sqlnet, TCP/IP and Listener setup for oracle databases.
• Supported new PeopleSoft CRM 8.8 and Field service Implementation.
• Created Heterogeneous services for accessing the database links from an Oracle database to SQL server database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Daily Health Checkup of the database using statspack, AWR, ADDM.
• Involved in Oracle Warehoused Builder creating Star schemas, Partitioned Materialized Views and logs utilizing Query Rewrite and Start Transformation.
• Created database objects like tables, indexes, synonyms, views etc. using SQL Plus, used SQL Loader control files to load data from external data sources into Oracle database.
• Perl Scripting, Shell Scripting, bash scripting and PL/SQL Programming to resolve business problems of various natures.
• SQL statement Tuning using Explain Plans and SQL Trace using TKPROF utility and AUTOTRACE utility.
• Migration of data from MS SQL Server 2000 to Oracle 9i.
• Created scripts for data migration from flat files and MS Access to Oracle.
• Involved in reviewing business object reports using Cognos.
• Designed Oracle Data ware house and ODS model.
• Developed ETL Process to load the data from .DAT files
• Created reports using crystal reports from oracle data.
• Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
• Involved in sizing and planning of large VERITAS Net backup environments.
• Backup to virtual tape using VERITAS Net Backup and shared storage Option.
• Optimizing Oracle RMAN and ASM environment.
• Taking Periodic Backup of the databases and the software using RMAN.
• Flash Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption .
• Monitoring CPU usage, I/O Contention, memory paging on UNIX server. Provide technical direction to system administrator.
• Worked with the business analysts throughout the development cycle, and provided post-implementation support, for data and report issues identified by customers.

Environment: Sun Solaris 9.0/10.0, IBM-AIX, Oracle 11gRAC/10gRAC/10g/9i, SQL Server 2008, Oracle Streams, Data Guard, Toad, Sql-navigator 2000 2005, SQL Loader, Oracle Warehouse Builder, ODBC, ASM, PL/SQL, XML, OEM Grid, RMAN, Erwin 4.1.2.

Confidential

Designation: Oracle DBA

Responsibilities:

• Installed Oracle 10gRAC database on Redhat Linux using ASM.
• Installed Oracle 9i and 10g database on HP-UX 11.0, Redat4.
• Involved in the installation and administration of Sql-Server 2005.
• Migrated data from 9i to 10g using Transportable Table spaces and Export / Import utilities
• Migrated Databases from TRU64 bit and to HP-UX 11.0 Servers.
• Migrated Databases from 9.2.0.3 on Linux to 10.2.0.3 on HP-UX
• Monitored and Tuned database to optimize the performance and satisfy the availability.
• Performance Tuning by using Oracle utilities like Explain Plan, Stats Pack, and Tkprof for addressing performance bottlenecks is performed.
• Reviews and assigns remedy tickets assigned to the DBA team.
• Logical and Physical data modeling using Erwin, Dimensional/OLAP data modeling.
• Taken Backup Recovery by using RMAN.
• Analyzed and monitored that data got by ADDM performed logical database using Export utility.
• Adopted general DBA tasks like Indexes, Partitioning and Flashback Recovery.
• Used Oracle Retek Space Optimization for optimal space and allocation recommendations.
• Use of Transparent Data Encryption TDE for the protection of Application Data Stored in the Database.
• Used Snapshots for Replication and synchronization data with other branches.
• Used Snap Mirror for creating duplication of production databases.
• Created new environment for Shareplex replication.
• Maintained database replication using Quest Shareplex and materialized views.
• Implemented Oracle Data Guard for maintained oracle disaster recovery
• Used Storage Management using SAN.
• 24 7 remote support and on call for Production database supporting developers end-users.
• Provided all kinds of DBA support to development teams as well as production support to various tasks.
• Understand user requirements and involved in data reconciliation of technical requirements.
• Involved in Developing Informatica workflows and sessions associated with the mappings using Workflow Manager
• Ability to design mappings for Data Capture, Staging, Cleansing, Transforming, Loading and Auditing.
• Manage Enterprise databases, users and roles by Oracle Enterprise Grid Control.
• Developed Dynamic SQL, PL/SQL Scripts, Packages and views
• Created Data Modeling and Data definition Language DDL to support development efforts.
• Created and maintained different database entities included table spaces, data files redo log files, rollback segments and renaming/relocating of data files on servers.
• Created PARTIONING of its types like Range, List Hash by the specific use.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, Tkprof, TOAD and Oracle Enterprise Manager.
• Provided administrative support for PEOPLE SOFT 8.8 for Oracle on Redhat.
• Trouble shooting and resolving any database and/or application issues or errors that occurred.
• Done backup and recovery using autosys.
• Developing shell scripts and using various tools monitored the various database activities.
• Utilizing OEM SQL Analyze, OEM Grid Control, STATSPACK, SQL Trace, TKPROF etc.
• Experience in writing Perl scripting for day day activities for monitoring the database.
• Involved in writing ETL and Validation Programs for complex data sources using Perl.
• Experience using the System Development Life Cycle SDLC .
• Involved in data conversion from sql-server to Oracle databases.
• Established database backup/recovery strategy for different databases.
• Implemented Oracle Streams for Replication.
• Implemented schema level, table level and bidirectional oracle streams.
• Strong Knowledge in Application Development client/server
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Modified database structures including table spaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
• Performed daily alert log files, trace files check, and general data consistency data integrity check.
• Developed scripts to monitor the storage usage, object status for daily job .
• Involved in Unit testing and Integration testing of forms and reports.
• Oracle support and Meta Link are utilized to troubleshoot the problems and issues.
• On-call support regarding production - related database problems is performed.

Environment: Oracle 10gRAC/10g/9i, Sql-Server 2005, HP-UX 11.0, Redhat4 Linux, Tru64bit, Informatica 8.1, Data Guard, OEM Grid Control, RMAN, Erwin, ESM, Explain Plan, SQL Trace, Tkprof, STATSPACK, Shell Scripting.