Senior Oracle DBA

Vidya Dambala

Phone: 214-***-**** e-mail: *****.*******@*****.***

Citizenship: United States of America

OBJECTIVE: To seek a position as an Oracle Database Administrator in production and/or development environment.

QUALIFICATIONS SUMMARY:

Highly trained Oracle Certified Professional (OCP 11g) and Application Administrator. Well motivated high-tech professional with more than twenty years experience in Oracle database administration (DBA) and software development. Worked as a Senior DBA at Collin College for maintaining 12 databases and 10 applications. Worked as a Senior Oracle DBA at ETC for maintaining more than 20 Production database and more than 40 development databases. Prior experience includes working as a Senior Oracle DBA at Sabre Holdings for SQL Tuning and moving the NonStop SQL database to Oracle Database, worked as Senior Oracle DBA as a Consultant at SITA Inc, managing 40-50 Oracle database instances in production & development environments, and working at University of North Texas as a Lead DBA and at Sabre Holdings, Inc. as Senior Consultant performing database administration and software development. Significantly raised productivity levels by applying reengineering methodologies and innovative technology solutions, thus reducing downtime. Self-motivated and an innovative thinker, consistently pursuing new challenges to stretch abilities, expand knowledge, and bring greater returns to employers.

COMPUTER SKILLS:

Databases: Oracle 12c, Oracle 11g, Oracle 10g RAC, Oracle 10g, Oracle 9i, Oracle 8.x, Oracle 8i, Oracle 7.x, Informix 7.x, MS-Access.

Languages/Tools: Banner 8.x, Banner 9.x, Weblogic 11g, Weblogic 12c, Tomcat 7.x, Tomcat 8.x, Oracle Application Server 10g, PeopleTools, Peoplecode, SQR, Query Tools, C, C++, SQL*Net, SQL*Loader, SQL Navigator, Nonstop SQL/MX, TOAD, Pro*C, PL/SQL, UNIX shell scripting, JIL scripting (AutoSys), RMAN scripting, Visual Basic, HTML.

Hardware/O.S: SUN Solaris, Red Hat Linux, HP-UX, AIX, Windows XP/2000, NSK, OSS.

Software: ER-Win, ER/Studio 7.3, AutoSys 4.5, VCS Cluster, MS Office, MS Project, ClearCase, PVCS, Cygwin, Legato, Commvault Galaxy, VI Editor, Golden Gate, Visual Query Planner.

Methodologies: ER-Modeling, Object Modeling Technique (RUMBAUGH Methodology).

Certifications: Oracle Certified Professional (OCP) – Feb. 2007

PROFESSIONAL EXPERIENCE:

Senior Oracle DBA, Collin College, TX (November ‘13 – Jan’2019)

Administer about 12 Oracle databases and 15 applications.

Implemented Oracle 11g and Oracle 12c Active dataguard for high availability and maintain the standby database.

Performed installation, configuration, administration, and deployment of the applications to Weblogic and Tomcat servers.

Helping resolve day-to-day user requests and troubleshooting application and database related problems.

Perform Banner patching on a weekly basis.

Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Install, Administer, and troubleshoot Oracle Enterprise Manager 12c.

Performed SSL Certificate management for web applications.

Senior Oracle DBA, Electronic Transaction Consultant, TX (September ‘11 – June ‘13)

Administer about 50 Oracle databases, and Oracle Application Server 24x7.

Assisted in migration of Oracle 10g database to Oracle 11g version.

Experience in installing, configuring and administering Oracle Databases and in RAC.

Performed installation, configuration, administration, and deployment of the applications to Oracle application Server.

Implemented Oracle 10g Dataguard for High Availability. (HA) and maintained stand by database.

Going through the day-to-day user requests and troubleshooting the database related problems.

Managing backup & Recovery for Oracle on Linux and Windows using RMAN

Consultant Contract, Sabre Holdings, Southlake TX (Nov ’09 – Dec ‘10)

Senior Oracle DBA

Generating data model of Nonstop SQL database using Erwin.

