SUMMARY

• Oracle Professional with 9 Years of extensive experience on Oracle 11g/10g/9i Database Administration UNIX ( Confidential - UX, Solaris, Linux, AIX) & WINDOWS Operating systems.
• Installation and administration of Oracle 11g/10g/9ion OEL, RHEL, Confidential -UX, Windows, UNIX and Sun Solaris in OLTP environment.
• Managed Databases in the range from 50GB to 30TB.
• Performed Migration and Upgrade of databases to 11g and 10g.
• Upgradation of databases by applying patches, patch sets and critical patch updates.
• Installation and configuration of Oracle Server 11g RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
• Extensive experience on Oracle 11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment
• Experience in Configuring Automatic Storage Management (ASM).
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Extensive experience in configuring and managing Dataguard on RHEL, OEL and Windows.
• Configured Active Dataguard.
• Configuration of dataguard broker on RAC.
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
• Experience on DataReplication using Snapshot, Materialized views, import/export and Oracle Streams.
• Regular database synchronization for test database environments through automation.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp.
• Migration of databases from one platform to another platform.
• Extensive experience in migration of databases with export/import, expdp/impdp, RMAN.
• Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
• Experience in SQL Tuning, Optimization, cost based optimization and Hints
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
• Proficient in INDEX REBUILDING and INDEX TUNING.
• Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
• Experience working with Database Resource Management
• Working experience in creating materialized views.
• Proficient in writing PL/SQL Procedures, Functions and Triggers.
• Experience using Erwin as a Data Modeling tool & Designing the ETL processes
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

TECHNICAL SKILLS

Database: Oracle 11g, Oracle 10g, Oracle 9i.

Oracle Products: Oracle grid control, Oracle Enterprise Manager (OEM), SQL * LoaderExport and Import, Expdp and Impdp, RMAN, ASM.

Other Tools: VERITAS, Putty, Oracle streams, Win Scp, VNC server, Toad, ETL.

Programming Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL.

Operating systems: OEL, RHEL, AIX, Solaris, Windows XP, Windows server 2003.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Experience with administration of high - performance and large-scale multi-terabytes databases
• Installation, configuration and maintenance of Oracle 11g and 12c databases
• Implementation multi node RAC on Oracle 11g and Oracle 12c with ASM
• Also added nodes to RAC for minimizing the downtime and maximizing the availability and also achieving load balancing
• Involved in construction of DR sites for all the Production databases
• Performed Database Refresh from Production to QA, UAT and Development databases
• Upgraded the Oracle 10,11g database to 12c version and also applied patch set and interim patches
• Designed and implemented database backup/restore methodologies using RMAN
• Performed Import and Export using Oracle Data pump utilities
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases
• Configured and supported Golden gate 11g & 12c versions for uni directional replication and on heterogeneous platforms
• Upgraded Golden gate versions from 11.2 to 12.1
• Supported application teams to create necessary objects, granting privileges & roles etc for respective projects
• Administered and maintained database security policies and procedures
• Extensively used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics
• OEM Grid Control installation and configuration for monitoring and performance tuning
• Proactive performance monitoring, and capacity planning for future database and server growth

Environment: Oracle 12c/11g/10g, Oracle 11g RAC, Oracle 10g RAC, Data guard, Red Hat Linux, Confidential -UX, Sun Solaris, IBM AIX, Windows, TOAD, Grid Control, SQL, PL/SQL

