SUMMARY:

• Over 14 years of experience as Sr Database Manager/Database Architect/Lead Oracle DBA in projects covering OLTP and Warehouse implementations, large and complex databases, Performance Tuning, Systems Integration, support and upgrades. Solid hands - on experience in implementations of Real Applications Clusters (RAC), High Availability Systems, Highly Scalable database systems, Backup and Recovery Strategy, Veritas Cluster, Grid Control Implementations and Support of Mission-Critical Systems.
• Extensive experience with the right balance of management and technical skills to work effectively in a team and across cross functional groups. Proven strength in managing off shore resources, meeting goals and producing results through leadership, direction, guidance, continuity, excellent interpersonal, motivational and communicational skills.
• Extensive experience in RAC Implementations, Database Migration, Database Upgrade, Oracle Installations and Patch Application.
• Extensive Experience in design, implementing and performing Disaster Recovery.
• Extensive Experience in design and implementing High Availability.
• Provide work coordination, technical leadership and management for teams of DBA’s, including project lead, project management, task assignment and coordination.
• Experience in Agile Technology and ITIL technical solutions.
• Participate in production on-call and escalation on-call rotation of 7x24 production environments.
• Lead efforts to develop and improve procedures for automated proactive monitoring. Identify automation opportunities and implement solutions to improve efficiency, service reliability, productivity and cost of ownership.
• Promoted consistency, standardization and efficiency within database environment.
• Developed and implemented the strategic roadmap for the use of Oracle and Oracle products. Defined the set of products and versions to be used in production. Defined the standards, policies and procedures to be followed.
• Developed and implemented policies, procedures, technical solutions and best practices that relate to the effective implementation and operation of VLDB, grid/RAC.
• Very good understanding of broad range of technologies from systems, storage, networks, Middleware, ETL and other major application development tools.
• Background in strategic planning, project management, staffing, training and employee relations.
• A leader with strong ethics, extraordinary analytical skills and a demonstrated track record of achieving goals with dedication and dependability under tight constraints. Facilitate strong team organization.
• Strengths in understanding and analyzing business processes and infrastructure requirements and translating them into technical specifications and capable of breaking down large projects to definable sub-projects.
• Skillful in partnering, creating and managing business relationships with business clients from various divisions and geographies (local and international) while meeting business requirements and maintain strong, effective working relationships with coworkers.
• Keen analytical focus with strong research, investigative and problem solving techniques for quick recognition of errors and anomalies. Excellent math aptitude and abstract conceptualization.
• Managed multiple large scale projects and successfully delivered high profile/priority projects.
• Coordinate and drive cross functional project teams, schedule, install, test and deliver contracted products within scheduled timeline and with a high degree of quality and customer satisfaction.
• Lead/participate in meetings with customers and internal project resources.
• Provide continuous feedback on project status and offer constructive options to ensure project continues to meet original expectations.
• Identify resources and/or schedule conflicts and changing of project scope.
• Communicate identification and resolution of business/project issues, as well as the monitoring, tracking and reporting on project deliverables to ensure adherence to project plan.
• Assist project teams in data modeling and designing data accesses methods.
• Contribute towards the inventory and metrics management processes to track IM assets.

TECHNICAL SKILLS:

DATABASES: Oracle 12c,11g/10g/9i/8i/8x/7x, Oracle Exadata 12C, 11g, Teradata 7.0,SqlServer 2000,2008,2012, MySql 5.x, MS Access, Hadoop

ENGINEERED SYSTEM: Exadata X6-2, X2-2.

OPERATING SYSTEM: RHEL, Sun Solaris, Aix, HP-Unix, Windows 2000/NT/XP, MS-Dos

LANGUAGES: SQL, PL/SQL, C, Shell Scripting, Perl Scripting.

DATABASE /DATA WAREHOUSE TOOLS: Oem grid control 12C,11.1,10.2.x, Oem data control, Sql Loader, Datapump, Exp, Imp, Toad, Sql Navigator, Queryman, DBartisan, DataJunction, Erwin, Exceed, Kea, Informatica, Cognos power play7.0, Cognos Impromptu 7.0, ILM

APPLICATION SERVERS: Oracle AS Portal, Weblogic

INCIDENT MANAGEMENT: Remedy, Peregrine, Clarify

CLUSTER: Oracle RAC, Veritas Cluster, Microsoft Cluster, Oracle Failsafe

REPLICATION: Oracle Streams, Golden Gate.

BACKUP AND SCHEDULING: EMC Clone, RMAN, Netbackup, TSM, Sql Backtrack 5x/6x, Control M,Maestro, Autosys, Automate, Cron

HARDWARE: HP EVA 8100, EMC XtremeIO, MSA 2000, Sun StorEdge 3000/A5200, SunE10k/E6000/E5000/E3500/E450/E250/E420R/E220R, SunUltrasparc 450, Aix 570,HP 9000A180 /D200 /K460 /K570 /N4000 /k220,RP 7400, CompaqProLiant DL series, Compaq ML series, ProLiant 5000, 3000, 2000.

