Oracle Manager

Sandeep Singh Thakur

Ph: 201-***-****

Email: acb08m@r.postjobfree.com

PROFESSIONAL SUMMARY:

• Database Architect and Certified Professional with over 10+ years of experience in IT, including

database Architecture, Design, Modeling, Installation, Administration, Development, Tuning and ETL.

• Experienced in developing data models using Erwin, ER Studio, Power Designer tools.

• Develop Data Warehousing, Data Mart blueprints, evaluating hardware and software platforms, and

integrating systems.

• Assisted with Change management (CAB), ITIL, Cyber security enforcement and CMDB policies.

• Possess expertise in migration of databases, servers & networks in a Data Center environment

• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX,

Sun Solaris, IBM AIX, Windows and Red Hat, Oracle Enterprise Linux environment.

• Experienced in Install, Create and Configure MS SQL Server 2005, 2008, 2008R2 databases,

administering using SSMS.

• Proficient at performing major Database Release Upgrade (scripts as well as using DBUA) along with

applying various PSU patches using OPatch for 9i 10g 11g databases.

• Experience in designing and configuring high-availability systems using DataGuard with physical

standby effectively configured and used DataGuard Broker utility.

• Adept at installation of OEM Database Control, OEM grid control and Deploying Agents.

• Experienced in using Oracle's Transportable Tablespace (TTS) to migrate Tablespace across Oracle

databases.

• Experienced in Designing, Installing, Configuring and Maintaining Real Application Cluster (RAC)

using raw devices, OCFS, Automatic Storage Management (ASM) and SRVCTL utility.

• Expert in implementing Oracle Streams (unidirectional, bi-directional and downstream capture) and

managed Operational, Historical and reporting databases.

• Experienced in Oracle GoldenGate installation, configuration, troubleshooting GG issues using

GGSCI.

• Fabricated multiple CLONING databases using traditional method (scripts) and RMAN utility.

• Designed developed and implemented complete RMAN backup and recovery solution for

full/incremental backup and recovery of databases using Veritas Netbackup, Tivoli Server Manager

with and without catalog. Used RMAN to duplicate database from active database as well as from

RMAN backup and also performed point in time recovery. Used RMAN to create standby database.

• Acquainted in designing and implementing PL/SQL stored procedures, functions, packages, triggers

and SQL for automating daily administration tasks

• Performed FlashBack features to handle efficient database recovery and implementing restore points

for testing.

• Qualified at writing Shell Scripts and using Crontab for automatic daily administrative tasks.

• In-depth knowledge and understanding of Oracle Database features Materialized Views,

Export/Import, Data Pump, SQL Loader, Row Chaining, Row Migration and External Tables.

• Working knowledge of Auditing, FGA and Database Security.

• Monitor and maintain system security and Auditing. Experienced in executing HIPPA/SOX related

auditing controls.

• Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic

shared memory management (ASMM), Automatic memory management (AMM) ASH and Buffer

Cache Advisors.

• Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and

ANALYZE command.

• Scheduling and Troubleshooting Database performance issues using Statspack, Automated Workload

Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).

• Efficient in SQL query Optimization using Explain plan, Auto trace, TKPROF, Gathering statistics,

pinning objects.

• Knowledge on Oracle Support processes for technical requests through Meta link.

• Monitoring & Reorganizing Tablespace/Tables/Indexes to improve performance.

• Creating Users, Profiles, Managing Sessions, Privileges and Roles.

• Experienced in converting Business Requirements to Technical Specifications.

• Supported the system 24x7. Ability to work beyond regular hours. Carried primary and secondary

support roles with pager rotation to support during weekends, Holidays and beyond regular hours.

TECHNICAL SKILLS:

C, C++, Java, PL/SQL, SQL,HTML, Shell Script, TSQL,PLSQL Languages

Oracle 12c/11g/10g/9i/8i SQL Server 2005/2008/2008R2 Database

Management:

HP-UX 10.x, 11.x, Sun Solaris 5.8, 5.9, 5.10, AIX 5.1, 5.2, 5.3, 6.1 Red Hat Linux Operating Systems

