SUMMARY

• SQL Database Administrator
• Six years of hands - on experience on a production and development environment, medium to large projects.
• Problem solver, self-starter, adaptable, can-do attitude, quick learner (love to learn new technology and involve in development projects).
• 24/7 call support, understanding of business need and flexible in working weekend and overnight on call/rotation and stretched to meet business need and deadlines

TECHNICAL SKILLS:

• SQL/T-SQL Scripts
• Store Procedures
• Triggers
• Functions SQL/T-SQL Script writing
• Data Modeling/Design
• SSRS
• SSIS
• ETL

PROFESSIONAL EXPERIENCE

SQL Server Database Administrator/Developer

Confidential

Responsibilities:

• Confidential, Configured and managed SQL Server 2008/2012/2014 /2016.
• Designed and configured logical and physical database models for OLTP and OLAP 
• Built database schema & objects such as tables, triggers, views, stored procedures & indexes.
• Configured MDW database to store data using Data Collector and did trend analysis.
• Set up database maintenance plan, back-up & restore strategies and procedures
• Creating and automating jobs, database mail, operators and alerts. 
• Expertise in T-SQL writing, stored procedures, triggers, indexed views and functions 
• Proficient in configuring/implementing mirroring, log shipping & replication.
• Monitoring servers & tuning performance using native, 3rd party tools and DBCC commands
• Used Dynamic Management Views (DMV) to monitor SQL Server, troubleshoot the performance bottleneck/issues and proactively worked on to minimize downtime
• Evaluated the peak/no peak usage pattern of the application; effectively distributed database administration activities, such as full backup, Bulk Insert, index maintenance and database defragmentation during no peak hours. 
• Worked on applying patching service packs, cumulative updates and hot fixes for MS SQL server.
• Expertise in SQL server audit, policy based management & transparent database encryption 
• Proficient in performance monitoring, tuning, query optimization and database integrity.
• Expertise in data Extraction, Transformation and Loading (ETL) tools.
• Responsible for maintaining SQL Server security and granting access to users as per requirement and database security policies, procedures.
• Experienced in database upgrade and migration.

SQL Server DBA

Confidential

Responsibilities:

• Implemented SQL Server HA features, DR strategies and Troubleshooting.
• Confidential and Configured SQL Server 2008/2012/2014
• Wrote T-SQL Scripts, stored procedures, triggers and functions.
• Worked on conceptual, logical and physical database modeling.
• Experienced in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, DBCC, Built in performance Report and Activity Monitor. 
• Moving TEMPDB folder to another drive on Production Environment to improve Performance. 
• Proficient in implementing of Replication models like Snapshot, Transactional, Merge. 
• Experience in Implementing Database Mirroring in SQL server 
• Successfully implemented Log shipping by placing the secondary database in Read-only mode
• Worked on data security and user management.
• Identified and troubleshot performance issues, index analysis and maintenance.
• Performed bulk load, import/export, backup, copy database and attach/detach.
• Proficient in migration of Data from Excel, Flat file, Non-SQL db's to MS SQL Server by using SSIS.
• Working knowledge in SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) to manage ETL environment.
• Expert in job automation, scheduling jobs (backup, disk alert, optimization, integrity check, reporting)

SQL Server DBA/Developer

Confidential

Responsibilities:

• Confidential MS SQL Server2005/2008, Performed Database Design and created User Databases
• Wrote T-SQL Scripts, stored procedures, triggers and functions.
• Worked on conceptual, logical and physical database modeling of OLTP and OLAP
• Worked on maintaining database security (logins, users, database/server roles and granting/revoking permissions). 
• Improved the database performance by rebuild / reorganize indexes based on index fragmentation threshold.
• Designed and implemented comprehensive backup plan and disaster recovery strategies.
• Worked on performance tuning and troubleshooting to ensure performance, integrity and concurrency of databases.
• Performed SQL server service pack and windows service pack upgrades.
• Analyzed long running queries, fix issues to optimize application & system performance.
• Performed migration of the databases from SQL Server 2008 to SQL server 2012.
• Excellent knowledge in database recovery during emergency/data file missing/log space full 
• Scheduled backup/restore operations for system test data depending on developers' requirement.
• Created maintenance plan and SQL server jobs and scheduling them, setting emails alerts on failure. 
• Managed Disk space, memory and User connections.
• Tuned SQL Server using DMVs, SQL Profiler and Windows Performance Monitor.
• Detected/troubleshooted SQL Server related CPU, memory, I/O, disk space, and other resource contention.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing. 
• Used DBCC checks and fixed data corruption in Application databases.
• Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
• Responsible for stored procedures optimization, performance tuning & index maintenance.