نبذة عني
20+ years experienced, and MS-Certified and Database Administrator, Architect Backend + BI Developer. Apart from solid experience of managing 600+ database servers (MSSQL, MySQL, MS Access, PostgreSQL and GCP Cloud datab…
20+ years experienced, and MS-Certified and Database Administrator, Architect Backend + BI Developer. Apart from solid experience of managing 600+ database servers (MSSQL, MySQL, MS Access, PostgreSQL and GCP Cloud databases), I have also worked extensively on many SQL backend reporting, data-development, business warehouse, disaster recovery mechanism, SOX & GDPR audit requirements, database migrations and backend automations. I have extensively used PowerShell, PowerBI, VBA, MS-Access, Python, MS-Excel automation, .NET C# ASP.NET development tools and many backend internal automations, financial auditing, and reporting requirements.
الخبرة
Senior Database Analyst
SQL Server Administration
Cloud Database Server Management
Database Reporting
Database Development
Database Analysis
Application Development Support
Data Warehouse Development
ASP .NET Portal Development
Database and DATA support Team Manager
Managing all data reporting and audit requirements for CEX.
Maintain 650+ Database servers in AWS and Google Cloud (MSSQL, MySQL, Google SQL/BigQuery, AWS Aurora/EC2/RDS).
Managing both team resource and projects.
Providing database architectural support to all development teams/projects.
Cloud database disaster recovery management, monitoring, and migration support.
Sales, HR, Commercial and Accounting Reporting using PowerBI, Excel, HTM, CSV, MS Access, C#, Python, PowerShell, and SQL Automation.
Senior SQL Server DBA and Application Support Lead
Overall database server responsibility for client Tempur-Pedic INC, USA & Denmark.
SQL Server Tech Lead for 24/7 Production support team.
Application and BI Support Team Lead, providing both Functional and Backend Technical support.
Developing .NET ASP.NET in-house tool development for data-reporting, data-warehouse, and backend migration projects.
IT Technical Documentation and Audit requirement expert.
Backups, Monitoring, Performance Tuning, Query Optimization, DB corruption checks, connectivity and deadlock issues.
Advisory System Analyst (Senior SQL DBA)
Member of SOX control Team, implementation audit requirements for client.
Team Lead - SQL Server Production Team.
System Analyst
SQL Server Database Management.
Taking care of all IT requirements within the company, which includes Server Maintenance, SQL DBA, Ad-hoc Reporting, and other PC related issues/guidance/maintenances.
Designed and developed both Internet and Intranet website for Blackwood, along with various other Intranet based solutions (using .NET 2.0, ASP, SQL Server 2005, SSIS, FTP).
Senior Analyst Programmer & SQL Server DBA
SQL Server 2000 and 2005 Database Administration; mainly responsible for installation, configuration and administration of SQL Servers, SSRS, SSIS, performance tuning, maintenance planning, log shipping, security, etc.
Systems analysis, designing, requirements gathering and development of business-critical applications in ASP.NET, SQL Server 2000/2005, ASP, MS Access, VBScript, JavaScript, Crystal Reports, VB 6.0, FTP scripting, DTS packages, etc.
Database and Reporting Specialist
Working on development of various inhouse applications (Excel, Access, PowerBI, Python, ASP.NET applications) for financial reporting and audit purpose.
Providing data solutions to AVANA and its associated credit unions for various financial data reporting, and other reconciliation issues, mainly for its audit purpose.
IT, MIS and Financial Accounting Reporting using PowerBI, Excel, HTML, Access, VBA, Python, PowerShell, gsutil tools and .NET application.
Provide overall database solution, which includes database administration, financial & IT audit requirements, disaster recovery, backend + BI development.
Database Architect – for various ongoing development of financial applications.