AJENDRA DUBEY

Ph: 996-***-****

aczmy7@r.postjobfree.com

Professional Summary

I have 8 year of experience in Database Administration.

I have strong troubleshooting/logical abilities to identify organizational needs meet corporate goals and undertake full responsibility for delivering solutions that meets Customer’s expectations/requirements.

Education

Degree

University

Yr of Passing

MBA (Finance)

IASE Deemed University Rajasthan

2014

B.E(Information Technology)

RGPV Madhya Pradesh

2008

Experience

Organization

Designation

Duration

Teradata India Pvt. Ltd.

Senior Technical Consultant

Feb 2015-till date

Polaris

Team Lead

June 2013-Feb 2015

Rolta India Limited

Executive

Apr 2011-May 2013

AntiClock Softwares

Sr DBA

Mar 2009-Feb 2011

Technical Skills

Operating Systems

Windows NT, 9x, 2000, XP, Linux, HP-UX, Solaris,Suse Linux

Languages

SQL, PL/SQL,PG/PSQL, Shell Scripting

Databases

Teradata 14.10, 15.00, Oracle 8i/9i/10g/11g, PostgreSQL/PostGIS

Tools & Utilities

DSA, BTEQ, TASM, VIEWPOINT, Export/Import, Recovery Manager (RMAN), SQL Developer

Trainings

Sno

Title

Location

Organized by

Duration

1

GIS

Mumbai

Rolta India Limited

15 Days

2

RDBMS

Lucknow

AntiClock Softwares.

3 Weeks

3

SQL, PLSQL

Lucknow

AntiClock Softwares.

2 Weeks

4

Oracle-DBA

Lucknow

AntiClock Softwares.

8 Weeks

5

Teradata Factory Training

Pune

Teradata India Pvt. Limited

2 Weeks

6

Teradata Performance Optimization Through Physical Design

Pune

Teradata India Pvt. Limited

1 Week

7

Teradata Performance Optimization Through Workload Management

Pune

Teradata India Pvt. Limited

1 Week

8

Netbackup

Mumbai

Teradata India Pvt. Limited

1 Week

9

Teradata Backup - DSA

Mumbai

Teradata India Pvt. Limited

1 Week

Certification & Awards

Teradata 14 Basic.

Teradata 14 SQL Certification.

Oracle Introduction to SQL.

GDC Employee of the Quarter Award 2016

AWS Business Professional Accreditation.

AWS Technical Professional Accreditation.

Teradata DBA Skills

Teradata 14 Database Certified Professional.

Experience in 24*7 Production Support environment

Create and manage Database Objects.

Backup and Restore using DSA,ARCMAIN and ABU backup utilities.

Experience in Teradata Active System Management (TASM).

Experience in Performance & Tuning.

Experience in Datalabs Creation and Administration

Experience in Viewpoint Administration and Monitoring.

Prepare plan for various DBA activities like database upgrade, data migration.

Resolve issues related to backup/Restore(DSA, ARCMAIN, etc).

Prepare Database Operations & Performance reports.

Worked on various database performance tuning activities (like statistics, MVC, etc.).

Worked on Partition Management

Worked on Space Management

Projects in Teradata

Client

Large Ireland Bank

Role

Teradata DBA-Consultant

Duration

Mar 2015-Till date

Team Size

6

Environment

(with skill versions)

Database :

Teradata 14.10

O/s :

Suse Linux

Contribution-

Lead the Teradata DBA Team.

Provide 24*7 Teradata DBA Support (including Active and On-Call support).

Developed backup solution using shell script.

Understand Client Requirements and resolve the issues.

Prepare plan for various DBA activities like database upgrade, data migration.

Resolve issues related to backup/Restore (DSA, ARCMAIN, etc).

Prepare Database Performance reports.

Worked on various database performance tuning activities (like statictics, MVC, etc.).

Recommend various value additions for Teradata Database to improve performance.

Recommend purge process to manage space in Prod & Preprod Database.

Client

Large German Automobile Company

Role

Teradata DBA-Consultant

Duration

Mar 2015-Till date

Team Size

4

Environment

(with skill versions)

Database :

Teradata 14.10

O/s :

Suse Linux

Contribution-

Providing 24 X 7 production support for client database.

Enable encryption at CLI and ODBC level.

Understand Client Requirements and resolve the issues.

Prepare KEDB for many day-to-day activities like unix user creation, enable encryption, etc.

Resolve issues related to backup/Restore (ABU).

Provide L1 support for GCFR jobs.

Initiated roles and rights clean-up activity to make Teradata Database stable.

Provide various suggestions to client for database performance and tuning.

Worked on Data labs creation and setup.

Projects in Previous Organization

1.Large German Bank (Mar 2014 to Feb 2015). Ajendra has been a part of the Corporate Investment Banking (CIB) project in which the scope was to provide 24*7 production support to Client Production Database. The project involved extensive knowledge of Oracle DBA work.

2.Large Indian Bank (Feb 2014 to Mar 2014). Ajendra has been a part of the Treasury project in which the scope was to setup Disaster Recovery site at Client datacenter.

3.Large American Bank (Oct 2013 to Jan 2014). Ajendra was a part of the Performance & Tuning of Oracle Database. Ajendra was a Technical Lead in this Project and this project deals with the Database Performance & Tuning of all databases from various regions like NA (America), EMEA (Europe), ASIA and INDIA.

4.Large American Bank (June 2013 to Sep 2014). Ajendra has been a part of Oracle Database Upgrade project with a large US based Bank. This project deals with the Oracle 11gR1 upgrade to 11gR2 for almost about 15-20 databases from various regions like NA (America), EMEA (Europe), ASIA and INDIA including development, SIT (System Integration Testing), UAT (User Acceptance Testing) and Production Databases.

5.Image Management Server (Dec 2012 to May 2013). Image Management Solution is required by Large Indian Organization for various nodes which need instantaneous access to HQ data, as they are observing neighboring harbors and shorelines and also there is a need to mitigate hostile actions and act instantaneously to provide relief in case of disasters / natural calamities.

6.KUM (July 2012 to Nov 2012). Constituted under the aegis of the Commerce & Industries Department, KUM is an initiative from the State to promote and facilitate investments, and assist investors. KUM is a single contact point for all investors who are looking at setting up businesses in State.

7.Network Analysis (May 2012 to June 2012). Network Analysis is a technique used to find the shortest path between two different points from available road network. Ajendra has been involved in creating or develop functionalities using Postgis Database to get the shortest path.

8.Mapfinisher Database Customization Tool (Feb 2012 to Apr 2012). Ajendra has been involved in Customization of existing GIS tool by implementing various Database GIS functionalities in the tool for various GIS functionalities.

Previous Employment

Company

Duration

Role

Polaris

03 JUN 2013 – 13 FEB 2015

Oracle DBA

Rolta India Limited

12 APR 2011 – 31 MAY 2013

Oracle DBA

AntiClock Softwares

01 MAR 2009 – 28 FEB 2011

Oracle DBA

Personal Details

Name

Ajendra Dubey

Email Id

aczmy7@r.postjobfree.com

Contact Number

996-***-****

Passport No.

P5292895

Valid Up to: 24 Nov 2026

Contact this candidate