Design the data model using Erwin for the new Oracle 11g Database for migration.

Assist in performance tuning of the Nonstop SQL queries for developers.

Planning for requirements on moving from Nonstop SQL to Oracle 10g database.

Consulting Contract, SITA, Inc. (May ’08 – May ’09)

Senior Oracle DBA

Administer 40-50 Oracle databases 24x7.

Assisted in migration of Sun Solaris databases to Red Hat Linux platform.

Assisted in migration of Oracle 10g database to Oracle 11g version.

Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation, performance tuning, backup/recovery, Configuring Oracle Streams, patches, monitoring, export/imports and SQL loader.

Working with RMAN to implement Backup/Recovery strategies and clear understanding of the data structures and architecture provided by Oracle for Recovery in all kinds of Disasters.

Developed UNIX Shell scripts for daily database backups and other scheduled database procedures.

Involved in the installation of Test Environments, Development Environments for the project in VCS cluster environment.

Oracle DBA, University of North Texas, Denton, TX (Jan ’05 – Apr ’08)

Administer 70 Oracle Databases 24x7 for databases of size between 10GB – 700GB.

Installed, upgraded and patched Oracle software. Have setup brand new machines which included Oracle software installation, Oracle side configuration, testing on third party backup software Commvault Galaxy for database backups.

Installed and configured Oracle Enterprise Manager 10g Grid Control for enterprise monitoring.

Assist developers in SQL Programming, SQR’s, People Code, SQL*Loader for loading data, and SQL Tuning.

Perform regular Database Tuning and Space Management to increase performance.

Researched, evaluated and recommended the use of new features in Oracle and their applicability to current application databases to end-users, developers and project managers.

Trained & mentored new DBAs in our environment.

Consulting Contract, Texas Instruments Inc, Dallas, TX (Oct ’04 – Dec ’04)

Development/Production Data Warehouse Oracle DBA

Supported the development team with enhancement of enterprise data warehouse/business intelligence application for the Semi-conductor business unit at Texas Instruments Inc.

Responsible for analysis of the database, the extraction, verification, and loading of the data.

Senior Consultant, Sabre Holdings, Southlake, TX. (Jun ’98 –Jul ’04)

Development/Production DBA 2001 - 2004

Supported 30 Airlines around the world for 3 different products that involved administration of 35 Oracle & 3 Informix database instances.

Supported software developers on three major products with 25 Oracle & 3 Informix database instances.

Oracle 7, 8, 8i & 9i Administration and Programming.

oAdministered database 24x7 for databases of size between 10GB – 500GB. Also administered a database of 29TB for one Airline.

Performance monitoring and tuning of SQL and PL/SQL.

oImproved system performance significantly by reducing the processing time from 8 hours to 2 hours.

oPerformed network tuning, & troubleshooting including analyzing traces, reorganizing tablespaces, tables and indices.

Used ER-Win to architect databases and for initial DB designs or reengineering of existing designs.

oUtilized ERwin to create and modify the logical and physical data models.

Trained peers and aspiring DBA personnel for knowledge transfer.

Installed, configured, and maintain AutoSys Job Scheduler.

oPlanned and implemented nightly batch jobs, utilizing AutoSys for loading external market data into the AutoSys database.

Software Developer 1998 - 2004

Supported 13 Airlines around the world to use the Revenue generating system for Airlines.

Improved the performance of loading data from SABRE reservation system into the client's database (TAM airlines) by almost 50%. The solution was to split the bulk data file into smaller files and spawn multiple processes concurrently to load the data.

EDUCATION:

Master of Science in Computer Sciences, University of North Texas, Denton, TX 1998

Master of Science (MS), Mysore University, Mysore, India 1991

Bachelor of Science (BS), Osmania University, Hyderabad, India 1989

PROFESSIONAL DEVELOPMENT:

Oracle 8i Database Administration, Oracle Corporation.

Oracle 9i Database Backup & Recovery, Oracle Corporation.

Oracle 9i Performance Tuning, Oracle Corporation.

Oracle 10g New Features, Oracle Corporation.

Contact this candidate