Data Analyst Lecturer

RASHMI DHAKE

Email ***********@*****.*** Mobile No:- 919-***-****

Professional Summary

• 2.9 years of working experience in Oracle Database Administration.

• Experience in working with Oracle 10g, 11g, 12c Databases.

• Experience in Oracle 11g Database installation and configuration, maintenance, performance, tuning, upgrades, patching and monitoring.

• Good knowledge of Oracle architecture.

• Experienced at administering database security by creating users, grant/revoke roles, privileges to the users.

• Cloning the databases using RMAN and hot/cold for test, reporting environments.

• Monitoring and performing daily incremental backups, weekly backups using RMAN.

• Experience in RAM cloning of databases, Backup and Recovery of databases.

• Experience in backups of exp/imp and expdb/impdb.

• Configure and maintenance of Network Services (Listener and TNS configuration)

• Creating and monitoring the tablespaces, allocating tablespace for users.

• Usage of various types of functions, packages, procedures other DB objects available in SQL and PL/SQL.

• Analysing AWR, ASH reports and tracing

• Working on Excel macros, formula.

• Programming languages known are C, C#, Python, PL/SQL and SQL, databases MS-SQL server, Oracle 10g/11g/12c,19c, OS windows/Linux

• Excellent problem-solving skills with a strong technical background and good interpersonal skills.

EXPERIENCE

VR software Pvt. Ltd.

1. Project Name: Chronica

-Client: VMC (Vadodara Municipal Corporation)

-Role: DBA

-Database: Oracle 11g

o Creating table spaces and monitoring their growth and Resize or add more data files to Database or tablespaces for space related issues. o Creating Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

o Moving data between databases using utilities like Export /Import and Transportable tablespaces.

o Taking the online and offline backups on weekly and Monthly basis. o Taking the backup of the databases using RMAN, Logical and Hot Backup procedures. o Monitoring the alert log files, Trace files and troubleshooting the issues accordingly. o Exporting and importing the data or schemas across databases using logical backups EXP/IMP.

o Creating Databases and different objects of databases (Tables, Views, Function, Procedure and trigger).

o Installing, configuring, administering and troubleshooting database related software such as RMAN, OEM and log minor.

o Provides technical support for management of databases, listeners and other databases.

o Provides on call supports as and when needed.

o Reviews and modifies SQL to increase processing performance, referred to as performance tuning.

o Provides technical and functional support for db monitoring, dB installation, db configuration, db administration, troubleshooting techniques, performance tuning. 2. Project Name: VrGamthan

-Client: Mascon (SIPL)

-Role: SQL DEVLOPER

-Database: SQL server 2014

o Retrieving Data Using the SQL SELECT Statement as per client’s requirement. o Writing data manipulation language (DML) statements and subqueries. o Using DDL Statements to Create and Manage Tables. o Creation of constraints at the time of table creation. o Creating Databases and objects of database like tables, views, procedure and trigger.

o Prepare documentation for database.

o Creating store procedures and usage of various types of functions available in SQL. o Tracing SQL by Toad.

PREVIOUS EXPERIENCE

PSPL Pvt. Ltd., Vadodara (GJ) (India)

-Duration: 05 Months

-Designation: Data Analyst

-Project Name: Service Provider (Sales Force)

Govt. College of Engineering, Jalgaon (MH)(India)

-Duration: 06 Months

-Designation: Assistant Lecturer

-Subject: DBMS, Computer Networks

EDUCATIONAL QUALIFICATIONS

Bachelor’s in Computer Engineering from North Maharashtra University, Maharashtra (Yr.2011) Diploma in Computer engineering (2008) MSBTE, Mumbai.

Contact this candidate