Engineer Software
Resume:
Mayank Varshney
Email: *****************@*****.***
Tel:
Address: **-*, ****** *** ****, Royal Tower, Indirapuram, Ghaziabad,U.P. : 91-904*******
Career Objective
Module Lead Engineer with expertise in UNIX System/Network Administration, shell scripting, user management to increase reliability, productivity and introduce system efficiencies.
IT Skill set
Languages
:
SQL, Unix Shell Scripting
Technical Tools
Functional Tools
:
:
Oracle RMAN, TOAD, Putty, Data pumping, EM controller
Connectiva (Revenue Assurance ),Axway Product (CFT,Interchange,Sentinel)
Database
:
Oracle 10g
Operating system
:
Unix (Solaris 10),Linux, Windows XP
Hardware
Incident Management Tool
:
:
Intel X86,Sparc
Service Now
Certifications & Academic Credentials
SCSA
: Sun Certified System
Administrator
Sun Micro System Inc.
SCNA
: Sun Certified Network
Administrator
Sun Micro System Inc.
OCA
: Oracle Certified Associate
Oracle Corporation.
B.Com.
: Dr. Bhim Rao Ambedkar University.
M.Com : Dr. Bhim Rao Ambedkar University.
M.B.A (IT) : Allahabad Agricultural University.(Pursuing)
Summary
●Oracle Certified DBA and Sun Certified System & Network Administrator (SCSA & SCNA).
●Over 4 years of experience in production support environment.
●Skilled in installing and configuring UNIX like OS.
●Rich exposure of developing Shell Scripts for automation on UNIX.
●Excellent knowledge of UNIX architecture and Expert in UNIX File System Management.
●Capable of troubleshooting and debugging.
Professional Experience
Company: Sopra India Pvt. Ltd., Noida
(June 2015-Present)
Designation: Module Lead Engineer
Company: R Systems International Pvt. Ltd., Noida
(Sept 2014-Till date)
Designation: Software Engineer
Company: R Systems International Pvt. Ltd., Noida
(June 2011-July 2013)
Designation: Software Engineer
Projects
1. Project (at Sopra India Pvt. Ltd. Noida.)
(June 2015 - Present)
Client: Dignity Health
Domain: Cloud MS
Cloud management involves numerous tasks including performance monitoring (response times, latency, up-time, etc.), security and compliance auditing and management, and Initiating and overseeing disaster recovery and contingency plans.B2bi provides the visibility you need to find information about business-critical files and messages, and the analytics you need to be proactive, react to exceptions, and improve your overall business processes and SLAs.
Production Support and Development
Oracle 10g, Sun Solaris 10, SQL, Shell Scripting, CFT, Gateway Interchange, Sentinel
Roles & Responsibilities:-
Responsible to process and load the files within the given SLA.
Health’s checks of all the SOLARIS servers and carry out Unix Server Administration Activities and database Administration Activities
Use SQL queries to fetch report from database and Report to the customer about data process and server’s health.
Incident management - logging, prioritizing and resolving incidents and track them against various SLAs.
Monitor system availability. Manage and support high-availability 24/7 production systems.
Devised Logs Monitoring shell scripts & automated them for easy & efficient monitoring of servers/logs daily.
Product Up gradation, Installation and Patch Management.
Providing 24*7 Production Support to the customer.
2. Project (at R Systems International Pvt. Ltd. Noida.)
(June 2011 – July 2013 and Sep 2014 to May 2015)
Client: ZAIN Telecom Revenue Assurance
Domain: Telecom
To Provide Revenue Assurance solution for five Countries using Connectiva Revenue assurance solution.it Includes Trend Reports of Daily Usages Reconciliation Report between various usage point and key performance indicator (KPI) from various sources (CRM, Billing, Mediation and Order Management System)
Production Support and Development
Oracle 10g, Sun Solaris 10, PL/SQL, SQL, Shell Scripting
Key responsibilities:
1. To Carry out Unix Server Administration Activities
2. Report Generation on key Revenue Points and Leakages
3. Monitoring and Maintenance of file systems and File Processing through ETL
4. Performance Tuning at UNIX and Oracle Level.
5. To carry out database Administration Activities
TRAININGS & PROGRAMS
Network Based Attendance System (at Moonup Infotech Pvt. Ltd. Aligarh.)
(June 2010 – May 2011)
Client: Moonup Infotech, Aligarh.
Domain: IT (Information Technology)
Networking/Unix Administration
DBA, Testing/Automation
Responsible for regular backups using shell scripting and make utility. Client will calculate Smbios serial number and ip-address of student laptop and will pass it to attendance server, attendance server in turn communicate with ORACLE server’s tables to find his actual class and current location if he is in actual class or somewhere else based upon ip-address in VLAN. If current location matched with actual class location as per class’s timetable then attendance is marked. Created different tables, cursors, procedures, triggers in Oracle schema.
Shell scripts for cold and hot backup using crontab .Written apache based cgi programming in shell scripting for reporting in internet browser.
Other tasks were included Solaris/oracle installation. Solaris security/network driver setup, oracle network setup and oracle tablespace / data files management .Created Backup and recovery plans using RMAN and crontab based scripting.
Environment
Hardware : Intel Core2duo, SunSparc Server
Operating System : Sun Solaris 10
RDBMS : Oracle 10g
Language : C, Pro*C
Scripting : Shell, SQL
Tools : Bugzilla, CVS, make, SQL* Loader, Apache
Contact this candidate