Confidential, Ontario, CA

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, upgradation and maintenance of Oracle databases of Oracle 10g& Oracle 11g on RHEL 6.
• Configuring and maintaining of a two node RAC on Oracle 10g& Oracle 11g.
• Managed users and maintained security, populated databases of Oracle 10g& Oracle 11g on RHEL, Solaris and Windows 2003.
• Implementation of Data Guard for disaster recovery on both 10g & 11g.
• Configured and maintained Oracle Golden Gate.
• Migration ofdatabases from Solaris to Linux.
• Involved in migration of applications of the clients.
• Configuring ASM with normal and external redundancy.
• Managed Databases related to retail, Telecom and health Clients.
• Restoring databases from Critical failures.
• Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible.
• Responsible for scheduling backups.
• Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters.
• Taking Incremental backup using RMAN.
• Creating tables, tablespaces, users, views and related objects.
• Used SQL*Loader to load data into database tables.
• 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.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 10g, Oracle 11g,Linux 6, Solaris 10, Window 2003, Oracle Enterprise Manager Database Control, RDBMS, TOAD, SQL*Loader, PL/SQL, Shell Scripting, PERL, ASM, Data guard, Oracle Streams, Oracle primavera.

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Oracle Database software installation, Instance creations, schema creations.
• Upgradation of databases from 9i to 10g.
• Configuring and Maintaining of Physical Standby databases.
• Supported different Databases like Production, Testing, Staging and Training.
• Implementation of dataguardon 9i.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Online and Offline Database backup and Recovery using RMAN.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node applications
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import)EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client - Server environment using TNS Names, LISTENER, Net Configuration Assistant and other configuration files.
• Extensively used SQL* LOADER as a tool for loading data.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• Extensively compressed large tables in Data warehouse Environment to reduce space usage.
• Created and Managed users, user profiles, tablespaces, data files, archive log.
• Created database links that are required for databases.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting, PERL, Data warehouse, AIX 4.3 etc.

Confidential, Virginia Beach, VA

Sr. Oracle DBA

Responsibilities:

• Installation and maintenance of Oracle 9i/10g on Linux OS
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• 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.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Environment: Oracle 9i, Window NT/2000/2003, Linux, Unix, Oracle Enterprise Manager, MS SQL Server 7/2000, RDBMS, VERITAS Net backup, PL/SQL, TOAD 7.5, Shell Scripting, HTML, Stored Procedures, Triggers.

Confidential

PL/SQL Developer, Oracle DBA

Responsibilities:

• Installed and Configured Oracle 9i Software.
• Worked on Oracle 9i OEM for regular database management.
• Wrote PL/SQL procedures and triggers to carry out database maintenance tasks
• Created different views as per the business needs
• Created materialized views and snapshots for high end application usage.
• Created and used different types of sequences and indexes.
• Planning, Installation and Configuration of Oracle 9i on Sun Solaris and Windows 2000 Server.
• Performance tuning of database using stats pack reports.
• Backup and Recovery operations over all databases, ensuring 100% recoverability using RMAN.
• Wrote control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Created Table space, Data files, Indexes and monitoring them.
• Designed and created schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Understanding business data relation ships
• Prepared documents and loaded on to knowledge base portal of the company.

Environment: Oracle 9i, Windows (NT/2000), Sun Solaris, TOAD, PL/SQL, SQL*PLUS, Explain Plan, Statspack etc.

Confidential

Oracle Database Administrator

RESPONSIBILITIES:

• Evaluate h/w, capacity planning.
• Re - tolled backup and recovery strategy.
• Oracle Standby/Failover Administration.
• Done database cloning to setup Test & Development Databases.
• Used Flashback utility to restore the erroneously deleted objects.
• Used Datapump utility instead of Export/Import.
• Performance Tuning of the databases.
• Performed partitioning on oracle large tables.
• Design of Data Models using Erwin. Worked on designing of Dimensional Data Models.
• Helping Dev team to move database objects from Dev environment to PROD.
• Creating and maintaining database roles and privileges.
• Database Migration across various OS and in between different databases.
• Used Security features such as FGAC, Roles and privileges.
• Performing Various Backup (HOT&COLD) and Recoveries using RMAN.
• Good understanding of Data warehouse tasks such as data mining, data integration, data cleansing, data transformation and data governance.
• Having good knowledge with creation of Metadata.

Environment: Oracle 9i/10g, Solaris 8.0, Confidential -UX, RHE Linux 5.3, SQL/PL-SQL