Document Sample
REECHA MISHRA - Amazon S3 Powered By Docstoc
					                                             REECHA MISHRA
                              CONTACT NUMBER: 0770-427-5827(C), 02083574128 (H)
                                  EMAIL ID- REECHAMISHRA@GMAIL.COM


   Seasoned technology professional with over 9 years of DBA experience, on SQL Server 2005/2008 ;Oracle
    10g/11g, and Oracle EBS (R11i) at organizations like Microsoft and Teradata Corporation, across India &
   Over 4 years of database design experience involving data requirements, classification, logical & physical data
    model creation
   Analytical and results driven Senior DBA with long term experience in engineering, implementing and
    supporting disaster recovery and high availability plans and solutions based on Oracle software.
   Resourceful individual with problem solving capabilities, excellent communication and team leadership skills

Bachelor of Computer Science (1999-2002) from Barkatullah University, Bhopal, India (NARIC Certified)


   Oracle Certified Professional Oracle 9i DBA
   Oracle Apps R12 i System Administrators Course from Oracle Training Center.
   Microsoft Internal certification on SQL Server 2005
   Microsoft Certified DBA in SQL Server 2000


Database Administration
    All aspects of SQL Server 2000/2005/2008 and Oracle 10g database administration including planning,
       installation, configuration, backup, recovery, security, data manipulation, SSIS,SSRS,DTS and disaster
       recovery to 3rd level.
    SME on Replication, Clustering, SSIS and Performance tuning of SQL environments.
    RAC administration, Storage planning and data movement are key expertise area in Oracle Environments.
    Worked on High transactional environments and successfully completed upgrades and migrations for low
       downtime through all different versions of SQL server and Oracle.
    I have fairly well knowledge of few front end languages like C#.Net, VB, C++, C and Java.
    Programming Languages: SQL, PL/SQL, Perl, Shell scripting
    6+ years of experience in administrations of IIS webservers.
    7+ years of experience in Unix, Solaris, Linux Operating systems.
    9 years of experience in Active Directories Services.
    5+ years of experience in shell scripting(limited to DBA use)
    7 years of experience in Replication, Log shipping , backup Recovery and database mirroring solutions for
    9 Years of experience in designing, coding, troubleshooting and implementing SSIS packages (DTS)
    7 years of experience in handling large and high volume transactional Oracle database servers.
    5 years of experience in handling RAC environments

Professional Profile         :                    : 0770-427-5827             1
Reecha Mishra

       5 years of experience in Oracle Apps R11i E-Business suit (Installation, Patching, Cloning and
        troubleshooting DB and Mid-Tier issues)
       6 years of experience in working for clients in UK, US and Australia, EMEA region.
       Worked on Database Tools like Quest SQLab, SQL Expert, Quest TOAD, TOAD DBA Edition, Quest SQL
        Navigator, Oracle Enterprise Manager, Redgate SQL monitoring tools.


Teradata Corporation (Earlier, part of NCR) Gurgaon (From July ‘06 – Till March 2011)

Sr. DBA: SQL Server 2000/2005 and 2008--- Oracle 9i/10g/11g and Oracle Apps(11i) DBA
The DBA team within ITS division of Teradata supports all internal applications, which helps in smooth processing
of other divisions like Law, Teradata sales and realization, Payroll and HR. I was also responsible for major
upgrade and migrations of db servers from 1 platform to another.

Role : Senior DBA with a team of 7 production DBAs supporting distributed mission critical databases
Databases/ Applications: SQL Server 2000/2005/2008; Oracle 10g, Oracle EBS (11i),
Environments: Windows Server 2000/2003, Linux, Solaris
Tools: Quest Toad for SQL Server XPert, Hybrid SQL SPY, Idera SQL Diagnostic Manager, Idera SQLCheck; Toad

