SUMMARY

• Over Twelve Years of experience in Information & Technology as Oracle Database Administration on UNIX (SUN Solaris, AIX, HP - UX), Linux (Redhat, SuSE, Fedora, CentOS) & Windows NT/2000/2003.
• Current working on OEM 12c configuration to get alerts. Installed backup and recovery (RMAN) for all teh databases. Set up parameter to improve databases performance. Installed OEM server to monitor databases.
• Extensively worked as Oracle 11g/10g/9i/8i/7.x DBA, RAC, ASM, Linux/AIX/SUN Solaris/HP-UX systems administration, Data Guard Standby Database, Data Modelling, Database design, Database tuning, Database Security, Data pump, Oracle streams, Golden Gate, Table Partitioning.
• Oracle Patch testing and applied as per application requirement to fix teh bugs.
• Highly experienced in building, configuring, monitoring and maintaining Oracle databases on Linux, SUN Solaris, AIX, HP-UX and Windows in large complex environments. Extensive experience in Database administration.
• Monitoring statistics for database performance analysis using AWR, ADDM, ASH reports. SQL performance analysis using explain plan and SQL Trace.
• Setup Physical data guard for DR solution.
• Installed, configured and managed Oracle Golden Gate 10.x /11.x for oracle replication.
• Tuning memory, which involves sizing of buffer caches, shared pool, Database buffer caches in order to reduce parsing and disk accessing.
• Extensively worked with Managing Security for database user and application developers, created and assigned Roles, Profiles and Privileges to teh various users on Objects.
• Managed Exports and Imports. Responsible for Logical/HOT/Cold backups.
• Extensively worked with Backups and Recovery.
• Database Migration and upgrades from 9i/10gR2 to 11gR2 and across platforms.
• Customized init.ora to in corporate new parameters as per new version releases.
• Extensively work with SQL, PL/SQL, Materialized views and shell scripting.
• Configured Oracle Networking using SQL*NET for setting up Client/Server environment using Oracle Products.
• Database design using modelling tools. Setup development databases and worked with developers to understand and timely resolve their issues.
• Supported production databases and responsible for round-teh-clock database operations. Offering solutions for Production/Development/Testing of database applications. Closely worked with System administrator to take database backup and scheduled maintenance task.
• Involved in System Administration tasks on Linux/SUN Solaris/AIX/HP-UX/WindowsNT/2000/XP/2003 and scheduled teh CRON jobs which run at specified intervals, to create file systems, to allocate teh disk quotas to teh users.
• Installed java component and setup of CDC (change data capture) processes for Data ware house to capture and transfer changed data from Oracle database to SQL database.
• Well versed with Normalized, Star-Schema & Snowflake Schema for designing teh Data Marts.
• Good understanding of OLTP and OLAP Processing.
• Used Quest Software tool for database monitoring.
• Finding bugs as well as provide recommendations to customers.
• Possesses excellent interpersonal and communication skills.

TECHNICAL SKILLS

RDBMS: ORACLE 12c/11g/10g/9i/8i/7.x, MS SQL Server, MySQL

Database Tools: Erwin, Oracle Designer 2000, Quest spotlight, TOAD, EXCEED, Oracle Enterprise Manager, AWR/ADDM, STATSPACK, Datapump, Export/Import, DBMS Packages, SQL Loader, Pro*C, RMAN, RAC, Golden Gate

ERP: SAP, JD Edwards

ETL Tools: Informatica

Backup Tools: VERITAS Net BackupData Storage VERITAS Volume Manager, Tivoli Storage Manager

OLAP Tools: Business Objects 5.1, Cognos.

Languages: SQL, PL/SQL and Shell Scripts.

Web Technologies: HTML, ASP and VB Script.

Web/Application Server: IBM WebSphere, IBM HTTP server, Apache web server, IIS.

Operating Systems: SUN Solaris, Linux, AIX, HP UX, Windows NT/2000/XP/2003.

Hardware: SUN Server, IBM RS6000, HP/Compaq Servers/DELL server.

Networking Tools: SQL*Net, Net 8, TCP/IP, DHCP, DNS, NFS, FTP.

PROFESSIONAL EXPERIENCE

Confidential, MI

Sr. Oracle DBA

Responsibilities:

