Michellea David

Work History

Database Architect

Jewelers Mutual

01.2023 - 06.2023

Set up and controlled user profiles and access levels for each database segment to protect important data.
Used SQL Server, MongoDB, Google Data Lake
Coded CCPA requirements to remove client PII data from Guidewire software on request
Design PowerShell functions and add to custom package in Nexus
Create an Azure Data Factory (ADF) pipeline, Azure keys, and Azure storage Blob
Design SSDT structure for databases in Visual Studio, compile with Jenkins, and deploy with CARA to Azure MI
Monitor JAMS jobs, sequences, and workflows
Reverse Engineer SSIS code to find performance issues
Troubleshoot SSAS deployment
Architect user groups for each type of project and environment so logins/users are maintained by the system admins
Used JAMS to run database backup jobs, Zerto and Veeam would copy the files for archiving
Troubleshoot SQL Server always on disconnection issues from On-Prem to Azure
Created data sets in Google Data Lake
Architected databases in Azure Atlas MongoDB
Designed physical table structures to client parameters, integrating business goals and data set characteristics to streamline data entry and processing.
Performed data integrity inspections, referring exceptions and discrepancies to manager for amelioration.
Managed identification, protection and use of data assets.

Lead Database Administrator

Cedars Sinai Medical Center

05.2022 - 11.2022

Worked with SQL Server and Oracle
Support over 300 Oracle and SQL Server environments
Integrated and migrated databases from newly bought hospital
Lead a team of 5 Oracle DBAs and 1 SQL Server DBA
Used Veeam and Commvault for Database backups
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Coordinated with project management on database development timelines.

Lead Database Administrator

Datavail

11.2020 - 05.2022

Supportted 19 clients
Gather client requirements and expectations
Evaluate database, SSIS, SSAS, SSRS, servers, cloud (AWS RDS, Rackspace, and Azure), storage, and VMware configurations for performance
Redesign SQL Server and hardware layout for performance
Fix low performing queries and databases
Implemented TDE, partitioning, archiving, and backup strategies
Write TSQL code to automatically partition and archive
Managed large database migrations
Redesign indexes for performance
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Developed scripts and processes for data integration and maintenance.
Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Conducted tests to identify issues and make necessary modifications.
Coordinated with project management on database development timelines.
Wrote and maintained technical and functional specifications to document database intentions and requirements.

Manager Database Administrators, AVP

Mechanics Bank/CRB Auto

05.2018 - 05.2020

While in charge, the environment grew from 10 to over 500 databases with 25 SQL Server instances, and 3 Oracle instances
Saved the company 500K in consulting costs by assigning a DBA to implement Apex Oracle on Linux
Managed five SQL Server/Oracle DBAs with no turnover in two years
Budgeted database administration cost and team overhead
Used Agile project management skills to head an initiative to move all Production databases into an HA/DR always on environment
Administrated SQL Server and Oracle environments - ETL, Data Warehouse, OLTP, OLAP, and Azure environments
Maintained Web site and databases in a Cloud environment at Rackspace and Azure
Project manager, using Kanban, to partition larger databases
Coordinated database migration and integration for three bank mergers
Coordinated free and paid database training for all I.T
Planed DBA and BI reporting team building events
Wrote employee evaluations and met with employees to talk about objectives every six months, for two large data migration projects from EMEA UK, EMEA Germany, Asia Pacific’s, North America, and Military/Government regions into the Central Database environment
Mentored offshore DBA team in preparation for software support relocation
Promoted and led performance enhancement culture by actively coaching and mentoring direct reports.
Communicated business concepts and expected functional behavior to developers and other stakeholders.
Demonstrated proficient leadership skills to motivate employees and build competent teams.
Hired and managed employees to maximize productivity while training staff on best practices and protocols.
Identified opportunities to improve business process flows and productivity.
Clarified roles, responsibilities and expectations of staff.
Established performance goals for department and outlined processes for achievement.
Identified and resolved issues between employees, promoting better collaboration and mutual respect.
Established performance goals for department and provided methods for reaching milestones.
Evaluated product development strategies and prepared alternative approaches to goal achievement.
Mitigated regulatory risks by overseeing adherence to insurance and safety regulations.

Database Administrator

Mechanics Bank/CRB Auto

11.2016 - 05.2018

Programmed ETL in SSIS using Visual Studio and TFS/Azure DevOps
Created a Centralized Monitoring environment to compile all ETL errors and server job details into one database for the DBA team using MSX job server.
Forecast growth, usage statistics, and generated baselines for each instance
Create on-call paging with PagerDuty
Administer the Auto payment website on Rackspace
On-call 24/7 every other week
Developed and updated databases to handle customer data.
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Developed scripts and processes for data integration and maintenance.
Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Modified databases to meet needs and goals determined during planning process.
Built databases and table structures for web applications.
Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
Wrote and maintained technical and functional specifications to document database intentions and requirements.
Implemented security measures to protect vital business data.
Installed and configured middleware in Linux and Windows environments.

