SUMMARY:

• Proficiently providing services in Information Data Management Services since last 8 years.
• Eight plus years in SQL Server Administration, worked in MSSQL 2016/2014/2012/2008 R 2/ 2008/2005/2000 versions and Operational Supporting Activities.
• Installed SQL standalone, SQL clusters and migrated from SQL Server 2005 to SQL Server 2008R2, SQL Server 2012, SQL Server 2014 & SQL Server 2016.
• Worked in all phases of Release Management Lifecycles for Application and Data Warehouse Environments.
• Accountable for the below Database Management Capabilities -
• Incorporated Service packs, hot fixes and security patches.
• Implemented advance features like table partitioning, indexing, file group.
• Created Database Snapshot, Transactional and Merge Replications Services.
• Involved On-call 24x7 supporting and maintenance Rollovers.
• Build and supported databases for Application Normalized and Object-Oriented Data Models.
• Build and supported databases for Operational and transactional log databases.
• Performed Database Operations Supporting Activities -
• User Authentications and Authorizations for Databases and Schemas.
• Accountable for Database Backup and Recovery, Pruning Data Corruption, and Troubleshooting.
• Supported, enhanced and tuned application views, stored procedures, functions and database triggers.
• Implemented partitioning strategies as need basis requested by the Enterprise data architects. performa
• Experience in the configuration of Log Shipping, Mirroring and High Availability Always-On Availability Groups
• Creating Active directory accounts and giving access to the users.
• Managing and supporting Delphix Virtualization Platform
• Good understanding of VDBs (Virtual databases) like Delphix Masked VDBs.
• Wrote Advanced SQL functions in T-SQL.
• Involved in Query Optimization, Client/Server connectivity’s, database consistency and System DMVs.
• Experience in extracting and transforming transactional information using DTS Import/Export Wizard, BCP (Bulk Copy Program), DTS (Data Transformation Services) and SSIS Packages from SQL Server
• Created and maintained job plans, scheduling the jobs, Sending Alerts, Mail configurations.
• Strong interpersonal and communication skills.

TECHNICAL SKILLS:

Categories: Technologies

Operating Systems: Windows 95 /98/2000,2012, DOS, Linux, Unix

Languages: Windows Power shell Scripting, T-SQL, PLSQL, SQL

Storage: EMC-SAN Clarion

San Tools: EMC Navisphere 6.0, Multipath Software

Hardware: DELL 6850 Servers, DELL 6300 Servers, SAN arrays, Pentium PC’s and Windows 2000,2008,2003,2012,2016 Servers

Cisco Firewall: ASA firewalls, Fort iGATE, Sonic

Databases: SQL server 2000, 2005, 2008, 2012, 2014, & 2016

ETL tool: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), SQL Server Reporting Service (SSRS)

Cloud: Microsoft Azure Cloud Computing, SQL Server Azure

SQL Server Monitoring Tool and replication tool: Solar Winds, Red-Gate, SQL Sentry, Golden Gate, Attunity, PerfMon

PROFESSIONAL EXPERIENCE:

Confidential

Lead SQL Server Administrator with Delphix Quality Engineer

Responsibilities:

• Creation of User Database and Installation of SQL Server 2008/2008 R2, 2012, 2014 & 2016.
• Involved in Install, configure, monitor, upgrade, patch and tune SQL Server 2008,2012,2014 & 2016 servers
• Security Administration: creation of users, Roles and granting appropriate privileges.
• Implementing Backup and Recovery Strategies and supporting Delphix Database Virtualization Platform
• Expertise in implementing of high availability Always-On Availability and disaster recovery mechanism like replication models, log shipping, database mirroring.
• Creating DSources from the production database on Prod Delphix engine, creating VBDS from them and replicating to Non Prod by using Delphix replication.
• Creating Delphix Masked VDBs from them for end clients.
• Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery, Services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), issue\ problem maintenance and management, Incident management, Security maintenance etc.
• Recovered the database during the event of crash on several occasions. The Recovery was done to Point-in-time.
• Involved in SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor {DTA}.
• Worked closely with the application team, network team and storage teams on various projects.
• Worked on debugging and troubleshooting the database issues and code issues.
• Involved and implemented the Disaster recovery process to the critical databases and Instances as per MSFT standards.
• Involved and worked with the Change management, Release management for the smooth releases and of application\server\db installation or db patch\upgrade
• Provide 24 X 7 Production Support DBA with On-call Rotation.
• Worked as team player in resolving issues, documentation etc.

