PROFILE:

• Results - driven and customer-focused, a senior DBA consultant with expert hands-on tech skills, keen understanding of various dbms and software technologies, a self-starter and highly motivated in bringing about improvements with efficient and methodical IT troubleshooting skills to help lower IT's total cost of ownership to the business stakeholders.
• AIX 4.3/5L/6, Linux Oracle 9i,10g, 11g DG, Oracle As, EM, Grid
• Solaris 7,8,9,10 RAC 10G/11gR2/11Gr1,ASM ECC 6.0 Basis
• HPUX 10/11, Alpha OSFSQL Server 6.5,7.0, 2000 BroadVision
• Windows XP, Advanced Server UDB DB2 7,8Vignette
• Informix IDS2000, AccessApache mySQL, Pervasive SQL, NetezzaNetscape Enterprise Srvr
• Applications / Tools Oracle Gateway
• Oracle 10.7/ 11i/12 (e-Business Suite)
• Customer Care and Billing (CC&B)
• PeopleSoft 7.5/8.x, Ellipse EAM (Mincom/Ventyx)
• SAP R/3, Basis, NetWeaver, ECC 6.0, Solman
• Visio
• Kintana MsOffice
• Peregrine ErWin
• Lotus Notes TOAD, Precise, i2, Quest Performance Analysis i-Learning (Oracle)SiteScope, OpenView/BMC Patrol, NetBackup, sqlBacktrak
• Oracle Forms, Reports Tivoli Storage Manager (TSM)
• Oracle Discoverer, Oracle DesignerEmbarcadero DbArtisan
• SharePlex, fastunload,fastcopy, OpenView, BCV,HUR
• NetBackup, Legato (NMDA interface) TimesTen, Clarity, Ellipse, OMS, OID
• Confidential Ensemble, Enabler, Clarify, copyBan, Tiger |
• BMC Remedy Ticketing System, Clarity System
• MVSTAR Itron (Meter Reading system), SmartMetering (ODS)

WORK EXPERIENCE:

Sr Technical Consultant - Oracle DBA

Confidential

Responsibilities:

• Optimized Oracle sql/plsql scripts with Oracle support team for the legacy databases’ conversion to CC&B, ensuring that the entire conversion process will fit into the 48-72-hr conversion window towards golive date; helped and advised conversion team in the use of datapumps, bulk collection inserts, explain plan, advisory tools, oracle hints, temp/staging tools, parallelism to complete the successful conversion within limited timeline.
• Performed controlled patching/change implementations and management, database changes, CC&B config/reference/transaction push; Made and implemented actionable technical solutions and recommendations and consulted with development in database re-organizations, to improve performance and ensure maximum uptime of the databases as well as tuning of heavy hitting sqls using various DBA techniques (data skewing, db objects fragmentation, suboptimal optimizer plans, reindexing strategies, scripts simplication, use of oracle hints, stored outlines, profiles for plan stability).
• Perform cloning of databases using various methods (transportable tablespaces, expdp/impdp, cross-platform migration); perform databases and server consolidation to reduce Oracle licencing footprints (enterprise licensing, db options review and removal where not required to reduce TCO.
• CC&B data/code refreshes, Monthly staging databases refreshes from production using shadow HUR/BCV ; Setup Oracle ASM instances in production and non-production environments; Setup/build/production support of 12 10g/11gR1/11gR2 RAC databases using ASM in production and staging environments; Migrated non-ASM to ASM; Lead conversion of a single nodes databases to Oracle RAC, non-ASM to ASMs; Install Oracle patches, custom inhouse code, Oracle critical patch updates
• Perform Oracle CC&B db/apps-tier patching procedures on development, testing, staging and production environments following a rigorous method of tracking, documenting and testing of each db upgrade phases. Said patching includes database/schema refreshes from source to various environments with smoke tests after each phase.
• Helped in the planning, blueprinting, pre-go-live implementation phases of CC&B implementation projects where middletier and backend tier layers of technology stack are concerned. On-site collaboration with onsite Oracle support, CC&B patching procedures, audit trailing, methodical deployment of various of patches from Oracle support, in-house patches, deployment/rollback before hand off to the testing group.
• Performed performance tuning on prod CC&B batch (general slowdowns, change in optimizers’ typical execution plan, excessive LIOs and other db init ora tuning paremeters, tables/index reorg (shrink/compact/reindex/move), using tools such hints, parallelism, reindexing, histograms, stored outlines/profiles, EM advisories, sql scripts, ADDM and AWRPT resulting in significant improvements from 10% - 80%.
• Perform data modelling/normalization/denormalization strategies using Erwin Case for data modeling DSS/datawarehousing db envs such as ODS, OMS, IAM (SmartMeters project and CC&B apps)
• Work as a very effective team member with other support IT groups such as Oracle Support, Unix, Websphere, network, SAN, application support, developers, testers ensuring issues-ownerships and prompt resolutions.
• Helped create SAP landscapes in FI and CO, ECC6.0, created transports and performed ECC 6.0 Basis admin work. - this project in conjunction with TH Ellipse, MvStar, OMS and ODS satellite prod application and databases.
• Perform operationa production and dev DBA support which included end-to-end performance tuning for the onlines as well as keeping batch processing windows within the SLA timeframe, at one point, able to fix a recurring suboptimal execution plans to revert back to the most optimized plan reducing the batch jobs duration by 30%-60% improvement.

Hardware/software: AIX, EMC storage, IBM Shark SAN

Applications: ORACLE CC&B, Clarify, Siebel, Neteeza DW

Databases: Oracle 8,9.2.0.x, RAC, 10g,11gOthers WebSphere, Precise, Toad, HQ LoadRunner, QTP, ASM, DG

Sr Oracle DBA

Confidential

Responsibilities:

• Performed database capacity planning for proactive OS and db space management to ensure continuous database availability
• Performed DBA on call on rotations with other DBAs, carry pagers and notebook for 24x7 rotations onsite as well as remotely within SLAs ensuring proper handover details from outgoing as well incoming DBA shift
• Performed build/create/cloning/ETLs/refresh/conversions on 150+ prod and nonprod databases using various technologies such as custom-scripts, hot/cold shadow copying, Oracle data pump, HUR (Hitachi) and BCV
• Performed Confidential -special procedures such as copying of BANS, create ETL extract scripts from operational Ensemble / Enabler ERP into BIDW, env refreshes using custom scripts/oracle datapump on database, schemas and table/row
• Performed performance tuning for baseline stats as well as for break-fix emergency production situations using appropriate indexing and parallelism, oracle hints, undos config adjustments, gather stats and oracle explain plan methodology resulting in timely re-execution of failed mission-critical batch jobs.
• Attended management meetings, post-mortem sessions and brainstorming sessions with mid level managers, DBA peers and application support groups in technical discussions, implementation of projects planning and checklists signoffs, and risk-assessment analysis
• Worked with Oracle support for TAR creation on Sev1 and other lower severity issues, follow ups, downloads/uploads up to resolutions, metalink notes, patching/release procedures for known bugs and issues/workaround - overall objective is to get maximum and timely vendor assistance to mitigate/minimize production impact (issues logged - bit map corruptions, data dictionary corruptions due to os-lunids massive failures, known bugs, support matrix issues )
• Worked with other tech groups (Unix, Weblogic/midtier, network and SAN) ensuring issues-ownerships and prompt resolutions and knowledge sharing of critical procedures and helped in the documentation of these procedures as accurately and up-to-date as possible.

Hardware/software: AIX, Solaris, EMC storage, HP

Applications: Proprietary Ensemble, Enabler, Clarify ( Confidential telecom billing applications)

Databases: Oracle 8,9.2.0.x RAC, 10g,11g, mysql, UDB DB2, Sql Server 2000

Others: Bea WebLogic, Precise, Toad, SharePlex, FastCopy, EMC Timefinder, OpenView

Senior Oracle Consultant

Confidential, CA

Responsibilities:

• Administers 25 Oracle distributed databases production and UAT databases for Confidential DW, pensions, RETEK and ecommerce apps with sizes up to 2.5 TB in size)
• Supported and migrated 4 Confidential pensions and benefits DBs application systems from the Eaton Center datacenter to North York data center, resolved with network group certain firewall ports/oracle/windows issued which impacted production business hours for sometime.
• Provided DBA production supports (but not limited to pure DBA tasks), firewall/network issues resolution, space contentions, tuning SQLs, wrote performance monitoring scripts and quick diagnostics tools for fast turnaround DBA support
• Provided enterprise data warehousing DBA administrations (MDW, 3TB)
• Supported production /test environments using Micro strategy applications. Confidential liquidation applications and other merchant /retail applications
• Performed lead hands on DBA role in migrations of dbms from SAN to another SAN env, from Informix to Oracle (design, create, migration, data/structure), patching of Oracle CPU quarterly
• Managed and resolved potential db issues before they becomes production problems which lead to downtime and database unavailability
• Migrated various databases from Informix to Oracle, performed lead role in hands on migration from old SAN (Shark) to a new SAN on the Oracle database portion
• Provided important soft skills in team and technical lead roles playing, works well with other tech groups, owned issues and resolutions processes in timely manner.

Hardware: HP Superdomes, Sun, EMC storageSoftware HPUX, Solaris, Linux, Windows

Applications: Proprietary Ensemble, Enabler, Clarify ( Confidential telecom billing applications)

Databases: Oracle 8,9.2.0.x RAC,(4.5+ TB), mysql, UDB DB2, Sql Server 2000

Others: Bea WebLogic, Precise, Toad, SharePlex, FastCopy, EMC Timefinder, OpenView, Timesten

Senior Oracle Consultant

Confidential

Responsibilities:

• Administered at least 55 Oracle distributed databases production and UAT databases for Confidential outsourced environments for Cingular, Nextel, Sprint and their partners (up to 4.5 TB in size) using Ensemble Enterprise applications for telecom billing
• Participated in the first line of mission-critical databases’ 24x7 support with strict guidelines of various SLAS, turnaround times and security and confidentiality agreements between Confidential and their clients
• Wrote and deployed OS and sql scripts to proactively monitors database metrics and alerts threshold level for performance indicators, server resource utilization (cpu, sessions, disk, memory, io), and multitude of db metrics
• Performed DB management / adminstration roles such as EMC BCV, replication, failovers (Timesten, RAC, snapshots, Shareplex, fastcopy), managed standby databases, recovery, DRP and customer-facing troubleshooting with methodical care and procedures
• Worked in multicultural technical environments and with close coordination with Unix, network, storage, application and other technical vendor and service providers with emphasis on clear procedures and terms of verbal and written communications to deliver cost-effective results to issues
• Performed lead roles in sql/application tuning to help developers in order to boost performance, develops business rapport with other groups to ensure service delivery is top notch and of excellent quality
• Performed fast turnaround production troubleshooting and performance bottlenecks troubleshooting and disagnostics in realtime before and when SLAS are breached (blocking locks, parallelisms, deadlocks, rogue sessions, sql tuning, finding resource contentions, networks, io, latencies, archiver stuck, general application slowdowns)
• Wrote scripts to actively monitor OS and databases metric for automatic alerts; performed changes to production in controlled environments and processes.
• Managed and resolved potential db issues before they becomes production problems which lead to downtime and database unavailability, performance change configuration as scheduled and planned
• Excellent technical as well as equally important soft skills in team and technical lead role, works well with other culture and able to work around corporate politics to deliver timely results to issues

Hardware: HP Superdomes, Sun, EMC storageSoftware HPUX, Solaris, Linux, Windows

Applications: Proprietary Ensemble, Enabler, Clarify ( Confidential telecom billing applications)

Databases: Oracle 8,9.2.0.x RAC,(4.5+ TB), mysql, UDB DB2, Sql Server 2000

Others: Bea WebLogic, Precise, Toad, SharePlex, FastCopy, EMC Timefinder, OpenView, Timesten

Confidential

Contract DBA

Responsibilities:

• Implemented methodical change management procedures on databases; performed planned and time-critical fix releases and upgrades for Confidential World Markets banking applications such as schema cloning, data repopulation, index/table rebuilds and db space management, proactive os and sql scripts creations
• Performed Oracle software installation, DB creation and day-to-day administrations (usability, RMAN backup/restore tests among other typical DBA tasks) of Oracle databases and instances on RAC and non-RAC (DEV, UAT and PROD)
• Setup cron/OEM jobs, wrote Unix shells/Oracle scripts to perform specific tasks such as application-related jobs, DBMS-related maintenance jobs such as statspack runs and other monitoring jobs (runaways, shared memory issues, disk/space, cpu utils checks, XA/indoubt tx clearing/monitoring)
• Managed db, schema and object level administrations via command line as well as using 3rd party tools (csh, ksh, OEM, TOAD, DBArtisan) on a day-to-day basis as well as during break-fix situations.
• Performed troubleshooting and diagnosis of high severity issues impacting overall performance and when it’s necessary, to escalate issues with Oracle Support and collaborate with various groups (SAN storage, UNIX, network, TELCO,vendors) in order to completely resolve the issues at hand.
• Able to identify points of failure in production batch setup scripts (TIDAL setup/configuration) causing repeated batch failures impacting production.
• Able to proactively monitor and resolve imminent DB issues before they become transparent to the user community.
• Able to work closer and foster better business and technical relationships with the privileged users and gain their cooperation and respect
• Able to diagnose and confirm with Oracle Support that current DBMS configurations were optimal and ideally setup as per specs requirements.
• Able to formally document methods and procedures, systems flows and diagrams for technical group's central documentation library.

Technical Environment:

Hardware: Sun MidRange DB servers, Vseres

Software: OS - Solaris 8 and 9

Applications: Proprietary Banking Applications

Databases: Oracle 9.2.0.4 RAC,(900+ GB, DEV/UAT/PROD)

Others: Bea WebSphere, iPlanet, Citrix, VCS

Confidential

Contract DBA

Responsibilities:

• To resolve observed performance degradation issues of some of the critical production batch jobs since a major change request was implemented.
• To verify, validate and confirm that database settings and configuration were at their most optimal levels and configuration settings.
• Able to verify with statspack and other monitoring tools that overall performance degradation was due to the high lios and i/o disk contention resulting from the change of the production SAN configuration.
• Implemented performance tuning fix - working with proper indexes and usage, appropriate degrees of parallelism, use of datapumps over exp/imp tools, use of histograms, analyze stats - resulting in improved overall batch performance for their production env.

Technical Environment:

Hardware: IBM P/Series 690 DB servers

Software: Aix 4.3/5L

Applications: Proprietary Batch Applications

Databases: Oracle 7.3/8.1.7.4/9.2.0.4 (1.2 TB)

Others: Citrix

Confidential

DBA / Senior Analyst

Responsibilities:

• Created, administered and managed numerous databases for various large outsourcing Confidential clients such as Banking and Investment Group (Zechner, AIG, TD), AirLiquide North America and Europe and Manulife Financial (sizes ranged from small, 50+GB to large, 4.3+TB)
• Troubleshoot and diagnosed high severity issues impacting production core business hours and performed whatever it took to resolve situations to full completion (lock / waits events analysis, runaways kill, blocker/waiters identifications)
• Managed N-tiers layers of the production environment including but not limited to the db tiers, the Broadvision application layers, presentation layers as well the web server tiers. (Broadvision server/web server builds, db server builds and administration for Airliquide ecommerce sites, upgrades, migration, relocations of hosts servers from Houston, TX to Europe)
• Performed regular/adhoc RMAN backup and restores/recovery procedures as part of overall DBA procedures, periodic backup dumps tests and DR exercises included.
• Worked very closely with various vendors such as EMC, Brocade, HP, IBM, Oracle, Veritas (Symantec), Sun, SAP in order to resolve high impacting issues; documented issues and confirmed resolutions to full completion and provided closures to tickets.
• Performed Oracle 10.7/11i System administration role in addition to the production DBA role for Airliquide (install, cloning, patching and systems administration).; Created, tested and deployed 11i core enterprise DBs extraction scripts for Maximo backoffice processing and enterprise datawarehouses.
• Performed Peoplesoft 8.x administration and configuration tasks for Airliquide Houston for their HR, Benefits and Payroll modules (sqr migrations, MF COBOL compilations, apps server build and troubleshooing of the apps domain.
• Performed UDB DB2 DBA role for Manulife Financials, this included but not limited to, install of DB2 binaries, database/instances creation, implementing change requests via Confidential change management methodology and worked in close coordination with Manulife technical groups to resolve production issues.
• Worked in close coordination with local Airliquide France and Belgium technical group for their e-commerce database applications using BroadVision, Oracle and Netscape technologies.
• Gathered information, interviewed outgoing staff and prepared intensive systems architecture literatures (diagrams, build books, methods of procedures, manuals) for formal documentation and internal use knowledge base repository
• Participated in the Confidential outsourcing planning and implementation execution of AirLiquide datacenter relocation from Houston to Phoenix, Arizona and France & Belgium
• Participated in the procedures and logistics planning in the servers’ build/decommission/consolidation as a major part of the Confidential and AirLiquide outsourcing agreement.
• Performed business-as-usual and break-fix technical DBA support to Houston datacenters as well as Phoenix datacenters hosting Confidential /Airliquide enterprise databases of up to 4.3 TB of databases.
• Participated in various Disaster Recovery simulations, exercises and failover testing off-site and on-site SunGuard and Confidential DR sites.
• Prepared and implemented succession plans to transition mission-critical current role and other critical support roles to incoming staff to ensure support continuity prior departure
• Helped Confidential outsourcing production support relocation of mission-critical 24x7 e-commerce sites from Houston to Toronto and France
• Helped Confidential and AirLiquide meet its target time and resources constraints and deadline in the server consolidation (AIX and Solaris) planning and execution from Houston to Phoenix
• Helped Confidential in its server consolidation (HPUX and Solaris) planning and implementation for its Banking and Investment group in Toronto
• Able to manage and orchestrate successful delivery of critical and complex systems requests/implementations and planned changes among various technical groups (Unix admins, networks, DBAs, business testers/users, web admins, vendors) located in remote locations

Technical Environment:

Hardware: IBM P/Series, SunFire Vseries and Eseries, Compaq Proliant

Software OS: Aix 4.3/5L, Solaris 7,8,9, Windows NT

Applications: Proprietary, Banking/Insurance Applications, Oracle Apps 11i Peoplesoft 8.0, SAP R/3

Databases: Oracle 7.3/8.1.7.4/9.2.0.4/10 g, SqlServer 7/2000, UDB EE 7/8

Others: Netscape, Apache, BroadVision, Vignette, Websphere, Mqseries

Confidential

DBA

Responsibilities:

• Led DBA group in supporting Confidential Informix production databases
• Provided day-to-day databases administration such as morning overall health checks and monitoring reports analysis
• Prepared migration/upgrade plans and presentations for upgrading current Informix version.
• Able to participate immediately in the rotational-on-call pager DBA support for Confidential production databases
• Able to present the migration/upgrade presentation plans to the higher management to secure their approval and buy-ins
• Able to share the bulk of DBA workload more evenly enabling among the DBA group members resulting in increased efficiencies

Technical Environment:

Hardware: Compaq ProLiant DB servers, HP C,K Class

Software: Windows NT, HPUX

Applications: Custom Courier Tracking Application

Databases: Informix

Others: DataStage Ardent, COBOL, Tuxedo