Oracle DBA

Amol Joshi

*** ********* *****, *** ***, Santa Clara CA 95054

E-Mail: *************@*****.***, Cell: 315-***-****

SUMMARY

Over 6+ years of sound experience as core DBA in database design and

administration of Oracle 9i,10g and 11g and SQL Server 2000/2005 in

development, integration, staging and production environments on .Unix (Sun

Solaris, RedHatLinux) and Windows servers.

.Experience in database administration of OLTP and Data warehousing (OLAP)

environment.

.Working knowledge of ETL tool Informatica to create design process flow

for Data extraction transformation and load and subsequent mappings.

. Knowledge of database machine EXADATA, architecture, configuration,

patching.

.Demonstrated proficiency in managing Oracle/SQL Server Instance, database

storage structure, schema objects.

.Strong knowledge of SDLC and AGILE methodologies.

.Conversant with best practices of ITIL to design solutions by mapping

customer business problems to reusable end to end process and process

combined with technology solutions.

.Excellent knowledge and understanding of Oracle Architecture (SGA, PGA,

Instance).

.Expert knowledge of maintaining security by creating Users and Roles with

appropriate Privileges and Profiles, OID.

.Knowledge of Oracle Audit Vault for automating the audit collection,

monitoring and reporting process for detecting unauthorized activity.

.Constructed Partitions on tables for managing large tables.

.Monitored tablespaces, segments, extents, and indexes.

.Good understanding of Parallelism and batch processing of SQL queries in

OLTP environment.

.Hands on experience of managing Very Large Databases (VLDB) in the range

of 500 GB to 20 TB.

.Extensive use of Crontab in UNIX environment for scheduling routine tasks.

.Experience in writing UNIX shell scripts to check the status, space

management and performance of the database.

.Knowledge of RAID levels namely RAID 0 through RAID 5.

.Strong knowledge of SQL Server 2000/2005 database techniques DTS and SSIS

for data transformation.

.Experience in using oracle packages such as DBMS_STATS, UTL_FILE, DBMS_JOB

and DBMS_SCHEDULER.

.Implemented Database link to access the object on remote database and

script to check the connectivity among all the databases.

.Exposed to database tuning, SQL tuning and capacity planning in Oracle

8i/9i/10g environments.

.Cloned database from PRODUCTION to TEST and DEVELOPMENT and from

Development to production using RMAN.

.Strong experience in performing database backup, restore and recovery

using RMAN.

.Experience in Upgrade and Migration of oracle database to higher version

installing patches and other platforms without/with using Oracle Data

Migration Assistant (DBMA) and Oracle Data Upgrade Assistant (DBUA).

.Effected performance-tuning using Automated Workload Repository (AWR) and

Automatic Database Diagnostics Monitor (ADDM).

.System Analysis and Designing using Conceptual, Logical and Physical

database design and using Object Modeling techniques, Normalization

Techniques. Interactions with Business Analysts, Creating modeling

solutions to business problems.

.Used oracle flashback query utility to replicate past state of data.

.Used Oracle Grid Control and SQL Server Management Studio for monitoring,

tuning and configuring database components for better performance.

.Successfully implemented advanced High Availability technologies including

DATAGUARD (physical & logical stand-by).

.Exposure to Real Application Cluster (RAC) environment with Automatic

Storage Management (ASM) on Oracle 10g.

.Experience in using TOAD for debugging applications.

.Strong skill in SQL, PL/SQL package, function, stored procedure, triggers,

Materialized view, to implement business logics of oracle database.

.Enforced data Integrity using integrity constraints and database triggers

as per data model.

.Experience with Database SQL tuning and query optimization tools like

TKPROF, SQL Trace, Autotrace, Explain Plan, STATSPACK.

.Applying Patches using OPATCH utility, Upgrades, Troubleshooting database

issues, critical security updates and User Issues using Meta link.

.Experience of 24x7 production support of Oracle database in Windows and

Sun Solaris environments.

SKILLS

Databases: Oracle 11g/10g/9i, Oracle EBS 11i,SQLServer2000/2005, MySQL,

Cassandra, Berkeley DB

Data Virtualization: Denodo 4.7

High Availability : Oracle RAC 11g/10g, Dataguard

