Management Service

Dinesh A Serving Notice Period, LWD: **th April **19

Email ID: ******.******@*******.***

Mobile: +91-964*******

Age: 24

Objective

Seeking challenging work in an environment, that promotes creative thinking, allows flexibility, and offers immense potential to build my technical and leadership skills.

Professional Summary

Total 6.7 Years of multi-skilled IT experience in Scripting, Linux Administration, Database Administration and handling cross-functional responsibilities

2+ years of Experience in Scripting(Bash, Python), Linux Administration Essentials and Devops Tools

Working Knowledge on GIT, Docker, Vagrant, Ansible, Jenkins and other Devops Tools

Extremely passionate and proven abilities in Automating Repetitive Tasks

Tested, implemented and maintained scripts for health check and admin operations

Extremely passionate and proven abilities in “IT Infrastructure Automation and Service operations”

Excellent communication and interpersonal skills with abilities in resolving complex issues

3.5 years of Experience in Database Administration L2 (Oracle, MSSQL), MYSQL(L1)

Supported 24X7 Production environments on rotational basis

Experience in building Oracle and MSSQL Server database environments

Technical Skills

Automation Tools : Vagrant, Ansible, Jenkins, Chef

Operating Systems : RHEL, AIX and Windows Server

Databases : Oracle (9i-12c), MSSQL Server (2000-2012), MYSQL 5.5

Ticketing Tools : Enlighta, OTRS, Ivanti Landesk, Service Now, BMC Remedy

Monitoring Tools : Nagios, HP Site Scope, OEM

Virtualization Tools : VMware, Oracle VM Virtual Box

Scripting : Bash, Python

Others : GIT, Docker

Professional Experience

Organization : Tech Mahindra Pvt Ltd

Project : GHSS

Role : Automation, Linux Administration, Database Administration

Duration : August 2012 to till date (6.7 Years)

Team Size : 7

Project Description and Responsibilities

Global Hosting and Shared Services provides shared services to multiple clients spread across the globe. Key activities are Administration and Automation of Database and Linux servers, ensuring services availability 24X7. Clients Supporting include, JTEKT – Japan (Automotive),DION – Singapore (Wealth Management),Hexagon – Sweden (Manufacturing Intelligence),Solenis – USA (Manufacturing and chemical distribution), Super Retail Group – Australia (Automotive, Outdoor and Leisure Retailer), Care Stream Dental – Atlanta (Digital imaging, Software and Practice management solutions for Dental Practitioners)

Scripting (Shell, Python), Linux Administration and Devops

Configured Bash scripts for Health Check Monitoring Alerts, Log file Management, Backups and Mail Alerts in Database Environments.

Configured Python Scripts to Automate Repetitive tasks based on frequency of Tickets. Automated tasks include User Creation, Database Creation, User Privileges modification, Backup and Restoration of MSSQL Database Servers.

Knowledge on OTRS Ticket Integration with Service Now for Automation based on Tickets Raised.

Automating tasks by scheduling CRON jobs and monitoring the Cron jobs

Day to day operational support with hands on experience of RHEL, AIX and Oracle Linux servers

