SUMMARY:

• Worked on SQL Server 05/08/2012 and 2014 Servers DBA in Windows and also Azure environments.
• Experience in Upgrade/migration of several instances and databases from SQL Server 2005 to SQL Server 2008, from SQL Server 2008 to SQL Server 2012 and SQL Server .
• Experience configuring and working with Microsoft SQL server 2005, 2008/R2, 2012, 2014 on VMware/Hyper - V Environment
• Working experience with quarterly and half yearly Disaster Recovery activities.
• Involved in preparing DR planning, Recovery & testing steps.
• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication with different topologies for production databases.
• Experience in Server administration in various environments - Window 2000, 2003, 2008 and 2012 with Active Directory Services (AD, DNS, and DHCP).
• Involved in SQL Server Migration Projects from 2008/2005 to SQL 2012 and 2000/ /R2
• Successfully lead the Project for Implementing SQL Server Virtualization on VMware Dedicated Datacenters (ESX Servers).
• Installed and configured SQL Server R2 / 2005 Clusters in Active/Active and Active/Passive for high availability.
• Worked on Backup, Recovery and Performance tuning of Very Large Databases (VLDB).
• Implemented High Availability and Disaster Recovery using Mirroring / Log Shipping.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery.
• Performed Capacity Planning, data modeling, and Logical/Physical database Design.
• Conducted risk evaluation of database security for enterprise wide SQL server Databases and managed mitigation of identified areas with diverse teams in a record time.
• Expertise in using tools like Windows Performance Monitor, Database Engine Tuning Advisor, SQL Profiler, and SQLDIAG utilities from Microsoft.
• Implemented the new SQL Server 2012/ 2008 R2 mechanisms like data compressions, online indexing, Contained Databases.
• Extensive experience in Power shell, Windows scripting, VB Scripting and T-SQL in automating server build process and various database management activities.
• Worked with cloud companies Rack Space and Microsoft Azure to setup SQL Server instances.
• Data Import/Export using SQL Server Integration Services across different database platforms like Oracle, SQL Server and MS access.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Experience with SSIS / SSRS Administration work.
• Database Installation, Designing, Administration and troubleshooting database servers like MySQL 5.6, MySQL 5.5, MySQL 5.1 on Windows, Linux platforms.
• Installation and Maintaining MySQL enterprise and community versions, Installation of MySQL cluster7.3/7.2 database instances in production environment and setup of configuration files.
• Configuration and Setup of various MySQL performance monitoring tools like Nagios and MySQL enterprise Monitor for monitoring MySQL Servers.
• Creation of events for scheduling jobs in MySQL.
• Experience with other databases like Installation of Oracle database on Linux Red Hat and Windows Server.
• Proven ability to deliver productivity and quality improvements through well-managed, on-time Projects.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2012/ 2008/R2, 2005

BI Tools: SSIS SSRS 2012/2008/2005

Operating Systems: Windows 2012 R2 / 2008R2 / 2008 and 2003, RHEL, Ubuntu, CentOS

Languages: VB script, WMI Scripting, HTML Scripting, T-SQL, Python

Version Control: Team Foundation Server (TFS), Visual Source Safe

Virtual Environment: VMWare (ESX Servers), Hyper-V

DB Monitoring Tools: Quest Performance Analysis, Performance Monitor, SQL Server DMVs

HA/DR: SQL Server 2012/2008 R2 Clustering, Always-On, Mirroring and Log Shipping

Hardware Tool: HP ProLiant DL385, DL380 G7/G6

DB Netback up tools: VERITAS and Tivoli storage Manager

Other Tools: Compaq Insight Manager, Idera Diagnostic Manager, Quest, Dells Lite Speed, Quest Enterprise Software, SQL Lite speed, CHEF, ERWIN, Crystal Reports, SSRS, MySQL Workbench, MySQL Administrator.

WORK EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Managed and Administrated the SQL Server 2008R2/2012/2014 production and Non-production servers.
• Assisted Windows Admin in order to determine editions, service packs on Windows Server 2003/2008 to configure custom High Availability Solution and Disaster Recovery Strategy
• Installation of SQL Server 2008R2/2012/2014 on Windows Server Clustered environment.
• Worked on Conceptual, Logical, Physical data modeling and Performance Analysis
• Performed backup using backup compression, recovery procedures and disaster recovery plans
• Handled up to 800 GB Size databases over clustered environment. capacity planning and application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks
• Setting up and Monitoring replication, Database mirroring and Log shipping on Production, and Test servers
• Expert in SQL Server new features like Always On Availability Groups, In-Memory OLTP, Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), Activity monitor and Multi Server Query
• Upgraded SQL Server 2008 databases to SQL Server 2012/2014 databases including DTS to SSIS packages
• Created, scheduled database maintenance plan using PowerShell and SSIS Maintenance plan task.
• Implemented SQL Server 2012/2014 new features like Always On Availability Groups for high availability of multiple databases in place of database mirroring.
• Configured and deployed SSIS Packages from Test to Production Environments.
• Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, indexes, views, tables, indexing, structure modifications and functions.
• Performed online index rebuilds for critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
• Reviewed stored procedures developed by the developers and gave recommendations for the code modifications for production
• Optimizing performance of individual queries at the lowest granularity level by analyzing Execution Plans and Estimating their cost of execution
• Used Performance Monitor to Help Identify SQL Server Hardware Bottlenecks
• Managed Security using SQL Logins, Roles and Security Modes for various users
• Maintenance and monitoring of MySQL based Hadoop servers.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Experience with MySQL GUI tools MySQL Workbench, MySQL Administrator, MySQL Query Browser and MySQL Migration Toolkit.
• Implemented database backups - Logical/Physical, Online/Offline, Full/Incremental and Snapshot backups(MySQL dump backup).
• Supporting management with different database related decisions.

