Malik Anwar

Accomplished Power BI and Database Management Professional with 12 years of experience in data visualization, reporting, and database optimization across diverse industries, including finance, healthcare, and retail. Proven expertise in designing and deploying scalable Power BI dashboards and data models, alongside extensive hands-on experience in database management (SQL, PostgreSQL, and Oracle). Skilled in developing ETL processes, optimizing data pipelines, and ensuring data integrity for business intelligence applications. Demonstrated success in implementing performance tuning strategies for databases, automating reporting workflows, and integrating data-driven insights to support business decision-making.

• Assist in the installation, configuration, and setup of SQL Server or other relational databases.
• Support database setup and configuration in development, testing, and production environments.
• Monitor database performance and ensure that systems are performing optimally.
• Identify slow queries and work to optimize them for faster data retrieval and performance.
• Assist in scheduling and executing database backups and performing recovery procedures when necessary.
• Ensure that backup procedures follow best practices and compliance requirements.
• Help implement database security measures to ensure data integrity and prevent unauthorized access.
• Assist in managing user roles, permissions, and encryption settings.
• Perform regular maintenance tasks such as database reorganization, rebuilding indexes, and updating statistics.
• Assist in cleaning up old data to optimize database size and performance.
• Write and optimize SQL queries for retrieving and manipulating data in relational databases.
• Create stored procedures, views, and functions to streamline data access and operations.
• Provide basic troubleshooting support for database-related issues.
• Collaborate with senior DBAs or other teams to resolve database issues in a timely manner.
• Assist in migrating data between systems and ensuring that data is properly integrated and mapped.
• Support in database upgrades and version migrations, ensuring data consistency during the process.
• Maintain documentation related to database configurations, procedures, and system performance.
• Assist in preparing reports on database performance and incidents.
• Collaborate with developers, IT teams, and other stakeholders to support database requirements.
• Continuously learn and stay updated with new database technologies, tools, and best practices.