SUMMARY

• 7 years of IT experience in SQL Server Database Administration, Design System Analysis, Testing, Development and Support of Microsoft SQL server 2012, 2008R2/2008, 2005 in PRODUCTION, DEVELOPMENT, QA and UAT Environments.
• Experience in database administration and development activities like Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Disaster Recovery, Performance tuning and Query Optimization, Data Transformation Services, Database Security and Patching SQL server.
• Extensive experience working with Microsoft SQL Servers with hands on experience in SQL Server DTS and SQL Server Integration Service (SSIS) package design, constructing, and deployment.
• Expert in Upgrading server from Microsoft SQL Server 2005 and 2008R2 to Microsoft SQL Server 2012 and Patched SQL server and Expert in handling OLTP and OLAP environment in 24x7 and on call basis.
• Expert in working with VLDB 3 TB database in production, development and Test environment and 40 TB Very large environment.
• Implemented Disaster Recovery Solutions by configuring SQL Server in Log Shipping, Mirroring and replication Environments.
• Expert skills in Performance Tuning SQL Servers for Index Fragmentation, Query Plans and Deadlocks.
• Successfully tested and implemented Log Shipping Technique used for hot backup solution for Microsoft SQL Server databases.
• Expertise in database Backup, Recovery and Disaster Recovery procedures that alert lead developers / key functional users when it finds any issues. Developed and documented disaster recovery plans and backup and recovery strategies for production environment.
• Managed MS SQL Servers in Virtual Environments using VMWARE.
• Strong ability in defining query for generating drill down reports in SSRS 2005.
• Strong proficiency in SSAS cubes development and processing including dimensions and measures design, Perspectives.
• Extensive experience in SQL Server development, stored procedures, User defined functions, Triggers, Views, Indexes, data integrity.
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands and DMVs.
• Experience working with database developers, administrators and other engineering and technical teams resolving technical issues related to the design, analysis, administration & support of database applications in development.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008R2, 2008, 2005

Databases: Microsoft SQL Server 2012, 2008, 2005, 2000

Programing Languages: T - SQL, SQL, PL/SQL, PowerShell, HTML, C#, C/C++, XML

Database / ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), DTS, Query Analyzer, SQL Profiler, TOAD

Reporting Tolls: SQL Server Reporting Services (SSRS) and Report Builder

Third Party Tools: SQL Lite speed, IDERA, VMware, TSRM, SQL Sentry, ERwin Data Modeler and SQL Compare, ITSM Ticketing System, Aldon Ticketing System, Orion

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

SQL Server DBA

Responsibilities:

• Installed SQL Server 2012/2008 on Windows 2012/2008 R2 servers, applied service packs and security fix for all servers.
• Upgraded server from MS SQL Server 2008/2008R2 to MS SQL Server 2012 and Patched SQL server.
• Working with 24x7 Production support and On-Call rotation.
• Implemented Failover clustering for Active/Active and Active/Passive SQL Server 64 bit environment
• Managed SQL Servers in 32/64 bit Clustered environments and Implemented Database Mirroring on SQL Server 2012/2008 environments.
• Used ERWIN to carry out heavy duty Logical and Physical data modeling.
• Managed all Publisher, Distributor and Subscriber database environments for the replication and implemented different types of Replication like Snapshot and Transactional.
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Created SSIS packages to Extract and Load data from diverse source (flat file, excel, XML and Oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load. Created extensive reports using SSRS (Tabular, Matrix)
• Installed, configured and maintained MS SQL Fail over clustering and configure SQL Server 2012 Always On High Availability to provide server high availability solution for different environments.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Responsible for upgrades of SQL server 2005 Service Pack, SQL Safe Backup tools and SQL Diagnostic Manager.
• Experienced with creating logical and physical database design for development projects.
• Experienced with improving SQL Server using windows performance monitor to improve the server performance.
• Worked with developers to do the database schema changes and database restore request.
• Involved in restore operations to refresh the data from production to test servers.
• Experienced in troubleshooting production servers and fixed the user and application issues.

Environment: Microsoft SQL Server 2012/2008, SSIS, SSRS, Replication, Migration, OLAP, OLTP, ITSM Ticketing System, Double-Take Recover Now 5.3, Erwin 7.1 & Microsoft Visio 2003.

Confidential, Richmond, VA

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2012 Enterprise and standard edition in the production/Development and test environment and applied latest service packs and security fix servers.
• Expert in daily development to Test and Weekly Test to Production deployment using MS-Visual Source Safe and SQL compare 8.0.
• Automated daily, weekly and monthly maintenance tasks such as backups, refresh databases and verifying database integrity and rebuild indexing.
• Implemented SQL Server 2012 Always On High Availability in Windows server bit environment.
• Identifying blocking issues with automated SQL agent job.
• Implemented and monitoring Transactional replication in Test and production environment
• Implemented automation for daily database refresh job in Production, development and Test environment.
• Expert in performing multiple SSIS packages migration.
• Worked with Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring and SQL server native tool PerfMon. Counters and performance tuning.
• Expert in database sizing and capacity planning for production servers.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.

Environment: Microsoft SQL Server 2012, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System, MS Visual Source Safe, SQL Lite speed console

Confidential, Bradenton, FL

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 Enterprise and standard edition in the production environment. And applied service packs and security fix for all servers.
• Successfully migrated from SQL Server /2008R2 on Developing/Testing/ production Environment.
• Monitoring 1600 Production server using CMS, working with offshore and onshore SQL DBA team.
• Expert in Recover database from Suspect/Emergency mode using DBCC command, repair/rebuild user database and rebuild master using command prompt.
• Troubleshoot SQL server performance issue using DMS’s in Production Environment.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• Expert in implementing database mirroring between Primary server and Mirror Server as a DR policy.
• Expert in implementing and monitored transactional replication.
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands.
• Configured and maintained Log shipping architecture to provide backup server solution for environments.
• Reduced the dead locks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.
• Troubleshoot and Resolved issued problems with the production server via the Aldon ticketing system
• Expert in automating SQL server using SQL server Severity in Prod., Development. Also automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and rebuild indexing.
• Provided dedicated supports for SQL Server production server 24x7 shifts.
• Created the backup and restore strategy for 2.2 TB in production and development environment.
• Expert in creating the standard documents for Disaster recovery testing and implemented them.

Environment: MS SQL Server 2008 R2/2008/2005, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Aldon Ticketing System, Orion

Confidential, Madison, WI

SQL Server Database Admin

Responsibilities:

• Maintaining more SQL Servers as production and other environments.
• Providing Primary On-Call Support as a production DBA on rotation basis.
• Installing and configuring SQL Server 2008 on production as standalone and cluster servers.
• Apply service packs and hot fixes on production servers.
• Trouble shoots the long running jobs on production.
• Changed generic service accounts to specific service accounts on prod and non-prod servers.
• Configure Database Mail and Maintenance scripts on all environments.
• Trouble shoots replication issues on production.
• Migrating database from SQL and SQL .
• Refresh databases from Prod to other environments.
• Configure and Support Always- On, Mirroring, Replication, Log shipping and Clustering
• Rebuilt SQL Server 2008 and SQL Server 2005 servers
• Worked on year end Disaster recovery test and built DR database servers.
• Write TSQL and SQL scripts, SSIS and developing SQL Server Reports on SSRS
• Tuning the SQL Server and Databases on production.

Environment: Windows server 2008/2008R2, SQL Server 2008, TSQL, SSRS

Confidential, New York City, NY

SQL Server Database Administrator / Developer

Responsibilities:

• Involved in upgrading the instance of SQL Server 2000 to SQL Server 2005 in testing and production environment.
• Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and addressing database related issues.
• Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery. Implemented New Objects according to the Business requirements. Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine tune Indexes on Tables.
• Fine Tuning of Stored Procedures and SQL Queries. Worked with Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Developed various reports to validate the data between source and the target systems. Involved in providing security to the reports by restricting various users through Roles.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Configured Log shipping from one production server to the reporting server. Implemented built in log shipping with SQL Server 2000 for disaster recovery server. Creating the Packages for running the jobs automatically good in Implementing SQL Server security and process control.
• Creating users and assigning permissions in the DEV box.
• Creating back up strategies and scheduling them for execution.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance tuning for source databases.
• Knowledge of VPN networks and used VPN extensively to connect to Citibank Networks from home.

Environment: Microsoft SQL Server 2005/2000, DB2, Windows 2003 Enterprise server, Windows 2000 Advanced Server, Visual Source Safe 6.0, Crystal Reports.

Confidential, Bethesda MD

MS SQL Server DBA / Developer

Responsibilities:

• Data Import/Export through DTS. Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery. Creating users, Roles and granting privileges. Creating database, tables, indexes, and rules. Developed stored procedures, triggers, and views for managing efficient data retrieval.
• Written T-SQL statements using DML and DDL for retrieval of the data. Configured data mapping between different Databases.
• Query optimization using SQL Profiler and performance monitors to enhance the performance of database servers. Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Experience in writing and debugging Stored Procedures and triggers. Designed, Developed and managed the reports using Reporting Services. Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Created Replication models Snapshot and Transactional. Created and scheduled various SQL Jobs using SQL Server Agent to perform various Administrative skills.

Environment: Microsoft SQL Server 2005, Windows 2003Server, SQL Diagrams, Erwin, and SQL Lite Speed Backup Software