Sign in

IT Technical Specialist

Omaha, Nebraska, United States
March 12, 2019

Contact this candidate


Carol Ann Brothers

Omaha, NE *****


Summary of Qualifications

Quality-driven IS Database Technical Specialist with experience in broader Information Technology discipline. Proven ability in documentation and interfacing with others to ensure stakeholder confidence and satisfaction. Possess basic understandings of Waterfall/Agile methodologies, SQL and gatekeeper to service queues. With DBA access, use of SQL-Developer to create & maintain Oracle User Accounts; use of Oracle Unified Directory (OUD); Oracle Enterprise Manager (OEM) related SQL; Putty; MVS (TSO). Experience in Change Control, Enterprise Vendor Management Program (EVMP), Asset Management, BMC Remedy, OpenPages and Erwin. Strong technical writing for wide variety of genres; i.e., vi, procedures, project management, educational, technical, safety & quality control. Invite team collaboration. Welcome repetitive input tasks that improve quality & security. Comfortable working remotely, as needed.

User Applications: Microsoft Visio, Project, Word, Excel, Outlook, PowerPoint, SharePoint, Office365, Skype, QuickBooks, SQL-Developer, Oracle, OpenPages, Erwin, Metadata Repository, SpecsIntact (XML), VMware (InfoSphere), Privia Proposal Management, USACE Resident Management System (RMS), AutoBid Mechanical.

Professional Experience

Mutual of Omaha, Omaha, NE Jan. 2014 – Jan. 2018

Technical Specialist/Business Systems Technician

Hired as IT Intern in IS Infrastructure within relational database management, which included the Tools team. As a quality and productivity-driven team member, identified a need and created a basic script to compare 183+ Oracle databases for their inclusion among IS Security (IIQ/SailPoint), OEM and manual inventory databases. Script added to existing script that ran through 99+ Linux servers hosting Oracle Relational Database Management Systems (RDBMS). Assisted Project Managers.

•Gathered metrics for service requests to create a Baseline using SIPOC and Visio cross-functional diagrams, from modeling through table creation/changes, for creating a data element (conducted analyses of technical and business requirements) and the DEV/OPS process improvement initiative. Presented these findings to the team.

•Waterfall to Agile and our department had both types of teams. Both project managers used Jira and conducted daily standups. The Agile PM provided two-week sprints as well as storyboards, retrospectives and backlogs. Assisted the scrum master when the PM was out of the office, while creating Jira tasks during those ceremonies. Participated in daily Kanbans.

•Collaborated and confirmed DDQs were up-to-date with IS Security (OpenPages), established status of (current/expired) engagements in order to send data off property to third-party vendors. Performed quality assurance functions to identify/investigate deviations from standards.

•Triaged SQL Server and Oracle service request queues daily, documented business rules, identifying possible deviations from those rules, EVMP, Remedy change controls, reversed engineered DDL from Erwin Data Modeler under the direction of Senior DBA. Reviewed and approved/rejected service requests on behalf of manager. Introduction of process reduced time waste using centralized researcher/troubleshooter.

•Installed Oracle clients onto Windows servers, minimized need for multiple DBAs to complete similar tasks, which increased quality control/productivity. Picked up DB2 requests and generated Copybooks.

•Maintained Oracle user access requests, daily. Created individual OUD and non-individual accounts, schemas, grants, roles, etc., using SQL-Developer v4.1.5, CN=Directory, Putty. Maintained a 98.6+ SLA rating. Maintained Tablespaces and Datafiles.

•Participated in two off-site Disaster Recovery Exercises using off-site URL, Bcinthecloud, with CPR dashboard updates and documentation. These activities helped prepare/create improvements for several areas within IS Infrastructure and Operations.

•Facilitated and prepared meeting materials from BMC Remedy for weekly Change Management/Critical Incident Management meeting, to 34-DBA team members, for collaboration/awareness purposes among six workgroups. Chaired in enterprise change management meetings to make sure RDBMS were included in discussions and initiate collaboration among workgroups.

Carol Ann Brothers 402-***-**** Page Two

Technical Specialist/Business Systems Technician (continued)

•Created and maintained internal procedural documentation. Lead teams’ documentation repository and master Table of Contents (TOC) for annual reviews/updates, assigning JIRA tasks. Published TOC to Confluence. Maintained Policies/Standards in Quickr and OpenPages, for VP approvals and updated RDBMS APEX inventory.

•Researched/created team products inventory for original comparison into Configuration Management Database (CMDB), while retiring software bundles/packages. Ran SCCM, IBM License Metric Tool (ILMT), native commands, etc. for maintaining inventory.

•Championed a Plan and Schedule for upgrading Oracle clients to v12.2, using email to several internal application support contacts, identifying historical clients that were unable to upgrade. Used Excel to analyze email data into Pivot tables to investigate, monitor and schedule to help reduce technical debt.

