With over 10 years industrial experience in database design of business & web-based applications.
His experience includes:
- Perform day to day Database Maintenance tasks – Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
- Development of complex business intelligence reports with dashboards, drill-down, lookup and aggregation capabilities.
- Monitoring performance and managing parameters to provide fast query responses to front-end users.
Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
- Running queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
- Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
- Manage security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas.
- Checking Database Health by using DBCC Commands and DMVS.
- Communicates effectively and collaboratively with other workers and data entry vendors.
- Experience in developing reports using SQL Server 2008 Reporting Services and Seagate crystal reports.
- Experienced in analyzing, designing and implementation of different ERP modules.
Technical Skills
SQL Server, SSRS, SSIS, Oracle 10G, .Net, VB 6.0, Seagate Crystal Reports, MS-Office, MS Visio
