Database Manager

Nitesh Ariga

Email: ***********.******@*****.*** Mobile: 609-***-****

Professional Summary

8+ years of professional experience as an Oracle Database Administration in the Database Installation, Development and Production System Supporting leading global teams in a wide variety of cutting edge environments.

In-depth knowledge and experience in full life-cycle database including data architecture, logical and physical database design, implementation, and administration

Experienced in database administration of 9i/10g/11g databases on heterogeneous and complex Datacenter environment

Experienced in Migrating databases from file systems to ASM

Experienced in implementing Real Application Clusters (RAC) on a variety of Oracle versions (10G,11GR1 & 11GR2) on Linux

Hands on experience on SQL Server 2012 HA Techniques (Log shipping, Mirroring).

Good exposure on Backup & Restore in SQL Server 2008 & 2012.

Configured MS SQL Server cluster on Windows Server 2008

Experienced in upgrading databases from one version of oracle to higher version

Opatch Installation/Upgradation on recommendation by Oracle.

Experienced in configuring Disaster Recovery Site for single instance and RAC databases

Experienced in various scenarios of Database Recovery and troubleshooting.

Experience in Replication/Cloning of production databases for creation of DEV/UAT environments.

Solid skills in database optimization and performance tuning for servers, applications, and SQL queries

Applying the CPU/PSU patches to fix the existing bug as per the Business policy

Installation, Configuration, Administration and Patching of Grid Control / Oracle Management Agents

Experience in data migrations using data pumps between various environments

Implemented partitioning for better load balancing of data and to ease data purging in archival activities.

Experience in Implementing RMAN backup with Recovery catalog and optimizing the backup timing and utilization of backup resources and fast recovery of the system in case of Failure.

Experience with Oracle Enterprise Manager Monitoring/Performance Tuning/Real Time Advisor.

Experience on SQL Performance analyzer(SPA) and SQL Plan Management (SPM)

Experience using TOAD and SQL developer for database activities and monitoring.

Technicalskills

Databases: Oracle 11g/10g/9i,SQL Server 2012

DBA Tools: Oracle Enterprise Manager (OEM) 12c/11g/10g Grid, RAC, Active Data Guard, Putty, GoldenGate, SQL*Plus, Toad, Recovery Manager (RMAN).

Operating Systems: Solaris 10/9/8; Red Hat Linux EL 4/5/6, UNIX 5.1/5.1a/4.0, IBM AIX

4.3.2/4.3.3, Windows XP/NT/2000, HP UX 11.00/ 10.20

Languages: ShellScripts, SQL, PL/SQL.

Education

Bachelor of Technology, Jawaharlal Nehru Technological University Hyderabad, India

Work experience

Client:Orbitz –Chicago,IL July 2014– present

Title: Sr. Oracle Database Administrator

Environment: Oracle11g, Oracle10g, Solaris 10, Linux, OEM grid, RMAN, SQL, Oracle EE, RAC, PL-SQL, ASM, CRS, XML, TOAD

Responsibilities:

Installation and configuration of Oracle Database Software 10g on Solaris, AIX with 2 nodes RAC with ASM in development, integration, Production Environment.

Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.

Implement DBMS_SQLTUNE to fine tune the database.

Created 10g databases using DBCA on HP-UNIX, ZLinux platform.

Schedule jobs in crontab including RMAN backup and other memory maintenance, security jobs.

Worked on DBMS SCHEDULER.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Created standby database and worked with data guard to provide high availability.

Partitioned appropriate tables to optimize performance and simplified maintenance work.

Auditing and security with Oracle databases.

Created and Managed user, tablespaces, datafiles, archive log.

Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.

Created physical standby database (for disaster recovery) from hot backup of primary database.

Resolved gaps between primary and standby databases (Gap Resolution).

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Involved in performance monitoring and tuning of the database by fine tuning the database implementation.

Backup and Recovery using RMAN.

Migrated databases from Oracle 10.2.0.2 on window 2003 to Oracle 10g on Linux development, integration, production environment using Import/Export.

Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the Stats pack report generated from snapshots taken at the peak business hours.

Support application team to solve any issues in Production Environment.

Provided 24x7 on-call production supports.

UNIX Shell scripting for backup and monitoring of databases.

Client:AstraZeneca, London, UK July 2013 – may2014

Title: Sr. Oracle Database Administrator

Environment: Linux, Sun Solaris, Oracle 10/11g, ASM, RAC, RMAN, SQL, PL/SQL, Golden Gate, UNIX scripting

Responsibilities:

Involved in installation, configuration and support of Oracle 10g RAC.

Providing 24x7 on call support for the business critical production real application cluster (RAC) databases.

Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.

Performed Database upgrade/migration from Oracle 9.2.0. To 10.1.0.3.

Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.

Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files.

Configured maintenance plans for SQL Server Database backups.

