Data Database

Summary

Having **+ years of experience as Database Administrator and have worked for Financial, Federal/State Government, Logistics and ecommerce domains. Managed invoicing, trading, tailored portfolios, hedge fund, investment banking and payment card solutions databases.

Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting. Good experience in Oracle RAC, ASM, OEM, Golden Gate and Data Guard implementation and administration. Worked on many Oracle versions (8i, 9i, 10g, 11g and 12c) in multiple operating environments such as Windows, Redhat Enterprise Linux, Sun Solaris, and IBM AIX, etc.

Experience in administering VMWare vSphere hypervisor, Cisco ASA Networks and DELL Enterprise servers. Expertise in database builds, database migration, capacity planning, etc. SQL Tuning with diagnostic tools Explain Plan, SQL Trace, TKProf, AWR, ADDM, ASH and SQL Advisors. Written many SQL, PL/SQL, Shell and AWK programs.

Education

M.Sc., Application Oriented Mathematics

Post Graduate Diploma in Computer Applications

Oracle Database 10g: RAC for Administrators Ed 2

Certification

Oracle Certified Professional

Government

US Public Trust Security Clearance

Social

https://www.linkedin.com/in/naveen-avvaru-602998120

Skills

Operating Systems : Windows Server 2003//2008, Red Hat Enterprise Linux 5/6

: SUSE Linux 11, Sun Solaris 10, IBM AIX 7, HP UNIX 11i

Databases : Oracle (8i, 9i, 10g, 11g and 12c), SQL Server 2008 R2

Languages : PL/SQL, Shell Script, awk, sed, HTML, Java Script, JAVA

Hypervisor : VMWare vSphere 5.5 & vCenter 5.5

Tools : Erwin and ER Studio for Data Modeling

: Toad for Oracle Database Administration

: RAC, ASM, OEM, AWR and ASH

: Data Guard for Disaster Recovery

: Oracle Golden Gate for Data Replication

First Data Corporation Aug 2014 – Till Date

Senior Database Administrator Jersey City, NJ

Working as Senior Database Administrator for First Data Corporation, Jersey City, NJ with a team of 12. I am providing database build & migration support for various complex financial systems like STAR Network fraud score systems, Business Track (Credit Card Merchant Reporting System), 360 Control (Comercial Card Application for Government and Banks), Global MIS (Merchant Initiation Process & POS Performance Reporting System), Mirage (Card Settlement Application), Money Network, etc. First Data is a provider of electronic commerce and payment solutions. The company's portfolio includes merchant transaction processing services; credit, debit, private-label, gift, payroll and other prepaid card offerings; fraud protection and authentication solutions, credit reporting agency services.

Role & Responsibilities

Database software installation and patchset upgrade.

EM Grid 12c agent software installation and configuration.

Install and configure RDA and OSWatcher utilities.

Configure RMAN backups using EMC Networker.

Perform data refresh from production to beta environments.

Perform database hardware refresh.

Setup Data Guard with LGWR as LTS for data replication.

Writing UNIX shell scripts for routine task automation.

Oracle Golden Gate replication setup and maintenance.

Develop and deliver Oracle database builds with live migration.

OS: Sun Solaris 10, RHEL 5, AIX 7; Oracle: 11gR2, 12cR1, OEM Grid, Datapump, RMAN, Data Guard; Golden Gate; Application: Java; Hypervisor: VMWare vSphere 5.0

Federal Aviation Administration Feb 2011 – Apr 2014

Senior Database Administrator Edison, NJ

Worked as Senior Database Administrator for Federal Aviation Administration, Edison, NJ with a team of 5 supporting Aviation Financial System databases. Federal Aviation is a part of Department of Transportation and is responsible for Airport Development, Air Traffic Control, Aircraft Certfication, Aircraft Training etc.

Role & Responsibilities

Database software installation and patchset upgrade.

Perform database deployments into beta and production databases.

