Docstoc

PRANAB MISHRA

Document Sample
PRANAB MISHRA Powered By Docstoc
					                                              PRANAB MISHRA
                                              T. (703) 655 6931
                           Email: pranabmishra@hotmail.com; pranabpmishra@gmail.com

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
TRAINING

   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.

TECHNICAL SKILLS

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
                                    Middleware etc.
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.
PROFESSIONAL EXPERIENCES

JUNE ‘09 – December ‘10                                                            COMCAST Cable, Philadelphia, PA
Sr. ORACLE DBA (OLTP/Data Warehouse) / GoldenGate Administrator

Achievements
 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 11.1.0.6 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)
Achievements
 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
     parameter.
 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)
Achievements
 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)
Achievements
 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)
Achievements:
 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
Achievements:



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
Achievements:
 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 8.1.7.3.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 v8.1.7.3.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
Achievements:
 Installation and configuration of ORACLE 9i v9.0.1.1/ v8.1.7 on Sun Solaris v5.8 and LINUX for Test Environment
    according to OFA standard. Oracle Client Installation 9i/v8.1.7.0.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) v1.0.2.2.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 v8.1.7.1.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
Achievements:
 Installations and configurations of ORACLE 8I viz. v8.1.5.0.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.6.0.8.10.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
Achievements:
 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
Achievements:
 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.
     EDUCATION
     Bachelors of Engineering (B.E.) in Computer Science and Engineering.
     Management in Business Administration



Resume of PRANAB MISHRA                                                                                  Page 8 of 8

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:47
posted:1/11/2012
language:English
pages:8