SUMMARY

• 8+ Years of experience in IT industry as Oracle Database administrator, having exclusive experience in database administration, installation, configuration and upgrades with Oracle Software 12c/11g/10g/9i/8i on, Red Hat Linux, HP - UX, Sun Solaris, IBM AIX, Oracle Enterprise Linux, Windows Platform.
• Expert in Architecture of Oracle Databases 12c/11g/10g RAC, 9i with objectives of saving costs and time.
• Strong experience in supporting production, development, unit test, system test, Integration test, certification test databases under UNIX/LINUX.
• Experience in managing large mission critical databases high availability and disaster recovery environments in 24*7 using Oracle RAC, Standby databases (Active Data Guard).
• Expertise in Replication of Oracle Databases using Streams and Golden Gate.
• Experience in Upgrading databases (9i, 10g, 11g, 12c)
• Involved in doing Data Modeling, Data Mart, Data Warehousing, Data Transformation.
• Proficient in Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.
• Expert in Administration, Productivity and Modeling Tools including OEM, Data pump, Exp/Imp, VERITAS, OLAP/Partition/RAC, Erwin, TOAD, SQL, Home-made Scripts.
• Installed, configured and Monitored OracleEnterprise Manager Grid Control 11g.
• Expert in Database Health Maintenance using Stats pack, TKPROF, RACDIAG, Explain Plan, Enterprise Manager, Self-developed Scripts & methodology, Procedures.
• Expertise in cloning databases using manual methods and using RMAN Duplicate DB to create Test, Development databases and Active Duplication to create standby databases.
• Experience in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and Performance monitoring and tuning.
• Experience in Backup and Recovery activities using RMAN and conventional backups.
• Expert in configuration of 12c/11g/10g RAC, Standby Databases (Active Data Guard) for High Availability, Disaster Recovery and reporting.
• Installed oracle database server on HP-UX, WINDOWS NT, LINUX and migration of oracle server from 8i, 9i to 10g and 10g to 11g and 11g to 12c applied oracle patches.
• Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD.
• Experience in fulfilling DBA daily activities, schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, views, sequence).
• Worked on space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, ASH, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Involved in performance tuning and database reorganizations. Worked on Disaster Recovery and Implementation
• Setup and installed Oracle 11g,10g RAC software with ASM & OCFS2 File systems.
• Database security include authentication, access controls, secure configuration and auditing.
• Maintenance and tuning of RAC Applications. Used rapid install and other Oracle Application maintenance utilities like OEM, CRS Cluster.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Experience in designing, implementing and supporting highly available RAC clusters for companywide single sign on application, as well as other database solutions using advanced replication and standby (data guard) options.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup. Incomplete recovery and disaster recovery using Standby database or Data Guard by implementing RMAN backup.
• Experience in performing Oracle 11g databases on single RAC Cluster and also Configured two node Oracle 9i RAC cluster.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc.
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms

TECHNICAL SKILLS

Relational Databases: Oracle 12c,11g, 10g, 9i, MS SQL Server

Languages: SQL, PL/SQL, UNIX Shell Scripts, HTML,C,C++,PASCAL,COBOL,FORTRAN

Tools: OEM/Grid Control, Toad, Visual Studio, Microsoft Office, WinSCP, Putty, PL/SQL Developer.

Oracle Utilities: RMAN, Data Pump Export/Import(expdp / impdp), SQL* Loader, DBCA

Disaster Recovery and High Availability: Oracle Data Guard, Oracle RAC 11g,Golden Gate

Storage Systems: ASM (Automatic Storage Management),Veritas, Hitachi, NetApp& EMC

Operating Systems: UNIX, Sun Solaris, Red Hat Enterprise Linux, Windows Servers

PROFESSIONAL EXPERIENCE

Confidential, Romulus, MI

Oracle DBA

Responsibilities:

• Maintaining the database availability and security
• Involved in maintenance & updating the database
• Manage several heterogeneous database instances
• Created Oracle tables in Oracle, Partitioned tables, Created Indexes.
• Recommend alterations/enhancements to improve database optimization.
• Troubleshoot, diagnose and resolve complex database problems; ensuring high performance operation and minimal disruption of business critical systems.
• Planning, designing and implementations of strategies for backup & recovery
• Review of Database logical and Physical design
• Install, upgrade and maintain Oracle 10g, 11g on Sun Solaris and Windows 2003, Redhat4
• Installation, setup and configuration of DATA GUARD
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database
• Write and modify UNIX shell scripts to manage Oracle environment
• Performed Data Migration as a part of enterprise data warehouse project
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup
• Setup and Configure Replication of Oracle Databases using Streams and Golden Gate
• Cloning databases using scripts as well as RMAN
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files
• Logical and Physical data modeling using Erwin, Dimensional/ OLAP Data Modeling, Relational/ OLTP modeling

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