Prepare database topology diagrams and infrastructure documents.

Perform data refresh from production to beta environments.

Upgrade Oracle databases from 10gR2 to 11gR2 release.

Capacity planning to meet the future database needs.

Configure & manage Oracle RAC with ASM databases.

Plan and co-ordinate data migration from legacy systems.

SQL query optimization for efficient database response.

Writing batch or shell scripts for routine task automation.

Performed database recoveries on corrupted databases due to storage issues.

OS: Sun Solaris 10, Windows Server 2003; Oracle: 11gR2, RAC, ASM, OEM Grid, Datapump, RMAN; Application: Java, ColdFusion; Hypervisor: VMWare vSphere 5.0

JP Morgan Chase & Co. Aug 2010 – Dec 2010

Senior Database Administrator Jersey City, NJ

Worked as Senior Database Administrator for JP Morgan Chase & Co., Jersey City, NJ. JP Morgan Chase & Co. is one of the world’s oldest, larget and best-known fianancial institutions with over 200 years of history. The firm is a leader in investment banking, consumer banking, commercial banking, asset management and private equity. I work in Global Technology Infrastructure group with a team of 20 supporting over 800 databases operating on Sun Solaris, IBM AIX and Redhat Linux.

Role & Responsibilities

AWR reports generation to find the performance issues

Resolving service center tickets

Preparing disaster recovery plans for databases

Building production, development and test database servers

Performing database patching and upgrades

Implementing database code changes into production databases

Resolving data guard sync issues

Monitoring Autosys and Control M jobs

Install and configure OEM Agents

OS: Sun Solaris 10, IBM AIX 5, RHEL 5; Oracle: 10gR2, 11gR2, RAC, ASM, OEM Grid, Datapump, RMAN; Storage: VxVM, Veritas Clusters, EMC SAN; Application: Java

FedEx Aug 2009 – Jul 2010

Senior Database Administrator Pittsburgh, PA

Worked as Senior Database Administrator for FedEx, Pittsburgh, PA. FedEx is a leading logistics services company based in the United States. I work for FedEx Ground division managing OLTP and Data Warehouse databases with mid to large size (8TB) and high transactional volume (upto 10TB I/O per Day) of total 190 operating on HP-UX, Sun Solaris and Redhat Linux with a DBA team of 5.

Role & Responsibilities

Capacity plan reports generation and preparation for peak season work load

AWR reports generation to find the performance issues

Identifying database performance issues and fixing them

Applying to database releases to production databases

Deployment of HA solution using 10g 5-Node/8-Node RAC on HP-UX/RHEL

Monitoring RAC interconnect traffic and eliminating contention

RAC specific performance tuning, implementing load balancing and TAF

Install, maintain and troubleshoot CRS (Cluster Ready Services)

Database administration using Enterprise Manager Grid Control

Database tuning with Explain Plan, TKProf and SQL Trace

SQL Tuning and optimizer adjustment for performance improvement

Performing data refreshes from production to stage environments with datapump

Recommendation on hardware upgrade/changes to business groups

Setting HA databases with RAC/ASM and implementing load balancing and TAF

Database performance and tuning using AWR, ADDM and Advisors

Implemented compression and partition on warehouse tables

Disk partition, iSCSI and RAID configuration in Windows, RHEL and Solaris

Shell and PL/SQL scripting for database automation

Installed and configured unidirectional Golden Gate replication

Used Golden Gate log dump utility to scan log file contents.

Configuring databases with OEM and troubleshooting OEM issues

OS: HP-UX 11i, Sun Solaris 10, RHEL 4; Oracle: 10gR2, 11gR2, RAC, ASM, OEM Grid,OID, Datapump, RMAN, Oracle Golden Gate; Hardware: HP rx6600, VxVM, Veritas Clusters,Veritas Storage Foundation, EMC SAN; Application: Java

Blockbuster Feb 2009 – Jul 2009

