SUMMARY

• An Oracle DBA having an overall experience in oracle technology of 15+ years. Experienced in managing production databases, troubleshooting, inter - departmental coordination and escalation management. Consistent performer in all teh sites/roles handled till date.
• Over 15 years of experience in Oracle products on multiple platforms and environments.
• Hands on experience in installing, upgrading and managing 9i/10g/11g databases on various flavors of Unix platforms.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• 2+ years of experience in oracle 11gR1/R2.
• Prototyped oracle DATAGUARD for creating and managing standby databases.
• Extensive experience in database growth monitoring and CAPACITY planning.
• Experience in implementing, upgrade and managing oracle ENTERPRISE GRID CONTROL.
• Experience in planning backup and recovery operations using RMAN.
• Hands on experience in performing logical backup using DATAPUMP for non-production database, schema refreshes.
• Setup and manage Advanced database security (TDE and SQL-Net encryption).
• Proactively monitor teh database systems to ensure secure services with minimum downtime.
• Experience in performance tuning using AWR and ADDM reports.
• Currently Prototyping ORION tool to resolve I/O performance issue in one of teh databases.
• Hands on experience in evaluating teh performance of SQL statements using utilities like AUTOTRACE, TKPROF & Explain plan.
• Frequent interaction with development, network, system and storage teams.
• Good understanding of teh business, follow teh ITIL process and adhere to customer’s SLA’s.
• Interface with ORACLE SUPPORT for technical assistance.
• Prototype In-Memory database for one of teh customer requirements in Confidential .
• Installation and configuration of MYSQL 5.5 (including Self signed SSL certificate installation).
• Ability to learn new technologies and adapt to a dynamic environment.
• Dedicated and committed with good team leadership skills.
• Successful in meeting new technical challenges and finding solutions to meet teh needs of teh customer.

TECHNICAL SKILLS

Operating System: HP UNIX, AIX 5.3/5.4/6.1, SOLARIS 9/10, Linux, WINDOWS 2003 Server.

Languages: SQL, PL/SQL, Shell scripting

RDBMS: Oracle 8i/9i/10g/11g, DB2UDB, MS-SQL Server, MYSql MAXDB.

Database Administration: Oracle 9i/10g/11g.

Oracle utilities: RMAN, DATAPUMP, Tkprof, OEM grid control, Sql/Plsql developer, Sql loader.

Tools: TOAD, SQL Navigator, PL/SQL developer.

PROFESSIONAL EXPERIENCE

Confidential, Park Ridge, NJ

Sr. ORACLE DBA/DBA Manager

Responsibilities:

• Working as a senior database administrator and provide 7*24 supports when required.
• Good understanding of teh business, follow teh ITIL process and adhere to customer’s SLA’s.
• Installation of ORACLE 9i/10g/11g database software on UNIX, Linux and windows Platforms.
• Database patching (one-off, CPU, PSU, patchset) for both PCI and Non-PCI environments.
• Run CSSCAN/Csalter to perform Characterset changes in 11g database.
• Creating databases, managing database users, managing tablespaces.
• Perform database tuning and monitoring.
• Perform general database trouble shooting and give consultation to development teams.
• Perform database backup, restore and recovery operations using RMAN.
• Cloning, database & schema refresh.
• Proactively monitoring teh databases and taking preventive actions.
• Daily checks on database servers and auditing.
• Participate in incident management and execute problem/change management.

Confidential

Project Manager/Lead/Database Admin

Responsibilities:

• Studied teh tools across various Data Centers (Across globe) dat was used before implementing standard monitoring too
• Evaluated various vendor’s monitoring/performance tools and recommend appropriate tools for dis customer globally across various sub-towers (i.e. Network, Servers, Database).
• Finalize teh tool with teh customer and implement teh same (HP Operations Manager, Sitescope and HP BAC).
• As Database admin, finalized teh parameters dat needs to be monitored for databases.
• Maintained teh repository databases of ticketing system.
• Integrate these tools with ticketing system
• Fine tune teh alerts from these tools.
• Define process for teh alerts being generated from these tools along with other towers and Service Desk.

Confidential

Lead Process Automation

Responsibilities:

• Study teh various features and present various solution options to Confidential management.
• Implement agreed options with Confidential Management.
• Help Pre-sales in highlighting teh features of dis new tool.
• Maintain databases for teh tool
• Created design for database dashboards.

Confidential

Senior IT Specialist (DB2)

Responsibilities:

• Training Business Partners/clients
• Help teh Sales team in proposals
• Make client presentation
• Help teh clients in POC
• Keep abreast on latest developments in DB2 & BI
• Knowledge of Ascential Data stage, WCC and Confidential Information Integration products.
• Working Knowledge in DB2 9 (Viper).

Confidential

Database Administrator

Responsibilities:

• Resource Enablement
• Setting up Lab for prototyping solution offerings
• Establishing alliance with database vendors
• Lead a set DBAs
• Create various assets (estimation guidelines, Checklists, questionnaire)

Confidential

Database Administrator

Responsibilities:

• Performance tuning of Peoplesoft database (RAC).
• Provide recommendation for migration of data from old database into Peoplesoft database.
• Database monitoring and maintenance post implementation
• Monitoring RMAN & export backups of Production databases.
• Transition to Support team, post-implementation.

Confidential

Project Manager/Database Administrator

Responsibilities:

• Upgrade database from 8i to 9i.
• Upgrade informatica to 6.2.
• Re-engineered data load using partition exchange to bring down data load timings.
• Performance tuning of Stored procedure to bring down teh run time from 15hrs to 4hrs.
• Review of all low-level design, unit test plans and unit test results.

Confidential

Database Administrator

Responsibilities:

• Upgrade database from 7.3.3.6 to 8.1.7.3.
• Provide recommendations for teh following: -
• Datafiles re-organization
• Table parameters (PCTFREE, Freelists, Freelist Groups, PCTINCREASE)
• Provide guidance in application issues due to migration..

Confidential

Project Leader

Responsibilities:

• Allocation of modules, Change requests,
• Develop high level and low level design for new projects
• Provide support for Integration testing to post implementation of new projects
• Provide day to day maintenance for production application.

Confidential

Project Leader

Responsibilities:

• Collection of project metrics right from integration testing through Pre-delivery phase,
• Doing causal analysis and presentation to teh clients
• Release co-ordination, Supporting integration/system tests and deployment.
• Review of all low-level designs, unit test plans, modules and unit test results.