SUMMARY

• 6+ years of Microsoft SQL Server Database Administration & Development experience in SQL Server 2008/2005/2000.
• Extensive experience in Migrating and upgrading SQL Servers from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 and SQL Server 2008R2 to SQL Server 2012.
• Experience wif SQL Server 2012/2008R2/2008/2005 DDL/DML Triggers, Database Mirroring, Migration, Upgrading.
• Experience in implementing different types of Replication models like Transactional, Snapshot and Merge in SQL Server 2005/2008 R2, 2012.
• Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2000, MS SQL Server 2005 databases and MS SQL Server 2008 R2 and SQL Server 2012 used as DR solution.
• Experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive cluster in Windows 2008 R2 Datacenter, Windows 2008 R2 Enterprise, Windows Server 2008 Datacenter, Windows 2008 Enterprise, Window 2003 Enterprise Server and Windows 2000 Advanced Server.
• Experience in using data modeling tools like SQL Diagrams, Erwin 7.1 & Microsoft Visio 2003/2007/2010.
• Extensive experience in Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Extensive knowledge in Tuning SQL queries& improving teh performance of teh Database.
• Experience in migration of Data from Excel, Flat file, Oracle to SQL using BCP, DTS and SSIS utilities.
• Experience in managing database filegroups, adding data files to a filegroup, monitoring teh data file size in temp db and other database file system management.
• Extensive experience in Capacity planning, Maintained many SQL Servers in Clustered environment (Active\Passive and Active\Active).
• Knowledge in various states of System Development Life Cycle (SDLC).
• Extensive knowledge of RAID technologies for increased storage reliability.
• Experience in using data modeling tools like CA Erwin and MS Visio.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities, Index tuning.
• Experience in SQL Server Analysis Services (SSAS), Reporting Services (SSRS) and Integration Services (SSIS) to manage data warehouse environment.
• Good understanding of RDBMS concepts and very good in writing Joins, Sub queries, Views, Stored procedures, Functions using SQL Server.
• Expertise in RDBMS S/W Installation, applying patches, Upgradation, configuring, managing, monitoring, and troubleshooting of SQL Server on Windows servers.
• Monitoring Jobs, Alerts and scheduling DTS/SSIS Packages using SQL server Agent.
• Experience in implementing SQL Server security models to prevent unauthorized access which Includes windows/mixed authentication, database permissions, roles, securable and principals.
• Migrating SQL Server 2000 databases into SQL Server 2005/2008 by In - place upgrade process.
• Trained in cross server data transfer using utilities such as Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) packages.
• Good Knowledge and experience on Active Directory.
• Hands-on working experience wif analysing query plans.
• Experienced in creating logins and assign teh permissions to databases. Maintained teh SQL Server in secured environment.
• Configured and maintained teh transaction and merge replication for two different projects.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, VB script

RDBMS: MS SQL Server 2008, 2005, 2000

Version Control Tools: Visual Source Safe

Operating Systems: Windows 2008/2003 Enterprise Server, Windows 2000 Advanced Server, Windows NT

Application: MS Office, PageMaker, Publisher, Photoshop, Acrobat,Distiller, Word, Excel,PowerPoint, FileMaker, MSWorks

Other Tools: Cluster administrator, SQL Profiler, ISQL, OSQL SQL Query Analyzer,Perfmon, CA Erwin

PROFESSIONAL EXPERIENCE

Confidential, Melbourne, FL

SQL Server DBA

Responsibilities:

• Installed and configured many SQL Servers from developer editions to enterprise editions and on Windows 2008R2 also on Windows7 for user’s desktops and for several development and productions environments.
• Upgraded SQL Server 2008R2 Active\Passive Cluster to SQL Server 2012 Active\Passive Clustered wif Always on.
• Worked on 24\7 technical support basis and on shifts work strategies.
• Worked on robust environment and followed all teh system operating procedures and high visibility and much complicated systems.
• Implemented best industry practices for backups, security standards and capacity planning.
• Performance tuning for database in SQL server 2012, 2008R2, 2005 and for several different applications related slowness.
• Used many third party tools like Confio Ignite, RedGate, SpotLight, SCOM, BigBrother for monitoring performance, raising alerts and for backups.
• Performed and designed best practices for daily maintenance, Weekly maintenance and Monthly Maintenance for SQL Server 2012, SQL Server 2008R and SQL Server 2005.
• Performance tuned Stored Procedures, T-SQL Statements, Index tuning.
• Developed set of administrative scripts to automate most daily operations
• Implemented Disaster Recovery Solutions in case of disaster wif minimal downtime.
• Implemented SQL Server Replication, Log Shipping and Database Mirroring as per teh business needs in SQL Server 2008R2 and SQL Server 2012.
• Migrated and Upgraded SQL Server 2008 to SQL Server 2012, SQL Server 2005 to SQL Server 2012.
• And user databases Setup log shipping of production databases to maintain standby copy of production databases and for offloading query processing from teh production server.
• Maintained Production, Test, and Development Server Setup and maintained Linked Servers Setup and maintained Replication Servers.
• Developed Stored Procedures and Triggers for new applications. Implementing Backups and restoring when necessary.
• Used BCP utility to publish table output to text files.
• Developed DTS Packages to transfer teh data between SQL Server database and files Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor teh server performance, debug T-SQL and slow running queries.
• Managing of users including creation/alteration, grant of system/db roles and permission on various Database objects.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.

