SUMMARY

• Over 9 years of progressive experience in teh Database Administration, Analysis, Design, Development, Technical QA, Environment Configuration Management & Technical Integration.
• As a Sybase Team Lead involved in building a cohesive team structure to drive teh company’s vision to viable realizable goals.
• Functional experience includes Payments Applications, Telecommunications, HR/Payroll Applications and Insurance Applications.
• Strong skills include SQL, PL/SQL in Oracle 8i, 9i, 10g, 11g; SQL, T - SQL in Sybase and MS SQL Server 2000, Oracle Database Administration 10g, 11g, UNIX, LINUX.
• Problem determination and Trouble shooting in Development, Test and Production Environments.
• Providing 24x7 Production Support for Oracle databases.
• Performing periodic maintenance tasks like Index rebuilds, Table Analysis and data purge to ensure efficiency and reliability of teh applications and databases.
• Complying with Security Policies by managing SPI/PCI data, periodic password resets, secure password management and access control to production databases etc.
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Developing SQL Stored Procedures, Shell scripts and SQL updates for reference data based on HLD/AD for delivery to Development and System Test Databases.
• Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
• Environment Configuration Management by Integration of teh Patches, Installation and Configuration of HR Design Client/HRD Studio, DDL deployment, Execution of Jobs and Bug fixing.
• Analysis and development of Batch Programs using teh Business Rules, CL and Cobol Code of teh existing system.
• Oracle 9i Application Server Installation/ Administration and Development using Oracle 9i Application Server Portal.
• Installation/Maintenance/Upgrade of Oracle RDBMS Server 8i, 9i and 10g.

TECHNICAL SKILLS

Core Strengths: Oracle Database Administration, SQL, PL/SQL; Sybase SQL, T-SQL, UNIX.

RDBMS: Oracle 8i, 9i, 10g, 11g Administration, Sybase ASE 12.x/15.x, MS SQL Server 2000Operating

Systems: UNIX, LINUX, Windows NT/2000/XP, Sun Solaris, AIXProgramming

Languages: SQL, PL/SQL, T-SQL, DTS, Shell Scripting.

Tools: Oracle Enterprise Manager, Toad for Oracle, SQL Developer, Sybase Central.Application

Servers: Oracle 9i Application Server Administration and Oracle 9i Application Server Portal Development.

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Oracle DBA

Responsibilities:

• Deploy database changes on production needed for new requirements, to fix application defects or performance issues.
• Perform activities of data maintenance, table maintenance, database re-organizations, data archival and other efforts typically undertaken to improve teh efficiency and reliability of teh applications and databases.
• Perform database activities like schema backup/restore, import/export, required for teh health of teh application and release processes.
• Analyze database activity, perform application database performance and tuning activities and maintain development, test and production databases.
• Perform analysis and reporting of results from processing and database monitoring.
• Maintain Database Alerts.
• Proactively maintain stability of production databases.
• Co-ordination and scheduling of DBMS upgrades with impacted teams.
• Ensuring compliance for AT&T’s Security Policies by periodic password resets, secure password management, control access to production databases etc.
• Manage privileges on tables with SPI/PCI data.
• Periodic data purge to follow retention policies and space constraints.
• Work with application team and production support team to debug production issues.
• Generating DDL and SQL updates based on HLD/AD for delivery to Development and System Test Databases.

Environment: Oracle 10g, 11g, Toad for Oracle, Unix.

Confidential, Database Team Lead

Responsibilities:

• Knowledge Transition for database activities from teh existing teams.
• Preparing plans, schedules for work, attending transition calls, to track transition status and management reviews within teh project.
• Preparing and Reviewing Understanding Documents and Query Register for teh Knowledge Transition.
• Analysis and Documentation of teh existing database architecture.
• Build and maintain reference data driven from System requirements and client requests.
• Administration of teh Content Management Application (CMA) which facilitates a higher level of data integrity and provides a mechanism to quickly implement content and data changes.
• Executing routine jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Developing database Stored Procedures for Change/Modification Requests.
• Developing shell scripts for data conversion and resolution of Trouble Tickets.
• Formulating and developing new tools for reducing ma hours and increasing efficiency.
• Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.
• Allocation and follow up of tasks with database team resources.

Environment: Sybase ASE 12x/15x, UNIX.

Confidential

Environment Configuration Management

Responsibilities:

• Providing technical support for teh HR Access development and test environments.
• Installation and Configuration of HR Design Client/HRD Studio used for customizing teh HR Access Application.
• Installation and Configuration of HR Access WebTools that include OpenHR Server, Query Server and teh HR Access Web Application.
• Integration of Patches, Creation and Modification of tables in teh database, Execution of Jobs, Bug fixing etc.
• Environment Configuration for teh Web Application through HR Design Client.
• Resolving user requests for teh technical issues as well as various other tasks for teh development environments.
• Preparation of Scenarios for Regression tests and enhancements included in teh new release using requirement documents.
• Execution of Regression tests for HR Design Server, HR Design Client and WebTools.
• Integration of teh HR Design Server Patches and validation of patches and events for teh new releases of HR Design Server, HR Design Client and WebTools.
• Automation of teh Scenarios for Regression tests using QTP.
• Conducting HR Access technical trainings.

Environment: Windows Server 2003, Unix/AIX, Lotus Notes 6.0, Oracle 9.x/10.x, SQL Server 2000, Apache Tomcat Web Server, QTP 8.0, HRD Studio.

Confidential

SQL Server Developer

Responsibilities:

• Analysis of Batch Programs using teh Business Rules, CL and Cobol Code of teh existing system.
• Developing Stored Procedures in MS SQL Server 2000 for teh Batch Programs.
• Developing DTS packages for data import and export.
• Designing queries for Reports generated through teh Batch Programs.

Environment: SQL Server 2000, AS400, DB2.

Confidential

Junior Database Administrator

Responsibilities:

• Installation and Maintenance of Oracle RDBMS Server 8i, 9i and 10g.
• Oracle Database Setup, Administration and Performance Tuning.
• SQL, PL/SQL Tuning for Oracle based Applications.
• Database migration.
• Creating database in MS SQL Server 2000.
• Migrating database from Fox-Pro to MS SQL Server 2000.
• Developing scripts for creating database objects.
• Developing scripts for Data Migration.

Environment: Windows Server 2003, Unix/AIX, RedHat Linux, Oracle 9.x/10.x, SQL Plus, PL/SQL, SQL Server 2000.

Confidential

Project Trainee

Responsibilities:

• Developing a web based Library System for handling of Electronic files and to manage records and transactions in a library related to physical items.
• Provide facility to store media files in teh database.
• Installation of Oracle RDBMS Server 8.1.7.0.
• Upgrading Oracle RDBMS Server from 8.1.7.0 to 8.1.7.4.
• Installation and Configuration of Oracle 9i Application Server.
• Upgrading Oracle 9i Application Server Portal from 3.0.9.8.0 to 3.0.9.8.5.
• Migration of Database Schemas.
• Migration of 9i Application Server Portal Applications.