Replication : Goldengate 10.4/11.2

Environment : Sun Solaris 5.8/5.9, HP-UX11i, RedHatLinux 5.5, Windows

2003/2000/XP/NT, IBM AIX 4.3/5.2,True64 UNIX OS, J2EE, .NET

DB Utilities: SQL Loader, Exp/Imp, Datapump Utilities, Statspack, TKPROF,

RMAN, ORAPWD, Utlbstat, Utlestat, BMC SQL-BackTrack, Sqlnet, SQL Server

Management Studio,Denodo VDP.

Languages: SQL, PL/SQL, C, C++,XML, UNIX shell scripting (Korn, Bourne,

Bash), PERL, Windows Power Shell.

Tools: ERWIN 6.0,OEM,DBArtisan,Oracle Developer 2000, TOAD9.5, Veritas net

backup, F-secure client, ORADIM, Hummingbird, iSQL*Plus, Putty, Crystal

Reports, Remedy, Shareplex, Oracle Streams, Autosys, Oracle Warehouse

Builder 9i/10g, JDBC, Galaxy Backup & Recovery, VMWARE,QTP 9.2, Quality

Center, Rational Clear Quest,JSON, RAT(Real Application Testing), SQLT.

Others: MS Office, MS Visio, Adobe Acrobat Reader/Writer, HTML, UML, FTP,

SFTP, SCP, Telnet, TCP/IP, LDAP, NET8, Quest Spotlight, UML, MS Visio, IBM

Rational Clear Case (Version Control), NETIQ, LOADRUNNER.

Certification: Oracle 9i/10g Certified Associate

Certification: Brainbench-PL/SQL Programming.

Certification: Brain bench Certified in RDBMS Concepts

Certification: Microsoft SQL Server 2005-Implementation and Maintenance

Wireless Networking: CWNA

Coursera : Python Programming.

WORK EXPERIENCE:

Technology Software Inc

Client:Cisco Systems, San Jose CA.

Oracle DBA

01/2013 - Present

Working in CSTG-Smart services release team supporting QA, DEV,LT and

PROD environment. The environment is Agile and has many critical

applications collecting information about Network Devices in the field and

provides that data for reporting purposes. The data collected is used to

support Cisco devices located at client location. I am working as Oracle

DBA for SNTC/PSS application. We are in process of releasing production

environment for SNTC/PSS2.0 application based on CITIES GEN2 virtual

platform and I am heavily involved not only in creating the DB

infrastructure but also in capacity planning, backup and recovery strategy

creations, creation of documentation, migration test runs.

Responsibilities:

.Extensively involved in collaborating with testing team in performing load

testing which will help in capacity analysis of LT databases to scale up to

concurrent load from end users.

. Gathering statistics on databases using stats pack to analyze database

bottlenecks.

.Knowledge of NO SQL database Cassandra and non relational database

Berkeley DB.

. Performing checks on CPU, Memory and Storage while load testing is being

performed as the loads are of different types which flood the database.

. Creation of AWR, ADDM, ASH reports to detect bottlenecks in database if

loads running multiple high volume queries take long time to execute.

. Executing plans for TOP SQL to tune them and avoid hard parses and waits.

. Proactively installing OEM agents and monitoring databases through OEM

grid control.

. Performing Index analysis and rebuilding Indexes on objects if broken and

creating them if missing.

. Refreshing databases in DEV and QA with new builds.

. Maintenance of Oracle Database parameters(SPFILE) with values to support

application needs.

. Created documentation and separated data, indexes, LOBS from schema

objects and migrated them to their specific tablespaces in SNTC/PSS2.0 PROD

database for better management and faster access.

. Performed database upgrade from 11.2.0.2 to 11.2.0.3 on all databases in

DEV, QA and new PROD VMs

. Proactively creating housekeeping scripts and monitoring databases and

objects using them.

. Patching of database and grid home with latest patch set updates(PSU).

. Developed POC doc for database backup using hot backup scripts and RMAN,

tested recovery scenarios and implemented it .

. Knowledge of Cassandra systems backup and recovery

. Knowledge of Cassandra security

.Knowledge of Cassandra maintenance and tuning - both database and server.

. Created a POC for integration of Cassandra with Hadoop and HDFS.

