Teradata DBA
Resume:
AJENDRA DUBEY
Ph: 996-***-****
***.*******@*****.***
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
***.*******@*****.***
Contact Number
Passport No.
P5292895
Valid Up to: 24 Nov 2026
Contact this candidate