Progress DBA
Resume:
Pournima V. Ahire
Email Id : **************@*****.***
Contact no. : +919*********
Certification
•Oracle Database SQL Expert Certified
•PKS Certification for Technical Implementation - Enterprise Edition
Educational Qualifications
EXAMINATION
COLLEGE / SCHOOL
YEAR OF PASSING
PERCENTAGE
EXTC(BE)
Atharva College of Engg.
2014
68.19
HSC (Sci.)
Maharashtra Board
2010
72.33
SSC
Maharashtra Board
2008
93.07
Programming Knowledge
Databases
Progress OpenEdge databases 9.1 & above
Languages
Sql, Basics of C++, JAVA
Operating systems
Linux(Centos), Windows XP/7/8, UNIX
Progress OpenEdge Skills
( DBA )
OpenEdge (AI, OERP, Auditing,Performance Tuning, Upgradation, Security, ODBC/JDBC, Dump/Loads,Administration and Scripting)
QAD Technical Skills
( App Admin )
SE, EE, YAB, QXtend, MSW/PSW, EAM, Alerts
Technical Skill Set
•Strong knowledge on Progress database administration tasks in all versions of progress and performance tuning of Progress Server databases.
•Strong technical, installation & upgradation experience in the QAD Standard Edition, Enterprise Edition, YAB 2015 EE & 2016 EE and add-on modules of QAD like Qxtend, EAM, MSW/PSW, Internationalization etc.
•Extensive experience in working with Progress support team, raising service requests and driving them to closure.
•Performance tuning and monitoring including statistical analysis, resource utilization management and error/event log monitoring.
•Good Understanding of structural query language(SQL)
•DML and DDL, DTL, DCL Statements of SQL.
•Design and creation of database, managing users and profiles.
•Understanding of Triggers, views, Events.
•Hands on experience on Linux commands.
•Knowledge about QAD application.
•Knowledge of Progress Database Architecture/Components.
•Schema - Database - Tables - fields – Indexes
•Dump load of .d (data table), .df (Structure file) on customer environment.
•Progress Installation - UNIX.
•Creating and deleting a database.
•Starting up and shutting down a database.
•Backup and Restore of database
•Ubroker Components (Adminserver, NameServer, Appserver,Webpseed) introduction and commonly performed operations like Startup, Shutdown, Query, Trim etc
•Introduction to OE Replication.
•BI Monitoring and Maintenance.
•Crash Recovery, AI-Image Roll Forward Recovery.
•Excellent communication, interpersonal and customer handling skills.
Work Experience :
Currently working with Tata Consultancy Services as I.T analyst joined form 17th April 2019 till now.
Worked for client Adient India Pvt Ltd as a Progress DBA from Blue chip computer consultants Pvt Ltd . (Joined from 17th July 2017 till 8th April 2019)
Worked with QAD India Pvt Ltd. at the position of Associate Technical Consultant since July 1st 2015 to present. (6 months of Internship at QAD from 1st Jan to 30th June 2015) till 10th July 2017.
Tasks and Responsibilities Handled : Installation, Configuration, Administration and Troubleshooting of QAD Core Products, QAD Add-On Products and Progress OpenEdge RDBMS
•Administration of Progress/OpenEdge 9.1,10.xx and 11.xx databases.
•Trouble shooting and identifying root cause for fixing the production problems.
•Installation and upgradation of Progress OpenEdge.
•Performance analysis to improve the performance of the database.
•Handling QAD applications (SE and EE) and progress database related issues and interaction with client.
•Installing, upgrading, configuration and troubleshooting of add on products like QAD Alerts, MSWPSW, EAM, QXtend.
•To configure and troubleshoot QAD Interoperability – QXtend Inbound and Outbound.
•Working on Linux Red Hat OS on daily basis, resolving file system issues, zombie PID, Load related issues, File system.
•Installation of Enterprise Financial patches and .NETUI Cumulative patches.
•Installation of OpenEdge database service pack, patches and hot fix.
•Automating the tasks by creating the batches for QAD application programs.
•Working on non-critical as well as system down issues for cloud customers.
•Day to Day activities to carry out database refresh and perform online / offline backup for cloud customers.
•Worked on Icinga monitoring tool to monitor the cloud customer databases & application services.
•Monitoring customer systems through the web interface and taking necessary preventive/corrective actions for avoiding the system down situations.
•Creating knowledgebase articles for issues reported with the resolution or fix provided.
•Working closely with other teams across QAD (including QAD R&D) for installation, configuration and troubleshooting of various products.
•Worked on YAB based cloud customer environments to perform day to day activities.
•Performing upgrades and add on product installation on YAB based environments.
•Enabled Enhanced controls on SE EE and YAB managed environments.
Interest and Hobbies
•Dancing and Singing
Personal Information
Name
Pournima Vijaykumar Ahire
Date Of Birth
11th October 1992
Contact number
Email Id
**************@*****.***
Gender
Female
Nationality
Indian
Languages
English, Hindi, Marathi
Contact this candidate