Senior Database Administrator Dallas, TX

Worked as Senior Database Administrator for Blockbuster Inc., Dallas, TX. Blockbuster is a leading global provider of in-home movie and game entertainment, with over 7,400 stores throughout the Americas, Europe, Asia, and Australia. I am involved in managing the store online and warehouse databases with a team of 4. The production databases are of size close to 5 TB.

Role & Responsibilities

Analysis of performance issues and finding remediations

Periodic statspack and AWR reports generation to find the performance issues

SQL query tuning and optimization

Performing development database user requests

Database logical design with star or snowflake design patterns

Data loading and extracting using SQL * Loader

Day-to-day administration tasks and support to development requests

Implementing partitioning on tables and indexes for faster search results

Database migration using cloning and schema migration using data pump

Performance analysis of indexes and their usage

Relational data modeling using ER Studio

Debugging of SQL & PL/SQL for performance issues

Application tuning with Explain Plan, TK Prof, SQL Trace, Analyze and Hints

Installation of Grid Control and configuring databases to Grid

Fixing block corruptions occurred in table or index segment

Creating and maintaining database links and materialized views for reporting purpose

Database performance monitoring and tuning required components

Preparing data center migration plans, scripts and documents

Worked on data center migration from IBM data center to AT&T data center

Writing PL/SQL functions, procedures, packages and triggers

Creating user accounts, roles and profiles

Data refresh from production to test databases

Performed compression on tables in warehouse environment to manage space

OS: IBM AIX, Sun Solaris 10; Oracle: 10gR2, 11gR1, RMAN, OEM Grid,ER Studio; Hardware: Sun M5000, M8000 Enterprise Servers,VxVM,Veritas Cluster, EMC SAN Storage; Application: Java, J2EE

Vitech Systems Group Inc. Jun 2008 - Nov 2008

Senior Database Administrator New York City, NY

Worked as Senior Database Administrator for Vitech Systems Group Inc., New York City. Vitech Systems Group is a software solution provider for retirement, health & group benefits, private equity, hedge and alternative asset administration. I am involved in managing the 50 client production environments and 400 in house databases with a team of 4. I am involved in setup and administration of MAA (Maximum Availability Architecture) with Data Guard and RAC technology for different client production environments.

Role & Responsibilities

Preparing Migration Strategy and plan for hardware migrations

Writing generic scripts for traditional clone and transportable tablespace migrations

Migration of databases using traditional clone or transportable tablespace method

Preparing RMAN scripts for incremental/full backups and recoveries on ASM

Migration of databases from windows and UNIX to Linux operating system

Performing point-in-time recoveries using RMAN on production databases

Implementing MAA (Maximum Availability Architecture) with Data Guard and RAC technology for different client production environments

Implementing offsite tape backup solutions

Working with Oracle Support on various issues related to core product or clusterware

Resolving application performance issues after database upgrade to 10g

Tuning SQL, database and optimizer components for optimal database performance

Applying CPU patches to databases to single instance or RAC databases

Adding database connect strings in OID for centralized service naming

Monitoring and administering log transfer and apply in Data Guard environments

Performing switchover and failover tests with or without Data Guard Broker

Writing SQL scripts for measuring database I/O and memory usage

Generating AWR reports to review and fix database performance related issues

Attending business meetings with customers to understand the database support needs

Routine database health check monitoring and reporting to management

Performing product certification on different operating systems and their versions

Implemented flashback recovery mechanism for faster media recovery

Environment

OS: Red Hat Enterprise Linux, Windows Server 2003; Oracle: 10gR2 Data Guard, RAC, ASM, RMAN, OEM Grid, DBArtisan; Hardware: DELL Power Edge Servers, DELL AX SAN Storage; Application: Java, J2EE

Citibank Dec 2005 - May 2008

Senior Database Administrator New York City, NY