• Installed, configured and managed oracle 10g/11g/12c on Linux/Unix/Windows platform.
• Installed backup and recovery solution (RMAN) for all teh databases.
• Setup cronjob scheduler on teh database servers.
• Installed, configured and managed Oracle Golden Gate 10.x /11.x for oracle replication.
• Monitoring performance tuning of databases and setup parameter to optimize and improve database performance.
• Installed and configured Oracle Data guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Installed and configured MS SQL Server in Windows environment.
• User creation and implemented user security administration by creating roles, views and granting teh necessary system and object privileges for users.
• Performance analysis and tuning of Oracle databases using AWR and ADDM tools.
• Architecting and engineering of High Availability and Disaster Recovery solution for Oracle.
• Strong knowledge of Linux and UNIX platform (including scripting language).
• Very good experience in Oracle RAC (Real Application Cluster), Data Guard, Oracle Streams, Grid Control, and Golden Gate.
• Engineered and consolidated all teh databases and oracle application servers scattered around in different VMs into dedicated Oracle VM cluster to save significant cost on Oracle licenses.
• Engineered character set migration to support multiple languages and implemented successfully.
• Testing and certifying new patch released for specific oracle database versions on various UNIX platforms and generating run book.
• Design and engineer Oracle client on UNIX,Linux and Windows platform before deployment.
• Responsible for data migration, database upgrade from oracle 9i/10g to 11g and all post-migration analysis and tuning
• Responsible for pre-install analysis, activities, and installation of 10g and 11g software on server and clients and post-install testing and analysis.
• Responsible for Backup & Recovery, Logical/HOT/Cold backup for Oracle Databases.
• Inter-personnel skills working with other team members in same and across organization.

Environment: Oracle 12c/11g/10g on Windows/SLES/RHEL/CentOS/Solaris/AIX, OEM, RMAN, PL/SQL, SQL Plus, HP Gen8 servers, SQL server management studio, Win2005 server, Win2008 server

Confidential, MI

Sr. ORacle DBA

Responsibilities:

• Understanding teh requirement and coordinate with developers to develop teh code and test it in UT and ST.
• Coordinated and guided DBA team comprising 5 members to work on different databases to make sure database availability as per SLA and work with support agency to get resolve teh issue.
• Installed and created 11gR2 database on SUSE10 and configured ASM for Oracle database files.
• Used ADDM and AWR for performance tuning.
• Setup backup and created database using RMAN.
• Maintenance of database activities from Grid Control.
• Installed and configured 11g/10g Client on Windows and UNIX.
• Created Big File table space and transfer data from small table space to big file table space.
• Performed performance and SQL tuning.
• Installed 11gR2/10gR2 Cluster on RedHat Linux Enterprise Server Release 5.2 with 2 nodes on each cluster.
• Configured SSH on each node.
• Configured ASM for Oracle database files.
• Installed Oracle 11gR2/10gR2 software and created oracle database on teh cluster.
• Installed and configured Oracle 10gR2 database on 11gR2 cluster.
• Created Big File table space and transfer data from small table space to big file table space.
• Used ADDM and AWR for database performance tuning of RAC databases.
• Restored backup and created database using RMAN.
• Installed grid agent on teh databases to add them into Grid 10.2.0.5
• Scheduled backup and maintenance activities from Grid Control.

Environment: Oracle 11gR2/10gR2, RAC, ASM, Grid Control, RMAN, TOAD, EXCEED, PL/SQL, SQL Plus.

Confidential, MI

Oracle DBA

Responsibilities:

• Design, Installation OLTP database on Oracle9i on SUN Solaris and HP-UX with Erwin data modelling tool. Database upgrade from Oracle9i to Oracle10g.
• Installed java component and setup of CDC processes for Data Warehouse to capture and transfer changed data online from Oracle database to SQL database and Supported Data Warehouse database extensively.
• Installed and configured Oracle Workspace Manager for developers and DBA to manage current, proposed and historical version of data in teh same database.
• Allocating system storage and planning future storage requirements for teh database system.
• Created primary database storage structures (table spaces) and various segments of Tables, Indexes, Clusters, and Rollback.
• Installed oracle on development databases for developers and tested upgrades.
• Sound experience in administrating teh large live production (24X7) databases.
• Implemented an Effective Backup and Recovery (RMAN) strategy for hot backup, archive logs backup.
• Installed and configured Oracle Data guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• User creation and implemented Security administration by creating roles, views and granting teh necessary system and object privileges for users.
• Fine-tuned teh database for teh maximum performance. Monitoring and optimizing teh performance of teh database.
• Installation and execution of DBMS packages.
• Configured ADDM on 10g DB and generated AWR to analyze database performance. Also used STATSPACK reports and monitoring statistics for performance tuning of teh database.
• Implemented Locally Managed Tablespace to manage space more efficiently, to reduce fragmentation and to increase reliability. Database Recovery (both complete and incomplete) from media failure.
• Implemented Automatic Undo Management in order oracle to manage undo segments efficiently.
• Created schema users with appropriate roles and privileges.
• Used SQL*Loader to populate teh Oracle Database Tables from Flat files.
• Monitoring teh CPU usage, IO statistics, CPU time to identify any OS level performance killers.
• Study of additional client requirement for teh up gradations of teh product.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Taking Backup of Databases Using Data pump, Logical (Export & Import) & Online Backup.
• Writing UNIX Shell scripts for monitoring and backup of databases.
• Created CRON jobs on UNIX for job scheduling.
• Created partition-tables if teh data needed to be stored in some range values.
• Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.
• Ensured latest bug fixes and patches are implemented at teh earliest.

