Summary
Overview
Work History
Education
Skills
Hobbies and Interests
Education And Professional Development
Key Proficiencies
Timeline
Generic

Brenda Pitt

Wellesley,Canada

Summary

Results-oriented IT Professional with extensive experience in system development life cycle (SDLC), from initial feasibility analysis, physical design through implementation, quality review, enhancements and administration. Key proficiencies include: Analytical skills to develop and administer data modeling and database management solutions. Hands on problem management, easily trouble shoots highly complex issues. Organizational skills, plans and oversees projects from conception to completion. Demonstrated leadership skills, leads by example. Positive team player who can also guide, coach and mentor. Excellent communication skills, requirements gathering and solution design. Strong customer focus, listening, understanding and following through with customer needs and following through with recommendation to Management. Strong SQL background in writing queries to analyze data for the Business needs. Ability to remain calm under pressure. Good collaborator with the Business, Third parties and internal/external teams. Work with IT team to develop SLAs for Problem Management and escalation and follows through with using SLAs.

Overview

11
11
years of professional experience

Work History

DB2 for Z/os Database Administrator

Canada Revenue Agency
Current - Current
  • Create DDLs for new tables and deploy into test environments
  • COBOL programming and Testing in development to incorporate new Table functionality
  • Backup and Restore of production data to a Test environment for Year end activity for audit purposes
  • Copy of database to several environments and incorporate Test Data as defined by the Business for Testing in each environment
  • Sanitize accounts for test environments before copying
  • Program paths for each transaction functionality for database tables
  • Create/Update/Use JCLs for copy functionality and for backups , Refreshes, Restore, Runstats, Reorg and Checkdata
  • Manage the mailbox for requests coming from the Business with an hour turnaround time frame
  • Migrate entire filesystem to create a new environment using File-Aid and renaming of objects
  • Follow up on tasks asking questions for clarity before doing a task or responding to an e-mail
  • Migration of DB2 modules with the use of Endevor for migration from one environment to another up to Pre-Prod
  • Creation of schedules for each Database in Control-M for Loading of large tables so they don't have to be done manually
  • Noting the dependency of key tables are loaded successfully before child tables are loaded
  • Responsible for two databases that includes one high profile database required for tax filing season

IT Programmer/DBA/BI Reporting Analyst

Heartland Farm Mutual Insurance Company
01.2016 - 01.2021
  • Created and maintain the SQL Server Database for Brokers, Credit Score and Conversion
  • Export and Import functionality used on a regular basis as well as creating scripts for specific queries against several SQL Sever databases
  • Manage all third parties SQL Server databases using SQL Server Studio both remote and local
  • Added new SQL Server tables in the Staging Database for Data migration from Third Party to new Policy System database
  • Use Backup and Restore functionality to create SQL Server backups for new and restore functionality to restore databases as per requests
  • Identify performance issues and escalate to Senior Management
  • Explain/show trends for potential impact of performance degradation
  • Assist on the Helpdesk managing all different levels of incidents from critical to low
  • Create Reports using Business Intelligence Tools to reduce time spent on creating these reports on a monthly basis
  • Significantly reduced time from days to minutes
  • Create queries for extracts of all formats of data(jpegs, pdfs, audio files) and modifications of queries to include or exclude columns from reports in SQL Server using T-SQL
  • Responsible for the maintenance of Service Now Incident Management system for modifications to forms and rules
  • Run several reports at Month end for Management to review the results of our performance for each month
  • Deploy changes into production as per Business requirements and projects

Senior zOS DB2 Database Administrator