Database Administrator II

United Auto Credit

08.2015 - 11.2016

Developed and updated databases to handle customer data.
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Developed scripts and processes for data integration and maintenance.
Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
Conducted tests to identify issues and make necessary modifications.
Set up and controlled user access levels across databases to protect important data.
Tested programs and databases to identify issues and make necessary modifications.
Wrote and maintained technical and functional specifications to document database intentions and requirements.
Project Manager to migrate twenty-one databases from a SQL Server 2008 R2 Instance to four SQL Server 2012 Always On instances. Saving license fees.
Manage three Jr DBAs: teaching DBA skills, holding SQL Server classes, and training them in project management.

Sr Development DBA

Carlson Wagonlit Corporation, CWT

11.2008 - 08.2015

SQL Server and Oracle Development DBA
Developed scripts and processes for data integration and maintenance.
Modified databases to meet needs and goals determined during planning process.
Conducted tests to identify issues and make necessary modifications.
Created and updated database designs and data models.
Built databases and table structures for web applications.
Project Manager and Database Administrator for two large data migration projects from EMEA UK, EMEA Germany, Asia Pacific’s, North America, and Military/Government regions into the Central Database environment
Mentored offshore DBA team in preparation for software support relocation
Coordinated with project management on database development timelines.
Skilled at working independently and collaboratively in a team environment.
Self-motivated, with a strong sense of personal responsibility.
Worked well in a team setting, providing support and guidance.

Software Engineer SQL Server/Oracle Developer

IBaset

11.2004 - 06.2008

Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance.
Updated old code bases to modern development standards, improving functionality.
Integrated third-party tools and components into applications.
Analyzed proposed technical solutions based on customer requirements.
Delivered unit-tested systems within customer-prescribed timeframes.
Collaborated with clients to define solution requirements.
Coordinated with other engineers to evaluate and improve software and hardware interfaces.

Development DBA and System Administrator

Los Alamos National Laboratory

05.2002 - 06.2004

SQL Server/Oracle/MySQL/NoSQL DBA
Solaris and Windows System Administrator
Developed and updated databases to handle customer data.
Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Developed scripts and processes for data integration and maintenance.
Created and updated database designs and data models.
Modified databases to meet needs and goals determined during planning process.
Built databases and table structures for web applications.
Determined database structural requirements, working with business stakeholders to identify optimal database specifications.
Installed and configured middleware in Solaris and Windows environments.

Oracle Production DBA

BenefitPoint

05.2000 - 05.2002

Established working relationships across various departments to understand existing and emerging IT requirements.
Developed automated processes to manage database creation in virtualized or cloud environment.
Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
Provided resources and skill sets to support DBA functions for applications.
Troubleshot database issues to create and resolve trouble tickets.
Set up and controlled user access levels across databases to protect important data.
Modified databases to meet needs and goals determined during planning process.
Implemented security measures to protect vital business data.
Adhered to set schedules to test databases for flaws and reduce downtime.
Installed and configured middleware in Linux and Windows environments.

IR Technologist (Help-desk and Java Software Eng)

Sun Microsystems Systems

12.1998 - 05.2000

Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
Wrote enhancements in Java
Internal Solaris help desk
Help desk for 3rd party applications on Solaris

Prior to 1998 Worked in Accounting

Various

01.1993 - 12.1998

Implemented internal controls and safeguards for receipt of revenue, costs, budgets and expenditures.
Compiled and reviewed data and delivered reports of financial statuses.
Reviewed regulations and guidelines to confirm business accounting practices adhered to GAAP standards.
Handled cash controls and implemented payment authority practices and approval of Chart of Accounts.
Created detailed financial reports based on financial statuses and data.
Followed all GAAP standards and complied with regulations when setting up accounts, ledgers and reporting systems.
Created accounts, wrote ledgers and set up reporting systems based on GAAP standards and regulations.

Summary

Overview

Work History

Database Architect

Lead Database Administrator

Lead Database Administrator

Manager Database Administrators, AVP

Database Administrator

Database Administrator II

Sr Development DBA

Software Engineer SQL Server/Oracle Developer

Development DBA and System Administrator

Oracle Production DBA

IR Technologist (Help-desk and Java Software Eng)

Prior to 1998 Worked in Accounting

Education

Master of Science - Databases

BBA - Accounting And Statistics

Skills

Volunteer

Timeline

Similar Profiles

Dana KoutnikDana Koutnik

Vanessa GomezVanessa Gomez

Rowan UnderhillRowan Underhill

Dylan McCurdyDylan McCurdy

Michaela RogersMichaela Rogers