SUMMARY

• Over nine years of experience in Database Administration for large databases in Oracle 12cR1, 11gR2, 11gR1,10g, 9i, 8i on Red Hat Linux/Sun Solaris/AIX and SQL Server 2012 SQL Server 2008 R2, SQL Server 2005 and 2000 on Windows NT 4/2003/2008/2012.
• Migration of Oracle databases from 9i to 10g on Solaris platform and from 10g to 11G on Red Hat Linux platform
• Expert in Administration, Productivity and Modeling Tools including OEM(Oracle Enterprise Manager, RMAN, Exp/Imp, Data Pump, Option Packs/OLAP/Partition/RAC, Erwin, TOAD, SQL, Home - made Scripts /Tools, Grid Control, SQL Tuning.
• Built UNIX farm servers by installing and configuring Oracle Clusterware including CRS, ASM, RAC and Grid Control agents on multi-node Oracle RAC clusters, Managed cluster expansion by adding server nodes for scalability and tested clusters for High Availability
• Sound knowledge in Programming such as UNIX Shell Scripting, T-SQL, PL/SQL, Java, PHP, VB.
• Expert in Production Database Daily Administration (such as data loading, data processing, job scheduling via OEM, UNIX CRONTAB ) and Data Warehouse maintenance (such as partitioning tables, creating materialized views), and documented DBA operational procedure for day-to-day activities.
• Installation, Configuration, Troubleshooting Golden Gate Replication in 10g and 11g, migration of Database using Golden gate technology in 11GR2.
• Installed Oracle Server Upgrades and Apply required security patches to Oracle and SQL Server databases as per recommendation from vendors.
• Expert in High Availability technologies such as Oracle 9i/10g/11g ORACLE RAC,Data Guard/Standby Database, Database Replication/Clone.
• Expert in Database Health Maintenance and Performance Tuning using Stats pack, AWR/ADDM, Enterprise Manager, Self-developed Scripts & methodology, Diagnostic and Tuning Pack, DBMS Utilities/Procedures.
• Administer SQL Server High Availability and Disaster Recovery strategies, Expertise in T-SQL, writing stored procedures, triggers and functions.
• Proficient in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Handle multiple SQL Instances on Cluster environment for Server Consolidation projects, configure SQL Server with minimum privileged access
• Upgraded/Migrated from SQL Server 2008/2005 to SQL server 2012
• Proficient in Batch Processing, memory configurations for SQL Server 2012/2008/2005 , database monitoring and Application support.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Expert in Analysis Services (SSAS), Reporting Services (SSRS) and SQL Server services on cluster with different Security groups.
• Proficient in setup SQL Server 2008/2012 Failover Cluster, Log Shipping, Database Mirroring and Replication
• Proficient in high-level Database/IT Skills such as System Analysis and Infrastructure Design, Operating Systems (UNIX/Sun Solaris/AIX, Linux, and Windows), Computer Networks, Database Storage (RAID, ASM, Raw Devices), and data communication networks, data security, business model.
• Proficient in interpersonal relations, Team Lead skills, Project Management, Communication, Outsourcing Partner Teamwork, and Organization, 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

• SQL Server 2012/20
• Oracle 12c/11g/10g/9i/8i
• Erwin 4.0
• MS-Visio
• RMAN
• Oracle RAC 12.1/11.2/11.1/10 g
• Data Guard
• Oracle Enterprise Manager
• MarkView
• ETL
• SQLLoader
• Data Pump
• TOAD
• SQL Server Enterprise Manager
• Sun Sparc E6500
• E450
• HP9000
• RS6000
• Compaq7000
• DELL 6680/ 60/1650/1750/2450/2600
• Dell Power Vault STORAGE
• HITACHI and EMC
• PL/SQL
• MYSQL
• C
• C++
• VB
• Java
• XML
• PHP
• Shell programming
• Golden Gate
• Solaris 9
• HP-UX 10.2
• Windows NT 4.0 and 2000
• 2003
• XP and Windows XP
• Windows 7
• Web Logic
• CA Service Desk
• Clarify
• MS Office Suites 2003/2007/2010 ( Word/Excel/Outlook/Access/PowerPoint)
• Lync(2012)
• NetMeeting
• Share Point.

PROFESSIONAL EXPERIENCE

Confidential, Malvern, PA

Senior DBA

Responsibilities:

• Migrated and upgraded 11.2.0.3/11.2.0.4 databases from Sun Solaris to 12.1.0.2 on Red Hat Linux Platform
• Built new databases on Exadata and Virtual Machine in Red Hat Linux 6.5
• Built Real Application cluster with two nodes with ASM Storage on Exadata Machine, converted Two nodes to RAC ONENODE
• Implemented Golden Gates schema-level Replication between two data centers.
• Implemented and maintained Oracle 10g/11g Physical Active Data Guard/standby databases for Disaster Recovery
• Developed strategies for disaster recovery services of all database machines along with advisory services.
• Resolved Performance related issues by using AWR/ADDM/Trace/OEM, involved in tier-3 level support. Provide timely communications of issues and status to Clients and line Managers.
• Enabled Daily RMAN and Archive job by using CONTROL-M, deployed new release code from NON-PROD to PROD and applied quarterly patches to all environments.
• Monitored system space, database allocation and storage metrics by using ORACLE Enterprise Manager.
• Migrated SQL Server databases from by using side by side method
• Enabling automation jobs of full backup, transaction log, rebuild indexes and database integrity check by using OLA Script in SQL SERVER
• Resolved Performance issues in SQL Server by using Trace/Profiler, Engine Tuning Advisor, and regularly rebuilding cluster and non-cluster indexes.

Environment: Oracle 10g/11g/12c, SQL Server 2005/2008/2012 Enterprise Edition, Windows Enterprise Server 2008/2012, Windows 7, .NET, Microsoft Visio, SFTP, Red Hat Linux, ASM, MS Office suites, Lotus Notes, TOAD, SQL Developer, Control-M, RAC ONENODE, Exadata, VM, SEBRENA team Track.

Confidential, Delta, OH

Senior DBA

Responsibilities:

• Supported around 450 Oracle Databases on Red Hat Linux 5/6 and Z-Linux environments and 170 SQL Server instances on Microsoft Windows Server 2012
• Built 3 nodes Oracle Real Application cluster in 11Gr2 in Red Hat Linux 6 with ASM Storage with High redundancy and migrated standalone databases as schemas to newly built cluster.
• Implemented Physical active/active data guard in production database in 11gr2 and 12cr1
• Migrated databases from 11GR2 in windows environment to Oracle 12CR1 in Z-Linux environment.
• Worked closely with apps/development/deployment teams to resolve databases related issues.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Installed and administered multiple Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition
• Upgraded SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012.
• Migrated/Upgraded SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Widely worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), and Implemented Data partitioning, Error Handling
• Created simple to complicated queries involving self joins, correlated sub queries, tuned and optimized queries by altering database.
• Extensively used Dynamic Management Views, Mirroring, database snapshots and resolved Performance issues, and regularly rebuilt the cluster/non-cluster indexes for better performance.
• Recovered the databases from backup in disasters in shorted time. Documented and implemented multiple methods for Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency, implemented the snapshot isolation and DDL triggers.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction, responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Extensively worked in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Environment: Oracle 10g/11g/12c, SQL Server 2008/2012 Enterprise, Windows Enterprise Server 2012, Windows 7, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services, SSIS, SSRS, SSAS, Red Hat Linux, Z-Linux, ASM, MS Office suites, Lync, SharePoint, Net meeting.

