Resume

Sign in

Database Administrator

Location:
Wayne, NJ, 07470
Posted:
March 15, 2018

Contact this candidate

Resume:

VISHAL SRIVASTAVA

Contact : 973-***-****

Email : ac4tqf@r.postjobfree.com

SUMMARY

• 10+ years of IT experience in Database Technologies which includes extensive exposure to Database Administration, Performance Engineering, system analysis, design, development, implementation and support.

• Oracle database Version ( 9i/10g/11g/12c) database administration with various techonolgies .

• Microsoft SQL database version ( 2008 R2/2014/2016) administration.

• Teradata database Version ( V15.x) administration.

• MySQL database version ( 5.6 / 5.7 ) administration .

• Experience in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Database designing and Query optimization

• Hands on experience of Oracle Replication technologies GOLDEN GATE,Shareplex by Dell.

• GOLDEN GATE Bi-directional / uni-dirctional setup and production support for various application .

• Hands on experience on AWS services ( EC2, VPC,IAM,S3 ) .

• Good understanding of Cassandra .

• Good exposure in Oracle partitioning ( Hash,Range,Interval)

• Experience in configuring and managing high availability solutions like DataGuard, RAC, ASM, GRID, SCAN

• Experience in implementing Oracle Replication Models ( Golden Gate, Shareplex)

• Extensive knowledge of RDBMS and experience with space forecasting/allocation

• Hands on experience in Troubleshooting database issues

• Strong experience of Oracle Patch Upgrade (PSU, Interim bug fix, Merge patch)

• Experience in RMAN Database Backups, RMAN Cloning ( from Active target as well as backup ), Recovery models and Disaster Recovery procedures

• Experience in implementing database using DBCA

• Experience in maintenance of databases, creating roles and managing user permissions

• Provided scripts for various modifications (table creation, index creation, package creation) associated with new release to deployment team

• Performed sizing estimations of different objects getting created as part of new releases, monitored organic growth of DB Objects

• Implemented and documented proactive monitoring scripts for production databases such as alert log verification, daily tablespace free space monitoring and also for automating database backups using RMAN

• Experience in resolving performance issues by analyzing AWR reports, V$ Dynamic performance view, SGA Tuning

• Extensive experience in SQL tuning and understanding of business requirement/frontend application.

• AWS EC2 deployement for all Non prod DB migration to oracle . TECHNICAL SKILLS

Clould Exp Amazon Web Services ( AWS Services ),DB migration SQL

MS Sql Server 2008 R2,2014,2016 Standard and Enterprise edition,SSMS

MySQL Version 5.6 / 5.7

No SQL Cassandra

Oracle Oracle 12c /11g R2/10g R2/RAC,ASM,RMAN

Replication Oracle Golden Gate, Shareplex ( Dell ), Data Guard,Oracle Streams Oracle Tools/Utility OEM 13c / 12c/11g, SQLT,RAT Capture,SQLT Scripting Unix Scripting, PL SQL Troubleshooting

Platform Unix Sun solaris, Linux Red hat,AIX, Supercluster exadata Tools BMC Remedy,team Track,Clarity

Others Informatica,Tivoli

VISHAL SRIVASTAVA Page 2 of 5

CERTIFICATIONS & TRAININGS

• AWS Certified Solution Architect Associates

• Oracle Certified Associate (OCA-Oracle 11g DBA)

• Golden Gate Advance Training from Oracle

OEM 12c – Training from Oracle organized by Verizon Wireless

Cassandra training from Datastax

AWS workshop on VPC, EC2 and for Non prod deployment .

Attended workshop on Oracle 12c Multitenant Architecture EXPERIENCE

ToysRus 01/15/2018 – Till Date

JobTitle – Senior Database Administrator

Following tasks for MS Sql Server / Oracle /MySQL /Teradata

• Capacity Management

• Security Management

• High Availability Management

• Backup and Recovery Management

• Performance Tuning

• Process Improvements

• Daily, Weekly and Monthly maintenance

• Installations / Upgrades / Patching

• Health Checks / Report Analysis

