SUMMARY:

• 8+ years of experience as SQL SERVER Database Administrator/Developer/Designer.
• Experience in installing, configuring, upgrading and maintaining servers of all versions of Microsoft SQL Server 2012/2008R2/2005/2000.
• Expertise in Administration, Database Design, Performance Analysis, Complex Databases up to 2 Terabytes and implemented policies/procedures for ensuring teh security and integrity of teh databases.
• Worked on new SQL server 2012 features like Contained Databases, Security TEMPPrincipals and AAG (Always on Availability Groups).
• Experience in working with Data and Backup compression, Performance Data Collection, Transparent Data Encryption which were new in 2008R2 version of SQL.
• Optimizing Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards.
• Expertise in Creating Linked Servers between different Servers in SQL environments and also between 32 and 64 bit servers to access database objects in remote locations.
• Experience in working with performance monitoring tools to monitor teh memory used, long running queries, consistency errors.
• Migrating application code and objects from development/test environments to production.
• Performed web creations and development using MS Visual Studio.
• Experience in working on SQL server Replication, Backup/Recovery, Disaster Recovery and Planning. Hands on experience with Database Mirroring and Log Shipping.
• Monitoring teh event logs and Server error logs using DBCC utilities for troubleshooting purposes.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering.
• Worked in Active Active, Active Passive Cluster environment as a High availability solution.
• Hands - on experience with SQL Server 2008 new features like Change Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Experience in using Performance Monitor/Profiler to resolve Dead Locks and long running queries.
• Planned, Designed and implemented enterprise solutions involving VMware. Experience with teh design, architecture and implementation of Virtual Infrastructure environments using VMware VI.
• Experience in using teh DMVS, DMFS, SP PROCS, INFORMATION SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for teh instant analysis.
• Efficient in performing database consistency checks using DBCC Utilities and handling data corruption in user databases and identifying teh bottlenecks caused by complex queries using Activity Monitor, SQL Profiler and Performance Monitor.
• Experience in working with Side by Side migration.
• Experience in verifying teh stored procedures created by developers, modifying and fine-tuning teh scripts for better performance using Database tuning advisor.
• Experience with SQL Azure Cloud Database Security.
• Installing and creating various types of reports using SSRS and packages using SSIS.
• Expertise in writing and debugging Stored procedures, Triggers, Optimizing Code and Improving efficiency in databases including Re-indexing, Updating Statistics and performing other maintenance tasks.
• Intensively worked on Auditing for extracting data from Databases.
• Experience in Import-Export, and Backups.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and teh ability to multitask.

TECHNICAL SKILLS:

Data Warehousing/BI Tools: MS SQL Server Business Intelligence (MSBI) Development - SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), SQL Server Management Studio(SSMS)2000/2005/2008/2008R2/2012, Visual Studio (VS) 2005/2008/2010/2012

RDBMS: MS SQL Server 2000/2005/2008/2008R2/2012

Languages: C, C++, XML, HTML, TSQL

Tools: SQL DB Access, Performance Monitor, DTS, MS Office 2000/2003/2007, Visual Studio, BIDS, VSS, Cognos, Informatica, MS Visio

Operating Systems: Windows Server 2000/2003/2008/2008 R2, XP/Vista/7.

Backup and Monitoring Tools: Ignite, Red Gate, Lite Speed, VERITAS Net Backup, Spotlight, Idera, Data Protector

PROFESSIONAL EXPERIENCE

Confidential, Albuquerque, NM

QL Server DBA

Responsibilities:

• Production DBA for SQL Server Environment with over 50 Production Servers and 100 Development/ Test Servers and more TEMPthan 1000 Databases.
• Install and configure SQL Server 2008R2/2012. Troubleshooting Performance issues and database issues.
• Extensively worked on setting up Always On Availability Groups on a Multi-subnet failover network. Worked with teh Windows team to configure Windows Failover Cluster on which teh Always-On setup was done.
• Migrating servers from 2005 to 2008 and some sandboxes from 2008 to 2012.
• Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
• Design and implement comprehensive Backup Plan and Disaster Recovery strategies.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Maintain teh database consistency by checking with DBCC Utilities at regular intervals.
• Use Resource Governor to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Design and develop SSIS packages using different control flow tasks, data flow task and data transformations.
• Maintain Active/Passive and Active/Active cluster environment with Virtual Machines using Hyper V.
• Create and maintain Transactional, and Merge Replication environments.
• Implement Database mirroring. Configured TEMPPrincipal, witness and mirror on teh 2008R2 SQL Servers.
• Used DMVS, DMFS, SP PROCS for teh instant analysis.
• Implement Asynchronous mode for Database mirroring in Staging Environment.
• Use Performance monitor and SQL Profiler to optimize queries and enhance teh performance of database servers and uptime in production environment.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Implemented partitioning for both tables and Indexes.
• Used Online Indexing and online Restoring in SQL Server 2008.
• Applied changes on Production through Change management after thoroughly testing on development servers.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services (SSRS).
• Create documentation for steps that need to be taken while upgrading teh SQL server 2008/2012 to SQL server 2014.

