Nayana Chavda

***, *********** ********, *******

Ontario l3s4p3

Email: acw5ig@r.postjobfree.com

Valid Canada PR

CARRER GOAL

An accomplished Oracle Database administrator (DBA) with expertise in technical skills and knowledge fruitful for the growth of the firm

PROFILE SUMMARY

6 years of experience in Oracle DBA

Skilled in managing and creating database in oracle 9i, 10g, 11g and 12c.

Proficient in SQL Tuning in an Oracle Environment.

Knowledge of implementation of Oracle RAC & ASM Administration/Installation

Expertise in Oracle Data Guard installation and maintenance.

Expertise in Oracle SQL/PL-SQL programming

Good command on Linux Shell scripting

PROFESSIONAL SKILLS

SQL, PL/SQL programming,Linux,Windows OS

Oracle 9i,10g,11g and 12c,RAC,Data Guard, ASM,OEM

Database & query tuning,auditing, backup and recovery, Monitoring,Migration, Upgrade

ACADEMIC CREDENTIALS

Bachelor of Engineering, A.D.Patel Institute of Technology, VIDYANAGAR INDIA (2004).

Major: Information Technology.

CERTIFICATIONS

2013-2014

Oracle 10g and 11g Certify Professional

ITS Data Solutions Ltd. India

2006-2007

Oracle 9i Certify Associate and

Oracle 9i Certify Professional

ITS Data Solutions Ltd. India

WORK EXPERIENCE

2015-Current

DBA IT ACTION Gujarat Pvt Ltd.

2012 - 2014

Fulltime Home stays Mother and

continues Professional development

2008-2012

Database engineer Elite core Technology Pvt Ltd.

2015 – Present Oracle DBA

IT Action Gujarat Pvt Ltd. Ahmedabad, INDIA

IT Action is being one of the most trusted IT solution and services partner, we focus to provide integrated Information Technology solutions. Today, besides our on-going major involvement in Indian Government sector IT projects, we have also successfully completed many overseas and local enterprise client projects. Software Development for International clients in UK, USA, Australia.

Duties & Achievements:

Database creation and management

Database security, SQL & PL/SQL

Support development team

Performing database and query tuning

Worked with Tera bytes of database

Database backup and recovery using RMAN

Managed data guard using data guard broker

Schema management

Managed Primary and standby database

Manually apply archive logs to DR Server incase need raised

Configuring and managing oracle network files like Tnsnames.ora, listener and Sqlnet files

Export and import utility using data pump

Table Partitions, exchange partitions, partition management

Diagnosed the problems by using OEM (oracle enterprise manager) utility

Oracle Apex 3.0.4. Installation and configuration

Oracle BI publisher installation and configuration

Work as a team to provide support 7*24 when required

Linux Shell scripting language

2009 – 2012 Database Engineer

Elite core Technologies, Ahmedabad INDIA

Elite core Technology is Telecommunication, Network Security and Access Gateway domains. It has Development Centre in India with Offices in India, USA, Bahrain, Dubai and Singapore and 800+ Employees worldwide

Duties & Achievements:

Installed, configured and upgraded Oracle server software and related products

Established and maintained sound backup and recovery policies and procedures

Configured and managed different types of Oracle backup (consistent and inconsistent), like Cold backup and Hot backup, user managed Manual backups, etc.

Database design and implementation as per the standard

Worked with database of size 100 GB to 500 GB with more than 10,000 users

Implemented and maintained database securities

Performed application and database tuning and performance monitoring

Worked as part of a team and provided 24x7 support

Created database schemas and objects (tables, indexes, etc.)

Diagnosed the problems by using OEM (oracle enterprise manager) utility

Created recovery catalog database in RMAN (Recovery manager) for storing backup to

Perform restore and recovery operation of database

Configuring and managing oracle network files like Tnsnames.ora, listener and Sqlnet files

Putting oracle database into read only / read write / offline / online and backup mode for various maintenance purposes

Troubleshoot performance issues by identifying bottle necks, wait events generating AWR reports, 10046, DBMS_MONITOR traces and analyzing traces with TKPROF, Trace Analyzer

Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues

2008 – 2009 Jr. Database Engineer

Elite core Technologies, Ahmedabad INDIA

SQL (structure query language) generation as per the client requirement in project

Generated report based on query

Back-end Programming using SQL and PL/SQL like procedure, trigger, function etc.

Created schemas and grant necessary privileges

Worked with different team members for query tuning

Analyzed queries executing for longer time

KPI (key performance indicator) for the application development

Identified different module of the application for the query taking more time in that module

Work in different projects like Vodafone, Airtel etc.

Identify requirements of the client, prepare document and negotiate with client

Manage three different database local, QA and remote database

Test on local database, QA and apply on remote database

Improvements of the query result with help of procedure, job etc.

Creating and managing database users and their space management, database access and their passwords/privileges/roles definition

Creating additional data files under existing table spaces as and when required for increasing table space storage

REFERENCES

Available upon request

Contact this candidate