SUMMARY

• 12 plus years of professional experience in Development, Administration & performance monitoring for Production,, Testing and Staging environment.
• Currently working for one of teh leading telecom company since 2006 as production and development DBA.
• Extensive noledge on database administration for Oracle 8i, 9i, 10g & 11g wif experience wifin very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading teh databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24*7 production database support wif Support to developers & end-users.
• Experience in implementation of Gloden Gate features to extract and replicate teh data between various topologies
• Created development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMANwif VERITAS Net Backup.
• Performance tuning of teh database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDMand Tuning of SGA, Distribution of disk me/O, Sizing of tables and indexes
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to teh databases.
• TEMPEffective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning teh tables and Indexes.
• Extensive noledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills wif customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.
• Coordinate onshore/offshore dba tasks and interact wif clients.
• Knowledge on Dataguard,Glodengate and RAC
• Ability to communicate technical terms in lay man terms.
• Domain noledge in Telecom,Core Banking and Foreign Exchange operations
• Oracle certified Professional (OCP) Oracle 9i.
• Sun Solaris system administrator for Solaris 8
• Microsoft Certified professional (MCP) Windows 2000 server

TECHNICAL SKILLS

Operating Systems: Solaris 8,9,10, Windows 2000 Server, Windows NT Server 4.0, Windows 95/98/XP, MS-DOS. HP UX 11.11,Sco UnixWare 2.3.1 & 7.1,AIX 7.1,Miracle Linux,Turbo Linux 7

Database: Oracle Enterprise Edition 11g R 211.2.0.2.0 , 10g,9.2,8.07.4,8,7.3,DATAGUARD, RMAN, MS-Access; MS-SQL Server

Application Servers: BEA WebLogic 10, 9.2, 8.1/7.1.

Web Servers: Apache Java Web Server

GUI: Developer 2000, Forms 6I, VB 5.0/6.0

Tools: & Utilities: Toad,OEM,ER-win4, PLSQL developer5, MSOffice 97,2000, webmin, RMAN, Shareplex, TIGER(Amdocs),Hobbit

Languages: UNIX Shell (Korn, bash),HTML

Config Management: VSS, Win CVS

Monitoring Tools: Wily Introscope, Hobbit Monitoring

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Sr. Oracle DBA

Responsibilities:

• Performed Installation,upgrade and Administration of Oracle 10 and 11g
• Involved in 24/7 support for production environments.
• Planning and scheduling teh environment build, upgrade, load data and deploy it on production on monthly and Major Releases.
• Troubleshoot issues, defects wifout slippage in SLA.
• Coordinate, monitor and assign tasks to offshore.
• Patch installation activities for oracle 11g under sun Solaris and AIX.
• Attending and give suggestions on Release note meeting and SIS release.
• Production support on rotation basis .
• Developed UNIX shell scripts to automate teh deployment process.
• Monitored WebLogic server resources using Wily 9.0 Introscope.
• Used Hobbit to monitor network services and conenctivities
• Used Wily Introscope extensively to troubleshoot application bottlenecks to dig-out which modules are consuming excessive resources.
• Automated teh nightly RMAN backups for teh Production and Test Databases in Crontab.
• Cloning&duplicating databases using scripts as well as RMAN.
• Verify alert messages day to day basis
• Configure SSH key, FACT tool for file transfer on different servers.
• Provide expert assistance in performance tuning.
• Schemas refresh using Export/Import Pump, Creating teh database table spaces, tables, indexes, setting privileges and user logins.
• Initiated new security controls on db servers and monitoring using db vault.

Environment: Oracle 10g,11g, HTML,VB,ERWin, HP QC, Sun Solaris 8,9HP UX 11.11,AIX,Toad,SQL Developer, DataGuard,CVS.

Confidential, Richardson, TX

Sr. Oracle DBA

Responsibilities:

• Planning and scheduling teh environment build, upgrade and load data.
• Production/QA DB planning and upgrade.
• Worked in a team doing upgrade from Oracle 10g R2 to oracle 11g R2.
• Using Tiger(Amdocs) apply patches and upgrade teh systems.
• Is responsible for teh reference area tables and data of OMS applications for teh rapid deployment and major release activities.
• ETM (Enterprise Table Management) tool database management for rapid deployments, monthly releases and major releases.
• Work wif teh dev/IT/Business people to resolve defects/CR.
• Attending teh future Release planning/discussions.
• Validate data and table for reference area Pre/Post Major release
• Load patches to teh Tiger repository.
• Production support for Enabler, ACS,Mediation and OMS systems.
• Creates and maintains all databases required for development, testing and production usage.
• Configured Glodengate extract and replicate.
• Configured Glodengate datapump extract to move teh trail files from source database server to target database server.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Assists wif impact analysis of any changes made to teh database objects.
• Hands on experience wif vtiers\Logical partitioning (LPAR)
• Controls migrations of programs, database changes, reference data changes and menu changes through teh development life cycle.
• Troubleshoots wif problems regarding teh databases, applications and development tools.
• Cloning&duplicating databases using scripts as well as RMAN. patch installation activities for oracle 11g under sun Solaris and AIX.
• Handling all production issues resolution on time
• Data Guard maintain, monitoring and problem resolving.

