SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2014
• Over 8 years of IT experience in database administration, system analysis, backup recovery, testing, disaster recovery and development & support in production using SQL Server 2014/2012/2008 R 2/2008/2005/2000 .
• Experience in planning and implementing MS SQL server security and database permissions.
• Experience in Upgrade/migration of several instances and databases from SQL Server 2000 to SQL Server 2005/2008, SQL Server 2005 to SQL Server 2008/2008 R2, from SQL Server 2008/2008R2 to SQL Server 2012/2014.
• Performed database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) using native and third - party tools and also Restoring on requirement
• Experience in automating day to day maintenance tasks using PowerShell scripts, converting existing TSQL batch scripts to PowerShell scripts and improving SQL Server maintenance jobs performance.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Managing database systems using Query Governor and Activity Monitor
• Experience of using various replication models like Snapshot, Transactional and Merge replication (Planning, Replication Tools, Implementing Replication).
• Provided 24/7 On Call Support for Production Databases.
• Experience in implementation of SQL Server new features like Always on Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
• Expert working in Virtual Environment using VMWARE for SQL Server.
• Migrated the Databases from an External Sybase/Oracle/MYSQL to MS SQL Database by using SSMA.
• Configured, tuned and maintainedMYSQLdatabaseservers
• Strong in monitoring and optimizing the performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, Server side trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third-party tools like Red Gate SQL Monitor, idera SQL Diagnostic Manager, Quest Spotlight.
• Good knowledge in OOP’s concepts and Business Objects& Database analysis and design experience using Erwin.
• Implementing efficient Database Design principles including Partitions and Compression techniques.
• Used PowerShell script for SQL Server Maintenance activities.
• Experience in Storage Capacity planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Experience in documenting and implementing Disaster Recovery Plans using Database Mirroring, Log shipping and Replication wif different topologies for production databases.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor
• Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, Notification.
• Extensive experience in controlling the User Privileges, Monitoring the Security and Audit issues as per Enterprise Standards
• Excellent technical, problem solving, analytical, interpersonal and communication skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005, SQL Azure.

ETL & REPORTING Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, DTA, SQL Server Management Studio

Third Part Tools: SCOM, Idera SQL Check, Companion, lite speed, Red gate, Veritas net backup, Erwin r7, Azure Storage Explorer, Cloudberry Storage Explorer.

Languages, Back up& Monitoring: T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net, Spotlight, Red gate, Fog light

PROFESSIONAL EXPERIENCE

Confidential, Tempe, AZ

Sr. SQL Server DBA

Responsibilities:

• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production.
• Experience in RDBMS database design, performance tuning and monitoring, optimization, backup and recovery inSQLServer2000, 2014, 2016.
• Troubleshoot daily program problems to assist program users in accessing and manipulating computerized data.
• Day-to-day activities such as SQL installations, configure, test, and deploySQLinstances, configureSQLnative backups, backups and restore the databases and transaction log on production/development servers as per business IT needs.
• Upgrading & migrating - Migrated SQL2000,2005,2008,2008R2SQL servers to 2012/201
• Help monitor SQL Servers using the performance monitoring tools SQLserver2012 Activity monitor and data collection tools for both real-time and archived data.
• Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces.
• Installed, managed and administrated the MSSQLServer2014/12/08 Production and Non-Production Servers.
• Involved Upgrade and Migration of SQLServer2012/2008 in placed, side by side to MSSQL Server2014.
• Performed Failover drill tests to check the High Availability during disasters
• Worked on High Availability 2012 Solutions Always On
• Used log shipping for synchronization of databases.
• Experienced in developing, maintaining and deploying complex SSRS reports.
• Migration of 2005 and and 2014 Migrations.
• Production supporting DBA activities in huge OLTP environments.
• Query tuning based on High CPU, Memory and Logical reads and writes.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers,SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Analyzing and designing and implementing different types of Replication Models.
• Supporting Huge Databases, Troubleshooting the problems.
• Developed stored procedures, triggers inMYSQLfor lowering traffic betweenservers& clients
• Design & implementation of custom solutions using Agile & Waterfall mythologies in Oracle EBS.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Created ETL Process Consisting of SSIS Packages, Stored procedures, PowerShell Scripts and SQL Agent jobs.
• Create ETL packages wif SSIS tools to extract data from various source of record, transform and cleanse the data, and load the data.
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Created SSIS packages to retrieve data from Legacy sources and also to retrieve data from the Flat files on monthly and weekly basis.
• Discussion wif peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Managing SQL Server using PowerShell scripts.
• Configure IIS, Install MS SQL Server and implement Software in Client Server.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• Data migration (import & export - BCP) from Text to SQL server.
• Supported Application Development team wif any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results etc.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Enterprise, Windows server 2003/20 bit, Linux, Business Intelligence Development Studio/Data Tools - SSIS, SSRS.

