93, ELMGROVE CRESENT, HARROW, MIDDLESEX, LONDON, HA12QT
CONTACT NUMBER: 0770-427-5827(C), 02083574128 (H)
EMAIL ID- REECHAMISHRA@GMAIL.COM
PROFESSIONAL PROFILE – LEAD DATABASE ADMINISTRATOR (ORACLE AND SQL SERVER)
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
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
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 : firstname.lastname@example.org : 0770-427-5827 1
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.
WORK EXPERIENCE DETAILS
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
Implemented DR solutions for very high visibility Applications by using Log shipping, database Mirroring
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
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 : email@example.com : 0770-427-5827 2
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 : firstname.lastname@example.org : 0770-427-5827 3
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.
ACHIEVEMENTS AND HONOURS
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 : email@example.com : 0770-427-5827 4