Summary

Microsoft Certified SQL Server Database Administrator having Six years of working experience in SQL Server 2014, 2012, 2008 R2, 2008, 2005 , which includes Installation, Configurations and Administration Standalone/HA Solutions Replications, Log Shipping, Mirroring, Clustering , Data Modeling, Backup/Recovery, Designing DR Solutions, SSIS, Reports development and management in SQL Server Reporting Services SSRS , Monitoring and Managing Database Health, Performance Tuning, Partitioning, Transaction Management, Index, stored procedures, triggers, functions, constraints, DBCC, used third party tools for Database Administration/Data Modeling. Working experience entails strong working experience on using database third party tools Idera, Spotlight, Foglight, Red Gate, Erwin, Toad Data Modeler and Visio and managing large databases in 24/7 environment.

Working experience includes installation, configurations, and Administering Operating Systems Windows Server 2012, 2008 R2, 2008 and 2003 R2 , AD Active Directory .

Experienced on Managing Database Servers in Test, Dev and Production Environment

Career Summary:

• Experience in Physical and Logical data modeling using E-R Diagram, Erwin, Toad Modeler and VISIO.
• Data Modeling:
• Installed Configured Operating System - Windows Server 2012, 2008R2, 2008 and 2003R2.
• Installed Configured SQL Server 2014, 2012, 2008R2, 2008 and 2005 in Development, Test and Production environment.
• Installation:
• Hands on Experience in Data Normalization.

Database Administration:

• Windows Operating Systems 2012, 2008R2, 2008 and 2003R2 : Installation, Configuration, User and Security Management
• Deployed databases to different environments in development, test and production environment
• Database Migration: Migrated Oracle 10gR2, 11gR2 and MySQL 4.0.3, 5.0.15 database and DB2 to SQL Server 2008 R2, 2012 and 2014.
• Upgraded databases from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 R2 to SQL Server 2012 and SQL Server 2012 to SQL Server 2014.
• Strong Database Administration experience with MS SQL Server 2014, 2012, 2008 R2, 2008 and 2005. MS Access 2010, 2007 and 2003 including Scripting and Job Automation.
• Strong working experience and knowledge with SQL Server Database High availability using Standby, Replication, Database Mirroring, Clustering, Log shipping includes Installation, Configuration, Administration.
• Database Monitoring, Performance Tuning, Query Optimization.
• Backup/Recovery, Security Management.
• Having working experience in a fast paced environment as a Database Administrator for VLDBs in SQL Server 2012, 2008R2, 2008 and 2005 running on Windows Server 2012, 2008R2, 2003 R2 .
• Storage Management: SAN and RAID.
• Experienced in Batch processes, SSIS, DTS, BCP Bulk copy , Bulk Insert, Import, Export, Database Monitoring tools and Application support
• Reporting tools - BI Business Intelligence : SSRS SQL Server Reporting Services includes installation, configuration, administration and Report Development and Management
• Have experience on other tools like SharePoint, VPN, AD Active Directory , Portals, Bulletin Board, Visio.

High Availability Solutions:

• Log Shipping Configure Monitor Log shipping in 2012, 2008R2, 2008 and 2005. Experienced on Planned Unplanned Failover.
• Worked on High Availability solutions Clustering Active-Active/Active-Passive , Replication, Database Mirroring, Log Shipping. Evicting dropping nodes and adding node s in cluster 2008, 2008R2 and 2012 disk management, Applying SP.
• 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.
• Performance Tuning:
• Experienced in Performance Tuning and Trouble Shooting using native tools like PerfMon, Resource Monitor, Activity Monitor, Event Viewer, Profiler, Execution plan, DTA Database Engine Tuning Advisor , DBCC, Stored Procedures, Triggers, DMV's and DMF's, Database Mail Setup, Jobs, and Alerts for troubleshoot performance problems, fine-tuning of databases, Managing long running queries, and index analysis.

Professional Experiences:

Confidential

