Sr.Oracle DBA

NAVEEN ANCHA

(Sr.Oracle DBA)

Email: d9upnb@r.postjobfree.com

Contact Phone no: 202-***-**** (Cell)

Work Authorization: U.S Citizen

SUMMARY

Over 14 years of solid experience as an Oracle DBA. Experience in the full project life cycle, from collecting user requirements to implementation, managing and coordinating projects, as well as, the design, implementation and maintenance of production database systems in mission critical 24X7 environments. Outstanding contribution to the customer satisfaction and cost cutting efforts by pro-active monitoring, improved backups and in cases of recovery, performed within the time limits permitted by aggressive Service Level Agreement (SLA).

Solid expertise in Performance Tuning, Backup and Recovery, Database Migration, Replication and Managing Databases on High Availability Sun Cluster, RMAN, Table Partitioning, Data Guard, Oracle RAC, OEM Grid Control, Unix Shell programming, Oracle Parallel server on various Oracle Versions 8i, 9i, 10g,11g on Unix, Linux, Open VMS and Windows platforms. Solid writing skills in Stored Procedures, Functions, Packages and Database Triggers in PL/SQL and using front-end Oracle Developer 2000 tools set and Visual Basic 5.0. I am team oriented with strong analytical skills, excellent work ethics and peoples’ skills.

TECHNICAL SKILLS

RDBMS Oracle Server 11g/10g/9i/ 8i, DB2, SQL Server6.5/7.0, Real Application Clusters (RAC), Oracle Application Server 10g

RDB Tools Oracle Enterprise Manager Grid Control, SQL Backtrack, TOAD, BMC Patrol V3.1, Web DBA, Oracle RMAN, SQL Loader, Informatica, Data Stage (ETL Tools), Warehouse Builder

Languages C, C++, SQL, PL/SQL, Unix Shell Programming (Korn Shell, Bourne Shell), Perl

GUI Developer 2000, Visual Basic 4.0/5.0

Other Software’s Sun HA Cluster 2.2, Legato Networker, Veritas NetBackup, Remedy 4.6, Clear Quest, Clear Case, BMC Patrol, Cognos, Assyst

O/S Sun Solaris 8.0/ 9.0/10, AIX 4.1/4.2/5.2, HP-Unix10.20, Linux 7.2, Open VMS 7.3, Windows 2000/NT

Hardware Sun Enterprise Series (E6800/E3500/E3000/E450/250), IBM RS6000, HP-Server 9000/982, IBM X86, A1000, EMC Disk Arrays

PROFESSIONAL EXPERIENCE

CSC, Sr.Oracle DBA 11/07 to Till Date

Environment: Oracle 9i/10g/11g, SQL Server2005, SQL Backtrack, AIX 5.2, Linux 2.4.9, Sun Solaris, Clarify

Working as an Oracle DBA in the OPS-DBA team for the ARC project. Supporting nearly 400 production, Development and Test database’s for the various applications.

Responsibilities:

• Maintenance of critical production database’s 24X7

• Supporting logical standby production database’s

• Install, configuration and maintenance of an Oracle RAC environment

• Resolution of clarify cases from the application support teams on the database issues.

• Database backup’s and disaster recovery tests for the production database’s with RMAN

• Resolving Database and Application performance issues

• Oracle upgrades and security patches

• Refresh Development and Test database’s with the production data

• Writing scripts for the database jobs.

VeriSign, Sr.Oracle DBA 08/05 to 09/08

Environment: Oracle 9.2.0.6/10g,SQL Server2005, AIX 5.2, Linux 2.4.9, Sun Solaris, Windows, Assyst

Worked as Oracle DBA for the VCS projects maintaining nearly 40 OLTP Production database’s on various environments. Also supporting development team in tuning SQL, application issues and code deployments in the production.

Responsibilities:

• Maintenance support for the mission critical Production database’s

• Tuning SQL statements for the application

• Logical standby database configuration and maintenance for a production database

• RMAN configuration and recovering database’s on a different hosts for reporting purpose

• Worked on RAC configuration in a testing environment

• Production database migration from old versions to 9.2.0.6

• 24X7 support for the production databases.

• Scripting monitoring scripts for the database and backups.

• Worked in creating data warehouse for a database of more than 1TB

• Data files reorg for a very big database

• Managing Database’s on SQL Server 2005

• Support production deployments

FannieMae / Data Architecture, Oracle DBA 02/05 to 07/05

Environment: Oracle 9.2.0.6, Sun Solaris 8.0, Windows 2000, Clear Quest, Clear Case

Worked as Oracle DBA for the Data Architecture team with the primary responsibility of maintaining the Oracle Databases and implementing physical and logical changes in the database through a version controlled process.

Responsibilities:

• Maintenance of Production and Development Databases

• Physical and Logical changes in the database through a version controlled process by using Clear Case and Clear Quest

• Migrating higher environments with Delta Deployments.

• Refreshing Development database with Production data.

• Working with Developers in the Application design and resolving issues with in the application

• Tuning Databases and the application for better performance

• Database backup with RMAN and Veritas Net backup