Confidential, Ann Arbor, MI

Senior Oracle DBA

Responsibilities:

• Designed and Created Physical Databases as per the requirements and migrated 700 databases from 9i/10g to 11gR2 in eight nodes/instances RAC Environment with ASM with multiple redundancy.
• Migrated Oracle 10g from windows environment to 11g on Red Hat Linux Platform.
• Performed day to day administration of RAC databases including creation, deletion, backup, recovery, data migration from Solaris to UNIX cluster.
• Performed Hot/Cold backup Clone from production to staging, moved production databases from one server to another.
• Optimized database performance by analyzing objects, generating statistics, creating indexes and views.
• Installed and implemented 10g and 11g clients on Sun Solaris and Red Hat Linux
• Setup, Configured, implemented Oracle Data Guard using Active/Active physical standby databases in 10g and 11g
• Monitored script, creation of log files, packages & script, developed scripts for integrated jobs
• Utilized Active Dataguard (ADG) to create physical standby database and implemented database replication using Oracle Golden Gate in uni-directional, bi-directional and three way.
• Performed Large size Database Backup including Physical backup through Hot Backup/Cold Backup of DEVELOP/TEST/PRDOCTION Databases and Recovery Procedures by using RMAN
• Designed and developed scripts to monitor instances locks, long running queries, listener, free space, extents growth, etc.
• Used ETL tools and OLAP tools for data warehousing for extraction, transformation and loading, worked and integrated data analysis approach by using CA Erwin in several projects in both OLAP and OLTP applications.
• Supported development team in tuning databases and application side for optimal performance using Query explain plans, AWR, ADDM reports, dbms stats and rebuilding indexes.
• Assisted Project Managers and Customers with any issues relating to Performance Monitoring and Tuning by using Oracle supplied tools/third party’s software.
• Managed team, achieved team and individual targets, addressed any issues of concern regarding performance of team members, monitoring performance and developed people competencies with in the team.