RHEL 4.x, 5.x, 6.x and Windows NT/2000/2003/2008/XP.

Oracle Enterprise Manager(OEM), TOAD, GRID control, SQL Trace, 10g&11g RAC, Utilities & Tools:

Oracle Streams, Oracle GoldenGate 10x,11x Oracle Scheduler, SQL Developer, Putty,

RAID Systems, isqlplus, DBCA, DBUA, Oracle Data Guard, RMAN, ASM,

Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump

(expdp, impdp), ERwin, ERStudio TOAD Data Modeler, DBLINK, VERITAS Net

Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK,

AWR, ADDM, BCP, SSIS, SQL Server Management Studio(SSMS), SVN source

control, PMI – Agile-Scrum

Real Application Clusters (RAC), Oracle Streams, Golden Gate, Cloning, Dataguard, High Availability.

Dataguard Broker

CERTIFICATIONS:

● Project Management Professional – PMP

● Six Sigma White Belt

● Information Technology Infrastructure Library - ITIL V3 Foundation

● Oracle 11g Database Administration I Certified Associate ( OCA 11g)

● Oracle 10g Database Administration II Certified Professional (OCP 10g)

● Oracle 10g Database Administration I Certified Associate (OCA 10g)

● Introduction to Oracle 9i SQL

Professional Experience:

Fannie Mae, Herndon, VA Oct’12 – Till date

Role: Enterprise Data Architect

Project: CDR, EDR, CDM, NUCDM

Fannie Mae is a government-sponsored enterprise (GSE), to help strengthen the U.S. housing and mortgage

markets, and to support affordable homeownership. The corporation's purpose is to expand the secondary

mortgage market by securitizing mortgages in the form of mortgage-backed securities allowing lenders to

reinvest their assets into more lending and in effect increasing the number of lenders in the mortgage market by

reducing the reliance on thrifts

Responsibilities:

• Work closely with business analysts, subject matter experts and development teams to gather

requirements, design, develop, test, implement, and Data Warehouses and Data Marts with about 260

entities and 4000 attributes.

• Create and Develop data model using modeling Erwin, ERStudio tools for Credit Loss Mitigation

division of Fannie Mae.

• Involved in developing and managing data models and associated metadata management for data

lineage in the enterprise.

• Technical Lead for ETL, Modeling teams to bring data from 12 various sources (Mainframe, Oracle,

Flat files and others) into comprehensive credit system, research and simulation system using Abinitio.

• Mapping and auditing data/information assets as they flow from upstream applications and interfaces

to downstream reporting and analytical applications, to ensure optimal transparency, quality,

consistency, and controlled redundancy across the organization.

• Responsible for designing data warehouse models, objects and developing and implementing data

migration processes.

• Work with PMO, project managers and release managers to plan, provide LOE’s and execute

deliverables per schedule.

• Shared responsibilities with Enterprise Architects to design and develop road maps for strategic goals

for credit division.

• Creating Database specific DDL’s for application database and maintain versioning using Tortoise SVN

• Created Partitioned tables using various Oracle Partition methods, Materialized Views, Indexes for

easy maintenance and better performance.

• Worked with ETL team to create bitmap indexes on low cardinality keys, create dedicated storage for

staging and target tables to bring down load time to less than 40% of initial load time.

• Developed Oracle procedures, functions and packages to handle various business requirements, for

exception handling, data cleansing/consistency.

• Developed and maintained documentation for Enterprise Privacy and Security work groups.

Environment: Tortoise SVN, ER-Studio, ERWin, Abinitio, MS Project, PMI Agile, Oracle 9i,10g,11g, SQL

Server 2008,2008R2, SAS, Oracle Grid control, Solaris, HACMP, PL/SQL, AIX, SAP, DBArtisan, TOAD,

SQL *Plus, RAC, GoldenGate.

Southern California Edison, Irwindale, CA Dec’11- Oct’12

Role: Database Architect

Project: IT&BI, IDM

Southern California Edison (SCE Corp), the largest subsidiary of Edison International (EIX), is the primary

