Objective

• A proactive, enthusiastic, innovative, constructive and result oriented professional with more than 9 years of experience.
• Seeking an opportunity to provide, invest and prove my skills as expertise SQL Server Database Administrator.

SUMMARY

• Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Migrated SQL Server 2008 to SQL Server 2012, SQL Server 2000/2005 to SQL Server 2012 and 2008 R2 versions.
• Installed & configured database software, associated database tools and performance monitoring software.
• Database consistency checks using DBCC utilities and server connectivity.
• Conducted research and collaborated with vendor if necessary for additional patches.
• Researched, reviewed and recommended for preventive maintenance.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Performed acceptance testing to verify that database changes perform without adverse consequences.
• Estimated disk storage requirements for database software, database files & database administration needs.
• SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Participated in meetings impacting databases physical design.
• Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
• Implemented & managed database clustering, failover and load balance technologies as per client requirement.
• Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
• Scheduling Backups and Restore, Log Shipping and Maintenance plans using Native & Third - party tools (LiteSpeed and SQLSafe Backup).
• Conducted root cause and analysis for database incidents and problems.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Escalated database issues to appropriate approvers (if applicable).
• Set up security and access profiles and procedures for database system administrators.
• Managed security by defining roles and rights.
• Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
• Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement.
• Interfaced with database vendors & client technical support teams to isolate & resolve database related problems.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node.
• Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Provided & managed support to Environment of more than 500 Database Servers.
• Proven ability to handle Database of more than 1 TB in Size.
• Set up AlwaysOn, Database Mirroring, Log Shipping, MS SQL Mail.
• Scanned the data pages, Indexes and checked the storage space used by each table.
• Suggested, developed & implemented Scaling out solution with Data partitioning and Data Compression techniques.
• Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications.
• Designing and Deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).

TECHNICAL SKILLS

Databases: MS-SQL Server 2000/2005/2008/2012 , Oracle, MS Access.

Languages: C, C+, T-SQL, VB Script, Java Script, HTML, XML.

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export & Import, Precise i3 for SQL Server, Idera SQL Safe and SQL Diagnostic Manager.

Operating system: Windows / 2003/ 2000/ Professional/ NT 4.0 Advanced Server

OLAP Tools: SQL Server Analysis Server 2008, 2005, SSIS (as ETL)

Load Test Tools: WAPT, WAPT Pro

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

SQL Server DBA

Responsibilities:

• Installed SQL Server 2012 on Integrated Platform and migrated databases from SQL 2005.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY
• Identifying orphaned users and ghost accounts, removing them by transferring schema ownerships and authorizations.
• Certifying Service Packs and Cumulative Updates to be implemented into production environment.
• Installed latest SP’s and CU’s on standalone and clustered SQL 2008/2008 R2 and SQL 2012 servers.
• Scheduling and monitoring Backup jobs (native and SQL Safe).
• Configured AlwaysOn with three replicas for providing HADR.
• Created and configured AG listeners.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.

Environment: Windows 2003/2008, MS-SQL Server 2012/2008r2/2005, .NET Framework, Visual Studio, SSIS and SSRS, IDERA tools SQLSafe and SQL Diagnostic Manager.

Confidential, Hazelwood, MO

Sr. SQL Server Performance Analyst/ DBA

Responsibilities:

• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• Migrated databases from SQL Server 2005 to SQL Server 2008R2 and Sql Server 2012.
• Expertise in running Load Test using WAPT Tool, and Capturing Long Running Query’s in the profiler and Fine Tuning the Stored Procs.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• 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.
• Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Installed Sql Server 2012 and configured AlwaysOn with Primary and secondary Replicas, Read only databases, listener and with Application Intent.
• Experience in writing scripts like retention of data using batch deletes.
• Incremental loading of dimensions, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files.
• Created SSIS/DTS packages for Finance application that would transfer data among servers to perform other data transformations and scheduled the same SSIS packages by creating the corresponding job tasks.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.

Environment: MS SQL Server 2012/2008R2/2005, T-SQL, SSIS, SQL Safe, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering and AlwaysOn. Windows 2003 and Windows 2008R2 Server.

Confidential, Cleveland, OH

Sr. SQL Server DBA

Responsibilities:

• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008r2, 2005.
• Conducted Database mirroring in High Performance and High Availability mode and trouble shooted issues with witness servers.
• Expertise in registering a SPN for Kerberos Connection and Performing NTML Failback.
• Implemented Kerberos Delegation with SSRS.
• Performed daily backups and developed recovery procedures
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshooted issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Involved in Capacity Planning, data modeling and Logical/Physical database Design
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

Environment: Windows 2003/2008, MS-SQL Server 2012/2008r2/2005, .NET Framework, Visual Studio, i3 performance tool, SSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, AJAX, Visual Studio, HTML, XML, XSLT.

Confidential, San Antonio, TX

Sr. SQL Server Database Administrator

Responsibilities:

• Planned and Successfully Installed SQL Server 2005, 2008 on the Production and
• Development Servers.
• Successfully Installed the Service Pack 2 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.
• Involved in migrating the existing 2000 databases to SQL Server 2005 (Side by Side).
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/
• Development servers as per requirement.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up with the customer approval, for making any changes in the production server
• On call 24/7 support to databases on weekly rotation.
• Experience with SSIS,SSAS,SSRS
• Used SSRS to build health check reports & deploying the SSRS.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows XP/2000 and Windows 2003 Server.

Confidential, Cranbury, NJ

Sr. SQL Server DBA

Responsibilities:

• Installed SQL server 2008 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• Installed and Configured MS SQL Server 2008 R2, and responsible for configuration, tuning and provide support to all Production and development servers.
• Maintained database response times in 24X7 Production environments, proactively generated performance reports. Automating most of the DBA Tasks and monitoring stats.
• Planning and implementation of database backup/restore and disaster recovery.
• Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Using SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Creating DTS Packages migration of data across different servers and other databases such as Oracle, Sybase and DB2 UDB.
• Implemented MS SQL Server security policies and granted object level permissions.
• Developed Cubes using SQL Server Analysis Services (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: SQL Server 2005/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Teradata, DB2 UDB

Confidential, PA

SQL Server DBA/ Developer

Responsibilities:

• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Scheduling SSIS jobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.
• Involved in Health Check process for database and monthly auditing of the servers.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005/2008, which includes in-place, side-by-side and standalone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2005 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

Environment: SQL Server 2000/2005 with Clustering, MS Access, VMware ESX, Windows 2000/2003, Lite speed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
• Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
• Used Index Tuning Advisor for Database performance for proper indexes.

Environment: SQL Server 2000/2005 Windows NT/2003, VERITAS Net Backup and Crystal Reports.