PROFESSIONAL EXPERIENCE:

Confidential, PA

Database Manager Tech Lead

Responsibilities:

• Involved in vital planning for infrastructure setup.
• Manage team of DBA’s (infra-structure) on site and off site spread across the globe. DBA categorized of Administration, Application, Operation, Production, Change Management, On-call support and performance optimization.
• Implemented the ITIL standard model of RDBMS for the DBA teams: Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.
• Implemented Exadata X6-2 Engineered System half rack.
• Defined the Cost saving structured Shared-Service Model for the operational DBA team servicing multiple projects. Defined Outsource model across continents for rapid DB service requests.
• Involved actively in technical solutions in bidding proposal for future Business development.
• Managed enterprise-level Oracle database systems, achieving the goal of 99.99% availability at acceptable level of performance.
• Involved actively in technical solution of integrating ovd with ldap for Enterprise User Security.
• Involved actively in design and implementation of Warehouse and reporting solution including Golden Gate.
• Involved in strategic planning, project management, staffing, training and employee relations

Environment: Oracle 12.1.0.2,11.2.0.x/10.2.0.x, Exadata X6-2, RAC 11g/10g, RMAN, Golden Gate, Oracle Grid Control, OID OVD, ILM, MySql 5.x, SQL Server 2012, Linux Red hat 4x,5x,6x, EMC Clone, VPlex, Xbrick.

Confidential, MD

Database Manager

Responsibilities:

• Responsible for bringing latest technology in field of Database.
• Manage team of DBA’s on site and off site.
• Ensured team is compliant with regulatory standards and policies.
• Responsible for implementing Golden Gate technology leading to path of all live reporting.
• Managing and providing technical leadership to DBA team.
• Architect end to end migration of high profile external facing revenue earning database system from one Hardware to another with minimal downtime thus saving dollar amount.
• Responsible for building DR environments using Data Guard.
• Involved in Design of etl, Data warehouse, and BI studying of source system till end reporting.
• Responsible for Building 2 and 4 Node 11gr2 external facing RAC environments.
• Worked on bringing Hadoop in house and utilize for different applications.

Environment: Oracle 11.2.x/11.1.0.x/10.2.0.x, RAC 11g/10g, Banner, Backboard, RMAN, Golden Gate, Oracle Grid Control, Shell Scripting, Hadoop, SQL server 2012, Linux Red hat 4x/5x,6x, HP EVA

Confidential, DE

Lead Database Manager

Responsibilities:

• Leading migration project of migrating Servers, database and application from one data center to other.
• Lead the team for migration effort successfully completing migration well below project timeline.
• Managed team functions viz. manpower planning, recruitment, performance appraisal.
• Lead meetings with the Clients, Stack Holders and managing the expectations.

Environment: Oracle 11.2.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN, Shell Scripting, Linux Red hat 4x/5x, Solaris, HP EVA

Confidential, PA

Lead Oracle DBA Consultant

Responsibilities:

• Responsible for designing strategy moving the production databases between the data centers from east coast to west coast saving multi million dollars in infrastructure, timeline.
• Responsible for designing, developing and implementing the backup strategy enterprise wide using Data Domain Technology comprising of tapeless solution, replication to offsite for DR, encryption of data at rest and data in motion satisfying corporate security standards(sox,hipaa) thus saving multi million dollars.
• Responsible for assessing the infrastructure requirements, provide the cost estimates using costing model and develop timelines for specified projects.
• Worked with engineers, development teams, business product group and peers to understand the business requirements and help design develop and implement solutions that meet the business needs.
• Responsible for evaluating Oracle Exadata Quarter Rack for bringing it In House.
• Evaluated and brought in house Oracle Grid Control Monitoring thus saving dollar amounts.
• Providing technical and project leadership for oracle database migration projects to newer Versions 10g/11g.
• Responsible for preparing upgrade document for Oracle Grid Control Environment (oms, agent, database).
• Responsible for maintaining standard across board, maintain uniform environments patch set and one off patches.
• Provide status reports on key projects to senior management and make recommendations to optimize project implementations.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap.
• Establish and communicate the security guidelines and participate in Security Risk Assessments.
• Provide technical and management leadership to the consulting and junior staff.
• Research and analyze all assigned anomalies to determine root cause - produce, review, track and log all findings and recommendations.
• Collaborate with platform engineering and storage engineering teams to order the required hardware, install necessary patches and software to provide innovative solutions such as RAC and Grid computing.
• Serve as team liaison to project managers for database administration and system administration services.
• Responsible for road map of database versions, upgrades, PSU’s.
• Oversees database administration support for production, development, and test environments to include day-to-day monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, SQL and database optimization and tuning as well as providing technical leadership and leading efforts to research, analyze, and recommend patches, upgrades, and new technologies surrounding all aspects of data management using relational databases.
• Responsible for 4 installations of 12c, 11.1, 10.2.x Grid Control Environment.
• Responsible for 9 rac installations of 11gr2 and 10gR2 2/3/4/6 node on Linux red hat, creating 15+ rac client production databases, upgrading rac environments (GI, clusterware, asm, database).
• Responsible for staff planning, Conducting Interviews, Hiring, conducting performance reviews, goal settings, attracting and retaining the best talent.
• Managed change control meetings ensuring that changes to production environments are validated and thoroughly tested.

