PROFESSIONAL SUMMARY:

• 7+ years of Database Administration and Development experience on MS SQL Server 2000/2005/2008 R2/2012/2014 in OLTP and OLAP environments
• Experience in installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014 & updating with hot fixes and service packs
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts
• Extensive experience in implementing High availability and Disaster Recovery solutions like Always - On Availability groups, Replication (Snapshot and Transactional), Log shipping and Mirroring on physical and virtual machines
• Extensively worked on Active-Active and Active-Passive Clustering
• Implemented new features in MS SQL Server 2012 like Always On HADR in production and non-production environments
• Implemented Side by Side Migration of MS SQL SERVER R2 and 2008R2 to 2012
• Experience in developing T-SQL (DDL, DML, and DCL) statements
• Experience in Migrating DTS 2005 packages to SSIS packages in 2008 using Migration Wizard
• Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor and Transparent Data Encryption (TDE)
• Expert in Data Integrity, Performance Tuning, Query Optimization
• Expert level skills in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers, Views and other SQL Joins and Query writing.
• Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
• Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
• Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003 Server
• Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, Updating Statistics
• Expert in analyzing the execution plan and index management for better Query Optimization
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values
• Created effective Backup and Recovery plan by Transactional Log and Full Database Backups and utilized to recover data in point in time in case of disaster of server
• Extensively used third party tools like Lite Speed, Fog light and Red gate
• Auditing of Database for user’s transactions, login and database action and removing orphan users
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, excel files, legacy systems and loading into SQL server
• Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
• Experience in creating SQL Server Reports using SSRS 2005 and 2008
• Experience working on VMware environments
• Experience working with Change control process/Change management
• Extensively worked in 24*7 Production environment

TECHNICAL SKILLS:

Languages: C, C++, T-SQL.

RDBMS: MS SQL Server 2012, 2008R2, 2008, 2005, 2000, MS Access.

Tools: SQL Server Management studio, SSIS, SSRS, SSAS, Performance Monitor, Backup Utility, TDP/TSM, Lite speed, VSS, TWS, IderaWeb Server Technologies: IIS 5.1/6.0.

Data Modeling Tool: Visio 2003, Office Visio 2007

Operating System: Windows 2012/ 2008, 2003, 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

PROFESSIONAL EXPERIENCE:

Confidential, Whippany NJ

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008 R2 on Prod and Non-Prod environments.
• Configured HA & DR techniques like replication (snapshot and transactional), mirroring, log shipping and clustering on virtual and physical environments
• Worked on side-by-side migrations of SQL server
• Applied service packs as a part of standardization project
• Implemented SQL server auditing to collect data for quarterly audits
• Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler and DMV’s to find the resource bottlenecks
• Resolve locking and blocking issues
• Refresh non-prod environments with production data on regular basis
• Implemented data availability solutions like online restore, online index, database snapshot and fast recovery
• Worked on complete backing up of database and restored the database from Disaster Recovery
• Provided RAID level suggestion for data files, log files and tempdb drives
• Used Index tuning wizard for optimal query performance
• Monitoring SQL Server logs, Application logs and analyzing the logs
• Reorganizing or Rebuilding Indexes based on the Index fragmentation
• Implementation of SQL Logins, Roles and Authentication Modes as a part of security policies for various categories of users
• Creating backup strategies and scheduling them as a part of database maintenance plans

Environment: SQL Server 2000/20 R2, Windows 2003/ 2008/ 2008 R2 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008R2.

Confidential, Louisville, Kentucky

SQL Server DBA

Responsibilities:

• Responsible for maintaining production databases, supporting development and QA environment
• Clustered and non-clustered index creation/optimization using SQL Profiler and Index Tuning Wizard
• Full, Differential and Transaction Log backup strategies
• Configured log shipping as part of recovery strategy
• Created and maintained technical documentation
• Installed, configured and maintained failover clustering for SQL SERVER 2005.
• Created jobs, alerts, log to monitor the database errors
• Involved in various stages like Development, Testing and Support
• Deployed functions, triggers, stored procedures, databases, and views
• Enhancing the existing databases and database modeling
• Support for ongoing databases
• Daily routine DBA tasks like handling user’s permissions and space issues on production and handling maintenance jobs including backups and restores
• Used SSIS to Export/Import data
• Design and normalize the databases and created different objects like tables, views, stored procedures on MS SQL server
• Production code deployment and handling concurrent user requests
• Using SQL Agent to setup and automate internal processing tasks and backup tasks as well as setting up alerts to monitor the server and database health
• Provided analysis and recommendations for setting up a comprehensive backup and recovery strategy for SQL Servers
• Security Implementation, administering the MS SQL server by creating user’s logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups
• Testing of applications for performance, data Integrity
• Performing regular consistency checks for database consistency using DBCC commands and re-index/index-defrag tables on a scheduled basis
• Monitoring and fixing replication issues
• Database and log backups and restoration, backup strategies, scheduling backups
• Managing the use of disk space, memory and connections