electricity supply company for much of Southern California, USA. It provides 14 million customers with

electricity. In addition, SCE operates a regulated gas and water utility. SCE is the sole commercial provider of

natural gas and fresh water service for most parts of Southern California.

Responsibilities:

• Involved in complete life cycle (SDLC) of Identity Management (IDM) project aimed to strengthen

enterprise level security.

• Managed CAB/ECAB, responsible for accessing impact on various databases/applications and

approving requests.

• Perform data access analysis design, and archive/recovery design and implementation

• Translate business needs into long-term architecture solutions

• Assist in developing and maintaining standards for naming, describing, governing, managing,

modeling, storing, cleansing, and transforming all data within the enterprise.

• Work in a data warehouse environment, which includes data design, database architecture, and

metadata repository creation and management.

• Installation, Design, Create and Configure Oracle 10g/11g database on AIX, Linux and Windows

servers.

• Upgraded 8i/9i databases to 10g/11g using scripts, DBUA and export-import utilities.

• Created and Configured RMAN databases, upgraded RMAN catalog databases.

• Configured 10g/11g standby database for disaster recovery using Oracle DataGuard.

• Implemented Oracle GoldenGate on table level to propagate changes from OLTP databases to DSS

databases.

• Configuring 10g /11g OEM for stand-alone and standby databases

• Supporting 8+ TB VLDB Edison Smart Meter databases.

• Partitioned tables using DBMS_Redefinition and export-import utilities to improve performance.

• Involved in recommending and establishing standards, guidelines, and procedures for design and

maintenance.

• Refreshing test and development databases using RMAN and exports(Regular/ Datapump)

• Actively worked on performance tuning of instance (SGA and PGA) and Physical database that

included resolving fragmentation and disk contention.

• Installing, Creating and Administering SQL 2008R2 databases.

• Backup, restore and refreshing SQL Server databases using SSMS.

• Monitor database capacity and growth. Develop expansion/scalability plans.

• Working closely with Application team in deployment of bug fixes, releases and post deployment health

check.

• Creating users, roles, controlling access in compliance with SOX regulations.

• Restored tables using Oracle Flash back technology and TSPIT recovery.

• Meetings with business users to discuss and fine tune the requirements.

• Preparation of Proof of concept and impact analysis.

Environment: ERStudio 8.x, Abinitio, ITIL, Oracle 8i,9i,10g,11g, Oracle Enterprise Manager, Oracle Grid

control, RHEL, HP-UX, HACMP, PL/SQL, AIX, Citrix, SAP, DBArtisan, TOAD, SQL *Plus, SQLServer

2005, 2008R2, SSMS, Tortoise SVN.

Toshiba America Electronic Components, Irvine, CA Aug’10- Dec’11

Role: Lead DBA / Data Architect

Project: SDDCM

Toshiba is a leading innovator in Semiconductor industry. TAEC, one of the business units of Toshiba, offers

memory storage solutions, a broad range of discrete devices, displays, medical tubes, ASICs, custom SOCs,

microprocessors, microcontrollers and wireless components for the computing, wireless, networking,

automotive and digital consumer markets

Responsibilities:

• Worked with the Business analysts for requirements gathering, business analysis, testing, and metrics

and project coordination for Data Center Migration project, involving hardware and software

migration

• Conducted meetings with management and user community to understand the business requirements

and convert Business requirements into technical specifications.

• Responsible for defining governance and best practices around meta-data to ensure an integrated

definition of data for enterprise information, and to ensure the accuracy, validity, reusability, and

consistent definitions for common reference data across the enterprise.

• Involved in Installing, Configuring, Administration and tuning of Oracle 10g RAC on ASM.

• Upgraded Oracle databases from 9i to 10g /11g manually and using DBUA.

• Installed 10g /11g binaries on Solaris and Linux servers and configured new production databases for

the same.

• Involved in Design, implementation and generating documentation of Oracle 9i/10g Data Guard on

physical standby databases in high availability mode.

• Defining and implementing database monitoring controls, executing SOX related controls.

• Migrated 9i/10g Databases from Fiber Channel LUN’s to NFS Storage system.