Environment: Oracle Exadata, Oracle 11.2.x/11.1.0.x/10.2.0.x/9.2.0.x, RAC 11g/10g, RMAN, Oracle Grid Control, Shell Scripting, SQL Server 2008, Linux Red hat 4x/5x, Sun Solaris 9, HP-UX 10.2/11, HP EVA, MSA

Confidential, Wachovia, PA

Sr Database Architect Consultant

Responsibilities:

• Evaluated maximum availability architecture and implemented data guard solution for Disaster recovery.
• Responsible for configuration and deployment of oracle 10g RAC solutions on Solaris.
• Responsible for creating document for upgrading/migrating 30+ databases to 10204 from 10202 and 9206.
• Provided training and technical leadership to Junior Database Administrators.
• Performed analysis of existing implementation and make recommendations to further improve performance, availability, scalability and take lead in getting those recommendations implemented.
• Responsible for evaluating and addressing technical shortfalls (bugs) and security concerns.
• Responsible for creating High Level Design from requirements.

Environment: Oracle 10204/10203/10202/10201/9208/9206, RAC, RMAN, SQL Backtrack, SQL, PL/SQL, SQL*Loader, OEM, Toad, Discoverer, Shell Scripting, Net 8, Sun Solaris 10/9/8, Veritas Cluster, Veritas File System, Veritas Volume Manager, Symantec I3 Monitoring, Aix-5.2/5.3, Linux Red hat 4x, Linux Suse 9, Sun E15/10/5K, E450, E420R.

Confidential, DE

Database Management Lead

Responsibilities:

• Responsible for designing and implementing complete Disaster Recovery Solution usingDisk replication and standby database for more than 30 production databases thus saving multi million dollars.
• Responsible for design of backups with Veritas Netbackup and Tivoli and lead prototype efforts.
• Responsible for performing capacity planning, space forecasting, architecting and designing the environment.
• Participate and lead in database management sub-committees to developSOPs & Work Instructions, Security Guidelines and to improve SLA response time.
• Responsible for design and deployment of 3 RAC solutions on Solaris with and without Veritas Cluster.
• Responsible for accessing infrastructure to validate performance, capacity andUpgrading the infrastructure there by managing the SLA’s with improved performance.
• Responsible for providing database management and reporting solutions for business partners.
• Providing leadership and database technical support in implementation of applications.
• Provide technical and management leadership to consulting and junior staff.
• Lead the capacity enhancements and new technology adaptability efforts for utilizing in house.
• Ensure standards and security compliance for Databases.
• Proposed, Implemented and documented proof of concept for business applications.
• Performed 30+ Installations of oracle 9i and 10g on various platforms, 80+ Migrations.
• Performed migration of three 2+tb 9206 databases from Hp platform to Aix platform.

Environment: Oracle 10202/9206/9204/8174, RAC, RMAN, SQL, PL/SQL, SQL*Loader, Oracle grid control, Oracle data control, Shell Scripting, Net 8, Sun Solaris 10/9/8,Veritas Cluster, Veritas File System, Veritas Volume Manager, HP-UX 10.2/11, Aix-5.2/5.3, Windows NT/2000, Sun, Hp, Aix

Confidential, PA

DBA/Architect Consultant

Responsibilities:

• Responsible for Engineering, Reengineering, Logical and Physical design of database.
• Responsible for implementing process to connect to heterogeneous database like Teradata from Oracle and implemented automated process for interacting with heterogeneous databases.
• Designed and lead prototype efforts for the backup and recovery strategy used across the board.
• Responsible for creating document to be used enterprise wide for Migrating of 8i database to 9i database, application of patches and patch sets, moving databases to different server, Refreshing dev/test/qa database with prod database.
• Responsible for Creation, Maintenance, Performance tuning, Backup and Recovery of database.
• Responsible for administration of cognos Power play and Impromptu.

Environment: Oracle 9i/8i/8.x, Teradata 7.0, RMAN, SQL, PL/SQL, SQL*Loader, OEM, IIS 5.0, Cognos Power Play 7.0, Cognos Impromptu 7.0, Perl Scripting, Shell Scripting, Net 8, Sun Solaris 2.7/2.6, Veritas Cluster, Veritas File System, Veritas Volume Manager, HP-UX 10.2/11, Windows NT/2000, Sun Enterprise Server E5000, E450, E420R, HP-K 570/220, Compaq DL Series, ML Series.