Environment: SQL Server 2008, 2008R2, 2012, 2014 Windows Server 2008, VS 2010, T-SQL, and Excel.

Confidential, Virginia Beach, VA

SENIOR SQL SERVER DBA

Responsibilities:

• Administrated and Managed SQL Server 2012/2008R2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include teh Production and Application Support for teh Database and Application Servers.
• Upgraded/Migrated SQL Server 2000/2005 databases into SQL server 2008R2/2012 and mentored other technical staff.
• Involved in implementation of Always On Availability Group as a High Availability solution on SQL Server 2012.
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native monitoring tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2008R2/2008/2005 (64 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using trace flags and activity monitor.
• Designed teh Database Recovery plan and implemented teh Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing and Resource Governor.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Participated in teh designing and development of software using agile development practices.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with teh halp of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development& Test Servers of MS SQL Servers.

Environment: MS SQL Server 2005, 2008 R2 Windows 2003 Server, Windows 2008 R2 Server, MS Visual Studio 2010, Excel, HTML, RedGate

Confidential, MA

Database Administrator

Responsibilities:

• Maintaining and administering around 100 servers as a team.
• Installing various versions of SQL on user machines and servers.
• Monitoring Database mirroring and log shipping on some of teh servers.
• Installing and working with third party tools track teh server /database level performance and to improve it.
• Assigning DB level and table level permissions, creating logins to different users at Database and windows level. Maintaining strategies using Policy Based Administration.
• Migrating Databases from SQL Server 2005 to SQL Server 2008.
• Creating SSIS packages to get data from other sources to some of teh SQL servers and scheduling them as daily and weekly jobs. Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Creating tables, triggers, and cursors and modifying stored procedures with change requests sent from development teams and hence working closely with Web / Change Management teams.
• Solving space and memory related issues on servers as daily and weekly tasks, setting up email notifications on all teh servers to teh DBA group to be notified when a job/ maintenance task fails or if teh server runs out of drive space.
• Using Profiler, Activity Monitor to check for teh long running queries, tuning them and creating maintenance plans for all SQL servers for daily/weekly tasks.
• Frequently performing data Integrity checks and monitoring teh databases which are highly used.
• Working with teh Operations team on installing HP tool Data Protector on all teh servers for backups and Recovery, apart from teh native SQL backups.
• Generating periodic reports based on analysis of teh data using SSIS.
• Working on huge projects like Data Center move and IP address change of all teh SQL servers, Upgrading Production servers from SQL 2005 to SQL 2008R2 SQL and documenting teh process.

Environment: SQL 2008 R2/ 2005/2000, BIDS (SSIS, SSRS), MS Visio, Cognos, Data Protector, MS Office.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Performance tuning of teh SQL 2000 servers in order to reduce I/O and Memory contentions.
• Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.
• Deployed teh SSIS Packages and created jobs for efficient running of teh packages. Import/export packages.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Involved in scheduling, creating snapshots and subscriptions for teh reports (SSRS 2005/2008).
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Export or Import data from other data sources like flat files using Import/Export of DTS.
• Recovering teh databases from backup in disasters.
• Creating logins, groups, users, roles, database devices, databases, mirroring devices, checking for database consistency, fixing DBCC errors, monitoring error logs, database space allocations, transaction log space allocations, fine tuning SQL performance.
• DBA support for a development team customizing and testing new releases of client-server applications.
• Analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity and reusability of code.
• Written Tested and Documented Program code and implemented programs.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: SQL Server 7.0/2000, Windows 2000, SQL Profiler, SQL Profiler

Confidential

SQL Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created database triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support teh front-end application.
• Involved in tuning teh database and T-SQL queries using Explain Plan.
• Optimize SQL queries for improved performance and availability.
• Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.
• Successfully created schema change scripts to existing objects to synchronize with changing business rules.
• Monitored growth of database objects for capacity planning.
• Developed DTS Packages to get teh reports, routinely, in teh excel sheets, required by teh managers for analysis.
• Designed individual physical structure of teh business using .NET Framework and OLAP.
• Configured and monitored database application.
• Involved in performance tuning of teh database and T-SQL queries.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using Crystal Reports.
• Preparation of project documentation.
• Preparation of test plans for assembly testing & System Integration testing.

Environment: SQL Server 2000, Query Analyzer, T-SQL, .NET Framework, Crystal Reports 8.0, Windows 2000/XP.