oWorked with package builders that required the client upgrade, enterprise-wide, who required the manual processes to de-install Oracle 11g in order to push SCCM packages for both servers and workstations.

•Collected weekly metrics using SSMS for statistical backup reports (via TSM clients from Idera and RMAN) and Service Requests for SQL Server, Oracle and Teradata queues.

•Performed basic functions within Oracle RDBMS, using SQL Developer, natively, SSH and OEM. Provided inquires and reporting to manager regarding DBA’s procedural steps when creating databases. Resolution: Investigated and prioritized so there were no missing instances among three databases.

•Participated in annual volunteer program

Metropolitan Community College (Learning & Tutoring Centers), Omaha, NE Sept. 2013 – Jan. 2014

Instructional Assistant (Part-Time Temp Position)

Successful Team Lead for Capstone in developing an Electronic Security System and database, using XML, MySQL, Oxygen 15, NotePad++, NetBeans, Oracle, TextPad, Telecommuting.

•Assisted students with assignments by explaining concepts and demonstrating computer activities to accomplish Webpage Creation, SFTP, Project Management, MS Office products and uploading homework to Office365, SharePoint and Angel/Blackboard online learning portals.

•Assisted customers with academic resources by resetting passwords, setting up online users with SkillsTutor while assisting students.

Secure Mission Solutions, LLC (a Parsons Company), Omaha, NE Nov. 2008 – Mar. 2012

Data Manager

•Dissected stakeholder requirements from Statements of Work, selected OEM data sheets for engineering design specifications. Collaborated with engineers and prepared technical specifications, using UFGS Masters, for as-built status in PMO setting.

•Technical writer for program deliverables for technical documentation IAW Government contracts and Federal Acquisition Regulations for Quality Program (mapping PMBOK to CMMI), Training Lesson Plans, Training, Operations, Maintenance Manuals and Technical Data Packages for integrated security systems (ACS, IDS, CCTV).

•Interviewed field personnel and wrote job-specific safety plans IAW OSHA, DOI’s Bureau of Reclamation and USACE standards, reported monthly safety exposure hours, tracked correspondence and submittal statuses using Remote Terminal Site (RTS).

•Contributed to document management, proposal writing/project teleconferences, proofread, edited, formatted and submitted final deliverables and as-built drawings. Tracked preventive on-demand maintenance services IAW Federal contracts.

Mainelli Mechanical Contractors, Inc., Omaha, NE November 2007 – March 2008

Project Manager

Managed commercial projects (Union plumbers and HVAC subcontractors)

Configured and implemented estimating software using material multipliers, jointing tables and wages by customizing and interpolating labor tables (MCAA) for piping items, fittings, valves and joints

Created RFIs and initiated Change Orders, approved payments to vendors and subcontractors

Read and interpreted plans and specifications, attended pre-bid meetings and bid openings

Solicited subcontractor and supplier quotes, attended weekly meetings and managed Punch List with General Contractors

Carol Ann Brothers 402-***-**** Page Three

Greenwood Plumbing, Omaha, NE July 2006 – June 2007

Independent Contractor/Estimator

Negotiated three of four projects awarded ($1.7m)

Implemented estimating software for vendors material multipliers and wages

Scrutinized and selected projects from Omaha Builders Exchange, interpreted Plans and Specifications, performed digitized take off of plumbing and piping items, obtained subcontractor and supplier quotes

Delegated work to subcontractors in owner’s absence

Prepared pre-qualifications and attended pre-bid meetings, submitted proposals, AIA documents, RFIs, RFCs and Lien Waivers

Rose Brothers’ Enterprises, Inc., Carson, IA June 2000 – April 2006

Vice President, Secretary and Treasurer

Managed residential projects and business sign installations

Prepared estimates, proposals for ICF and remodeling projects, permit applications

Met with municipalities and customers, performed computer-aided residential designs

Maintained full-cycle accounting including collections, account reconciliations, adjusting journal entries in accordance with financial plans

Attended annual meetings with tax-attorney and year-end tax filings

Sold home remodeling products, performed cold-call sales and site surveys for the design and manufacturing of outdoor business signs. Purchased, picked up and delivered heavy equipment and materials.

Education / Certifications / Professional Development & Affiliations

AAS in IT – Database Administration Metropolitan Community College, Omaha, NE (2013)

Senn Delaney Culture Shaping and SQL 3-day In-house Training Class (2017)

Overviews on Oracle Data Guard, Oracle Advanced Security Workshop

USACE Construction Quality Management for Contractors (RMS)

DOD Interim Clearance (Secret) expired

Former Member: Project Management Institute and Omaha Builders Exchange

OSHA: Certified 30-HR Construction

Gallup StrengthsFinder: Maximizer, Responsibility, Belief, Activator, Analytical

Contact this candidate