Sql Server Oracle

[pic]

Mr. Venky Pandey

***********@*****.*** ? 201-***-**** (Cell)

SUMMARY

. 11+ years of experience working with design, development,

implementation and administration of RDBMS.

. Installing and configuring Primary database server and physical stand

by database server for implementing Data Guard for DR Failover.

. Filled in various positions from Technical Support to Software

Developer to Database Administrator. Learned and got proficient in

different technologies in its respective positions.

. Designed and developed Data warehouse on Oracle 10g using PL/SQL,

PERL, Shell and Autosys scripts.

. IT professional with expertise in production control/support, project

management, software life cycle, Oracle and MSSQL Database

Administration, Autosys, PERL and Unix. Strengths include data

analysis, troubleshooting, setting up Oracle database servers

including RMAN for hot and cold backup and restructuring systems and

interacting with internal and external clients with all levels of

technical backgrounds.

. Worked on migration and importing of databases to newer versions and

has considerable experience with the new features of Oracle 10g and

11g.

. Worked on migration of MSSQL databases to newer versions to 2005 and

2008 from 2000 and 7.0. Also worked on migration of Sybase 12.5 to

Sybase 15.0.

EXPERTISE

. Played lead role in Recovery and Disaster Recovery procedures in

Oracle environments

. Installation, configuration of Oracle 11g, 10g and 9i. Also well

versed with the installations of Sybase 15.0 and MS SQL Server.

. Main DBA to maintain latest Oracle patches installations.

. Saved thousands of dollars of money for the company by implementing a

special way to purge useful data into database using the native script

and not using any 3rd party tool in one of the giant application named

Provisor.

. Led a team of Developers to migrate Sybase scripts, procedures, batch

format files and data to Oracle 10g.

. Worked towards the process of implementation of a batch product to a

maturity level. Automated batch scripts using PERL, SHELL and SQL.

. Saved a good sum of labor, maintenance and money for the company by

totally automating cleansing of data without buying separate license

or server to maintain the data within the servers. This was done by

creating and customizing the Purge Script to fit the company's

criteria, again a free tool within the software by Microsoft.

. Saved thousands of dollars of money for the company by implementing

the data warehouse processing using PERL, K-Shell and PL/SQL scripts.

This was done to avoid the expensive datastage license that was

costing a fortune to the company.

. Created a Real-Time monitor to monitor 100 client real-time server

using JAVA and Web Sphere MQ. This saved thousands of dollars from

hiring a consultant. The monitor is still active and being used Help

Desk.

