Manager Oracle

Vimal Raj

Mobile no: 469-***-****

Email:*****.******@*****.***

Objective

To make the best use of my acquire skills, constantly improve my technical and interpersonal skills and reflect that in my work to achieve organizational goals.

Accomplishments:

• Over 10 Years of experience as Oracle DBA with hands-on experience on Oracle RAC, ASM, Dataguard, RMAN, Golden gate, Performance Tuning and OEM.

• Primary DBA for more than 100 Critical trading databases including franchise critical applications, SME for performance issues, database technological enhancement recommendations and POC for major incident calls/infrastructure compliance.

• Completed successful migration of several databases of sizes greater than 10TB from AIX to Linux.

• Migrated around 50 databases from Linux/AIX to Private Cloud Solutions.

• Restored and Recovered 8 databases within 24 hours from tape in UAT environment when data diskgroup got corrupted because of unexpected OS issues.

• Expertise in creating High availability features for Oracle databases using Oracle Dataguard and Oracle Real Application Clusters(RAC).

• Strong experience in implementation of Oracle Grid to monitor and maintain database infrastructure.

• Strong experience in handling various disaster recovery scenarios and COB drills with respect to the oracle databases. ·

• Experience in developing service improvement plans and implementing major technical initiatives.

• Strong Experience in implementations of unidirectional and bidirectional database replication using Oracle Golden Gate.

• Experience in build and managing Postresql databases.

• Experience in managing MongoDB in on-premise cloud.

• Experience in managing and supporting oracle databases using Amazon RDS . Technical Skills

• Operating Systems: Sun Solaris, Red Hat Linux, AIX

• Database Administration: Oracle 10g/11g/12c, RAC, Grid, Golden Gate, Postgresql 10/11

• DB Tools and utilities: OEM, Solarwinds DPA, Toad, SQL Developer, Datapump, pgadmin

• NO SQL: Mongo DB

• Cloud Technologies: AWS

Certifications

• AWS certified Solutions Architect Associate.

• Oracle Certified Database administrator Associate.

• Oracle certified SQL Expert.

Education:

Duration: July 2005 – June 2009

Degree: Bachelor’s in Electronics and Communication Engineering. Professional Experience:

Company: Wipro Limited

Duration: August 2013 – Till date

Client: Citibank

Location: Irving, Tx.

Role: DBA

Responsibilities

• New Project Architecture/ Database design as per customer requirement taking into consideration of Application Process.

• Provide primary DBA responsibilities to Global Markets Production data servers. New server builds and rollout to production.

• Service improvements in process of technical expertise.

• Production servers fine tuning and maintenance.

• Maintaining high availability solutions like Data guard, Golden Gate, RAC Cluster with less outages. Migrations and upgrades to the latest hardware with cost effectiveness.

• Protecting the servers from vulnerabilities through VTM patches and fixing Audit violations to retain it as per standards. ·

• Automating the required areas to reduce time and efforts spent of the Database Administrator team.

• Managing postgresql replicas and managing postgresql databases

• Periodically perform COB test (Continuity of Business Tests) to ensure the backup servers availability in case of Production server crash or destroyed by natural calamities.

• Implementing all Database integrated tools for better Auditing and monitoring. Major initiative - Planning and Execution across the Estate.

• Identifying the Process gaps and recommending improvements to fix.

• Involving in all major issues\outages to provide technical solution within a short time.

• Liaising with different support teams and vendor partners to resolve any Major incidents. Company: Cognizant

Duration: Jul 2012 – August 2013

Client: McGraw hill

Role: DBA

Responsibilities

• Create, Upgrade and maintain Oracle databases across multiple platforms and setup backups.

• Handling configuration and managing Real Application cluster nodes;

• Performing Online & Offline backups using RMAN and Oracle import/export as a method of recovering data or individual objects.

• Applying database and CPU patches as per the scope of work

• Performing Disaster Recovery Drills.

• Troubleshooting synchronization issues with primary and Physical standby.

• Performing database refresh as per the user requirement.

• Performing database re-org to get rid of fragmentation and rebuilding indexes as per business schedules

• Performance monitoring the databases for Better performance and tuning sql queries.

• Creating and managing tablespace, Space issues, Extent and storage parameters.

• Managing and Modifying Discoverer reports as per the application users requirements.

• Export and Import applications in Apex.

• Creating OID in Oracle Directory Manager and granting roles using Oracle Security manager. Company: Cognizant

Duration: Feb 2010 – July 2012

Client: Marks & Spencer’s, UK.

Role: DBA

Responsibilities

• Installation and Configuration of Oracle 11g on AIX, Linux and windows.

• Performing Logical backup using export utility and recovering specific object or schema using Import utility.

• Planning of Backup & Recovery strategy using RMAN and export/import utility.

• Creating and managing tablespace, Space issues, Extent and storage parameters.

• Create and modify database objects like table, index, synonym, etc. as per application requirement.

• Applying Bug fix and CPU patches.

• Security Administration and Creation of Users, Managing their roles and privileges.

Contact this candidate