We provide IT Staff Augmentation Services!

Dba Consultant Resume

5.00/5 (Submit Your Rating)

EXPERIENCE:

  • Confidential DBA / Confidential Application Performance Tuning / Confidential ETL/ELT Architect
  • Over twenty years of DBA Support, Application Performance Tuning and ETL/ELT Architecture design.
  • Skilled in all aspects of running an efficient Confidential environment.
  • Excellent technical and interpersonal communication skills are consistently used in collaborating team environments.
  • Communication skills also have been demonstrated in project lead roles and many more years as a performance driven team lead.
  • Team lead roles included production support, system development, and acceptance testing.
  • Ethical business practices have been a leading factor in innovative and thorough problem solving skills. Agile, Six Sigma, and Lean practices are forefront in keeping each project lifecycle moving with accuracy and optimal capacity.

KEY SKILLS:

  • DBA Support as System DBA, Application DBA, Application Performance Tuning, ETL/ELT Architecture design, Release Management and Upgrades, Confidential At Your Service (TAYS) administration, TAYS Incident creation through follow up, TSET ( Confidential System Emulation Tool) utility, Backup and Restore, Data Mover, Skilled in Confidential Best Practices, Logical and Physical Modeling, Data Security, and Capacity Planning. administration tools up to V2R15.10 including Viewpoint Portlets and administrative functions of Viewpoint, Packdisk, Scandisk, Checktable, Ferret, DBS Control, Query Monitor, Query Spotlight, TASM, Workload Designer, Workload Monitor & Health, Remote Console, DBS Control, Compression techniques, ARCMAIN, DSMAIN, TARA, DSMAIN, DSA/DSM, Cluster archives, Disaster Recovery, NetBackup, Unity, TD system macros, PDCR, TD Analyst Pack (TD Index Wizard, Statistics Wizard, and Visual Explain). load and extract utilities including MLOAD, FASTLOAD, FASTEXPORT, TPUMP, TD Parallel Transporter (TPT), and BTEQ.
  • Confidential migrations from DB2, Oracle, Sybase, and SQL Server.
  • V2R3 through V2R15, Confidential tools & utilities, DB Window, Resusage, DBQL, Alerts, Confidential Manager, Priority Scheduler, PMON, BEZ, Erwin, Operating Systems: SUSE Linux SLES 10 & 11, MP RAS, and channel attached (mainframe).
  • Changeman, ClearCase, FTP, NDM, UUCP, EDI, Librarian, Panvalet, Endevor, ZEKE, Expediter, Workbench, Access, Remedy, Lotus Notes, Visio, Function Points, Windows, and most all MicroSoft products. Mainframe, MP - RAS and Linux. Data Marts and EDW designs, ETL/ELT Processes, SQL, JCL, COBOL, VSAM, LINUX Administration, UNIX/LINUX SHELL programming, Access, DB2, IMS DB/DC, IMS Fast Path, CICS, JCL, TSO/ISPF, ROSCOE, OS/MVS, JES 2 & 3, VSAM, OS/IMS/DB2 Fileaid, QMF, DB2, IBM Utilities, Platinum Utilities, APS, UNIX MP RAS, Linux, Hummingbird Exceed, CRON, Autosys, Syncsort/Maxsort, INSYNC, Strobe performance Tuning, PANAPT, and CA7.

WORK HISTORY:

Confidential

DBA Consultant

Responsibilities:

  • DBA support and customer education for a new implementation of two 2700 appliances.
  • General DBA Support and Education, 2650 Appliance
  • General DBA Support and Education, 6700 Enterprise class,
  • Architectural performance analysis and tuning.
  • DBA support and customer education for a new implementation of two, 2700 appliances.
  • Performance tuning analysis on a new application implementation. Index Wizard was used to identify join index and partition index opportunities.
  • TD lead DBA support for a new implementation of two 2650 app lead support for an initial data mart and EDW analysis.
  • DBA support for DCM Forklift. support for Rx / USCM data forklift (lift and shift)
  • ELT development.