Confidential, Houston, TX

Oracle DBA Consultant

Responsibilities:

• Installed, configured, migrated oracle from 8i/9i to 10g production and dev/test databases
• Design Physical Database with logical data model with DDL as entities/attributes/indexes/primary keys
• Created scripts to load data from production databases to dev/test databases
• Implemented database job processing via UNIX/Solaris crontab
• Regular Troubleshooting Oracle errors during development and Test
• Performed production database health check, performance tuning, operation auditing.
• Supported high availability for production databases and development databases by designing and implementing different backup and restore strategies
• Tuned the multiple databases for Performance by Stackpack, ADDM
• Implemented procedures for Oracle database giving 24x7 support, including Disaster Recovery plans
• Refreshed databases from Production database using hot backups
• Implemented Backup and recovery strategies using export/import, RMAN and Netbackup

Environment: Oracle 10g/ 9.0.1.0/9.2.0/9.2.6 /8.1.7 People soft 8.44/8.47, Dell storage, SAN storage, Oracle SQL, PL/SQL, Scripts Bash/Bourne/Korn SQL Loader, OEM, Standby Database/Dataguard Erwin, Toad, Secure Shell, Putty

Confidential

Oracle DBA Consultant

Responsibilities:

• Setup Oracle 10G RAC on Linux Red Hat ES 4.0 Environment for production. Upgrading of Patch from 10.1.0.2 to 10.1.0.4 on production Servers. Migrated oracle 9.2.1 to 9.2.4 and 9.2.6 to 10g.
• Maintaining terabytes of data storage on Hitachi SAN. Configured the logical volumes using Veritas software. Installed and configured the Veritas enterprise edition cluster file system for RAC.
• Daily maintenance of multiple Oracle servers and SQL server Instance
• Setup and configured web access to OEM console including email and paging services.
• Resolving Oracle errors and bugs by working with Oracle Support
• Performance monitoring and tuning of 9i and 10g RAC databases. OEM, Statspack, PL/SQL and Shell scripts.
• Applied patches and migrated databases and maintain an updated platform matrix.
• Cloned/Refreshed databases from Production database using RMAN and hot backups.
• Implemented backup and recovery strategies using export/import, RMAN.
• Worked closely with the in-house and offshore users and QA team in debugging, tuning and trouble-shooting performance bottlenecks in application and network.
• Wrote packages, functions and procedures to implement a module in the attribute-coding engine.
• Designed (and documented) a data migration routine to move production data from SQL Server to Oracle using DTS, Text Files, SQL Loader and External Tables.
• Prepared documentation on HA System, recovery scenarios, data conversion, system setup and configuration for Linux, Hardware, Oracle Software installations, database creation and naming conventions.

Environment: Oracle 10g/ 9.0.1.0/9.2.0/9.2.6 , SQL Server 2000, Dell power vault storage, SAN (Hitachi), Oracle RAC 9.2.0, SQL, PL/SQL, SQL Loader, OEM, Standby Database with Dataguard, Erwin

Confidential

Oracle DBA---Consultant

Responsibilities:

• Configured the Hardware to install the Sun Solaris and Oracle 9i software. Created multiple database instances for HA environment. Applied the updated latest patches to oracle and Sun Solaris.
• Installed and configured the oracle 9i RAC on sun fire servers using Veritas Enterprise edition cluster file system. Setup and maintained Logical Standby Database using Data guard.
• Implemented Backup and recovery strategies using export/import, RMAN and online backups.
• Wrote shell scripts to implement periodic security management on the production databases
• Created scripts to load data from production databases to report data warehouse databases
• Tuned the multiple databases for Performance. Involved in security audit of databases and servers.
• Wrote packages, functions and procedure for reporting.
• Implemented procedures for Oracle database giving 24x7 support, including Disaster Recovery plans.
• Estimate current and future requirements in terms of storage and other resources including capacity planning.

Environment: Oracle 9.2.1/ 9.2.4/ 8.1.7 , 9ias, Sun Solaris, PL/SQL, SQL Loader, OEM, K Shell, J2EE, Veritas NetBackup