Confidential, Norfolk, VA

Sr. SQL Server DBA

Responsibilities:

• High Availability Disaster Recovery during SQL2014migration.
• Migration of 2005 and and 2014 Migrations.
• Production supporting DBA activities in huge OLTP environments.
• Query tuning based on High CPU, Memory and Logical reads and writes.
• Analyzing and designing and implementing different types of Replication Models.
• Supporting Huge Databases, Troubleshooting the problems.
• Developed stored procedures, triggers inMYSQLfor lowering traffic betweenservers& clients
• Extensive Oracle EBS implementation experience in multi-org environment, specifically Oracle HCM modules.
• Design & implementation of custom solutions using Agile & Waterfall mythologies in Oracle EBS.
• Spreading huge tables to different file groups to achieve maximum performance.
• Writing TSQL code and complex stored procedures for different tasks. Tuning the code written by team members to achieve optimum performance.
• Setting up DR solutions using Log shipping, Mirroring, Always On (2012) in windows clustering environments for High Availability.
• Created ETL Process Consisting of SSIS Packages, Stored procedures, PowerShell Scripts and SQL Agent jobs.
• In Oracle EBS we monitor and track all ongoing transactions and accountings.
• Create ETL packages wif SSIS tools to extract data from various source of record, transform and cleanse the data, and load the data into data warehouse
• Setting up monitoring alerts and dashboards in addition using of SQL built-in dashboards.
• Discussion wif peers about performance issues, SQL Internals about log shipping, DB mirroring, replication etc.,
• MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Database creation, restoration, recovery, User/Schema Creation and maintenance Space Management.
• Managing SQL Server using PowerShell scripts.
• Configure IIS, Install MS SQL Server and implement Software in Client Server.
• Monitoring and Troubleshooting SQL Server using Windows System Monitor, creating an Alert in Windows System Monitor, creating a SQL server Performance Alerts.
• P2V Migration of 70 + SQL servers as part of Code reduction for SQL licensing project.
• Data migration (import & export - BCP) from Text to SQL server.
• Setting up High availability always on future on new 2012 servers.
• Good understanding and experience in SQL Server 2008 features like Change Data Capture (CDC), Transparent Data
• Encryption (TDE) and Policy based Management.
• Prepared and documented Backup & Restore Plans and manage data import and export form multi-agency interfaces.
• Maintain the web servers (IIS) solutions deployment
• Knowledge on Azure hosting.
• Supported Application Development team wif any database issues, updates or new releases. Support included deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results etc.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Enterprise, Windows server 2003/20 bit, Linux, Business Intelligence Development Studio/Data Tools - SSIS, SSRS, Quest light speed and Spotlight Enterprise edition

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2008R2/2008/2005 and 32/64 bit SQL Server Cluster for SQL 2008 and SQL 2005.
• Migrated from SQL Server 2000/2005 to SQL Server 2005/2008R2.
• Implemented high availability solutions for mission critical SQL Server databases wif clustering and Mirroring.
• Implemented and monitored the replication between two sites, support and maintenance of MS SQL Server Transactional Replication.
• Worked in 24X7 production support wif a rotation basis.
• Analyzed business requirements and build logical and Physical data models dat describe all the data and relationships between the data.
• Responsible for Physical Storage Structures and Index Design and Tuning.
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
• Experienced working on DB2 to Oracle replication using CDC (Change Data Capture).
• Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MSSQLServerusing DTS Import/Export utility, BCP, DTS and SSIS Packages.
• Increased database performance by utilizingMYSQLconfig changes, multiple instances and by upgrading hardware
• Restored and recovered databases to point in time for testing, pre-prod and production environments.
• Rewrote and tuned long-running SQL queries to cut execution time, ease database load and improve scalability.
• Used SQL Profiler to find badly performing queries and deadlocks.
• Used 3rd party tools like idera SQL Diagnostic Manager in taking the backups to optimize performance and restoring.
• Evaluated the peak and no peak usage pattern of the application; TEMPeffectively distributed database administration activities, such as full database backup and database defragmentation during no peak hours.
• Used SQL Profiler, Windows Performance Monitor and DB Artisan for troubleshooting, monitoring, optimization of SQL Server.
• Monitored database status including CPU, Memory, I/O, Space and dead lock using SQL Server Utilities.
• Developed SSIS packages to export data from OLTP database to OLAP database.
• Involved in loading the Warehouse databases and performing maintenance tasks on these databases.
• Configured and worked on SSRS in SharePoint integration and native mode.
• Configured security and access as per SOX and PCI standards.