SQL DBA/Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2014, 2012, 2008 R2 and 2008 in development, test and production environment
• Installed and Configured SQL Server 2014 for testing different features and stability
• Database Upgrade:
• SQL Server 2008 to SQL Server 2008 R2
• SQL Server 2008 R2 to SQL Server 2012 and SQL Server 2012 to SQL Server 2014
• Database Migration:
• Database Migration from MS SQL 2008 to MS SQL 2008R2, MS SQL 2008R2 to MS SQL 2012
• And SQL Server 2012 to SQL Server 2014
• MS Access 2010 and 2007 databases into MS SQL Server 2008, 2008R2 and 2012, DB2 databases to SQL Server 2008 R2 and 2012, My-SQL 5.1/5.5 databases to SQL Server 2008 R2 and 2012
• Data Modeling:
• Strong working experience on Conceptual, Logical and Physical Data Modeling
• Working experience on multiple data modeling projects
• Generate scripts for objects, Developed Relationship, and Created E-R Diagram.
• Backward Forward Engineering for Logical and Physical Data Modeling using Tools - Toad Data Modeler, and Visio.
• Created and managed Object, Schema, Indexes and Constraints.
• Patch Management:
• Applied SP Service Pack on SQL Server 2008, 2008 R2 and 2012
• Database High Availability:
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008 R2 and 2012
• Configured Log Shipping as Standby database for Reporting purposes
• Configured and Maintained Clustering using SQL Server 2008 R2 and 2012
• Configured and Maintained Replications.
• Configured, deployed and control MS SQL 2012 at VMware environment.
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Experienced with Point-in-Time Recovery and Restored Database from backup
• DBCC:
• Used DBCC to check database conditions, fix database corruption, rebuild/reorganized indexes and other database Maintenance purposes as well
• Database Programming:
• Writing T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• Database Monitoring/Performance Tuning:
• Strong knowledge on database Monitoring and Performance tuning.
• Schedule jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc.
• 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 MSSQL Server.
• SSIS:
• SSIS Package create, deploy and manage, Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server.
• 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 and 2.0
• Deployed Reports and managed security of report server including folder level

Work Environment: SQL Server 2014, 2012, 2008 R2, 2005. Windows Server 2012, 2008 R2 and 2003 R2, IIS 8.0, 7.5, 6.5 .ASP, ASP.net, AD Active Directory , SharePoint

Confidential

SQL DBA/Database Administrator

Responsibilities:

• Main Duties:
• Installed, Configured, and Managed SQL Server 2008R2,2008 and 2005 in development, test, and production environment
• Installed and Configured SQL Server 2008 R2 for testing different features and stability
• Database Upgraded Development, Test and Production environment :
• SQL Server 2005 to 2008.
• SQL Server 2008 to SQL Server 2008R2.
• Database Migrated Development, Test and Production environment
• MS Access 2003 and 2007 databases into MS SQL Server 2008 and 2008R2.
• Oracle 10g databases to SQL Server 2008 and 2008R2.
• My-SQL 4.1 databases to SQL Server 2008 and 2008R2.
• Data Modeling:
• Created and managed Index, Constraints, Keys PK, FK
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Data Modeling tools used using Erwin, Quest Data Modeler, SQL Server Data Diagram
• Database High Availability:
• Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2008 R2/2008/2005
• Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008 and2008R2.
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications Transactional
• Backup/Recovery:
• Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services SSRS
• Developed Reports using SSRS.
• Deployed Reports.
• Developed Ad-hoc Reports using Report Builder 2.0.
• Managed Security of Reports and Report Server.
• Patch Management:
• Applied SP Service Pack on SQL Server 2008, 2008R2.
• Applied HOT Fixes on SQL Server 2008 and 2008R2.
• Applied Patch on Windows Server 2003R2, 2008 and 2008R2 Enterprise Edition
• Database Monitoring/Performance Tuning:
• Strong working experience on database Monitoring and Performance tuning
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
• Monitor SQL Server Error Log, space usage
• Database Programming:
• Writing 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
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance

Work Environment: Windows Server 2008 R2, 2008 and 2003R2 IIS 7.5, 7.0 and 6.5 , SQL Server 2008R2, 2008 and 2005. ASP, PHP, AD Active Directory , Internal Registration System, Reporting System