Mayank Varshney

Email: aczi6d@r.postjobfree.com

Tel:

Address: **-*, ****** *** ****, Royal Tower, Indirapuram, Ghaziabad,U.P. : 91-904*******

: 91-971*******

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