Confidential

System and Operational DBA Consultant

Responsibilities:

  • Provided support of the operational Prod, QA and Dev environments. ITSM was used to reconcile all issues presented across the Confidential landscape. In a V2R15.10 environment, used Data Mover tresolve data movement between environments and TARA to remediate archive and restore issues. Used Administrator and SQL
  • Assistant to resolve data issues raised by users and the ETL team. Provided release management scheduling and coordination to upgrade and harden the Confidential landscape. Customized Viewpoint alerts to more closely respond to the overall workloads and remediated all daily alerts. Led the Confidential team in quarterly disaster recovery exercise site wide testing, monthly archive/restore testing and
  • PDCR reporting. Participated in regular internal and external security audits.
  • Provided expert consultation and best practice advisement. Trained additional
  • DBA team members in all the above mentioned activities and procedures.

Confidential, Bloomington, MN

DBA Technical Consultant

Responsibilities:

  • Provided System and application DBA Support for newly developed retail model implementation for Express Cloths.
  • Transformed Logical model to a physical model.
  • Used TD Administrator and Assistant to create objects associated with the physical model.
  • Merged the new system into existing TASM workloads.
  • Provided expert consultation and best practice advisement.
  • Used Performance Monitor Locking Logger, and Resusage Data to assess performance needs and TASM adjustments.
  • Implemented database archive scripts using TARA.

Confidential

Sr. Technical Consultant

Responsibilities:

  • Demonstrated technical expertise to Confidential U.S. customer base in all aspects of
  • V2R13 through V2R15 database administration.
  • Provided educational opportunities to customers expressing an interest in a more in depth or broader knowledge base.
  • Performed customer database administration issue resolution as assigned.

Confidential

Application/Physical DBA

Responsibilities:

  • Provided System Administration support for Confidential V2R6.1, V2R6.2 and V2R12 environments to five corporations
  • Wrote Confidential system support processes using UNIX BTEQ Scripts, performed space analysis and optimization, performance analysis using TASM methodology.
  • Supported production processes, user queries, and V2R12 software upgrade from V2R6.2.
  • Produced documentation and procedures for best practices in Confidential administration.
  • Mentored employees interested in building a knowledge base of Confidential best practices and efficiencies.

Confidential, Charlotte, NC

Application/Physical DBA

Responsibilities:

  • Provided System Administration support for a new Confidential V2R6.1 environment
  • Developed pro-active processes for monitoring capacity and performance.
  • Performed implementation analysis for Capacity on Demand (COD), CPU limits Priority Scheduler and ResUsage monitoring.
  • This analysis included managing post upgrade expectations using Priority Scheduler and Query Manager. Wrote UNIX
  • BTEQ scripts to manage and collect statistics daily.
  • Also wrote ad hoc processes to collect and analyze data demographics for value compression.
  • Produced documentation and procedures for best practices in Confidential development and administration.
  • Supported production processes, user queries, and a TTU upgrade to V2R8.1.
  • Mentored employees interested in building a knowledge base of Confidential best practices and efficiencies.

Confidential, Bentonville, AR

Specialist

Responsibilities:

  • Developed a reporting system for a Competitive Pricing Alerts system.
  • This was comprised of a number of comprehensive competitor price monitoring reports
  • MVS/OS, BTEQ accessing multiple PPI tables as well as multiple UPI and NUPI tables was the development environment. Data storage capability was measured above a petabyte.

Confidential, Jacksonville, FL.

Application DBA

Responsibilities:

  • Provided Database Administration support for very large databases in a Confidential
  • V2R5 channel attached environment.
  • Responsibilities included creation maintenance, and support of Confidential architectural environment, design of Physical database, administration of production objects in change control environment development of pro-active processes for monitoring capacity and performance.
  • Performed system level and application level tuning. Supported the application development teams for database needs and guidance.
  • Developed backup and recovery operation.
  • Supported production processes, user queries, and database security administration.
  • Mentored employees interested in building a knowledge base of Confidential best practices and efficiencies.

