SUMMARY

• Around 10 Years of experience as Oracle and LDAP Database Administrator Worked extensively on Oracle12c,11g, 10g, 9i, 8i, MyQSL, SQL Server and Exadata Database Machine, involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, replication, database security, cloning, space management and also I experienced using Oracle VM on an Exadata Database Machine.
• Installed and Maintained Oracle RDBMS Software (12c, 11g, 10g, and 9i) and MySQL, SQL Server on different flavors of UNIX (HP - UX, AIX), Linux (RHEL, SUSE, and OEL), Sun Solaris and Windows Platform.
• Working as onsite DBA lead and managing the offshore team.
• Installed and configured MySQL on Linux and Windows environments. Managing, Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
• Effectively configured MySQL Replication.
• Designed databases for referential integrity and involved in logical design plan. Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Having Experience on Data center servers and handling 1.4 TB databases.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Have implemented standby databases supported by DATAGUARD physical standby databases in 10g, 11g & 12c.
• Have implemented High Availability setup of SQL Server and MySQL databases
• Implemented GoldenGate Replication (unidirectional, Bidirectional & peer to peer configuration of Oracle 12c and 11g).
• Troubleshooting GoldenGate replication issues in prod and non-prod servers.
• Design logical/physical data modeling of all internally developed databases.
• Perform database-related performance tuning and optimization to improve the performance of the system.
• Resolves complex or ambiguous database issues.
• Responsible for all of the server and database security for all environments. Create necessary server and Active Directory groups in order to provide.
• Participates in systems planning, scheduling and implementation.
• Assists with data conversion and normalization, as necessary.
• Maintains existing third-party and in-house developed scripts and databases.
• Create and maintain database documentation.
• Provide assistance with technical support to developers and analysts.
• Administering and tuning databases on Linux based platform. Solid knowledge of Linux / UNIX operating systems, shell scripting and Perl scripting.
• Experience working directly on Oracle RAC, OEM and Data masking pack.
• Oracle SQL or PL/SQL development experience.
• Experience with installing, configuring, upgrading and tuning Oracle 12c on Linux.
• Experience with configuring database accounts using Active directory.
• Install, configure and upgrade of software including code deployment.
• Experience with Oracle Enterprise Manager (OEM) 12c, Oracle Recovery Manager (RMAN), and have UNIX shell scripting, SQL Scripting and PL/SQL experience.
• Monitoring and performing Data guard databases and Performing DR switchover and switchback activities on part of DR test annually.
• Migrated databases from NON-ASM to ASM instance.
• Upgraded the ASM instance from 11g to 12c.
• Experience in upgrading databases from 9i (9.2.0.8) to 10g (10.2.0.3), 10g (10.2.0.4) to 11g (11.1.0.6) and 11g to 12c.
• Experience working with SQL Tuning tools like SQL Trace, Explain Plan and SQL profiles.
• Expertise in Tuning Memory, I/O and CPU Utilization, Disk Usage and Space Utilization.
• Performing RMAN backups (Full, Incremental).
• Performing Patching activity on each quarterly basis.
• Worked on large-scale databases with size more than 20TB in large system environments.
• Having hands on experience in Cloning of databases using RMAN.
• Created development, testing, staging RAC environments.
• Maintaining the RAC environments and performing daily activities.
• 24/7 Production Support for the databases and support to the developers and end-users.
• Refreshing the schema using DATAPUMP, export/import as per application team request.
• Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments.
• Management of Schemas, Objects & Partitioning the tables & indexes.
• Performing Recovery Operation in the database.
• Excellent communication and interpersonal skills.

TECHNICAL SKILLS

Database (RDBMS): Oracle Database 12c, 11g, 10g, 9i, 8i, MS SQL Server 2000,2008,20102012,2014, DB2, MySQL and MS Access and Oracle on an Exadata Database Platform

High Availability: Oracle Database 10g, 11g and 12c Real Application Cluster, MS SQL Server 2008, 2012 and 2014 Clustering and on an Exadata Database Machine.

Replication: Oracle Streams, Materialized View, GoldenGate, and Oracle DataGuard.

Operating System: UNIX - Sun Solaris, IBM-AIX, HP-UX, RedHat Enterprise Linux 4.0, 4.55.0, 6.0, 7.0, Oracle Linux 5.4, 6.0, 6.4, 6.6 and 7.0, Microsoft Windows Server 2000, 2003, 2008, 2012 and 2014/NT Environment, CentOSUbuntu and Debian.

