Abu Khan Email & Phone Number

Bankstown, Nsw, Au

I have been working on a wide range of applications in the development, upgrade and management of the SQL servers and related applications. Core tasks have included large-scale data centre consolidation projects, management and development of databases, integrations for internal business groups, and upgrades of 720+ databases (2005 to 2008) for the organisation which has 8500 users. Technologies used: SQL Server 2005 and 2008, SSIS, SSRS, SSAS, TFS 2010 Maximise the uptime of SQL Server databases supporting the enterprise Production, Test and Dev environments through system monitoring, performance tuning, and routine maintenance tasks such as index rebuilds, file compressions, statistical updates, and database consistency checks Install upgrades, service packs, and security updates for SQL Server database environments to protect data from intrusion and maximise system stability Manage the storage environments for the SQL Server databases, including optimal sizing, monitoring space, requesting additional storage, and providing growth statistics Create and execute SQL Server backup and recovery policies, and maintain integrity and reliability of access to information Perform routine backup and recovery trials, including testing and documenting recovery scenarios Manage database users and security Work with development teams to assist in overall database design, helping developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures Import and export data to and from the SQL Server databases Create and maintain detailed operating procedures, configuration documentation, and maintenance plans for the SQL Server environment Problem escalation and resolution, working with Microsoft and other software/hardware vendors to resolve problems Participate in multi-landscape design solutions, architecture recommendations, and strategies for continuous improvement

Technologies used: SQL Server 2000 and 2005, Analysis Services 2000, DTS, TFS 2008As a Development DBA my achievement at Hudson were as follows Upgrade reporting Dashboard system from SQL 2000 to SQL 2005 Re-architect Dashboard system to accommodate new employee hierarchies Rewrite stored procedures to extract data from highly normalized Operational Data Store Redesign Analysis Services Cubes to accommodate new employee hierarchies Architect and develop Integration Services packages for ETL Staging to Production System Implement Database Change Management through MS Team Foundation Server

Technologies used: SQL Server 2000 and 2005, Analysis Services 2000 and 2005, DTS, SSIS, SSRSAs a database consultant at Roche my responsibilities can be outlined as follows Automate database backup and performance monitoring Create SQL script for database audit and health check Create analysis services cubes using SSAS 2005 and 2008 Develop SSRS reports on OLAP cubes Write MDX to query cubes and populate reports. Configure and develop data driven report subscription Implement role based security over reporting services reports and analysis services cubes Create new SSIS packages and migrate DTS to SSIS for Data Warehouse load

Technologies used: SQL Server 2000 and 2005, DTS, SSIS, SSRS, Oracle 10g, MS Source Safe 2005My major responsibilities can be outlined as follows Install and configure server software and hardware for SQL Server development and production environments.  Create and manage database maintenance plans and design and implement backup and disaster recovery plans through Log Shipping.  Upgraded number of production servers from SQL Server 2000 to SQL Server 2005 Prepare current database structure and configuration for high-performance through analysis and optimization.  Diagnose problems using tools such as SQL Profiler and System Monitor, work with vendors and developers as needed to resolve issues.  Work on data mapping and conversion; manage disk space, change control and bug fixes. Installing and upgrading Oracle in Windows 2003 Sever platform. Also Administer Oracle using Oracle Enterprise Manager  Maintaining and monitoring multiple Oracle database instances in production, development, and test environments  Participate in testing and the development of performance standards

Technologies used: SQL Server 2005, SQL Server Reporting Services 2005, SSIS, MS Source Safe 2005 Performance tuning of query and report processing Monitor database systems performance, capacity and availability Built and maintained staging server for testing new applications.  Developed reports for various clients and other departments using scripts written in T-SQL. Configure ETL packages and SQL script to implement SSIS packages in different environment Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases Developed, modified, and optimized complex stored procedures to handle complex business rules

Technologies used: SQL Server 2000/2005, SQL Reporting Service 2000/2005, DTS, SSIS, TFS 2005 Monitor daily and weekly ETL tasks Extend existent DTS package to accommodate required data feed Debug ETL transaction by examining error log Manage data warehouse databases and maintain all databases Report data warehouse load and activities Install patches and manage upgrades Backup, test and restore all data warehouse objects Administer Reporting Services reports and servers Develop and maintain ad-hoc reports

Technologies used: MS Access 2003, VBA, .Net, SQL Server 2000/2005, DTS, SSIS, Source Safe 2005 Install and configure SQL server 2000/2005 Implement business rules through stored procedures, user-defined functions and triggers. Generate daily/weekly database performance report. Perform disaster recovery operations; develop database maintenance plans, backups, recovery and restoration. Develop storage procedures for posting data into associated tables Write scripts in DTS packages for data transformation Implement and audit database security Conduct all aspects of capacity planning, performance Monitoring and tuning of databases on SQL server 2000/2005.

Technologies used: MS Access 2000, VBA. Liaison with both technical and non-technical staff to analyse user requirement and implement business rules.  Successfully identified the root cause and suggested approach to overcome the bottlenecks. Successfully transform all data from multiple sources to Access tables by keeping the corresponding relationship with data and table. Modified the database to accommodate additional information and also changed the user interface according to the requirement without changing the underlining structure. Defined new rolls for the users which insure smooth operation of data entry in secure environment.

Technologies used: MS Access 2000, VBA, SQL Server 2000 CV Management System: A complete RDBMS in multi-user environment to handle large volume of CV. The selection based search mechanism was highly appreciated by the management. Personnel Management Information System: A Client-Server database application is to manage personnel information and to enhance HR Management. Project Monitoring and Evaluation System: Business process analysis and project management capabilities have significantly improved by the introduction of the system. Booking Management System: Managing booking records of seminar hall audio-visual equipments and other resources.