. Installation of CassandraDB version 2.0 and issue resolution.

. Familiarity with SOX compliance process.

. Using Remedy to log tickets and resolving them.

. Knowledge of creation of CR(Change Request) through EMAN and REMEDY after

gathering information from concerned teams and getting approval.

. Expertise in creating and maintaining documentation.

Environment:

Oracle11g,OracleSQLDeveloper,OracleEM Grid Control, DENODO, SQL*Loader,

RedHatLinux, DBCA,DBUA,TOAD9.7.2,Remedy8.0, Dataguard 10g, Cassandra,

Berkeley DB.

Technology Software Inc

Client:Cisco Systems, Austin TX

Oracle DBA

02/2010 - 12/2012

Worked in CSDC (CISCO Service Delivery Center) for Cisco Developer Network

(CDN), Collaborative Professional Services(CPS), ROS clients managing

Oracle and SQL Server databases in highly available RAC environment in

close co-ordination with onsite and offshore teams in Cisco's in a multi-

tenant(vendor) service provider environment.

Responsibilities:

.Responsible for supporting windows and Linux based database systems for

CDN and CPS NDCS projects in AST6 datacenter.

.Programmed shell scripts to gather 100% performance metrics on the

systems.

.Formalized systems synchronization plan and documented it.

.Installed Oracle 11gR2 (11.2.0.3) RAC with ASM and installed latest patch

sets.

.Upgraded Oracle 10gR2 to Oracle 11gR2.

.Experience in managing ASM disks using ASMCA and ASMCMD utilities.

.Worked on refining architecture diagrams of upcoming projects and

providing suggestions to the clients about database versions, patches,

memory and systems needs for hosting applications.

.Working with DNS tools namely DNSCAP, DSC, dnsdump and dig to troubleshoot

DNS related issues.

.Knowledge of network security concepts.

.Actively administering 20 Oracle10g and 5 instances of SQL Server 2005

databases in Clustered environment.

.Created Oracle 10g two node RAC with ASM on RHEL 5.3. and virtual

machines.

.Expertise in RAC monitoring and maintenance.

.Implemented Backup & Recovery using RMAN for Oracle 9i/10gR2/11gR2 in

Linux environment.

.Prepared Shell script for automation of Export/Import process to sync up

stage with production.

.Performed character set change for production database to UTF8 to solve

Japanese localization issues.

.Using OEM grid control, OEM database control and SQL Server management

studio for performance monitoring, administration and maintenance of

databases.

.Created Phyiscal Standby database in Dataguard as part of disaster

recovery plan.

.Maintenance of primary and standby database configuration and mitigating

issues related to gap sequence.

.Performed Switch Over from primary database to standby database in

Dataguard for planned maintenance.

.Created documentation for DBA standards in CDN and CPS environment.

. Used import/export utility and Datapump utility to transfer data.

. Experience in working in Cisco's software as a service (SaaS), Platform

as a service (PaaS) and Datacenter as a service (DCaaS) environment.

. Troubleshot database performance issues using Automated Workload

Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and ASH

statistics.

. Hands on experience of tablespace partitioning using various schemes like

Range, Hash, List and Composite range-hash partitioning.

.Using SQL Server profiler and server side trace to troubleshoot problems

in SQL Server databases.

.Configured SQL Server Log shipping between primary and secondary servers.

.Experience in upgrading and applying security patches the databases.

.Experience in performance tuning and monitoring using various tools such

as STATSPACK, TKPROF, SQL Trace and Explain Plan, OEM.

.Working knowledge of Oracle security practices such as triggers, Auditing,

Transparent Data Encryption, Tablespace Encryption, Audit Vault.

.Performed Oracle EBS 11i installation.

.Code Migration through FNDLOAD and WFLOAD.

.Worked on Oracle Applications AD utilities.

.Knowledge on Cloning of Release 11i using the Rapidclone.

.Cloning of Oracle Applications with autoconfig.

.Experience as a production DBA, maintaining and troubleshooting large

databases, during off hours and over the weekends and maintaining multiple

instances in a 24/7 production support.

Environment:

Oracle11g/10g/9i,OracleEBS11i,OracleStreams,EmbarcaderoDBArtisan,OracleSQLDe

