Database Manager

Deepak Gangadharappa acroyk@r.postjobfree.com

Chantilly, VA 347-***-****

Professional Summary

Highly accomplished DBA Manager for Data Center Services with over 17yrs of work experience & Certified Scrum Master. Implements streamlined operations of infrastructure services for large enterprises with a focus on database management services. Ensures business objectives are met effectively and efficiently.

Managing 9 Data centers that supports over 1550 Oracle database & 3500 SQL server databases spread across 1000 servers on all platforms (HP-UX, AIX, Linux, Windows & Solaris).

15 years of experience in Oracle Database Administration including Oracle Database 12c, 11g, 10g, 9i.

Strong background in architecting large databases with High Availability solutions (DataGuard, RAC & GoldenGate) & hands on experience with creation & maintenance.

Maintained infrastructure availability and stability at 99.9%.

Experienced in designing, creating, implementing & supporting large databases for mission critical apps.

Cloud computing experience in AWS for Non-prod environments.

Capacity Planning and storage designing and administration.

RMAN Backups and Recoveries with DR planning and testing.

Managed licensing costs & improved SLA metrics for the environments by 45%.

Experience on OEM, Grid Control & Sitescope for monitoring and alerting solutions.

Expertise in database design and implementation, proactive performance tuning, and database enhancements.

Lead database projects, prepare project plan, create deliverables, perform resource & project coordination.

Supporting very large databases (VLD) up to 19TB in size and implemented partitioning in the Data Warehouse environment.

Patch management & performing upgrades for Oracle & SQL Server database env on a timely basis on Standalone/Standby servers.

Good knowledge and understanding of Teradata, SQL Server, PostgreSQL & Amazon Web Services (RDS & EC2).

Team player with excellent interpersonal, analytical and communications skills

Work History

Oct 2011 – present Capital One, VA Sr Oracle DBA/Manager

Feb 2007 – Oct 2011 Capital One, VA Sr. DBA Consultant

Sept 2006 – Feb 2007 Time Warner Cable, PA Sr. DBA Consultant

Mar 2005 – Sept 2006 MCare - Univ of Michigan, MI DBA Consultant

Aug 2004 – Feb 2005 Zenith Insurance, LA DBA Consultant

May 2002 – July 2004 Khodayss Systems Ltd, UK DBA

Jan 2001 – May 2002 Madras Refineries Ltd, India DBA

May 1999 – Dec 2000 Khodayss Systems Ltd, India DBA

Oct 1998 – Apr 1999 Multimedia Studio Systems, India Programmer Analyst

Technical Skills

Certifications: Certified Scrum Master, Certified Product Owner

RDBMS: Oracle 11g,10g/9i/8i/8, AWS RDS, SQL Server 2000/2005, Teradata

Operating Systems: Sun Solaris 2.7, HP-UNIX, Win 98/NT/2000, Linux, AIX

Languages: Java-script, PL/SQL, Shell Scripts

GUIs: Oracle Enterprise Manager (OEM), Grid Control.

DBA Tools OEM, SQL Loader, Grid Control, TOAD

Professional Courses: Project Management Professional

Education

MBA (General Management), Oxford Brookes University, Oxford, UK

BE (Computer Science), S J C E, Mysore University, INDIA

Professional Experience

Capital One, VA – DBA Manager Oct 2011 – present

Responsibilities

Supporting 1500+ dbs & largest Production database being 19TB in the Data Warehouse env.

Managing the database administration for production, test and development platforms including planning, coordination and execution.

Moving non-prod databases into AWS RDS.

Oracle Database Configuration, Tuning, Patch Administration; TAR Reporting, Tracking & Coordination.

Providing a consistent env to support all DBA’s by automating scripts & to improve efficiency.

Working with various teams to provide infrastructure & database support.

Working with other technical teams and customers to develop strategic direction to achieve cost efficiency and high availability.

Installed and manage Physical Standby databases on Unix/windows platforms.

Database Capacity Planning and requirements gathering to logical and physical modeling, design, development, testing and implementation.

Responsible for implementing SiteScope & custom monitoring scripts on all production and staging/development systems.

Responsible for all security patches, upgrades, maintenance and performance tuning activities for all databases.

Certified Scrum Master & Product Owner managing Agile – Kanban board for all Projects.

Moved the backup solution from TSM to CommVault.

Database performance management and tuning using AWR, ASH

Oracle Data Pump, export-import, partitioning, mat-views

Consistently improved Compliance & Audit scores.

Working with App teams to move to Amazon Web Services – Cloud (AWS - RDS).

Led Integration efforts for CRS & 360 into Capital One – Enterprise Data center.

Consistently improved SLA’s on Incidents, events & reporting.

Providing weekly & monthly reports to senior management

Responsible for defining and communicating project milestones, service level agreements, and resource allocation to executive team, department leads, support staff, and end users.

Review performance of IT systems to determine operating costs, productivity levels, and upgrade requirements.

Developing business case justifications and cost/benefit analyses for IT spending and initiatives.

Developing and implementing all IT policies and procedures for DBA Services

Responsible for managing IT staffing, including recruitment, supervision, scheduling, development, evaluation, and disciplinary actions.

Insourced Production support from outsourced company (IBM)

Environment – AWS RDS, EC2, Oracle 9i, 10gR2 and 11g on Solaris, HP-UX, Windows and AIX platforms, SQL Server 2005/2008, PostgreSQL

Capital One, VA – Sr Oracle DBA Consultant Feb 2007 – Oct 2011

Responsibilities

Responsible for database administration for production, test and development platforms including planning, coordination and execution of db sizes from 20Gb to 2.5TB.

Oracle Database Configuration, Tuning, Patch Administration; TAR Reporting, Tracking & Coordination

Good knowledge and understanding of Teradata.

Coordinating Backup and Recovery operations over all databases, ensuring 100% recoverability

Monitor and analyze user / process / file system usage and performance indicators

Monitor and analyze file system / database growth patterns, make recommendations, and implement required changes.

Installing and configuring latest Oracle Application Server(10.1.3.1) on Linux Servers.

Provide all support related issues for databases and application servers in client.

Comply with Change and Configuration Management standards.

Develop, maintain, and monitor documentation and procedural standards relating to all database projects.

Changing NLS Character set and performing technical reviews.

Providing advice and support for the Program Manager in achieving overall project goals, including quality, schedule, staffing and cost metrics

Work outside usual hours of business in order to support servers, systems, and services without impeding access to these servers and services during usual business hours.

Design, implement and modify physical database structures; evaluate, test and implement database management systems, utilities and tools.

Used Basic Teradata Query (BTEQ) Facility extensively for interactive and batch query processor/report generator

Well versed with Teradata Manager Suite for Performance Monitoring (PMON), Statistics and Alert management.

Very good understanding of Partitioning Primary Index (PPI).

Worked on data loading tools like FastLoad, FastExport, MultiLoad and Tpump

Involved in large scale database management & system upgrade.

Used HP Service Desk and Erwin tools to model.

Working with ETL developers to meet the standards and requirements.

Create new SQL Server database/instances (2000/2005). Implement requested dbs modifications designed by architecture team.

Perform backup and restoration of SQL Server Test/Dev/QA dbs between servers.

Supported SQL managed regions along with experience on SQL Server database installation, configuration, Partition Tables, tuning & security configuration etc.

Applying SQL Server patches like SP2 and latest MS patches on a timely basis, performance & capacity planning.

Generate User and Technical Documentation; Troubleshoot performance issues

Environment: Unix/Linux/AIX, Oracle (9i/10g/11g), 10gAS, SQL Server 2000/2005, HP Service Desk, Teradata.

Time Warner Cable, PA - Sr. Oracle DBA Consultant Sept 2006 – Feb 2007

Responsibilities

Performed primary DBA support for establishing, upgrading and maintaining OLTP Oracle database environments.

Maintenance, monitoring and reporting of Service Level Agreements

Responded to critical production incidents 24x7.

Provided communication needed to maintain well-managed platform

Improved efficiency and ensure backup/recovery procedures.

Established and followed best practices for enterprise monitoring, troubleshooting and maintenance.

Created, maintained and refreshed required instances/dbs for development, test and production environments on Unix.

Monitored database and log space, error logs and resource utilization of prod env.

Maintained up-to-date plans for disaster recovery and fail over capabilities test accordingly.

Performed capacity monitoring, short term and long term capacity planning working with development resources, system administrators and system architects.

Used and deployed of DBMS software, data management tool and utilities, data warehouse and replication tools.

Experienced on OEM Grid Control and Veritas Control Center.

Moved databases from Netbackup to Veritas Netbackup.

Environment: Sun Solaris, HP Unix, Windows, Linux, Oracle (8i/9i/10g), OEM, SQL Server 2000.

MCare, Univ of Michigan, MI - Oracle DBA Consultant Mar 2005 – Sept 2006

Responsibilities

Database Administration for Data warehouse environments, Production and Development Databases.

Supported a 300gb production data warehouse.

Built more than 15 databases for the development and testing teams.

Migrating Production Database from one Unix server to another creating test and development databases.

Installed and manage Physical Standby databases on Unix/windows platforms.

Managed and maintained 9i RAC.

Monitor database size / growth and perform space allocation on an as needed basis and project additional disk space needs.

Setup and monitoring of full databases backup strategies

Write shell and Perl scripts as needed for monitoring and automation.

Security and critical patch installation for the databases

Created table partitions to improve performance and execute batch processes to balance I/O load.

Controlling and monitoring the programmers/users access to the databases.

CronTab Setup for daily/weekend jobs to run on the Unix servers.

Ensure that all database and database environment changes follow company

change control procedures.

Disk Space Management for Data files and monitoring the table spaces for space requirements

Databases Performance Tuning for Production and Development

Responsible for Oracle database installation and configuration on Unix.

Monitoring and managing all databases for the on line applications.

Experience on OEM Grid Control and Veritas Control Center.

Available for non-business hours support and work when necessary.

A fair knowledge of handling Network Protocols.

Environment: HP/UX 9000, Windows 2003 Server, Linux, Oracle (8i/9i/10g), SQL Server 2000, OEM, OMS

Zenith Insurance, CA - Oracle DBA Consultant Aug 2004 – Feb 2005

Responsibilities

Worked in the IT Enterprise and Database Management group.

Created database of 280Gb with over 1500 users and control files.

Loading and exporting/importing the data between two databases.

Backend/Integration testing the application on the database and managing the user access to database.

Developed comparison scripts to assist in syncing database objects between databases.

Data-modeled and reverse engineered using ER/Studio and TOAD.

Planned for capacity, space and performance tuned using OEM tools.

Provided ongoing development support in the form of full and partial migrations from partial migrations from development through production databases using the export/import utilities.

Provided ongoing coverage and support for any problems associated with availability, performance and accessibility

Database migration from 8.1.7.4 to 9.2.0.4.

Planned all disk space allocation and load balancing.

Designed and implemented backup and recovery scripts for Oracle on HP Unix box.

Performed periodic reorganizations to optimize database performance.

Implemented procedures for monitoring table and Index problems.

Communicated plan and strategies for future storage and hardware requirements.

Ensured all aspects of database were documented to company standards.

Environment: HP/UX, Linux, Oracle (9i/8i), OEM, TOAD, ER/Studio, RMAN, SQL Loader, SQL*Plus

Pursued MBA from Oct 2002 – Aug 2004

Khodayss Systems LLC, UK - Oracle DBA May 2002 to July 2004

Client: In house

This system is used for sales / payment processing, product catalogue, inventory control and monitoring at a manufacturing company that generates automobile spare parts. The modules in this system are payment processing and inventory. This system will maintain a huge number of products divided into categories and sub-categories and tracks current inventory levels, orders placed against each of them and payments pending.

Responsibilities

Installation of Oracle 9.0.1 on Windows / Solaris environments.

Database design and creation of table spaces, users, tables and indexes, providing parameters to these objects during creation time.

Planning and configuring storage strategy and reducing I/O contention by placing different data files on different disks.

Setting up and configuring client to server communication.

Tuning the database, optimizing SQL queries using DBMS_STATS package (DB Tuning), monitoring for dead locks and avoiding them.

Taking Online/ Offline and Logical backups at various levels.

Using of Recovery Manager (RMAN) technique in database backup and recovery

Environment: ORACLE 9.0.1, ORACLE 8.1.7, Sun SPARC Solaris, Developer 2000, SQL*Plus, PL/SQL, Windows NT / 2000.

Madras Refineries Ltd., Chennai - DBA

Client - K Lang Container Terminal – BHD, Port, Malaysia. Jun 2001 to May 2002

The package is developed to manage the activities in all Malaysian Ports. This system is mainly classified into In yard Operating, Export containers management, Import containers management, Empty container management This system is to keep track of container movement from receivable at entry gate to loading in the ship to delivery to customer. The system having interface with other system like KCTNET (Internet tracking container), Touch Screen, Tele Client, HHT (Hand Held Terminal), VHT (Vehicle held Terminal), Time Attendance System ECT. The scope of the project includes Financials and HRMS.

Responsibilities

Leading the DBA team in all the phases of this upgrade process.

Instance strategy for the upgrade runs in all testing phases.

Strategy for applying of patches found in the Testing process.

Involved in development of the interface between the GUI and the Database.

Plan, implement and test Backup and Recovery strategies for the client.

Suggesting Alternate Solutions to the client needs and working on their database design.

Responsible for planning Upgrade and Migration of the Oracle databases.

Responsible for trouble shooting development and production databases using Metalink and by getting the solutions / patches from Oracle Support, Oracle Corporation.

Modifying the database structure, as necessary, from the information given.

Creating primary database storage structures (table spaces) and database objects.

Development of SQL scripts for reports.

Involved in the module level project management with a team size of 10.

Environment: HP-UX 11.11, Windows NT/2000, SQL, PL/SQL, Developer 2000

Madras Refineries Ltd., Chennai, India - DBA Jan 2001 to May 2001

This project automates the procedure of process and stores ledger processing. This project deals in three main departments Planning, Purchase and Stores. In Planning, this gets the indent/requisition from the processes the indent and sends it to the Purchase dept. In the Purchase dept, it sends the enquiry to the vendors, receives quotations from vendors and chooses the lowest vendor and sends the Purchase orders to the concerned vendor. In Stores, receives items from vendors, generates Material Inward Note(MIN), Material Receipt Note(MRN) and issues the items to the indenter(user).

Responsibilities

Installation of software needed to migrate Oracle from release 7.3.4 to 8.1.7.2.

Involved in preparation of Project Plan for Go-Live.

Active team member during complete migration.

Migration of Oracle Database from 7.3.4 to 8.1.7.2.

Troubleshooting problems encountered during the process of migration.

Maintaining the technical dairy, this is used to fix the problems before going live.

Cloning of Oracle Database instances test, development, patch, and quality.

Planning the strategy for the 24x7(Production Support) availability of the system.

Efficient coordination of the activities by interacting with all the customizations team, system admin team.

Involved in the development of the interface between the client and the Host and also responsible for Effective Database Queries.

Proactively involved in the meetings and discussions relating to the midrange infrastructure

Setting up user security and authentication within the development database environments.

Environment: Unix, Oracle 8.1.7.2, PL/SQL, Developer 2000

Khodayss Systems, Bangalore, India – DBA consultant May 1999 to Dec 2000

Building a data warehouse for the Breweries division comprising of Data marts in Accounts, Sales, Marketing, Stock etc.

Responsibilities

Led a team of 9 members to develop a DW for the Parent company.

Designed logical model of the schema and by studying the functionality of the existing online application and OLTP databases of the parent company.

Converted the logical model to physical database model for implementation.

Performed Capacity Planning for the Database. This involved calculating the space requirements for various components of the database viz. Rollback segments, data segments, index segments and redo log sizes and number.

Tuned the database and after hours application component post implementation of after hours modules.

knowledge of building data marts, building cubes, writing PL/SQL codes, developing applications etc

Designed and developed procedures to populate data into data mart. This involved designing modules to: Data Extract procedures, Data Load Procedures, Data processing procedures and Data Consistency check strategies.

Used SQL-Loader to load data from flat files to Oracle database and wrote scheduling procedure to push and pull data using PLSQL .

Developed an intranet web application, which consists of several reports to monitor the performance of various departments and also know the revenues generated

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

Handling 20 users and a database size of 280 GB.

Environment: Windows NT 4.0, Redbrick Decision Server 4.2, SQL Server 7, MS OLAP Server, Oracle 8.1.4, OLAP, OLTP

Multimedia Studio Systems Ltd, Bangalore Oct 1998 to Apr 1999

Programmer Analyst

Client - Premier Plastics Pvt., Ltd. Chennai.

The application enables the management to keep track of all the salary related details of all the employees working in the organization.

The PMIS contains two major modules:

* Earning Calculation Module

* Deduction Calculation Module

The main activities of the module PMIS are preparation of wage slip, giving details of all earnings, deductions of an employee together with net salary payable for the month.

Responsibilities

Involved in the Design and Development of the GUI for the Users and the Database. Involved in Code Reviewing and Testing.

Documented the Database that was supported

Development of SQL scripts for reports.

Involved in the screen designing and data modeling.

Involved in the preparation of unit test plans and system test plans

Environment: Windows 98, Oracle 7.X, Developer 2000.

Indian Institute of Science (IISc), Bangalore. Mar 1998 – Sept 1998

Final Year Project during the BE

The concept of Picture-in-Picture (PIP) revolves around the idea of allowing a user to watch more than one video simultaneously. The implementation of PIP is a multi-threaded application on 32-bit windows in adherence to the MPEG2 standards prescribed by the Motion Picture Experts Group. Trends increasingly point towards the convergence of TV and Computer Systems and such an application may soon be desirable for computers. With the increasing bandwidth of the Internet, the networked computer may soon be able to access more than one MPEG stream simultaneously in real time similar application will be required in video conferencing to permit the two or more users to view one another simultaneously. The main features are switching of clips, repositioning of smaller video, Zooming and Availability of various channels.

Environment: Access, VB, C and VC++

Contact this candidate