Confidential, Spring Valley, NY

Oracle DBA

Responsibilities:

• Installation, Upgrade and Configuration of Oracle 10g, 11g databases on Linux/Solaris platforms.
• Installation, Configure, setup of 10g RAC; Add new nodes to RAC 10g Cluster to distribute the load
• Performed upgrades from 10g to 11g and applied quarterly patches.
• Setting up RMAN, Hot and Cold Backups, Exports.
• Configuration of Oracle Enterprise Manager - OEM 11g tools for monitoring, performance enhancement and debugging.
• Real Application Clusters monitoring, tuning, load balanced using OEM (Oracle Enterprise Manager), Stats pack, and V$ dynamic views.
• Involved in Database Design & Data Modeling (ERWIN).
• Development of solutions for enhancements based on a technical specification
• Analyze, design, develop, test and deploy stored procedures, packages, functions, triggers, cursors and Schema objects in the database and support post deployment
• Installation, setup and configuration of physical Standby Database using Data Guard.
• Setup of Oracle two-wayreplication using Oracle streams, daily monitoring and troubleshooting of streams issues.
• Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack & tkprof.

Environment: Oracle 10g and 11g, Sun Solaris, Red Hat Linux, OEM, RMAN, Export/Import, SQL, PL/SQL

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Providing production support for 24X7 database availability for Oracle Database
• Worked on 2,4 and 8 node RAC databases with volumes up to 2.5TB
• Continuous performance monitoring and tuning of the databases and application using OEM, AWR, ASH, Explain plan, ADDM, tkprof, DBMS stats
• Migration of Oracle on Unix to Oracle on VM
• Migration from SQL Backtrack to RMAN as backup utility
• Convert the databases to use Data Domain
• Oracle active data guard installation and maintenance
• Performed Data Guard switchover/failover as per the requirements
• Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option
• Use expdp/impdp, Data Pump utility to perform data refresh
• Regular DBA activities of Space Management and Performance Monitoring

Environment: Oracle 9i and 10g, Sun Solaris, Red Hat Linux, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Created test databases from the production environment as per development team requirement for testing purposes
• Performed database backup and recovery using Oracle Recovery Manager and UNIX Shell scripts
• Performed cold and hot backups of database on a regular basis
• Tuned the performance of the SQL’s using AWR reports, stats and OEM
• Interacted with user for troubleshooting problems with database performance and SQL query tuning
• Maintained database security by managing user’s roles, privileges and auditing users
• Coordinated with System administrators, application developers for various activities
• Generated working documentation for the DBA team use

Environment: SQL*Loader, SQL*Plus, Oracle 10g/11g, Oracle Enterprise Manager, PL/SQL, RMAN, Linux

Confidential

Software Developer

Responsibilities:

• Developed Software for Primary Market Management System for mutual fund, Bonds and insurance using visual basic 6.0 in front end and, Ms Sql server 2000 in back end.
• Developed Software for Environment Consultancy System using visual basic 6.0 in front end and Ms sql server 2000 in back end.
• Extensively worked on DAO, ADO controls, DLL etc in VB 6.0
• Write various triggers and stored procedures for a MS Sql Server database.
• Extensively use of procedure, views, Cursors, Constraints, Indexes, in MS Sql server 2000
• Use of SQL for Generate Various Reports for Clients.
• To play an active role in the product definition process and design methodology.
• To create detailed specifications includes database design, ERD, DFD etc.
• Development of functionality and analysis of product to meet the business needs of customers.
• To translate design requirement and specifications into robust implementations.
• Design and implement effective user interfaces that are intuitive and easy to use in the design and planning process.
• Testing and error handling of product.
• Designing attractive forms, reports etc.
• Creating functions and procedures as per requirement
• Creating effective graphical user interface to understand and easy to operate.
• Includes some utilities, which help user to handle software.

Environment: Windows 2000/Xp, Visual Basic 6.0, MS Sql Server 2000, MS Access 2002,Seagate Crystal Roports