• Writing Oracle PL/SQL procedures, functions and packages for the Build and Deployment process

• Implementing Security policies in the Database

SAIC / US Department Of Commerce, Sr.Oracle DBA 08/04 to 02/05

Environment: Oracle 10g/9.2.0.5, Oracle Application Server 10g, Sun Solaris 8.0, Linux, Open VMS, Windows

Worked as a Sr.Oracle DBA for DSCMO project with Primary responsibility of maintaining Production Database’s and Application development and supporting Oracle Application servers for various client’s projects

Responsibilities:

• Maintenance of critical Production database’s 24X7 on Various OS Platforms Sun Solaris, Linux, Open VMS, Windows

• Oracle Upgrades and applying Oracle Security Patches

• Install and configuration of Oracle Application server 10g, Oracle Database server 10g, Oracle Developer Suite and other Oracle products on various OS platforms Solaris, Linux, Open VMS, Windows

• Installed Backup tool and writing scripts for backing up Oracle Application server (Mid tier) and Infra database

• Created Oracle RMAN and Designer repositories

• Disaster and Recovery tests for Oracle Databases and Application servers

• Database Migration from 9.0.1 to 9.2.0.5 on Open VMS and Sun Solaris

• Provide support to end users in resolving application, connectivity and database performance issues

• Documentation of various procedures to meet CMMI standards

NASD (NASDAQ) / ADF Project, Sr.Oracle DBA 01/03 to 07/04

Environment: Oracle 9.2.0.5/ 8.1.7/ 8.1.6, SQL Server 6.5, Sun Solaris 8.0, Windows 2000, Veritas Net Backup 3.4, Informatica Power center / Power mart 6.2/5.1

Worked as Sr.Oracle DBA for ADF Project with the primary responsibility of maintaining the Trading engine application and the Trading Production Databases as well as in a Data warehouse project.

Responsibilities:

• Configuration and Maintenance of Standby Databases.

• Configured and managed table partitions and Index partitions in a large production database.

• Created RMAN repository and configured RMAN with Veritas Netbackup for backing up the production databases.

• Production Database migration from Oracle 8.1.7.4 to 9.2.0.4.0

• Maintenance of SQL Server Databases on Windows2000

• Maintained development, Test & Production informatica repositories.

• Installed/upgraded and configured Informatica Power center 6.2/5.1 and created Dev/QA/Prod Repositories.

• Installed and configured third party applications and tools including the Trading engine application, BMC Patrol, etc including upgrades.

• Tuning SQL statements for the cognos application.

• Perl scripting for automating DBA functions including logical and physical backups, as well as, for the purpose of syncing the standby Database with the primary database.

• Provide 2nd and 3rd tier support for the Development and testing teams in resolving application, connectivity and database performance issues.

UUNet Technologies Inc (MCI WorldCom), Sr.Oracle DBA – Oracle Operations Team 09/99 to 12/02

Environment: Oracle 9.0.1/ 8.1.7/ 8.0.6, SQL Server 6.5, Sun Solaris 8.0/ 7.0/ 2.5.1, Linux 7.2, Windows NT

Senior Oracle DBA for the Enterprise Web Hosting Group. The main objective of this group is to host the client’s web applications. Responsibilities include maintenance of various clients’ Databases while proactively monitoring their Production Databases including the implementation of several E-Commerce Solutions for the advanced network Web Hosting group.

Responsibilities:

• Installation of Oracle Software (Oracle versions 7.x, 8x, 8i, 9i), design and creation of databases for various clients based on their requirements.

• Installation of SQL Server 6.5 software and Database creation and maintenance of SQL Server Databases on WindowsNT

• Replication configuration in a SQL Server Database.

• Managing and Providing Oracle services on Database administration, Performance monitoring, Database tuning for optimal performance and space management in a mission critical 24x7 Enterprise Web Hosting Environment.

• Writing system Shell scripts which execute both physical and logical backups of the database which and saved remotely by the Legato Networker.

• Oracle core software and patch upgrades.

• Database migration from Oracle 7.3 to Oracle 8, 8 to 8i and from Oracle 8i to 9i.

• Configuration of Recovery Manager (RMAN) in Oracle 8.1.7 and in 9i

• Tuning System Global Area (SGA) dynamically in Oracle 9i

• Database, as well as, user administration including changing the Character Set of the databases, renaming the Databases, cloning the Database, application tuning, refreshing staging Databases with production data, creating views and Indexes etc.

• Trouble shooting the Database, as well as, the customers’ applications.

• Managing Databases on High Availability Sun Cluster (Hardware Fail over).

• Recovering Databases in case of crashes well within aggressive SLAs.

• Configuration of Oracle Intermedia Text in Oracle 8.1.7

• Installation and configuration of Java VM and Oracle XDK in Oracle 8.1.6

• Documentation of Internal Standard procedures for Oracle Installation, Database creation (OFA Compliant), product development in Oracle 8i, database monitoring scripts and backups and recovery’s scenarios.

Sun Microsystems, CA, Oracle DBA (Secure Oracle Database Replication) 06/99 to 08/99

Environment: Oracle 8.0.5.1.0, Sun Solaris 2.6

