PROFESSIONAL SUMMARY:

• Expert in Oracle DBs with over 20 years of Oracle Architect, development and Administration experience
• Built complex Oracle symmetric replicated environment on a SUN/Linux platform
• Design and build backend database support for applications software
• Installed and upgraded various Oracle DBMS releases, including 12c, 11g, 10g, 9i, 8i and 7.3 on Linux, and Window.
• Develop/Review/Tune PL/SQL code and queries
• Expert in SQLServer DBs with over 9 years of Administration experience.
• Installed and upgraded various SQLServer releases, including 2000, 2005, 2008, 2012 and 2014 Window environment.
• Develop/Review/Tune T - SQL code and queries
• Installed and upgraded various MySQL releases, including 4, 5.0, 5.1 and 5.5 Red Hat Linux environment.
• Installed MySQL cluster.
• Developed and implemented the latest backup and restore process for Oracle, SQLServer and MySQL server databases for disaster and recovery plan.
• Planned, and managed the implementation of Critical Security Patches which are recommended by Oracle quarterly.
• Designed and implemented a monitoring alert process which performs a check of more than 100 databases for disk space usage to ensure there will be no disruption over the availability and performance of these databases.

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

Sr. Database Architect

• Acts as resident Oracle/SQL Server Expert and Mentor for Consumer Compliance, Financial Crime Control.
• Develop Pl/SQL Fn/Proc and Packages and prepares operating instructions
• Install and Create SQL/Oracle Cluster database
• Ensuring that disaster recovery plans our developed and functional for mission critical systems.
• Defining and maintaining database security strategies and ensuring that confidential information is secured.
• Prepare effective documentation for relevant activities (Architecture, Design, Data model, Implementation..etc)
• Implements advanced database security features
• Perform database monitoring, tuning, and capacity planning
• Develops strategies for data migration, archive recovery, and implementation of a database.
• Increase offshore effectiveness by Identify skill/knowledge gaps and plan and execute the plan to fill the skill gap
• Increase Development Effectiveness by Adapt Test Driven Development / Leverage tools/technologies
• Maintain and implement Technology Roadmap
• Architects and implements complex Oracle 11g RAC, Data Guard and Oracle ASM environments
• Identifies opportunities to improve current processes, and communicates suggestions for improvement
• Provides guidance to developers for logical data modeling for both OLTP and OLAP
• Designs, develops and tunes PL/SQL, T-SQL in our high volume database environment.
• Analyzes and resolves complex technical issues for Tier 3 Production Support of Oracle databases/SQL Server and PL/SQL, T-SQL in support of ETL batch processes

Confidential, Century City, CA

Sr. DBA

• Supported of over 400 development, test and production SQL/Oracle databases.
• Administration of a several 7 plus terabytes databases
• Support Oracle RAC on 9i, 10g and 11g
• Install and Create Oracle RAC database
• Install/Support SQL Server Cluster 2008/2012
• Created numerous scripts for routine database administrative duties
• Providing 24X7 escalations supports for all databases and related applications.
• Participating with other members of the Technical Services management team in long-range and strategic planning for Technical Services.
• Ensuring that disaster recovery plans our developed and functional for mission critical systems.
• Defining and maintaining database security strategies and ensuring that confidential information is secured.
• Install, configure and support MySQL Replication
• Upgrade MySQL from 5.0.56 to 5.5.24

Confidential, Burbank, CA

Consultant