• Performed DataGuard testing (SwithchOver) on a regular basis to ensure High Availability

• Monitoring and troubleshooting GoldenGate replication issues such as GG Abend.

• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups

(with Export/Import Data pump utilities).

• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback

segments, Constraints, Database Access, Roles and Privileges.

• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of

Hints, Stored outlines, Statistics for the same.

• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using

automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active

Session History (ASH).

• Worked closely with the Oracle developers for the better performance in Applications in writing the

Packages, Triggers, Materialized Views and Indexes on the tables.

• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

• Involved in PL/SQL and UNIX shell scripting and automating them using Cron Utility.

• Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.

Environment: Oracle 9i/10g/11g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, GoldenGate

11x, TOAD, SQL, PL/SQL, AIX, HP-UX, Solaris 8,9,10, RHELAS4.0, SQL Server 2008R2.

Emblem Health, Melville, NY Nov’09-Jul’10

Role: Sr. Oracle DBA

Project: SRM

Emblem Health through its companies Group Health Incorporated (GHI) and HIP Health Plan of New York

(HIP) provides affordable, quality health care coverage and administrative services to approximately 2.9 million

people. The goal of the project is to install, configure and administer oracle 10g RAC for few critical databases.

We successfully implemented oracle 10g RAC for High availability.

Responsibilities:

• Installation and Configuration of Oracle 10g Database on UNIX platform using single node and Multi

nodes (RAC) with ASM, OCFS and RAW devices.

• Experienced in Installation and configuration Oracle GoldenGate for data integrity and consolidation.

• Involved in Migration of Databases from AIX to Linux using RMAN and Oracle transportable

tablespace (TTS).

• Creating Test and Dev instances as required using RMAN and Scripts.

• Experienced in the installation of Oracle Grid Control in Server (OMS Oracle management Server)

and installing the Agents in all the production, test and development databases and configuring them.

• Made performance improvements to the database by building Partitioned tables, Index Organized

Tables, Materialized Views and Bitmap Indexes.

• Used Export/Import and Datapump utilities for full/partial backup.

• Performing Backup/Recovery of all the Oracle databases using RMAN, also setup RMAN catalog for

the same.

• Sizing the SGA, db buffers, shared SQL area, log buffer based on the requirements.

• Performed logical backup using export/import and data pump (remote export) utilities.

• Wrote UNIX shell script to perform backup and schedule it with Crontab.

• Optimize SQL queries for better performance.

• Carried out Optimizing performance and Query tuning using Statspack, Tkprof and OEM.

• Use Explain Plan for monitoring the query execution.

• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and

Automatic Database Diagnostics Monitor (ADDM).

• Installation and configuration of Oracle Client software and Tools.

• Provided Production DBA support, as needed, on a 24/7 basis.

Environment: Oracle 9i, 10g-RAC-ASM R2,11g, Oracle Enterprise Manager, Oracle Grid control, RHEL,

HP-Itanium, HP-RISC, AIX, DATAGUARD, Streams(CDC), GoldenGate, PL/SQL, TOAD, SQL *Plus, SQL

SERVER 2000/2005.

Sprint Nextel Group, Iselin, NJ Dec’08- Oct’09

Role: Oracle DBA

Sprint Nextel is widely recognized for developing, engineering and deploying innovative technologies including

robust wireless networks serving more than 53.1 million customers in USA Major part of this project involved

configuration and creating of databases to support market growth and implementation of Physical standby

database.

Responsibilities:

• Capacity planning, Install, configure OLTP, Data warehouse (DSS) databases( Oracle 9i &

10GR2) Either in shared environment/standalone environment as well as on VMware virtual

machines.

• Involved in database upgrade from 11.1.0.6 to 11.1.0.7 for DEV and TEST environments.

• Used SRVCTL utility for managing multiple instances and nodes.

• Experience in configuring and maintaining Oracle Replication by using Oracle streams (CDC)

for Data replication from production system to Data warehouse on 11g RAC Environment.

• Implemented the database with ASM storage, skilled towards database tuning and hands on

