T :- +1-571-***-****

Email: acrswy@r.postjobfree.com

MALAY SINGH

SUMMARY

Over 12 years of experience as DBA in 24 7 environment for 7.x to 12c on Unix/Windows.

Strong expertise Backups and Recovery using RMAN or logical like Export and Import Datapump.

Expertise in Golden Gate Replications UNIDIRECTIONAL/BIDIRECTINAL.

Install, upgrade Oracle Databases 8i and higher.

Experience in Oracle Real Application Cluster (RAC) with Active Dataguard.

Configured/support NoSQL/Mongo databases.

Support Informatica and OBIEE for Dev support.

Managed Teradata database with Teradata SQL Assistant.

Working on RazorSQL tools for export schemas/tables.

Experience in DWH tools like Informatica.

Experience in Shell scripts for database.

Install, upgrade Oracle Enterprise Manager (OEM) for 10g/11g/12c.

Transparent Data Encryption (TDE) on Database.

Experience in modifying Storage for tablespaces in Capacity Planning.

Design Logical & Physical data model for the database for application.

Experienced with database security on tablespace level, object level, TDE, etc.

Experience in coding in PL/SQL blocks, Packages,Triggers on database.

WORK EXPERIENCE

Frontier Communications July 2015 – Present

Sr. Oracle DBA

Richardson TX

Decide database server as part of Cost Analysis and Performance.

Migrate Teradata 14.10 database to the new Linux Oracle 12c RAC.

24x7 supports for very large Database.

Compare table structures between Teradata 14.10 and Oracle 12c RAC.

Upgrade Oracle Databases and install Patches.

Editing/writing shell scripts for ETL jobs for Teradata to Oracle database.

Design Logical database design with Application as per their requirement.

Compare roles/privileges for various USERS/SCHEMAS post migrate.

Configure RMAN on databases and schedule in cron jobs.

Support various Physical Dataguard and monitor and troubleshoot.

Enable encryption Transparent Data Encryption (TDE) on database.

Perform schema/table refresh via EXPDP/IMPDP.

Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.

Rewrite complex table views from Teradata to Oracle.

Load Teradata schema to Oracle database.

Converting Teradata SQL into Oracle database.

Install and maintain Oracle Real Application Cluster (RAC) on Cluster for failover testing.

Setup Oracle Golden Gate on schema/table level.

Performance on Golden Gate.

Setup Oracle Golden Gate for Databases.

Troubleshoot Oracle Golden Gate issues source and target.

Install and maintain Golden Gate on Oracle Real Application Cluster (RAC).

Performed schema/table refresh via EXPDP/IMPDP.

Apply Oracle Security Patches to adhere to the security policy.

Performance Tuning for various databases/applications.

Gathering statistic, analyzing tables and indexes.

Fannie Mae, Reston, VA June 2014 – June 2015

Sr. Oracle DBA

Responsibilities

Decide database server as part of Cost Analysis and Performance.

Design database architecture with installation Oracle 11g on Linux.

Migrate/Upgrade OLTP/OLAP database to the new Linux Oracle RAC.

24x7 supports for very large Database.

Compare table structures between production and lower environment databases.

Upgrade Oracle Databases and install Patches.

Install/configure Oracle 12c clouds on databases.

Writing shell scripts for report for database.

Maintain Teradata databases along

Design Logical database design with Application as per their requirement.

Apply Physical database once Logical design approved.

Compare roles/privileges for various USERS/SCHEMAS post migrate.

Configure RMAN on databases and schedule in cron jobs.

Support various Physical Dataguard and monitor and troubleshoot.

Perform schema/table refresh via EXPDP/IMPDP.

Install, upgrade Oracle Enterprise Manager (OEM) for 11g/12c.

Build and support Informatica to help Dev team.

Troubleshoot issues on ETL on Appl/Dev team request.

Subject Matter Expert (SME) for over 100 databases.

Help Application/Dev team in OBIEE.

Setup Oracle Golden Gate Replication for non-Oracle to Oracle.

Troubleshoot Oracle Golden Gate issues source and target.

Install and maintain Golden Gate on Oracle Real Application Cluster (RAC).

Setup Oracle Golden Gate for Databases.

Deployed applications for various production databases.

Performed schema/table refresh via EXPDP/IMPDP.

Apply Oracle Security Patches to adhere to the security policy.

Worked on database security like database files in encryption Transparent Data Encryption (TDE).

Performance on Golden Gate.

Performance Tuning for various databases/applications with DBMS_PROFILER.

Gathering statistic, analyzing tables and indexes.

AT&T, Richardson, TX Jan 2012 – May 2014

Lead Oracle DBA

Responsibilities

Design Architecture of the database and supported 24x7 Production DBA for critical databases.

Writing shell scripts for report for database.

Upgrade Oracle Databases and install Oracle Patches.

Setup Golden Gate for Oracle databases and Non-Oracle Database.

Install/Support NoSQL/Mongo databases.

Subject Matter Expert (SME) for over 100 databases.

Installed/Configured Oracle Enterprise Manager (OEM) 11g / 12c Grid for databases.

Configure Cloud for 12c database on Amazon.

Trained team for Oracle RAC (RAC) databases with Physical Data Guard.

