SUMMARY

• Over 11 years of IT Experience in various domains including Banking, Telecommunication, Aviation & Financial and Real Estate Lending.
• Worked as a team member to provide 24x7 on - call production database support.
• Experience in implementation of 3-node RAC (11g R2 and 10g) with ASM.
• Good Knowledge of Oracle 12c Multi-tenancy, container and pluggable databases.
• Installed Goldengate on 11gR2 and 12c database servers
• Configured and supported uni-directional and Bi-directional oracle-to-Oracle replicated environments Using Goldengate.
• Migrated databases from Solaris to Linux with zero downtime using Goldengate.
• Configured manager process to automate purging of the old trail files.
• Created compare pairs and jobs in Goldengate veridata to compare data between source and target databases and eliminate the gap.
• Managed Oracle RAC database configurations utilizing Goldengate and Dataguard to ensure maximum availability and data protection.
• Proficient in Exadata configuration/Maintenance/Support/Dataguard/backup/recovery/failover and switchover.
• Experience on Exadata Full rack/Half rack/Quarter rack
• MonitoringExadatasystems using OEM 12candExachkutility.
• AdministeringExadatastorage servers usingcellCLIanddCLI.
• Worked on Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
• Upgraded databases from11.2.0.4 to 12.1.0 and incorporating the changes in the database design.
• Migrated databases from File System to ASM and from Single Instance to RAC
• Extensive experience in setting up Dataguard, Grid control and Oracle Enterprise Manager.
• Worked on Active Dataguard and setting up physical standby database.
• Worked on Dataguard switch over test and Failover test using Flashback and snapshot standby.
• Worked on setting the physical standby database on a 2 node RAC
• Configured Dataguard Broker and worked on gap resolution between Primary and Standby sites.
• Excellent experience in performance tuning using EXPLAIN PLAN, SQL TRACE, AWR, ASH and ADDM reports
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g and 11g, with experience within very large scale database environment and mission critical large OLTP systems.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN Active database duplication.
• Skilled in developing RMAN scripts for database backup including hot and cold backup options for both RAC and standalone instances.
• Good experience in resolving the issues related to installation, upgrades and patches.
• Excellent Troubleshooting skills in OS level and Database level.
• Awareness on Oracle Support processes for technical requests through Metalink.
• Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control and TOAD
• Good experience in Transportable Tablespaces, SQL Tuning Advisor, Data Pump, Flashback Table, Tablespace Management, Materialized Views, and Oracle Streams.
• Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, Logical and Physical Database Design, Backup and Recovery procedures.
• Experienced in resolving the issues related to installation, upgrades and patches.
• Experience in a variety of hardware and software platforms including Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, Confidential -UX & AIX
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS)
• Extensively worked on Database administration activities like SQL server 2000, 2005 and 2008 DB Installation, Configuration, Backup & Recovery and Database Security.
• Experience in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Installed Service Packs in SQL 2000/2005 in standalone and clustered environment.
• Experience working with Windows 2003 Server - Administration and Installation.
• Database and log backups & restoration, backup strategies, scheduling backups.
• A Self-starter with positive attitude, willingness to learn new concepts and acceptance of challenges
• Good co-ordination and communication with system administrators, Business, Data Analysts and development teams.

TECHNICAL SKILLS

Operating Systems: AIX, Confidential /Sun Solaris, RedHat Linux, Windows Server

Databases: Oracle 12c/11g/10g/9i/ Real Application Clusters (RAC), SQL Server 2000/2005/2008.

Languages: SQL, PL/SQL, Transact SQL, C, Perl, Shell

Tools: Goldengate, Toad, Erwin, SQLT, SQL developer, Enterprise Manager

Domain Knowledge: Banking, Aviation, Financial, Tele Communication

PROFESSIONAL EXPERIENCE

Confidential, Irving-TX

Sr. Oracle DBA

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Developing and maintaining standards (SOE) and comply with Confidential 's Audit requirements
• Manage, deploy and installOracledatabases 11GR1 & 11GR2 on RAC and non-RAC hardware (AIX 6.1, RedHat 5.3).
• Installed Golden Gate on 11gR2 and configured unidirectional and Bi-directional replication.
• Configured manager process to automate purging of the old trail files.
• Worked on Goldengate veridata to create compare pairs and jobs to compare data between source and target databases.
• Configured Extract, datapump and replicat groups for database migration and schema migration across OS.
• Resolved issues in conflicts between source and target databases using Goldengate.
• Exadata Database machine administration and patching.
• Focusing on Exadata administration on Full rack, Half Rack and Quarter Rackand incorporated Dataguard for maximum Availability.
• Used OEM (Oracle Enterprise Manager) for Database monitoring and maintenance activities, which include checking alert logs, space management, and undo management, gathering database statistics, database locking issues and other database issues.
• Establishing and monitoring database RMAN backups and datapump export of schemas (hot/cold).
• Configured Physical standby database using Oracle 11gR2 Dataguard for high availability and disaster recovery solution.
• Tested the switch over of primary and standby databases using Flashback.
• Migrated databases from single Instance to RAC and from file system to ASM.
• Installed 12c agents, Created templates and configured OEM Grid control
• Upgraded databases from11.2.0.2 to 11.2.0.4 and from 11.2.0.4 to 12.1.0
• Applied quarterly patches to both GI home and database home in a rolling fashion.
• Implemented Data Pump, Import and export techniques for Schema level export and imports.
• Create PL/SQL Stored Procedures, Triggers and Packages, Functions, Views and Materialized views.
• Cloned databases using Active Database duplication.
• Performing SQL*Loader jobs for loading data from text files.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, AWR and ADDM reports.
• Monitoring and troubleshooting SAN related issues
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Environment: Oracle 12c/11g/10g/ RAC, ASM, Dataguard, Goldengate, Exadata, IBM AIX 5.3, Red Hat Linux 4/5/6,and Grid Control (OEM). Goldengate Veridata