Environment: MS SQL Server 2008/ 2008 R2, 2012, 2014 & 2016, Microsoft Azure, Delphix tool masking, Delphix jet Stream.

Confidential, Austin.

Lead SQL Server Administrator

Responsibilities:

• Successfully Upgraded from SQL Server 2008/2008 R2 to SQL Server 2012 and SQL 2012 to 2014 on development and Testing Environment.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database mirroring, replication verification, database integrity verification and indexing updates and apply in development and Testing Environment.
• Worked in Active/ Passive Cluster environment.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup and archival software, hardware, and media, offsite storage.
• Generated test data and check databases consistency to meet the functionalities requirements.
• Creating logins and roles with appropriate permissions.
• Configured MS SQL Server 2005 in-built log shipping from primary server to standby server for report generation.
• Configured Various Replication Types between Primary Server and Read - Only servers.
• Installing applications and establish the connectivity with the database.8
• Creating Stored Procedures to convert database tables into XML format and display via web.
• Monitored database performance and rebuilt indexes on tables using Index Tuning Wizard to reduce fragmentation.
• Upgrade DTS Packages to SSIS Packages
• Assist ETL Developers to write and debug SSIS packages.
• Involved in Performance tuning, and optimization of procedures and queries.
• Worked with SQL Server Profiler to generate traces.
• Controlled and monitored user access to the database, backed up and recovered the database, maintained system security and monitored/optimized database performance for Data warehouse and OLTP applications.
• Helped Development Team in deploying and testing the application, which uses SQL Server 2005backend.

Environment: MS SQL Server 2008/2008R2/2012, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System

Confidential CA

SR.SQL Server Administrator

Responsibilities:

• Involved in Application Release Activities to implement into SQL Server Databases 2008 and 2012.
• Actively participated in Critical Services to restore the databases and storage management.
• Discover how Datical's database release automation solution helps you deliver better application experiences with today's database deployment process
• Responsible for Installation, Upgrades, Migration and Configuration Activities.
• Involved in Database Recovery Analysis and Testing and SQL Database Tuning Advisor {DTA}. Addressed Database. Performance Issues, Space Enhancements and Capacity Planning Projections.
• Day to Day Operations including Security Administration and Maintenance and User Authentication like (LDAP)
• Creating Active directory accounts and giving access to the users.
• Worked with Application Development and Reporting Teams to in corporate Objects Creation Process.
• Maintained the databases on Highly Availability Architecture and Implemented.
• Worked on Locks, Deadlocks, Handling Isolation Level and Concurrency Effects, Detect CPU, I/O, Memory Bottlenecks.
• Migrated DTS Packages from SQL Server 2008 to 2012 SSIS Packages. Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.
• Managing and supporting Delphix Database Virtualization Platform
• Performing Cloning and Refreshing the database with De-source copy (Delphix)
• BizTalk servers used to connect the SQL Server database and get the information from it for their reporting purpose.
• Monitoring the servers by using SQL Server 2008 tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent, and Database Tuning Advisor (DTA)
• Performance data collected around the clock as a persistent source for trending and support.
• Visualization and Trending services to track and report on the impact of recommendations.
• Developed standards and guidelines to guide the use and acquisition of software and to protect assets.
• Created, back up, restore of production databases into development environments.
• Modified the existing databases to enhance the application product development process.
• Understands business requirements and translates them into high quality SSRS report deliverables.
• Able to build and maintain automated ETL processes by coding-SQL and DTS Packages.
• Testing and implementing ETL mappings and scripts.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Responsible for providing 24 X 7 critical production support

