T. (703) 655 6931
Email: email@example.com; firstname.lastname@example.org
SUMMARY OF QUALIFICATIONS
More than nineteen years of professional IT experience out of which more than TWELVE years as a LEAD/Sr.
Oracle Database Administrator (DBA) and ORACLE GOLDENGATE ADMINISTRATOR on Multi-OS such as Sun
Solaris, HP-UX, IBM AIX, COMPAQ UNIX and Windows Server in 24x7 basis for Production, Development and Test
Environments on RAID level and involved in different roles viz. Production/Development/Application DBA for OLTP
and Data Warehouse environments. Experience in Database Administrations of SQL Server and SYBASE SERVER. I
have more than SEVEN years of experience as Data Architect/Data Analyst.
Installation and Configuration of Oracle Server 11gR2/R1, 10gR2/R1, 9iR2 in different operating systems for Very
Large Databases (VLDB) in OLTP & Data Warehouse environments. Implementation of Oracle 11gR1/10gR2 New
Features such as Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor, Flash Recovery Area,
Automatic Database Diagnostic Monitor (ADDM) and export/import Data Pump utilities of various type of Data Loads
and enhanced securities for HA database. Data loading using SQL*Loader direct and parallel options.
Configuration and Administration of GOLDENGATE v10.4 and GG Director for UNI/BI-DIRECTIONAL replication.
Configuration of GG Veridata v3.x for comparison between Source and Target after replicating the processes for
online Transaction Logs form Source DB to Target DB.. Configuration of Oracle Replication Server for Advanced
Multi-Master & Basic replication type in Oracle 9i/8i.
Experience working on Oracle 11gR2/R1 OEM Grid Control and OEM Console for the effective DB administration.
Administration of Oracle files using Automatic Storage Management (ASM) in a Storage Area Network (SAN).
RMAN configuration using Recovery Catalog/no-catalog running on ARCHIVE/NOARCHIVE and managing more than
100 plus instances. Restore and DB Cloning from RMAN new features.
Monitoring and optimising the Database Performances through Database Tuning such as AWR and ADDM, Tuning of
SGA and Memory, System Tuning, Application Tuning and SQL query plan using Explain Plan, Tkprof and prefstat.
Configuration and Administration of Oracle 10gR2 Real Application Cluster (RAC) environments for multi-nodes
based database by configuring Oracle registry, Oracle Clusterware and RAC. Working on Cluster Verification Utility
(CVU). Administering Oracle listener and server to & from cluster monitoring. Starting and stopping cluster monitoring
of the instance and listener thereby checking the status of Oracle cluster resources.
Implemented hot standby database (Data Guard) for production database. Setup and successfully performed active
fail over in the event of production failure. Creating, Maintaining and Supporting Physical standby databases.
Monitoring Redo Transport services, Log apply services and Role transitions. Handing issues with Network tuning for
Redo Data Transmission.
Configured Oracle Transparent Gateway between SQL Server and Oracle. Experience with Oracle Apps Server
DBA responsibilities such as supporting on 24X7, applying patches and troubleshooting etc.
Effective ways of writing stored procedures, functions, triggers and packages using PL/SQL. Writing UNIX Ksh shell
scripts for scheduling of jobs in Crontab for Database monitoring and PERL Scripting. Worked on Autosys for
scheduling and monitoring jobs. Used packages such as DBMS_JOB, UTL_FILE, DBMS_STATS, DBMS_SQL,
DBMS_REORG and DBMS_SCHEDULER.
Performed DB patching, cloning, troubleshooting issues/errors; collaborate with Oracle support for bugs and creating
TAR in METALINK. Designed SOPs, responsible for 21 CFR Part 11, SOX regulatory compliance audits.
Experience on Logical & Physical Designing of Databases using tools such as ErWin for effective Data Modelling for
DWH and OLAP systems satisfying Database Normalization. Experience in building Data warehouse environments
with Star Schema and SnowFlake Architecture.
Installations and Configurations of SQL Server v2000/7.0/6.5. Installations and Configurations of Sybase Adaptive
Server Enterprise (ASE) v12.5/11.x on UNIX and Windows. Performance tuning, client/server connectivity, query
optimization, back-up/recovery, running Database Consistency Checks and troubleshooting.
Installation and Configuration of Oracle 9iAS (Multi-tyre Architecture) deals with INTERNET and WEB technologies.
Worked on EMC Symetrix DMX, EMC CLARiON NAS devices, Hitachi, IBM, DMX SAN storage devices.
Maximum Database Sizes handle up to 20 TB. Mentoring Junior and Mid Level DBAs including Off-shore.
Resume of PRANAB MISHRA Page 1 of 8
Oracle GOLDENGATE Training from Oracle University. Supporting Oracle Corp customers for effective
implementation of GOLDENGATE replication.
Trained on 21 CFR Part 11, SOX regulatory compliance audits to support Pharmaceutical and Insurance companies.
Hardware: SUN Enterprise SunFire 480R UltraSparc III+, SunFire 280R UltraSparc III+ servers
E10K, 6500 & E4500, HP 9000 Servers, IBM Shark and Compaq 4100.
Operating Systems: SUN Solaris v10/9/8/6, HP-UX v11.x/10.x, AIX v.6.1/5.3/5.2, MS Windows
2K3/XP/2K/2K8, Red Hat LINUX, Digital OpenVMS v.7.3, Compaq Tru64 Unix.
RDBMS: Oracle 11gR2/R1, 10gR2/1, 9iR2, 8i viz. v8.1.x and 8 & 7.3.4, MS SQL Server
v2K5/2K/7.0/6.5, Sybase v12.5/12.0/11.x, IBM DB2 UDB etc.
GUIs & Languages: Oracle 10g/9iAS, Oracle 11g/10g/9i Client, Developer 9i/6i, Oracle 10g/9i
JDeveloper, iSQL*PLUS, PL/SQL, Java, JDBC, ESX Vmware 3.5, Oracle Fusion
Networking/Web Server: Oracle 9iAS, IBM Web Server, Apache Server (SSL), IIS, Web Portal etc.
Others: Recovery Manager (RMAN), OEM Grid Control, AWR, ADDM, SQL*LOADER, Data
Guard, Ksh Shell Scripting, TOAD v9/8/7, Exceed v7.x, BMC Patrol, Erwin v6.x, Data
Stage and Informatica, EMC (DMX, CLARiiON), HP/Hitachi (XP) storage, PVCS / CVS
Version Source Control, Clear Quest & Clear Case, ER Studio, etc.
JUNE ‘09 – December ‘10 COMCAST Cable, Philadelphia, PA
Sr. ORACLE DBA (OLTP/Data Warehouse) / GoldenGate Administrator
Installation, configuration and administration of Oracle 11gR2/R1 and 10gR2 High Availability databases for
Production, Development and QA on Sun Solaris v10, IBM AIX, Linux. Production Support of 600 users, 90 DBs each
of several TB, consisting of several hundreds of tables, partitioned some on 24X365. Involved in planning DB upgrade
from 10.2.0.4 to 184.108.40.206 using Migration Utility and implemented New Features and initialization parameter.
Installed/configured Golden Gate v10.4 replication in a Real Application Clustered Environment on Solaris v10.
Responsibilities include Running an Initial Load, Mapping and manipulating data, Customizing GG processing,
monitoring processes, managing the Oracle DDL replication environment and performing administrative processes,
Backup and recovery strategies of Oracle GoldenGate. Tuning of Oracle GoldenGate server for optimal
performances. Installation and configuration of the GG Veridata v.3.x for comparing objects between Source and
Target DB. Publishing the report on the web. Configuration of GoldenGate Director Server.
Configured Data Guard Broker using DGMGRL and Data Guard Manager GUI via EM Grid console to monitor and
manage physical/logical standby databases. Configured physical standby database for Maximum Availability
protection with fast-start failover using data guard broker on Solaris v.10. Configured Flashback Recovery Area for
all the 11g production databases. Monitoring Redo Transport services, Log apply services and Role transitions.
Configured 11gR1/10gR2 Enterprise Manager Grid Control for effective Database maintenance and monitoring.
Configured Templates, User Defined Metrics, Rules etc. for Alert generation and receiving EMAILS to DB monitor.
Also effective configuration, maintenance, and administration of Oracle Text
Configured 10g2RAC for two nodes with ASM/SAN storage on Red Hat Enterprise Linux Failover testing and
implementation of TAF Migration, Load balancing, Up-gradation and RAC database patching using rolling upgrades.
Responsible for performance tuning of corporate databases using tools such as Oracle Grid Control 11gR1, AWR,
ADDM, SQL Advisor, Quest Central, and Performance Analysis etc. Used Database Features like Mean time to
recovery (MTTR), Flashback Query, LogMiner etc, Replication for keeping database available always.
Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK reports and assisting the DB
developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
Designed, Configured and Implemented centralized database backup solution using 11gR1/R2 RMAN compression
Resume of PRANAB MISHRA Page 2 of 8
utility ZLIB algorithm over default BZIP2, Catalog database repository for 100+ databases. Database export and
import data pump utility for loading data into DWH environments.
Installation and Configuration of typical Fail Safe configuration and deployed in managing Unplanned group failover
and Planned failover. Efficiently managing Independent workloads and Load balancing.
DBA Support on Oracle Apps 10i Databases. Applying patches, DB Tuning, backup and restore etc. Unix Ksh
scripting for DBA and also reviewing/using PERL scripting for Administration automation.
Configuration and Administration of IBM UDB v9.7. Support for Oracle XML DBs on TEST and DEV environment.
Perform database Capacity Planning and growth projection by monitoring DB space and ensuring disk space
availability for various end-user applications accessing the database. DB size is >25TB and users are >600.
Environment: Oracle version 11gR1, 10gR2 Server on Sun OS 10, IBM AIX and Linux, TOAD v8/9 & ErWin for data
model design, MS Visio, SQL Developer, JAVA, Tivoli etc.
September ’08 – May ‘09 Kaiser Permanente, Pasadena, CA
Sr. ORACLE DBA/Data Architect (OLTP/Data Warehouse)
Installation and configuration of Oracle 11gR1 and 10gR2 databases for Production, Development and QA on Sun
Solaris v10 and IBM AIX meeting the SOX Compliance. Production Support on 24X365 basis for HA and MAA DBs.
Installation, Configuration and support of Oracle Real Application Cluster 11g/10g (RAC) for multiple nodes.
Monitored and administered and backing up RAC instances. Used the Oracle 10gR2 Flashback Query options such
as Flashback database for recovering the whole database to a point in time, Flashback table for restoring the state of
a table to a certain point in time and Flashback Drop.
Implemented Oracle 11gR2/1 New Features in Automatic Storage Management (ASM) for storage and administration
of Oracle files under SAN. Administered ASM Disk Groups and backed up ASM managed files. Other features such
as Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Secure Files, SQL
Access Advisor, SQL Performance Analyzer, SQL Plan Management, Statistics Collection Enhancements, Table
Compression Enhancements, Tablespace Encryption and Temporary Tablespace Enhancements and also init
Implemented Automated Oracle Tuning feature. Configured ADDM for bottleneck problems, memory related issues,
DB Configuration problems, Space related issues, application/SQL tuning issues etc. Used AWR snapshot reports for
ADDM to analyze data for performance bottlenecks. Implemented Oracle Automatic SQL Tuning procedure for
enabling SQL Tuning. Tuning of SGA, memory allocation and I/O Tuning such as reducing Disk I/O Contention.
Designed and Implemented database Cold and Hot backup strategy using RMAN. Database backup implementation
using EMC BCV and Veritas NetBackup. Export/Import of database using Data Pump Utility was configured.
Created and configured the Oracle Standby databases. Configured Data Guard for Physical, Logical and Active Data
Guard providing HA of DBs. Monitored DB growth and activities and Exception notification procedures thru Emails.
Database automation for Crontab script using UNIX ksh and Dynamic SQL scripts for administration purposes and
integrate data load scripts using SQL Loader. Administration of Oracle DB instances using OEM 10gR2 Grid Control.
Designed Dimensional data models (Snowflakes, Star Schemas), which consisted of both fact and dimension tables.
Maintained code tables, materialized views and fact tables being loaded on a daily basis from various sources.
Logical and Physical Database design using ERWin. Working with ETL tools such as Data Stage and Informatica for
Data masking to protect customer info and implemented Row-Internal Synchronization, Table-Internal
synchronization and table-to-table Synchronization and Encrypting the data by Nulling Out Or Deletion.
Used new database structures such as stored procedures, functions, triggers and packages, different type of Indexes,
materialized views etc. and AUDIT Trail. Implemented Oracle TEXT and crated indexes for HTML, XML documents.
Migration of Oracle 8i into 10g Database on Linux and Solaris OS for Development and Production DBs. Migration of
oracle 9i into 10g DBs on Multi-OS. Running the Post Migration Steps thereafter to Validate Data Integrity.
Used Oracle Advanced Queuing, to exchange messages and communicating between different application modules,
a client and the Oracle database server or between two Oracle databases. Working on Advanced Security features
such as Enqueues and Dequeues. Extensive experience on Table partitioning and maintenance of it. Expertise in
Implementation of Fine Grain Access Control (FGAC) for Oracle Data Encryption and Oracle Data Masking.
Applying Oracle Patches when/as required. Contacting Oracle Support using METALINK. Responsible for writing
SOP for the DB server implementation procedure and mentoring Junior DBAs includes Offshore in Europe and Asia.
Resume of PRANAB MISHRA Page 3 of 8
Working on Remedy ticketing tool to handle online queries of developers / users and resolving them remotely and
providing them solutions. Database size is >20TB and administered >80 DBs.
Configuration of Oracle Advanced Queues for effective security measures to ensure Customer data protection.
Implemented Secure Shell (SSH) tunnelling as a way of Oracle Network traffic.
Environment: Oracle version 11g, 10g, 9i (v9.2) Server on Sun OS 10 and IBM AIX v.6.1, LINUX. TOAD v8/9 & ErWin
v6.x for data model design, MS Visio, SQL Developer, JAVA and EMC BCV etc.
April ’06 – August ‘08 DEPARTMENT OF RECORDS (DOR), Philadelphia, PA
LEAD ORACLE DBA/Data Architect (OLTP/Data Warehouse)
Installation, configuration and administration of Oracle 10gR2/9i databases for Production (24X7), Development and
QA on environments such as Sun Solaris v10, IBM AIX v5.3 and Linux.
Configuration of ADDM for analyzing data in the Automatic Workload Repository (AWR) to identify potential
performance bottlenecks. Configured Automatic Storage Management (ASM) for effective storage and administration
of Oracle files, Configured ADDM for bottleneck problems, memory related issues, DB Configuration problems, Space
related issues, application/SQL tuning issues etc. Used AWR snapshot reports for ADDM to analyze data for
performance bottlenecks. Enables fine grained Auditing.
Administration of Oracle 10gR2 Real Application Cluster (RAC) based nodes. Configuration of 10G OEM Grid
Control to administer Production/Development Servers. Configuration of OEM GIRD 10gR2 for DB monitoring.
ONLINE HOT database backup of Production database followed by OFFLINE COLD backup of TEST and QA
databases mostly using RMAN. DB Cloning and restore from RMAN backup.
UNIX K-sh Shell Scripting mostly in order to achieve scheduled backups and data loading and Crontab jobs.
Implemented the scheduler in the production environment. Configured Veritas Netbackup v6.5 for Data Protection and
Disaster Recovery plan. Used Oracle Flashback Option for DB Recover. Supporting Oracle 10i Apps Server for
Development and Test environments.
Tuning of SQL structured queries, Database Tuning for improving database performance using STATSPACK, Hints
and Oracle Automated Tuning Procedure. Writing complex codes using Dynamic SQL. Designing and implementing
DW logical data model (ODS, Star/ Snowflakes Models). Worked on Informatica v8.6.
Used Materialized Views (snapshots) for replication of data. Worked on optimizing new and existing SQL queries by
creating indexes and materialized views. Managed Standby DB for disaster recovery, locally managed tablespaces,
Function Based Indexes, Global Temporary Table. Configuration and installation and support of OBIEE.
Validating Models created in ErWin and structuring DDLs according to the business/client requirements. Used
Advance Oracle features such as MERGE, Analytical function and dynamic SQL for the migration scripts.
Applying Oracle Patches and raised the issues/concerns creating TAR in METALINK.
The Geo Database was provided by ESRI. The Geo Databases in ArcGIS was stored in "ArcSDE Geo Database". It
was used for City of Philadelphia’s urban planning on SPATIAL Database.. Database size is 8 TB.
Environment: Oracle 10gR2, 9i on Sun OS 8/10 and Linux, IBM AIX v5.3 under SAN environment. OpenVMS, TOAD v8/7
& ErWin v6.x for data model and design & MS Visio, ArcGIS 9.2, ArcSDE, ArcView 3.x, Oracle Apps 11i, SAP etc.
July ’05 – March ‘06 BLUE CROSS BLUE SHIELD Inc., Providence, RI
Sr. ORACLE DBA (OLTP/Data Warehouse)
Installation and configuration of ORACLE 9.2.x for AIX 5.2 and Sun Solaris 8 according to OFA.
Database is running on ARCHIVELOG mode. Database backup mode is ONLINE HOT BACKUP. Export/Import of the
databases at users/table levels. Oracle9i/8i back up and restore/recover using Recovery Manager (RMAN) utility to
locate, back up, restore, and recover data files, control files, and archived logs. Planning Backup/Restoration Strategy,
Executing Shell Scripts using Corn jobs, Planning and scheduling Backups. Configure and Administration of OLAP DB
Data load using SQL*Loader across Oracle databases. Export and Import utility across the oracle DB instances.
Production Support on 24X7 bases. PL/SQL Debugging for SQL Tuning. Used Data Stage and Informatica.
UNIX Ksh scripting to accomplish several objectives according to the application requirement. Implemented the
scheduler in the Production environment. Dynamic PL/SQL Scripting and DD reconciliation.
Responsibilities includes logical and physical data modelling, data analysis and definitions, database design and
Resume of PRANAB MISHRA Page 4 of 8
engineering, database architecture/set-up, security, standards development and implementation, data modelling tools
evaluation, logical modelling consultation and advanced SQL and SQL constructs consultation and use, SQL and
PL/SQL coding and scripting, database programming specifications, functional specs and user requirements.
Designing and implementing DW logical data model (ODS, Star/ Snowflakes Models)
Performance tuning using STATSPACK and UTLSTAT reports, third party tools, Explain Plan and monitoring Alert
logs. Carry out Capacity planning; generate capacity reports to monitor space utilization, collecting and diagnosing
performance event traces like 10046, 10053 etc. Expertise in handling ORACLE INTERNAL ORA-600 and ORA-7445
issues. Reviewed the issues & incorporate assessment for UTF-8 character set for effective DB Administration.
Oracle Advanced Security features such as fine grained access control (FGAC), application context and global
application context. Role Based access control in accessing secured customer data. Secured Enhanced Auditing and
Database Risk management, Configuration of Oracle Data Masking out for Data Sensivity.
Worked on Oracle Streams and Data Guard in a Test and Development environment. Configured Oracle 9i Data
Guard for High Availability and Disaster Recovery. Administered for Data Protection for better performance and
Streams AQ scalability. Worked on Oracle Streams for Message Queuing, the Data Replication and Event
Management and Notification. Applying Oracle patches as and when released by Oracle Corp.
Worked on Informatica v8.6 for ETL purposes. Configuration of OWB for ETL for nightly data load. Using Mapping
Data Canvas for OWB design and SQL transformations.
Oracle SQL Tuning, Parallel queries, database tuning, OS tuning required for Oracle database in Production and
Development environment. Tools such as STATSPACK, Analyze etc. Database table partitioning. Working in a SAN
environment. Database size is 10TB.
Environment: Oracle v9.2/8i Server on IBM AIX v.5.2, Digital OpenVMS and Sun Solaris 8 on a Storage Area Network,
iSeries Based System. TOAD v8/7 & Erwin v6.x, Business Objects & MS Visio, JAVA, PeopleSoft and Cold Fusion.
January ‘04 – June ‘05 OFFICE OF EDUCATION AND TECHNOLOGY (KDE), Frankfort, KY
Sr. ORACLE DBA (OLTP and Data warehouse)
Installation and configuration of Oracle 9i and 8i databases on Multi-OS environment such as IBM v.5.2 and Windows
2K3/XP/2000 meeting the OFA standards. Administering and troubling shooting the database problem.
ONLINE HOT database backup of Production databases and OFFLINE COLD backup of TEST and QA databases.
Shell Scripting using Ksh mostly in order to achieve scheduled backups and data loading. Export and Import of
databases in different OS. Configured Oracle 9iAS Web Portal.
Tuning of SQL structured queries for improving database performance. Tools such as Analyze, SQL Trace, Hints,
STATSPACK etc. Writing complex codes using Dynamic SQL. DB modelling for OLAP environment and configured
following the guidelines.
Configuration of Oracle Transparent Gateway for data load from MS SQL Server 2000 into Oracle 9i database.
Configuration of Oracle Enterprise Manager (OEM) for administering Multi-OS based Oracle databases. Provide
assistance w/troubleshooting Oracle Database Gateway for Distributed Relational Database Architecture.
Administered SQL Server database. Configured OWB for Data warehouse DB and Data load from different sources.
Validating Models created in ErWin and structuring DDLs according to the business/client requirements.
Applying patches released by Oracle and raised the issues/concerns creating TAR in METALINK.
Installation and configuration of Oracle 9iAS Infrastructure portal database. Trouble shooting of any database
problems and applying Oracle patches as and when required. Working on Oracle Business Intelligence (OBIEE)
Working on Oracle Internet Directory based on LDAP based directory server. Administered LDAP directories by giving
access to LDAP users for accessing the databases. Using LDAP to pursue High Availability, better securities,
integration of multiple directories etc. Oracle Advanced Security and Audit trail of Databases.
Migration of Oracle 8i to Oracle 9iR2 on LINUX and IBM AIX.Database Size is 2TB.
Environment: Oracle 9i (v9.2)/8i Server on IBM AIX v.5.2. Oracle 9iAS on IBM AIX v.5.2 in SAN. TOAD v8/7 & ErWin v4.x
for data model and design, iSeries Based Systems, Oracle DWH Builder, PeopleSoft & MS Visio.
August ‘03 – December ‘03 PFIZER Inc., Kalamazoo, MI
Oracle Developer DBA/Data Architect
Resume of PRANAB MISHRA Page 5 of 8
Responsible for supporting application developers on best possible implementation of database schema/objects and
data integrity. Design and development of PL/SQL scripts for data extraction, data transformation and data migration.
Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and effective
management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
Installation and configuration of ORACLE 9i Release 2 on Sun Solaris v5.8 and HP-UX 11.x for Production,
Development and Test Environment according to OFA standard. Working on a database that meets the “HIPAA
regulations”. Production support of the databases on 24X365.
Oracle application tuning viz. EXPLAIN PLAN, ANALYZE, SQL Trace, HINTS etc. and optimisation for better
performance in Production environment. Provide assistance w/troubleshooting Oracle Database Gateway for
Distributed Relational Database Architecture.
Data loading using SQL*Loader across Oracle databases. Script writing in Ksh to accomplish several objectives
according to the application requirement. Physical and Logical database modelling using Erwin v4.x Data Modeler.
Database backup using RMAN for HOT online backup and scripts written for COLD offline backup. Database
availability is 24X7 bases. Database size is 6TB.
Federal and Adhoc Report generation using Oracle Reports and guiding the developers to incorporate the technology
for Crystal Reports v9/8. Experience using Dynamic SQL. Supporting the application written in PRO*C.
Environment: Oracle version 9i (v9.2) Server on Sun Solaris v5.8 in SAN. Tools such as TOAD v7.3 & ErWin v4.x for data
model and design & MS Visio.
October ‘02 – July ‘03 H & R BLOCK FINACIAL ADVISORS, Detroit, MI
Oracle Data warehouse Developer DBA
Installations and configurations of ORACLE v9.2/8.1.7 on Solaris v2.8..
Created a staging area and wrote PL/SQL scripts to automate the loads. SQL*Loader for loading data from standard
operating system files into Oracle database tables.
Installations of Oracle Designer 6I and creation of repository. Data load and working on ETL tools such as Informatica.
Performance tuning using UTLSTAT reports, third party tools, Explain Plan and monitoring Alert logs. Carry out
Capacity planning; generate capacity reports to monitor space utilization. Configurations of Oracle Replication Server
between two Production servers according to Optimal Flexible Architecture (OFA) on Production environment.
Tuning of Queries, Parallel queries, tuning of database before and after the completion of project and Database.
Development and optimisation of packages, procedures, functions, triggers in PL/SQL.
Oracle9i/8i RMAN backup for Production and Development Servers and restore/recover as and when required.
Tune the Data Warehouse Server for optimal performances. Data Migration to Solaris v2.8 based Oracle 220.127.116.11.0.
Database size was 7TB.
Responsibilities as Sybase DBA
Installation and Administration of Sybase Adaptive Server v12.5.
Database Backup Procedures, Restoration Procedures. Testing and implementing these procedures. Mirroring of
devices was done to recover important database due to suspect on primary DB or when primary DB was not loaded..
Proficient in Sybase SQL Server performance tuning, client/server connectivity, query optimization, back-up/recovery,
disaster recovery, running Database Consistency Checks and trouble shooting.
Manipulating system table data to solve time sensitive problems and optimize server performance. Controlling Access:
Granting and revoking permissions to users, groups and roles on various objects. Adding logins to the server, making
them users in particular or many DB. Locking the logins and restricting users. Enabling and disabling roles. Making
use of SA, SSO and OPER roles to secure the database. Working on Data Stage.
Configuring Parameters: Configured various parameters in Sybase Adaptive Server for more throughputs.
Environment: Oracle 9i v9.2/8i v18.104.22.168.0 Server on Sun Solaris v5.8/Windows 2k/NT server, Oracle Designer/Discoverer
6i for data modeling and designing. Data Stage.
March ‘01 – September ‘02 QUEST DIAGNOSTICS, NYC, NY
Oracle DBA/MS SQL Server DBA
Installation and configuration of ORACLE 9i v22.214.171.124/ v8.1.7 on Sun Solaris v5.8 and LINUX for Test Environment
according to OFA standard. Oracle Client Installation 9i/v126.96.36.199.0 and Oracle Developer 6i on Solaris and Windows.
Resume of PRANAB MISHRA Page 6 of 8
Export & Import of Databases from one server/schema to another server/schema. Export/Import of Partitions with
compressing the export/import databases.
Installations/Configurations of Oracle Parallel Server (OPS) according to OFA structure to administer multiple
instances that are connected to every single Online Transaction Processing (OLTP) databases.
Database Backup mode is RMAN for database operating mode is ARCHIVELOG / NOARCHIVELOG mode for 24X7
activities. The environment was configured using Veritas Net backup procedure.
Server Performance of Database. Tuning of SGA viz. Shared Pool by Tuning of Library Cache, Dictionary Cache, and
Buffer Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning
of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and
Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of
Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and
optimization. Production Support on 24X365 bases.
Choosing the appropriate RAID levels (chose RAID 0+5 striping with parity checking). The concept of separating
random data and indexes with traditional disks is no longer applicable using RAID striping.
Installing and administering Designer/2000 repository. Copying elements from one Repository to another.
Configuration/Installations of Oracle Enterprise Manager Console v2.04, Performance Pack, Diagnostic Pack and
Tuning Pack to monitor database activity and schedule routine jobs, and increase database performance to automate
the DBA activities on Production databases.
Data Modeling, Database Design and identifying entities, normalization/de-normalization, Table Design and
Functional Design using Erwin v4.x/3.x. ETL tools such as Informatica and DataStage.
Installation and configuration of Oracle 9i Application Server (9iAS) v188.8.131.52.1 to deliver Web content, Host Web
application and accessing Forms/Reports on the Internet/Intranet. Configuration of Oracle 9iAS for Enterprise Edition
viz. Oracle HTTP Server enabling SSL, Oracle9iAS Portal, Oracle9iAS Reports, Oracle 9iAS Discoverer, Oracle 9iAS
Forms Services, Oracle9iASWireless, Oracle9iAS Web Cache, Oracle 9iAS Database Cache, Oracle Internet File
System for running transactional applications. The Lightweight Directory Access Protocol (LDAP) for accessing online
directory services. It runs directly over TCP, and is used by nearly all X.500 directory clients that are in widespread
use. This page contains pointers to many of the available LDAP clients. It is organized by platform.
The system is designed to support Replication and Multi-Mater Replication applied. Implementing version control on
an application system and freezing previous versions.
Responsible for System Design, Templates, Object Libraries and PL/SQL Libraries, develop program using Oracle
forms & reports, Oracle Workflow Builder, Oracle Mail, File Upload, PJC, PL/SQL Packages, Triggers, Schema
Management, Replication & Testing, Database size was 6TB.
Responsibilities as MS SQL Server DBA:
Installation and Administration of MS SQL Server v2000. Database design, creation of user Databases, Installation of
MS SQL Clients. Use SSIS to transfer millions of rows of data to and from heterogeneous data sources.
Using DTS for import/export and transform data in support of tasks such as data consolidation, archiving, and
analysis, FTP task, the Execute Package task, the Dynamic Properties task, and the Message Queue task.
Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
Performance monitoring and tuning of SQL servers.
Designing and Implementing the Filters that can be applied in different modules based on the individual requirements
of the modules, which helps the users in restricting or browsing through the Data, they actually require
Environment: Oracle Server 8i v184.108.40.206.5 on Solaris 6 and HP-UX 11.x in SAN, Windows 2000/NT v4.0 (SP6), Oracle
Apps v11i. Client machines are Windows NT workstation v4.x. IBM DB2.
March ’00 - February ’01 Bell Atlantic (Now VERIZON), Arlington, VA
Oracle Developer DBA
Installations and configurations of ORACLE 8I viz. v220.127.116.11.0 (Production Server) on Solaris/HP-UX v11.x
Configurations of it according to ExpressTrak Application that met MARIMBA requirement
Installations/configuration of Oracle Developer/2000 (Forms and Reports 6i) on Windows NT 4.x Server. Installations
of Report Server (v.18.104.22.168.1) to publish the reports on the web on each one-hour time frame.
Migration of Windows NT based Oracle Server v8.0.5 to HP-UX/Sun Solaris based Oracle v8.1.5.
Database is running on ARCHIVELOG mode and availability is 24X7. Database backup mode is ONLINE HOT
Resume of PRANAB MISHRA Page 7 of 8
BACKUP. Export/Import of the databases at user/table level. Oracle8i back up and restore/recover using Recovery
Manager (RMAN) utility to locate, back up, restore, and recover data files, control files, and archived logs.
Installations of Oracle Designer 6I and creation of repository. Installations and Configuration of Oracle Application
Server (OAS) 4.0.x, Web DB, Oracle JServer. Installations/Configurations of Oracle Parallel Server (OPS) according
to OFA structure.
Configurations of Oracle Replication Server between two Production servers according to Optimal Flexible
Architecture (OFA) on Production environment.
Contacting Oracle for Patch demands and Problem resolution and Creation of TAR in Oracle METALINK. Database
Size is more than 10TB consisting of 10 Databases.
Environment: Oracle Server 8i v8.1.5 and Oracle Apps v11i on Sun Solaris v5.6 & HP-UX v11.x in SAN, Visual Java
v2.x. The Client machines are Windows NT workstation version 4.x. The Utilities includes Erwin v3.5, TOAD v7.x & SQL*
LAB to administer the Databases.
June '99 – February ‘00 MCI WORLDCOM, VIENNA, VA
Oracle DBA / Sybase DBA
Installation and configuration of ORACLE v8.0.5 and Database Creation. Space Management, Security Policies,
managing users and profiles, Creation of Roles. Monitoring of Database storage and user activities.
Responsible for database Backups (ONLINE) using backup scripts. Database mode is ARCHIVELOG. Recovery of
Database in the event of crash or corruption. Oracle7 back up and restore/recover using Enterprise Backup Utility
(EBU) utility to locate, back up, restore, and recover data files, control files, and archived logs for Oracle v7.3.4 DB.
Database Server Performance, Tuning of Shared Pool by Tuning of Library Cache, Dictionary Cache, and Buffer
Cache, Tuning of OS by Reducing Paging/Swapping, Tuning of SGA and Tuning of memory allocation. Tuning of I/O,
which includes Separating of Data files and Redo log, files on different location, Striping of table data, and Separating
of tables and indexes on different locations? Reducing Disk I/O Contention etc. Applications tuning using HINTS,
EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE etc.
Client/Server Connectivity by SQL*Net. Export & Import of Databases from one server/ schema to another
server/schema. Export/Import of Partitions with Compress. Database Size is more than 4TB consisting of 10 DBs.
Setting up various DBA notifications like email, page in case of database unavailability, server unavailability, filling up
of any directory to its maximum capacity. Various notifications are also set through BMC patrol that constantly
monitors the database for different parameters.
Generating Erwin Metamodel to create data dictionary which stores information about data structures used in Erwin
models. Use of Erwin for ODBC software to access the Database.
Environment: Oracle 8.0.5/7.3.4 SERVER on SUN SOLARIS v5.6, HP-UX v10.x and Developer/2000, Visual Basic on
Win NT workstation and Window based client.
Sept ‘92 to May '99 Victor Computers Private Limited, India
Role: Network Administrator/ MS SQL Server Developer/DBA
Responsibilities includes logical and physical data modelling, data analysis and definitions, database design and
engineering, database architecture/set-up, security, standards development and implementation, data modelling tools
evaluation, logical modelling consultation and advanced SQL and SQL constructs consultation and use, SQL and
PL/SQL coding and scripting, database programming specifications, functional specs and user requirements,
mentoring developers and users.
Conversion and optimisation of customer Data from a stand-alone NT SQL Server v6.5 environment to a production
system in Oracle on AIX running on data centre. Configured TCP/IP protocol and administered Novel Netware and
Windows NT Networked configured systems on a large scale basis. Configured Department of Indian Post and
Telegraph computers and networked for effective delivery Postal department mails in Eastern Indian region.
Logical and physical data modelling and SQL programming for design and build of software and conversions for
additional database functionality and additional programming for aligning sales to multiple contract purchasing
memberships. Designed and built user flat file upload process from Novell server into UNIX via UNIX scripting, FTP,
SQL*Loader and PL/SQL into Oracle database.
Bachelors of Engineering (B.E.) in Computer Science and Engineering.
Management in Business Administration
Resume of PRANAB MISHRA Page 8 of 8