SUMMARY:

• 4+ years of experience in Database Administration and for very large and critical databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Expertise in T - SQL writing stored procedures, triggers and functions.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
• Worked on logical and physical data base modeling with UML and ERWIN tools.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Worked on configuring SQL Server with minimum privileged access.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Having Experience on Data center servers and handling 2.4 TB databases.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows 2008R2.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.
• Working knowledge in Analysis Services(SSAS), Reporting Services(SSRS)

WORK EXPERIENCE:

Confidential, Decatur GA

SQL Server DBA

Responsibilities:

• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Worked on SQL Server 2012 migration from SQL Server .
• Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations.
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.
• Experience in supporting Very Large databases (VLDB) and troubleshooting related problems.
• Strong experience in mentoring team members and writing documentation.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2005, 3008R2 and 2012, Windows 2003/2008R2/2012 Server, LiteSpeed 6.0, MSE, VSS and Password Updater.

Confidential

CONSULTANT SQL SERVER DBA

Responsibilities:

• Monitoring the server for High availability of the servers and databases.
• Solving the request raised by user support related to database and system issues.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments from Development, UAT and final production go-live.
• Meet the SLA (Service Level Agreement) established with acknowledgement, resolution and completion of requests.
• Day-to-day administration of live SQL Servers databases.
• Work with developers to refresh development and test database with current production data
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Deploying monitoring tools like Sitescope and spot light.
• Table partitioning and file group creation to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, and root cause analysis.
• Act as the first technical contact for any query or database performance issues and assist developers and business power users in query request and enhancements
• Assist in the deployment of Net application, SSIS packages, SSRS-RDL and SSAS cubes
• Enforced data objects naming convention and data integrity by building data cleansing rules and refining the ETL processes.
• Undertook Table/schema design of the database as well as wrote and tuned stored procedures that access those tables for performance.
• Designed and recommended, and wrote/maintain SQL code to support development of custom products and services.
• Wrote transact-SQL stored procedures and reviewed stored procedures written by programmers.
• Maintained and monitored database backup and restore process
• Coordinated with Network Administrators and Developers to ensure data security and availability to meet the necessity of database refresh in development and staging area
• Used different replication methodologies to select and configure the settings while maintaining the stability of data stream.

Environment: SQL Server 2000/2005/2008/2008 r2, IIS, Windows 2008/2003/2000 Server, SQL DB Access, Performance Monitor, Backup Utility, MOM, MSE and Sitescope.