Environment: MS SQL Server 2008 and 2012, Windows 2003 Server, SSRS, SSIS, MS Visual studio 2008, T-SQL and DTS Packages

Confidential

SR. SQL Server Administrator

Responsibilities:

• Supporting Database Administrator for UAT, Performance and Production Environments.
• Installed, Configured and Monitored SQL Server 2008R2 and 2012 Database Servers.
• SQL Server Database Upgraded from 2005 to 2008 R2.
• Implemented Log shipping activities in SQL Server 2005 and 2008 R2 into remote servers.
• Created and maintained User Authentications and Authorizations defined by Client requests.
• Refresh the production copied data into UAT and Development Environment upon request.
• Implementation of SQL Server 2012 Always on High Availability in Windows server 2012 64-bit environment.
• Supported, Developed and Migrated DTS packages into SSIS Packages.
• Created packages in SSIS with custom error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Created the automated processes for the SSIS Packages run sequentially using SQL Server Agent job.
• Supported and Developed schema object type write-ups for an application development teams.
• Using SQL Server Profiler traced bottlenecks and re-writes the query to improve performance.
• Proposed and rebuilt index paths to reduce fragmentation by monitoring database table usage access paths.
• Implemented backup and archival software, hardware, media, and offsite storage solutions.
• Configured Replication for Data Warehouse Servers from Application Servers.
• Created and scheduled daily, weekly and monthly Database Backup, Mirroring, and Replication scripts.
• Created on Data Models deployment, Data Integrity, and Views and Stored Procedure activities.
• Created Views, Stored Procedures, Functions and Triggers for application
• Implemented Database Mirroring with HA mode in SQL Server 2008R2.

Environment: MS SQL Server 2008/2008R2/2012, SSIS, SSRS, Replication, Migration, OLAP, OLTP, Alloy and TSRM Ticketing System

Confidential

MID SQLServerAdministrator

Responsibilities:

• Installed and configured SQL Server 2008/2008R2 Enterprise and standard edition in the production environment.
• Installed, Configured and Monitored SQL Server 2008R2 and 2012 Database Servers.
• Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL failover clustering for mission critical servers
• Involved in monitoring the backup jobs and resolved the issues for failover jobs.
• Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process
• Supported and build Erwin created forward engineer data models provided by Data Modeling team.
• Addressed server performance issues by Performance monitor using I/O, memory and CPU counters.
• Used index tuning wizard, SQL Profiler and SQL Query Analyzer for performance issues.
• Tunes SQL queries and stored procedures to improve the SQL Server performance.
• Created maintenance plans for integrity checks and server optimization process.
• Created database backup strategy for production, test and development environments.
• Responsible and support engineer for disaster recovery procedures and restore the production databases.
• Involved in database restore and refresh process for various environments.

Environment: MS Windows Server 2008 R2 Enterprise Edition, MS SQL Server 2008/2008R2, SQL Profiler

Confidential

SQL Server Administrator

Responsibilities:

• Responsible for Critical server support 120 servers out of which 90 servers are production servers, remaining test and development servers.
• Installed SQL Server 2000 and 2005 on windows 2000 and 2003 servers, Installed service packs and security fix on production, test and development servers.
• Installed, configured and maintained MS SQL fail over clustering for mission critical servers
• Involved in monitoring the backup jobs and fixed the failed jobs. Created manual Log shipping environments for standby servers.
• Involved in securing SQL Servers and assign the permissions for users and roles.
• Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
• Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
• Experienced in creating backup strategy for production, test and development servers.
• Involved in disaster recovery procedures and restore the production databases.
• Involved in database restore requests and refresh the database between productions, test servers.
• Created the maintenance plans for integrity checks and optimization for production, test and development servers.
• Tuned SQL queries and stored procedures to improve the SQL Server performance.

Environment: MS SQL Server 2005/2000, Windows 2000/2003 Server Operating systems.