We provide IT Staff Augmentation Services!

Database Administrator / Data Architect Resume

5.00/5 (Submit Your Rating)

OhiO

TECHNICAL SKILLS:

DATABASES: DB2 9.5, OS/390 Z/OS, IMS, ORACLE v7, SQL*PLUS, SQLserver 2005

OPERATING SYSTEMS / STORAGE SYSTEMS: Windows 2003 Enterprise Server, Z/OS - OS/390, OS/2, AIX, LINUX, NetAPP

SOFTWARE: JCL, BMC, CICS, Embarcadero/ERSTUDIO; IEF/ COMPOSER / COOL GEN; ERWIN / MODELMART / ALL FUSION

PROFESSIONAL EXPERIENCE:

Confidential, Ohio

Database administrator / Data architect

Responsibilities:

  • Re - architected DB2 UDB AIX Informatica ETL / Business Object reporting BI / OLAP system, migration to open source LINUX, adding double 365x24x7 availability protection with fail-over architecture and taking advantage of virtual machine technology
  • Overhauled security architecture: Introduced DB2/ZOS role-based security /Trusted Context security; conducted testing, published results, convinced lead ZOS DB2 systems programmer buy in / test / implement the expensive / complex infrastructure changes and security overhaul
  • Performance tuning on Informatica jobs and Business Object reporting - revised job stream flow, helped fixed up Informatica target definition, dropping/recreating indexes ( and physical database index redesign), transformation, adding job stream checkpoint restart capability
  • Analyzed data / growth / change requirement across DB2/mainframe - DB2/LINUX; QA checks (caught / raised data quality issues / data governance issues ); advised on data model / meta-data model / enterprise repository design
  • Transferred MDM /model management knowledge / meta-data management design, proposed new standards and best practices in database object naming convention to address existing inconsistence across different systems, proposed series of scripts/jobs to improve data quality / prevent potential production problem

Confidential, Ohio

Database Analyst/Database Administrator/Architect

Responsibilities:

  • Reverse engineered production system back into data models.
  • Maintained data model changes.
  • Trained developers on data modeling practices.
  • Developed various re-usable common “sub-models” and common entities to train developers / analysts on various data modeling techniques: normalization vs. de-normalization, role-based security modeling, component-based modeling, business rules - data driven modeling, OLTP / OLAP dimensional modeling and OLTP/OLAP integration, data model sub-setting, business area analysis, data life cycle analysis, state-transition diagramming, data decision tree, unique identifier generation strategy, XML and hierarchical data structures and XML physical database implementation, physical data modeling - performance best practices
  • Created / maintained data model change control / version control procedures, emergency change procedures, and monitored new software releases impacts.
  • Developed / promoted and ongoing maintenance of standards/ best practice templates on naming / usage of tables / views / attributes / TRIGGERS / STORED PROCEDURES, OLTP normalization / de-normalization cost/benefit, db-referential integrity vs. programmatic RI enforcement
  • Established standard practice of information gathering on data volumetric / archive -retention requirement of data
  • Supported OLTP/OLAP ETL from core DB2 to SQLServer / DTS /SSIS service, consulted on OLAP designs / slow changing dimension - conform dimension design / multi-clustering design / partitioning design
  • Introduced / championed for data-warehousing / data-mining and event driven BI to IT executive management, resulting in the creation of new data analytic team and attracted senior corporate executive office sponsorship.
  • Reviewed / approved new project data models and existing model changes; ran data models quality checks, identified potential data quality problems, referential integrity problems, performance problems, provided advices and alternative design, requested rework
  • Investigating legacy systems data QA issues, created jobs to investigate data pattern, growth pattern, data inaccuracy pattern
  • Devised roadmap for step-by-step system overhaul toward an organized master data management infrastructure, including long term data governance strategic goals and short term tactical direction
  • Trained two DBAs on database / instance parameters setting / performance tuning / log file performance bottleneck get-arounds, refresh job scripts explanation, high availability fail over procedures etc.
  • Additional technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential

Data Modeler/DBA/Data Architect consultant

