Data Management Database Administrator

CHARLES MULWA

Dallas, TX 469-***-**** ******@*****.*** https://www.linkedin.com/in/charlesmulwa/

Data Management & Engineering

Database Administration Data Analytics Data Governance Database Architecture Development

Accomplished Data Management and Administration professional with a proven history in delivering impactful data strategies that modernize Business and Operational practices that remove complexity, reduce manual processes and accelerate product delivery.

Detail-oriented and results-driven SQL Database Administrator with 20 years of experience in managing and maintaining SQL Server and other databases across various industries.

Proficient in leading multi-disciplinary teams to realize data monetarization, data democratization, data modernization that serves organizational vision, strategy, and objectives.

Cuts down wait time for access to data products by removing unnecessary Red Tape, Data Silos, and leading teams with an owner-mentality.

Collaborates with business leaders to gather and understand requirements, translating them into clear functional specifications for technical teams. Acts as a bridge between business and development, ensuring alignment of project deliverables with business objectives

Adept at leading cross-functional teams to design, implement, and maintain robust data architectures, pipelines, governance frameworks, policies, and protocols that ensure data integrity, security, and compliance.

Known for exceptional leadership, problem solving abilities, and a commitment to fostering a data-driven culture that serves multiple departments within organizations.

CORE COMPETENCIES

Strategic Planning

Data Warehousing

Digital Transformation

Application Development

Cutting Edge Technologies

Project Management

Data Integration

Technical Teams

ETL Pipelines

Data Solutions

Data Availability

Data Infrastructure

Reporting Solutions

Infrastructure Solutions

Operational Excellence

Quality Assurance

Risk Assessment

Data Validation

Data Reporting

Data Structures

Software Solutions

People Management

Performance Management

Continuous Improvement

Enterprise Systems

Data Processing

Data Accuracy

TECHNICAL EXPERTISE

Databases:

Oracle, Hadoop, Microsoft SQL Server 2022, 2014, 2012, DB2, Amazon Redshift, MongoDB, MySQL

Operating Systems:

Windows 2016, 2012, 2008, 2003, 2000 Server, Win /10/8/, UNIX, Linux

Programming:

SQL, T-SQL, .NET, Python, JAVA, PHP, JSP, ASP, Visual Basic, JavaScript, HTML

Servers:

Microsoft IIS Web server, Apache, Web Sphere App. Server

Visualization:

Tableau, SSRS, Power Bi, PowerBi, Jaspersoft

Others:

Azure Data Factory, RedShift, SolarWinds DPA, Alteryx, RedGate, Visio, SSIS, SSAS, .Net, MS Project, Word, Excel, CRM, Salesforce, EDI, Data Analysis, delegate, Diverse, Feedback, Aviation Industry, Testing, HL7, JSON, PaSS, SaaS, IaaS, Cloud Based Databases, EC2, Glue, Airflow, RDBMS, SOPs, SLAs, GCP, Technical Liaison, Microsoft Office 365, R, Data Access, Unstructured Data, Data Modeling, Strategic Direction, Budget, Unix Shell Scripting, Global Teams, Guidance, Data Scientists, Workflows, Machine Learning, Data Cleaning, Influence, Prioritize, Writing, Health Systems, Data Classification, Data Types, Production Environments, Healthcare, EHR, SAP ERP, AWS Cloud Platform, Google Cloud, EDW, Test Driven Development, Computer Science, Professional Development, Market Research, Coach, Team Members, Dynamic Environment, Finance, People, Architects, Domain Knowledge, Changing Environment, Hiring, Scale up, Clear Communication, Programming Language, Agile Environments, Software Development Methodologies, Industry Trends, Technical Vision, IT, SAS, Core Data, Database Administrator, Big Data, IT Compliance, Employee, Innovation, Articulate, Tailor, Equity, Product Engineering, MDM, Emerging Technologies, ISO 27001, LMS, Kanban Board, Agile, Data Science, Agile Development, Vision, Software Engineer, Hadoop, Hive, Regulatory Requirements, Impala, HDFS

PROFESSIONAL EXPERIENCE

Southwest Airlines Dallas, TX 08/2023 Present

Manager, Data Management and Governance

Empowers teams to work efficiently by maintaining over 99.99% systems availability by mobilizing vendors, internal IT staff to identify, mitigate and proactively prevent systems and process constrictions.

Implements d High Availability and Disaster Recovery solutions using AlwaysOn Availability Groups, ensuring 99.99% database uptime across data centers.

Optimized complex queries, stored procedures, and indexes, improving performance by up to 50% in key transactional systems like flight booking and check-in services.

Monitored and resolved database performance issues using tools such as SQL Profiler, Extended Events, and third-party monitoring tools.

Developed and maintained automated backup and recovery solutions, ensuring zero data loss in critical airline operational data.

Collaborated with development teams to design efficient database schemas and support airline-specific applications such as baggage tracking, flight schedule management, and loyalty programs.

Conducted regular security audits and applied encryption mechanisms (TDE, SSL) to safeguard sensitive passenger and financial data.

Managed data migrations and upgrades across multiple environments (development, QA, production), ensuring minimal downtime and data integrity.

Created SSRS reports and SSIS packages to support analytics and reporting for flight performance, passenger metrics, and financial reporting.

Creates a strategic data roadmap to simplify access to data assets, reduce duplication, increase accuracy, and deliver self service capabilities to the business to facilitate quick and informed decision making.

Improves productivity by over 25% through automation of repetitive tasks, documentation of processes, and delivering information to users’ fingertips through Data Visualization solutions and self-serve tools.

Grows the value of enterprise data by breaking down unnecessary data silos and leveraging Data Lakes, Enterprise Data Warehouses (EDW) to pull together data assets.

Leverages data to ensure compliance, flight safety, effective cost management, on-time performance, and superior customer experience through timely, accurate, and easy accessibility to data.

Saves the organization millions of dollars in fines through the creation and enforcement of Data Management and Governance policies to ensure information security, accuracy, availability, and one source of truth.

A go-to professional that bridges gaps between departments and improves business and technical operations.

Provides strategic leadership to a team of managers, business analysts, BI developers, data engineers, among others.

RYAN LLC Dallas, TX 4/2022 11/2022

Director, Data Engineering

Liberates corporate clients from the burden of over taxation, freeing their capital to invest, grow, and thrive.

Leverages data to fuel strategic tax services that deliver substantial value, improved profitability, and greater cash flow for many of the world’s most respected companies.

Assist enterprise clients reclaim overpaid Use and Sales taxes by integrating with Enterprise Resource Planning systems (ERP) to extract General Ledger (GL), transactions, Accounts Payable (AP), Accounts Receivables (AR), and Balances data to support audit and refiling of their taxes.

Performs regular database backups and restorations, ensuring data integrity and compliance with disaster recovery plans.

Conducts performance tuning activities, optimizing queries and indexes to enhance database performance by 70% in critical systems.

Develops and maintained T-SQL scripts for automated tasks, including backups, index maintenance, and data integrity checks.

Manages user permissions, roles, and encryption mechanisms to safeguard sensitive data and ensure compliance with industry standards.

Enhance data democratization by transforming, storing, and providing data in a form that is accessible and useful to end users through SQL Server, Snowflake, Tableau, SSRS, SSIS, Alteryx, among other tools.

IBM WATSON HEALTH Dallas, TX 6/2015 3/2022

Director, Data Management & Governance

Collaborates with Senior Management, Business Partners, contractors, leaders, and stakeholders to set goals, priorities, manage roadblocks, and delivery of organizational initiatives.

Enhance availability and efficiency of data assets through clustering, log shipping, mirroring, replication, troubleshooting, configuration, planning, capacity management, data migration, data recovery, and monitoring.

Implement data quality measures through data profiling, data standardization, data matching, data enrichment, monitoring, and operationalization using tools such as Talent Cloud.

Active contributor to data governance, data stewardship, master data and metadata management ensuring data consistency and data democratization.

Administration and governance of SQL and NoSQL data stores including MS SQL Server 2008 – 2022, MySQL, DB2, Azure SQL Database, RDS, and Snowflake – ensuring data security, integrity, and compliance.

Simplify and automate database administration utilizing tools including IDERA Data Loss Prevention (DLP), ER Studio, Erwin, SSMS, MySQL Workbench, SQL Server Profiler, SQL Server Agent, DMVs, SolarWinds DPA, SolarWinds SQL Sentry, and PowerShell freeing up over 30% of DBA time to focus on other tasks.

Integrate with Electronic Medical Record Systems (EMR) and Practice Management Systems (PMS) to extract and exchange patient clinical and demographics data for population health management solutions.

Support business decision making and operations through implementing an enterprise data warehouse to separate OLTP from OLAP using dimensions, facts with star and snowflake schemas using Ralph Kimball Dimensional modeling approach.

Design and implement ETL data pipelines using SSIS, data stage, Azure Data Factory, Alteryx, and Python to ensure seamless data flow across systems.

Enable knowledge sharing by creating and maintaining documentation including data dictionaries, data mapping, data flow diagrams, architectural artifacts; this reduced learning curve by over 25%.

Build business continuity and disaster recovery strategies and playbooks that meet business RTO and RPO.

Create database objects including tables, collections, documents, partitions, constraints, triggers, stored procedures, indexes, keys, table spaces among other data related objects.

Realized cost saving and SLA improvements through managing third party vendor relationships, RFPs, SOWs, and contract negotiations for data management tools and services.

Collaborate with cross-functional teams to define business requirements, data standards, and data quality metrics for effective data management and reporting.

Establish and maintain data policies and procedures to ensure compliance with data protection regulations (such as HIPAA and GRPD) and industry standards.

Implement data security measures, including access controls, encryption, and data masking techniques, to safeguard sensitive data and mitigate risks.

Foster a data-driven culture by promoting data literacy, data awareness, and the value of data-driven decision making throughout the organization.

PHYTEL Inc Dallas, TX 4/2008 5/2015

Manager Data Operations

Administer, design, develop, implement database platforms and storage infrastructure in support of company’s population health management offering data systems.

Manage the full system life cycle development (SDLC) and administration of enterprise data warehouse.

Key player in implementation of Agile Methodologies, Total Quality Management Systems and Lean Six Sigma.

Establish and implement data security using GDPR, HiTrust and HIPAA standards.

Additional experience as Data Expert at Citi, RAPP, BCBS, BNSF, USDA.

SOFT SKILLS

Accountable, Creative, Collaborative, Interpersonal, Enthusiastic, Motivated, Dedicated, Resilient, Energetic, Adaptation, Confidence, Partnerships, Responsible, Reliable, Passionate, Mentor, Proactive, Attention to Detail

EDUCATION & CERTIFICATIONS

Master of Business Administration, Strategic Management, University of North Texas, Denton, TX

Bachelor of Science, Computer Information Systems, University of Central Missouri, Warrensburg, MO

IBM Certified Specialist DB2 UDB, IBM, Austin, TX

Contact this candidate