Summary

• Over eight 8 years of experience as a SQL Server DBA Overall 12 years in IT with detail oriented, analytical and troubleshooting experience in different aspect of SQL Server including installation and configurations of SQL Server, Database High Availability Solutions, SQL Server Reporting Services SSRS , data modeling, DR Disaster Recovery Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, indexes, statistics etc.
• Solid working experience in managing large databases in 24/7 data processing environment including, developing and managing reports using SQL Reporting Services SSRS , and Monitoring. Working experience entails strong knowledge on using database third party tools SpotLite, Foglite, RedGate, Aqua Data Studio, ERWin Data Modeler, Toad Data Modeler, Microsoft Visio for Database Administration, Data Modeling, and Performance Tuning using different Tools like Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, and Activity Monitor.
• Experience of full System Development Life Cycle SDLC including system study, system analysis evaluating business process, designing, development, testing, implementation documentation of Client/Server applications.

Experience working on Test, Dev, and Production Environment

General Skills:

• Ability to adapt on changing environments
• Excellent team player and quick learner
• Excellent in Technical Support
• Excellent in working non-technical or Business Analyst

Career Summary:

• Having working experience in a fast paced environment as a Database Administrator for VLDBs in SQL Server 2008R2/2008 and SQL Server 2005 over the Windows 2000/2003/2008R2
• Proficiency in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management. Configured Service Broker and Table partitioning
• Implemented the new SQL Server 2005 / 2008 concepts like Data partitioning ,Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA, SQLCMD, dedicated admin connection, MERGE statement
• Worked on High Availability atmosphere Active-Active/Active-Passive Cluster, Transactional Replication . Mirroring, Log Shipping and Replication. Evicting dropping nodes and adding node in cluster 2005/2008. Documentation and Inventory maintenance for various SQL Servers
• Used PerfMon, profiler, DTA Database Engine Tuning Advisor and DMV's for troubleshoot performance problems, fine-tuning of databases, for finding long running queries and index analysis. Worked on 32 and 64 bit SQL Server and MSCS Configurations
• Extensively Worked on Transactional Replication, Snapshot Replication and Merge Replication
• Handled multiple SQL Instances on Cluster for Server Consolidation projects built on SAN using RAID levels.
• Worked on configuring SQL Server in Single user mode and Minimal Configuration Mode
• Data modeling experience in Physical and logical data modeling by using ERWin Data Modeler, Toad Data Modeler and Microsoft Visio
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server
• Sound knowledge stored procedures, Indexed views, User Data Link UDL , Triggers, Distributed Queries and Common Table Expressions, UDFs
• Experience in Batch processes, SSIS, DTS, BCP bulk copy , Bulk Insert, Import, Export, Backup, Database Monitoring tools and Application support
• Have experience on other tools like SharePoint, VPN, AD Active Directory , Portals, Bulleting Board, Visio
• Third party tools used RedGate, Idera, ERWin, Toad Data Modeler, SpotLite, FogLight
• Reporting tools - BI Business Intelligence ,Report builders, Crystal Reports, BRIO Query,SSRS SQL Server Reporting Services

Technical Skills:

Database Tools : SQLServer 2000/2005/2008/2008R2, MS-Access, Oracle 10g/11g

Third Party Tools : TOAD, IDERA, FOGLITE

Languages : T-SQL, Oracle PL-SQL, C , HTML, Shell, MySQL

Microsoft Tools : : MS-Office

Internet Tools : JavaScript, PHP, Dreamweaver

Operating System : Windows 9x/XP/VISTA, Windows 7, UNIX, Linux,

Version Control : IBM Clear Case

Professional Experiences:

Confidential

SQL DBA Developer

Responsibilities:

• Installed and configured SQL Server 2005,SQL server 2008, SQL server 2008R2 and SQL Server 2012 on Windows Server 2003, Windows Server 2008 and Windows Server 2008R2, applied service packs and security fixes.
• Configure and Maintain Always On HA on SQL Server 2008R2
• Responsible for a large scale of database migration from SQL server 2005 to SQL server 2008, SQL server 2008R2 and SQL Server 2012.
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
• Providing 24x7 dedicated On-Call production supports for SQL Server problem resolution and server outages.
• Involve in creating Logical Physical Database Design using ERWin .
• Responsible for configuring and maintaining transactional replication in different environments.
• Responsible for configuring and maintaining Database Mirroring Log Shipping
• Installed, configured and deployed MS SharePoint server 2010 with SQL server 2008.
• Using LiteSpeed ensuring all the databases are backed up on the regular basis and restoring databases as requested.
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and DTA.
• Using Foglight 5.6.5 to monitor all agents, Alarms ,Database, Domains, Hosts, the servers and their jobs in a single Management Console, to run and manage reports as required and as schedule
• Using Foglight Performance Analysis 7.0 to analyze workload in Instance view and Business Views
• Working with installation, configuration and creation of SSRS
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 2.0
• Deployed Reports and managed security of report server including folder level
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• SSIS Package create, deploy and manage
• Strong experience on user management, assigning permissions roles
• Working with SSIS and DTS package to import export operations in and out of the SQL Servers.
• Working with Central Management Server
• Working with Change Management using Landesk Management to manage CC Change Control and Ticketing tool Unicenter Service Desk
• Using HP 3Par Recovery Manager for SQL 4.4 to take quick backup, quick restore for databases
• Using Spectrum Monitoring tool.

Confidential

SQL Server DBA.

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2, 2008 2005 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Installed and Configured SQL Server 2012 in test and development environment

Backup/Recovery:

• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup

Database High Availability:

• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications

DBCC:

• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well

Report Development:

• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 2.0
• Deployed Reports and managed security of report server including folder level

SSIS:

• SSIS Package create, deploy and manage
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server

Database Upgrade:

• SQL Server 2005/2008/2008 R2
• SQL Server 2005 to SQL Server 2008/2008 R2

Database Migration:

• MS Access 2003/2000 databases into MS SQL Server 2005, and 2008
• Oracle 10gR2/11gR2 databases to SQL Server 2008 R2
• My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2

Data Modeling:

• Strong Theoretical and Practical work experience on Conceptual, Logical, and Physical Data Model
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and Created E-R Diagram
• Backward Forward Engineering for Logical and Physical Data Model respectively
• Implement Normalization up to 3NF.
• Tools used: ERWin Data Modeler, Toad Data Modeler, Microsoft Visio
• Created and managed Object, Schema, Indexes, Constraints

Patch Management:

• Applied SP Service Pack on SQL Server 2005, 2008, 2008 R2
• Applied Patch on Windows Server 2008, 2008 R2

Database Monitoring/Performance Tuning:

• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc.

Database Programming:

• T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures

DTS/SSIS:

• Export Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
• Export Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache Tomcat 5.5, SQL Server 2008 R2, 2005, ASP, ASP.NET, PHP, AD Active Directory

Confidential

Sr. SQL DBA:

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008 in development, test, and production environment
• Installed and Configured SQL Server Reporting Services SSRS
• Developed and Managed Report in SSRS SQL Server Reporting Services
• Created and Managed Securities for Reports
• Maintained VLDBs
• Configured and Maintained Database Replications
• Configured and Managed Log Shipping including Standby database for reporting purposes
• Managed Backup/Restore, Point-in-Time Recovery including backup verification
• Managed Server, Database Roles and Security for different users and user groups
• Upgraded databases from SQL Server 2005 to SQL Server 2008/2008 R2in Test and Production Environment
• Upgraded MS Access 2003 databases into MS SQL Server and 2008
• Applied SP Service Pack on SQL Server 2005, and 2008
• Applied Patch SP2 on Windows Server 2003 Enterprise Edition
• Expertise in database Performance tuning
• T-SQL, Stored-Procedures, Triggers
• Created and managed Index, Constraints, Keys PK, FK
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environment
• Processed data dump and Exported Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Monitored Server Activity, Error Log, space usage, and solving problem as needed

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 6.5, SQL Server 2008 R2, 2005, ASP, PHP, AD Active Directory , Internal Registration System, Reporting System and third party applications Timesheet, Payroll, HR

Confidential

Oracle Developer

Roles and Responsibilities:

• To look after the Technical/Management aspects of the site.
• Management of NSRC Network, System and Databases and WAN connectivity with NADRA HQ.
• Database Backup, Security and Disaster Recovery Planning, data transferring to data warehouse.
• Implementation of RAID1 / RAID5 for data recovery. Managing network security by
• LAN. Scripting Batch Files .
• managing groups and user. Installing and configuring new hardware / software on active
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• User Creation and Rights Administration by using Active Directory.
• On the spot Query Generation for any critical data requirement.
• Reading log files for error handling.
• Query Optimization for fast and Prompt data enquiry.