Environment: SQL Server 2012/2008/2005, Windows 2008R2, 2008/2003, SSIS, SSRS, Idera SQL Safe, Evault, Red Gate, ignite

Confidential, New York. NY

SQL Server DBA

Responsibilities:

• Managing and administering SQL server instances which include 2000/20 R2/2012
• Migration and upgradation of databases to different version
• Implemented and maintained Always ON new concept in SQL 2012
• Managing the database server’s security as per the MSB policy standards
• Managing all aspects of physical SQL Server database administration, which includes security setup and enforcement, ID creation, installations, upgrades, patching, troubleshooting and tuning
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance jobs
• Handled monthly database refresh in QA-Test environment for testing of new deployments and build
• Implemented high availability solutions, including clustering, database mirroring
• Routine DBA jobs like backups and restores
• Manage regularly scheduled backups and occasionally a database recovery
• Implemented SQL data compression using SQL server 2008 for compressing data and log files, backup level
• Working with application development team in implementation of data definition changes and performance analysis of complexT-SQL queries
• Worked with the table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level
• Worked with Transparent Data Encryption, table compression, database compression and merge statements
• Used Policy Based Administration feature (SQL Server 2008).
• Compare and synchronize your database schemas or data by using REDGATE
• Performing backup/restore to/from Legato server (Tape) and Disk
• Tuning queries, which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
• Extensively used TSM, Litespeed backups
• Created new database objects like tables, procedures, functions, indexes and views using T-SQL in development and production environment for SQL Server 2012
• Worked in Active Passive cluster environment as a High Availability solution.
• Recovered the system and user databases from suspect mode
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Used log shipping for synchronization of databases
• Prepared documentation for the Disaster Recovery plan
• Designed data Integrator jobs with error handling and email notifications
• Managing Databases spread across multiple servers in production, development, staging & testing environments
• Expert in Performance tuning of the stored procedures
• Checking database health by using DBCC commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Participating in 24X7 on call primary pager support

Environment: SQL Server 2012/2008/2005, Windows 2008, 2003, SSIS, SSRS, SQL LiteSpeed

Confidential, Brooklyn, NY

SQL Server Administrator

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008 in production, development, QA and staging environments
• Provided primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008 R2/2008/2005)
• Upgraded to SQL Server 2008 R2and guiding the development and application team to fully utilize SQL Server 2008 R2 enhancements
• Created Merge replication between different data centers
• Monitored databases for Dead Lock, capturing long running SQL queries, used HINTS for fine-tuning SQL statements
• Used SQL Server Profiler to monitor the server by running traces on various events like user connections, stored procedure execution time etc.
• Evaluated the database performance of index tuning with using DTA to resolve performance issues
• Setup and configured SQL Server for other business functions
• Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis
• Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc. for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks
• Responsible for SQL Server tuning, performance evaluation, optimization and utilized new features like SQL Dynamic Management Views for the same
• Used Visual Source Safe 2008 for version control. Created various Stored Procedures to enforce the business logic
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP
• Handled performance tuning and optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally
• The SSIS packages created included a variety of transformations, for example slowly changing dimensions, look up, aggregate, derived column, conditional split, fuzzy lookup, multicast, and data conversion
• Responsible for identifying and defining data source and data source views mappings for ETL
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes
• Monitored Full/Incremental/Daily loads and support all scheduled ETL jobs for batch processing.
• Provided primary pager support on rotation basis

Environment: SQL Server 2005/2008, Windows 2008/2003/2000 Server, SQL LiteSpeed 4.5, DTS, Replication, MS Access, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler Idera SQL Safe.

Confidential

SQL Server DBA

Responsibilities:

• Provided production support for SQL Server on 24/7 environment
• Supported a large data center using 120 SQL Servers running on Windows 2000/2003/2008
• Performed day-to-day database maintenance tasks -- database monitoring, backups, space, and resource utilization, responsible for performing database refresh from production to UAT database
• Migrated database from SQL Server 2000 to SQL Server 2005 and 2008
• Configured and setup SQL Server 2008 fail over cluster for Hydroone.com, CRM and Share Point
• Designed high availability database infrastructure
• Worked with developers and vendors to install 3rd party software
• Managed and maintained Data Warehouse and Data Mart applications and databases
• Responsible for database security, backup, recovery, performance tuning for databases and applications, user administration, and capacity planning
• Installed, configured, secured SQL Server 2005/2008 Fail over cluster, database replication, mirroring reporting service and analysis Server
• Troubleshoot database performance issues and tuned database objects
• Set up traces and Profiler to troubleshoot performance issues
• Analyzed deadlocks & diagnosed issues on the server
• Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc.
• Monitored log files to resolve issues
• Planned, tested and performed major upgrade of SQL Server 6.5, 7, 2000 to SQL Server 2005 and SQL 2008

Environment: SQL Server 2005/2008/2008 R2, Windows 2003/2008/2008 R2, SSRS, SSIS