SUMMARY:

• 13 years of experience in SQL Server 2005/2008/2012/2014 working as a Database Administrator
• Experience in installing, configuring and administering SQL Server 2000/ 2005/ 2008/ 2012/ 2014 Development, Enterprise and Standard Editions in both Clustered and Stand alone Systems.
• Migrated/Upgraded several databases/ servers from SQL Server 2005 and 2008 to SQL Server 2012/2014.
• Experience in 32/64 bit version of SQL Server 2005/2008/2012/2014. with Development, Enterprise and Standard editions
• Managed very large databases in 24/7 Production Environments.
• Experience on implementation of Transparent Data Encryption on multiple Databases
• Implemented SQL Hardening using Corporate Security Standards.
• Implemented high availability solutions, using Always On, Clustering, Database Mirroring, and in DR solutions using Replication and Log Shipping.
• Working Knowledge in ETL technologies, developing and deploying SSIS/SSRS/DTS packages.
• Extensive experience analyzing server performance and performing root cause analysis.
• Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
• Experience in table & index partitioning, implementing multiple files and file groups.
• Experience in qualifying third party SQL Server tools and documenting installation and configuration procedures.
• Experience in using Foglight, Spotlight, SQL Compare and SQL Data Compare.
• Experience using Native SQL Server tools including Profiler, Index tuning wizard, database upgrade advisor.
• Strong in database backup, restore and disaster recovery procedures.
• Experience in administering servers/databases in secured DMZ’s.
• Very good knowledge of PCI\CPNI\SOX regulations and documenting audit procedures.
• Experience working both SAN/ NAS storage technologies.
• Involved in complete lifecycle of SDLC process.
• Supported Telecomm, Retail, Financial and government agency databases.
• Excellent analytical and communication skills to effectively work with both business and technical groups.
• Capable to work in team or independently.
• Microsoft Certified IT Professional: Database Administrator

TECHNICAL SKILLS

Platforms: Windows XP/NT/2000 server/XP/2003 server/2008 server/ 2008 R2Server and Windows7

Databases: SQL SERVER 2000/2005/2008/2012/2014, MS - Access

Web Technologies: ASP, HTML, DHTML, XML, Java Script

Security Tools: Microsoft Baseline Security Analyzer (MBSA), NGSSQuirreL for SQLServer, Scuba by Imperva

Tools: SQL Server Management Studio / Enterprise Manager, SQL Navigator,SSRS, SSIS, Enterprise Manager, SSMS, Toad, Foglight, VERITASQuest Lite: Speed, Excel Macro 2007/2003, Erwin

PROFESSIONAL EXPERIENCE

Confidential, GA

MS SQL Server DBA

Tasks and Responsibilities:

• Worked on Data Center Migration from initial requirements gathering to finally going live in the Production environment.
• Installed and configured SQL Server 2008, 2012 and 2014 on WINDOWS 2003/2008/2012 R2 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked on SQL Server Upgrade Projects from SQL Server 2005/ 2008 to SQL Server 2012 and 2014 Environments.
• Implemented high availability solutions for mission critical SQL Server databases with Alway On, clustering and Mirroring in both High Safety and High Performance modes.
• Configured Transaction Replication Production to DR Servers and Reporting Server with Multiple subscribers.
• Designed and implemented Disaster Recovery site using SQL Server Mirroring.
• Supported production servers in Fail over cluster environment.
• Worked on implementation of Transparent Data Encryption on multiple Databases
• Worked on monthly Releases by performing Code reviews and deploying them in Production
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues promptly.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through.
• Used 3rd party tools like Quest Nightspeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Confidential, Princeton, New Jersey

MS SQL Server DBA

Tasks and Responsibilities:

• Installed and configured SQL Server 2005, SQL Server 2008 on WINDOWS 2003/2008 servers, applied service packs and security fixes in Clustered and Standalone environments.
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring in both High Safety and High Performance modes.
• Designed and implemented Disaster Recovery site using SQL server Database Log Shipping.
• Supported production servers in Fail over cluster environment with multiple Nodes during Windows monthly Patching and reboot cycle.
• Monitored database quality including database consistency check with DBCC, Defrag, and Index tuning and monitored error logs.
• Worked extensively on data maintenance like re-indexing, integrity checking, and database shrinking.
• Verify backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• Respond to trouble tickets assigned to me and fix any database issues.
• Test Backup and Recovery Strategies by simulating various recovery scenarios like loss of data files, Transaction logs, read only table spaces, Point-in-time recovery through.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Evaluate the peak and no peak usage pattern of the application; effectively distribute database administration activities, such as full database backup and database defragmentation during no peak hours.
• Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
• SQL Query Performance Tuning, system Performance Analysis, analyzing the Query Execution Plans, Used SQL Profiler for optimizing the store procedure.
• Worked with storage and network administrators to plan and estimate drive space and storage needs throughout the environment.
• Configuring Server-Level/User-Level Security Strategy, Authentication Modes, configure database Logins/Users.