Environment: SQL Server 2014/2012/2008 R2, Windows Server 2012/2008/03 server, WSFC, BIDS, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, TFS, SSIS, SSRS, VB.NET, ASP.NET, C#.NET, VM ware, Lite speed, ERWIN, Red gate, MS Office, SQL Mon, PowerShell, MySQL, RHEL, Ubuntu.

Confidential

Database Administrator

Responsibilities:

• Managed and Administrated theSQL Server 2012/2008/2005 production and Non-production servers.
• Extensive experience in implementing High availability solutions like Replication (Snapshot and Transactional), Log shipping, Clustering and Mirroring on physical and virtual machines.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Implemented Side by Side Migration and in-place upgrade of MS SQL SERVER 2005/2008/2008 R2/2012
• Worked on High Availability 2012 Solutions like Always On
• Involved in the migration ofSQL Server 2008 databases to SQL Server 2012.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Evaluated data storage considerations to store databases andtransaction logs. Implemented newT-SQLfeatures added inSQL Server 2008that areData partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Performed daily tasks includingbackupandrestoreby usingSQL Server 2012tools likeSQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Developed and optimized database structures,stored procedures, Dynamic Management views,DDL triggersanduser-defined functions.
• Identified, tested and resolveddatabase performance issues (monitoring and tuning)to ensuredata optimization.
• Involvedin trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Managed trouble shooting ofClient connections, viewing error log and applications.
• Developedautomated backup and DBCC scriptsfor databases and transaction logs.
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Worked on log shipping for synchronization of database.
• Authenticated logins and validated permissions.
• Writingstored procedures, triggers, and functionsand maintained coding standards.
• Involved indatabase Normalization, logical and physicaldata modelingusingERWIN.
• ManagedVERITAS net backups and Lite speed backups.
• Experience configuring and working with Microsoft SQL server 2005, 2008/R2, 2012, on VMware/Hyper-V Environment
• Used SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Transferred data (ETL) toData Warehouse Environment using SSIS.
• Design and Development of SSIS Packagesto load the Data from various Databases and Files.
• Worked onDTS, Import and Exportutility, for transferring data.
• Installed, authored, andmanaged reports using SQL Server 2005 Reporting Services
• ConfiguredIIS,Report manager, Report serverand implemented role based security to end users and developed report models for creating Ad-hoc reports using SSRS.
• Worked withApplication Developersto design databases and tables to supportDevelopment activitiesand achieveoptimal efficiency.
• ConfiguredSQL Server settingsusing configuration manager.

Environment: SQL Server 2012/2008/2005, Windows Server 2003/2008, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, SSIS, SSRS, VB.NET, ASP.NET, C#.NET, VMware/Hyper-V

Confidential

Database Administrator

Responsibilities:

• Installed SQL SERVER 2008/2008r2 FAILOVER Cluster and standalone installation on Windows Server 2008 r2 64-bit system in PROD/TEST/DEV from scratch.
• Installed and administrated SSRS 2008/2008r2/on Windows Server 2008 r2 64 bit.
• Practiced the DR (disaster recovery exercise) at SunGard for SQL Server 2008/2008r2.
• Setup the Transactional Replication for the reporting purpose
• Set up the active-active clusters.
• Implemented Transactional Log shipping and mirroring for database high availability.
• Regularly installed service packs and hot fixes for both clustered and standalone environment.
• Configured the alerts and jobs for the regular monitoring of the database Server.
• Extensively used the Orion monitoring tool at OS level.
• Used native tools DATABASE TUNING ADVISOR, PROFILER, PREFMONCE and ACTIVITY MONITOR.
• Regularly deployed the reports and configured the subscriptions for automated email delivery of the reports.
• Configured the DB SMTP mail for the notification purposes.
• Developed SSIS package in SQL Server 2008 to build the content data for the application.
• Scheduled agent jobs for database backup and windows task to clean up the file system using VB Script
• Configured Linked Servers between different servers
• Used the DMV and DMF for the performance data collection and monitoring.
• Implemented T-SQL features like Data partitioning, Error handling, Common Table Expression (CTE) and Snapshot Isolation.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security in SQL Server and SSRS
• Implemented SQL Audit 2008 and Server Side trace for auditing at server and database level on SQL Server 2008.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Used the cots products like Titanium with ESIR (enterprise System Image Retrieval)
• Administered the SQL Server 2008 r2 for the Microsoft Dynamics GP 2010(Great Plains Software)
• Used BULK INSERT to import the data from flat files.
• Developed stored procedures, functions, triggers in T-SQL and batch scripts.
• Used the TFS and Rational Clear case for change management in the SDLC cycle
• Provided 24X7 support and team player during production outage.

Environment: SQL Server 2005/2008, Windows Server 2003/2008, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, TFS, SSIS, SSRS.

Confidential

Software Engineer

Responsibilities:

• Responsible for all 90 MS SQL Server 2005 instances, Service Packs and Hot Fix installations, configuration and make the systems available always and provide 24/7 dedicated support to all Production, Test and Development servers.
• Installed and configured SQL 2005.
• Creating logins, users and giving appropriate permissions.
• Created backup and restore strategy for production, development and test databases.
• Managed, configured and monitored SQL Server instances with Dynamic Management Views, DBCC statements, Enterprise Manager, Management Studio
• Respond to problem tickets assigned to me and fix any database L1 issues promptly
• Update and work on projects that I have been assigned to as a resource from the Database Management team.