DBA

Rajiv Goyal

Cell: 416-***-****

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

Skill Summary for DBA Role

Over 12 years of experience as a Database Administrator/Analyst on Oracle, Sybase and MS SQL ServerSolid working experience in production supporting (7x24) very large heterogeneous production database systems running on Oracle 9i and 10g/11g R1, R2 RAC.Very proficient at database administration on Oracle (9i/10g), MS-SQL Server 2000/2005 and DB2 on various platforms (HP-UX, AIX, Solaris, Windows)Extensive working knowledge in database trouble shooting and performance tuning utilizing various tools (e.g. Precise, DBArtisan, OEM STATSPACK, DBMS_SYSTEM Package, SQL_TRACE, SQL Profiler, Window Monitor, Query Analyzer, MS-SQL Enterprise Manager, Glance)Performed many Oracle installations, configurations, upgrades, patch management, security, backup and recovery on Unix and WindowsStrong organizational, interpersonal, motivational & analytical skillsAbility to communicate effectively and to work independently Also a reliable team member in team/group environmentDesigned, Install and implemented Oracle 7,8i, 9i, 10g and 11g databases on Sun Solaris, AIX and Red Hat Linux on SAN/RAW devices.Working experience in Grid Environment using 10g/11g/11g R2 RAC on ASM Hands-on expertise installing, configuring, troubleshooting, patching, and supporting Oracle 11g R2 databasesGood experience in Disaster Recovery Solutions including Data Guard on Standby databaseDatabase backup and recovery experience using RMAN and user Managed for hot and cold backup in clustered and non – clustered environmentsGood working experience on all flavors of UNIX including Sun Solaris, Linux, HP, AIX and has great exposure of shell scripting and system administration tasks.RMAN and Net backup/Legato experience for Backup and recovery design and implementation using with duplication for test and QA environment.Excellent experience of monitoring Oracle instances and databases using OEM and custom UNIX shell script for Oracle performance, alert and space utilization monitoring.Creation of test and UAT servers for development and testing applications from production database.Hands on experience and outstanding knowledge of high availability SQL Server solutions, including replication and SQL Server clusteringExperience in installing, administering and managing Microsoft SQL Server and integration it with Oracle.Extensive experience in each part of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation. Experience in SQL*Plus, Toad, DB Partner, PL/SQL, OEM, PL/SQL Web Toolkit, SQL*Loader, VSS, PVCS, HTML, JavaScript, Pro*C and Unix Shell ScriptDatabase utility experience including reorg, runstats, rebind, export, import, load, auto-load, backup, restore and roll forward utilities.

Technical Summary

Databases : Oracle 7,8i, 9i, 10g, 11g, Sql Server

Software : Pro *C, SQL, PLSQL, C, UNIX Korn Shell

Other Oracle Tech. : Data Guard, ASM, RAC, RMAN

Web Technologies : JSP, JDBC, HTML, Weblogic,WebSphere

Backup Tools : RMAN, VERITAS Net Backup, Legato Networker

Operating Systems : Sun Solaris,,AIX, Linux, HP-Unix, NT,, Microsoft Windows Server 2003, 2008

Data Modeling Tools : Erwin 4 / 7, Toad

Tools :Rational Clearcase,PVC Tracker

Certification

ORACLE CERTIFIED Professional (OCP) DBA ORACLE 10g

Professional Experience

IBM Canada Markham, ON June 2010 to Current

Senior Oracle DBA

Working on Rogers account for IBM Canada for Production Support and other Project related activities:

supporting (7x24) very large heterogeneous production database systems running on Oracle 9i and 10g/11g R1, R2 RAC.Prime activities included handling tickets related to adding space to database, monitoring archive usage, alert log errors for alerts generated via IBM toolkitWorking on various Production incidences, Service Requests, changes to Provide support for Physical DBA related activitiesAdministration of RAC, Non-RAC databases on ASM for day to day Production Support activitiesSupporting various Standby Databases and fixing any issues related to gaps and Managed Recovery to make sure Standby is in Sync with ProductionParticipating in Disaster Recovery activities and restoring databases in DR environments for various databases as part of about one week long activity Rebuilding various Standby Databases from scratch after DR exercise Fixing archive gap and other Managed Recovery related issues after Standby Database went out of sync with Production Worked on various Database and Archive Backup related tasks/issues with Offshore Netbackup Team using RMANWorked on various restore tasks to restore production databases from Tape backups in lower environmentsHandling Severity 1 & 2 issues for Performance/Latency and providing Bridge Support for calls running for hours till issue is fixed with various other teams including UNIX, Storage and Application Teams. It included troubleshooting, time to time database health check and monitoringInstallation of oracle 10g/11g/11gR2, Oracle 10g/11g (RAC) on multi nodes and Patches, migration / up gradation and implementation of RAC database on HP UX, Linux clusters environments on ASM. Close coordination and interaction with system administrators for hardware and system reconfigurations. Making sure the SLA’s are metInstallation and monitoring of IBM toolkitInteracting with Oracle and creating any SR for various errors/issues and following up to resolveClosely worked with system administrators for hardware and system reconfigurations.Worked on various Project related work with Clients and PM’sWorked on various ad-hoc tasks and tickets like user security, database growth, space utilization etc.Writing and fixing custom shell scripts for various Production Tasks

Loblaw Companies Ltd Missisauga, ON Aug 2009 to Jun 2010

Oracle DBA

Working on IPFR Project for Batch Support and Enhancements for JDA application for Demand and Replenishment solution

Installation of oracle 10g, Oracle 10g (RAC) Designed and implemented a complete database health script Designed the backup and archival policy for production database and archived log backupConfiguration of Maximum High Availability features like DataGurad, Flashback, LogMinor for Non RAC / RAC database, monitoring and automation of switchover and fail over. Testing and automation of the data Guard setup in RAC Environment for High Availability and disaster recovery. Configuration of shared servers ( MTS ) for OLTP systems. Tuning the database and application with Oracle 9i automated inbuilt features. Documentation of benchmarks and metrics. Designing and developing standards for various database administration activities including database design, security, benchmarking, backups and data archiving. Involved in evaluating, prototype and recommend new features and techniques to development teams, and design and develop fail over and disaster recovery techniques and procedures Management, capacity planning for storage and maintenance of Cluster file system / shared RAW devices for RAC databases. Involved in testing and analyzing the High availability features of Oracle 10g for RAC and DataGuard for the existing infrastructure assisting users with SQL and PL/SQL needs in day-to-day operations and implementation of logical designs. Implemented the Oracle 10gpartitioning for DSS / OLTP systems. Migrated number of oracle 8 / oracle 8i database to oracle 9i standalone and to RAC environment.

Yellow Pages Group Scarborough, ON July 2008 to July 2009

DBA

Yellow Pages Group (YPG) is Canada’s leading local commercial search provider and largest directory publisher. I worked on various Projects for different providers and supported the application for yp.ca.

