OBJECTIVE:

An enthusiastic, self - motivated and initiator professional seeking for the position of Database Administrator that utilize state-of-the-art, software and hardware components with a creative, technology-driven organization in an environment that encourages innovative thinking, recognition and career development

PROFESSIONAL SUMMARY:

• 8+ years of experience with installation of Microsoft SQL Server in Production, Development and Testing in Clustered and Stand-alone Server Environments on both 32-bit and 64-bit systems
• Sound experience in Installation, Configuration and Administration of SQL Server 2005/2008/2008 R2/2012/2014 versions
• Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2000/ / 2008 R2/2012/2014
• Experience implementing and maintaining AlwaysOn Availability Groups as High Availability and Disaster Recovery solution on SQL server 2012/2014
• Extensive experience in implementing Disaster Recovery solutions like Log Shipping, Database Mirroring and Replication
• Experience in analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects
• Experience implementing Transparent Data Encryption(TDE) on Production systems
• Recovered many databases to point in time or maximum possible data in many cases during database corruption or accidentally dropped objects due to human errors
• Configured SMTP Server for Database Mail setup and received alerts for the Threshold values
• Extensively involved in 24/7 Production support of the databases and round-the-clock database operations
• SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, Capacity Planning, Backup and Recovery of mission critical databases
• Supported over 600+ SQL 2000/2005/2008 servers and 900+ databases in clustering environment (A/A, A/P) and databases over 600GB in size
• Import and export data (Prod to Dev to QA, QA to Prod)
• Technical Lead in charge of migrating over 180 databases from SQL Server 2005 to SQL Server 2008/2008R2 and SQL 2008 to SQL 2012
• Extensively used native tools like index tuning wizard, Database Tuning Advisor, SQL Server Profiler, Performance Monitor, Event Viewer, Activity Monitor for performance analysis
• Ability to troubleshoot day-to-day problems encountered on production as well as development database environments
• Experience in writing complex T-SQL queries including Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Experience working in PowerShell Scripting and Batch Scripting
• Expert in Performance Tuning for Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal partitioning
• Rebuilding indexes with different fill factors and updating statistics
• Expert in using DMV’s, DMF’s, System Views, Trace Flags and DBCC commands
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation, loading) with DTS/SSIS, Data Cleansing and Reporting Services (SSRS), Crystal Reports
• Extensive experience working with Data marts and Data warehouse environments
• Explicitly used third party tools like Lite speed, Fog light, Spot Light and Tivoli Storage Manager (TSM), EMC Networker (Backups)
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID
• Auditing of database and worked on logins, user permissions and security in SQL server level and fixing orphaned users while migrating databases from one server to another server
• Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables
• A hands-on SQL Server Database Administrator (DBA) and Web Administrator with a proven track record of team leadership and technical skills
• Keeping up to date with latest technology and features

TECHNICAL SKILLS:

Languages: T: SQL, PL/SQL, MySQL, MDX, HTML, CSS, XML, C, C++, C#, Visual Basic, Perl, JavaScript, UNIX

Operating Systems: Microsoft Windows7/Vista/XP/2000/98/95, Linux, Windows Server 2012/2008

Databases: MS SQL Server 2014/2012/2008 R2/2005, Oracle 11g,10g,9i, DB2, Oracle Hyperion, MS Access 2012/2008

ETL Tools: SQL Server Integration Services (SSIS 2012/2008 R2/2005)

Reporting Tools: SQL Server Reporting Services (SSRS 2012/2008 R2/2005), Crystal Reports, Tableau 8.x

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

Tools: /Utilities: Red Gate(SQL Compare, SQL Monitor, SQL Backup, SQL Doc), Quest(Now Dell) Lite Speed, Spotlight, Performance Management suite, Idera(SQL Safe, SQL compliance manager), IBMTivoli, SQL Diagnostic Manager, EMC Networker

PROFESSIONAL EXPERIENCE:

Confidential, Greenwood Village, CO

Senior Database Administrator

Responsibilities:

• Worked as project lead for around 80 migration projects involving migrations from SQL 2000/2005 to SQL 2008 R2 initially and then to SQL Server 2012/2014
• Handled DB Migrations of 1-2 TB critical databases with least outage possible
• Supported around 150 DB Instances and 50 applications as Primary DBA
• As DB Migration lead, worked on Install, configure and maintain different versions of SQL Server database systems
• Largely responsible for providing operations database services to the organization
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking, connectivity issues, security etc.
• Troubleshoot CPU, Memory, I/O, disk space and other resource contention issues
• Provides 24/7 On call support of all critical applications
• Document and train technical business approaches/solutions, complex data issues to lower level administrators
• Setup database security and maintain accounts and access levels by creating suitable logins, roles and assigning object level permissions
• Setup Always On high availability for SQL Server 2012/2014 database servers based on application need and RTO/RPO intervals
• Experience in importing/exporting between different sources like Oracle/Access/Excel using SSIS/DTS Utility
• Transformed data from one server to other using tools like Bulk Copy Program, SSIS etc.
• Experience in creating configuration files to deploy SSIS packages across environments
• Providing inputs for developing newer versions of databases customized to peculiar needs
• Implemented data partitioning of large tables
• Implemented EMC Networker backups for easy recovery of databases
• Worked on implementing Transparent Data Encryption for critical databases
• Implemented Ola hallogren script for rebuilding indexes and updating statistics which can be customized based on application