User and Group administration (create, delete, modify & SUDO user's configuration)

Package management using RPM, YUM

Performing Backup using tar, gzip and rsync

Configuring SSH key pair for seamless authentication

Applications/tools installation as per client requirement

Research and Troubleshoot on system performance issues, Application Integration, Service issues, etc.

Ansible installation and configuration, configuring systems, deploying software’s and orchestrating IT automation

Defining hosts/groups in ansible inventory, using shell, transferring files, managing packages, user/group administration, deploying from source control(GIT), service management

Creating playbook, defining tasks, creating roles and executing ansible playbook

Experience in using version control tools like GIT

Installing GIT, cloning and pushing, creating repository, committing changes, opening and merging pull requests in GIT Hub

Docker installation, downloading images, creating containers and other administration tasks

Creating repository, pushing and pulling images from Docker Hub

Installing Chef, developed Chef recipes and cookbooks to automate, configure, deploy and maintain software components of the existing infrastructure

Jenkins Installation, Configuration, Design and Administration, Managing Plugins, Nodes and configuring tools

Continuous delivery using GIT, Jenkins and Ansible

Vagrant installation, configuration, initializing/editing Vagrant file, provisioning Machines (Virtual Box)

Downloading vagrant Boxes and spinning virtual machines, deploying software’s from synced folders

Analyze the level of automation (partial, full and non-automatable) and preparing test cases for script and process

Oracle DBA

Installation and Configuration of Oracle 11g R2 (11.2.0.3, 11.2.0.4) on Linux RHEL 6

Upgrading Oracle 11g (11.2.0.4) to Oracle 12c (12.1.0.1)

Deploying mail alerts and configuring the scripts, to automate manual DB health checks for alert log errors, DB health, DB status, Listener status, RMAN backups etc.

Implementing multiplexing, archive log mode, SP file

Active participation in DB reboot activities performed monthly or when required during OS Patching

Daily Monitoring of all servers and generating weekly/monthly reports accordingly

Performing user management requests i.e., creating users, dropping users, changing passwords, assigning roles and profiles

Experience on Storage tasks, space management including creation and maintenance of data files and table spaces along with flash recovery area configuration

Working with traditional and data pump utility, for selective data export and import on production/test/dev based on client/online team requests. Creating directories, granting permissions and performing imp/exp accordingly

Handling the listener issues and purging the listener log to avoid the connectivity issues

Monitoring mount points and Space management of archive logs and taking proper action within SLA timelines

Database troubleshooting for general issues (DB Connectivity, Disk Spaces, Alert log & trace file management, DB locks, cursor issues, undo tables pace issues and temporary table space issues)

Generating monthly reports for availability, performance and space usage. Arranging meetings, discussions, etc. with customer and onsite team

Troubleshooting and Monitoring from Oracle Enterprise Manager

MSSQL Server DBA

Hands on experience in installing, configuring SQL Servers (SQL Server 2000 to 2012) and updating Service packs

Involving in new SQL Server builds along with the pre and post steps

Planning and implementing the backup strategy by analyzing the disk space upon the requirement ensuring backups are done at regular intervals

Experience in Scheduling daily/weekly maintenance plans for SQL backups (Full, Diff, Tlog)

Troubleshooting failed backups using logs

Performing database restoration upon client requests

Administering the MS SQL server by creating logins with appropriate roles, monitoring the user accounts, and granting the privileges to users based on customer requirement in production and development environment

Involved in the service accounts change for SQL Services based upon the requirement

SQL server daily health check to ensure all the servers and database are up and running fine by monitoring the database status, checking error logs, checking Windows NT Event Logs, checking log file sizes, connectivity to the instance/databases and monitoring Disk spaces

Experience in Incident management, change management, request management, Inventory Management and performing the activities based on the severity providing 24x7 support

MYSQL DBA

Performing daily monitoring and administration of MYSQL databases of OVM (Oracle), Nagios and OTRS

Bouncing the database as required during reboot activities

Performing backup and restore as requested by respective team with mysqldump utility

Configuring and maintaining retention for the manual backups for the mysql database in OVM Server

Certifications

Certified Infrastructure Management Support Professional from Tech Mahindra

Academics

Diploma in Electrical and Electronics Engineering, from Sai Ganapathi Engineering College in 2012. Secured 89.4% with distinction

Class Xth (ICSE Board), from St Joseph's Secondary School in 2009. Secured 78.4% with distinction

Personal Details

Name : Dinesh Anjuri

Date of Birth : 12th March 1994

Nationality : Indian

Marital Status : Single

Languages known : English, Hindi and Telugu

Passport No. : Z4765932

Pan Number : BBVPA6807J

Contact this candidate