Responsibilities:

  • Uncovered the lack of disaster recovery practice; designed templates for both IT / hardware / software failure scenarios and recovery procedures, and high level business continuity templates, sent to IT executives and championed for enterprise DR procedures
  • Researched and scum work to gather cost / benefit / payoff for data mart /warehousing, to promote business intelligent benefit to senior IT management
  • Introduced / set up standards / assisted developers in building triggers and stored procedure; naming standard; usage standard

Confidential, Ohio

Data Modeler/DBA/Database Architect

Responsibilities:

  • Helped set up ERWIN MODELMART new DDL gen guidelines/ naming conventions, backup strategies across OLTP/OLAP
  • Ran ERWIN model checks, model compares, automatic DB2 host database synchronization; identified / fixed ERWIN objects, investigated model corruptions, uncovered and worked with CA tech support to fix ERWIN bugs
  • Worked with business analysts to develop pieces of data models and addressed integration issues into next release of XML banking software for the banking clientele
  • Developed OLAP / OLTP interfaces, dimensional model with data source/target mapping, ETL jobs and performance tuning
  • Explained various modeling practices and techniques ( role - based security, data-driven modeling, CRUD matrix ) to enterprise IT architects, fellow DBAs and designed customized adaptation
  • Ad hoc Huntington Bank support - COOL:GEN data model enhancement and reporting; collected volume info and statistics.
  • Published data model reports on Intranet, kept track of change and versioning and model backups.
  • Built, reviewed, made recommendation to data models /database design and implemented logical and physical data model.
  • Replication of database objects and data; promotion of database changes and data changes across different environments and across OLTP/OLAP ETL changes / source-target mapping
  • Configured subsystem and DB2/ZOS- ZPARMs tuning; generated ZPARM module; improved dynamic SQLs, increased JDBC connections limits, reset max. concurrent users limits, configured connection timeouts; performance and system monitoring on I/Os, bufferpool /EDM / hiperpool pool setups.
  • Additional tec hnical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential, TX

DBA/Database Analyst

Responsibilities:

  • Managed ERWIN user accounts / profiles /access; worked with vendor technical support, managed/leveraged software.
  • Mentored database staffs /application staffs in ERWIN / MODELMART usage.
  • Led ERWIN NT/MODELMART 3.5.2 upgrade ORACLE 7/UNIX with team of ORACLE DBAs, INTEL Server Admins.
  • Led effort on improving ERWIN ModelMart Library management efficiency; planned cleanup cycle, improved space utilization.
  • Handled / implemented database change control with Embarcadero DBArtisan/ DB2 / ORACLE and ERStudio DDL gens
  • Developing interfaces and sub - setting strategy to the IBM IIA Insurance Data Model for practical implementation
  • Repaired model corruption ER1 file on Windows NT and assisted ORACLE DBA in database recoveries.
  • Advised on model/ database design / normalized / de-normalized / index usage / SQL tuning / RI issues / BIND parameters.
  • Additional technical experience on database administration / disaster recovery / primary production on-call tasks will be provided if interested

Confidential

Database Administrator

Responsibilities:

  • Data Modeler, Advanced Systems Engineer, IEF Encyclopedia Administrator / Technical Leads Canada,USA,UK - Jun/94-Feb/98
  • Promoted / applied process engineering, SEI CMM, SDLC, TQM systems / data quality methodologies and best practices
  • Laid down EDS North America central data model management road-map, provisions for individual EDS client customization / optimization within a master framework / strategy for adaptability flexibility into the global EDS enterprise
  • Defined/ maintained model subsets, encyclopedia access, models migration, models merges, models adoptions, models splits.
  • Developed DB2 / OS390-mainframe data models, process models / applications / web-apps with COMPOSER/COOLGEN COBOL/CICS/IMS/DB2/ ORACE with C++ / JAVA / HTML / JSP
  • Performed check-in/check-outs and version control of data models and common action blocks of process models.
  • Re-architected SIGNET bank model repository, re-architected banking COBOL/CICS-transactions and program structures to more model-based structures ( received $2,000 bonus and baseball tickets / paid day off at baseball game)
  • Trained team in OLTP / OLAP dimensional data model, conform dimensions, model management, sub-setting, version control
  • Installed / upgraded / resolved OS, DB2, DB2/2, data model corruption / encyclopedia issues

We'd love your feedback!