SUMMARY:

• Having 7 years' experience in Database Administration, System Analysis and administration, Design, Development Support of MS SQL Servers 2014, 2012, 2008r2, 2008, 2005, 2000 in Production, Development Replication Environments.
• Worked as a team member to provide 24x7 on-call production database support.
• Experience in installation and configuration of MS SQL Server 2014, 2012, 2008r2/2008/2005/2000 versions and administering 100 servers with zero downtime and has supported with 3TB size databases in total.
• Expert in Data Extraction, Transforming and Loading ETL using various tools such as SQL Server Integration Services SSIS , Log Shipping, DTS, Bulk Insert and BCP.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 side by side , as well as DTS exchange tool for migrating DTS packages to SSIS packages.
• Developed SSIS packages, developed SSRS reports for DBA purpose.
• Expertise in DATA CENTRE Migration across the globe, or any geographical location within USA.
• Extensive experience in implementing the Data ware house application design of database.
• Expertise in planning and implementing MS SQL server security and database permissions
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Developed logical and physical data models using ERWIN for database schema and objects.
• Experience in writing and debugging Stored procedures, triggers and Functions
• Experience in trouble shooting database issues
• Experience in implementing different types of Replication models like Snapshot, Merge and transactional
• Transformed data from one server to other servers using tools like Bulk Copy Program BCP and Data Transformation Services DTS , SSIS SQL Server Integration Services and log shipping.
• Experience in Installing, Configuring and maintaining SQL Server Active/Active and Active/Passive clusters.
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2005, SQL Server 2008r2, SQL Server 2008R2 and 2012 in OLTP Environments.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries
• Expertise with Table Design, Index Design and Performance Tuning
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks
• Administered, maintained, developed and implemented policies and procedures for ensuring the security and Integrity of the company database.

SKILL SET:

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2014, 2012 2008R2 in enterprise clusters and Standalone environment.
• Expert in SharePoint 2013, 2010 enterprise clusters for SQL Server 2012 as well.
• Designed and Architect for both SQL Server 2012 and SharePoint 2013, 2010.
• Designed new databases architecture according to Business requirements like logical design and physical design.
• Implemented Always ON for SQL Server 2012.
• Upgraded SQL Server 2005 to SQL 2012, and SQL 2008R2 to SQL Server 2012 enterprise.
• Also upgraded SQL Server 2008r2 Active Passive cluster to SQL Server 2012.
• Actively involved in Migration of SQL Server and related applications from SQL Server.
• Deployed the SSIS Packages to the MSDB as well as File System depending on the requirements.
• Created and Migrated DTS/SSIS packages from SQL server 2000/2005 to SQL Server 2005/2008 respectively
• Implemented Database Mirroring in SQL 2012.
• Extensively worked on Capacity Planning. Maintaining both DEVELOPMENT and PRODUCTION servers in sync.
• Creating databases, designing the constraints and documenting the requirements
• Implemented best practices for SQL Server Backup Strategies, and scheduling them for execution as per the business need to meet SLA's.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Experience in Understanding structured data analysis, data models, data normalization.
• Implemented Transactional Replication between primary server read only server with separate distributor server
• Configured the Log shipping and created the Standby server.
• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance. Analyzed potential problems response delay, locking, server down time, etc to avoid and optimize
• Involved in Query optimization and overall SQL server Performance improvement
• Through experience in implementing DBCC commands and CTE
• Involved in numerous overnight implementations and upgrades.
• Monitored SQL Logs to ensure success of schedules, jobs, and backups.
• Worked on Command prompt utility like SQLCMD, ISQL, OSQL, and BCP.
• Extensively worked on Performance tuning of stored procedure.
• Involved in Monitoring Performance of different production servers

Environment: MS SQL Server 2005/2008/2012/2014, Windows 2012, windows 2008R2 SP2/ Windows 2003/2000 Advanced Servers, IIS Server 6.0, TFS, SSIS, Office Communicator, MS Office, and VB scripting.

Confidential

SQL Server DBA

Responsibilities:

• Installed and configured SQL 2012/2008 with the best practices with configuration standards.
• Upgraded from SQL Server 2005 32bit to SQL server 2008r2 64bit .
• Extensively involved in Database Mirroring in SQL 2008 r2.
• Involved in Implemented CDC Change data capture in SQL 2008r2
• Extensively Involved in Log Shipping in SQL 2005.
• Extensively involved in creating backup strategy according SLA.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Involved in semiannual Disaster Recovery Testing drills.
• Extensively worked on Capacity Planning.
• Worked in 24x7 production environment.
• Worked on IIS including installation, configuration and administration
• Identified flaws with DR strategies and offered suggestions for improvement.
• Creating and managing schema objects such as Tables, Views, Indexes, Stored Procedures and User-Defined Functions depending on the Technical Requirements Using T-SQL.
• Extensively worked on Performance tuning of stored procedure.
• Involved in Monitoring Performance of different production servers.
• Experience in Database administration activities like Installation, Configuration, and Backup Recovery.
• Used Idera Diagnostic Manager for monitoring solutions.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Connecting remote Oracle Servers and SQL Servers as Linked Servers and by using Ad-Hoc Queries.
• Good experience in resolving blocking and Dead lock Issues by using SQL commands.
• Extensive knowledge in Tuning SQL queries improving the performance of the Database.
• Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Migrated DTS Packages to SSIS Packages Using Package Migration Wizard and DTSXCHANGE.
• Extensively worked on Data extraction using the Microsoft DTS and SSIS.
• Extensive Experience in creation, Deployment and Scheduling of SSIS Package.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility. Extracting, Transforming and loading of data using SSIS and DTS.
• Monitored SQL Logs to ensure success of schedules, jobs, and backups.
• Worked on Command prompt utility like SQLCMD, ISQL, OSQL, and BCP.
• Working with the end users, gathering requirements for the system.
• Installing applications and establish the connectivity with the database.
• Experience in with tools like Microsoft Reporting Services SSRS .
• Expert in creating traditional as well as Web-based interactive reports using SSRS.
• Experience in Deploying Reports and also managing Security of Reports.

Environment: MS SQL server 2008, MS SQL Server 2005, Windows 2003 Server, Enterprise Manager, Management Studio, DTS/SSIS, SQL Profiler , Idera Diagnostic Manager, MS Reporting Services, SQL Litespeed Backup Software, DTSXchange.

Confidential

MS SQL Server DBA

Responsibilities:

• As a Production support DBA responsible for managing production, development and QA environments.
• Managed multiple instances of SQL Server in Virtual and Physical environments with 32 / 64 bit environments
• Managed Production environments and participated in on call 24/7 support
• Did heavy duty Migration / Upgrades from lower version of SQL Server to SQL Server 2008 R2
• Installed / configured SQL Server in Virtual Environments using VMWare.
• Installed SQL Server 2008 R2/2008 and SQL Server 2005 on windows 2008 and 2003 servers, applied service packs and security fix for all servers.
• Exclusive Knowledge of Database security including creation of roles/login/user accounts and having good Knowledge of authentication modes, types of roles, how to manage security accounts, grant /revoke permission to access data and how to make a security plan matching your business needs
• Implemented SQL Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit/32 bits environment and SQL Server 2005/2008
• Implemented Database Mirroring on SQL Server 2008 environments and experience in configured and maintained Log shipping on primary and secondary server with or without witness server on MS SQL 2005/2008.
• Implemented replication for database objects, Managed all Publisher, Distributor and Subscriber database environments for transactional, merge and snapshot replication
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle and also Created Data Flow's for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
• 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
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load
• Created the standard documents for Disaster recovery testing and implemented them.
• Experienced with database sizing and capacity planning for production servers.
• Created the backup schedule for production, test and development servers.
• Worked with developers to do the database schema changes and database restore requests.
• 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 : MS SQL Server 2008 R2/2008/2005/2000, SQL Server 2012, Windows Server 2008 R2/2003/2000, Virtualization, SSIS, SSRS, SSAS, DTS, T-SQL, Clustering, Mirroring, Log Shipping, Replication.

Confidential

SQL DBA

Responsibilities:

• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Responsible for Query Optimization, Performance Tuning, System Monitoring.
• Secured the SQL Server by creating User Logins with appropriate roles, dropping and locking the logins, Creation of Groups, granting the privileges to users and Groups.
• Implemented Transactional Replication model and involved in maintenance of the replication.
• Established Joins and Created Indexes to assimilate client information from multiple tables.
• Managing and Scheduling Daily Jobs relating to data transfers, Backup and Recovery, transaction log dumps.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Written Stored Procedures, Triggers, user defined Functions UDF for Application Developers.
• Monitor SQL Error Logs, Schedule tasks, database activity.
• Involved in Configuring the Log shipping to create the Standby server.
• Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Documentation of the systems Tables, Views, Stored Procedures, Jobs.

Environment: SQL Server 2000/2005, T-SQL, VB, Access, Excel, Crystal reports ,Asp, Windows 2000 Advanced Server, Unix, Oracle and Windows NT