SUMMARY:

• A Senior Database administrator with more than 12 years of IT experience in supporting application Databases in Banking and Financial, Health care and Telecom domains running on various RDBMS like Oracle and Sql server and No Sql databases like Mongo db.
• More than 12 years of Extensive knowledge on database administration of Oracle databases which includes version - 8i, 9i, 10g RAC, Oracle 11g RAC and Oracle 12c RAC with experience within very large scale database environment (65 TB) and mission critical large OLTP and OLAP systems.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNSNames, SQL Net,V$ and DBA views.
• Vast experience in Performance Tuning by using tools/utilities like Stats pack, Tkprof, explain plan, Analyze, AWR and ADDM, Tuning Advisor
• Expertise in Oracle Enterprise Manager (OEM), Grid Control.
• Expertise in upgrading Oracle databases to 11g and 12c. Patching GI and RDBMS in 11g
• Expertise in installation, configuration, trouble shooting and administering Confidential replication tool in sun Solaris UNIX and Linux environment.
• Expertise in Oracle RMAN Backup and Recovery.
• Strong knowledge on PL/SQL development like writing, debugging and tuning stored procedures, packages, Triggers, Functions and views etc.
• Extensive experience in Data guard setup, administration.
• 3+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting, S QL Server Replication, Backup/Recovery, Disaster recovery and planning.
• 1+ years of experience in performing Mongo DB DBA operational routines, Configuring and monitoring replica sets, Configuring Sharding, monitoring, and identify the proper shard key
• Extensive Oracle DBA knowledge and experience on Data Warehouse environment.
• Knowledge of NoSQL DB Cassandra
• Worked on supporting Oracle Exadata X3-X4 administration and patching.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Have supported huge data load (ETL) using Informatica, Data stages.. etc and Reporting applications like Cognos and Crystal and Business Object on oracle and SQL server databases.
• Experience in a variety of hardware and software platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX
• Expertise in Unix Shell scripting. Writing new or Modifying existing UNIX shell scripts to manage database operations
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Data pump), Capacity Planning, Confidential, Shareplex, Oracle configuration management, Data guard, database cloning, refresh and patch management.
• Worked as a DBA team lead to provide database supports and leading the team
• Good co-ordination and communication with system administrators, business data analysts and development teams.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C, C++, Basic, Pascal

RDBMS: 8X, Oracle 8i, 9i, 10g RAC, 11g RAC, 12C RAC, MySQL

NoSQL: MongoDB, Cassandra

Scripting: UNIX Shell script (Korn, Bourne, Bash), Perl

DB utilities: Export/import, DATA PUMP, SQL*Loader, RMAN, STATSPACK, TKPROF, Explain Plan, Oracle Warehouse Builder, Crontab

Tools: Oracle Enterprise Manager (OEM), TOAD,SQL*PLUS, iSQL*Plus, Erwin 3.5/4.0, Confidential 10.x and 11.x, Shareplex 5x/6, SQL Server Management Studio, Ractop, mongotop, mongostat

Environment (0S)/Protocol: SUN Solaris 8, 9, 10, 5.8, 5.9, HP-UX 10i, IBM AIX 4.3, 5.3, RH Linux4.3,5.0, Windows 2000/2003/XP/NT, Red Hat Linux, Oracle Exadata X3/X4 .SAN, TCP/IP, IPV4, IPV6, FTP, SSH, DNS, Data warehouse

WORK EXPERIENCE:

Confidential, Jersey City, NJ

Oracle DBA

Responsibilities:

• Managing high-performance, high-capacity databases in a critical production environment .
• Oracle 11gR2 and 12C RAC experience including build, general administration, troubleshooting (Break/Fix) and L3 support .
• Supporting Cluster ware (GRID Infrastructure) - CRS management and configuration and Oracle ASM administration .
• Supporting high-availability solutions such as Oracle Data Guard , Disk replication technologies (SRDF), and VERITAS clustering
• Patching and upgrading oracle databases 10g/11g/12c databases. Installation of database components
• Installation, configuration and administration of datagaurd. Used data guard broker to administer data guard environments.
• Extensive experience in UNIX shell scripting, Crontab to monitor database status, retrieve database statistics for analysis, startup and shutdown database, automatic moving and purging of archive files based on time.
• Supporting very large scale production databases (up to 45 TB )
• Administration and patching of databases hosted on Oracle X3/X4 Full rack.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc
• Performance tuning of database, instance, sql, I/O, using Enterprise Manager (OEM), TOAD, STATSPACK, AWR, ADDM, ASH, SQL Trace, TKPROF, Explain Plan, Sql profiles, Outlines and sql plan baselines.
• Working on user requests - like data refresh using RMAN, data pump, backing up user data, user account maintenance, query tuning, session tracing etc.
• Monitoring Day-to-Day Backups, Log’s and recovering them as per the requirement.
• Installation of GI, Patch Set, PSU and Security Patches for Oracle database environments.
• Supporting Backup, Restore & Recovery using RMAN which includes hot backups and Cold backups. Tuning RMAN backup. Working on RMAN active and back up based duplication.
• Participating in change management, capacity planning.

Environment: 10g RAC, 11g RAC, Unix Sun Solaris 8, 9,10, AIX 6.1, Oracle X3/X4 full rack Exadata machine, RMAN, ASM, Enterprise Manager Grid Control 11g and 12C, Data guard, Data Warehouse, TKprof, Data guard broker, Confidential

Confidential, Middle Town, NJ

Oracle DBA

Responsibilities:

• Migrated Oracle 10g database of Size 15 TB from Solaris 5.8 to oracle 11g on AIX 6.1 using transportable table space method.
• Performed Oracle Confidential 10.4 and 11.1.x replication installation, configuration and monitoring
• Database monitoring using OEM Gird control and shell scripts.
• Administered up to 4 node RAC and ASM databases.
• Patching and upgrading oracle databases 10g/11g databases. Migration from 10g to 11gR1 and 11g R2.
• Initial Set up and monitoring of Active stand by databases. Use up data guard broker to administer data guard environments.
• Extensive experience in UNIX shell scripting, Per Shell scripting, Crontab to monitor database status, retrieve database statistics for analysis, startup and shutdown database, automatic moving and purging of archive files based on time.
• Extensive knowledge on ETL and reporting query tuning in date warehouse system.
• Experience in performance tuning of database, instance, SGA, I/O, using Enterprise Manager (OEM), TOAD, STATSPACK, SQL Trace, TKPROF and Explain Plan.
• Working on user requests - like data refresh using data pump, backing up user data, user account maintenance, query tuning, session tracing, space etc.
• Scheduling and Monitoring Database jobs using autosys and OEM
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement.
• Supporting Backup, Restore & Recovery using RMAN which includes hot backups and Cold backups. Tuning RMAN backup. Working on RMAN active and back up based duplication.
• Administering SQL Server large and complex databases in SQL Server 2012, SQL Server 2008 R2
• Experience in performing Mongo DB DBA operational routines
• Configuring and monitoring replica sets. Configuring Sharding, monitoring, and identify the proper shard key
• Mongo DB User Management - creating users, assigning roles, managing permissions
• Mongo DB Skilled in backups & disaster recovery

Environment: 10g RAC, 11g RAC, Unix Sun Solaris 8, 9,10, AIX 6.1, RMAN, ASM, Enterprise Manager Grid Control, Data guard, Data Warehouse, TKprof, Data guard broker, Confidential, SQL Server 2012 and 2008R2

Confidential, Philadelphia, PA

Sr. Oracle DBA

Responsibilities:

• Supporting development, testing and production databases.
• Performance tuning including instance tuning, SQL Tuning using SQL Tuning Advisor. AWR, ADDM, ASH report analysis. Use of advance SQL tuning features like SQL profile and baselines
• Database monitoring using OEM Gird control and shell scripts.
• Administering RAC and ASM databases.
• Patching and upgrading oracle databases. Migration from 10g to 11gR1 and 11g R2.
• Initial Set up and monitoring of Active stand by databases. Use up data guard broker to administer data guard environments.
• Supporting huge data load (ETL) and report generation process as DBA in Warehouse environment.
• Extensive knowledge on ETL and reporting query tuning in date warehouse system.
• Implemented and managed optimum physical database design (table space, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Working on user requests - like data refresh using data pump, backing up user data, user account maintenance, query tuning, session tracing, space etc.
• Oracle Confidential Installation, Configuration and maintenance in Unix Sun Solaris/Red Hat Linux, including patch application and upgrade of the environments.
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement.
• Supporting Backup, Restore & Recovery using RMAN which includes hot backups and Cold backups. Tuning RMAN backup. Working on RMAN active and back up based duplication.
• Administering SQL Server large and complex databases in SQL Server 2008 R2
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Environment: 10g RAC, 11g RAC, Unix Sun Solaris 9,10, RH Linux 4.0, 4.3 and 5.0, RMAN, ASM, Enterprise Manager Grid Control, Data guard, Data Warehouse, TKprof, Data guard broker, SQL Server 2008 R2

Confidential, Warren, NJ

Oracle DBA

Responsibilities:

• Supporting RAC databases and Oracle Grid.
• Large high volume site experience with database monitoring and tuning on transactional 24 * 7 * 365 systems. Efficient in Database performance monitoring, diagnostic and Tuning, Backup and Recovery, managing users and security.
• Provide Oracle database support. Support includes routine DBA tasks such as backup and recovery of full and partial databases using RMAN, performance tuning of SQL and PL/SQL code, system and database performance tuning of Sun Solaris multiprocessor shared database environments.
• Tracking database growth and planning near-term requirements with existing resources
• Automating daily routine activities using shell scripts to verify free space within tablespaces, check data type consistencies between two environments, find differences between objects in two instances.
• Automating the daily routine activities backups, migrations etc, using Shell scripts and performance tuning of the database, using AWR reports.
• Monitoring of the queries with high response time, and high disk reads per execution (Top SQL) and tuning the same using Explain Plan, TKPROF, Auto trace.
• Have configured and install Shareplex for replication between RAC clustered Databases.
• Have experience with using KSH (UNIX scripting) for scheduling daily Tasks.
• Migration of data between Databases over the network.
• Good Experience with Logical and physical Database Design and Data Modeling.
• Ensuring integration and implementation of all database components including procedures, functions and packages
• Configuring and monitoring the Data Guard environment for Capacity planning for future growth requirements.
• Involved in the Analysis, Design and Development of the Reports for the End Users.
• Assigning roles, privileges, resources to users: granting quotas, allocating table spaces, revoking user privileges,
• Managing resources and profiles: creating profiles for various users, setting resource limits for each profile, allocating default and temporary table spaces for each user, enhancing table space quotas for each user, dropping users and associated schema objects
• Used PL/SQL Tables and Array’s to process huge volume of data and used bulk collect and bulk bind for mass updates as performance improvement process.
• Used Toad to Optimize and test SQL’s, PL-SQL statements developed by the Development Team.
• Developed SQL Scripts for Unit Testing the Application.
• Migration of the Developed Products from Windows Environment to UNIX Environment.
• Supportive Individual capable of Managing incidents, being proactive in terms of preventive maintenance and knowledgeable in terms of risk management.
• Perform database monitoring and tuning to ensure databases run Confidential peak performance; troubleshooting performance issues.
• Installs, configures, trouble-shoot, Upgrade, Security Patch Oracle Database products.

Environment: Oracle 10g/11g R2 RAC, Solaris 5.10, HP-UX 11.23, Import/Export Datapump, WinSCP, OEM, RMAN, Explain Plan, SQL*Loader, Materialized Views, SQL, PL/SQL,Shareplex.

Confidential, Middle Town, NJ

Lead Oracle DBA

Responsibilities:

• Installation and upgrade of Oracle 10g in Sun Solaris 9, 10.
• Installation and upgrade of Oracle 11g in Sun Solaris 9, 10.
• Leading the team of size 25. Assigning projects to the resources, project tracking, leading team meeting, helping resource on day to day DBA activities.
• Performance tuning including instance tuning, SQL Tuning using SQL Tuning Advisor, SQL Access Advisor and Explain plan in very large database in data ware house
• Daily activity included database monitoring using OEM and shell scripts
• Writing, debugging and tuning PL/SQL codes like stored procedures, packages, Triggers, Functions and views etc. as per the business requirement.
• Developed Perl scripts to automate database operation and database monitoring.
• Have supported huge data load (ETL) and report generation process as DBA in Warehouse environment.
• Supporting very large scale production databases (up to 65 TB)
• Extensive knowledge on ETL and reporting query tuning in date warehouse system.
• Implemented and managed optimum physical database design (tablespace, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
• Have expertise on ERWIN data model ling tool for creating logical and physical data models.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Supported 4- node RACs and ASM
• Installation and Configuration of Shareplex 5.3 and 6 for data replication. Regular Shareplex maintenance activity like adding new tables to configuration, starting and shutting down for configuration change, checking status, compare and repair, monitoring the latency
• Oracle Confidential Installation, Configuration and maintenance in Unix Sun Solaris/Red Hat Linux, including patch application and upgrade of the environments.
• Establishes standards, policies, and procedures for Confidential replication administration
• Monitoring Day-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN which includeshot backups and Cold backups.

Environment: Oracle 9i, 10g RAC, 11g RAC, Unix Sun Solaris 9,10, RH Linux 4.0, 4.3 and 5.0, RMAN, Enterprise Manager, Data Warehouse

Confidential

Oracle DBA

Responsibilities:

• Development and Testing Database Administration and support
• The work involves overall maintenance of Oracle database, performance tuning, backup, recoveries and other database related activities in data warehouse environment.
• Leading DBA team of size 6.
• Taking Backups on scheduled time and monitoring scheduled Backups.
• Creating and dropping of users, granting and revoking rights as and when required.
• Checking of Oracle files for abnormal behaviors
• Day to day performance monitoring and tuning of database.
• Monitoring of database objects like rollback segments, temp segments and tablespace
• Diagnose and troubleshoot Database problems and failures.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Involved in the Design (Logical & Physical) of Databases
• Preparing Backup and Recovery plan.
• Have supported huge data load (ETL) and report generation process as DBA in Warehouse environment.
• Involved in the installation of Oracle 9i and 10g RAC on Solaris and UNIX/Linux platform.
• Creation and maintenance of database.
• Writing, debugging and tuning PL/SQL codes like stored procedures, packages, Triggers, Functions and views etc. as per the business requirement.
• Storage and space management including table spaces and data files.
• Management of table space growth, monitoring data files additions, extent growth
• Constantly monitor the performance (V$ dynamic performance views Confidential peak load) of the Databases and viewing Alert log files & Trace files.
• Monitoring of database for growth and performance
• Defined backup procedures using daily hot backups and weekly cold backup.
• Oracle database administration on Solaris platform.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Monitoring Database for fragmentation and correcting them
• Creating and implementing backup and recovery strategies
• Setting up and maintaining user accounts and profiles
• Space management
• Maintaining Data models using Erwin
• Ensuring proper online and offline backup. Periodical reading and checking of backups taken.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Creating Databases and all database objects. Database Designing (Designing Tablespace and Rollback Segments)

Environment: Oracle 9i,10g, Sun Solaris, HP-Unix, UNIX, RH Linux 4.0, RH Linux 4.3,RH Linux, RMAN, DBCA, EXPLAIN PLAN Cloning, OEM, STATSPACK, TKPROF,ERWIN, Data ware house

Confidential

Oracle DBA

Responsibilities:

• Responsible for designing, configuring, and maintaining several company-critical systems and databases including Solaris 7/8/9 servers and Oracle 8i/9i databases.
• Production, development, test and pre-production environments.
• Setup, configuration, upgrades and maintenance of Oracle databases while maintaining a 99.9% uptime guaranty.
• Day to day performance monitoring and tuning of database.
• Maintained, configured and supported customized application databases running on Oracle back end with forms 6i as front end.
• Oracle database administration on Solaris platform.
• Planned setup and maintained an Oracle Database for Integrated Material Management, Cement dispatch section and Payroll system.
• Designed and Implemented Oracle 8i database for Raw Material System for cement manufacturing company, actively involved in resolving performance issues along with development team.
• Defined backup procedures using daily hot backups and weekly cold backup.
• Using TKPROF, EXPLAIN PLAN for the Better performance.
• Independently setup Oracle Databases, planned and Implemented daily backup.

Environment: Oracle 8i,9i Sun Solaris, RMAN,EXPLAIN PLAN, Cloning, STATSPACK, TKPROF