Environment: SQLServer2005,2008R2/2012/2014,Windows 2003/2008/2012 , VisualStudio 2010, EMC Networker, SSMS, SSIS, SSRS, BIDS, SSDT

Confidential, Des Moines, IOWA

Sr. SQL Server DBA

Responsibilities:

• Installed, Configured and administration of SQL Server 2012, 2008, 2008R2 and 2005
• Scaling and configuring the new server builds.
• Configured and managed virtual Servers and worked on virtualization and clustering environment
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Commitment to SLA based on ticketing system where responding time with 15 minutes to production and 45 minutes to other environments.
• Successfully migrated SQL SERVER 2005 to SQL SERVER 2008/2008R2 and SQL SERVER 2008 to SQL SERVER 2012
• Tested and applied latest service packs on SQL 2005/2008/2008 R2/2012
• Experience working with Oracle 11g/11g R2 on Unix/Linux Environments
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy
• Configuring and Troubleshooting Transactional Replication
• Extensively configured Log Shipping and addressing issues with it during day and on-call
• Implemented and maintained AlwaysOn Availability Groups as High Availability and Disaster Recovery solution on SQL Server 2012
• Experience with performing DR tests periodically for mission critical application.
• Automated daily Database Refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2000, 2005, 2008, 2008R2 and 2012 versions
• Implemented Data Partitioning to improve the performance of large table to reduce contention and increase availability of data
• Developed and implemented customized maintenance plans to meet the needs and keep up to date with the glitches and fixes for performances issues
• Develop and implement scripts in development and production environments for performance tuning and automating scripts through jobs
• Developed scripts using Windows PowerShell and automated them using Jobs
• Setting up Backup and Restore Strategies using Lite Speed tool and Automating them with scripts
• Document custom database installation procedures, security standards based on environment and SLA and keep update the inventory of servers periodically.
• Involved in Change Management, Problem management activities using BMC Remedy tool before implementing database changes in production.
• Worked with DacPac and IsPac for deploying SQL Server Objects to instance of SQL Server
• Checking the threshold values and baselines and monitoring in perfmon and SCOM 2012.
• Determined hardware and software requirements for SQL Server version 2005 and 2008/2008R2.
• Managed databases on multiple disks using RAID technology.
• 24-hour On-call support during off-hours on rotation basis.
• Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards, Execution Plans
• Used Spot Light, Fog Light tools for Performance Monitoring
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance
• Experience in writing good standard T-SQL queries, Stored Procedures, Functions, Views, Triggers
• Install and configured Report Servers and designing SSIS packages for refresh the report databases over nightly
• Designed Complex SSIS Packages for Data migration from various heterogeneous sources like Oracle, MYSQL, DB2, XML, SYBASE
• Experience working with Crystal Reports

Environment: Windows 2003/2008/2008 R2, SQL 2000/ 2005/2008/2008 R2/2012, MySQLDB2, SYBASE, TSQL, WINDOWS POWERSHELL, Replication, SSIS, SSRS, Database Mirroring, MS clustering, Lite Speed, MOM 2005/2007, NETIQ, HP SM7, Spotlight, Fog LightCitrix, Oracle, OEM, ASM, Agile and Scrum Methodolgy

Confidential, Birmingham, Alabama

Sr. SQL SERVER DBA

Responsibilities:

• Installed SQL Server 2008/2008R2 on both 32-bit and 64-bit systems
• Configured more than 2GB RAM on 32-bit environment
• Involved in Migration of SQL Server 2005 to SQL Server 2008 R2
• Involved in installing, configuration and administration of log shipping, Replication Snapshot Replication and Transactional Replication and Mirroring based on business requirement
• Worked on Active-passive and Active-Active Cluster environments VMware Environment
• Installed and Configured more than 50 Clustered SQL Instances
• Installed Service Packs and Builds
• Worked on Slip stream installations
• Developed and implemented scripts in Production for performance tuning
• Provide support to application developers in designing and implementing physical database structures
• Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2008/2008R2
• Lead in charge of migrating over 80 databases from SQL Server 2005 to SQL Server 2008/2008R2
• Designed DR plan, database backup and restore plan to point in time
• SQL Server performance statistics collection, Server monitoring and performance tuning using perfmon, SQL Server profiler and Index tuning advisor
• Managed Disk space, memory and User connections
• User account management and connection troubleshooting issues with application team
• Database Capacity Planning, Maintenance planning, SQL Agent Jobs scheduling and troubleshooting
• Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
• Rebuilding the indexes and updating statistics at regular intervals for better performance
• Worked on Performance Monitoring of SQL Server using IDERA tool
• Developed Conceptual model based on business requirements, designed logical model based on conceptual and finally designed physical model for build of new database
• Installed and Configured SSRS and Deploying SSIS packages
• Incremental Loading of data from OLTP to OLAP (Datawarehouse) environments through SSIS Package
• Worked in setting up the SQL Server Configuration settings to resolve various resource allocation and memory issues for SQL Server databases and to setup min/max server memory, maximum degree of parallelism(DOP)
• Formulated and monitored policies, procedures, and standards relating to database management
• Provided project leadership within a functional database area of specialization
• Manage and resolve trouble tickets for database-related issues submitted by customers