• Production Support DBA for Oracle, Sql Server,My SQL,Teradata,Informix databases .

• Database migration from Oracle on primises to AWS EC2 .

• Database maintenenace of Teradata objects for Partition mentainance .

• Change management Review and approval for production change in database .

• Manage and implementation of Autosys and maintenance jobs.

• Troubleshooting on Critical and High priority tickets .

• Manage and implemenetation on Database Audit for Oracle and MySQL database .

• Applying CPU Patches to the Oracle Databases

• Performance Tuning of high resource consuming queries.

• Monitoring Space alerts during season

• Oracle 24*7 Support production support

• Oracle Installation & Patch up gradation

• CMR creation & implementation for Databases production releases

• Database up gradation from 11g to 12g

Kforce Inc 08/25/2014 – 01/12/2018

JobTitle – Senior Programmer Analyst

Following tasks for MS Sql Server / Oracle /MySQL /Teradata

• Capacity Management

• Security Management

• High Availability Management

• Backup and Recovery Management

• Performance Tuning

• Process Improvements

• Daily, Weekly and Monthly maintenance

• Installations / Upgrades / Patching

• Health Checks / Report Analysis

• Production Support DBA for Oracle, Sql Server,My SQL,Teradata,Informix databases .

• Database migration from Oracle on primises to AWS EC2 .

• Database maintenenace of Teradata objects for Partition mentainance .

• Change management Review and approval for production change in database . VISHAL SRIVASTAVA Page 3 of 5

• Manage and implementation of Autosys and maintenance jobs.

• Troubleshooting on Critical and High priority tickets .

• Manage and implemenetation on Database Audit for Oracle and MySQL database .

• Applying CPU Patches to the Oracle Databases

• Performance Tuning of high resource consuming queries.

• Monitoring Space alerts during season

• Oracle 24*7 Support production support

• Oracle Installation & Patch up gradation

• CMR creation & implementation for Databases production releases

• Database up gradation from 11g to 12g

• CPU patch installation on various oracle databases

• Creation & maintenance of oracle databases

• DB Sizing & Capacity planning for Databases

• Performance tuning

• Data planning, Purging & reconciliation as per defined policy

• Supporting database for critical trading web application .

• Design and support for Golden Gate replication from Oracle to SQL server databases .

• Integrated Extract / Replicat setup for oracle 12c database .

• Daily troubleshooting on Golden gate replication issue on various processes .

• Extensive use of GG Logdump to fix bad data issues .

• Source definition file creation for SQL server DB replication .

• Resolving Golden Gate conflict detection and resolution .

• Golden gate process monitoring setup and automation .

• Upgradtion of Golden gate software to new version .

• Weekly and monthly release for database refresh for QA and Integration .

• Migration of Non prod to AWS infrastructure .

• Oracle database restore from Pure Storage Array . Automation of DB restore from Standby database to QA env.

• Single point of contact for DB oriented activities for the designated application.

• Support monthly enterprise release.

• Assist development team during entire SDLC life cycle.

• Set up new databases using RMAN backups.

• Refresh performance testing environment from production using RMAN cloning.

• Golden Gate bi-dirctional replication setup for case management system application .

• CDR resolution in bi directional GG setup .

• Golden gate process monitoring setup and automation.

• Golden gate Logdump utility for any data related issues .

• Troubleshooting for all Extract, Pump, Replication Stopped/Abended issues .

• Settting up Gilden gate for failover in multinode RAC environment .

• Periodic refresh of datamasking environments outline i.e. metadata only from production.

• Perform maintainance such as Control file / Redo movement, convert Physical data guard to Active data guard etc.

• Maintain and configure SHAREPLEX on different ports as per the requirement.

• Periodic analysis of AWR/ASH data to keep a check on health of production .

• Apply patches

• Documenting the maintainance procedures for future reference.

• Design configurable automated scripts to backup/clone database, monitor database health, generate AWRs, identify blocking sessions etc.

• On call rotation.

• IVR database migration between 3 data centers.

• Moved Control files to a different location for both primary and physical standby database.