Worked as Senior Database Administrator for Citi Private Banking, New York City supporting different business groups like Trading, Investment Banking, Tailored Portfolios, Business Intelligence, Global Wealth Management and Customer Care etc. There were more than 220 databases of various sizes ranging from 100GB to 3TB VLDB (OLTP and Data Warehouse) with Dataguard and RAC configured for 24X7 business operations.

Role & Responsibilities

Preparing Capacity Plan Reports for new databases

Preparing Migration Strategy and plan for hardware migrations

Doing database releases for database related change requests

Writing shell scripts for task automation of database maintenance and monitoring activities with email, sms and pager notifications

Attending business meetings with customers to understand the business needs and for hardware procurement

Setting database administration standards and preparing DBA Handbook

Preparing MIS reports with database health statistics and performance related issues

Applying version upgrade, security (CPU) interim patches to databases

Installing Oracle and creating production databases with Data Guard setup

Involving database auditing and inventory preparation

Gathering db & system statistics for database performance monitoring and tuning

Performing database migrations using traditional clone or transportable tablespaces

Configuring and administering Oracle RAC clusterware components

Setup standby databases with or without Data Guard option

Performing Data Guard switchover while maintenance

Performing Data Guard failover while disaster scenarios

Monitor and maintain standby databases

Implementing SOX audit standards

Database patchset migrations and version upgrades

Performing mission critical recoveries

Review and fix ADDM findings reported in 10g EM Grid

Environment

OS: Sun Solaris 5.8; Oracle: 9iR2, 10gR2 Data Guard, RAC, RMAN, OEM; Hardware: SUN Midrange Servers, EMC SAN Storage, SRDF, BCV, VxVM, Veritas Clusters, Veritas Netbackup, IBM Tivoli,Autosys; Application: Java, J2EE, Informatica

Department of Mental Retardation Jul 2005 - Nov 2005

Database Administrator Boston, MA

The Department of Mental Retardation, Boston, MA is a state agency of Health and Human Services, Commonwealth of Massachusetts for disabilities and community services which provides a wide range of services and support to adults with mental retardation or children below 18 years of age with developmental disabilities. I am here as a Database Administrator for managing Oracle databases through vendor Deloitte. I am involved in the design phase of Home and Community Services Information System which is called as HCSIS. HCSIS is web based software that allows vendors to electronically file clinical information and incident reports on DMR consumers and enables DMR to respond more promptly to individual events as well as emerging trends and patterns.

Role & Responsibilities

Creating and maintaining all databases required for development, testing, training and production

Performing ongoing tuning of the database instances

Controlling migration of programs, database changes, reference data changes and menu changes through the development life cycle

Implementing and enforcing Fine Grained Access Control future in Oracle databases

Performing database re-organizations as required to assist performance and ensure maximum uptime of the database

Reviewing and administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures

Developing and managing all Oracle batch programs

Developing complex stored procedures

Preparing Capacity planning reports taking the previous production information

Performing PL/SQL code reviews for maintaing standards

Identifing inefficient SQLs and rewriting such SQLs

Implementing FGA, roles and privileges for virtual database security

Tunig SQLs and PL/SQL using Explain Plan Report

Preparing replication strategy and identifying replication objects

Setting replication process for databases in different environments

Creating schema objects like tables, indexes and sequences etc.

Database logical design and data modeling using Erwin

Estimating of undo segments & temp segments space requirements for application

Environment

OS: Windows Server 2000; Oracle: 9.2.0.5, 10.1.0.3, Erwin 4.1, MS SQL Server 2005; Application: Microsoft .net

Yodlee Oct 2003 - Feb 2005

Database Administrator Bangalore, INDIA

Worked as Oracle Database Administrator in Yodlee, supporting the Data Aggregation, Funds Transfer and Direct Bill Payment products for international financial organizations AOL, Yahoo, Citi Bank, Bank of America, American Express, Funds Express and Fedility Investments etc. I was supporting 250 Production (OLTP), QA, Development, Content and Dataware House databases with 3 other DBAs