experience in database security (auditing), recovery, archival concepts and procedures.

• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD

utility.

• Upgrade the production and development databases from 9i to 10g on AIX.

• Created and maintained standby databases using database replication (Data Guard) for high

availability.

• Configured databases on Veritas Cluster Server (VCS) and performed cluster failover/failback

test.

• Cloned the databases using scripts, cold/Hot backups and Using RMAN.

• Regular monitoring of the databases with Oracle Enterprise Manager, Grid Control for

operational databases with high sensitivity alerts

• Performing SQL*Loader jobs for loading data from text files

• Actively worked on performance tuning of instance (SGA and PGA) and Physical database that

included resolving fragmentation and disk contention. Use Partitioning and indexing feature of

Oracle 10g to improve performance.

• Implemented OLAP Data warehouse.

• Disaster recovery planning; implemented database backups and disaster recovery strategies using

RMAN and data pump export, import.

• Troubleshooting and Tuning of production & RAC databases.

• Supported very large database with heavy OLTP and batch activities Writing and testing PL/SQL

procedures (stored procedure, triggers, function, cursors and packages) for maintaining tables,

retrieving data from tables and managing users. Responsibilities included working with developers

to tune the PL/SQL, SQL.

• Designed and Implemented database security using Oracle roles and privileges.

• Experienced in optimizing SQL and PL/SQL tuning using CBO, explain plan, TKPROF,

Statspack, ADDM and AWR.

• Involved In query optimization and using rule based optimizers and cost based optimizers

• Worked on sizing of database and tables, re-organizing of tables, tablespaces and users.

• Work with a geographically dispersed team for round-the-clock monitoring of production systems

Environment: Oracle 9i, 10g, 11g, Oracle Enterprise Manager, Oracle Grid control, RHEL, HP-UX,ERWIN,

PL/SQL, Informatica, Shareplex, AIX, RAC, Streams TOAD, and SQL *Plus.

Drugstore.com, Bellevue, Washington July’07- Nov’08

Role: Oracle DBA

Drugstore.com is an internet retailer in health and beauty care products. Established in 1999, drugstore is one

of the healthcare retailers.

Responsibilities:

• Installation of Oracle Database Software 9i/10g. Created database through DBCA and manually.

• Worked with other DBA’s for Capacity planning of new Databases. Data replication between different

Oracle databases using DBLinks. Setup test environment to simulate the migration process.

• Involved in Installing & Administering Oracle Real Application Cluster (RAC) 10g on ASM

• Convert database from Non RAC database to RAC database using RMAN and ASM.

• Implemented Oracle Uni-Directional Streams for a 10g database.

• Upgraded from 9.2.0.7 to 10.1.0.2 database and installed patches for new Oracle software and doing

TAR support.

• Export/Import (Data Pump) of data using batch method. Backup and disaster planning using User

Managed/RMAN. Prepare approach and steps of migration which will be carried for OLTP and DWH

databases of production data. Installed and generated Statspack report on each server for

benchmarking the database statistics.

• Responsible for database performance tuning for memory (SGA), disk I/O contentions, rollback

segment contention and application tuning.

• Created PL/SQL Packages to move / transform data from OLTP to DWH. Gathering statistics of data

objects using Analyze and DBMS_STATS. Developed scripts to monitor the storage usage, object

status for daily jobs. Database & Instance configuration using Grid control, ADDM, ASMM, etc.

• Doing the regular activities like monitoring the alert logs, redo log status, listener. Log, v$session and

checking the space for normal segments, rollback segments.

• Involve in the database community meeting with the client to discuss the methodology and decide the

strategy of migration. Preparation of database migration document. Effort estimation for Data migration

for all the databases. Helped in preparation of Project plan for the Migration.

Environment: Oracle 9i/10g, RMAN, RAC, ASM, OEM, DATAGUARD, DATAPUMP, Streams, TOAD,

SQL, PL/SQL, AIX, UNIX, HP-UX, Solaris, RHELAS4.0

Compass Bank, Concord, CA Aug 06 - June 07

Role: Oracle DBA