Confidential, Atlanta, GA

Specialist

Responsibilities:

  • Performed a forklift conversion for Bellsouth Telephone of many Oracle & Sybase data marts into a Confidential data warehouse.
  • Responsibilities included code conversion of Oracle and Sybase view definitions into Confidential Views.
  • Loaded Oracle data into Confidential tables using Confidential OLE Load and fastload utilities.
  • Mentored employees interested in building a knowledge base of Confidential best practices and efficiencies.

Confidential, Scott AFB, IL.

ETL Architect/Specialist

Responsibilities:

  • Performed Confidential architectural ECTL design for the US Central Command Global Transportation Network 21st century
  • This was an active warehouse design with 24/7 availability. Business requirements gathering, IT impact analysis, specification and recommendation for iterative database design and view architecture.
  • Performance tuning analysis and design recommendation.
  • Use of ERWIN modeling tool.
  • Developed technical specifications for ECTL development.
  • Generation of technical specification for other user application development, design documentation and communication to business user.
  • Coordinated Confidential database capacity requirements with Technical Planning. Coordinated with DBA to transition logical design to physical database structures.
  • Provided Confidential expertise in thedevelopment of physical data base solutions by prototyping an initial conversion design and production ECTL system.
  • Acted as liaison between application development and corporate data administration to ensure the desired level of data sharing was achieved across the organization.
  • Analyzed and documented various data sources for subsequent input to the EDW. ECTL Confidential Design and development. Analyzed and documented legacy systems for transition and acquisition of source data. Worked with the EDW team to define programming, tables, and naming conventions. Interacted with the EDW and source data teams for the transition.
  • Confidential V2R5.1, Confidential Warehouse Builder, TPump, Fastload, Multiload, BTEQ, Stored Procedures, Macros, Triggers, JDBC, SQL, SeeBeyond, JAVA, ClearCase, UNIX and Windows provided the development environment.
  • Provided expertise in the development of Confidential physical data base solutions.

Confidential, Columbus, OH.

QA Analyst

Responsibilities:

  • Developed SQL for data verification (source to target), QA and performance testing of a large ECTL (IMS & DB2 to Confidential ) project.
  • The environment (twelve terabytes) was heavily integrated with MicroStrategy as the main reporting tool.
  • Queryman, WINDDI, VSAM. COBOL2, IMS, DB2, SQL, NDM, JCL, Expediter Changeman and Lotus Notes was the software development environment.
  • Source to Target, Unit, system, and integration testing was accomplished using SQL Queryman, WINDDI, & IBM utilities.

Confidential, Dallas, TX

Specialist / DBA

Responsibilities:

  • Developed COBOL/DB2 programs in conjunction with Confidential utilities and BTEQ scripts to provide ETL and daily maintenance in a Confidential Star Scheme CRM environment (ten terabytes).
  • MicroStrategy was introduced to enhance user reporting of Facts and Dimensions within the data warehouse.
  • Performed Web Log Click Stream analysis to determine web site navigation and product shopping patterns.
  • Developed and performed Ad Hoc procedure to reload multiple days of log data.
  • Developed multiple Confidential database Cluster Archive and Restore procedures to the Click Stream system. 3.
  • Developed BTEQ scripts incorporating OLAP to load fresh Test Click Stream tables sourcing the production database tables.
  • Developed new Confidential tables using
  • Fastload and BTEQ to enhance email options available to web site users. 5.
  • Developed a Confidential system to prevent email discount notifications sent to targeted shoppers from being used by a non-intended shopper.
  • Source to Target, Unit, system, and integration testing was accomplished using Queryman, WINDDI, & IBM utilities.

We'd love your feedback!