Database Architect Resume Profile
Experience Summary
- Over 23 years of professional experience in IT services, delivering projects to finance, banking, bard Processing, mortgage, healthcare, government, financial service, media, telecommunication, transportation, manufacturing and IT Services industries.
- Managed multiple infrastructure projects in a Program during transition period of acquisitions mergers and streamlined operations for post transition period for several clients.
- Successfully migrated entire company infrastructure to new data center saving clients tens of millions of dollars by combining platform migration, upgrade, and server consolidation projects into single project delivered in record 9 month timeframe.
- Interacted with CIOs, CTOs, COOs, Chief Architects, and Program Managers, and presented architectural designs, solutions, and project strategies and plans.
- As Database Architect and project manager designed and successfully delivered data center migration, platform migration, upgrade, server consolidation with high availability in single weekend of multi-terabyte databases with minimal business interruption.
- Responsible for supporting an estimated 600 databases for around 100 enterprise applications running on over 150 servers.
- Over 21 years of Oracle DBA experience in server and DB sizing, design, installation, upgrades, multiple platform migrations from one O/S to another O/S, configuration, tuning, working with vendor for problem resolution, support multi-terabytes size production databases with 5000 users in 24X7 global environments running business critical applications. Installed OEM Grid control, developed RMAN scripts for backup and recovery, standby databases for DR using Data Guard, Real Application Cluster RAC implementation, support, ASM, patching, and all aspects of Oracle infrastructure administration.
- Excellent proven hands on skills in UNIX administration, Shell Scripting, data analysis, data modeling, system analysis, requirement gathering, system design, logical database design, physical database design, backup, recovery, high availability, disaster recovery planning, and implementation and testing.
- Developed ITIL based Standard operating procedures, service catalog for global IT, IT Services costing model that is instrumental in creating transparency to business on IT spending, gaining clients repeated business by reducing 1.2 Million IT services cost. Created strategies for IT Service cost reduction, presented strategies to IT executive, initiated and executed strategic projects to reduce IT cost successfully.
- Excellent IT Operational experience and worked closely with service desk managers to improve customer experience.
- Hands on Project Management with over 15 years of IT Infrastructure delivery experience, strong technical background, IT Service Management and IT Service Delivery experience for ERPs like PeopleSoft, Siebel, Arbor, Lawson, CableData etc.
- As Project Lead created infrastructure delivery strategies, project plans, schedules, budgets, TCOs, staffed projects, identified risks, contingency plans and QA plans, defined roles and responsibilities, and managed delivery of infrastructure.
- Managed multiple complex projects simultaneously, involving matrix delivery teams consultant, driven projects through corporate governance, financial, architectural, change reviews boards, worked with vendors, coordinate procurement, logistics, infrastructure delivery, coordinated tasks with systems, network, security, and storage teams.
- Regularly conducted status meetings executive presentations to Sponsors, Sr. Management, program managers, peer managers and clients with accomplishments, issues and escalations.
- Developed plans for infrastructure local failover, DR drills, and datacenter power shutdown and move projects. Developed minimal downtime to minutes for Oracle upgrades/switchover/failover using Data Guard.
- Interacted with Corporate Security Office, internal SOX auditors, enforcing SOX, HIPPA and other corporate security policies. Identified security, DR risks and implemented mitigation solutions across IT departments.
- Task force member for Corporate governance process, SDLC, and change control process design
- Liaison with application, business owners in defining SLA, and worked closely with service desk in incident resolution.
- Improved customer satisfaction by align with business users, improving IT services, reducing incidents, improving response times, resolving problems by root cause analysis, implementing problem resolving solutions, and providing metrics.
- Excellent communication, presentation, leader ship, people, management, and analytical skills.
- ERPs: PeopleSoft HRMS/ELM 9.1, PSTools 8.5 Oracle Financial 11i, BMC Remedy 7.1 BMC Portal, Siebel, DataStage Tools: Microsoft Project, Power Point, Word, Excel, VISIO, Access, NIKU Databases: Oracle 11gR2/10g/9i/8i/7.x/6.x SQLServer 2005/2000/7 Dbase IV Case Tools: Designer, ERStudio, Erwin Process and Data Modeler, Toad Data Modeler Hardware: Cisco UCS, IBM 8230 Power7, RS/6000, P770, P570, P630/ HP9000 -V2250, K380, D390, H70, E55, E45 / SUN Ultra1, 10, E420, E450, E4500/ VAX 34XX Cluster / DEC Alpha / Windows / Macintosh
- Operating Systems: AIX 6.1/5.3, HP-UX, Sun Solaris ULTRIX, SCO, Oracle/RedHat Linux 5,6 , Windows
- Languages: Java, MS .Net, .Net Framework, C , C, PL/SQL, HTML, XML, UML, Shell Scripting
Confidential
Database Architect
- First Data is one of the global leaders in providing Debit, ATM card processing, merchant payment processing, Point of Sale processing around the world. On day-to-day basis it processes around 30 Million transactions.
- As architect, re-designing the Debit transactions settlement system from current file based processing into Oracle database based settlement system that is flexible to allow new frequent settlement cycles.
Confidential
Database Architect
- Saved an estimated 6 million dollars by delivering all applications to run in Ditech data center 3 months earlier than Transition Services Agreement TSA deadline.
- Database infrastructure delivery is lynchpin for this migration as all 100 applications rely on database infrastructure.
- As Database Architect analyzed current infrastructure, and made up of 60 plus Unix servers running on 10g and 11g Oracle databases running on different flavors of Unix accessed by about100 applications.
- Planned, designed and successfully migrated 20 production databases sizes ranging from 500GB to 6 TB over single weekend from old data center to new datacenter with least down time.
- Architected processes to migrate from Sun Solaris and HP-UX to Linux platform, upgrade from 10gR2 to 11gR2, and converting from single instance to highly available clustered environment.
- All Production databases run on single three node 11gR2 RAC with DR capability to remote site to running RAC.
- Designed and delivered four 3 node RACs for production, staging, development and testing to run in 24X7 environments with 2000 user base.
- Delivered this project in a record 9 months.
- Managed multi-terabyte Data warehouse databases like Data Stage and many OLTP databases.
- Headed a team of 10 DBAs and managed all migration activities of database infrastructure that had also included Microsoft SQLServer 2005/2008 to SQLServer 2012.
Environment: CISCO UCS, RedHat Enterprise Linux 6.2, MS Windows XP, 2000/2003, Oracle11g, Data Guard, OEM Grid Control 12c, RMAN, RAC, NetApps, VMWare, ServiceNow, Microsoft Project, and Toad 12, OEM 12c, Tomcat, Apache, .Net, IIS, Datastage, BusinessObjects
Confidential
Lead Database Administrator
- As Lead Database Administrator responsible for over 100 database in 24X7 environment with Oracle running on versions 11gR2/10g RAC and standalone environments supporting PeopleSoft HRMS 9.1, PeopleSoft ELM 9.1, Quest STAT 5.5, Oracle Financials 11i, Oracle Identity Management 11g and BMC Remedy Service desk 7.1 production, development, QA environments. Lead team of DBAs and manage upgrade and datacenter move projects of Database infrastructure.
- Migrated databases from one platform to another platform like AIX to Linux, Windows to Linux. Sized Servers for multiple ERPs like Oracle Financials, PeopleSoft, BMC Remedy, Foglight etc.
- Installed and configured OEM Grid control 12c/11g management packs.
- Installed and configured RMAN with IBM Tivoli Data Protection, and VERITAS NetBackup for Oracle for backup of about 100 databases for restore recovery.
- Configured Oracle Standby databases for high availability and upgraded with 15 minutes downtime using Data Guard.
- Performed patching, upgrade, SQL Tuning, Trouble shooting, working with Oracle to open Service requests for resolving issues.
- Played key roles for DR drills, and implementation of multiple data center move of database infrastructure.
- Responsible for Remedy Service Desk Database installations, configuration and upgrade, CMDB, security remediation and numerous infrastructure and service delivery upgrades.
- Responsible for database infrastructure capacity planning, infrastructure upgrades, project schedules, estimates, issues, risks, contingency plans, QA, delivery of database infrastructure for Production, development, and QA environments.
- Provide databases services based on ITIL based Enterprise Service Management Remedy database infrastructure, and implemented best practices for successful delivery of IT services, manage SLA and service restoration, incident and management and worked closely with service desk, external vendors to improve IT services.
- Developed procedures streamlining operations through standard operating procedures, reducing incidents and implementing problem resolutions.
- Installed and configured IBM AIX 5.3/6.1/Linux based Oracle 11gR2/10gR2 Real Application Cluster with multi-node RACs for Production/Development/QA load testing environments for PeopleSoft, Remedy, and OIM etc.
- Support E-commerce Oracle Financials, and Oracle Identity management Oracle 11g environments for Production, Development and QA. Configured OIM, OID for maximum availability architecture with automatic failover.
- Install and administer Web Logic environment. Automated PeopleSoft interface sent to Mainframe through sftp.
- Manage and troubleshoot Esker Delivery Ware 5 environment for paperless e-commerce fax integration and routing e-faxes to facilities.
Environment: IBM AIX 6.1, 5.x, IBM-8233-E8B, Power 7, 9117-MMA, LPARs, P630, P570,P630 RS6000, GPFS 3.x, Enterprise Linux 6, RedHat Linux, MS Windows XP, 2000/2003, Oracle11g/ 10g, Data Guard, OEM Grid Control 11g/10g, RMAN, RAC, EMC Clarion/ESS Storage, Tivoli Data Protection for Oracle: version 5.5.1.0, VERITAS NetBackup for Oracle - Release 6.5, VMWare, BMC Remedy, Microsoft Project. Toad 10, Foglight6,Foglight5, BMC patrol, Esker Merkur Deliveryware 5 Document management. PSTools 8.5x, PeopleSoft HRMS 9.1, PSTools 8.51, Oracle Identity Management 11g, BMC Remedy Service Desk 7.1, Quest Stat 5.5, Oracle Fusion Middleware 11g, BPEL, Oracle Financials 11i 11.1.10
Confidential
Manager, Database Information Management
- Managed multi-million dollar IT service management, infrastructure project delivery, capacity planning, created infrastructure delivery strategy, project schedules, budgets, estimates, costs, issues, risks, contingency plans, QA, defined roles responsibilities, delivery of infrastructure for development, QA and production environments.
- Lead multiple projects in Integration Program into Bowne from acquisitions of Vestcom, and streamlined post transition operations.
- Managed ITIL trainings, ITIL Service Management Assessment project, IT Cost model projects and implemented ITIL based best practices for successful delivery of IT services, managed SLA and negotiated OLA, service restoration, incident and management and worked closely with service desk, external vendors to improve customer service.
- Presented strategies on IT cost reduction and streamlining operations to executives and Sr. Management. Developed a cost model to provide transparency on IT spending and reduced it support costs by 1.2M.
- Streamlined operations through standard operating procedures, reducing incidents and implementing problem resolution plans. Boosted DBA team moral and increased productivity by 5 times and created a model team in global operations.
- As a Lead DBA responsible for services in complex global 24X7 Oracle with 10/9i/8i, 10g RAC, OEM Grid control, management packs with RMAN with IBM Tivoli Data Protection integration for backup, restore recovery, Oracle Standby databases for high availability Data Guard, MS SQL Server 7/2000/2005 clusters.
- Played lead roles for DR drills, and implementation of site power down, multiple data center move of database infrastructure.
- Lead diverse highly skilled technical team, supporting about 600 Oracle and MS SQL Server Databases for about 150 applications.
- Lead Remedy Service Desk upgrade, CMDB, security remediation and numerous IT infrastructure and service delivery projects.
Environment: IBM AIX 5.x, 4.3.3, P630, P570, P630 RS6000, HPOpenVMS, MS Windows NT, 2000, Oracle10g/ 9i/8i/ 8.x/7.x, Data Guard, OEM Grid Control, Erwin, RMAN, RAC, MS SQL Server 2005/2000/7.0/6.5, EMC Storage, Tivoli Data Protection 5.x for Oracle, Citrix, BMC Remedy, Project Central, SharePoint, VMWare, LanDesk, Microsoft .Net, C , Microsoft SharePoint
Confidential
- Cablevision Systems Corporation NYSE: CVC is one of the nation's leading telecom and entertainment companies.
- Project Leader, Senior Oracle DBA, Team leader for interactive Optimum Project
- Project leader Sr.DBA for Mediation project in Digital Set Top Box project Interactive Optimum or iO .
- As a Project leader for Mediation Project involving Subscriber Management Systems SMS and Entitlement Message Management Generation EMMG , transitioned the project from Accenture. Lead 4 DBAs and 4 Java developers.
- Played key role in Architectural design through implementation phases of the project.
- Gathered business requirements, involved in design, development, QA of iO systems, Corporate IS systems related to iO project. Designed and developed 3.2 million customers data replication from Corporate IS systems to Engineering Systems. DBA for over 25 Oracle databases sizing from 500GB to 2TB with 24X7 availability
- Designed and developed Java based Server and C based client socket system for MD5 key generator to encrypt messages.
- Installed Siebel 2000, on Solaris, and played critical role in migrating Siebel from NT to UNIX/Linux environment.
- Installed Arbor formerly Kenan cable and telephone billing system and administered databases of Customer, admin, catalogue databases in multi server architecture in Solaris environment.
- Designed data mapping between various iO systems for Enterprise Reporting project, designed data extraction processes for interfaces to Remedy, Arbor, Mediation, Customer Index, InTouch, and Account Management Systems. Designed and developed data extraction and loading system for Cable Modem Bricking interfaces.
- Focal point for Database issues resolution for interactive Optimum iO Digital TV systems.
Environment: Sun E420, E4500, Sun Solaris 5.6 to 5.8, HP 9000/800 Series V class 2250, K380, H70, E55, E45, HP-UX 11/10.2/9.2, Oracle 8i/ 8.x/7.x, Designer 2000,Discoverer 3, EMC Storage, Veritas VM and Tandem
Confidential
UNIX Administrator, Senior Oracle DBA, Project leader for Corporate Database
Environment: HP 9000/800 Series V class 2250, K 380, H70, E55, E45, HP-UX 11/10.2/9.2
Oracle 8.x/7.x, Oracle Financials, Lawson, Power Builder, Developer 2000, Designer 2000,Discoverer 3, Omni Back II, Glance, and Perfview Monitor
Confidential
Senior Oracle DBA, System performance Tuning and Upgrades
Environment: IBM RS/6000, AIX, Oracle 7, PeopleSoft HRMS 4.1 and Crystal Reports
Confidential
Predict Demand System for Rover Group UK Lead DBA, Architect and Sr. Developer Nov '95 Dec '95
Involved in the development and testing of predict demand system as a Lead DBA, Architect and Sr. Developer.
Confidential
Oracle DBA, support for Development and Testing for a team of 12 members
As a DBA handled the database administration, testing and development support actives.
Confidential
Oracle DBA, supporting Development and Testing
As DBA and developer, involved in the design, development, coding standards preparation, coding and testing
Confidential
Order Processing Invoicing System
Systems Designer Developer
As a designer and developer involved in the installation, design, development, project coordination.
Confidential
Systems Analyst and Developer
Designed application, database, tables, triggers, clusters, indexes, forms for Sales order processing in a team of 6.
Confidential
Goods Transportation Management System
Systems Analyst and Developer
As Systems Analyst and Developer, performed installations administration, and development of application.
Confidential
Oracle Developer
Confidential
Text Processing Utilities
Developed automated tool for a PL/I to COBOL code conversion, for a multi-national company.