Arousa Mughal

Experienced and results-driven Database Administrator and Developer expertise in SQL Server, Azure SQL, PostgreSQL, and ETL pipelines. Proven track record in query optimization, database security, performance tuning, and disaster recovery planning. Skilled in delivering scalable, high-performing database solutions across healthcare and technology sectors. Strong analytical thinker with a collaborative mindset and a focus on reliability and efficiency.

DATABASE ADMINISTRATOR - WISEMAN INNOVATIONS

(2023-03)

• Implemented Transparent Data Encryption (TDE) across production, development, and UAT environments to ensure data protection, compliance, and prevent unauthorized access.
• Designed and managed DDL/DML triggers to enforce data integrity, automate auditing, and improve business logic enforcement within the database layer.
• Developed and enforced secure access policies and role-based access control (RBAC) for both on-premises SQL Server and Azure SQL Database environments, aligned with least privilege principles.
• Optimized complex T-SQL queries, improving overall query performance by up to 30% through execution plan analysis, indexing, and query refactoring.
• Deployed robust disaster recovery (DR) strategies using Log Shipping and Always On Availability Groups, ensuring 99.99% high availability and business continuity.
• Successfully migrated SQL Server infrastructure from version 2016 to 2022, following a structured approach with zero data loss, minimum downtime, and post-migration validation.
• Built and deployed ETL pipelines using SSIS to automate CSV-based data ingestion, enabling scalable data warehousing and business intelligence operations.
• Familiar with Docker basics and tested SQL Server container deployments for development, testing, and DevOps pipeline integration purposes.
• Configured SQL Server Maintenance Plans for automated backups, index rebuilds, database integrity checks, and statistics updates, ensuring optimal database health.
• Developed PowerShell scripts to automate tasks such as database backups, log file cleanup, restore validation, and monitoring, improving DBA team efficiency by 25%.
• Collaborated with development and BI teams to support SSRS reports, stored procedures, and data validation workflows.
• Managed and optimized SQL Server high-availability solutions, including clustering, Log Shipping, and Always on Availability Groups, to ensure reliability, disaster recovery, and performance.
• Documented and maintained SOPs for disaster recovery, data migrations, and performance tuning to support operational excellence.
• Configured role-based dynamic data masking (DDM) in SQL Server to restrict sensitive data visibility for application users at the database level.
• Migrated SQL Server managed disks to Azure Blob Storage using Private Endpoints and strict network governance, enabling zero-trust connectivity, direct restore workflows, and optimized storage tiers to enhance flexibility and reduce operational costs

DATABASE DEVELOPER & ADMINISTRATOR - MTBC/CARECLOUD

(2021-08 - 2023-02)

• Generated on-demand reports for internal departments and offshore clients, ensuring timely and accurate data delivery.
• Collaborated with cross-functional teams on database design and architecture projects, contributing to scalable and maintainable data models.
• Created and managed database objects including triggers, indexes, and constraints to enforce data integrity and enhance performance.
• Developed and maintained DML queries to support core business functions and application workflows.
• Monitored database health using Performance Dashboards and performed routine administrative tasks such as log management and resource allocation.
• Diagnosed and resolved database-related issues promptly, reducing service disruptions and improving system reliability.
• Conducted daily database maintenance including job scheduling, replication monitoring, memory tuning, and handling system alerts.
• Executed data imports and exports across systems to meet application and reporting requirements.
• Resolved data conflicts in SQL Server replication (Merge and Transactional) using Conflict Viewer, custom resolvers, and reinitialization techniques.
• Contributed to front-end development of a Business Intelligence (BI) project, focusing on data visualization.
• I work extensively with Power BI, developing and delivering front-end analytical reports on a daily basis include dashboard design, building interactive visuals, writing DAX measures, ensuring data accuracy, and optimizing performance. These reports support operational decision-making by providing timely and meaningful insights to stakeholders.
• Performed scheduled server reboots across development, UAT, and production environments as part of routine maintenance, patch updates, and performance troubleshooting, ensuring minimal downtime and service continuity.
• Diagnosed and resolved data conflicts in SQL Server replication, including Merge and Transactional Replication, using Conflict Viewer, custom resolvers, and reinitialization techniques to ensure data consistency across distributed environments.

DATABASE DEVELOPER (INTERN) - MTBC/CARECLOUD

(2019-08 - 2020-11)

• Developed and maintained complex SQL queries to support business intelligence and reporting requirements, ensuring data accuracy and consistency across multiple reporting platforms. Analyzed and optimized underperforming queries and database objects.
• Utilized tools such as SQL Server, MySQL, and ETL pipelines to extract, transform, and load data efficiently into reporting environments.
• Collaborated with cross-functional teams to deliver data-driven insights and support strategic decision-making through automated dashboards and ad hoc reporting.

ACCOUNT MANAGER (HEALTHCARE) - MTBC/CARECLOUD - Islamabad, Pakistan

(2016-12 - 2020-12)

• Accurately posted payments from ERA/EOB files, patient payments, and insurance remittances into the billing system, ensuring proper allocation to patient accounts.
• Reconciled daily deposits and payment batches to maintain accurate financial records and resolve any discrepancies in collaboration with the finance team.
• Monitored and analyzed denials, underpayments, and unapplied payments, escalating issues to appropriate departments for resolution.
• Maintained compliance with HIPAA and internal privacy standards during all billing and posting activities.
• Assisted in monthly AR reconciliations, payment audits, and reporting to support revenue cycle integrity and timely month-end closing.
• Collaborated with insurance payers and internal departments to verify payment accuracy and reduce payment posting errors.
• Contributed to process improvements by identifying recurring issues in payment posting and recommending workflow enhancements.

MCS - Computer Science - ARID AGRICULTURE UNIVERSITY (2019-07 - 2021-07)