Oracle installation, Creation of database, which includes physical and logical design.Created and implemented Database Backup script for Hot backup, archive log backup and catalog syncingInstalled Oracle 11g on development environment on HP UX and Windows Server 2008. Upgraded Oracle 10g database to Oracle 11g database for development and testing using manual upgrade processAdministered SQL Server database for Yellow Pages web synonyms mapping for categories and directories services. Migrated data from sql server to Oracle for data validation and reporting.Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of development, UAT, and production environments.Perform server installations, configuration, upgrades, maintenance of Data and Replication servers, contingency testing, implementation and enforcement of the standards, scripting and documenting.Provide 24x7 production supports on rotated basis. Environment includes multiple Oracle Servers, distributed database systems, Oracle replication across multiple locationsMaintain disaster recovery and replication databases to reduce the impact of any database or server outages configuring and maintaining replication environment. Setup Replication Site, Creating Master Groups, and Snapshots Group. Designing Conflict Resolution Methods, Refresh Methods. Trouble Shooting and Resolve Replication Problems. Security setup for multimaster and snapshot replicationInstalling and configuring STATSPACK for peak performance, Extending STATSPACK to capture server statistics. Performing trend analysis with STATSPACK data. Tuning the server environment, including the CPU and RAM, Monitoring and tuning disk I/O subsystems Detecting and correcting instance performance problems. Locating and tuning SQL statements Tuning SGA, Rollback segments, Latch contention Issues, Optimize Sort OperationCreate appropriate indexes for queries and suggesting changes to application developerDesign and Perform backup schedulesTesting the production archive log files by performing time-based recoveries on simulation databasesPerforms extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environmentCreating objects required for the application team after carefully estimating the sizes Monitors and maintains all production and development databases in a proactive manner to minimize the potential for database outages and performance problemsApplied, tested & administered Patches/Minpacks/Mega Patches in Development/Test/ Production.Talked to Oracle Support, opened TARs and taken pro-active corrective actions.Unix shell scripts for database administration, backup and performance monitoring.Electronically documented all the Development/Test/Production Activities for the client Record.Involved in Oracle Migration from 8.0.5 to 8.1.7, 8.1.7 to 9i applying patches, managing RMAN backups, Provides technical support to programmers on database issues

Environment: HP/UX, Solaris, Windows Server 2008, Oracle 8.0.5/8.1.7/9i/10g/11g, Oracle Advanced Replication, Perl, Pro*C, Oracle Expert, Oracle Enterprise manager, Shell Script, SQL Toad

GM Motors, MI USA

Oct 06– Jul 08

I worked on Brand Management Platform (BMP) project for various enhancements, production support and other development activities.

Oracle DBA

Work with storage estimation, storage maintenance, security management, auditing, user/privileges management, defragmentation and resource management for Oracle databases.Installed Oracle 10g on development environment on AIX and Windows Server 2003.Setup test database and performed DBA activities.Set up and tuned Oracle clustered environment (RAC) to improve Scalability and load distribution to overcome resource bottlenecks Develop technical specifications document to provide requirement solutionMonitored database performance to identify and resolve bottleneck for database and OS related issues.Managed the migration of SQL Server 2000 databases to SQL Server 2005Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning AdvisorWorking with application and database team to implement data guard for disaster recovery and availability with RMAN to disk and tape. Resolving issues with Oracle support using metalink.Installation of new databases in Development and test environment and duplication of database to development and testing purposes.Working to design and test Yellow pages data center move by migrating data from current test server to new datacenter. This is for migrate Yellow pages servers from current to new datacenter.Implemented backup and recovery procedure using RMAN to SAN and RMAN to tape backup. Implemented UNIX scripts for Duplication of production database to DEV/QA.

Wellsfargo, MN USA

Apr 05– Oct 06

Oracle DBA

Network setup for Oracle servers. Single and multiple listener configuration and local naming using tnsnames.ora. Worked with Network administrator to resolve firewall issues regarding Oracle traffic by opening oracle network ports.Upgraded several Oracle 8i databases to Oracle 9i and 10g using oracle upgrade assistants and Transportable table spaces and export utility between Oracle 9i and 10g with minimum downtime.Designed and implemented Hot and Cold backups using RMAN and VERITAS NETBACKUP, with a separate catalog database, and daily cron jobs. Installed required VERITAS modules for UNIX Oracle client and configured the VERITAS module with Storage node and Tape backup. Automated RMAN Backup script to backup using VERITAS and/or legato networker. Responsible of identifying UNIX patch upgrade for oracle releases. Designed Unix/Oracle upgrade process for servers that were no longer supported by vendor. Worked with UNIX SA for issues related to server upgrade. Design and documented server/oracle upgrade process.Setting up DataGuard for Dister Recovery for physical Standby.Designed and implemented Oracle RAC in development environment for future RAC implementation and migration of non-RAC to RAC environment. Created and documented change control procedures for database and UNIX maintenance and upgrades.Maintenance and support of Symantec Enterprise Vault for document archiving.