Operating System Cluster: IBM-AIX and Microsoft Windows Server.

Tuning Tool: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Programming Language: C, C++, VB, Oracle 9i, 10g and 11g Forms & Reports DeveloperJavaScript, Java and UNIX Shell Scripting, Ksh, bash.

Development Framework: Spring Framework - 3, Struts - 2.

Query Language: SQL and PL/SQL.

Data Access Tools: Toad, SQL*Plus and SQL Developer.

Data Modeling Tools: Toad Data Modeler, SQL Developer Data Modeler.

DB Monitoring Tool: Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad, Percona Toolkit, Common Schema Query Digest UI, mydumper andMySQL Sandbox

DB Backup &Recovery: Recovery Manager(RMAN), DataPump and Export, Import, mysqldump, hot backup (the officialOracle MySQL Enterprise Backup orPercona's Xtrabackup ) and storage snapshots.

Data Loading: DataPump, Export and Import, SQL Loader and External table.

MS SQL Server Replication: Transaction, Merge and Snapshot.

Database security: Database Vault, Audit Vault, Key Vault, Database Firewall, TDE.

ETL Tool: Oracle Warehouse Builder, Business Objects.

Data Warehouse and BI: OBIEE.

Project Management Tool: Microsoft Project and JIRA.

Source code Mgmt. Tool: Subversion (SVN).

IDE: Eclipse, Netbeans.

Server Monitoring Tool: SAR HP-UX, GLANCE, TOP-RHEL, WhatsUp Gold.

Web Servers: Oracle WebLogic Server and Tomcat.

Domain management Tool: Microsoft Active Directory.

Web Tools: HTML, XML.

PROFESSIONAL EXPERIENCE

Confidential, NJ

LEAD Database Administrator

Responsibilities:

• Maintenance and Administration of 11g/10g databases on, Red Hat Linux 4 Node Cluster with database sizes ranging from 30GB to 20TB and managed these databases in different Data Centers and Reporting databases.
• Administration and management of the entire development, QA and production environment.
• Installed and configured MySQL on Linux and Windows environments. Managing, Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on both Linux (5.0, 5.1) and Mac OS X.
• Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. Assisted with sizing, query optimization, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.
• Worked with the engineering team to implement new design systems of databases used by the company.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Expertise in T-SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log Shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Effectively configured MySQL Replication.
• Designed databases for referential integrity and involved in logical design plan. Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Implemented GoldenGate Replication in non-prod & prod servers (unidirectional, bidirectional & Peer to peer configuration).
• Involvement in the timely Database and Application releases for application. Interacting with the Development team, Application Team, System Administrators and Release teams.
• Working On performance tuning the database using utilities like AWR, ADDM & SQL TUNNING ADVISOR.
• Migration of database servers from Non-RAC (non-ASM) environment on 64 bit UNIX to RAC (with ASM) environment.
• Adding DISKS to ASM Disk groups and resizing the data files.
• Maintenance and Administration of 4 node High availability RAC 11g databases with ASM shared storage, failover and Disaster Recovery procedures using a Physical Standby.
• Experience implementing Restore and Recovery strategies using RMAN cold/Hot backups and cloning databases using RMAN duplicate and scheduling the backups using Crontab.
• Refreshed Application schemas from Production to Test using Datapump and Export/Import.
• Setup and Maintenance of Oracle Advanced features like Oracle FLASHBACK and Flash Recovery Area, Data Guard (Physical Standby) and Failover procedures.
• Renamed database with DBNEWID Utility.
• Applied latest PSU patch updates from MOS to GRID and RDBMS on 11.2.0.4.
• Installation and configuration of Oracle Client on Application servers.
• Created and troubleshoot of DB Link issues in Oracle for communicating with external databases.
• Analysis and management of Oracle problems/defects using SRs and/or MOS with Confidential and installation of patches.
• Administering, maintaining, developing and implementing policies and procedures for ensuring the accessibility, integrity and security of all databases by following policies and procedures and documentation of every step.
• Managed crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Responsible for Change Management, Incident Management, Problem Management, Security Management, Backup Management etc.
• Recovered the database from block corruption in the data file.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: s: Oracle 12c,11g, 10g, 9i,MS SQL Server 2008, 2010, 2012, 2014, MySQL, SQl*Plus, PL/SQL, Oracle RAC and Replication, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux, Oracle GoldenGate, Oracle GoldenGate Monitor, Oracle Veridata and Oracle GoldenGate Director, Toad Data Modeler, SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad Percona Toolkit, Common Schema, mysqldump, hot backup (the officialOracle MySQL Enterprise Backup orPercona's Xtrabackup ) and storagesnapshots.

Confidential

Senior Oracle DBA

Responsibilities:

• Installation and Maintenance of Oracle 9i, 10g, 11gR2 RAC on IBM-AIX, LINUX, HP-UX, Solaris and Oracle 11g RAC on an Exadata Database Platform
• Implemented the Oracle 11gR2, Physical Data Guardand Oracle 11g on an Exadata Database Platform
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 10TB on RAC.
• Upgradation of databases applying patches, patch sets, critical patch updates and PSUs.
• Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Worked with very large scale Database environment and mission critical OLTP and OLAP systems ranging from 1TB to 4TB.
• Upgraded the database from 9.2.0.8 to 11.2.0.2
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• 24x7 remote support and on call support for Production databases.
• Performed cloning of database using RMAN.
• Performance tuning of database by using the reports AWR, ADDM, TKPROF, STATSPACK, EXPLAIN PLAN.
• Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data at the database level.
• Worked on creation of users, granting roles and privileges to users, table space management.
• Planning the backups Hot & COLD backup, Incremental Level 0 and Level 1 Back and scheduling.
• Taken backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Implemented Security user management, privileges, roles, profiling, auditing, authentications etc.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Environment: s: Exadata Database Machine, Oracle 12c 11g, 10g &9i, MS SQL Server 2008, 2010, 2012, 2014, MySQL, SQl*Plus, PL/SQL, Oracle & MS SQL Server Cluster and Replication, Java, Oracle Forms & Report 11g, Tomcat, Oracle WebLogic Server, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux, Window Server NT, Oracle GoldenGate, Oracle GoldenGate Monitor, Oracle Veridata and Oracle GoldenGate Director, Toad Data Modeler and SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad Percona Toolkit, Common Schema, mysqldump, hot backup (the officialOracle MySQL Enterprise Backup orPercona's Xtrabackup ) and storage snapshots.

Confidential

Oracle DBA

Responsibilities:

• Supported Oracle 11gR2 RAC databases
• Responsible for supporting and administrating both Data warehousing and OLTP databases of size 12TB on RAC.
• Installed and upgraded from 9.2.0.8 to 11.2.0.4 RAC database on Linux 6.4
• Cloned 11grR2 RAC Production databases (size of 10TB) for UAT
• Provided Centralized management of information about users and groups using Oracle Collaboration Suite which uses Oracle Internet Directory (LDAP) to store and resolve database services.
• Cloned Productions databases for Test environments using RMAN
• Created the partition table concepts like rang, list etc.
• Configured RMAN Hot and Cold backups
• Analyzing the AWR report for the performance issue
• Performing the DR switchover activity on periodical basis
• Implemented Security user management, privileges, roles, profiling, auditing, authentications etc.
• Refreshed schemas from production to lower environments with re-mapping table spaces for partitioned objects.
• Worked on both ASM and file systems for managing data in SAN.
• Documented the issues/resolutions/process details with maintaining them up to date.
• Created and troubleshoot DB Links issues in Oracle for communicating with external databases.
• Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Managed crontab file, rescheduling the failed jobs (due to errors), changing timings for the scripts to run if the job fails and adding new jobs (scripts).
• Generated weekly performance reports to identify and solve the problems with performance.
• Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.
• Monitoring and resolving tickets in different environments
• Export and Import of database objects to copy from one database to another database between different environments
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities)
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Involved in team management, team building exercises for the DBA team.

Environment: s: Oracle 11g, 10g &9i, MS SQL Server 2008, 2010, 2012 MySQL, SQl*Plus, PL/SQL, Oracle, Java, Tomcat, Oracle WebLogic Server, UNIX - Solaris, HP-UX, AIX, RedHat Enterprise Linux, Oracle Linux, Window Server NT, Oracle Golden Gate, Oracle Golden Gate Monitor, and Oracle Golden Gate Director, Toad Data Modeler and SQL Developer Data Modeler, Oracle Enterprise Manager(OEM), Enterprise Manager Grid Control, Enterprise Manager Cloud Control, Toad Percona Toolkit, Common Schema, mysqldump, hot backup (the officialOracle MySQL Enterprise Backup orPercona's Xtrabackup ) and storage snapshots.