Confidential, Plano-TX.

Lead DBA

Responsibilities:

• Lead a team of 5 DBA’s on a critical project to migrate the databases from Nortel to Ericsson
• Responsible for administration and supporting Oracle 11g, 10g, 9i and 8i databases which includes Dev, Integration and Production databases.
• Installation and Setting up of 11gr2 RAC with ASM on Red Hat 5
• Worked closely with application teams in the migration process of the 9i and 10g databases doing performance testing and designing optimal migration process.
• Configuration, maintenance and tuning of 11gr2 3 nodes RAC Cluster.
• Migrated databases from solaris to Linux using Goldengate
• Configured DML and DDL changes to replicate on the target databases using Goldengate.
• Resolved gaps and conflicts in the Goldengate replication.
• Setup, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection
• Configured RMAN backups using VERITAS Netbackups
• Analyzing the query performance using EXPLAIN PLAN and tkprof utilities
• Involved in the system setup for the new clients and releasing the cycle code to all the existing clients.
• Periodic monitoring of database performance, size, growth trends, approaching thresholds
• Analyzing messages generated by alert log files.
• Evaluating & Performing database upgrades
• Applying new database patches and upgrading to new application releases
• Responsible for documenting database changes
• Performing backup and recovery operations
• Planning Backup/ Restoration Strategy, Scheduling Backups, taking Logical Backups (with Export/ Import Data Pump utilities)
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Created database maintenance plans, including updating statistics, re-indexing, structure modifications, Capacity plans, and index analysis
• Storage Management Managing Space, Table Spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Data Modeling, Database Design and Creation using ERwin

Environment: s:Oracle 11g/10g/9i, RAC, ASM, Dataguard, AIX 5.3, Red Hat Linux 5, Grid Control (OEM), Toad and Goldengate.

Confidential, New York

Oracle & SQL Server DBA

Responsibilities:

• Installed Oracle 11gR2 RAC with 2 Nodes on (RHEL- 5.0,64-bit Processor) with New SAN Storage
• Performed Migration of the databases from file system to Automatic Storage Management (ASM)
• Experience ensuring the high availability, Performance and integrity of databases.
• Configured physical Standby databases with Dataguard and managed Dataguard using data guard broker (DGMGRL).
• Installed Oracle 10G and 11G, Gridcontrol Agents on Linux, Sun Solaris and Windows servers.
• Have worked as Data modular building complex logical data models using sophisticated modeling techniques and tools like TOAD, Erwin, Visio and KeepTool.
• Responsible for Data Modeling and converting Domain model to Data model- logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, streams, failover and Disaster Recovery.
• Setup backup and recovery procedures using RMAN.
• Have done database backup and recovery using (Cold backup/ Hot backup/ Logical).
• Created and managed database objects such as tables, indexes, partition tables and views.
• Created and managed users, roles, privileges, profiles, schemas using OEM.
• Manage data architects, data administrators and client enhancement requests.
• Handling large database environments (Data warehouse) using ETL tool and Oracle Enterprise Manager (OEM), Grid Control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• SQL tuning and Database tuning TEMPhas been done based on reports generated by SQL Trace, TKPROF Reports, AWR, Statspack, Explain Plans and monitor the database performance on daily basis. Having stored outlines before and after Database tuning to stabilize and optimize the database by changing the parameters.
• Strong ability with UNIX shell scripting to automate tasks and also in Crontab and dbms scheduler for scheduling jobs.
• Extensively worked on Database administration activities like Installation, Configuration, Backup & Recovery and Database Security.
• Expert in upgrade and configuration of MS SQL Server and databases in clustered and non-clustered environments.
• Installed Service Packs in SQL 2000/2005 in standalone and clustered environment.
• Experience working with Windows 2003 Server - Administration and Installation.
• Monitoring alerts through SCOM and MOM.
• Good in Implementing SQL Server change control process.
• Established and maintained disaster recovery, backups, restore, attach, and detach migrations across SQL servers
• Database and log backups & restoration, backup strategies, scheduling backups.
• Created Database Security by giving proper permissions to users and Admins.

Environment: s: Sun Solaris 9.0, Linux 5.0, Windows 2003, Dataguard, ASM, Oracle 11g/10g/9i, SQL*Plus, Grid Control, TOAD, SQL server 2000, 2005, 2008

Confidential, Wilmington-DE.

Oracle Database Administrator

Responsibilities:

• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Have worked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Installation and creation of Oracle 9i databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases from 9i to 10g, applying patches.
• Expertise in VCS enterprise agent for EMC and SRDF configuration.
• Experience in handling GUI software and OS.
• Database Restore using RMAN, Cold Backup and Export.
• Setup, configured and managed oracle 10g RAC database for high availability.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used import/export, Datapump and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX, Confidential -UX 11.23, Solaris 9, Windows XP, Oracle 10g, RAC, OEM, Grid Control, RMAN, DBCA, Dataguard, Putty, TOAD 8.1, Erwin, Linux 4.0.