SUMMARY

• Strong database administrator with in - depth knowledge of Oracle 11g/10g, Oracle RAC, and MS SQL Server,
• A technician who has strong experience with Oracle Application 11i, SAP e-business suite (ERP) support, enterprise-level system integration, and system development life cycle management. Repeated success implementing applications and other software/tools across platforms;
• Special expertise in Data architect with professional experience designing database structures, database capacity, backup/DR strategy, and security management.
• Hands-on Database and application Manager with extensive experience of Lean exercise, Scrum management, Agile project methodology, license management, and vendor relationship.
• An effective technical leader who build team, optimize resources, evaluate/implement new technologies, and led team to maintain 24x7 production support that receives frequent praise from end users.
• A business professional with a strong background in Financial, Manufacturing, Education and Telecom industries.

TECHNICAL SKILLS

• Oracle 12c/11g/10g
• ORACLE RAC
• Oracle cloud
• Oracle ERP solution
• MS SQL Server 2014/2012/2008
• SAP ASE
• SQL Server Always On Availability Group
• Sybase 12.5
• Autosys
• Remedy
• AIX UNIX
• Red Hat Linux
• HP-UNIX
• SUN SOLARIS UNIX(2.8)
• PL/SQL
• UNIX-SHELL
• C
• ERwin
• ERStudio
• Oracle Designer
• EMC storage
• EMC BCV
• EMC SRDF
• DBArtisan
• Quest Center
• Nagios
• Autosys
• Remedy ticketing system

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

DBA leader

Responsibilities:

• Day to day database and database application administration that includes
• Oracle and SQL Database administration
• Database application development and implementation
• Ingenico customer mobile transaction monitoring and reporting
• Backup& recovery, troubleshooting, performance tuning, security, failover, and Disaster & Recovery.
• Oncall 24x7
• Database architecture design and implementation.
• Be the gatekeeper to review and approve all database related design and implementation, and database application release for continuous enhancement.
• Planned, Designed, and led the implementation of Ingenico Mobile transaction center processing system with SQL Server Always On
• Proposed next generation Ingenico Mobile transaction center processing system architecture that covers operation system, storage, database, and applications.
• Laid down the Pre-production SQL Always On environment for testing, which includes planning of installation, laydown system, install SQL, load service pack, and configure SQL Always-on on windows cluster
• Planned and tested Ingenico Mobile center system migration/upgrade from old hardware/architecture to new Always on architecture/hardware, documented the process for production upgrade/migration.
• Planned, and coordinated system integration testing among all cross functional teams. Identified the problems, developed and implemented the resolutions successfully before system go-live.

Confidential, Waltham, MA

DA manager

Responsibilities:

• Daily Oracle database administration that includes database object administration, performance tuning, backup& recovery & security management….etc.
• Oracle database 12c upgrade
• Oracle Cloud, MS Azure and AWS Cloud assessment
• Hands on manager to provide daily support and management to Bentley databases, middleware, and applications that covers Oracle, SQL server, Tomcat, Apache, Weblogic, Banner, Salesforce…etc. Data warehouse support and ETL job support Data security and application integration Bentley.com web application administration
• Established offshore On-call that includes support hotline, key application SLA definition with key users, conducted knowledge transfer to offshore team.
• Successfully led the implementation of the latest release of “mybentley.edu” with mobile friendly interface.
• Successfully led the implementation of Oracle cloud control and Lifecycle management auto patching
• Successfully led the implementation of Myphoto implementation
• Initialized and implemented the new database refresh process that improves Banner refreshing from 17 hours to 5 hours.
• Led the team to develop DA two year road map that includes application roadmap and infrastructure support roadmap
• Established DA change management guidance
• Established DA annual maintenance schedule

Confidential, Framingham, MA

Manager, Database and application

Responsibilities:

• Managed database team with size of 10 people from onsite and offshore to supports Confidential 120+ Oracle SAP databases, 100+ MS SQL Servers, SAP ASE, and SAP HANA 24x7 global wide.
• Day to day status review of production database support. Production emergency firefight, escalated problem resolution, project status review/obstacle resolution, and resource assignment to the adhoc DB requirements
• Oracle database strategy development to maximize Confidential existing Oracle investment, and successful execution of strategy.
• SQL Server database global strategy development and successful execution of strategy, such as SQL server global consolidation.
• Database license management and optimization, such as license strategy development, annual license audit and contract renew, vendor relationship management, and License consultant service for Confidential application teams who need to obtain database licenses…etc.
• New technologies and software evaluation, POC, procurement and implementation.
• Database project initiation and management to ensure continuous improvement and problem addressing. Below is a list of projects that requires 500+ support hours.
• Initiated RFP to consolidate Confidential database support vendors to obtain financial benefits and improve support efficiency. Successfully Executed the vendor consolidation and expanded database support to additional 200+ SQL servers global wide with no change of annual database support budget. ( )
• Developed SQL Server consolidation strategy and successfully executed strategy. ( )
• DataGuard DR solution implementation for business critical systems (2012)
• SQL Server 2008 upgrade (2012)
• 2012 SQL Always On Availability Group Implementation ( )
• Database PCI harden and compliance (2012)
• Nagios Open source monitoring tool implementation (2013)
• TimeFinder backup resolution POC and implementation ( )
• Oracle 11g upgrade in 2011and minor release patching on annual basis
• Oracle 11g database compression implementation ( 2011)
• Day to day Oracle and Microsoft SQL database administration hands -on support as needed to fill in DBA support gap

Confidential, Boston, MA

DBA Manager

Responsibilities:

• Established and led DBA team responsible for 24x7 support of production databases crossing Oracle, Sybase and MS SQL Server, and applications including distributed client/server systems and web based e-business, such as Golden Source Security Integration, TIBCO, EAGLE PACE EDM, CRD, PMA…etc.
• Set up team business plan; assisted in budget process; reviewed team PMPs quarterly to insure business plan was being executed successfully.
• Led DBA team to work closely with development and QA team to develop, enhance, and maintain of customized financial applications used primarily by internal business units. In charge of database related production release.
• Expanded DBA responsibility from infrastructure support to data modeling function to standardize database development process to improve data integrity control and security management. Defined database utilization policies, procedures, security, backup, and recovery to ensure accurate, appropriate, and effective use of data. Institutionalized data modeling processes and worked as Gatekeeper to review logical and physical models.
• Executed database strategic switch from Sybase to Oracle to enhance database capacity, flexibility and reliability needed to support growing business. Led project to pilot CRD (Charles River Developing) migration from Sybase to Oracle.
• Obtained Oracle RAC technology. Successfully led team to lay down the first Oracle RAC production data mart system of Pioneer Enterprise Information Management. Hands-on experience included Oracle 10g RAC installation and administration, Sybase migration to Oracle, RMAN backup and recovery, and Data Guard.
• Managed software service and relationship with software vendors. Obtained tools such as DBArtisan and ERStudio to improve DBA support capability of problems diagnosis, events monitoring, performance troubleshooting and optimization
• Initiated project to evaluate Oracle Data Change Capture and Attrunity Data Change Capture to support database globalization. Coordinated Pioneer Eagle PACE global implementation between Boston and Munich. Supported IBM ETL frame implementation in Boston and Dublin.
• Served as part of IT Governance team to standardize IT processes including project management, business analysis, data modeling, development cycle management, QA, change management, and on-call support.

Confidential, Boston, MA

DBA Lead

Responsibilities:

• Led DBA team to administer Oracle PARALLEL SERVER (OPS) 8i to support Confidential Center Trading System in an ORACLE OPS environment. Supported 24x7 production, database installation, security, performance tuning, troubleshooting, and backup/recovery. Used EMC BCV technology for DR strategy. Piloted upgrade from ORACLE 8i OPS to Oracle 10g RAC.
• Guided DBA team in administering Sybase 11/12.5 database installation, security management, performance tuning, troubleshooting, and dump/restore.
• Attended weekly meeting with development team to review current requirements; coordinated DBA support. Coordinated with System Administration, Network, Data Center and other functional teams to allocate DBA resources for projects and requests that are responsible for; followed up on project status to insure successful support
• Standardized database support, change management and accident reporting procedures to lower system downtime and to improve request turnaround time.
• Initiated project to implement RMAN backup and led DBA team to complete its implementation.