SUMMARY

• 8+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012/2008/2005/2000.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Handling Memory configurations for SQL Server 2012/2008R2/2005/ and 2000 on Windows 2008 and 2003 servers both 32bit and 64 bit.
• Experience in using DMV and Dynamic Management Functions (DMF) for finding out long running queries.
• Administering SQL Server High Availability, like Database Mirroring, Replication.
• Experience in supporting Very Large databases (VLDB) more than 6TB and troubleshooting the problems.
• Data modeling Experience like Physical data modeling and logical by using ERWIN.
• Extensively worked on Active - Active and Active-Passive Clustering.
• Worked extensively on Clustering and server consolidation, Troubleshooting production issues and raising high availability.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Worked on configuring SQL Server with minimum privileged access.
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Done Password Changes on cluster and Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery planning and Security Management.
• Strong experience in mentoring team members and writing documentation.
• Good Knowledge of front-end .NET
• Excellent communication, presentation, interpersonal, troubleshooting and organizational skills.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Relational Databases: T-SQL, SQL Server 2012, 2008 R / 7.0, MS-Access 2000/2003/2007 , Oracle 9i & 10g, MYSQL 4/5

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSISSSAS, SSRS, Business Intelligence Studio, Crystal Reports.

Operating Systems: Windows 2008, Windows 2003, Windows 2000 server, 64bit & 32Bit

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, MirroringETL SSIS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS SourceSafe, Source Control, MS Visio, Windows System MonitorSQL COMPARE.

Database Backup Software's: Red-Gate (SQL Backup 7), Light Speed.

SQL Server Monitoring Tools: SQL Server Performance Dashboard, SQL Diagnostic Manager 7.5 (Idera)

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

Sr. SQL Server DBA

Responsibilities:

• Primarily responsible for Migrating Learn production databases from Raleigh, NC data-center to Sterling, VA data-center.
• Moved more than 70 databases from SQL 2000/2005/2008 R2 and migrated them to SQL 2012.
• Installed and configured SQL server 2012 in a 5 node production cluster.
• Administered 7 clusters with different nodes like 2 node, 3node and 5 node clusters in both production and staging environment.
• Designed and executed Disaster Recovery Plan using Database Mirroring.
• Installed and configured SQL Server 2012 in a 2 node cluster for internal applications in Confidential like PlanView which is used for submitting timesheets of employees.
• Installed and configured SQL Server 2012 in a 3 node cluster for applications like SolarWinds, SiteScope and Shavlik Scans which monitor the health of windows servers in both production and staging environment.
• Installed SQL Server 2012 on stand-alone machine which hosted McAfee (ePO) database in different environments.
• Creating and maintaining logins/user and other data securities using TDE etc.
• Experience on Incident Management, closing out high priority tickets though Track-it Ticketing software.
• Involved in monthly maintenance where we need to reboot clusters, failing over instances from one node to another after windows patches pushed by the network team.
• Strong expertise on clustering and troubleshooting alerts when cluster goes down.
• Installing latest Service Packs, Hot-fixes to all production and staging database servers. Recently installed SP2 and also Cumulative update 1 to 2012 servers.
• Monitoring all production servers using Idera Monitoring tool, SQL Server Performance Dashboard and also by using different scripts to identify blocking sessions.
• Strong expertise on using Redgate (SQL Backup 7) for backups and encrypting the database backups with 12 character password generated by Norton password protection tool and securing them in separate ADMIN database created for Database Administration.
• Configuring mount points SAN drives for clustering environment. Storage team assigns the disks and I used to bring them online and configuring the mount points.
• Involved in daily production server check list, SQL Backups, Disk Space, Job Failures, System Checks, Checking performance statistics for all servers using monitoring tool and research and resolve any issues, Checking connectivity
• Created Severity Alerts, Database Mail, Operators, Maintenance Plans for system databases
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database Integrity Check, Rebuild Indexes on user databases, and apply in development and Testing Environment.
• Involved in the Backup & Restore and point in time recovery of the databases.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2012, Windows 2008 R2, Windows NT, Litespeed, Red-Gate (SQL Backup 7), SQL Server Performance Dashboard, Activity Monitor, SQL Diagnostic Manager 7.5 (Idera), SolarWinds, SiteScope.

Confidential, Harrisburg, PA

Sr. SQL Server DBA

Responsibilities:

• Installed SQL Server 2005\2008 with SP2 in production and development environments.
• Involved in maintaining and upgrading the agency’s data dictionary, and developing metadata standards in order to facilitate improved data quality and master data identification.
• Planed and designed new SQL Server 2012, implementedon Development server.
• Worked in 2- node Active/Passive Clustered Environment.
• Involved in migrating DTS packages from SQL Server 2005 to SQL Server 2008 databases.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Integrated SQL Server 2008 reporting services with Microsoft Share Point Portal Server to deliver automatically generated reports to a Share Point portal.
• Involved in Performance tuning, optimization of stored procedures and queries.
• Rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Monitored Performance with SQL Profiler, Perfmon and using a monitoring tool called DBArtisan.
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Creating Logins and Roles with appropriate permissions.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Involved in checking the replication on each server by checking each publication to make sure the distributor is running for each subscription,
• Maintained log book to write down any issues and how they were resolved.
• Prepared and documented database Backup & Maintenance Plans.
• Involved in daily production server checks
• Worked in 24x7 production environment.

Environment: MS Windows 2003/2008 Enterprise Server, MS SQL Server 2005/2008 R2/2012, Visual Studio 2005,SharePoint 2007, SCOM 2007 R2

