Sandra Mausberg Email & Phone Number

United States

Calgary, Ab, Ca

Calgary, Ab, Ca

Newtown, Pa, Us

Strategized and developed lift-and-shift migration plans for 50+ db2 systems to AWS.Developed refactor database migration plans for DB2 to Aurora PostgreSQL, DB2 to Snowflake, DB2 to Redshift and DB2 to DynamoDB.Refactored 50+ DB2 databases to Aurora PostgreSQL 11.4.Refactored DB2 Warehouse databases to Redshift.Lead project with in-depth understanding of AWS Services, best practices, methods of creating cloud-native solutions and an overall detailed understanding of all database technologies.Ability to simplify complex problems and build solutions.Determined to meet business critical deadlines.Ability to simplify complex problems, build cloud-native solutions and solve technical problems.Cooperate and communicate with developers, technical team members, designers, and stakeholders.Guarantee that the functional requirements are achievable, met, and tracked.Directs deployment scheduling in coordination with tech lead, Dev Ops, and Product Owner- help to manage dependencies among cross-product teams.Initiates project planning.Ability to understand and communicate technical concepts to both technical and non-technical colleagues.Registers and controls the sprint planning and grooming meetings and trails ticket assignments.Monitors and schedules projects - as per the Project Roadmap defined by the Business Owner.Manages the daily stand-ups, securing they are timely, brief, and focused.Ensuring the team is working effectively, clearing obstacles.Capable of working independently with minimal oversight.

Provide database consulting and design services to a large midwest insurance company.Provide physical and logical design of database, from instance to index creation.Maintain four highly clustered DB2 data warehouse systems.Each of the four systems consists of approximately 160 nodes and 60 terabytes of data.Perform problem determination, tracking and resolution by using various approaches such as problem circumvention, system impact estimation, incidence tracking, and diagnostic and trace reports. Responsibilities also include monitoring system performance and carrying out system analysis and tuning.Design and implement ETL processes and ensure data integrity and completeness.Maintain a high level of customer satisfaction through on-going communication, teamwork, timeliness and a close working relationship.Assist users with procedure and UDF implementation, testing and problem resolution.Query Optimization through analysis, data collocation, index creation, query rewriting.Responsible for backup and recovery procedures and scripts.Experience with loading CLOBS and XML columns and translating CLOBS to XMLSetup and implementation of federated servers and connections across different database systems.Design, setup and implementation of LBAC (Label Based Access Control) rules and policies.Experience with load jobs and data movement from MVS/TSO system to DB2 on Linux.Experience with all db2 utilities.Setup IBM’s Optim Performance Manager tool with DB2 Databases.

Edmonton, Alberta, Ca

Highly experienced in writing Terraform code for automated infrastructure deployment and ongoing management of systemsDesigned Banking solution Data Lake with pipelines and data ingestion funneling in from numerous database systems.Developed processes written in Python/PySpark using AWS Glue, AWS Athena, AWS Pipelines, Amazon Sage Maker and AWS Lake Formation services20+ years experience with data partitioning. Able to apply past experience with data partitioning best practices for use on S3 and AWS GlueDevelop, construct and automate data pipelines and computational architectures that allow for leading edge analytical modelsTranslates complex functional and technical requirements into detailed design, and high performing end to end solutionsDeveloped a deep understanding of data and business modules.Analyze data to help determine insights to solve business problems or identify new opportunitiesCreated automation of data quality process in line with the corporate data governance standardsDesign and build interactive and static data visualizations to provide insights and enable strategic business decisions.

Edmonton, Alberta, Ca

Setup and designed SAP Replication Server (SRS) for SAP HANA databases to IBM DB2. Worked on SAP HANA migration project for ATB which used SRS at first, then SLT and finally SDI. Dealt with usual database administration tasks such as performance and optimization, tuning and troubleshooting.Took over IBMs database role with ATB and rewrote all of the scripts to manage their systems more efficiently.Automated new processes for ATB that were not being done by IBM. Within 6 months ATB's systems were performing more efficiently with double the amount of data. Business users became confident in the performance and availability of the systems they worked on.Supported 250+ db2 instances with HADR enabled. Production systems required 24/7/365 availabilityProvide database monitoring and problem circumvention and resolutionAdvising teams on DB2 best practices. Lead team on creation of databases and setting up procedures.Responsibilities also include monitoring system performance and carrying out system analysis and tuning.Analytical problem solver, able to anticipate issues and create new systems that streamline operations, resolve concerns and improve efficiencyQuery Optimization through analysis, data collocation, index creation, query rewriting.Assisted in Backup/recovery procedures and Disaster Recovery for entire ATB infrastructure.Delivered off hour and weekend support when needed

Calgary, Alberta, Ca

Lead database team on the mainframe migration of db2 databases to Linux environmentProvide physical data design of database and continued to modify physical architecture to improve performance.Designed solutions to aid in mainframe data translation. Consisted of working with star schema models and required creating functions to interpret/translate and clean mainframe data.Analytical problem solver, able to anticipate issues and create new systems that streamline operations, resolve concerns and improve efficiencySkilled in building excellent rapport with client and team members. Able to see the big picture, delegate effectively to achieve on time project completion.Experience with UniKix Middle-ware and other applications such as CICS and IMS databasesResponsible for backup and recovery scripts, optimizing and tuning the system for workload, configuring systems for maximum performance, LDAP security.Implemented industry best practicesPerformed capacity planning and resource estimates for 3 databases in a Virtual Machine environment.Worked with teams across the globeDelivered off hour and weekend support when needed

Calgary, Alberta, Ca

University of CalgaryLocation: Calgary, AlbertaContributing member of the Milos Software Research Project.Actively participated in a team environment under minimal supervision by Dr. Frank Maurer.Co-developed a web-based application, which manages and maintains the development of other software projects.Gained valuable experience with various software application development tools including Enterprise Java Bean Technology, JSP, WAP, IBM’s DB2 and IBM VisualAge.Provided the team with weekly status updates.Successfully integrated group feedback and made revisions to the application accordingly.Worked to schedule.

Education record

Sap Hana 1.0 - Sap Certified Application Associate

Advanced Database Adminsitrator Db2 V9 For Linux, Unix And Windows

Bachelor Of Technology - Btech, Computer Science

Advanced Technical Expert Db2 Universal Database Enterprise-Extended Edition V7

B.S, Computer Science

Education record

Education record