Working with the application support people to resolve database related issues and running the scripts for the application support people.

Creating users and database links, snap shots on production and development servers.

Schedule cronjobs and monitoring application specific background processes.

Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Stats pack.

Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.

Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.

Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.

Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.

Managing, troubleshooting and resolving oracle database, RAC and applications issues.

Was involved in developing a disaster recovery (DR) plan.

Performing Backup/Recovery of all the Oracle databases using RMAN.

Scripts for Health Check of Databases.

Configured SQL Server Log shipping from Primary datacenter to DR Datacenter in SQL Server 2008.

Expert scripting experience in Perl and all UNIX shell scripting variations.

Reading Alert Logs and User trace Files and Diagnosing the Problem.

Providing Solutions to the Problems Faced by end Users or Programmers.

OS level activities like space monitoring of Mount points.

Interfacing with Oracle Corporation for technical support.

Client:-PHH Mortgage, Jacksonville, FL Jan 2011 - May 2013

Title:Oracle DBA

Environment : Oracle10g, Oracle9i, Solaris 10, windows 2003 Server, AIX, Zlinux, HP-Unix OEM grid, RMAN, SQL, Oracle EE, PL-SQL, ASM, CRS, XML, TOAD, RMAN

Responsibilities:

Oracle RDBMS Installation and RAC Installation

Create and Manage the database on standalone and RAC environments

Build Data Guard setup for disaster recovery

Recover standby sites using incremental backups

Recover block corruptions using RMAN

Migrate databases from non-ASM to ASM

Database upgrades from 10g to 11g

Support as primary on-call DBA in 24/7 production environment

Apply CPU Patches quarterly basis

Monitor OCR & Voting Disk backups

Perform regular RMAN Backups

Performance monitoring using AWR, ASH and ADDM reports

Database refreshes from production to reporting, development and test environments

Database administration, managing table spaces, objects and disk space

Configure and Install automated Alert Monitoring scripts using Shell scripts

Written Stored Procedures and Triggers, functions, cursor for database maintenance and management using PL/SQL.

Take Backups through RMAN and Export's

Troubleshoot and reschedule the failed backups

Recovery of database in case of media crash using Cold, Hot, Import, RMAN methodologies

Understand the problem from the database perspective and troubleshoot

User Management, providing connectivity and troubleshooting of connectivity problems between different databases and client computers

Refresh the databases from production environment to Dev and Test, as per the client requirements

Developed PL/SQL triggers and master tables for automatic creation of primary keys

Add space to the tablespace and configure the monitoring alerts for tablespace health check

Create the users and assign the appropriate profiles

Manage redo logs, checking alert log and trace files for errors

Prepare and review of Call, Task Trackers and Metrics in correspondence to SLA Adherence, and preparation of causal analysis and action plans on SLA deviation

Proactively analyze the outage window of the servers

Client:VISTEX, Chicago, IL Jun 2007 –Dec 2010

Title:Oracle DBA

Environment:Oracle Database (9i, 10g), Shell Script, PL/SQL, TOAD, SQL Developer, OEM Grid Control, RAC, SQL loader, TKPROF, Sun Solaris 5.9, Windows 2000/XP

Role & Responsibilities:

Managing users, roles & privileges, backup & recovery procedures using daily hot backups and weekly cold backups.

Primary DBA for production, development and testing databases. Install and configuring Oracle database 9i, 10g, Linux. Implemented 10g flashback database features. Extensively worked on SQL Tuning using AWR, ADDM, ASH and tuning advisor in Oracle 10g.

Performance tuning expert for all Oracle Application and Database Products.

Used various data movement utilities like export, import and Load, Planning

Performs DB/Application patching, DB/Application Cloning, Install DB & Application Server, troubleshoot issues/errors, DB/Application Maintenance using manual approach and OEM R1, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Monitored and tuned the Shared Pool, Database Buffer Cache and Redo Log Buffers for best performance. Troubleshooting and Recovery of Database from Data file losses. Backup and Recovery involving archiving, redo logs, data files using RMAN

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Loading the data using SQL Loader.

Evaluated new features and enhancements in later versions of Oracle (10g) for possible implementations like Data Pump (EXPDP/IMPDP), Transportable Table spaces, External Tables and Partitions

Oracle Database and SQL tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.

For testing the software, I have tested different scenarios like database creation, software installation, node addition, node deletion, database upgrade in RAC environment.

Configure listener and local service names to use load balancing, failover, dynamic service registration and multi-threaded architecture for shared servers, RAC and data guard databases. Also use naming servers, hostname and service name resolutions depending on the connections requests

Creating users and database links, snap shots on production and development servers.

Modified and maintained database structures and views for the core system.

Planning and implementing Backup strategy for the databases using RMAN, Scripting backups, once in two weeks on the application database.

Experienced in dealing with Query execution plan, SQL trace, TKPROF.

Contact this candidate