Name :Navneet singh

E.mail :adzs3s@r.postjobfree.com

Phone no. : +91-787*******/980-***-****

Summary:

Oracle Certified Expert having around 10 years of experience in IT industry with strong multiple skills in Database Administration and Architect profile.

Objective

Treating every adversity as an opportunity, aspire to morph every opportunity to an achievement.

To work in a challenging environment which provides me with the field to explore and enhance my technical skills.

To work in an energetic way to boost the performance of an organization.

Technical Expertise

Technology

Years of Experience

Oracle Database

10 years

Operating System (Linux/Solaris/Windows/AIX)

8 years

OBIEE 11G Admin

6 years

OBIEE12C Admin

2 years

Data Warehouse Informatica/DAC Admin

6 years

ODI ADMIN

2 years

Primavera Admin

6 Years

Denodo Admin

5 Year (Project Running)

Oracle EBS 12.2.0

1 year

OEM 12C Monitoring Tool

4 years

Oracle Fusion Middleware 11g/12c

3 years

Tableau Admin

5 year

PostgreSQL 10/Sql-server

3 year

Certification:

OCP 9i/11g DBA Track.

ITIL Foundation Certificate in IT Service Management.

AWS Certified Solution Architect Associate.

Denodo Platform Installation.

Denodo Platform Server Administrator.

Denodo Upgrade to Denodo Platform 7.0.

Technical Expertise/Activities:

ORACLE DBA:-

Performance Tuning and re-organization

Upgraded all database versions from 11g to 12c.

Applied Database/Security/CPU/PSU Patches.

Experience with Oracle 11g/12c Data Guard.

Expertise on Oracle Production / Development Support, Database Administration and Maintenance.

Extensive experience in Database and Application Performance tuning using AWR, ADDM reports.

Sound knowledge of Shell Scripting.

Used Oracle OEM and shell scripts for Database Monitoring and Control

Maintain and troubleshoot standby database and experience in Standby Rman Recovery.

Created Test/UAT environment by Migrating data from production.

Sound experience on Backup, restore and Recovery of production databases,

Clone the production database to non-production environments using RMAN.

INFORMATICA 9.0.1

Installation of informatica 9.0.1 on Linux.

Configured SSL on Informatica 9.0.1.

Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.

Extensively used SQL Tuning to improve performance.

Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes etc.

Used DAC (Data warehouse Application Console) for both incremental and full loads.

Monitored and Scheduled ETL along with reducing application configuration and development time by using DAC.

Installation of DAC 11G.

Configured DAC 11G client.

DAC Repository migration from one environment to other.

Experience on Tuning long running Mapping Mapping.

Use the best practices of business intelligence to administer the analytical solutions.

ORACLE ODI Admin:-

Experience in high data volume environments/ performance tuning in ODI.

Configure topology for all the technologies.

configure Standalone and Java EE agents.

Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents..

Experience installation of ODI 11g on linux/Windows .

Configure ODI REPOSITORY Creation.

Tuning weblogic in ODI and java process.

Integrate Adeptia tool with ODI jobs.

Shell script for ODI repository backup.

Experience in ODI migration from PROD to NON-PROD.

Reduced run time of ETL processes from 16 hours to 4 hours for Financials/HR PeopleSoft jobs.

ORACLE OBIEE Admin:-

Experience installation of OBIEE 11g/12C on linux/Windows .

Upgrade OBIEE 11g to 12c.

Configured SSL on OBIEE.

Experience with weblogic server and Enterprise manager in OBIEE 11g/12c

Monitor business use and performance of the BI and provide feedback to BI architects, developers, metadata manager and database administrators.

Install new equipment and software patches and upgrades in OBIEE.

Administer user access and security.

Shell script OBIEE repository Backup and restore data as needed.

OBIEE agent job creation.

Configure OBIEE R.

Oracle EBS 12:-

Installation, configuration Oracle EBS 12.2.0.

Upgrade EBS 12.2.0 to 12.2.6 and 12.2.8.

Starting and Stopping the application.

Establish and maintain backup and recovery policies and procedures.

Patch Management and Version Control.

Perform database tuning and performance monitoring.

Cloning DEV and TEST from PROD.

Primavera Admin:-

Installation of Primavera 17.7

Upgrade Primavera application 8.4 to 17.7

Upgrade Primavera application 17.7 to 18.8.2.

Installation of Bipublisher 12.2.1.2.0

Configure Primavera reports with Biplublisher.

Experience of configured Start ETL for Primavera.

Integration Financials with various tools for reporting purpose: -

Hands on experienced integration of Tableau, OBIEE 11g/12c, ODI11g, Smart Export, Denodo applications with financials database for statistical analysis.

Integrated Primavera 18.8.2 team member with Mobile application: -

Integrated Primavera 18.8.2 team member with iPhone/android apps. This app gives team members the possibility to update the progress of their activities while there are on location.

Integrated Smart view MS-Office with ORACLE OBIEE: -

Experienced on integrated Oracle OBIEE 12.2.1.1 with MS-EXCEL Smart view 2007. Using Smart View add-in, we created a OBIEE reports from Excel/Word and save in OBIEE catalog and see those reports within OBI Presentation services and can use it for further analysis.