Mentored/Worked to team on RMAN Backups and Recovery scenarios.

Deal on Disaster Recovery (DR).

Design Logical database design with Application as per their requirement.

Apply Physical database once Logical design approved.

Recover databases/objects using RMAN/logical backups.

Configure RMAN on databases and schedule in cron.

Clone database on application request.

Experienced on Encryption (TDE)for databases.

Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.

Mentored new team members of 20 team members.

AT&T Middletown, NJ Jan 2010 – Dec 2011

Lead Oracle DBA

Responsibilities

Design Architecture of the database and supported 24x7 Production DBA for critical databases.

Writing shell scripts for report for database.

Create/Upgrade and support databases and install Patches and bug fix.

Build and maintain Golden Gate Processes for replicating purposes including Oracle Real Application Cluster (RAC) databases. Troubleshoot with Golden Gate ERRORS.

Major/Minor upgrades databases and also CPU/One Off Patches and bug fixes.

Design Logical database design with Application as per their requirement.

Apply Physical database once Logical design approved.

Install Oracle Enterprise Manager (OEM) for 10g/11g.

Tablespace management and capacity planning.

Recover databases/objects using RMAN/logical backups.

Troubleshoot errors in ETL on Appl/Dev team request.

Configure RMAN on databases and set in cron jobs.

Clone database on application request.

Enable Transparent Data Encription (TDE) on databases on Application request.

Writing PL/SQL blocks for tuning and reporting uses to help Dev team.

Mentored to team.

Installation and Incidental support for Physical Standby database.

Provide EXPDP/IMPDP script to Application DBA for schema/user backup.

Experience in Creation and managing Table partitioning and Rebuilding, validating the Indexes.

Tuning SQL query, generating Explain plan, Statspack, DBMS_PROFILER with Log miner.

Gather Statistic on table, analyzing tables and indexes.

Creation of Service Request to Oracle.

Mentored/Knowledge Share new team members of 15.

AT&T, Pune, India May 2007 – Dec 2009

Sr. Oracle DBA

Responsibilities

Production DBA in 10g/11g in 24x7.

Major/Minor upgrades databases and also CPU/One Off Patches and bug fixes.

Setup Golden Gate for Oracle Databases and troubleshoot.

Write shell scripts for report for database.

Write/Tune PL/SQL blocks for reporting.

Install Oracle Enterprise Manager (OEM) for 10g/11g.

Tablespace management and capacity planning.

Troubleshoot errors in ETL on Appl/Dev team request.

Supported Oracle Real Application Cluster (RAC) systems.

Recover databases/objects using RMAN/logical backups.

Troubleshoot Backup issues

Configure RMAN on databases and schedule in cron.

Clone database on application request.

Disaster Recovery for various databases as regular exercise.

Creating and managing table partitioning and rebuilding and validating the indexes.

Performance Tuning for SQL Query for various databases/applications.

Tested TDE (Transparent Data Encryption) database for testing of data security.

Gather Statistic on table, analyzing tables and indexes.

Vision Infocom. Noida, India Feb 2005 – April 2007

Oracle DBA

Responsibilities

Creation of users/tables as per requirements for application and grant roles/privileges as per requirements.

Setup and recovery for Oracle RMAN for backup and recovery, cloning etc.

Proficient in database and SQL tuning using HINTS, EXPLAIN PLAN & TKPROF.

Table space management and capacity planning for optimal space utilization. Evaluate and resize space usage on daily basis.

Creating and maintaining Stored Procedure, PL/SQL Blocks, Functions, Trigger, Packages, etc.

Load data into database using SQL Loader, ETL, etc.

Help to optimize the queries, Tuning of SQL statements using tools like Explain plan, Auto trace, STATSPACK, DBMS_PROFILER.

Small shell scripting related to oracle.

Create Materialize Views for application requirements.

Create Partition on Tables and Index according to the need of application.

Drishti Exports Ltd. Patna, India Aug 2002 – Aug 2004

Oracle DBA

Responsibilities

To check the performances issue at database level.

Creating and maintaining stored procedure, function, trigger, and packages etc.

Identification of User Requirements.

Finalization of User- Interfaces and Preparation of Reports.

Create and maintain database operation to suit the applications like indexes, constraints.

CERTIFICATIONS & EDUCATIONS

OCP 10g DBA Track

OCP 11g DBA Track

ORACLE RAC 11g R2 Certified

Oracle 11g Certified Expert

Bachelor’s Computer Application

TECHNICAL SKILLS

Databases: OLAP, OLTP, Data Mining, Oracle 7.X till 12c

DBA Tools: Oracle Enterprise Manager (OEM) 12c/11g/10g Grid, RAC, Golden Gate, Active Data Guard, Putty, SQL*Plus, Toad, SQL Developer Recovery Manager (RMAN),RazorSQL,SQLLines.

Operating Systems: Solaris 10/9/8/2.7/2.6; Red Hat Linux EL 4.0, UNIX 5.1/5.1a/4.0, IBM AIX

4.3.2/4.3.3, Windows XP/NT/2000, HP UX 11.00/ 10.20, Veritas Clusters.

Languages: Shell Scripts, COBOL, SQL, PL/SQL.

Contact this candidate