Environment: Oracle 9.2.0.1,10g,11g, HTML,VB,ERWin, HP QC, Sun Solaris 8,9,HP UX 11.11,AIX,Toad,SQL Developer, DataGuard, ORACLE GRID.CVS.

Confidential, Middletown, NJ

DBA

Responsibilities:

• Creates and maintains all databases required for development, testing and production usage.
• Performs teh capacity planning required to create and maintain teh databases.
• Performs ongoing tuning of teh database instances.
• Controls migrations of programs, database changes, reference data changes and menu changes through teh development life cycle.
• Implements and enforces security for all of teh Oracle Databases.
• Plans and implements backup and recovery of teh Oracle database.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of teh database.
• Evaluates releases of Oracle and its tools, and applications to ensure dat teh site is running teh products dat are most appropriate.
• Provides technical support to application development teams.
• Enforces and maintains database constraints to ensure integrity of teh database.
• Used Wily Introscope 7.0 to monitor teh health of various applications
• Involved in assisting QA team in Regression, Load and Integration testing of J2EE applications on WebLogic Application Server
• Worked wif a Team for Stress tests, Performance tests and identified teh bottlenecks of teh applications, and set up various monitoring alerts using Wily Introscope.
• Providing 24x7 support (including Health Checks) to Testing, staging and Production environments.
• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Assists wif impact analysis of any changes made to teh database objects.
• Troubleshoots wif problems regarding teh databases, applications and development tools.
• Capacity Planning, High availability of Data Base Servers, Estimating Database Growth, Data Archiving and other Related Data base Operations.
• Handling all production issues resolution on time
• Upgrade\migrate databases to oracle enterprise 10g from oracle 9i and patch installation activities under sun Solaris and AIX.

Environment: Oracle 9.2.0.1,10g, HTML,VB,ERWin, HP QC, Sun Solaris 8,9,HP UX 11.11,AIX,Toad,SQL Developer,SharePlex.

Confidential

DBA

Responsibilities:

• Monitoring of availability of teh server, checking for free spaces for all applications and pro active maintenance of databases.
• Database consistency checks activities for all applications.
• Database management creating users and privileges checking teh status of database and taking up necessary steps like space allocation, updates, archiving etc.
• Modifying Initialization Parameter file, if it is necessary.
• Migration and Performance tuning activities.
• Database upgradation and patch installation activities.
• Stream lining of BACKUP activities using RMAN.
• Daily health and alert log monitoring.
• Resolving teh problems related to Databases.
• Initiating CRs (Change Request) for implementing Application level and database level patches.
• Maintaining a record of CRs and Bridge cases and their resolution method for documentation purpose.
• Prepare Consolidated Report of all projects in teh group.
• Involved in 24/7 support for production environments.

Environment: Oracle 9.2.0.1, Sun Solaris, HP Unix, ER Win, Toad, Windows 2000

Confidential

DBA

Responsibilities:

• Maintaining DB for teh development, Creating Stored procedures, triggers, Views.
• Administration and Troubleshooting of Database and test database.
• Planning and implementing teh standby server option.
• Database consistency checks activities for all applications.
• Database management creating users and privileges
• Troubleshooting of DB problems for other projects.

Environment: Oracle 9.2.0.1, Miracle Linux 2.1,Toad, MS Access, plsql developer

Confidential

Project Coordinator &DBA

Responsibilities:

• Coordinated wif client as Project Coordinator
• Involved in teh complete waterfall life cycle of Requirements Study, Analysis, Design, Development, Implementation and Maintenance.
• Administration and Troubleshooting of Database, Network and Hardware issues

Environment: ASP, Oracle 9.2.0.1, HTML,VB,ER Win, Windows 2000

Confidential

Database administrator/Developer

Responsibilities:

• Installation, Creation, Performance Tuning and Maintenance of databases.
• Analysis and Design of teh System.
• Client Interaction and support.
• Maintaining Existing database for payroll.
• Creating triggers, Procedures, Functions and Views.
• Implemented Oracle Enterprise Manager improving error response time and facilitated application troubleshooting and development.
• Implemented Hot and Cold backups.

Environment: Oracle 9.2.0.1.0, ER-win 4,Toad, Windows 2000, Windows 98,Turbo Linux 7 and VB6

Confidential

Developer

Responsibilities:

• Requirement study, System design, database design,
• Development and site installation.
• Client Interaction, Client support, bug fixing, Patch releasing, Analysis
• Installation of oracle, design and creation of database.
• Coding and database performance tuning
• System Testing, Implementation and User Training

Environment: Developer 2000,Oracle 8i,Toad, Windows 98,Sco Unix