Worked as an Oracle DBA in the project FLIPPER for Sun Microsystems. The Flipper project is an end-to-end E-Commerce architecture and development project for one of the state governments. Worked in the Secure Oracle Database Replication part of the project.

Responsibilities:

• Installation/Configuration of Oracle 8.0.5 on Sun Solaris Workstations with ANO and Replication Options.

• Configuration of Advanced Networking Option (ANO) for data Encryption and Authentication.

• Configuration of Replication Option by using Replication API functions.

• Configured Replication for Master – Master Replication and Snapshot – Master Replication.

• Error / Exception handling during Replication Process.

• UnitTesting and Application Integration.

Hewlett Packard, CA Application Developer/ DBA (MBA) 11/98 to 05/99

Environment: Oracle 8.0.6, HP-Unix 10.20

An in-house HP project, MBA is the integration of applications for business-to-business and intra-business purposes. MBA enabled applications can plug and play business functions. The responsibilities included establishing and managing database security policies for both users and applications, as well as:

• Database and User administration.

• Shell scripting.

• Establishing Backup and recovery policies and implementing the procedures.

• Creating and managing schemas.

• SQL Tuning. Creating PL/SQL procedures, stored procedures, and database triggers.

• Performance Tuning.

United States Cellular Corporation, IL (CARES) Oracle DBA 07/98 to 10/98

Environment: Oracle 8.0.5.1.0, Sun Solaris 2.6

Managing and maintaining a distributed database designed for the customer acquisition and retention system (CARES). It tracks customer and system calls, processes and bills. The production database has approximately 1.5 million customers and provides billing capabilities for about 80 million calls per month. Distributed between sites at Knoxville, Madison, and Chicago, Chicago was the location of the disaster recovery site.

Responsibilities:

• Oracle software installation and creation of multiple databases for testing and production.

• Creating and managing schema objects.

• Developing scripts to automate tasks.

• User administration/support.

• Database and system performance tuning.

• Establishing and implementing backup and recovery procedures.

• Migration from Oracle 7.0 to Release 7.3

AP Technological Services, Hyderabad, India. Oracle DBA 12/96 to 05/98

Environment: Oracle 7.3, Windows NT

AP Technological Services is a software development company providing software solutions to government organizations.

• Routine database administration and development support for MPHS (Multipurpose House holding Service) database, which maintains demographic data for each county of the state.

• Database migration from Oracle6 to Oracle7.3 on Windows NT. Responsible for full spectrum of DBA activities from auditing usage, solving user problems, taking hot/cold backups, managing archived log files, instance tuning, storage allocation, data loading. Performed the duties of database backup (Hot and Cold/incremental) as per schedule.

• Physical and logical backups. Recoveries with minimum downtime and impact on the environment.

• Data uploads using SQL* Loader.

• Preparing Project documentation and reports were also prepared using Oracle Reports 2.5.

Spectra Motors, Hyderabad, India. Oracle DBA / Developer 09/95 to 11/96

Environment: UNIX, Oracle 7.3 and Visual Basic 5.0

Working for Rasasri Systems Pvt. Ltd., a proprietary software developer, the responsibilities included:

• Application development & Database Administration of the Automobile Pricing System for Spectra Motors. The back end is on Oracle 7.2 on UNIX. This project has around 55 tables and about 30 forms and 25 reports was actively involved from the database Design phase.

• Customizing the primary design of databases as per customer requirements, however this was susceptible to changes. Application programming involved a lot of attached libraries, stored procedures etc, to retain flexibility in the event of a change in the database design.

• Application tuning. This was accomplished by constant testing and monitoring of the application using advanced Oracle tools such as performance pack and enterprise manager. Cost based optimization was extensively used and statistics were generated periodically.

• Cold and hot backup schemes implemented at client’s site as specified.

VBC Ferro Alloys Ltd., Hyderabad, India. Programmer / Analyst 03/95 to 08/95

Environment: HP 486, Oracle 7.1and Visual Basic 4.0

Programmer /Analyst responsible for the Development of Material Management System (MMS) for VBC Ferro Alloys Ltd.

• The Material Management System deals with the materials required, ordered available quantities in hand, items produced apart from maintaining Purchase orders and Sales orders.

• MMS has 3 main modules viz. Masters, Transactions and Reports. Master module maintains details of Items, Customers and Suppliers. Transactions module takes care of purchase orders and Sales orders. Reports module generates various reports for Daily, Monthly and yearly transactions.

APTS, Hyderabad, India. Programmer / Analyst 12/94 to 02/95

Environment: HP 386, Oracle 7.0, Forms 4.5 and Reports 2.5

Programmer/ Analyst was responsible for the Development of Civil Supplies application for APTS.

• This project deals with the supply of various Food items at subsidized rates to the people. It maintains the complete information of all the Ration cardholders. The quantity of Food items supplying to each cardholder depends on the income, number of family member’s etc.

• Various reports are generated day to day as well as monthly transactions. While developing the application we have used attached libraries, Stored Procedures and Functions etc.

EDUCATION

Bachelor of Engineering (B.E.) Bangalore University, India.

Contact this candidate