SUMMARY

• Over 11 years of progressive experience in the areas of Database Administration, Analysis, Design, Development, Technical QA, Environment Configuration Management & Technical Integration.
• As a Database Team Lead involved in building a cohesive team structure to drive the company’s vision to viable realizable goals.
• Sound knowledge on OEM, SQL*Plus, Export, Import and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA.
• 24x7 Production Support and maintenance of OLTP/Data warehouse database.
• Problem determination and Trouble shooting in Development, Test and Production Environments by working closely with respective teams.
• Performing periodic maintenance tasks like Table Partitioning, Index rebuilding, Statistics collection and data purge to ensure efficiency and reliability of the 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.
• Fulfill DBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.); space management (tablespace).
• Analyze database activity, perform application database performance and tuning activities using Explain plan, AWR reports.
• Experience with Oracle Golden Gate process management and troubleshooting.
• Co - ordination and follow up of all database activities for UNIX to Linux database migration.
• Migrating data across platforms and RDBMS releases for UNIX to Linux migration.
• Worked on SQL, PL/SQL in Oracle; SQL, T-SQL in Sybase and MS SQL Server 2000.
• Developing DDL/ SQL scripts and PL/SQL Stored Procedures 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.
• Functional experience includes Payments Applications, Telecommunications, HR/Payroll Applications and Insurance Applications.
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Environment Configuration Management by Integration of the 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 the Business Rules and code of the 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 2000

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

Programming 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

Application DBA

Responsibilities:

• Deploy database changes for business requirements, to fix application defects or performance issues.
• Perform activities of data maintenance, table maintenance/partitioning, data archival/purge and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
• Perform database activities like schema backup/restore, import/export, required for the health of the application and release processes.
• Analyze database activity, perform application database performance and tuning activities using Explain plan, AWR reports etc. and maintain development, test and production databases.
• Maintain Database Alerts.
• Proactively maintain stability of production databases.
• Co-ordination and scheduling of DBMS upgrades and migration with impacted teams for Unix to Linux database migration.
• Migrating data across platforms and RDBMS releases for Unix to Linux migration.
• Ensuring compliance for Confidential &T’s Security Policies by periodic password resets, secure password management, control access to production databases etc.
• Fulfill DBA daily activities, including user management (creating users, synonyms, privileges, roles, quotas, table, index, sequence etc.), space management (tablespace).
• Handling of QC requests through iTrack and consolidation of scripts for production deployment.
• Creating and scheduling DBMS Scheduler Jobs for executing stored procedures on an interval basis.
• Work with application team and production support team to debug and resolve production issues.
• Developing DDL/ SQL scripts and PL/SQL Stored Procedures based on HLD/AD for delivery to Development and System Test Databases.

Environment: Oracle 11g/10g, Solaris/Windows Server, SQL/PLSQL, TOAD, OEM, AWR, ADDM, UNIX Shell Scripts.

Confidential

Database Team Lead

Responsibilities:

• Knowledge Transition for database activities from the existing teams.
• Preparing plans, schedules for work, attending transition calls, to track transition status and management reviews within the project.
• Preparing and Reviewing Understanding Documents and Query Register for the Knowledge Transition.
• Analysis and Documentation of the existing database architecture.
• Build and maintain reference data driven from System requirements and client requests.
• Administration of the 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 man 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/Windows Server, Sybase Central, Sybase Interactive SQL, CMA.

Confidential

Responsibilities:

• Providing technical support for the HR Access development and test environments.
• Installation and Configuration of HR Design Client/HRD Studio used for customizing the HR Access Application.
• Installation and Configuration of HR Access WebTools that include OpenHR Server, Query Server and the HR Access Web Application.
• Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
• Environment Configuration for the Web Application through HR Design Client.
• Resolving user requests for the technical issues as well as various other tasks for the development environments.
• Preparation of Scenarios for Regression tests and enhancements included in the new release using requirement documents.
• Execution of Regression tests for HR Design Server, HR Design Client and WebTools.
• Integration of the HR Design Server Patches and validation of patches and events for the new releases of HR Design Server, HR Design Client and WebTools.
• Automation of the 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 the Business Rules, CL and Cobol Code of the existing system.
• Developing Stored Procedures in MS SQL Server 2000 for the Batch Programs.
• Developing DTS packages for data import and export.
• Designing queries for Reports generated through the Batch Programs.

Environment: SQL Server 2000, SQL Server Enterprise Manager, SQL Query Analyzer, AS400, Windows Server, COBOL, 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 the 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.

Environment: Windows 2000 Server, Oracle 9i Application Server, Apache web Server, Oracle 8i.