SUMMARY

• Senior Level Information Technology Professional with 10+ years of experience with strong management and techincal experience in database architect, project implementation and 24/7 production support in cost - effective, multi-tiered, high performance distributed enterprise global systems.
• Excellent Database operation management and leadership proven by consistently exceeding Service level Agreement with various business units.
• Over 10 years of pharmaceutical experience, with ability to quickly colloborate and motivate team members and establishing partnership with clients to achieve business goals on time and within budget.

TECHNICAL SKILLS

Platforms: AIX, Sun Solaris, Linux, Windows XP, Windows 20005, Windows 2000

Languages: SQL, PL / SQL, T SQL

RDBMS: Oracle 11g, 10g / 9 / 8 / 7, MS SQL Server 2000/2005/2008

Database Tool: Oracle RAC, Oracle Data Guard, Oracle Stream, Golden Gate, SQL Server DB Mirroring, Erwin and Toad

Project Mgmt & Version Control: Microsoft Project, Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Lead

Responsibilities:

• Led database effort and implementation of Citi’s largset implmentation RUSA/G2C($500 million) for retail banking application.
• Developed and defined environmental requirements to implement Development, Conversion, Pre-IST, IST, UAT, PAT and Production database environments 11gR1 in an alignment of release schedule of various applications including Data-warehouse
• Implemented and provided support of Oracle RAC using ASM and Data Guard utilizing maximum high availability architecture for mission critical applications.
• Implemented Database Log Shipping for SQL Server 2008 database.
• Developed and implemented Oracle Database upgrade/patch deployment process for Databases.
• Implement controls for DB Auditing and security for Oracle and SQL Server Database platforms.
• Developed service level management & process improvements, demand & capacity management, configuration change, incident & problem management and performance benchmarking.
• Developed Database strategic plan and Roadmap aligned with IT strategic plan.
• Led as a single coordination point for working with all application and shared services teams for Oracle and SQL Server Database implementation and production support
• Performed Database performance analysis, diagnosis and tuning (Sql Query Optimization, Storage and Network performance, CPU and Memory tuning, IO Load balancing etc) using AWR reports and SQL profiler
• Developed base line performance criteria and guidance to application team for their queries performance and tested data loads scenarios to meet business needs.
• Performed Database Upgrade from 11gR1 to 11gR2 for all RUSA database.
• Performed Database Upgrade from SQL Server 2005 to SQL Server 2008 R2 for RUSA database

Confidential, NJ

Database Lead

Responsibilities:

• Manage Confidential ’s second largest implementation PACE Contractsphere ($60 million) utilizing System Development Life Cycle (SDLC) from Database requirement gathering to the implementation phase.
• Led Database Server Architecture efforts for the Pace Contract Sphere implementation
• Managed and implemented multi terabyte Oracle Maximum High Availability Solution for Contract Sphere Application utilizing Oracle11g RAC and Data-Guard technology
• Managed and developed database activities and timelines to meet overall project timelines.
• Managed and performed end to end Disaster Recovery Testing to meet the Recovery Time Objective and Recovery Point Objective of the system.
• Initiated and led database performance optimization meetings during utilizing AWR and ADDR features, also developed bench marks for critical application processes.

Confidential, WOODCLIFF LAKE, NJ

Senior Manager - Database Administration

Responsibilities:

• Managed Expense & Capital Budgets with a total value of $4 million, Direct 5 employees responsible for approximately 12 employees & contractors.
• Managed various in-house database development projects to define and translate business requirements into a technology solution, planning and analysis, requirement engineering, system design and development, testing and implementation utilizing IT best practices.
• Reorganized cost effective 24/7 support Database Operations team in order to position Confidential for global business applications support, consolidation and harmonization.
• Established an audit and compliance procedure for database security for several annual audits including FDA, JSOX and internal auditing. Authored and implemented a standard work procedure (SWP) for database and user access authorization process.
• Designed and implemented database load-balancing, high availability and disaster recovery solution using Oracle Data-Guard, Oracle RAC and SQL Server database mirroring for Enterprise applications including SAP ECC, Global Clinical Data Management System and Blackberry Enterprise Service.
• Participated in requirement gathering sessions with business and implementation team to develop logical and physical database model.
• Developed and implemented logical and physical model for the EDW (Star Schema/Snowflake) and in-house built Distribution Application (transactional) using ERWIN modelling tool.
• Developed and implemented Database Upgrade process including Oracle 10g to Oracle 11g and SQL Server 2005 to SQL Server 2008 for several business applications.
• Implemented and provided support to Tera bytes of Sales and Marketing Data-Warehouse System
• Developed and maintained strong relationships with internal customers/clients, IT supports groups, and 3rd party vendors. Established and implemented database performance metric, Service level Agreements and Service Delivery Catalogue and associated report for monthly Database operations.
• Implemented Automated Work Load Repository (AWR) and Oracle Enterprise Manager (OEM) to monitor database performance and database availability across company-wide Oracle Databases.
• Recommended and resolved several Database performance issues including Global Clinical application running on Oracle RAC and Enterprise Data-warehouse utilizing AWR reports.
• Regulatory
• Implemented company-wide database qualification strategy to better define Confidential guidelines vis-à-vis FDA regulatory requirements and the use of computerized systems.
• Introduced “Qualify Once, Install Many” strategy which allowed for pre-qualification of database qualified provisioning platforms for the implementation of business applications including PeopleSoft, SAP and Global Clinical Data Management Systems.

Confidential

Senior Database Administrator

Responsibilities:

• Developed and implemented conversion of E-commerce application from SQL Server to Oracle 8 Database on Windows NT and Sun Solaris.
• Implemented database replication using snapshots and snap logs approach. Created database links between Transaction database and reporting databases.
• Implemented database hot and cold backups using RMAN scripts, managing archived log files, storage allocation, monitoring space availability of different schemas and adding space as and when needed.