Database Architect
Resume:
George Sheen
US Citizen
IBM CERTIFIED IT SPECIALIST
IBM CERTIFIED IT INFORMATION (DATA) ARCHITECT
Richardson, Tx 75080
Phone: 972-***-****
Email: ***********@*****.***
Objective
Provide technical guidance and direction in defining the data architecture strategy for individual projects and the business as a whole. Work with senior management, technical and client teams in order to determine data requirements and best practices for advance data manipulation, storage and analysis strategies in a data warehouse environment.
Profile
Experienced IBM Certified Senior IT Specialist, IBM Certified IT Information (Data) Architect and IBM Certified DB2 Solution Expert with concentration on AIX, CICS, DB2 UDB, Linux, Oracle, PopleSoft, z/OS and WebSphere Application Server on z/OS and UNIX platforms.
Extensive IT experiences with roles ranging from System Programmer to IT
Architect. Industry experiences in automotive, banking, distribution, energy & utilities, financial services, healthcare, insurance, life sciences, manufacturing, and telecommunication.
Has strong expertise in capacity planning, disaster recovery, financial analysis,
performance analysis and tuning, project management, requirement analysis, security
design, system development and system integration.
Qualifications
Database Architect with over 17 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
Extensive hands on experience using Oracle 12c, 11g, 10g, 9i, DB2 and SQL Server databases and several of its tools.
Management and implementation of database models, data flow diagrams, database schemas, db scripts, DTD schemas, structures and data standards to support a robust data management infrastructure.
Solid experience translating business requirements into conceptual, logical, and physical data models.
Implement best practices and methodologies in data analysis, design and modeling.
Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation, including ETL across different platforms, DB2 to Oracle VLDB databases and flat files.
Management and development of an enterprise tailored taxonomy. Categorized internal and external data collections and ensure users find the information they need with speed and precision.
Experience on Meta data definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation program library maintenance, XML file generation and data quality.
Design standards for using normalized data structures, de-normalized structures, and dimensional structures. Defines common design patterns for modeling various types of relationships.
Provide guidance and work leadership to less-experienced staff members.
Professional Experience
Citi Technology Inc. Feb 2015 – May 2018
Oracle DBA Irving, TX
Key Responsibilities
Backup and Restore strategies during disaster scenario.
Migrating and moving data between environments.
Provide support and resolve issues.
Troubleshoot Oracle Data Guard environment.
Troubleshoot Database Performance problem.
Participated in the installation and configuration of Golden Gate, Troubleshoot Golden Gate replication issues, applied database patch and Golden Gate patch, and monitored database replication using OEM Grid Control.
Experience and Skills
Experience as an Oracle Database Administrator .
Knowledge in installation and configuration of Oracle Enterprise Server software.
Expertise in data migration and movement technologies such as RMAN, Datapump, Exp/Imp, Transportable Tablespaces etc.
Working knowledge of Data guard replication.
Knowledge on ASM DG.
knowledge of UNIX / LINUX operating systems with shell scripting.
Expertise in backup / restore strategies.
Basic troubleshooting on performance problem.
Knowledge on Migration and upgrades from different Oracle versions.
Researched and resolved DBMS system problems and assisted in the resolution of application problems
Established DBMS system security standards and support Security Administration in maintaining access controls.
Apply PSU patches to 11.2.0.4 version of oracle databases including rolling patch for RAC Systems.
Monitor performance and tune all DBMS subsystems.
Support application performance review and tuning efforts.
Provided UAT, DEV Database request support for application developers.
Implemented High availability using Data Guard and Golden Gate
Installed Oracle 12c on many development servers and UAT servers.
Installed ORAAS on many development servers and UAT servers.
Database Security Architect/DBA Contractor
AT&T
May 2013 – Feb 2015
Performed business analysis, logical and physical database design using CASE tools for AT&T Corporate wide legal and managerial consolidated financial statements. Provided data architecture designed to eliminate discrepancies in managerial and legal results.
Architecting & implementing enterprise & business segment OLTP solutions.
Expert level production & development database administration – all platforms.
Logical and physical database design, modeling & implementation of enterprise. Customer and household profitability data warehouse.
SQL Server and Informix to Oracle migration for a suite of enterprise applications.
Expert level stored procedures development in Oracle, SQL Server & DB2 environments.
Expert level UNIX shell script development for automating ETL processes, data loads, instance data migration & database or file system backup and restores.
Responsible for the installation/migration of Oracle databases in the industry application systems. Participated in the installation and configuration of Golden Gate, Troubleshoot Golden Gate replication issues, applied database patch and Golden Gate patch, and monitored database replication using OEM Grid.
HR SUITS application development converting C++ code to PL/SQL
Application DBA Contractor
Client: Citi Group
Mar. 2011 – May 2013
Architected and implemented development environment in support of 20 databases at infancy to 500+ at peak.
Installed and configured database systems for company’s Production, QA, and development servers.
Citi bank branch/ ATM infrastructure architecture, design and deployments.
Managed computer system capacity planning and allocation worldwide, provided synchronized global source code access, selected and deployed a uniform set of Java, C++ development tools, identified and created system-level script as needed to automate redundant tasks, and defined and maintained a standard technology stack definition for both Production and customer deployment.
Enabled non-stop product development by software engineers.
Ported products to run on Linux, Solaris, HP-UX, AIX, and Windows x64.
Successfully commercialized large in-memory planning by widening products from 32-bit to 64-bit.
Established alliance relationships with all major system vendors in support of company’s C++ and Java product development and implementation.
Metadata Integration Strategy for the Enterprise Data Standards Initiative including software evaluation and information integration and management method development. Organization all existing data models, data flows and data dictionaries into a Meta Data Repository. Created physical models of all databases and logical models of strategic customer and product databases. Designed a Corporate Conceptual Model as an architecture migration target and developed procedures to map this model to the database models to facilitate information location.
Assisted application development in the installation/migration of Oracle database servers including 11.2.0.3 RAC/Data Guard using OEM/Grid infrastructure.
To provide 24 x 7 application support for PROD/UAT/STAGE databases
Provide FULL support for IST/ DEV/TEST databases
To process STRs/SIRs related to application changes and problems.
To restore PROD dumps to UAT/DEV/ IST environments based on user needs and masking/data scrambling if required
To provide support for app related changes such as Object creation, schema creation, altering schemas etc
To maintain object level permissions and grants
To setup maintenance jobs for daily/weekly/monthly processes for purging, performance stats etc
To run update statistics on a periodic basis
To monitor DEV / IST / UAT server resources and performance
To provide support for SQL tuning and suggestions for performance improvement
To work closely with development teams to assist in overall database design, such as creating normalized databases, helping developers tune queries, assign proper indexes, and aiding them in creating triggers and stored procedures.
Responsible for logical backup (schema level export) and restore (schema/table level import)
To develop, implement & maintain application data archive & purge processes as necessary for DEV / IST / TEST / UAT / PRD / COB database environments
Data Base Administrator
Client: JP Morgan Chase & Co.
Feb. 2010 – Mar. 2011
Worked closely with the system architect, data management director, product manager, and end users to develop the requirements and system architecture for a new customer centric repository (CCR), designed to be both the system of record for clients and the source for statistical analysis.
Designed and implemented the logical and physical data models for the CCR.
Chase bank branch/ ATM infrastructure architecture, design and deployments.
Data Architecture for Internet Data Aggregation. Provided data models and data maps (extract, transform and load analysis) of the datamarts and feeder systems in the aggregation effort.
Designed and implemented a Metadata Repository providing a centralized information source for the data models, data maps, processes, documents, contact lists, project calendars and issues affecting the Chase/Morgan merger.
Designed the Information Model for transformation of the Traditional Credit Product infrastructure.
Responsible for Oracle database performance, tuning analysis, and capacity planning.
Database Administrator
Client: Kaiser Permanente
Aug. 2008 – Feb. 2010: IBM Global IT Delivery
Clean and maintain the database by removing and deleting old data.
Working knowledge designing, developing and manipulating Oracle databases, data warehouses and multidimensional databases.
Responsible for Oracle database performance, tuning analysis, and capacity planning.
Relies on experience and judgment to plan and accomplish goals.
Performs a variety of tasks.
Works under little or no supervision; reports to the manager and allowed a certain degree of creativity and latitude.
Data Architect, IBM Global Services
Client: Department of Labor Industry, PA
Apr. 2007 – Aug. 2008
Physical data architecture and technical data architecture design under SOA
Defined data stores
Defined the key software/hardware components required to implement the physical concept
Developed Data Migration Plan
Advised on Database Performance/Tuning/Measurement
Produced Oracle Real Application Cluster and Automatic Storage Management architectural decisions and Architecture Overview Diagram work products
Logical and physical database design for an OLTP internet business to business communications and information system designed to help major financial institutions find, negotiate and agree to custom-tailored complex investment instrument transactions such as futures, options, swaps and other derivatives.
Data Architect, IBM Global Services
Client: California State Automotive Association (CSAA)
Oct. 2003 – Apr. 2007
Logical Data Architecture design
Physical Data Architecture design
Defined the conceptual and logical model of the data resources
Developed the physical data model of the database
Developed Storage Management Plan
Advised on Database Performance/Tuning/Measurement
Assisted with performance/scalability testing, and provided general assistance within the development and production testing environments.
Data Architect, IBM Global Services
Client: Aventis Pharmaceutical
Jul. 2001 – Oct. 2003
Physical Data Architecture design
Developed Storage Management Plan
Designed Physical Data Model
Advised on Database Performance/Tuning/Measurement
Implemented Middleware to support client-developed Web Portal application in drug discovery process of TLC (Target, Lead and Candidate).
Jul. 1988 – Jul. 2001 – IT Specialist, IBM Corp.
Market Support Representative for IBM Product Support Organization, Dallas
Product supported: CICS, DB2, IMS, MVS/ESA
Advisory System Integrator for IBM Southeast Region MVS Support, Irving
Product supported: MVS/ESA Availability
Senior IT Specialist for IBM Global Services, Dallas
Product supported: OS/390, z/OS, CICS, DB2, WAS
Key Courses and Training
Introduction to the Value and Governance Model of Service-Oriented Architecture
Design SOA Solutions and Apply Project, Technical, and Operational Governance
Technologies and Standards for SOA Project Implementation
Developing Applications with a Service-Oriented Architecture
Advanced Database Recovery and Repair in Oracle 10g
DB2 UDB for z/OS V8 Database Administration Workshop - Part 1 (DVL)
IBM Tivoli System Automation for Linux 1.1: Automating Complex Systems
IBM Tivoli Storage Manager 5.3 Overview
A Reference Architecture for Strategic Outsourcing and Service Delivery
Project Management Orientation (PMTO)
Client Consulting for IT Architects
Architectural Thinking for Experienced Professionals
Oracle9i Database Administration: Manage an Instance
IBM Global Services Method for Technology Integration Professionals
The IT Architect: An Introduction
Java Programming Advanced
Education
Ph.D. in Business Administration
Madison University, United States of America, 2002
Dissertation Title: A MODEL FOR THE DEVELOPMENT AND IMPLEMENTATION OF CORE COMPETENCIES IN INFORMATION TECHNOLOGY SERVICES COMPANIES FOR SUPERIOR FINANCIAL PERFORMANCE, 2002
Master of Science in Accounting
The University of Texas at Dallas, United States of America, 1997
Master of Business Administration in MBA
The University of Texas at Dallas, United States of America, 1995
Master of Science in Physics
Texas Christian University, United States of America, 1974
M.S. in Physics
National Taiwan University 1973
Languages
English Fluent, Chinese (Traditional) Fluent, Japanese Good, German Basic
Contact this candidate