The environment was Sun Solaris, RH Linux with Oracle of versions 8i, 9i and 10g. Despite of routine DBA activities, I was involved in the process optimiation and database documentation. Automated many processes such as DIEt (Data Import and Export Tool), SUM (Software Update Manager) and Push Prd etc. Actively involing in Schema Change Management Process (dbcabal), design changes of application and implementation of new features. Written many Korn shell scripts for database monitoring and ease to maintenace. Involved in production maintenance activities such as managing datafiles using Veritas Quick I/O, identifying and resolving performance bottle necks, statistics gathering etc.

Role & Responsibilities

Performing normalization for databases at design level

Preparing logical layouts and reports of database using Erwin

Performing logical backups using data pump (10g) and validating RMAN backups

Identifying poor performing SQLs and invalid indexes and fixing

Providing guidelines to co-developers in writing SQL, PL/SQL Code

Tuning application by using diagnostic tools Explain Plan, TK Prof and SQL Trace

Monitoring hit ratio of every database frequently and tuning SGA parameters

Identifying columns that do not have indexes and creating appropriate indexes

Scheduling jobs, ad-hoc backups and monitoring wait events using OEM

Monitoring database performance and tuning databases using statspack

Writing shell scripts for database monitoring & maintenance

Analyzing and approving schema changes for implementing new features

Resolving the tickets issued in Remedy by customers for production support

Involving in database up gradation (E.g. 8i to 9i, 9i to 10g) activities

Managing high availability groups and configuring listeners on cluster environment

Monitoring file system processes, iowait and disk & swap space

Preparing RMAN scripts for database backups and recoveries

Implementing 10g features like ASM, Flashback and RMAN compression etc.

Environment

OS: Sun Solaris 5.8; Oracle: 8.1.7, 9.2.0.5, 10.1.0.3, RMAN, Erwin 4.1; MySQL 4.0; Hardware: Sun Midrange Servers, EMC SAN Storage, Veritas Cluster; Application: Java, J2EE

Citibank Sep 2001 - Sep 2003

Database Administrator Tampines, Singapore

Worked for Citibank, Singapore (1 Year in Chennai, India and 1 Year in Tampines, Singapore) as database administrator supporting Citi Private Banking databases. My role and involvement partakes in Oracle database support and logical database design for the products Ecollect and Orbi Integrator. Ecollect is a central cheque processing system. Orbi Itegrator is a message communication tool that transfers messages in SWIFT parser among banks. As database administrator, I was involved in routine database administration tasks which were listed below and in data migration of CPC (Cheque Processing Centre) from Informix database to Oracle 9i using SQL * Loader and UNIX Korn shell scripting.

Role & Responsibilities

Installation of Oracle 8i product and its related tools

Database creations at various environments development, SIT, UAT and production

Data Modeling using Erwin

Managing of tablespaces for different users by granting quota on default and temporary tablespaces

In writing PL/SQL stored procedures, functions, triggers to meet new features to be incorporated in the system to implements business rules

Planning backup and recovery procedures and preparing RMAN scripts

Tuning of database after testing before making it online

Tuning databases for better performance. Tuning SGA and tuning the production database by altering the parameters

Application tuning, performance tuning and optimization

Resource monitoring and space management

Tuning SQL Queries by using Explain Plan, TK Prof and SQL Trace

Tuning of Oracle objects like rollback segments, temp segments etc.

Identifying and resolving resource contention

Maintaining security of the Oracle database

Data migration using SQL * Loader

Setting replication process and preparing scripts for data replication

Preparing utility scripts for database activities monitoring and maintenance

Preparing shell scripts for database maintenance and monitoring

Environment

OS: HP UNIX 11i, Sun Solaris 5.8; Oracle: 8.1.6, 9.2.0.4; Application: Java, Weblogic 6.1

Contact this candidate