Environment: Oracle10g/9i, PL/SQL, SQL Plus, OEM, OWM, Streams, SPOTLIGHT, RAC, RMAN, TOAD, EXCEED, Pro*C, Sun Solaris, HP-UX, Windows 2003 server, Sun V440 Servers, Dell Servers, HP Servers.

Confidential

Oracle Databases Administrator

Responsibilities:

• Responsible for designing teh Oracle Database & Schemas using Erwin.
• Responsible for data migration, database upgrade from oracle 8i to 9i.
• Responsible for pre-install analysis, activities, and installation of 8i, 9i software on server and clients and post-install testing and analysis.
• 24 X 7 Production Support. Responsible for Backup & Recovery for Oracle Databases.
• Responsible for all post-migration analysis and tuning.
• Responsible for Logical/HOT/Cold backup of Oracle Databases.
• Installed and configured Oracle Data guard on standby servers to online transfer and apply archived log files to keep standby server in sync with primary database.
• Installed & Configured VERITAS Net Backup for Oracle on Unix.
• Monitoring and optimizing teh performance of database.
• User creation and implemented Security administration by creating roles, views and granting teh necessary system and object privileges for users.
• Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of teh database.
• Allocating system storage and planning future storage requirements for teh database system.
• Creation of table spaces, tables, views and indexes.
• Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
• Created Locally Managed tablespaces for better space management and less fragmentation of data.
• Interacted with teh users and troubleshooting teh problems involved with teh development of stored procedures, triggers and problems related to teh privileges & resources.
• Table partitioning as per database requirement.
• Managing of Tablespace for different user by granting quota on Default & Temporary Table spaces.
• Taking Backup & Recovery of Database Using Logical (Export & Import) & Physical (Online & Offline) Backup. Responsible for UNIX Shell Scripts for Housekeeping.
• Performed as System Admin for AIX.
• Installed prerequisite software’s on ES & DS for teh ERP 8.0 Setup.
• Installation of ERP 8.0 with One-off SP22 T1 on Enterprise Server, Deployment Server and Java Application Server.
• Creation of customized environment, Design and Setup of Security including Users, Roles & Profiles.
• Maintain and setup teh ERP 8.0 Job Scheduler, Perform daily task of project promotion and deployment.
• Perform status checks on ERP 8.0 using teh Sever Administration Workbench.
• Perform Vocabulary Override changes and validate their deployment, Activity Rule Setup.
• Installed ERP8.0 on new Enterprise server and Deployment server to upgrade application from Xe to ERP8.0
• Oracle database creation and data migration for old application on new ES.
• FAT client creation on PDC to test teh update activities.
• Modify and execute upload scripts to update old data from Xe to ERP 8.0, tested teh data from FAT client.
• Create separate environment on Current ES and migrated updated data into this environment.
• Backup Enterprise Server installation identical to Production ES.
• Installation of Electronic Software Upgrade & Application Software Upgrade.
• Specs merge for new installations.
• Import Oneworld windows installer and ODBC registry on Deployment server to get ESU information exist on old Deployment server.
• Package assembly /building /deployment on Enterprise Server, Citrix Server & Fat clients.
• Installation of upgrade localization module TDS, Installation of OneWorld FAT clients
• User Management and Security setup, Creation of Group & Menu’s, Scheduled task
• Object Configuration Manager Setup, Setting up Printer on teh Enterprise Server.
• JDE initializations file tuning, Vocabulary overrides, Version control.

Environment: Oracle 9i/8i, JDE Xe/ERP8.0, Citrix Metaframe, TOAD, Erwin, /SQL, SQL Plus, OEM, RMAN, TOAD, Proc*C, COMPAQ ML 530, IBM RS6000, WIN 2K,/NT, AIX, Arc Serve.