Scrum Master database engineer
Resume:
Shawn McIver
**** *** ***** *****, ********, IL *2298
********@*****.***
Certifications: Comptia Security +
Certified Scrum Master (CSM)
Professional Experience
Decision Point Corp, SAFB, IL 4/2024 – Present
Database Engineer
Migrate 2TB Oracle RHEL 7 database to AWS RDS environment
Manage RDS environment for performance
Facilitating sprint planning, daily scrums, retrospectives, stakeholder meetings
Educate and reinforce scrum methodology and agile framework to team members and key stakeholders
Tracking and managing product backlog, burn-down metrics, velocity and task break-down
Adopt and enforce Scrum rules, foster self-management and removing impediments
Release management for Application team (Payment & Application Security). Review and write scripts for monthly release and implement through development, QA, SIT, and production.
Attend weekly sprint planning sessions
Apply PSU’s to standalone and replicated (dataguard) environments quarterly
Switchover dataguard environments quarterly
Refresh environment from BCV copies for PSU application and for new application releases
Clone staging environment for new test cycles and PSU using ASM Clone.
Disaster Recovery Exercise, recovered and restored critical database, assisted others with troubleshooting and monitoring.
Work up cost estimates for new space/disk, implement new storage when available.
Prep environments for Patching cycle
Patch Enterprise Manager and dev/test/production database with latest PSU.
Handle PCI data
Scrub data to conform with General Data Protection Regulation in Europe
Manage workload using JIRA
Utilize Confluence for documentation
Manage version control tools and deployment tools such as GitHub, Jenkins, Artifactory
Manager database servers and databases history with CMDB
Utilize ServiceNow for incidents/change request
Led Critical Situation, High Severity Incident Management and Escalation calls.
Periodic update to Leadership and Business stakeholders during Critical Situation or whenever required.
Represent Infrastructure Team on external Audit and take corrective actions whenever needed.
Wells Fargo, Saint Louis, MO 6/2020 – 4/2024
Senior Infrastructure Engineer
Educate and reinforce scrum methodology and agile framework to team members and key stakeholders
Track and manage product backlog, sprint churn, burn-down metrics, velocity and task break-down
Facilitate transition of application from waterfall to agile framework
Adopt and enforce Scrum rules, foster self-management and removing impediments
Identify anti-patterns, work with team members to correct and avoid
Work closely with Product Owner to understand requirements and story direction to better help team members achieve success in the sprint
Attend and facilitate meetings with key stakeholders for PI planning, refinement and sprint planning
Hold Fit Assessment evaluations with stakeholders quarterly
Assist with vulnerability resolution, researching vulnerability solutions
Provide support to application teams with deployment solutions for complex products and data challenges/issues.
Develop projects and strategies to improve our security compliance and processes.
Research, define solutions, and create technical documentation for patches/upgrades, removals, and configuration changes of Application products.
Lead, provide technical support, troubleshoot, and document solution during emergency vulnerabilities.
Monitor various information sources to identify new cyber security threats and assess against our products and solutions.
Gather and evaluate cyber threat business intelligence requirements for the LOBs by having regular discussions with key line of business personnel (e.g. operational risk personnel, technology managers, information security leaders, etc.).
Collaborate with various organizations on all manners of security and compliance related business matters.
Troubleshoot complex software application remediation issues. Issues to be resolved, require a broad range of troubleshooting skills related to: software functionality, application product setup, database management, data analysis, standalone/embedded products, and third party (vendor supported) products.
Research, identify, and provide solutions for complex products (i.e. embedded, dependencies, bundled, database, etc.)
Collaborate, troubleshoot, and provide guidance to applications and database teams with proper remediation solutions.
Enterprise, Saint Louis, MO
Database Engineer 10/2017 – 4/2020
●Facilitating sprint planning, daily scrums, retrospectives, stakeholder meetings
●Educate and reinforce scrum methodology and agile framework to team members and key stakeholders
●Tracking and managing product backlog, burn-down metrics, velocity and task break-down
●Adopt and enforce Scrum rules, foster self-management and removing impediments
●Release management for Application team (Payment & Application Security). Review and write scripts for monthly release and implement through development, QA, SIT, and production.
●Work with Scrum masters in Agile model to accomplish task, attend weekly sprint planning sessions
●Apply PSU’s to standalone and replicated (dataguard) environments quarterly
●Switchover dataguard environments quarterly
●Refresh environment from BCV copies for PSU application and for new application releases
●Clone staging environment for new test cycles and PSU using ASM Clone.
●Disaster Recovery Exercise, recovered and restored critical database, assisted others with troubleshooting and monitoring.
●Implemented Workday in Application Security environment.
●Work with storage team on disk migrations
●Work up cost estimates for new space/disk, implement new storage when available.
●Prep environments for Patching cycle
●Migrate environments from OEM 12c to OEM 13.
●Patch Enterprise Manager and dev/test/production database with latest PSU.
●Handle PCI data
●Scrub data to conform with General Data Protection Regulation in Europe
●Manage workload using JIRA
●Utilize Confluence for documentation
●Manage version control tools and deployment tools such as GitHub, Jenkins, Artifactory
●Manager database servers and databases history with CMDB
●Utilize ServiceNow for incidents/change request
●Led Critical Situation, High Severity Incident Management and Escalation calls.
●Periodic update to Leadership and Business stakeholders during Critical Situation or whenever required.
●Represent Infrastructure Team on external Audit and take corrective actions whenever needed.
Saint Louis University, Saint Louis, MO
Database Administrator (Sr. Engineer/Analyst) 5/2014 – 10/2017
●Support Oracle 11g databases for the University and Learning education system using OEM and Toad, with SCOM alerting. Perform 24X7 on call duties
●Build 12c OEM and RMAN environments, setting up alerting, monitoring, migrating all backup jobs from 11g to 12c.
●Upgrade non-encrypted and encrypted database to 12c.
●Planned and conducted database platform migration from HP-UX Itanium OS with disk storage to Unbreakable Linux on Oracle Database Appliance with ASM storage
●Worked with Vendor to implement Oracle TDE. Creating the wallet and moving all data into encrypted tablespaces
●Work with auditor team to identify vulnerabilities and correct where needed or write exemptions.
●Coordinate and conduct monthly clone of production to test and development environments using RMAN active duplicate
●Coordinated and conducted the move of all Oracle database backups from Data Protector to Grid using storage local on the ODA.
●Design, configure and implement Dataguard for DR situation
●Manage Backups and restores of database in a Common Computing Environment
●Work with Programs to upgrade their systems.
●Tested and documented database upgrade from 11.2.03 to 11.2.0.4 maintaining critical patches and performance tuning
●Ensure database availability, reliability, security, and connectivity through monitoring with OEM
●Administer privileged accounts
●Performance issues – work with application teams to identify query problems
●Led Critical Situation, High Severity Incident Management and Escalation calls.
●Periodic update to Leadership and Business stakeholders during Critical Situation or whenever required.
●Represent Infrastructure Team on external Audit and take corrective actions whenever needed.
Astadia (Contract Anhueser Busch) Jacksonville, FL
Database Administrator 12/2013 – 5/2014
●Simulate Disaster Recovery incident by working through Books created with documentation and steps needed to bring environment back on-line.
●Strategize and create DR and BCP Handbook, train IT and Business Team for DR preparedness and perform annual DR & BC Exercises.
●Ensure database availability, reliability, security, and connectivity
●Administer privileged accounts, reset privilege account passwords on a rotating 3 month basis
●Performance issues – work with application teams to identify query problems
●Implement releases
●Perform post action report, root cause analysis and mitigation plan.
●Conduct tabletop training exercises to IT Team, Application development Team and stakeholders.
●Conduct annual DR Exercise.
●Led Critical Situation, High Severity Incident Management and Escalation calls.
●Create DR and BCP Handbook, train IT and Business Team for DR preparedness and perform annual DR & BC Exercises
●Spearhead Infrastructure Team on implementing & fine-tuning Asset Management, onboarding/decommissioning Servers/Assets
SRA International, Inc., Fairfax, VA
Database Administrator (Sr. Engineer/Analyst) 7/2012 – 12/2013
●Manage Backups and restores of database in a Common Computing Environment
●Work with Programs to upgrade their systems.
●Design, install and maintain migration from Oracle Application Server to Oracle Fusion Middleware - Weblogic
●Upgrade environments from Oracle 11.2.0.2 to 11.2.0.3, maintaining Critical Patches
●Ensure database availability, reliability, security, and connectivity
●Administer privileged accounts
●Performance issues – work with application teams to identify query problems
●Veritas Cluster monitoring for database zones
●Led Critical Situation, High Severity Incident Management and Escalation calls.
●Periodic update to Leadership and Business stakeholders during Critical Situation or whenever required.
Harris
Database Engineer 10/2009 – 7/2012
●Support Hotline – answered and supported hotline calls from business units – calls range from password issues to max sessions to performance issues.
●Run monthly security scripts (STIG/SOX), identifying vulnerabilities and resolving as necessary or writing exemption.
●OEM – monitor space alerts, warnings/critical errors.
●Performance issues – work with application teams to identify query problems
●RMAN – perform backups, check failures and kick off based full destinations
●Release Management – Coordination of changes between business team and DBA, application of scripts, upgrading applications, review logs for errors, work with developers to clean up errors.
●Install Oracle 10g, and upgrade machines with Oracle Critical Patches as necessary
●Clone databases from production RMAN backups
●Monitoring and auditing database operations. Performing recovery procedures from system crashes
●Ensure database availability, reliability, security, and connectivity
●Administer privileged accounts
●Create/delete/modify DB user accounts and access privileges
●Monitor health (table space size, error logs, queue logs, etc) of single node and RAC Systems
●Track/Analyze database performance against the metrics
●Rebuild indexes
●Strategize and create DR and BCP Handbook, train IT and Business Team for DR preparedness and perform annual DR & BC Exercises.
●Administer SharePlex or other applicable replication software – monitor health of replication streams, redirect stream in a failover situation, and build new streams for testing or production purposes
●Troubleshoot - Detect and resolve database performance concerns
●Restore/Backup - Recover individual tables or entire database as necessary (data)
●Build test environments from correct baseline applying software releases and supporting testers with problems found during SIT testing
●Lead Infrastructure Team on implementing & fine-tuning Asset Management, onboarding/decommissioning Servers/Assets on CMDB.
●Implement Application to Server mapping, Server & Application upstream/downstream dependencies as these are important during Critical situations and during Conflict.
●Perform periodic Risk Assessment & strategize Mitigation Plan.
●Led Critical Situation, High Severity Incident Management and Escalation calls.
●Periodic update to Leadership and Business stakeholders during Critical Situation or whenever required.
●Perform post action report, root cause analysis and mitigation plan.
●Conduct tabletop training exercises to IT Team, Application development Team and stakeholders.
●Conduct annual DR Exercise.
NCI
Database Administrator 01/09 – 10/2009
●Ensure database availability, reliability, security, and connectivity
●Administer privileged accounts
●Create/delete/modify DB user accounts and access privileges
●Monitor health (table space size, error logs, queue logs, etc) of single node and RAC Systems
●Track/Analyze database performance against the metrics
●Perform Dump datasets
●Run DB maintenance scripts as provided by Level 3/PMO
●Rebuild indexes
●Administer SharePlex or other applicable replication software
●Troubleshooting/repair of DB's within skill level authority scope and per Level 3/PMO direction
Troubleshoot - Detect and resolve database performance concerns
●Restore/Backup - Recover individual tables or entire database as necessary (data)
Strategic Staffing (Assignment – Monsanto)
Database Administrator 12/07 – 12/08
●Support Hotline – answered and supported hotline calls from business units – calls range from password issues to max sessions to performance issues.
●OEM – monitor space alerts, warnings/critical errors.
●Performance issues – work with application teams to identify query problems
●RMAN – perform backups, check failures and kick off based full destinations
●Release Management – Coordination of changes between business team and DBA, application of scripts, upgrading applications, review logs for errors, work with developers to clean up errors.
●Oracle Internet Directory (OID) – maintain the OID suite, make changes to entries, add new changes, fix when broken.
●Install Oracle 10g, and upgrade machines with Oracle Critical Patches as necessary
●Clone databases from client dumps
●Monitoring and auditing database operations. Performing recovery procedures from system crashes
Northrop Grumman 02/04 – 10/07
Database Administrator
●Oracle Real Cluster Application (RAC) – maintaining, upgrading, backing up, building
●Release Management – pull changed files from SourceSafe and Clear Quest, apply to databases, and compile all that are invalid, release to development or testing teams
●Prepare documentation for version release
●Set-up Shareplex to resemble client production environment
●Install Oracle 10g, and upgrade machines with Oracle Critical Patches as necessary
●Clone databases from client dumps
●Travel to client site for version installations, trouble shoot and resolve any problem due from the installation
●Develop system Logical Data Models (LDM) and Physical Data Models (PDM) guidelines in the development, normalization, definition, documentation and integration of system data requirements
●Assists database server installation and upgrade, physical device configuration, database creation and population, system configuration settings, server monitoring and preventive maintenance, backup and maintenance of the system databases, server startup and shutdown, system security, and management of roles
●Performing data entry and/or database management operations in support of product design team
●Assisting in designing files within established specifications
●Monitoring and auditing database operations. Performing recovery procedures from system crashes
●Controlling data definitions within established data standards for existing applications
●Updating and maintaining database records and tables as required
●Design and implement new databases with Database Configuration Assistant as required by the Company's business requirements
●Work with Network and Operations managers and staff to determine space availability, placement, and back up procedures for the Oracle databases with 10g
●Designs, documents and guides the use of data and database changes for complex, enterprise wide database integration
●Analyzes needs and requirements of existing and proposed systems, and develops technical, structural, and organizational specifications
●Create standards and/or do modeling to monitor and enhance capacity and performance
●Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries
●Review database design and integration of systems, including client/servers, mainframes, etc., and makes recommendations regarding enhancements and/or improvements
Amdocs, Inc 07/99 – 02/04
Application Database Administrator
●Work closely with the application and business client to successfully implement an effect data model for new and existing projects, review changes and make recommendations to enhance them or use existing structure
●Approve data model changes for multiple projects/versions by checking spool logs created by building the table with SQLPlus, and check the build logs that are compiled in Unix 11i
●Conduct data model change meetings where impact assessments are discussed among application teams and database administrators question the reasoning of primary and foreign keys, verify proper naming standards for Oracle 8i, the client, and the company
●Oversee the creation of the physical and logical data models on cross application systems created using data modeling tool ACU/Designer 2000 (Amdocs customized tool comparable to Erwin)
●Troubleshoot and problem analysis data model changes and their impact on other applications
●Coordinate implementation of relational database management systems in a client/server architecture using Oracle 8i/9i
Database Manager
●Approved 600 data model changes in one day which resulted in a clean build on the first try
●Use SQLPlus and Toad to insert, delete, and update data for testing purposes
●Work with Business/IT clients to resolve data discrepancy issues (e.g. data integrity, data redundancy etc.) and to ensure data quality
●Validate data for all environments using SQLPlus and SQLLoader Work with the Control Configuration Team (Infrastructure) on build issues, code delivery to the client site, and splitting the cc for new versions
●Coordinate patches and data issues with the Database Administrators
●Monitor the build for each project version and work with each application to clean up the errors in their area
●Support Benchmarking, Performance, and Integration testing from a Database and Infrastructure perspective
●Contact the appropriate Infrastructure team for build errors, space issues, memory issues, database errors, sequence resets, synonym problems
●Coordinate environment issues with infrastructure team and application teams, gather all information for creation of new environments and maintenance clean-up of all old accounts and versions
●Serve in a support capacity to application teams, system test, infrastructure teams, and teams at the client site
●Use TestDirector and WinRunner to run GoNoGo testing on clean build, this test the basic functionality of a new build before the code is moved into the other system test accounts.
●Check API and Tuxedo log files to troubleshoot problems if GoNoGo fails, then work with application teams to get a new fix in the cc and rebuilt
●Refresh API clients, class, and jar files after successful builds, rebuild Weblogic and Jolt after refreshes
Programmer
●Wrote application programs for the IP Billing Team. Migrated files from Linux machine to Sun machine. Monitored network systems. Performed System administration. Installed computers connected to the IP Billing Lab. Performed System testing for various versions of PLS software. Wrote and maintained Detailed Program Design documents
●Wrote and maintained Impact Assessment documents from customer requirements.
Administrative Assistant
●Recorded time for site employees. Recorded and maintained expense reports / travel / vacation. Supported employees at a customer site. Ordered office supplies, maintain office equipment and supplies. Supported site management
Data Experts 03/99 – 07/99
Resume Technical Writer
●Typed new resumes and distributed to the recruiters. Monitored recruiter and sales people goals for the week to ensure they were meeting company expectations
Wedemeyer Cernik Corrubia 01/98 – 01/99
Office Manager
●Figured hours worked on project from payroll reports then created the bills for architecture and interior design work performed, sent bills to customer, collected payments and sent to Account Department
●Payroll and Expense reports. Human resources and benefit issues
●Ordered office supplies, maintained service contracts and equipment
●Typed specifications and proposals for prospective clients
St Louis University Health Sciences Center 07/96 – 01/98
Senior Billing Specialist
●Coded Echocardiography procedures with CPT and ICD9 codes
●Entered billing into the Meditech system for electronic filing to the insurance companies
●Typed test performed in the Echocardiography Laboratory
●Served as assistant for three attending physicians and one research physician
Miss Elaine 09/94 – 07/96
Shipping Office Manager
●Manage day-to-day operations of the shipping department for a women’s lingerie manufacturer. Prepare bills of lading for outgoing freight on a daily basis, call trucking companies for pickups, load freight on trucks
●Receive returned freight and incoming freight. Research disputes from customers concerning their freight. Manager warehouse inventory and shipping inventory
Education / Training
Bachelor of Science in Computer Science, Saint Louis University May 2001
Contact this candidate