Manulife Financial
01.2014 - 01.2016
  • Responsible for taking tasks requested from the business of all priorities with specific emphasis on the critical ones
  • Followed up with the Business for clarification of requests and due dates
  • Provided regular feedback to customers as to status of their request and asking for confirmation that requests were completed as expected via e-mails and same-time messaging
  • Performed analysis of requests from all intake mechanism, these include phone calls, same-time questions or production fall out from the night before
  • Worked with three DB2 DBAs and met on a regular basis to review on-call incidents and discussed options for permanent solutions to problems as opposed to short term fixes
  • Participated in the Disaster Recovery of the DB2 databases, created Testplans, took baselines before Disaster Recovery
  • Executed Testplans during Disaster Recovery and compared against baseline
  • Any issues encountered immediately escalated to Project Manager and followed through to find solution to the problem
  • Active participant in the on-call process
  • On-call for any implementations I scheduled and also once a month according to the on-call schedule
  • Collaborated with the Business regularly for any projects assigned to
  • This ensured requirements were being designed as expected from the Database level and customer expectations
  • Supported and worked collaboratively with Developers and Testers to ensure SQLs were meeting performance expectations in the User Acceptance Phase of Testing
  • Documented processes, stored in one central location and notified DB2 DBAs of them
  • This led to more effective and efficient task completion
  • Active team participant in sharing knowledge and what tasks I'm working on
  • This was very beneficial especially when DBAs are away for any reason
  • Participated in the weekly DBA meeting for all platforms
  • These include DB2, Oracle, SQL Server and Progress
  • Responsible for monitoring DBA mailbox once a month for a week all requests coming in for all the DBAs
  • This required a good understanding of requests and a good background for the database platforms
  • Delegated tasks to a specific DBA group according to requests and created calendar entries for the DBAs to carry out assigned tasks
  • Created Data Models or modified existing Data Models for new Business Functionality
  • Mentored new DBA with DBA processes and provided documentation on processes for a task request from the onset from taking task from Task Log Tool, following up with Business all the way to completion of task and documenting the change made
  • This provided a good foundation and knowledge for future requests that this DBA would be assigned

Education

Project Management Applied Tools and Techniques -

University of Waterloo

Diploma - Computer Programmer Analyst

Conestoga College
Kitchener, ON

UDB DBA Database Administrator course -

IBM
Toronto, ON

Skills

  • Technical Leadership
  • Mentoring
  • Database Artifacts Implementations
  • Customer Service
  • Technical Support
  • Broker Support
  • Tivoli Storage Management
  • Windows XP
  • Windows 10
  • LAN
  • Active Directory Design
  • DB2 for Z/os
  • CICS
  • Cobol
  • File-Aid
  • Platinum
  • Endevor
  • SDF2
  • RACF
  • LUW
  • TSO
  • XML
  • Middleware
  • Lotus Notes
  • Oracle 10g
  • Oracle 11g
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft Exchange
  • Microsoft Word
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Visio
  • Power Designer
  • Oracle Enterprise Manager
  • Oracle Apps
  • TOAD for DB2
  • IBM Data Studio
  • BTS Intake Tool
  • TOAD for Oracle
  • SQL Developer
  • Quest Central
  • PERL
  • AIX Shell Scripting
  • CA Service Desk
  • Tivoli Help Desk
  • Clarity Time Tracking
  • Microsoft Access
  • Maximo
  • ServiceNow
  • Qliksense
  • BIRT Reporting
  • Power BI
  • AIX
  • Windows 2000
  • Windows 2007
  • Windows 81 Pro
  • OS390
  • NOVELL
  • TCP/IP
  • IBM Hardware
  • CISCO Hardware

Hobbies and Interests

  • Travel
  • Cultural Experiences

Education And Professional Development

  • Project Management Applied Tools and Techniques, University of Waterloo
  • Diploma, Computer Programmer Analyst, Conestoga College
  • Data Modelling Course
  • DB2 Courses
  • UDB DBA Database Administrator course, IBM

Key Proficiencies

  • Analytical skills to develop and administer data modeling and database management solutions.
  • Hands on problem management, easily trouble shoots highly complex issues.
  • Organizational skills, plans and oversees projects from conception to completion.
  • Demonstrated leadership skills, leads by example.
  • Positive team player who can also guide, coach and mentor.
  • Excellent communication skills, requirements gathering and solution design.
  • Strong customer focus, listening, understanding and following through with customer needs and following through with recommendation to Management.
  • Strong SQL background in writing queries to analyze data for the Business needs.
  • Ability to remain calm under pressure.
  • Good collaborator with the Business, Third parties and internal/external teams.
  • Work with IT team to develop SLAs for Problem Management and escalation and follows through with using SLAs.

Timeline

DB2 for Z/os Database Administrator

Canada Revenue Agency
Current - Current

IT Programmer/DBA/BI Reporting Analyst

Heartland Farm Mutual Insurance Company
01.2016 - 01.2021

Senior zOS DB2 Database Administrator

Manulife Financial
01.2014 - 01.2016

Project Management Applied Tools and Techniques -

University of Waterloo

Diploma - Computer Programmer Analyst

Conestoga College

UDB DBA Database Administrator course -

IBM

Similar Profiles

CREATE PROFILE
Brenda Pitt