Environment: MS SQL Server 2008R 2/2008/2005/2000 , Windows Enterprise, Standard 2003/2008 servers, Linux, IIS Web server, Toad for SQL Server, Lite Speed, SSIS, SSRS, SharePoint, ERWIN.

Confidential, Folsom, CA

SQL Server DBA

Responsibilities:

• Installed SQL server 2008/2008R2 on windows 2003/2008R2 advanced servers, applied security fixes. Involved in Migrating SQL Server 2005 Servers to SQL server 2008
• 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 dat describe all the data and relationships between the data.
• Responsible for defining Check constraints, Business Rules, tuning data, indexes, and queries.
• Implemented an OLAP data warehouse to create BI reports using crystal reports
• Configuring and administering Database Mirroring, Log Shipping on SQL Server 2008R 2
• Developing SQL scripts for maintaining administration tasks.
• Additionally, designed and implemented a disaster recovery system.
• Configured CDC on Replicated Database.
• Running Index tuning wizard and rebuilding indexes for faster query response.
• Writing Stored Procedures, Functions and triggers based on the requirement.
• Creating jobs/maintenance plans for Database.
• Implemented MS SQL Server security policies and granted object level permissions.
• Created jobs for rebuilding of indexes and updating statistics.
• Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Configured Transactional replication between Primary Server and three Read - Only servers, wif separate Distributor server and experience in troubleshooting replication problems.
• Expertise in Security Issues such as creation and granting permissions on various Objects.
• Performance Monitoring of MS SQL Server 2005/2008.
• Created SSIS Packages to (ETL) Extract, Transform and Load the data into Reporting instance to generate the reports easily and quickly

Environment: SQL Server 2005/2008 R2 Enterprise Edition wif Clustering, OLTP & OLAP environment dat includes Production (24x7), Replication, Migration, SSAS, ETL, Microsoft Windows 2003/ 2008R2 Server.

Confidential, Bentonville, AR

SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005 on windows 2000/2003 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005.
• 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, 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 on different DB replication techniques.
• Worked wif Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Designed database standards as per HIPAA and PHI specifics.
• Participated in Disaster Recovery.
• Participated in DR installation and troubleshooting (Mirroring, Logs hipping and High Availability Cluster
• Experience in T-SQL and PL-SQL
• Optimized the Disk space for performance using RAID and SAN.
• Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.
• Handling the RFC s and work orders assigned to me as part of daily responsibilities.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Experience wif SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Managing security roles in SQL Suite.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Worked on call 24/7 Support on weekly basis

Environment: MS SQL Server 2000, MS SQL Server 2005, Windows XP, Windows NT 4.0, Erwin 3.5.2, Enterprise Manager, SSIS, SQL Query Analyzer, SQL Light Speed Backup Software.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Database Administrator, Database Programming.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• To set up SQL Server configuration settings.
• Backups and Restoration of data/database using a Third-Party Tool (SQL Lite Speed).
• Recovering the databases from backup in disasters
• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance
• Managing the San backups.
• Gathered requirements from business users.
• Wrote user requirement documents based on functional specification.
• Designed physical data models.
• Created functions, views and triggers.
• Developed source to target specifications.
• Created indexes, constraints and rules on database objects to improve the data base performance to has best out of it.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working wif customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: MS SQL Server 2000/2005, T-SQL, Windows NT/2000/ 2003