Environment: Windows 2003/2008/2008 R2, SQL 2000/ 2005/2008/2008 R2, Oracle 11/11g, MYSQL, DB2 TSQL, PowerShell, Replication, SSIS, SSRS, SSAS, Database Mirroring, MS clustering, Lite Speed, MOM 2005/2007, SAN and IDERA

Confidential, San Francisco, CA

SQL Server DBA

Responsibilities:

• Installation and Maintenance of SQL Server 2005/2008(R2) on Test, Development and Production Environments.
• Installation of SQL Server 2008/2005 on Windows Server Clustered environment.
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
• Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
• Implemented Database Mirroring, Transactional Replication and Cluster Active-passive as a part of DR plan.
• Disaster Recovery Planning, Testing and Analyzing, continuous update of documentation.
• Migration of SQL Server 2005 databases into SQL Server 2008 and SQL Server 2008 R2.
• Patching SQL servers for the new service packs released
• Create and manage databases across Development and Production instances using SQL Server Management Studio
• Created Data Models based on logical and physical models for building new database
• Involved in Capacity Planning, Database Normalization and De-normalization process.
• Involved in Monthly Activities like Refreshing databases from production to test environment.
• Implementing Change management processes to prevent production disruptions and outages.
• Pro-actively monitoring and managing SQL Server performance like disk space issues, Log file full and backup failures.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Worked on call 24/7 Support on weekly basis

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2000 and 2005, Windows 2003/2008 Server, Share point, IIS 6.0, SCOM, OEM and VERITAS Net Backup.

Confidential, NJ

SQL DBA

Responsibilities:

• Installed and configured SQL Server 2005/2008/2008 R2
• Configured more than 2 GB ram on 32 bit Environment
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Worked on migration and maintenance of data using various utilities like DTS, EXPORT, IMPORT and ATTACH/DETACH Data Migration tools.
• Created & maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions and other schema objects.
• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Dropped and recreated the indexes on tables for performance improvements.
• Experience in applying Service Packs at database and OS Level
• Experience working with High Availability and Disaster Recovery solutions like Log Shipping, Replication, Mirroring and Clustering
• Interacted with development team and assisted them in optimizing SQL Queries and Stored Procedures.
• Scheduled the backups for Databases and Transaction log. Performed restoration operations.
• To set up SQL Server configuration settings.
• Rebuilding the indexes at regular intervals for better performance.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Provided necessary data validation checks against the data entry.
• Frequently ran DBCC checks to maintain consistency.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000/2005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET,TSQL, Microsoft Reporting Service.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Installation of SQL Server 2008/2005, service packs, hot fixes, security patches
• Implemented and maintained Database mirroring as a Disaster Recovery Solution
• Worked on the migration of SQL Server 2000 to SQL Server 2005
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005
• Update statistics, database integrity check and Backup operations
• Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages
• Designed and implemented comprehensive Backup plan and disaster recovery model
• Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
• Created and modified Stored Procedures and Functions to generate reports
• Used log shipping for synchronization of database
• Implemented AWE /PAE switches for SQL Server to grab more than 2 GB RAM
• Configuring Perfmon, blocking analysis, Max degree Parallelism
• Practical experience in managing the internal and external MS SQL database security
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Responsible for creating user groups and assigning permissions
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Familiar with taking backup using Litespeed tool
• Involved in validating credit card number using regular expressions.
• Provided back-end support for functional testing and performance testing.

Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWINMS Access, Toad, Excel.

Confidential

SQL Server DEVELOPER

Responsibilities:

• Created Database tables with constraints and relationships between multiple tables.
• Created Views, User Defined Functions and Triggers.
• Extensively used VB coding and HTML
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
• Performed various data transfers between various servers using BCP and DTS.
• Supported team in resolving in DTS and T-SQL related issues.
• Involved in performance tuning and query optimization.
• Involved in documenting the entire technical process
• Created reports using 3rd party tool like Crystal Reports
• Supported technical teams involved with MS SQL issues and operations.

Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0.