SQL Server Administrator / Developer
Oracas (Pvt) Ltd
Total years of experience :18 years, 10 Months
• Designing and implementing Reporting Solutions.
• Design & Deploy SSIS Packages
• Designing and implementing Business Intelligence dashboards
• Designing and implementing ETL Solutions
• Building Analysis Services Multidimensional Databases
• Manage, maintain and troubleshoot analysis Service Database
• Installing, configuring, administering, upgrading and troubleshooting SQL Server versions through 2005-2014.
• Using SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources such as Excel, CSV & Oracle.
• Supporting end users as well as developers.
• Applying patches, service packs, upgrades, etc and automation of DBA tasks.
• Suggesting hardware & software requirements for implementation of SQL Server to achieve optimum performance.
• Design the migration strategy, test plans and scripts to verify data and migrated databases.
• Ensuring High Availability in mission critical environment.
• Backing up and restoring of Databases through automation scripts.
• Designing and implementing Disaster Recovery solutions and carryout best practices as suggested by Microsoft.
• Security Hardening of SQL Server as well as Windows Server.
• Design, develop & implement SQL Server Tables, Views, Functions & Stored Procedures.
• Designing data models
• Deployment of custom source code and version controlling.
• Working with Microsoft support and resolution of problems.
• Designed and create forms with form validation and exception handling for both server and client side processes.
• Created Database Powered applications for private use in C# using Visual Studio 2012.
• Experience in data migration from and to MS SQL Server.
• Creating Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Reporting using Visual Studio as well as third party tools such as Crystal Reports & Telerik RAD Controls.
• Planning, designing and implementing application database code objects, such as stored procedures, triggers, cursors, tables, views, joins and statements for applications.
• Implementing performance tuning by implementing suitable optimizations and appropriate indexes and keys.
• Using System monitor, event log viewer, SQL profiler, SQL analyzer to monitor and tune the performance of SQL server.
• Developing various complex reports in SSRS 2005-2008, Standard Tabular type reports, including Drill Down and Drill through Functionality and Graphical presentations such as Charts and Dashboard type metrics for effective analysis.
• Scheduling jobs, created alerts, notifications with SQL agent and configuring Linked servers for data access between new and old servers.
• Providing on-call support for production systems with rotation basis.
• Assist in multitude of Database development activities such as creating databases, writing queries, troubleshooting performance issues, etc.
• Assist in development of front end data driven applications
• Provide first level support to customers facing issues in their database driven applications.
• Also assist in administration, performance tuning & patching of databases.
2 Years MCS after BSc