• Supported of over 300 development, test and production Oracle databases.
• Leading team of 12 DBA offshore
• Administration of a several 1 plus terabytes databases
• Implementation 10g RAC instances
• Develop scripts for Development group to support in-house applications
• Created numerous scripts for routine database administrative duties
• Participate in rotational on-call support
• Managing the Database Services Office. Recruit, hire, train, supervise, and evaluate the staff.
• Providing 24X7 supports for all databases and related applications worldwide.
• Participating with other members of the Technical Services management team in long-range and strategic planning for Technical Services.
• Working closely with the business community to determine their needs and long range objectives.
• Developing and enforcing standards related to database design, backup and monitoring.
• Coordinating development and production maintenance projects to balance staff work load.
• Assisting other Technical Services staff members as needed in projects.
• Ensuring that disaster recovery plans our developed and functional for mission critical systems.
• Providing database design services to the development teams in accordance with industry accepted design practices and WMG database standards.
• Performing database capacity planning and participating in the budgeting process.
• Defining and maintaining database security strategies and ensuring that confidential information is secured.
• Install, Configure and support MySQL environment (MySQL 4.45, 5.0, 5.1)
• Setup MySQL replication
• Support 100s MySQL databases
• Install, Configure and support MS SQL (2000,2003,2005 and 2008)
• MS SQL upgrade, and patch apply

Confidential, Burbank, CA

Senior Technical Manager

• Supported of over 300 development, test and production Oracle databases.
• Leading team of 5 DBA on site
• Administration of a several 1 plus terabytes databases
• Implementation 10g RAC instances
• Develop scripts for Development group to support in-house applications
• Created numerous scripts for routine database administrative duties
• Capacity planning to support terabyte databases
• Managing the Database Services Office. Recruit, hire, train, supervise, and evaluate the staff.
• Providing 24X7 supports for all databases and related applications worldwide.
• Participating with other members of the Technical Services management team in long-range and strategic planning for Technical Services.
• Working closely with the business community to determine their needs and long range objectives.
• Developing and enforcing standards related to database design, backup and monitoring.
• Coordinating development and production maintenance projects to balance staff work load.
• Assisting other Technical Services staff members as needed in projects.
• Establishing procedures for maintaining high standards and availability of all database environments.
• Ensuring that disaster recovery plans our developed and functional for mission critical systems.
• Providing database design services to the development teams in accordance with industry accepted design practices and WMG database standards.
• Performing database capacity planning and participating in the budgeting process.
• Defining and maintaining database security strategies and ensuring that confidential information is secured.

Data Architect and Technical Lead

• Participated in the overall architecture for building a set of worldwide-distributed tools that have the capability of deploying the WMG label and cross label sites. Built using Hibernate, JBOSS, LDAP and Oracle Administration of development, test and production databases
• Diagnosed and tuning of developer and application SQL
• Performed data refreshes of test and development environments
• Troubleshoot performance issues
• Conceptual/Logical/Physical database modeling in ORM/ER/UML
• Created numerous scripts for routine database administrative duties
• Transactional (OLTP), Data Warehouse, and Data Mart (OLAP) schema design and construction
• Extraction/Transformation/Loading (ETL) design and implementation
• The design of the middle ware layer between the front-end application and the legacy systems (ORACLE 8i,,9i XML)

Data Architect and Technical Lead (Consultant)

• Design and implement data flow and data movements
• Designed Oracle database architecture to be used for dot com OLTP environment
• Worked with Data Architect to create logical data model
• Implemented physical data model created by developers
• Created triggers and stored procedures
• Develop database backup scripts for database in Network Appliance environment

Confidential, NY, NY

Sr. Database Administrator

• Designed Oracle database architecture to be used for dot com OLTP environment
• Worked with Data Architect to create logical data model
• Implemented physical data model created by developers
• Created triggers and stored procedures
• Develop database backup scripts for database in Network Appliance environment
• The package selection of the EAI (Enterprise Application Integration) software, benchmarking Constellar from CTalk Inc.

Confidential

Sr. Database Administrator (Consultant)

• Developed the architecture, design and management for Internet applications.
• Developed new web hosting architecture that allowed for extreme scalability.
• Mapped data models to Internet applications,
• Designed and built physical databases.
• Trouble shoots, and tune application performance during applications deployment.
• Install Oracle8i and applied required patches.
• Setup RMAN backup
• Setup shell script to monitor database and send alert

Confidential

Software Engineer

• Data modeling and schema development for custom financial system.
• Worked with user to determine database needs
• Developing application using relational database.
• Oracle Database Administration to include backup/recovery design and implementation.
• Install Oracle 7.3
• Create shell script to maintain and monitoring Database activity and backup schedule