Denodo 7.0 :- (PROJECT FINANCIALS,HR and Datawarehouse)

Denodo Platform provides all the benefits of data virtualization including the ability to provide real-time access to integrated data across an organization.

Installation of Denodo platform and solution manager 7.0 on Linux and applied necessary patches.

Installation of Denodo platform and solution manager.

Configured cache for denodo views.

Enable Auditing for user access in VPD.

LDAP configuration in Denodo.

Create a security role for users.

Denodo backup script scheduling.

Integrated Denodo with TFS for version control.

Integrated Denodo with different data source (Oracle/ms-sql/Mongo-db).

Integrated Denodo with Tableau for data visualization.

Implement denodo Solution Manager web tool for developers and administrators to promote changes from development to the other environments. Creating cluster on Denodo Solution manager.

Configured Denodo monitor usage tracking tool.

Worked on denodo performance tuning.

Apply the Latest Update of Denodo Solution manager.

License manager in Denodo Solution Manager.

Upgrade Denodo 7.0 to Denodo 8.0

Hands on Denodo DR

Tableau Admin and integration with Oracle Database for data Visualization: -

Upgrade tableau 2018 to 2019.2.0 and then 2020.2

Monitor server activity/usage statistics to identify possible performance issues/enhancements.

Created tableau dashboard for multiple database growth.

Archive log generation dashboard created which help to analyze the data generation per hour/week/day.

Blocking sessions dashboard created to help the blocked session of databases.

Created dashboard in tableau for infra team to check current and history per disk I/O.

Manage the application’s users, groups, and integration with Active Directory.

Hands in Tableau DR.

Professional Experience

Having around 10 years of experience as Database Administrator/Architect, Presently working with Oceaneering Inc LTD with Excellent hands of experience in Installation & Configuration, administrating and troubleshooting on Oracle 9i,10g,11g and 12c having a fair exposure in all DBA related activities like Oracle installations, Database Creation, RMAN Implementation and Backup and Recovery tasks. Have a good attitude towards hard work and have good ability to meet schedules and grasp new concepts and technology.

1)Oceaneering International Ltd

Designation: Sr. Application Administrator I, Oracle, Grade I

Duration: - 24 Sep 2012 to till yet

Project: - Support- Oracle Database servers

Upgrade Oracle 11g database to Oracle 12C/19C.

Implement Datagaurd broker (11g and 12c) for Production database.

Maintain and troubleshoot standby database and experience in Standby Rman Recovery.

Database RMAN cloning as per project requirement.

Develops strategies for archive recovery and implementation of a database.

Applied Database/Security/CPU/PSU Patches.

Created Test/UAT environment by Migrating data from production.

Extensive experience in Database and Application Performance tuning using AWR, ADDM reports.

Worked with monitoring tools such as OEM, Nagios.

BI ADMIN:-

Installation of BI, Informatica and DAC.

Provide Informatica privileges to users.

Monitoring ETL load and troubleshooting if it failed.

Hands on experience of installation ODI11g,OBIEE12C.

ODI ADMIN: -

Installation of ODI 11g on linux/Windows.

Performance tuning in ODI.

Configure Standalone and Java EE agents.

Configure with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files.

Configure ODI REPOSITORY Creation.

Tuning weblogic in ODI and java process.

Reduced run time of ETL processes from 16 hours to 4 hours for Financials/HR PeopleSoft implementation.

Primavera Admin and Integrate with Mobile application: -

Upgrade Primavera application 8.4 to 18.8.2.

Installation of Bipublisher 12.2.1.2.0 and integrate with primavera.

Configure Primavera reports with Biplublisher.

Tuning P6 slow running reports.

Experience of configured Start ETL for Primavera.

P6 Professional installation.

Integrate Primavera team member with Mobile application: -

Integrated Primavera 18.8.2 team member with iphone/android apps. This app gives team members the possibility to update the progress of their activities while there are on location.

Integrated Smart view MS-Office with ORACLE OBIEE:-

Experienced on integrated Oracle OBIEE 12.2.1.1 with MS-EXCEL Smart view 2007. Using Smart View add-in, we created a OBIEE reports from Excel/Word and save in OBIEE catalog and see those reports within OBI Presentation services and can use it for further analysis.

Integration R with OBIEE: -

Integrated R with OBIEE 12c so that users can predictive analytics, statistical analysis, advanced numerical computations and interactive graphics inside the database.

Denodo 7.0:- (PROJECT FINANCIALS,HR and Datawarehouse)

Denodo Platform provides all the benefits of data virtualization including the ability to provide real-time access to integrated data across an organization's.

Installation of Denodo platform and solution manager on AWS EC2 linux Instance.

Upgrade Denodo 7.0 to Denodo 8.0

Configuring cache for denodo views.

Enable Auditing for user access in VPD.

Create a security role for users.

Denodo backup script scheduling.

Denodo scheduler job create.

Integrated Denodo with TFS for version control.

Enable the Denodo monitoring tool.