veloper,OracleEnterpriseManager,SQL*Loader,RedHatLinux,

OracleClusterware,DBCA,DBUA,TOAD9.7.2,Remedy8.0,SQL Server 2000/2005, SQL

Server 2005 Management Studio, Dataguard 10g

Nexgenb Inc

Client: FedEx, Memphis TN

Oracle DBA (Application DBA)

05/2009 - 12/2009

Worked as Oracle Design DBA at World Technology Center for EIS-DBA.com and

DBA-XBS.com teams supporting test and application development databases of

COMM group responsible for handling the shipping and revenue aspect of

FedEx business.

Responsibilities:

.Responsible for providing database design/development/testing and

implementation support for systems/projects prioritized through request by

development business partners as per Sarbanes-Oxley compliance procedures.

.Responsible for monitoring and evaluating health of 50 Oracle 10g and 9i

databases using Oracle Enterprise Manager and DBArtisan.

.Worked on continuously available database CAD2.3 which has 8 nodes in

cluster using Oracle 10.2.0.4 RAC based on Linux Intel Servers using SAN.

.Used Oracle Streams for performing data propagation between databases and

for replication.

.Involved in upgrading 20 instances of SQL server 2000 to SQL server 2005

in testing and production environment.

.Performed SQL Server backup and transaction log backup.

.Used Idera's Diagnostic Manager and performance monitor for monitoring SQL

server activities and keep a real time check on health, availability and

performance of SQL Server.

.Performed SQL tuning using SQL EXPERT and performance tuning using OEM.

.Responsible for implementing backup and recovery using RMAN.

.Extensively used SQL LOADER for data loading and ORACLE DATAPUMP for

importing and exporting data across databases.

.Performed installation of MYSQL database on two test machines for

developers.

.Performance monitoring and providing capacity planning using MySQL

Enterprise Monitor.

.Working knowledge of creating Virtual Private Database (VPD) to control

data access.

.Installed and configured Goldengate 10.4 for data replication.

.Planned GoldenGate setup to achieve Unidirectional and Bidirectional

replication.

.Prepared GoldenGate parameter files for Extraction and Replication.

.Tested initial Data Load option of GoldenGate during environment build.

.Investigated Goldengate Replication failures using LogDump utility.

.Worked on Goldengate software for zero-downtime migrations and upgrades.

.Responsible for analyzing Oracle security vulnerabilities by using

AppDetective scanning tool.

.Responsible for applying patches to RAC database system using OPATCH

utility.

.Analysed SQL queries for solving performance issues.

.Responsible for running test backups to make sure test recovery prior to

production.

.Worked on capacity planning according to data architecture handbook

guidelines and designed tablespaces and file systems with alarm thresholds

of 80 to 90 percent.

.Benchmarked applications prior to implementation to ensure performance as

per benchmarks set by CAD team.

Environment:Oracle10g/9i,MYSQL,Shareplex,OracleStreams,Goldengate,Embarcader

oDBArtisan,EmbarcaderoChangeManager,OracleSQLDeveloper,OracleEnterpriseManag

er,PowerDesignerDataArchitect,SQL*Loader,RedHatLinux,HPUX/AIX/SunSolaris,Ora

cleSQLBacktrack,Symphony/Sourceforge, SQL Server 2000/2005, SQL Server 2005

Management Studio.

Infovision Technologies Inc

Client: Lehman Brothers, NY

08/2007 - 04/2009

Oracle DBA

Lehman is a global financial-services firm that does business in investment

banking, equity and fixed-income sales, research and trading, investment

management, private equity, and private banking.

Responsibilities:

.Responsible for Oracle 11g/10g/9i, SQL Server2005 installation and

Configuration for GMDB project.

.Responsible for administering 45 very large Oracle10g/9i production

databases of size 100-500GB and 15 SQL 2000/2005 databases of sizes 50-

100GB

.Extensive experience in SQL Server 2005 mirroring, log shipping,

replication and SSIS package creation.

.Worked on SQL Server2005 cluster databases in an active-passive 2 node

cluster.

.Performed data conversion (tables, data mapping rules) from Sybase to

Oracle 10g.

.Used SwisSQL tool to perform migration from Sybase to Oracle10g.

.Extensive experience in supporting multiple production databases running

