Manager Windows Server
Resume:
Praveen Kumar Jujare
***************@*****.***
To pursue a job that provides opportunities to pick up new skills, as an Oracle DBA, Oracle RAC DBA, ASM, Performance Tuning, Tableau Admin & knowledge in HADOOP Admin hone them and work in an environment of challenges. To achieve excellence, growth and satisfaction in the area of work undertaken.
More than Six plus years of experience in the IT industry, specialized in the area of Oracle database administration, having hands-on- experience extensively in Oracle DBA working on different platforms such as LINUX and Windows. Installation, configuration, migration and maintenance of Oracle Database on various operating Systems in 24x7 productions.
Working as a Database Administrator in Abdullatif & Mohamed AL Fozan Khobar
Saudi Arabia since April 2013 to till date.
Working as a Database Administrator in Trison Technologies Ltd. Bangalore. Since Jan 2009 to March 2013.
Bachelor of Technologies (B.Tech) From University of JNTU of Hyderabad.
Oracle Certified Associate (OCA) 9i & oracle certified professional (OCP) 9i
Skill set:
Tools & Utilities : Export & Import, RAC, ASM, Data guard, RMAN, putty,
VMware Workstation, Stats pack, lsnrctl, Sql loader,
Tableau Admin
And Hadoop Admin.
Third Party Tool : TOAD, Nagios, Apex, Orion 10.5
Operating Systems : Linux (Red Hat, Centos), Windows Server.
ROLES AND RESPONSIBILITIES:
Over all 6+ years of experience in the database administration of Oracle Database.
Performed Installation, Configuration and Administration of Oracle databases.
Knowledge of manually creating Oracle Database.
Have good knowledge on Oracle Architecture.
Have the knowledge of refreshing database and Cloning Database (Physically, Logically and with RMAN).
Creation of database objects like table, index, DB Link, Tablespace and Users according to the application requirements.
Knowledge of Oracle Utilities like export/import & Data pump.
Knowledge of configuring and using of Recovery Manager (RMAN).
Have Knowledge on Physical Backup’s like COLD and HOT Backup, Restore and Recovery at different scenario.
Using SQL *Loader to insert data from flat file to oracle tables.
Tuned frequently used SQL Statements and increased performance.
Knowledge of Data guard configuration, performing switchover and failover operations.
Having knowledge on tableau Administrator
Having basics knowledge on hadoop Administrator
Project 1:
Organization : Al Fozan Head office
Title : Retail, Real Estate & trading
Client : 1. Al Fozan Building Materials
2. Al Fozan Metals
3. Al Fozan Hardware co
4. Al Fozan Electricals co
5. Al Fozan Head office & Al Fozan Holding
Environment : Oracle 11g on Red Hat 5.4.
Time size : 10
Description : Administrating and supporting the Production and Development databases support for using monitoring tool, which involves user management, backup and recovery and handling day-to-day database activities.
Roles and Responsibilities:
Performed Installation, Configuration and Administration of Oracle databases in physical/virtual, Oracle Architecture.
Collaboration with the application team & work with together to fix the daily basis issues. To get best performance of the db & application.
Database backup by using data pump & RMan.
Creation of database objects like table, index, DB Link etc, creating Tablespace and Users according to the application requirements and Increasing the size of database by adding data files.
Backup, Restore and Recovery at different scenario.
Tuning frequently used SQL Statements and increased performance of the reports.
Checking the job executed or not and Compiling the invalid objects in support database.
Checking the Log files (alert, listener, backups in all the databases).
Monitoring the database
New Year Processing for every year
Project 2:
Organization : Al Fozan Head office
Title : BI implementation
Client : Al Fozan group of companies
Environment : Oracle 11g on Windows server 2012R2 and Apex
Time size : 6
Roles and Responsibilities:
Monitor the health of the entire BI environment.
Manage the security of the BI environment.
Monitor all scheduled jobs (Materialized view refresh).
Monitor and tune the performance of the entire BI environment.
Design and architect the entire BI environment, and any subsequent growth of the database.
Troubleshoot any issue.
Project 3:
Organization : Al Fozan Head office
Title : Tableau Software
Client : Al Fozan group of companies
Environment : Tableau Server 9.3 on Windows server 2012R2 and Tableau Desktop on Windows
Time size : 4
Roles and Responsibilities:
Installed windows server, tableau server & tableau desktop
Created server architecture for scheduling tasks.
Analyzed and resolved performance and server based issues.
Prepared backups using Tabadmin and Tabcmd commands.
Formulated procedures for installation and configuration of Tableau desktop.
Participated in performance tracking activity by evaluating server tasks.
Modified data visualization dashboards and developed data connections.
Project 4:
Organization : Honeywell
Title : ING GROUPS (U.K.)
Client : ING GROUPS
Environment : Oracle 10g on Red Hat 5.
Time size : Team Size 5 (3 DBA in Offshore, 2 DBA in Onsite)
Description:
Administrating and supporting the Production and Development databases in a 24X7 support for using monitoring tool, which involves user management, backup and recovery and handling day-to-day database activities.
Roles and Responsibilities:
Creating database and table spaces whenever needed.
Creating tables, views and indexes whenever needed.
Created users and granted appropriate privileges.
Good Knowledge on Linux Operating Systems.
Having Knowledge on installing Linux OS.
Having Knowledge on creating FTP server, DNS server
Ensuring Database security by managing users & profile.
Planning and Performing Cold and Hot Backups.
Online Database Backup, Archived redo log files and Offline backup.
Taking the Logical and physical backup of the database regularly.
Configuring RMAN (Recovery Manager).
Planning and Performing Daily, Weekly and Monthly RMAN Backups.
Archival management issues e.g.: deleting unnecessary archives using RMAN.
Refreshing development/test database from production using Export/Import, This is done so that the latest data is available in the development/test database.
Moving Data between Database using utilities like Export/Import.
Creation of database links & materialized views.
Enabled the database in archive log mode.
Supported the senior DBA in regular DBA activities.
Recovery strategies include simulation of crash scenarios on the test system.
Gender : MALE
Marital Status : SINGLE
Date of Birth : 28/10/1982
Language Known : English, Hindi, Telugu, Marathi
Nationality : Indian
Contact this candidate