. Highly skilled in Migration from Oracle 9i ( Oracle 10g ( Oracle 11g

. Highly skilled in Migration from MSSQL 7.0 ( 2000, 7.0/2000 ( 2005,

2000/2005 ( 2008

. Highly skilled in Migration from Sybase 12.5 (Sybase 15.0.3

. Main DBA to conduct Service Pack and hot fixes installations

. Professional in performance tuning Oracle, SQL and Sybase databases

and Server

. Data Export using Export/Import data pumps and SQL Loader for

importing data across different Oracle database versions.

. Highly skilled with loading data file with various file format

(delimited, CSV, fixed) in Oracle and SQL Server.

. Expert in Sybase and MSSQL BCP utility to copy and migrate to other

RDBMS.

. Hefty data cleansing, Removal of duplicate data to enforce uniqueness

and accuracy of data

. Design and documentation of Oracle Server Strategies and plans in

Oracle 9i and 10g

. Performance Tuning, Query Optimization, Client/Server Connectivity,

Database Consistency Checks using Oracle utility like DBVERIFY.

. Oracle Server Security - Setting Permissions with Database Roles and

Server Roles

TECHNICAL SKILLS

Languages: PERL, K-SHELL, SQL,PL/SQL

Operating Systems: UNIX SUN Solaris, UNIX AIX, WINDOWS, LINUX

DBMS : ORACLE 9i/10g/11g, Data Guard, MSSQL 2005 MSSQL 2008,

SYBASE 15.0

Software: TOAD, SQL DEVELOPER, DBARTISAN, AUTOSYS

Certifications: Oracle Certified Professional 10g Database Administrator

(OCP)

Status: Citizen

EXPERIENCES

Oracle DBA

Apr 07 - Present

Broadridge Financial Solutions, Jersey City, NJ

Broadridge is a leading full-service outsourcing provider to the global

financial industry, capable of meeting the most demanding requirements for

efficient, secure and scalable operational support. Our reach spans the

world, and encompasses an extensive array of services - from account

opening and securities transaction processing to correspondent clearing to

document management and investor communications as well as full operational

staff outsourcing. A steadfast source of processing support, we help

financial services institutions and public companies increase productivity,

streamline operations, enter new markets with new products more quickly,

drive down back-office costs and better manage risk.

Responsibilities:

. Role of the Lead DBA in Production environment.

. Led the project of upgrading 50 Oracle 9i databases to Oracle 10g.

Multiple groups were involved with the migration and testing the

applications.

. Expert in installing and upgrading Oracle 10g and Oracle 11g on Solaris

2.8 and above.

. Upgraded many Oracle 9i database instances to Oracle 10g. Also, upgraded

Oracle 10g database instance to Oracle 11g.

. Migrated many SQL Server 7.0and SQL Server 2000 to SQL Server 2005 and

2008.

. Migrated many Sybase 12.5 to Sybase 15.0

. Installed and being the person in charge of Service Packs releases for

the SQL Servers

. Installed Grid Control and its agents to monitor performance of the

multiple databases.

. Documented all Oracle installations to prepare for any emergency/disaster

recovery.

. Proficient in auditing on all Oracle Production Database servers.

. Implemented database refresh using full export for table level and full

database to remove defragmentation, resulting in improved performance and

effective space management.

. Managed database security. Design, develop, and implement automated data

backup and restoration procedures. Provide technical support for database

maintenance and disaster recovery.

. Specialized experience in partitioning. Creating and dropping monthly

partitions using automated shell and PL/SQL scripts.

. Proficient in creating new database user schemas and importing the DDL

from existing schema in multi-user environment.

. Generated and analyzed the AWR, TKPROF, STATSPACK and Explain Plan

reports for Database tuning to identify long running queries.

. Utilized SQL traces facility and TKPROF accurately assessed the

efficiency of the SQL statements when application runs.

. Solid experience with backups using both RMAN for hot and cold backup and

EXPORT dumps on daily basis using automated scripts through UNIX cron

scheduler.

. Created tablespaces monitor for all the Production servers using PL/SQL

and Shell scripts.

. Concrete experience with exports and imports data pumps to move data from

one Oracle database server to other.

. Collecting and Analyzing Sysmons, Optdiag statistics and MDA data for any

performance bottlenecks.

. Created named cache in Sybase for performance improvements.

. Designed one of the vast implementation which loaded flat files into

Oracle Database using SQL Loader.

. Transformed the Oracle database environment from a non-standard Oracle

structure to a standard one.

. Shaped PERL scripts interface for Oracle, Sybase and MSSQL batch

applications.

. Worked over network in multi-platform environment to support client's

data base, Unix and NT systems.

. Provided quality service and dedication to resolve issues, which resulted

in a client satisfaction increase from 85% to over 97% as recorded on

client surveys.

. Automated troubleshooting procedures for maintaining, scheduling and

executing many applications; leading to minimize group size and better

client satisfaction.

. Day to day DBA checklist task and remedy tickets solutions.

. Created new Databases, jobs, users and assigned roles and permissions.

. Ensure current servers are in sync with Data Center 1 and Data Center 2

Servers (Disaster Recovery).

. Ensured integrity and health of all platforms databases and at the same

time making sure the servers and databases are up and intact.

. Built back up and recovery model and maintained using scheduling to

prevent data loss or disaster.

. Fine tuned database objects and server to ensure system health.

. Provided 24/7 support and being the main person for weekend support DBA.

Environment: Oracle 11g, Oracle 10g, Oracle 9i, Sybase 12.5, Sybase

15.0, UNIX, PERL, Windows 2008, 2003, 2000, SQL Server 2008,

2005, 2000 and 7.0, Excel, Word, Visio

Automatic Data Processing (ADP), Jersey City, NJ

Sept 98 - Mar 07

Automatic Data Processing, Inc., with nearly $9 billion in revenues and

about 570,000 clients, is one of the world's largest providers of business

outsourcing solutions. Leveraging 60 years of experience, ADP offers the

widest range of HR, payroll, tax and benefits administration solutions from

a single source. ADP's easy-to-use solutions for employers provide superior

value to companies of all types and sizes. ADP is also a leading provider

of integrated computing solutions to auto, truck, motorcycle, marine and

recreational vehicle dealers throughout the world.

Database Administrator Apr 05 - Mar

07

Responsibilities:

. Installed Oracle, Sybase and SQL Server.

. Created new Databases, jobs, users and assigned roles and permissions on

Oracle, Sybase and SQL Server database platforms.

. Planned backup strategy on various database platforms and scheduled it

accordingly. Used RMAN for Oracle backup.

. Fine tuned Oracle and SQL Server database platforms.

. Installed latest Oracle patches to keep the database server up to date.

. Refreshed schema and tables from one system to another.

. Played the main role troubleshooting Production issues side by side with

Oracle, Sybase and Microsoft Corporation.

. Installed and being the person in charge of Service Packs releases for

the SQL Servers.

. Ran DBCC consistency checks for SQL Server and DBVerify for Oracle, and

fixing data corruption in application databases.

. Provided 24/7 support and being the main person for weekend support DBA.

Environment: Oracle 10g, Oracle 9i, Sybase 12.5, 15.0 UNIX, PERL, UNIX

Shell scripting, Windows batch scripting, Windows 2003, 2000, SQL Server

2005, 2000, Visio

Sr. Programmer Analyst Jul 00 - Mar 05

Responsibilities:

. Created and managed monthly purge of data to the databases before

synching it with other locations (Disaster Recovery). This was a big

achievement which yielded the company to save more than $20,000 from

buying a third party tool and licensing to do the same which was done in

Native scripts and has been running until today.

. Set up and organized meeting for emergency releases and discussion that

is related to Production.

. Planed and developed the Star Schema for the Data Mart proposed.

. Key member involved in achieving a product to maturity level.

. Proficient in PERL, SQL and Shell scripting.

. Key member in a group that executed the change from three tier (Main

Frame/OS2/Unix or NT) to two tier (Main Frame/Unix or NT) network that

uses OPC/NDM/MQ application.

. Worked with 3rd party vendor application hosted on SQL Server.

. SQL Server 2000, 7.0 development writing Stored Procedures, User-Defined

Functions, Triggers, Views. Good understanding of Normalization /De-

normalization and database design methodology. Strong T/SQL Query writing

skills (DDL, DML, DCL).

. Designed and Developed Data warehouse using PL/SQL procedures, Autosys,

PERL and shell scripting.

. Created and Modified Autosys jobs for data warehouse processing.

Environment: Oracle 9i, JAVA, Websphere MQ, UNIX, PERL, Shell

scripting, Windows 2003, 2000, SQL Server 2000 and 7.0, OLAP, Visio

Technical Support Sept 98 - Jun

00

Responsibilities:

. Installed and Configured Connect:Direct on different platforms.

. Installed MQ Websphere 5.3 on different platforms.

. Installed third party software and various patches on Solaris and AIX

operating systems.

. Provided Technical support for batch and real-time applications on daily

basis.

. Key contributor in implementing "NEON" software which increased data

transfer speed by eight times.

. Carried out the database release or changes for various projects.

. Worked directly with the Application and development team who get

connected to the clients.

. Communicated with vendors and clients for Production problems.

. Coordinated the software and database changes on quarterly basis.

. Provided 24/7 production support for both batch and real-time

application.

Environment: Sybase 11.9.2, Sybase 12.0, SQL Server 7.0, Websphere MQ,

UNIX, PERL, K-Shell, Expect, Windows 2000, OLAP

EDUCATION

M. S., Computer Science (Jan. 2001), New Jersey Institute of Technology,

Newark, NJ

B. S., Computer Science (Aug. 1998), New Jersey Institute of Technology,

Newark, NJ

Minor in Applied Mathematics (Aug. 1998), New Jersey Institute of

Technology, Newark, NJ

Contact this candidate