mission-critical/ OLTP applications demanding High Availability and

Increased Performance.

.Actively involved in installation and configuration of two-node active-

active Real Application Clusters (RAC) on RedHat Linux platform.

.Maintenance and performance tuning on a 10g RAC database.

.Hands on experience in refreshing database with export/import, RMAN.

.Applied security and daylight saving Patches using OPATCH utility.

.Used Shareplex to perform snapshot and multi master replication within

sites on RAC.

.Hands on experience of tablespace partitioning using various schemes like

Range, Hash, List and Composite range-hash partitioning.

.Experience in handling database security through roles, privileges, views,

profiles, audit and administering row level security through Virtual

Private Database (FGAC) technique.

.Performed statement auditing, privilege auditing and schema object

auditing.

.Worked extensively on database and operating system audit trails.

.Performed database server security through Kerberos security,

authentication servers.

.Performed migration from UNIX (Oracle) to Windows (MS SQL server) based

systems.

.Developed UNIX shell scripts for routine monitoring and statistics

collection tasks.

.Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER and AUTOSYS

tool to schedule tasks.

.Carried out Performance optimization and Query tuning using Statspack,

Tkprof and OEM.

.Performance optimization of large objects (LOB, BLOB, CLOB) by monitoring

redoes generation, increasing log buffer size, blocksize and changing

archiving procedures.

.Used Explain Plan for monitoring the query execution.

.Cloning of production database to the test environment using Recovery

Manager.

.Used Recovery Manager (RMAN) for various maintenance tasks like backup of

database, restore and recovery of database.

.Extraction of data from different flat files into Oracle Database using

SQL*Loader and automated the process by using UNIX Shell scripting.

.Performed SGA Instance tuning using instance parameters optimizer_mode and

optimizer_index_caching.

.Expert knowledge of Windows and Windows Security.

.SQL and PL/SQL Performance Tuning: Identified SQL and PL/SQL bottlenecks

using PL/SQL Profiler (package DBMS_PROFILER) and Auto trace.

.PIT Recovery of Database with various features like Log Miner, Flashback

Query, Mean Time to recover (MTTR).

.Troubleshoot database performance issues using Automated Workload

Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and ASH

statistics.

.Strong Knowledge of data modeling techniques and their CASE tools includes

Object-Role Modeling (ORM) and Object-Oriented (OO) techniques such as the

Unified Modeling Language (UML).

.Used import/export utility and Datapump utility to transfer data.

.Strong experience in creating and supporting Physical Standby using

DATAGUARD.

.Configured and maintained physical standby databases using Oracle

DATAGUARD to perform quick disaster recovery.

.Upgraded Oracle 9i to Oracle 10g using Database Upgrade Assistant (DBUA).

.Extensive use of Oracle 10g GridControl for maintaining many databases

together on separate servers.

.Strong knowledge of Oracle 10g new features Bigfile Tablespace, Flashback

and Oracle Streams.

.Wrote UNIX shell scripts to automate loading files into database, error

handling and notification.

.Used UNIX commands like VMSTAT, SAR, TOP, PS, WATCH, FREE, YAST, IOSTAT,

NETSTAT, AWK to monitor UNIX OS.

.Used Advisors like SQL Tuning, Segment, Undo from Advisor Central in OEM

for SQL tuning, Segment and Datafile shrinking in conjunction with AWR.

.Upgraded and patched Oracle binaries in the development environment and

production environment using Opatch utility

.Developed, documented and administered database policies and procedures.

Environment:

Oracle10g/9i,Foglight,QuestToadVer8.5,SQL*Loader,Windows2003/XP,RedHatLinux,

HPUX/AIX/SunSolaris,Erwin6.0,DataGuard,RAC,OEM,RMAN,Firstlogic,BMCSQLBackTra

ck,Datapump,OracleStreams,OpenVMS,Rational Clear Quest, Shareplex, SQL

Server 2005 Management Studio, Dataguard.

EDUCATION:

International Technological University, San Jose CA.

. MS in Computer Engineering (pursuing part time)

Syracuse University, NY

. MS in Electrical Engineering (2007)

Nagpur University, Nagpur India

. B.E in Industrial Electronics Engineering (2002)

Contact this candidate