Data Manager
Resume:
Sohil S. Sheikh
Nr. Al Rashidiyah Metro Station,
Dubai. UAE.
Mobile: +971-**-*******
Skype ID: sohil_sheikh
Email: ***********@*****.***
Career Objective
To seek the challenging position in software industry that needs innovation, creativity, dedication and enable me to continue to work in a challenging and fast paced environment, leveraging my current knowledge and fostering creativity with many learning opportunities. Experience and Key Skills
System Administrator with 5 + years of experience managing server infrastructures and data- centre operations across multiple platforms (Unix, Linux, Windows). Effectively plan, install, configure and optimize the IT infrastructure to consistently achieve high availability and performance.
Certified Oracle Database Administrator with good knowledge in all new Oracle tools.
Having good knowledge in creating database, storage management, table space management, security management, and monitoring Database performance on Oracle 8i, 9i, 10G, 11gR1 and 11gR2 installation, migration, etc.
Expertise in Installation, Monitoring, Cloning, Patching, and daily Health checks.
Environment: Oracle Enterprise Linux4/5/6.X, Sun Solaris 10, HP-UX 11.31, IBM AIX 6/7.x Oracle 10gR1/11gR1/R2, Physical Standby Database, Data guard, Oracle 10gR2/11gR1/R2 RAC.
Experience to managing and administrating 24/7 running database and also involved physical backup, logical backup, complete recovery, incomplete recovery, Data guard, RMAN, RAC, SQL*Loader, OEM, DBCA, DBUA tool.
Worked on the various environments such as SunOS-Solaris, RedHat, Linux, AIX,HP - Unix and
Windows 2000,XP,7, 2008 and 2012 Server.
Have setup Oracle RMAN with Flash Back, Clone database, Replication, Data Guard, RAC databases with ASM on Linux & Windows for High Availability environment.
Able administration of confidential projects with dispatch and discretion.
Possess positive attitude, responsible, and high degree of self-motivation.
Excellent problem solving and analytical skills troubleshoot real time problems in Short time period.
Willing to relocate: Anywhere.
Professional Experience
CMC Pvt. Ltd. System Supervisor 1st Nov 2008 To 30 Jan 2010
3I INFOTECH Pvt. Ltd. Assistant Engineer 28th Feb 2010 To 28 Jan 2012
WATERSHED. System Analyst 1st Fab 2012 To 15 July 2016 Technical Skills
Operating Systems UNIX, Windows (NT, 2000, XP, 7). Programming Languages C,C++,SQL & PL/SQL(Primary skill-set), Core JAVA etc. Tools PL/SQL: - Cursors, Procedure, Function, Triggers, Forms, Reports and More.SQL* Loader, DBV utility, SQL*PLUS, DBCA, Oracle Enterprise Manager, Export/Import, SQL Trace, Oracle Net Manager, RMAN, Data Guard, AWR, RAC,Flash backup Utility.
RDBMS/DBMS D2K, Databases: Oracle 9i / Oracle 10g / Oracle 11i and Toad developer 9.0.1.8
Education
Degree University Percentage Year of Passing
B.C.A Gujarat University, Gujarat, India. 59.50% 2007 H.S.C. G.H.E.B 54.62% 2004
S.S.C. G.S.E.B 56.50% 2002
Professional Certificate
Professional/Project Experience:
1. Watershed Management System. Is the Central Government Agency in India, with its Branches at every district in states of India. Watershed Department Maintain huge database with GEO Tagging, C Guard, IWMPMIS and PFMS Software on all Government Skims activities.
Watershed Management System.
Client: Watershed Management System.
Designation: System Analyst
Duration: Feb 2012 to At Present
Description.
Working with DOLR,IWMPMIS, GEO Tagging, C Guard Software Directly updated all changes with satellite pictures.
Working with GPS instruments directly data store in database Oracle 10g,11i.
Take physically backup use EXPDP and IMPDP every week.
Use RMAN Utilities for hot backup. Excellent experience in production support, installation, configuration, upgrades,
Migrations, patches, performance tuning, backup and recovery, cloning, space
Management, database security, auditing.
Expertise in development, testing and implementation of Backup and Recovery strategy Using RMAN, Data pump and Export/Import utilities.
Strong experience in Backup and Recovery strategies using RMAN, Export/Import, Data pump, Hot and Cold backups.
Implemented Data guard (Physical Standby) for RAC databases.
Proficiency in standby database (Data guard) installation, configuration, maintenance, and administration for disaster recovery.
Expertise includes Oracle Databases (11g RAC/10g RAC/9i/8i), on UNIX (HP-UX, Sun Solaris, IBMAIX)/LINUX and Windows environments
Experienced in setting up/installation and configuration of release 11g RAC/10g R1 RAC with EMC Storage.
Performance tune and Daily check health of database. Weekly and monthly schedule backup also use Oracle provide tools SQL OEM, SQL Light, SQL LOADER and more.
Oracle9i Database Administrator, Oracle Certified Associates (OCA) and Oracle Certified Professional (OCP).
Prometic Testing ID : SR2838168.
1.
IZ0-007 Introduction to Oracle 9i – SQL 87%.
2. IZ0-031 Oracle 9i Database Fundamentals. 95%.
3. IZ0-032 Oracle 9i Database Fundamentals II. 100%. 4. IZ0-033 Oracle 9i Performance Tuning. 83%.
2. NIC (National Informatics Centre) is the Central Government Organization of India, with its centers at every district in states of India. The project by which the NICs of districts provided by the Internet facilities.
Client: NIC (National Informatics Centre)
Designation: Assistant Engineer (Networking DBA).
Duration: Feb 2010 to Jan 2012
Description:
Install all new hardware, systems, and software for networks.
Handle the Ration card and unique card database. And also DDL, DML Operation. Migrating the Database.
Trouble Shooting when instance require.
Manage control file, data file, parameter file etc.
Created and managing the VLAN on the switches and VPN on Firewall.
Supports administration of servers and server clusters.
Manages all system back-up and restore protocol.
Plans and supports network and computing infrastructure.
Staff databases that store all of staff information with his thumb print for higher security.
LAN designing and troubleshooting.
Excellent knowledge of Oracle backup and recovery scenarios.
Cisco router, switch and modem configurations and troubleshooting.
Involved in ISP (Internet Service providing) at various government offices.
Expertise in network troubleshooting and designing.
Installation of Oracle software
Monitor database and system performance.
Managing Table spaces, rollback segments, Control file, Data file, Log file and parameter file
Creating Users and allocating Space and Privileges to Users
Monitoring alert log.
Perform hot, cold backups of the Oracle Database.
Tuning Database, Memory for optimal Performance
Work with ASM, RAC and Flash recovery of database with Oracle 10g.
Work with stand by database configure with Data Guard Logical and Physical stand by primary database.
Client ECI (Election Commission of India)
Designation System supervisor
Role Developer & Data Base Administrator (DBA)
Organization CMC.PVT.LTD
Duration Nov 2008 to Jan-2010
Environment Tool and Technology : Toad 9.0.1, SCROLL (System for Computerized Electoral Roll),Epic application, Create resorting MDB Database: Oracle 8, 9i, 11g.
3. CMC PVT LTD. Election Commission Of India is the maintain the Election Work of India. Most probably its contain Electors data. Who stores in district servers. Maintenance and handling by CMC.PVT.LTD Company. Creating Query, Function, Procedure, Fire Triggers as per Order. ERMS (Electoral Management System). Project that trouble shoot whole the database zero level. And taking migrating database old data in oracle 8 convert in Oracle 11g. Description:
Working as DBA configuration & installing of Database as per User authentication. Replication and flash back up of database. DML, DDL, DCL operation as per require.
Troubleshoots with problems regarding the databases, applications and development tools. Work with Toad developer use Crystal report 8 and 11.
Taking Hot / Cold backup. Configuration of Table Space, Extent manually. Export / Import with use of Data pump every weekly and monthly basis .
RMAN Recovery Manager Use database backup archived and non archived mode . Full backup of database use replication for security purpose.
Optimization of the different SQL Queries to insure faster response time from Instance.
Creating and maintaining Table, Indexes, views and other objects for the faster retrieval of data and manipulation. Checking and maintaining the Integrity of Database.
Create User and Grant, Revoke, and Roles.
Managing backup and recovery of databases.
Monitoring daily scheduled and Re-executing failed RMAN regular online and logical Backups.
Personal Details
I hereby declare that the information provided by me is true to the best of my knowledge. Sohil S. Sheikh
Birth date 30th Aug 1987
Languages Known English, Gujarati, Hindi
Gender Male
Passport No G9046627
Marital Status Married
Permanent Address
Sheikh Palace, Vajirvali Sheri, Off Diwanpara Road Bhavnagar –364001 Gujarat. India
Contact this candidate