Professional Profile

Virtual Business Card Link

About Me Page

Experience life

Professional Career starting from Nov 2005; Major in Databases (OLAP & OLTP) using Microsoft SQL Server development, administration and reporting solutions. Aspiring for a challenging and responsible position in the field of database DBA and DWH Life cycle that would be conductive for the respective organization and my professional growth.

Technologies

·         SQL server 2000, 2005, 2008, R2, 2012, Azure (Cloud)

·         Windows Azure, Windows Cluster setup

·         Microsoft Azure Sync Tool, SSMS Cloud, SSRS Cloud Server, Azure Federation

·         Database Tuning Advisor, Performance Counters, Database Profiler

·         Business Intelligence Development Studio and Crystal reports 7,8,9, Report Builder3

·         Microsoft Visual Studio for SSIS.

·         .Net for CLR functions Writing

·         Apex SQL Difference and Scripting tools

·         Red Gate and Toad for Backup, recovery, database performance

·         Microsoft Visio 2010 and Erwin for data modeling and forward/reverse engineering

Professional Substance

Database Administrator

·         Backup and Recovery Full, differential, transactional, Hot and Cold backups, mirroring server backup, point in time recovery, database mirroring, snapshot, partial and tail-log backup.

·         Monitoring database performance, disk space, monitoring logs, event viewer, capacity planning, Data archiving, job schedules

·         DMVs, PowerShell scripts, Dedicated admin connection setting, using execution plan, tuning advisor, data auditing

·         Data and user security Management

·         Reports server installation Management, reports deployment, Snapshot reporting, report subscription, parameterize reports setting.

Database Developer & Report Engineer

·         Performance Tuning, Query optimization, SQL & Transact-SQL, clustered views, filtered and column store indexes.

·         Database analysis and design and constraints, Data protection, triggers, encryption and decryption, SQL Injection preventions.

·         Database policies, distributed transactions, link server, deadlock detection, expensive queries, and Query time outs.

·         Microsoft Access 2008, SQL Server Reporting Services (SSRS), Crystal reports 9 and Oracle Reports with SQL Server and SharePoint.

·         Report designing i.e. Chart, Geography, Matrix, List, Cross tab reports, Analysis reporting using Excel and SSRS

Educational Accomplishments

·         Master in Software Engineering – MSSE (Bahria University Islamabad.)

·         Certified: MCTS 2008/2005, MCITP 2005/2008, MCP 2012, MCSA 2012

Career Progression

·         Head DBA; with National Audit Office (Bahrain) from Dec-2014 to Nov-2014

·         Consultant Microsoft Practice; Databases with OVEX Technologies (En Pointe Technologies, USA) from July-2013 to Nov-2014

·         Sr. Database Administrator with CIKLUM Pakistan (Ciklum Int, Denish) from Apr-2012 to June-2013

·         Team Lead Database Administrator/Developer with ISL Intelligentsia Software (Techsol technologies, USA) from Apr-2008 to March-2012

·         Database Developer with MOBILE Technologies (Valencia Technologies, Ireland) from Feb-2007 to March-2008

·         Software Engineer with SOLACE Applications from Nov-2005 to Feb-2007

 

Competences tools

·         SQL Lite, Microsoft Access, My SQL, SQL and PL/SQL Oracle 9i

·         Microsoft Windows servers (2003,2008) and VM ware, Hyper-V

·         Oracle Developer, VB6, Oracle Reports 2000, SQL I/O & Sim

·         Presentations, trainings, team meetings, daily tasks and blog writing.

Anonymous techniques

·         SSIS packages or DTS packages, Business Intelligence/Data Warehousing Knowledge

·         SQL Server Integration Services (SSIS) used to implement Export/Transform/Load (ETL)

·         SharePoint 2010 installation and configuration with reporting services.

·         Networking knowledge, Windows Clustering, Virtualization.

Professional Achievements

·         Microsoft Certified Solution Associate 2012

o    Administering Microsoft SQL Server 2012 Databases Part 2

o    Implementing a Data Warehouse with Microsoft SQL Server 2012

·         Microsoft Certified Professional 2012

o    Querying Microsoft SQL Server 2012

o    Administering Microsoft SQL Server 2012 Databases Part 1

·         Microsoft Certified Professional Developer 2008

o    Designing and Optimizing data access

o    Designing database solutions

·         Microsoft Certified IT Professional 2005

o    Designing and Optimizing data access

o    Designing database solutions

·         Microsoft Certified Technology Specialist

o    Microsoft SQL Server 2008 – Implementation and Maintenance

o    Microsoft SQL Server 2005 – Implementation and Maintenance

Position Responsibilities

Consultant Microsoft Practice

·         Database engine optimization, Clustering, Always On availability setup, database optimization, reporting server configuration, performance counters.

Sr. SE\ Database Administrator

·         Eovendo Online future advertisement solution includes self-balancing P2P overlay network, multiple desktop, distributed databases. Database mirroring has been implemented for multiple databases. Generate reports for Denmark based client.

·         Eovendo Azure Enterprise Online advertisement solution with advance techniques as Windows and SQL Azure, SQL & SSRS 2012. Database advance technologies as Sharding, Federation, (Table based storage NO-SQL), Worker Queues, database migration and synchronization tools.

Team Lead DBA

·         G3 Grubb & Ellis is a property research system. Design db that gather information through SSIS from text, Access, excel sources and generate OLAP reporting for Clients in US.

·         Wedgewood/Fortress An automated bidding and document collection system for properties bidding. Alters and Scrapper update bidding information. Generate SSRS reports for property cost evaluation for Wedgwood Inc.

·         Concern World Wide: Resources distribution and utilization aging management system. Utilization and Ageing reports in SSIS.

·         BizNav Involved in Analysis, designing, support of Dynamic Application logic designer where user can design its own application and its workflow management. Extensive XML and Dynamic Query based application.

Database Developer

·         NRCIA Property research, sale, purchase, roof inspection, mortgage, Analysis reporting on current and history data in SSRS and Crystal.

·         Powerbar, PowerbarCMS Complete social network solution for athletes with blogs, groups, photos, videos and articles designed for Nestle.

·         FSN Weather Forecast Management portal for News Agency in Share point portal and SSRS Reporting.

·         Collector Choice, ACI Assurance collection portal for bank default debtors and their court information with interest detail.

·         Flavordot/Geoffiti Online product sale management system, product display on basis of algorithm designed in procedures.

·         Right Side Pharmacy drugs control and surgery correction management system. Involves physical scanning devices and important reports.

Software Engineer

·         iTrack Card Inventory management system from purchase to retail sale.

Certification Verification

Transcript ID (1025208) with Access Code (1q2w3e4r). You can verify using this link https://mcp.microsoft.com/authenticate/validatemcp.aspx

Linked In Profile: 

http://pk.linkedin.com/in/shamassaeed

Contact Me: 

Email: shamassaeedmr@gmail.com