Sql Server Data

KOTA D

SQL DBA

Email Id: *********@*****.***

Contact Number: 737-***-****

PROFESSIONAL SUMMARY:

•2+ years of experience in SQL Server 2012/2008R2/2008/2005 with strong expertise in SQL Server development, designing Stored Procedures/Transact-SQL coding, SSIS/SSRS/SSAS, OLTP and OLAP.

•Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

•Expertise in Always-On Availability Groups (AAG) and High Availability (HA)/Disaster Recovery (DR) Troubleshooting.

•Experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor and DMVs.

•Experience in high availability SQL Server solutions with SQL Server 2012 availability groups, Replication, Database Snapshot, Log shipping, and Database Mirroring.

•Experience in automating the system by using Notification service and creating alerts, jobs and maintenance plans.

•Hands-on working experience with Analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.

•Experience in implementing High availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and Implementing SQL Server clustering (Active-Active, Active-Passive), (Multi Node Cluster).

•Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Online Restore, Fast Recovery, Database Snapshot, DDL triggers, TRY-CATCH blocks, Online indexing, DMV’s, DMF’s, SQLCMD, T-SQL debugger, CTE, certificates, and symmetric/asymmetric key and dedicated admin connection.

•Experience in maintenance jobs to perform Full, Differential and Transaction Log backups using Simple, Bulk-logged and Full Recovery Model experienced with Database Backup, Recovery solutions.

•Created missing indexes on the tables by running Data Base Engine Tuning Adviser.

•Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.

•Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).

•Experience in DBCC checks, solving Database issues with Index fragmentation, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.

•Experience in using SQL Object Level Audits using Change Data Capture (CDC), Transparent Data Encryption (TDE).

•Managing database systems using Query Governor and Activity Monitor.

•Worked on testing methodologies and tools - Automation and Performance testing.

•Experience in using SQL Object Level Audits using Change Data Capture (CDC), Transparent Data Encryption (TDE).

•Done Troubleshooting work and rectified the bottlenecks to achieve High Availability.

•Experience in providing off hours production support for 24x7 over weekends on rotation basis.

Technical Skills:

Programming Languages

SQL, TSQL

RDBMS

MS-SQL Server 2000/2005/2008/2008R2/2012, Microsoft Access

ETL Tools

SQL Server Integration Services (SSIS) 2005/2008/2008R2/2012, DTS

OLAP Tools

SQL Server Analysis Services (SSAS) 2005/2008/2008R2/2012

Reporting Tools

SQL Server Reporting Services (SSRS) 2005/2008, Crystal Reports

Database Tools

SQL Server Management Studio(SSMS), SQL Server Business Intelligence Studio(BIDS), Enterprise Manager, SQL Profiler, Query Analyzer

Operating Systems

Windows 98, Windows 2000 Advanced Server/Professional, Windows Server 2003/2008/2008R2/2012, Linux, Unix

Data Modeling Tools

Erwin, Red gate, Lite Speed, Idera.

Client: AMAZEAPPS IT INNOVATION (P) LIMITED

Hyderabad, India NOV 2012 – DEC 2014

Role: SQL Server DBA

Responsibilities:

Responsible for installing and maintained 2-Node (Active-Passive), Clustering as a High availability solution.

Responsible in preparing documentation on Disaster Recovery plan.

Implementing, maintaining and documenting the Backup and Recovery plans of all databases.

Responsible for Scheduling Tasks, Setting Alerts, Managing Task Scheduling, setting up SQL Mail, Managing Alerts, Monitoring and Tuning SQL Server, and to suggest the scheduling strategies to overcome Blocking and Dead Locks in jobs.

Analyze the existing application programs and tuned SQL queries using Execution plan, Query Analyzer, SQL Profiler and Database Engine Tuning Advisor.

Create and maintain the Users Security Permissions and Migration of entire database objects between multiple servers and multiple databases.

Actively involved in writing T-SQL Programming for implementing Stored Procedures, Functions, Cursors and Views for different tasks.

Created Views for extracting data and created indexes to improve the performance of the queries.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Rebuilding / Monitoring the indexes at regular intervals for better performance.

Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).

Expert in implementing the snapshot isolation and DDL triggers.

Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Monitored and modified Performance using execution plans and Index tuning.

Rebuilding the indexes at regular intervals for better performance.

Managing of users including creation/alteration, grant of system/db. Roles on various database objects.

Worked on formulating and monitoring the policies, procedures, and standards relating to database management.

Worked on installing, configuring and monitoring the log shipping, Replication and mirroring.

Performed database backups and restores whenever necessary.

Developed documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Worked on database capacity planning, maintenance planning, and SQL Agent jobs and troubleshooting.

Managed and resolved trouble tickets for database-related issues submitted by customers.

Environment: SQL Server 2012/2008 Enterprise, Windows Enterprise Server 2012, .NET, Microsoft Visio, SFTP, Microsoft Reporting Services.

EDUCATION:

•Bachelors from Jawaharlal Nehru Technical University, Hyderabad, India.

•Masters in Computer Science from Southern Arkansas University, Arkansas, USA.

Contact this candidate