Environment: SQL Server 2012, SQL Server 2008R2 and SQL Server 2005, Enterprise Manager, Windows 2000, SQL Profiler, DTS, T-SQL, BCP, Replication, Citrix, MS Exchange and Team Foundation Server 2010.

Confidential, Louisville, KY

SQL Server DBA

Responsibilities:

• Installed, configured, administered and secured SQL Server 2000/2005/2008/2008 r2 on Server and Clients.
• Involved in 24x7 support for both production and development databases wif on-call pager.
• Designed, implemented, and administrated databases in SQL Server 2000, 2005, 2008, 2008r2
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administering SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handleddead lock scenarios.
• Regularly monitored teh system for bottlenecks (CPU, RAM, Disk IO and Networking).
• Involved in analyzing and designing disaster recovery / replication strategies wif business managers to meet teh business requirements.
• Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction wif teh data warehouse architect on teh development of logical data models.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Applied performance benchmarks to have zero downtime for servers.
• Migrated from SQL Server 2000 to SQL Server 2005 and SQL Server 2008.
• Created DTS, SSIS packages to export and import data from SQL Server to Access, text and EXCEL files.
• Expert in Creating, Testing and Implementing SSRS packages for Reporting Services (SSRS)
• Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
• UNIX commands for server connections and settings.
• Created Database users, controlling access to SQL and Oracle Servers by making sure right people get access to right data and looking after security issues.
• Monitor connections, locks and performance of SQL server.
• Maintained SQL Server Active/Active and Active/Passive clusters
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code.
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T- SQL.

Environment: SQL Server 2000/2005/2008/2008 r2, Windows 2K/2003/2008,, SQL Profiler, DTS, T-SQL, BCP, Replication, SSIS, SSRS, MySQL, Replication, Enterprise Manager, Visual studio

Confidential, Memphis, TN

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2008 wif latest Service Packs
• Involved in Migrating SQL Server
• Wrote SSIS Packages to migrate users, logins, stored procedures, and tables
• Used SQL Server Management Studio to manage teh SQL Server Analysis Services(SSAS)
• Used SSRS to produce our own reports
• Worked performance tuning, Query optimization, using Perfmon, profiler.
• Worked in Active/Passive and Active/Active Clustered Environment
• Extensively involved in Database Mirroring.
• Extensively involved in replication and Implemented Snapshot, Transactional Replications
• Involved in semiannual Disaster Recovery Testing drills.
• Identified flaws wif DR Strategies and offered suggestions of improvement.
• Performed Database Backup, Recovery, and Transfer operations.
• Used Quest Litespeed 6.1.0 for back up and compression.
• Wrote custom scripts and jobs to manage backups due to lack of disk space.
• Installing applications involved in Database Mirroring.
• Configured Log Shipping in SQL Server 2005.
• Extensively involved in replication and Implemented Snapshot, Transactional Replications.
• Involved in semiannual Disaster Recovery Testing drills.
• Identified flaws wif DR Strategies and offered suggestions of improvement.
• Performed Database Backup, Recovery, and Transfer operations.
• Used Quest Litespeed and establish teh connectivity wif teh database.
• Maintained tables, indexes.
• Monitoring Notifications, Jobs and Alerts to make sure all jobs run successfully.
• Used Idera Diagnostic Manager for Monitoring solutions.
• Doing 24x7 production support on rotation basis.

Environment: MS SQL server 2008/2005, Windows 2008/2003 Enterprise edition, SQL profiler, Idea Diagnostic Manager, SQL Light speed Backup Software.

Confidential, Houston, TX

SQL DBA

Responsibilities:

• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Involved in gathering and analysis of user requirements.
• Create functional and technical specifications for projects.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Data Migration from SQL 2005 to SQL Server 2008
• Responsible and for logical and physical design of database using Erwin Tool.
• Create database maintenance plans for teh performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Bulk data migration using SSIS from flat files.
• Used Index Tuning Advisor for Database performance for proper indexes.
• Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
• Implementing Load balancing Replication across teh Databases.
• Performed Database Refresh tasks from production to Development and Staging Servers
• Involved in Performance Tuning of teh SQL Server for Web based Production and Development environments.
• Used PerfMon and Profiler Trace to monitor teh Memory, CPU and Disk usage, teh private bytes of each process, teh trend in teh Available Bytes, Performed Uploading of bulk data migration wif BCP Utilities.
• In charge of converting data using SQL Server 2005 using SSIS.
• Performance tuning and testing on stored procedures, indexes, and triggers.
• Performed daily back up of entire database and recovery.
• Designed and deployed various complex reports using MS Reporting Services.

Environment: SQL Server 2000, SQL Server 2005, Windows 2000 Server, DTS, SSIS, SSRS, Erwin, SQL Profiler, MS SQL Server Reporting Services.