TECHNICAL SUMMARY:

• About 7 years of IT experience in installing, upgrading, configuring, administering, monitoring, troubleshooting and securing production, test, development, replication and cluster servers for MS SQL Server 2005/2008/2008R2/2012.
• 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 etc.
• Strong knowledge of all Windows 8/ 7/ Vista/ Xp and Windows Server platform 2012/2008 R2/2003 including familiarity with virtualization techniques like VMware, Microsoft Virtual PC 2007-2012, Hyper-V, Oracle Virtual Box Operating System
• Knowledge of development software like Microsoft Visual Studio 2012/2010/2008, Java, MS Visio for database design and modelling, Adobe Dreamweaver, Flash, Photoshop, SAS Data Mining.
• Knowledge of SSIS, SSRS, SSAS, TSQL, Powershell, MS Access, MS Office Suite, MySQL, Oracle, MangoDB, Hadoop, SharePoint 2013/ 2010/ 2007, Microsoft IIS 6.0/7.0, DNS server, DHCP server, WINS, Java Scripts, HTML, XML.
• Experience in database backup/restore, data import/export, Point-in-Time recovery, High Availability and Disaster Recovery procedures and applying service packs and hot fixes to all SQL servers..
• Knowledge of handling database migration in MS SQL Server 2005/2008/2008R2/2012.
• Expertise in Capacity planning and Storage management, implementing MS SQL server security and database permissions like SQL Logins, Roles and Authentication Modes as a part of security policies.
• Experience with Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Experience in writing TSQL queries and hands on experience with performance tuning, stored procedures, query optimization, fine tuning, managing indexes and tables.
• Good exposer on creating and deploying SSIS packages, SSAS deploying cube, calculator and KPI along with experience in generating reports using SSRS, Crystal Reports.
• Ensuring data consistency in the database through DBCC commands.
• Worked on different types of Replication models like Snapshot and Transactional.
• Knowledge of 2 nodes active passive and active active clustering in SQL Server 2005/2008/2012.
• Expertise in administering large and complex databases, AlwaysOn availability Groups, Failover clustering, Log shipping, Database Mirroring and Security Management.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Experience with tools like NT Performance monitor/System monitor, SQL Profiler, SQL Query Analyzer, third party tools Red Gate, Lite Speed Backup Tools , Idera Diagnostic Compliance Manager , Hobbit, Test Director
• Experience in recommending and executing modifications to server environment in order to improve efficiency, reliability, and performance.
• Conducted research on server hardware, software, and protocols in support of procurement and development efforts.
• Designed and implemented training materials and server documentation.

TECHNICAL SKILLS:

PROFESSIONAL SUMMARY:

Confidential

Senior SQL Database Administrator

Responsibilities:

• Responsible for managing dedicated databases and servers
• Installed and Configured SQL Server 2000, 2005, 2008 and 2012 in development, test and production environment
• Installed and Configured Operating System Windows Server 2000, 2003 and 2008
• Migrated databases from Oracle 10g, MySQL 4.0.3, 5.0.15 to SQL Server 2008
• Upgraded earlier versions of SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2012
• Migrated MS Access 2003/2000/97 databases into MS SQL Server 2005/2008/2012
• Closely work with business analyst to deploy databases and manage availability
• Rebuild Servers Restore Recover from backups
• Configured and Managed Log Shipping from Production to Standby Server Running as Reporting Server
• Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering
• Wrote SQL, T-SQL, Triggers and Stored-Procedures
• Worked with developers to tune-up performance of SQL and T-SQL query
• Performance tuning optimization of servers in production, test environment
• Created and managed database security, data encryption, and applied object level security
• Developed and applied Backup strategy at my current workplace
• Setup and configured Database mail for notification purposes
• Developed Database Maintenance Plan for different important tasks
• Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
• Used DMV Dynamic Management View for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs
• Exported Imported database objects from/To Oracle, MySQL, Access Database, flat files text, excel, and CSV files and MS SQL Server
• Extensive experience in using SSIS/DTS, BCP to import export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases
• Worked on more than 10 Data Modeling projects includes interviewing stakeholders, gathering/analyzing requirements, developing E-R Diagram, designing Logical Physical Database using ERWin, Toad Data Modeler and Visio.

Environment: SQL Server 2008R2/2012, SQL Server 2005, Windows Server 2008 R2/2003, Dell PowerEdge T110 Servers, SQL, TSQL, SSIS, SSRS, SSAS, SQL Profiler, Red Gate, Lite Speed, MS Office 2010, Windows IIS 7.0, Visual Studio 2010, C .Net Framework 3.5 .

Confidential

SQL DBA

Responsibilities:

• Implemented High availability and Disaster Recovery solution such as Failover Clustering, Database Mirroring, Log shipping and Replication.
• Set up a Disaster Recovery Plan and Backup Strategy according to the business requirement such as data loss tolerance
• Determined the SQL server installation and tested SQL Server Management tools.
• Handled database migration from MS SQL Server 2005 to MS SQL Server 2008R2/2012.
• Created and performed routine Maintenance tasks for the Performance of SQL server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of the Database and Restored the Database from Disaster Recovery.
• Configured Replication Server and implemented Transactional Replication for the report.
• Implemented Peer to Peer Replication for higher read performance with the load balancer.
• Provided 24 X 7 dedicated support to all Production, QA Development server environments
• Used various DBCC commands like checkdb/checktable, showcontig, showstatistics, etc.. for checking database/table consistency and system performance.
• Identified the necessary steps to enhance user response performance by checking fragmentation and re-index tables for efficient application access methods along with Fine tuning of database objects and server.
• Worked with application development teams to facilitate change control along with database objects creation, maintenance and migration.
• Performed troubleshooting and resolving database related issues, working with other senior Database administrators, developers and systems engineers as needed.
• Performed regular proactive monitoring of the assigned database server environment.
• Provided excellent customer-service, with a strong commitment to quality and customer service.