Allstate Insurance Company, Northbrook, IL. USA

Jan 04 – Apr 05

DBA

System and application administration of several AIX and Sun UNIX servers Responsibilities included installing ADC Newnet SMS application on AIX servers, writing and testing software support scripts, software upgrades, troubleshooting application problems.Administration of IBM Aix and Sun Solaris Unix servers including Installation, monitoring and performance tuning. Designed and implemented several Korn shell scripts to maintain subscriber information in the SMS servers.Installed a separate server with OEM to monitor all Oracle databases. Created basic and advanced events to monitor database capacity, snapshot jobs, database and listener. Creation and setup of Oracle GRID CONTROL.Providing Maintenance and support for several s running on Sun 450 with Solaris UNIX 2.6 and 2.8 systems for various DSS and OLTP applications. Duties included daily health of all the databases and monitoring of memory usage, disk space utilization also responsible to monitor UNIX performance that affects the database performance including memory, swapping, iostat, CPU stats. Monitoring database and UNIX space utilization and growth requirement.Installation of ORACLE software in Sun and HP UNIX. File system layout and directories setup for Oracle on local file system or SAN. Configuration of shared memory structure for Oracle instance. Automation of Startup and shutdown scripts for UNIX. Creation of databases using cooked file system and raw devices on local or SAN. Worked with UNIX system administrator for the installation of SAN fiber channel. Migration of Oracle data files from local disks to SAN. Setup of RMAN backup to SAN.Work with storage estimation, storage maintenance, security management, auditing, user/privileges management, defragmentation and resource management for Oracle databases.

Pfizer, MI Dec 99 – Jan 04

Oracle DBA/Developer

Pfizer is a leading Pharmaceutical company in US.

Create appropriate indexes for queries and suggesting changes to application developers.Wrote Unix shell scripts for database administration, backup and performance monitoring.Gathered and analyzed business requirements and documented them into logical and physical database design. Designed and developed data models and workflow including packages, procedures, functions & triggers.System coding included writing extensive and complex back end PL/SQL scripts to capture the data from different applications and to produce different management reports.Tuning of Reports, Scripts and Screens to optimize queries.Established database standards regarding issues such as space requirement, backup & recovery strategies and distribution of DB’s physical & logical objects.Back-end and front-end development - user screens and reports, database stored PL/SQL and Java code.Created job schedule scripts as and when required.Integral part of development team and Sr. developer in Oracle design for the replication process of transferring product information data to and from client sites.Design automated data extraction process (ftp, UNIX shell scripts, SQL*Loader, Erwin, PL/SQL) for weekly submission and retrieval of identification data from external vendor.Interacted extensively with team members to provide input into various design and debugging issues and served as in-house expert for other Programmers assigned to this project.Working with application and database team to implement data guard for disaster recovery and availability with RMAN to disk and tape. Resolving issues with Oracle support using metalink.Installation of new databases in Development and test environment and duplication of database to development and testing purposes.Working to design and test Yellow pages data center move by migrating data from current test server to new datacenter. This is for migrate Yellow pages servers from current to new datacenter.Implemented backup and recovery procedure using RMAN to SAN and RMAN to tape backup. Implemented UNIX scripts for Duplication of production database to test/QA for one oracle database

Environment: Oracle 7/8i/9i, PL/SQL, SQL*PLUS, Oracle Forms 8i, Oracle Reports 8i, Oracle Workflow, MS Access, UML Rational Rose, TOAD, ClearCase, ClearQuest, Java, HTML, ASP, XML, Pro*C, C++, Visual Basic 6.0, Windows 2000/NT, Unix.

Education

M.S. in Computer Engineering from Wayne State University, MI USA

Technical Trainings

Oracle 9i: Performance Tuning Oracle Training Detroit, MI USA

Oracle 9i: Database fundamentals II Oracle Training Detroit, MI, USA

Oracle 10g: Database Fundamentals I Oracle Training Minneapolis, MN USA

Contact this candidate