ANIL KUMAR SINGH

[email protected]

Address: C-501 Shree Balaji Status , Nagalpur ,Mahesana, Gujarat Ph. no. (+91) 9540565968

Career Objective

To work in a creative environment using cutting edge technologies and successfully deliver innovative solutions to the problems as a computer engineer.

Currently working

 2 Month of Working Experience as Database Support Engineer -Middle (Oracle Database Administrator) in ASTOUND COMMERCES INDIA PVT.

Duration: From Jan2023 to Till.

●
3.10 Year of Working Experience as Senior Specialist (Oracle Database Administrator) in HCL TECHNOLOGY LIMITED. (Project for OMYA , Stanley Black &Decker) .

Duration: from March 2019 to Dec2022

●
2.3 Years of Working Experience as Oracle Database Administrator in SIFY TECHNOLOGY LIMITED. (Project for ONGC Tripura Power Company Limited New Delhi-

19)

Duration: from Dec 2016 to Feb 2019.

●
4.8 Years of Working experience as Database Administration in Innovative Business Solution.

Duration: from Jan 2011 to Dec. 2016.

Technical Skills

Programming Languages : Oracle, SQL, PL/SQL , T-SQL, MS SQL Server .

Database : Oracle 11g, Oracle 10g, 12c, 18c,19c, SQL Server 2014,16, Amazon cloud .

Operating system : RHEL 4.2, 5.3, 5.8, Linux 6.4 (Santiago), IBM AIX,Unix.

Window 2003, Window 2008, Windows servers 2012R

Domain : Oracle Core DBA, OEM 11g,12c,18c,19c, ASM, RMAN, RAC, GG.

Tools : Putty, TOAD, SQL Developer.

R- Language : Graph plotting, Designs, Experimental Block Designs, ANOVA Table, Alpha Design etc.

: Visual Studio Code, Git Bash, pycharm etc.

Python

Database related technical skills:

●
Oracle SQL, PL/SQL
●
Oracle Core DBA activities
●
Oracle Database Administration using OEM
●
Performance Tuning
●
Backup and Recovery using RMAN
●
R-Language and database connectivity for using related package.

Database Administration and development tools:

Oracle Enterprise Manager (OEM) : Oracle SQL *Plus

NETCA, NetMgr, DBCA, LSNRCTL, DBUA : SQL *Loader

EXPDP/IMPDP, EXP/IMP : RMAN

Putty : Toad

Responsibilities as Core-DBA:
●
Working on the Production Environment.
●
Installation and configuration of Oracle 10g/11g/12c/19c on Linux/Solaris as well as Windows.
●
Creating and configuring database using DBCA as well as manually as per the Organization

Standards.
●
Managing the database storage structure.
●
Managing more than 25+ Production databases having maximum database size is approx. 6 TB.
●
Managing database users and security as per the organization policy.
●
Managing Schema objects such as tables, views, indexes, mviews etc.
●
Analyzing various issues of database like creating index and their structure.
●
Involved in code review for compact and effective code.
●
Export/Import of database (database refresh or schema refresh).
●
Monitor and management of database performance.
●
Managing backup policy and managing crontab.
●
Perform recovery whenever required.
●
Using flashback technology whenever required.
●
Migration and cloning of database whenever required.
●
Installation and configuration on OEM.
●
Managing Standby Database.
●
Troubleshooting of all issues related to database.
●
Standby Database configuration and management.
●
Shell Scripting. Job Scheduling etc.
●
Having good knowledge of Oracle Architecture (SGA, PGA and background process).
● Experience in Oracle Software Installation, doing patching and up gradation of oracle database.
●
Schema Management.
●
Creating Database user and granting appropriate privilege.
●
Monitoring space related Issues of (data file, table space and Disk/Disk group)
●
Generating Reports (AWR/TKPROF/Execution Plane/Auto Trace)
●
Creating and managing DB link for distributed database privilege.
●
Design , Implementing and maintain Backup polices using RMAN, Import/Export, Hot/cold
●
Backup and data pump.
●
MS SQL database installation, configuration and monitoring.
●
MS SQL Always on configuration.
●
MS SQL database backup and recovery.
●
Installation , Configuration and Implementation of Data guard/ Standby /RAC
●
Having experience on DR Drills(Switchover) from Primary Database To Physical Database.
●
RAC Instance Start up/Shutdown ,Monitoring
●
Good Knowledge of Oracle Cluster Registry(OCR) and Voting Disk
●
Good Knowledge about global resource directory (GRD)
●
CRS manage with CRCTL and server control utility (SRVCTL)
●
Monitoring ASM and database Instance availability.
●
AWS cloud RDS and EC2
●
Golden Gate (Beginner )
●
Shell scripting.
●
Log Miner.
●
Oracle Change Data Capture (oracle CDC)
●
SQL Loader .
●
On-prim Oracle DB migration to AWS RDS