Confidential, Eagan, MN

Sr. SQL Server DBA

Responsibilities:

• Installed and configured in clustering environment for SQL server 2008 ENT for 2 node configuration
• Upgraded Servers from SQL server 2000 to SQL server 2008 and installed service pack
• Involved in SAN migration, completely moving data centers, changing the storage backbend’s to different vendors, consolidating SANS.
• Migrated Databases, DTS packages using Upgrade Advisor, DTS Wizard, Backup\Restore from SQL Server 2000 to SQL Server 2008.
• Implemented various policies using Policy-Based-Management for reliable configuration of the system and Managed SQL Server across the Enterprise.
• Administered the SQL server 2000/2005/2008 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users, groups and on Objects
• Worked on SQL Server Clusters Active - Passive on mission critical Client applications.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Monitored database status including CPU, Memory, I/O spikes, drive space and deadlocks on production server using DMVs, PerfMon console and took corrective actions.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans and DETA.
• Used SQL Sentry tool for Plan Explorer to simplify the analysis of execution plan.
• Conducted design reviews with users/team for development and production strategies.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Capacity-planning, Maintaining run book documentation on all the servers in word and excel formats.
• Worked closely with QA\App support team and tested the upgraded applications\databases.
• Created, configured and prepared documentation for the disaster recovery plan.
• Acted as a liaison between the offshore team and onshore team.

Environment: SQL Server 2008 R2/2005/2000, Windows 20 bit\32bit, SQL backup5 Red Gate, System Monitor / Performance Monitor, VMware ESX, Share point 2007, Microsoft Network monitor 3.4.

Confidential, Dover, DE

SQL Server Developer/DBA

Responsibilities:

• Installed and configured SQL server 2005 and administered 10 servers with minimal downtime
• Functional breakdown includes 70% DBA and 30% Development.
• Migrated Databases, DTS packages, from SQL Server 2000 to SQL Server 2005.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Responsible for maintaining all database environments Development, Testing, QA, Staging, and Production.
• Administering SQL Server security and apply security across environments and trouble shoot security issues on daily basis.
• Administered the SQL server 2000/2005 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Involved in database administration tasks and assisting developers with problems and SQL optimization.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Knowledge in Active/Passive Clustering and implementing RAID technology on windows 2003 servers.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Translating business requirements into technical design specifications and actively supported business users for change requests.
• Capacity-planning, Maintaining run book documentation on all the servers in word, pdf and excel formats.
• Good experience in handling onsite-offshore model.
• On call 24/7 support to databases on weekly rotation.

Environment: SQL Server 2005/2000, Windows 2000, Windows NT, Lite Speed, SQL backup5, SQL Secure.

Confidential, Redmond, VA

SQL Server DBA

Responsibilities:

• Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
• Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
• Interacted with developers in troubleshooting application and database issues.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Involved in installing SQL Server 2005/2008 R2 on Development, Production and WTC (Testing) machines.
• Troubleshooting high availability scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Involved in migrating SQL Server Databases from LAB Server to Development Server and from Development to Production Server.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
• Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchangetool.
• Extensive use of Import/Export wizard to convert T- SQL Queries, Data and Reports from different forms like XML file, MS Excel file, TTF file, PDF file and other formats to SQL data type and Vice versa
• Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
• Interacted with concern application team in fixing the problems when ever needed.
• Created performance baseline reports using RML tool and documented for future use.
• Involved in setting up database mirroring for production server
• Configured replication methods like snapshot, transactional and merge replications.
• Monitoring and scheduled jobs on production and staging environment.
• Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
• Used the Execution Plan to improve the optimization of the T-SQL code.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Resolving performance related issues to Blocking, Deadlocks and long running queries

Environment: MS Windows 2003/2008 Enterprise Server, MS SQL Server 2000/2005/2008 R2, Visual Studio 2005,IIS 6.0, HP ProLiant DL380 G4 with 12 GB RAM, Dell PowerEdge Servers, ERWIN, DBArtisan, SharePoint, SCOM 2007 R2

Confidential

Jr. SQL Server Developer/DBA

Responsibilities:

• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Provided 24 X 7 dedicated supports for the claims records database.
• Provided 24 X 7 supports for Production environment.
• Planned and modified the permission issues in the production servers.
• Server & Application fine-tuning & trouble shooting, Monitoring MS SQL Server performance and windows server issues.
• Created the backup and restore strategy for production environment.
• Worked with SQL server Profiler generated traces to optimize the performance of the database.
• Installed and configured active/passive clustered environment.
• Rebuilding indexes on various tables.
• Resolving locking and blocking issues.
• Installed and configured SQL Server bit in a Test Environment and migrated & tested databases to production server.
• Implemented log shipping in standby mode to support DR servers.
• Documented and tested Merge replication in test environment for generating reports.
• Designed a report on the monitoring of SQL Server Performance.
• This report gives a detail report to the management on the performance of the server on daily basis in email format.
• Provided technical assistance and mentoring to staff for developing conceptual and logical database design and physical database.
• Assisted other teams in stress-testing applications, locating bottlenecks, and recommending possible solutions.
• Responsible for quality control and auditing of databases to ensure accurate and appropriate use of data.
• Worked with management to develop database strategies to support company needs.
• Responsible for creating and maintaining technical documentation for the database environment to follow HIPPA rules.

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server, Windows 2003 Enterprise Edition, Confidential eServer pSeries platform, Confidential Storage systems DS8300, DS6800s and DS 4800s.