Integrated Denodo with different data source (Oracle/ms-sql/Mongo-db).

Apply SSL on denodo.

Integrated Denodo with Tableau for data visualization.

Hands on Denodo DR

2)Birlasoft Ltd.

Designation :- SOFTWARE ENGINEER

Duration : - 09 Mar 2011 to 21 Sep 2012

Company Name: - BIRLASOFT LTD

Project :- Support- Oracle Database servers

ROLE:

Managing Production Database on RAC Environment on 10g and Standby Database on 11g, 10g, 9i. Closely Monitor all database and their performance along with team.

Data migration between environments using Export/Import, EXPDP, Transportable Table space.

Installation of 11g O.E.M(Grid).

Upgrade and down-grade the db.

Implement and maintain database security (create and maintain users and roles, assign privileges).

Working as part of a team and provide 7x24 support when required.

Establish and maintain backup and recovery policies.

Troubleshooting the PL/SQL Procedure, Trigger’s errors.

Creating a reports in oracle forms on Unix enviourment.

Creation and maintenance of Physical Standby Database.

Experience in Patching.

Up gradation of Oracle 9i to 10g.

Refresh schmea,table using Data Pump.

Cloning of Database using RMAN.

Database Performance Report Generation Using AWR.

Basic Knowledge of RAC.

3)PROGRESSIVE INFOVISION PVT LTD

Project Title : Uninor

Job Title :Oracle DBA

Domain : Telecom

Company Name:- PROGRESSIVE INFOVISION PVT LTD

Duration :- 27 OCT 2010 to 07 Mar 2011.

Responsibility: -

Installation of Oracle 9i/10g on Solaris Sparc 10

Installation of 10G agent.

Worked on ASM and O.E.M enviourment.

Enrolled users with required permission based on their roles.

Database creation for UAT and Development Environment.

Index Rebuilding, Creating Partitions and Moving Tables.

Creation of Table spaces, adding or resizing data files.

Management of RMAN Backup and Scheduling Hot or Cold Backup Through Crontab jobs.

Resolving the alerts like Instance down, Database down, Agent, Backup failures, Job Failures, ORA errors, Database, archive hung etc.

Up gradation of Oracle 9i to 10G.

Database link creations.

Database refresh using export –import.

SQL DBA :-

Experience in administration of production environment in 24*7 Environment.

Installation and Configuration of Sql Server 2005 on Window Server 2003.

Maintaining the availability of database to the team by scheduled backup and restoration.

Checking of job and maintenance plan.

Monitoring growth and Performance of databases.

4)DEEPAK SPINNER’S LIMITED (09-FEB-2009 to 03-JULY-2010)

JobTitle :- ORACLE DBA

Company Name: - DEEPAK SPINNER’S LIMITED

Duration :- 09-FEB-2009 to 03-JULY-2010

Manage the database of DEEPAK SPINNER’S LIMITED CHANDIGARH having oracle 9i and 10g database forms oracle 6i on Redhat 5 version of IBM-AX server at Chandigarh.

Responsibilities Held:

Perform general technical trouble shooting and give consultation to development teams.

Installation & configuration of oracle9i/10g database on window& Linux environment.

Monitoring the oracle application server.

Shell scripting of Logical and Physical Backup.

Scheduling the backup.

Working as part of a team and provide 7x24 support when required.

Establish and maintain backup and recovery policies.

Troubleshooting the PL/SQL Procedure, Trigger's errors.

Daily backup on Tape.

Experience in Patching.

Refresh schema, table using Data Pump.

Cloning of Database using RMAN.

Database Performance Report Generation Using AWR.

Professional Qualification:

1Master of Computer Application (MCA) Chandigarh Engineering College, Landran(Mohali)

Under Punjab Technical University with 70%(2008).

2Bsc(Non-Medical) from Gov. Post Grad. College Kullu(H.P) Under Himachal Pradesh University,Shimla with 50%(2005).

Academic Qualification:

3 12th from Gov.sen.sec.boys school,kullu under Himachal Pradesh school education board,Dharamshala with 58%(2002).

410th from Gov.sen.sec.school bhuntar(kullu) under Himachal Pradesh school education board,Dharamshala with 66%(2000).

Achievements:

1.) Received SWAMI VIVAKANAND Scholarship From H.P.S.E.B Dharamshala.

2.) Received a best engineer award from Birla-Soft.

Computer Proficiency:

Operating Systems : UNIX 5.0, Linux AS 2.1, VM Server,Win2000, WinXp, Win98.

Software Concepts : Client server Tech.

Programming Languages : C++, PL-SQL.

Front-End Tools : Visual Basic and Oracle Reports.

RDBMS’s : Oracle 8i/9i/10g,11g,12c, SQL Server2008, MS Access.

Personal Details:

Phone no. : +91-787*******/980-***-****

E.mail :adzs3s@r.postjobfree.com

Father’s name : Mr. Upender Singh

DOB : 22/04/1985

Marital status : Married

Languages Known : Hindi, English

Hobbies : listening Music, reading Books, Interaction with People.

References to be provided on request NAVNEET SINGH

Contact this candidate