Projects Undertaken:

Database Production Support: Managing Oracle Database including installation, configuration, storage management, database health checkup, security policy, monitoring,

performance tuning, backup policy and recovery whenever required.

ONGC Tripura Power Company: My role and responsibility for here managing MS SQL database for creating new DB and configuration. Monitoring for CA automation, CA ticketing

tool, and Access control DB for all OTPC clients . Monitoring SQL Server DB through Solarwind etc.

OMYA : MS SQL database for RDS jump servers through access all Servers, create and configure always On for failover and Switchover. Some DB create AZURE cloud environment,

managing all DB and monitoring etc.

Multi-Client Support:

IFFCO Fertilizers, JAYPEE Associates, Sunbeam Auto Limited, Ola cabe, KFC food, JK Laxmi Cement, BPL Display Devices, NIC (Notional Informatics Center) Gujrat Two wheeler

project , ONGC Tripura Power Company LTD. OMYA, Stanley Black & Decker.

Communication Domain: Airtel (2 years of experience).

Educational Qualifications:

Examination Discipline/ School/College Board/University Year of Completion

Specialization

B.Tech Computer Science & Kali Charan Nigam Institute of Technology, Uttar Pradesh Technical University 2011

Engineering Banda, Uttar Pradesh (U.P.)

Intermediate PCM Stream Srimati Devakali Intermediate College, Jamalpur, Uttar Pradesh Board of High School and 2004

Mirzapur, U.P. Intermediate Education

High school Science Stream Intermediate College Mathana, Mirzapur, U.P. Uttar Pradesh Board of High School and 2002

Intermediate Education

Personal Profile:

Name : ANIL KUMAR SINGH

Father’s Name : Mr. PARAS NATH SINGH

Marital status : Unmarried

Nationality : Indian

Hobbies : Listening Music, Net surfing

Mobile Number : 95-4056-5968

Passport Number : J4905052

Permanent Address : Village:- Sahijani –Hardi, Post: Dedauna (Adalhat) Mirzapur, 231302 (U.P.)

Achievements

●
Successfully completed 6 weeks of summer Training program in IBM Mainframe at DUCAT in Noida; 2009

●
Successfully completed 4 weeks of summer Training program in ASP.NET(c#) at DUCAT in Noida; 2010
●
Participation in Microsoft online Seminar (Windows 7 Launching); 2010

●
Successfully completed Training program in GENSTAT Software platform for Data Management, Field–plot Techniques, Experimental Designs and Statistical Analysis,

Advance Biometrical Techniques in Crop Improvement Research at ICARDA (International Center for Agriculture Research in the Dry Areas) in office block-c, NASC complex, DPS

Marg, Pusa Campus New Delhi -110012, India.

Declaration: I hereby declare that the above-mentioned information is correct to the best of my knowledge and bear the full responsibility of the correctness of the above-

mentioned particulars.

Place: NEW DELHI ANIL KUMAR SINGH