Jawid Hussaini

Managed performance and reliability for critical servers and databases, tuned queries, identified bottlenecks and expensive operations

Designed, implemented, and maintained mission-critical database systems, ensuring optimal performance and reliability.

Created custom tools for monitoring and managing SQL Server.

Developed monitoring and alerting systems to proactively identify performance issues and mitigate potential risks.

Collaborated with software development teams to optimize database schemas and queries,improving application performance and user experience.

collaborated with other IT professionals, such as software developers, system administrators, and network engineers, to ensure that database systems meet the requirements of applications and infrastructure.

Configured SQL Server feature Always on High Availability Group for disaster recovery and high availability.

Installed, configured SQL Server and troubleshooted to solve issues.

Recommended modernization and standardization for better database performance.

Developed monitoring and alerting systems to proactively identify performance issues and mitigate potential risks.

Collaborated with cross-functional teams to integrate databases with applications and infrastructure, ensuring seamless operation and data consistency.

Automated SQL Server installations, configuration through Powershell.

Managed and monitored PostgresSQL and SQL Server in RDS AWS.

Migrated BI databases from on premises to snowflake used Fivetran.

Designed dashboard for report through Xtraction in Ivanti for vendors, used data model tool for designing and extracting data report in Xtraction.

Created and managed EC2 instances in AWS,configured elastic load balancer for distributing traffic.

Managed and monitored servers and databases backups through Rubrik.

Configured SQL Server replication remotely and locally for large databases.

Established monitoring, alerting, performance tuning and diagnosing issues for production databases.

Designed and build databases for production and developed environment used SQL (SQL Query Language).

monitored database performance, troubleshooted issues, and performed regular maintenance tasks such as database backups, software upgrades, and patch installations to keep the database systems running smoothly.

created data models that represent the relationships between different data elements and entities within the database, ensuring data integrity and consistency.

Implemented security measures to protect sensitive data from unauthorized access, ensuring compliance with data protection regulations and industry standards, used Transparent Data encryption and column security.

developed and implemented backup and recovery strategies to ensure data availability and integrity in case of system failures, disasters, or human errors.

Migrated databases from sql server to Azure SQL database used DMS

Configured always on high availability group for disaster recovery and load balancer.

Partitioned large tables for better performance and maintenance tasks.

UsedSQL Server Profiler, Extended Events, Management Views (DMVs) to monitor query performance.