Summary of projects and tasks
SQL Server
       Implemented DR solutions for very high visibility Applications by using Log shipping, database Mirroring
        and Replication.
       As a release manager, worked on releasing patches to Dev, Test and finally Production Servers
       Created and Managed backup plans (used Netbackup for backups) for all SQL server databases (150 + DB
       Designed and Implemented database security plan on a critical database which was accessed through a
        customer portal with 2 firewalls.
       Dealt and negotiated with third party vendors who support the applications for our databases.
       Extensive work on High transactional environments on SQL server responsible for Sales, Payroll and
        Invoicing Applications.
       Defined and enforced database standards, policies, security and documentation.
       Prepared database structure and configuration plans for high-performance Lead database troubleshooting
        using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to
        resolve critical database issues.
       Actively involved in monitoring database systems performance, capacity and availability.
       Deployment, configuration and monitoring of complex ETL/SSIS processes.
       Worked on storage issues with SAN and NAS devices.
Oracle & Oracle Apps
       Implementation and support of Oracle standby databases. Implementation and support of backup
        strategies, providing database consulting and engineering to development teams within company, creating
        custom SQL scripts, database monitoring and backup scripts, database performance tuning, writing
        support and training documentation and investigating new database related technologies for use within
       Installation, upgrades, migrations, performance tuning, backup and recovery, schema management, SQL
        tuning, proactive monitoring and troubleshooting Oracle databases in a 7x24 environment.
       Responsible for applying CPU patch every quarter on oracle databases.

Professional Profile          :                   : 0770-427-5827            2
Reecha Mishra

       I worked on high end RAC environment and also designed DR solutions using NAS storage devices.
       DB monitoring using Oracle Enterprise Manager & Oracle Grid
       RMAN Backup/Recovery procedure for Oracle database including Hot and Cold Backup
       Performance tuning the database based on Application needs.
       Scheduling of Cron jobs for Linux and solaris environments
       Implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases,
        including RAC (Real Application Cluster).
       Support includes routine DBA tasks such as backup and recovery of full and partial databases using
        RMAN/NetBackup, performance tuning of SQL and PL/SQL code, system and database performance
        tuning of shared database environments.
       Supported NCR’s 3.8 terabyte single global 11.5.10 Oracle ERP production database on Oracle RAC in a
        four node architecture with Veritas 4.1 clusterware on Sun Sparc servers . The system has over 1000
        concurrent users and executes 700,000 concurrent jobs weekly.

Microsoft R&D India (From Jun ‘05 – June’06)

SQL Server Quick Fix Engineer (SQL Server 2000 and 2005 Live Support)
The R&D department within Microsoft India takes care of the maintenance and support of the implementations of
SQL server databases at corporate sites in US & Canada. A key objective of the work related to the effectiveness and
efficiency of the support catered to our clients.

Role : Senior SQL Server Quick Fix Engineer & SME on Transactional Replication
Databases: SQL Server 2000/2005;
Environments: Windows Server 2000/2003,
Summary of projects and tasks
As a member of India based research & development team, my role required me to:-
     Analyze problems and develop solutions to meet customer needs; including writing code.
     Learn pre-release products in area(s) of support so as to support them when released
     Write technical articles and sample programs for Microsoft's knowledge base
     Communicate with corporate customers, written correspondence, or electronic service regarding problems
        identified in Microsoft SQL Server software
     Participate in daily triage meetings to share knowledge and develop efficient customer solutions.
     Identify and report both software bugs and customer suggestions.
     Learn entire product or product family supported and continually improve personal knowledge and skills.
As apart of my role described above, I was required to make use of my expertise in following area:
     SQL 2005 Data Integration, SSIS specialty handling issues related to SQL Server Integration Services (SSIS),
        connectivity, & security
     SQL Data Integration, & replication: Transactional, snapshot, merge, peer to peer, web sync, CE / mobile,
        Oracle publishing, RMO programming
     SQL Server 2005 32-bit & 64-bit Editions: Enterprise, Standard, Workgroup, Developer, Evaluation, Express
     Microsoft SQL Server 2000 Notification Services, Microsoft SQL Server 2005 Notification Services
     Cluster Setup and maintenance. (multimode and geographically separated nodes)
     Network issues with windows 2003 professional edition, active directory services and authentication

NIIT Ltd. (From March ‘05 – May ‘05)
Technical Consultant and Corporate trainer

Professional Profile           :                    : 0770-427-5827            3
Reecha Mishra

       Handled numerous training programs for Corporate RDBMS Training on MS SQL SERVER and ORACLE
        databases. Also provided Certification training for SQL and Oracle tracks.

Cyber Infodev Pvt Ltd. (From Jan ‘02 – Mar ‘05)
Consultant DBA, Multiple e-Governance projects for Government of India
       Designed, Implemented & Supported a package of 16 applications in live environment for an exceptionally high
        visibility project of Indian Government.


       Excellence award for Partner Intelligence Application 2010
       Certificate of Appreciation for Project ECMS 2007: NCR Corporation
       Star Performer Award, January 2006: Microsoft Corporation
       Multiple Spot Excellence Awards, 2005: Microsoft Corporation
       Recommendation for Outstanding Client Support, 2005: NIIT Ltd.
       Received 3 promotions in 3 years for consistent performance: Cyber Infodev Pvt. Ltd.

Professional Profile           :                    : 0770-427-5827            4

Shared By: