Muhammad Awais N.

As a Database Administrator (DBA) with over 10 years of experience, I specialize in providing robust, efficient, and secure database solutions for businesses of all sizes. My expertise spans SQL Server, MySQL, PostgreSQL, and cloud platforms like Azure SQL and Azure Managed Instance. I ensure optimal performance, scalability, and data integrity while tailoring solutions to meet your specific needs. • Skilled in managing SQL Server (2008 to 2022), MySQL, PostgreSQL, and Azure SQL environments. • Performance Tuning: Optimizing server performance through configurations, indexing strategies, and resource allocation. Query optimization for stored procedures, views, and functions. • High Availability & Disaster Recovery: Expertise in implementing solutions like Always On Availability Groups, Log Shipping, Replication, and Clustering. • Database Migration & Upgrades: Hands-on experience with cross-platform migrations, including Oracle, MySQL, PostgreSQL, Access, and cloud platforms like Azure Managed Instance. • Backup & Recovery: Proficient in designing reliable backup strategies for large databases (VLDBs) exceeding 100GB and ensuring fast recovery. • ETL Development: Extensive experience in building and troubleshooting SSIS packages for data extraction, transformation, and loading. • Reporting Services: Developed and optimized reports using SSRS to support data-driven decision-making. • Skilled in T-SQL scripting for automating maintenance, monitoring, and troubleshooting tasks. • Successfully managed 100+ database instances with high availability and performance requirements. • Experienced in managing SAN storage solutions for large-scale database environments. • Proficient in Security and Compliance, including user management, auditing, CDC (Change Data Capture), and Change Tracking. • Dedicated, reliable, and adept at resolving complex issues while meeting tight deadlines. • A proactive problem-solver with a passion for tackling challenging database scenarios and delivering high-quality solutions.