• Changes physical standby to Active data guard configuration.

• Changed memory parameters ( SGA/PGA ).

• Did Active Data Guard set up between 2 node RAC source and target

• Set up new 2 Node Oracle 12c RAC database site with shareplex replication to 11g database. VISHAL SRIVASTAVA Page 4 of 5

Environment: Oracle 11gR2/12c2, AWS,Solaris SPARC 64 T4/T5, TOAD, RAC, DataGuard, Splex 8,GG Tata Consultancy Services Ltd 09/08/2010 to 08/22/2014 Job Title – IT Analyst

• Worked side by side with production support and development teams and project management in laying out the plan for production upgrade

• Worked side by side with Oracle (OCS/ACS) and IBM assisting in production upgrade

• Lead team of DBAs to upgrade multiple test, development and performance environments (50 TB) equivalent to size of production

• Tested the sanity of cluster and database after upgrade (Oracle and IBM-INITIATE)

• Sanitized behavior of SCAN

• Performed failover failback testing

• Followed up on SRs for different issues (DRM freeze, SCAN behavior, Node eviction, Failover, etc.)

• Migrated data from production to production equivalent performance testing environment

• Coordinated with system administrators and storage team to successfully mount the backup copy and cross check the structure of raw volumes/ASM diskgroups

• Repaired ASM disks if required after migration

• Recovered databases on PT servers

• Renamed the RAC instances and services

Environment: Oracle 11gR2/10g, Solaris SPARC 64 T4/T5, TOAD, RAC,Golden gate

• Oracle EBS Migration

• Oracle database upgrade from 9.2.0.6 to 9.2.0.8 on AIX.

• Oracle database upgrade from 9.2.0.8 to 11.2.0.3 on AIX

• Oracle database migration from AIX to Linux Platform .

• Oracle Application 11i migration from AIX to Linux Platform.

• Developing action plan to improve performance.

• Assist the team in implementing the action plan.

• Providing technical inputs to the development team to improve performance.

• Evaluation of Hardware and memory requirement for installation of the database.

• Migration of Databases to different server

• Applying CPU Patches to the Oracle Databases

• Performance Tuning of high resource consuming queries.

• Monitoring Space alerts during season

• Oracle 24*7 Support production support

• Oracle Installation & Patch up gradation

• CMR creation & implementation for Databases production releases

• Database up gradation from 10g to 11g

• CPU patch installation on various oracle databases

• Creation & maintenance of oracle databases

• DB Sizing & Capacity planning for Databases

• Performance tuning

• Data planning, Purging & reconciliation as per defined policy

• Oracle 10g Grid Control (OEM) installation & support

• Migration and Upgrades from 9i to 10g

• Managing Logical, Hot and Cold Backups

Environment: Oracle 11gR2/10g, Solaris SPARC 64 T4/T5, TOAD, RAC,Golden gate Reliance Communications,Mumbai,India 10/08/2007 to 08/31/2010 Job Title – Deputy Manager

• Implementation & Good understanding of 10g RAC

• Oracle Installation & Patch up gradation

• Creation & maintenance of oracle databases

• Oracle Golden Gate Implementation & L3 support

VISHAL SRIVASTAVA Page 5 of 5

• DB Sizing & Capacity planning for Databases

• Performance tuning

• Data planning, Purging & reconciliation as per defined policy

• Oracle 10g Grid Control (OEM) installation & support

• Migration and Upgrades from 9i to 10g

• Managing Logical, Hot and Cold Backups

• Successfully deployed Golden Gate on Clarify (CRM),Clarity & Billing (OLTP) Databases

• Replication of databases size more than 6 TB

• Expertise in Oracle Golden Gate Implementation (TDM Tool) Administration & L3 support

• Oracle Golden Gate Implementation on Single & RAC Databases

• Configuration of processes and parameters

• Patch & version upgrade

Environment: Oracle 10gR2/9i, Solaris, TOAD, Golden Gate EDUCATION

Bachelor of Technology in Information Technology, 2003 – 2007,UPTU, Lucknow, India



Contact this candidate