• SQL Server Enterprise (2008 R2/2012)
• In-Place and Side by Side migrations, version upgrades
• SQL Server patching & hot fix implementation.
• Compression implementation to achieve space and performance
• Strong RDBMS concepts and analytical skills
• ETL developer with strong SSIS (2008 R2/2012) Skills
• SSAS Cube and Dashboard Reports using SSRS & Power BI.
• Query optimization and server Administration, server monitoring, capacity planning and backups.
• System/User database data and log files management.
• Database performance tuning using SQL DMVs, OS stats, Profiler and SQL Tuning Advisor.
• Role Based user security implementation and Proxy accounts management
• Database objects Archival Cycle for large objects.
• Pro-Active Security Measures for SQL Injections
• Automating various workflows using SQL agent jobs with appropriate time schedules.
TFG is the largest provider in Pakistan for POS, MPOS, e-commerce acceptance and issuance solutions & managed services.