Confidential, New Jersey

MS SQL Server DBA

Tasks and Responsibilities:

• Installing, configuring and deploying SQL Server 2005 and 2008 in Clustered and non-clustered environment.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008.
• Configured security and access per SOX and PCI standards.
• Created Linked Servers for OLEDB Data Source and Native Sources.
• Responsible for creating, maintaining and monitoring mirrored servers, configured using synchronous and asynchronous updates with witness server.
• Implemented and Monitor the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Setup Log Shipping and troubleshooting Log Shipping errors when arises.
• Created alerts, notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors, alerts, activity logs, error logs to capture any possible errors.
• Used 3rd party tools like Quest LiteSpeed in taking the backups to optimize performance and restoring.
• Analyzed business requirements and build logical and Physical data models that describe all the data and relationships between the data.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity. Monitor database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Running DBCC consistency checks, and fixing data corruption in user databases.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Worked on fail over clustering and mirroring.
• Documentation of daily tasks and scripting them.
• Worked in 24X7 production support with a rotation basis.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Experience in implementing Failover Support for SQL Server with active/Active Cluster configuration.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Created Dash board reports using COGNOS report studio.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Using Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data.
• Configured and worked on SSRS.
• Created Indexes to speed up the queries and Performed Database Normalization.

Confidential

MS SQL Server DBA

Tasks and Responsibilities:

• Performance Tuning of the SQL Server (in OLTP, Web based, Production and Development environments) including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, Page Faults, growth of Tempdb, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases, and use Index Tuning Wizard to create proper indexes
• Tuning of SQL Sever Memory structures and troubleshooting the existing issues with Buffer Pool and Paging
• Upgraded the server from SQL 2000 TO SQL 2005.
• Install SQL server on Stand alone and Clustered instances.
• Implemented high availability solutions for mission critical SQL Server databases with clustering and Mirroring in both High Safety and High Performance modes.
• Configured Transaction Replication Production to DR Servers and Reporting Server with Multiple subscribers.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held; avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Monitor and tune both server and databases using DBCC, Server configurations options (sp configure) and Database options (sp dboption).
• Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Monitored the application and database performance using SQL Profiler and Performance Monitor.
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Configured security and access per SOX and PCI standards.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Performed database consistency check as regular Interval.

Confidential

MS SQL Server DBA

Tasks and Responsibilities:

• Involved in installation and configuration of SQL server 2000.
• Migrated from SQL Server 2000to SQL Server 2005.
• Applied patches and service packs to keep the database at current patch level.
• Responsible for configuration of Microsoft Server/Client Products and implementation.
• Perform database capacity planning; create, administer and maintain databases; install and patch
• server software, upgrade and downgrade databases, perform database backup/recovery and cloning; perform operating system, application and performance monitoring and tuning, identify and resolve any database bottlenecks proactively, respond to raised problems quickly.
• Configured Transaction Replication Production to DR Servers and Reporting Server with Multiple subscribers.
• Designed and implemented Disaster Recovery site using SQL SERVER Log Shipping
• Monitor database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory,CPU, etc.). Manage and maintain high volume transactional tables and indexes, database reorganization
• Providing consultation on SQL Server to our development team.
• Design, creation, configuration, recovery and support of SQL Server databases
• Performed 1st tier Production support by troubleshooting database issues, performance monitoring/tuning, & capacity planning for SQL Server databases

Confidential

SQL Server Database Administrator

Tasks and Responsibilities:

• Installed SQL Server 2000 and upgraded databases from SQL Server 7.0
• Created Clustered and Non-Clustered Indexes.
• Administered various instances of SQL Server for Production, Development and Testing.
• Designed and developed databases and programmed the interface using Visual Basic and ASP.
• Data Modeling using Erwin Design Tool.
• Automated backup procedures.
• Tuned the SQL queries using SQL profiler. Involved in tuning the database
• Experienced in implementing disaster recovery strategies using Log shipping, Replication
• Migrated data across different databases and different servers.
• Create ad hoc reports for management.
• Used Performance Monitor and SQL Profiler for monitoring memory, processor, Disk I/O, long running SQL Queries, stored procedures, etc.
• Worked with application development teams in troubleshooting issues.

Environment:SQL Server 2000, .NET, Java, VB 6.0, Visual Source Safe 6 and Crystal Reports, DTS Wizard.