Environment: SQL Server 2008 R2/2012, SQL Server 2005, SSAS, SSIS, SSRS, Windows Server 2008R2, SP Server 2010, SP Foundation 2010, SP Designer 2010, MS Office 2010, IIS 7.0, Visual Studio 2010, C .Net Framework 3.5 , PowerShell 2.0

Confidential

SQL DBA/Database administrator

Responsibilities:

• Managed complete migration from MS SQL Server 2005 to MS SQL Server 2008R2.
• Responsible to Install, Upgrade, Design, and Implementation of SQL Server 2008R2 and 2005 Enterprise database environment for multiple clients' sites.
• Implemented client's policies, technical procedures and standards for preserving the integrity and security of government data, reports and accesses
• Support for end users connected to servers in various departments with regard to connection and data access issues
• Creating, modifying and managing tables, Index, Constraints, Views, Stored Procedures, Triggers
• Monitoring Database Backup and other jobs in the maintenance plan Restoration and Point-in-Time Recovery
• Monitoring Server Activity, Error Log, space usage, and solving problem as needed
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Managed and ensured that users were given the right privileges and roles.
• Installed and verified the database software on the database server. Planned,
• prepared and scheduled software installation.
• Implemented Database Maintenance Plans, Reports and Monitoring.
• Resolved database performance issues IO saturation, disk bottleneck, network bottleneck, etc. , database capacity issues, replication, and other distributed data issues.
• Created and implemented best backup and recovery strategies Full Backup Model with 4 hours period transaction Log backup.
• Designed and implemented Disaster Recovery site using SQL Server Log Shipping.
• Implemented various Powershell and T-SQL scripts for automation.
• Involved in creation of Windows clustering active/passive nodes.
• Created Replication Snapshot and Transactional replication and replication Issues
• Capacity planning of the database system and prepared Database Documentation.
• Implemented SQL security for application users using Active Directory.
• Responsible for creating jobs in SQL Server Agent
• Integrated Database Mail with SQL Server Agent
• Worked with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS and SSIS.

Environment: Microsoft SQL Server 2008 R2 Service Pack 1, MS SQL Server 2005, SP 2007, SP Designer 2007, Active Directory, InfoPath 2007, MS Office 2007, Excel Services in Microsoft Office SharePoint Server 2007, Microsoft SNA Server, , Microsoft SSAS, Microsoft SSIS, Microsoft SSRS.

Confidential

SQL DBA

Responsibilities:

• Involved in System design, installation, upgrade, and configuration of MS SQL Server 2008R2/ 2005.
• Implemented Database Mirroring in SQL 2005/2008R2
• Implemented different types of Replication such as Snapshot and Transactional
• Configured Log shipping from Production to Disaster Recovery server.
• Implemented Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Installed and configured 2-node Cluster Configuration Active/Passive and Active/Active .
• Management of users, including creation/alteration, grant of system/Database roles and permissions on various database objects.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification, replication verification, and indexing updates.
• Implemented various automated Powershell and T-SQL scripts to monitor disk space, fragmentation, failed job steps, backup and mirroring activities, and configured various job alert for immediate notifications
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Dimensional Data Modeling, Relational Data Modeling, Star and Snowflake Schema, Fact and Dimension Tables, Conceptual, Logical and Physical Data Modeling Using Erwin 8.2 data Modeler.
• Participated in requirement gathering session with business users and sponsors understand and document the business requirements as well as the goals of the project.
• Created the DDL scripts using ERWIN data Modeler 8.2 and source to target mappings to bring the data from Source/Staging area to the warehouse.

Environment: SQL Server 2005/2008R2, .NET Framework 3.0/3.5, C , Web Forms, JavaScript, Windows Server 2008R2, SSAS, SSIS, SSRS, Powershell, Microsoft SharePoint Server 2010, Visual Studio 2005/2008, ADO.NET, CSS.

Confidential

SQL DBA

Responsibility:

• Designed Database activities including organizing Data Files and File group, Capacity Planning, Data Partitioning and Data Normalization.
• Implemented Database Mirroring and Log shipping in SQL 2005/2008R2.
• Developed, designed and documented data dictionary, tables, view, stored procedures.
• Monitoring event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Good experience in resolving blocking and Deadlock Issues by using SQL commands.
• Packages for data extraction, transfer, and loading Import/Export from various OLEDB.
• Performance Monitor, DBCC Commands and Dynamic Management Views DMVs
• Designed Security Model by creating Users, Schemas, Roles, and Permissions in SQL Server 2008/2005.
• Worked with SSIS to import, export and transform data between linked servers.

Environment: MS SQL server 2005/2008R2, Windows Server 2003, SQL, TSQL, SSIS, SSRS, SSAS, C , Virtualized Dell PowerEdge R900 server computers, Idera, Idera SQLsafe.