Sushant More
Email.ID: *******.*****@*****.***
Mob.No: +91-992*******
CAREER OBJECTIVE:
My objective goal is make a significant contribution in an environment, which provides opportunities for professional growth and increased responsibility. More importantly in a team to bring forth the best from everyone and myself.
PROFESSIONAL SUMMARY:
Over 6.9 years of experience in Sybase Database Administration.
Presently associated with SAP on payroll of Optizm as Senior Sybase database administrator since May 2017.
Previously worked with SAP on payroll of Talentpro as Sybase Database Administrator for 1 year.
Worked with Sungard as Sybase Database Administrator for 1.5 years.
Also worked with Softenger India Pvt Ltd deputed to client site SAP India Pvt. Ltd,Pune (earlier called as Sybase Professional Services) as Sybase Database Administrator for 3.2 years
Worked in the core areas in Adaptive Server (ASE ) installation, configuration, upgradation, troubleshooting production servers, performance and tuning, monitoring, running consistency checks and other maintenance tasks.
Worked in the core areas in Replication Server installation, configuration, table level, WS and MSA setups, troubleshooting and monitoring.
Hands on Sybase IQ monitoring and management.
Management of 500+ servers with database size ranges from Terabytes to Gigabytes.
Working as shared resource to help my team to also resolve the system admin issues.
Team player with strong analytical & organizational skills and problem solving capabilities.
Experience in detail:
Company
Location
Start date
End date
Total years
Softenger India
Pune
Nov- 2011
Jan - 2014
3.2 years
Sungard
Pune
Jan -2014
May -2015
1.5 Years
Talentpro
Pune
May-2015
May-2016
1 year
Optizm
Pune
May-2016
Currently working
1.4 year
ACADEMIC QUALIFICATION:
Course
Institution
Board
Year of Passing
Percentage B.Tech (IT)
Pimpri Chinchwad college of engineering
Pune University
2011
60.00
H.S.C
Jai hind college
Maharashtra
2007
61.33
S.S.C
Good Samaritan school
Maharashtra
2005
74.40
TECHNICAL SKILLS:
Databases
Sybase ASE 12.x, 12.5.x, 15.x,16.x,Sybase IQ 15.x,SAP 16,MongoDB
Languages
T-SQL,C
Operating Systems
SunOS, Linux, HP-UX, Windows 2003/08/12
Tools
Sybase Central,Sybase control center,Jira,Nagios,Proactive DBA.
PROFESSIONAL EXPERIENCE:
Current Experience:
Company - Optizm
Client - SAP India Pvt.Ltd
Designation - Senior Sybase DBA
Period - May 2017 till date.
Organization
SAP India Pvt.Ltd, Pune.
Project Title
RDO
Designation
Senior Sybase DBA/Team lead for third party employees
Platform
SunOS, Linux, AIX, HP-UX, Windows
Team Size
18
Software
ASE 12.x, ASE 12.5.x, ASE 15.x,16.x
Sybase Replication 12.x, 15.x,16.x.
Sybase IQ 15.x
Environment
Production, Dev, QA, Stage
PROJECT DESCRIPTION:
Available worldwide and 24x7 through Sybase Professional Services/SAP, RDO is an end-to-end software infrastructure operational support solution that includes monitoring, alerting, reporting, problem resolution, performance management and day to day production administration.
RDO, formally called REMO Project is involved in providing Production Support to more than 13 clients from different business verticals with various platforms (Linux, SunOS, HP-UX, AIX, Windows) and technologies (ASE, Replication, Sybase IQ) with 24x7 term of SLA for Various Parts of globe.
Past Experience:
Company - TalentPro India LTD
Client - SAP India Pvt.Ltd
Designation - Associate Sybase DBA
Period - May- 2016 to May 2017.
Organization
SAP India Pvt.Ltd, Pune.
Project Title
RDO
Designation
Sybase DBA
Platform
SunOS, Linux, AIX, HP-UX, Windows
Team Size
15
Software
ASE 12.x, ASE 12.5.x, ASE 15.x
Sybase Replication 12.x, 15.x
Sybase IQ 15.x
Environment
Production, Dev, QA, Stage
PROJECT DESCRIPTION:
Available worldwide and 24x7 through Sybase Professional Services/SAP, RDO is an end-to-end software infrastructure operational support solution that includes monitoring, alerting, reporting, problem resolution, performance management and day to day production administration.
RDO, formally called REMO Project is involved in providing Production Support to more than 17 clients from different business verticals with various platforms (Linux, SunOS, HP-UX, AIX, Windows) and technologies (ASE, Replication, Sybase IQ) with 24x7 term of SLA for Various Parts of globe.
Past Experience:
Company - SunGard (India) (www.sungard.com)
Client - Wall Street concepts.
Designation - Sybase DBA & system administrator
Period - Jan -2015 till May-2016
Organization
SunGard India. Aundh Pune
Project Title
Wall street concepts.
Designation
Sybase DBA & Linux windows admin
Platform
SunOS, Linux, AIX, HP-UX, Windows
Team Size
40
Software
ASE 12.x, ASE 12.5.x, ASE 15.x,ASE 16.x
Sybase Replication 12.x, 15.x
Sybase IQ 15.x
Environment
Production, Dev, QA, Stage
PROJECT DESCRIPTION:
Available worldwide and 24x7 through SunGard, Wallstreet is team working on taxation in USA. We are working in team with bunch of developers, testers, Operations and QA.
Sybase DBA is involved in providing Production Support with various platforms (Linux, SunOS, HP-UX, AIX, Windows) and technologies (ASE, Replication) with 24x7 term of SLA for Various Parts of globe.
Also I am working as secondary system administrator like resolving any permission issue as well as on citrix. Resolving Jira or confluence issue or provide different access like ssh access or to work with users for any system or network related issues.
Past Experience:
Company - Softenger (India) Pvt. Ltd (www.softenger.com)
Client - SAP India Pvt.Ltd (earlier called as Sybase Software Services)
Designation - Sybase DBA
Period - Nov -2011 to Jan -2015
Organization
SAP India Pvt.Ltd, Pune.
Project Title
REMO/RDO
Designation
Sybase DBA
Platform
SunOS, Linux, AIX, HP-UX, Windows
Team Size
12
Software
ASE 12.x, ASE 12.5.x, ASE 15.x
Sybase Replication 12.x, 15.x
Sybase IQ 15.x,SAP 16
Environment
Production, Dev, QA, Stage
PROJECT DESCRIPTION:
Available worldwide and 24x7 through Sybase Professional Services/SAP, RDO is an end-to-end software infrastructure operational support solution that includes monitoring, alerting, reporting, problem resolution, performance management and day to day production administration.
RDO, formally called REMO Project is involved in providing Production Support to more than 14 clients from different business verticals with various platforms (Linux, SunOS, HP-UX, AIX, Windows) and technologies (ASE, Replication, Sybase IQ) with 24x7 term of SLA for Various Parts of globe.
Responsibilities and Major Work Done:
On Adaptive Server Enterprise:
Providing 24/7 production support to Sybase servers and troubleshooting issues on daily basis.
Performed installation and configuration of ASE on Linux, SunOS and Windows 2008 R2.
Performed ESD upgradation from 15.0.3 ESD 4 to 15.0.3 ESD 4.2 on Linux and also to SAP 16
Performing backup and recovery, troubleshooting issues and worked on implementation of backup strategy.
Performing maintenance tasks in a given time frame to enhance the server performance.
Performing database consistency checks and troubleshooting the same.
Performed license installation and management.
Dealing with the device and database management including device creation, resize, mirroring and database alter and monitoring space usage.
Creating archive database, user defined temporary databases, named caches and bindings.
Dealing with the user management task including adding login and users, login sync, controlling user access to database.
Using utilities like BCP, ddlgen and Sybase Central.
Analyzing server performance using sysmon and MDA tables and suggesting and implementing recommendations to enhance performance.
Dealing with the DBCC setup and Sybsecurity setup.
Designing and implementing a new server installation plan.
Dealing with the configuration of a server and troubleshooting connectivity issues.
Dealing with the tempdb related issues, monitoring and management.
Over all monitoring of the server for blocking, long running processes and deadlocks.
Writing/modifying shell scripts for maintenance activities and automating them in cron.
On Sybase Replication Server:
Performed installation of replication server (15.0,15.7,16) on Linux.
Design and implementation of table level, warm standby and MSA setup.
Dealing with adding and dropping partitions for stable device.
Purging inbound and outbound queues.
Dealing with the latency, DSI and repagent related issues.
Performing sync of target database with primary for all type of setups.
Switch active for the warm standby setup.
Monitoring replication threads, disk space and latency and troubleshooting issues.
On Sybase IQ Server:
Performing basic monitoring tasks on Sybase IQ simplex and multiplex environment.
Dealing with monitoring and adding main/temp space to Sybase IQ server.
Performing full and incremental backups.
Performing multiplex sync activity.
Dealing with user management including adding users, controlling access.
Performing log truncation on simplex and multiplex environment.
On SAP HANA :
Working with HANA STUDIO
Managing SAP HANA systems in HANA STUDIO
Starting and stopping HANA systems
Configuring SAP HANA system properties.
Managing SAP HANA licenses
Managing SAP HANA users
Monitoring SAP HANA systems
Managing tables in SAP HANA database
High availability of SAP HANA
TRAININGS ATTENDED:
SAP HANA Database administration training at SAP India Pvt.Ltd.
ITIL foundation certified.
MongoDB DBA M102 certified.
Solaris,Linux & windows admin training provided in SunGard.
Basic UNIX and Sybase ASE training at Softenger India Pvt.Ltd.
Soft Skills training at Softenger India Pvt.Ltd.
Oracle 10G developer training from SQL star.
PERSONAL DETAILS:
Date of Birth
29-Sep-1989
Gender
Male
Marital Status
Single
Nationality
Indian
Language Proficiency
English, Marathi, Hindi
Hobbies
Playing football, listening to music, playing games, doing bike stunts.
Father’s Name
Shantaram More
Permanent Address
“Omkar” Ratnadeep colony wakad road Thergaon Pune 411033
DECLARATION:
I hereby declare that all the details and particulars furnished above are correct to the best of my knowledge and faith.
Place: Pune
Date: / / yours sincerely, Sushant More