BBVA Compass is a leading U.S. banking franchise located in the Sunbelt region. BBVA Compass is the 15th

largest U.S. commercial bank based on deposit market, operating more than 720 branches national wide.

Responsibilities:

• Creation of users, Implemented database auditing, data security.

• Partitioning tables by determining the suitable methodology to improve performance and

manageability.

• Generated scripts for daily maintenance activities like analyzing the tables/indexes, growth rate and

SGA use.

• Performed Hot, Cold, Table space level backups and Detection of corrupted blocks by using utilities

like DBVERIFY and with RMAN Block corruption.

• Implemented a backup strategy integration with VERITAS Net Backup

• Creation and migration of DB and other related Objects including schema objects

• Created scripts for hot backup and export on a daily basis scheduled with cronjobs.

• Plan for system and monitor capacity usage for new hardware and software requirements

• Automation of Startup Shutdown on all Production and Development Database.

• Interfacing with oracle corporation for technical support(METALINK)

• Modified the listener port number and to archive log mode for one of the existing database

• Clone and refresh environments to create patch test, development and QA environments.

• Conducted multiple test runs to gather timings for production upgrades.

• Implemented Disaster recovery (standby database 9i), documented database and application validation

steps.

• Extensive custom development/data quality analysis; Legacy data processing, stored procedures,

Triggers, indexing strategies.

• Automate monitoring jobs, backups and alerts using UNIX shell scripts.

• Applying Upgrade, CPU Patch and bug fix patch.

• Loading data using SQL Loader.

• De-fragment tables and indexes for improved performance and effective space management.

• On-going SQL tuning using Explain Plan and SQL Trace.

Environment: Oracle 9i, 10g R2, Oracle Enterprise Manager, Oracle Grid control, RHEL, AIX, HP-UX,

RMAN, Snap Mirror, DATA PUMP, DATA GUARD, RAC, PL/SQL, TOAD and SQL *Plus.

Indus Towers Ltd, India Jun ‘03 – Aug ‘06

Role: Software Trainee

Indus Towers Limited is an independently managed company offering passive infrastructure services to all

telecom operators. Indus is headquartered in the National Capital Region, New Delhi. Indus Towers was

incorporated with an objective to provide shared telecom infrastructure to telecom operators on a

nondiscriminatory basis.

Responsibilities:

• Install / upgrade the Oracle databases and Oracle applications software & patches.

• Involved in Upgrading the database versions from 8i to 9i

• Backup and Recovery (using Cold Backups, hot backup, export/imports)

• VERITAS Net Backup 5.1 Backup & Media Management

• Restoration .Cloning the database and Recovery Drill

• Extensive knowledge of maintaining using Standby databases for high availability

• Basic SQL, monitoring system processes, setting up user privileges/passwords and all related

activities

• Table spaces and rollback segments maintenance

• Controlling and monitoring user access to the database

• Monitoring and optimizing the performance of the database

• Worked on call for 24x7 production Databases in Data center.

• Maintenance of Oracle Databases on the Production Machines

• Maintaining archived data on tape

• Involved in setting up backups, database re-orgs, upgrades and monitoring of databases to identify

performance issues.

• Performance monitoring / tuning.

• Tuning and monitoring multiple instances of Oracle on various platforms using Oracle Enterprise

Manager.

• Design and Implement Backup & recovery procedures and ensure reliability of Database Backup

and Recovery schemes

• Using export and Import utilities to take Logical backups

• Handling complete and incomplete recovery in case of database failure

• Performing database re-organization to get rid of fragmentation and also preventive maintenance

• Monitor database growth and size databases as required

• Monitor disk space usage, balance I/O load.

• Troubleshooting connectivity issues and network problems

• Monitoring alert logs, error trace, free spaces, file systems etc.

• Extensively worked on SQL* Loader to load data from other databases and text files into Oracle

Database

• Writing Shell scripts for automating backup and monitoring for the database

Environment: Oracle 8i/9i, Oracle Enterprise Manager, RHEL, PL/SQL, TOAD and SQL *Plus.

Contact this candidate