• Experienced Database Administrator with over 8 years of extensive experience, specializing in the development, analysis, architecture, design, installation, configuration, operation, and maintenance of complex information systems across diverse industries.• Expert-level proficiency in DDL, DML, and comprehensive data modeling techniques, including physical and logical data modeling using UML. Proven ability to develop and optimize complex stored procedures, ensuring efficient database operations.• In-depth knowledge and hands-on experience in database indexing strategies, data normalization, and de-normalization techniques to enhance database performance and maintain data integrity. Skilled in implementing and managing data replication processes, ensuring data consistency and availability.• Highly proficient in designing and maintaining Extract, Transform, Load (ETL) processes to support seamless data integration and migration. Adept at generating detailed and actionable reports that drive business insights and decision-making.• Extensive experience in data warehousing concepts, including data mining, data marts, and online analytical processing (OLAP). Capable of designing and managing robust data warehouses that support advanced analytics and business intelligence initiatives.• Expert in Microsoft SQL Server, including advanced use of Business Intelligence Solutions such as SSIS, SSRS, and SSAS. Skilled in using SQL Server monitoring and performance tools to ensure optimal database performance and reliability.• Experienced in managing database security, including user roles and permissions, to ensure data integrity and compliance with regulatory standards. Proficient in identifying, diagnosing, and resolving complex database performance and capacity issues. • Experienced in installing, configuring, testing, and maintaining database servers and related infrastructure. Proficient in conducting performance benchmarks and health checks to ensure the optimal functioning of database systems.• Proficient in connecting, importing, shaping, and transforming data from various sources, including Snowflake, Azure, and EMR/EHR systems, using Power BI.Technical Experience:Programming Languages: Python, R, DAX, SQL, SASCloud Platforms: Microsoft AzureData Processing & Analytics: Power Query, Power Pivot, Tableau Prep, Alteryx Data Visualization Tools: Power BI, Tableau, Microsoft Excel, Google Data StudioDatabase Systems: SQL Server, MySQL, Azure SQL Database, PostgreSQL, Oracle DatabaseETL Tools: SQL Server Integration Services (SSIS)
