SUMMARY

• 8+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R 2/2008/2005/2000.
• Expertise and Interest include Administration, Database Design, Performance Analysis of highly transactional servers and production support for Large (VLDB) Complex and Critical databases.
• Extensive experitise with configuring High Availability and Disaster recovery scenarios like Always On, Clustered environments, Mirroring, Log shipping and Replication.
• Documented Disaster Recovery plans and participated in disaster recovery drills.
• Worked extensively on Multi - Subnet Clustering and Server consolidation. Troubleshooting Production issues, HA issues and AG alerts
• Experience in implementing advanced features like Policy Based Management, Resource Governor, Data Collector sets, and Backup Compression Techniques.
• Implemented the methodologies like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, Online Indexing,
• Experience in creating cubes using MS SQL Analysis Services. Developed star and snowflake schemas.Working in both MOLAP and HOLAP environments.
• Worked extensively on DMV’s, DMF’s, Mail Setup, Jobs and Alerts, DTA, SQLCMD.
• Experience in working with Agile/SCRUM based product development teams, collect database requirements and provide solutions and recommendations for new schema, infrastructure or architecture.
• Expertise in setting up High Availability and Disaster Recovery(HADR) solutions such as Active/Passive and Active/Active Clusters.
• Performed Sharding and Vertical Partitioning in order to suffice the Application through put and good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, Optimizing execution plans, Proper usage of indexes, Index Rebuild, Reorg.
• Experience working with Profiler and Server side trace.
• Expertise in reading and understanding Execution plan and fixing query to execute with low cost.
• Expert in handling parameterized Reports, Drilldown Reports using SQL SERVER REPORTING SERVICES 2005
• Designed effective Maintenance Plans for Backups (Full, Differential and Transactional Log) and RPO, RTO to recover point in time data in in case of disaster of server/center
• Thorough Understanding of different RAID levels implementation and Performed methologies such as Disk Striping with/without Parity.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Upgraded databases from MS SQL Server, 2012 and MS SQL Server, 2014.
• Expert in extracting from different sources, transforming and loading data using transformation services like data transformation services like Batch processes, Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Hands on Experience with using Data Modeling Tools such as Erwin and MS Visio.
• Extensive experience in Capacity Planning, Performance Tuning, Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Experience in SQL Server Reporting Services(SSRS) and Crystal Reports.
• Overall database design thatinvolvescreating normalized databases, user authentication, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
• Explicit expertise in installation and configuration of SCO(System Center Orchestrator 2012) and SCOM(System Center Operations Manager 2012).
• Performed both single server and multiple server deployment of SCOM and its components.
• Extensively worked on Data tier applications, deploying and managing dacpacs.
• Hands on expertise on both Upgrading and Downgrading SQL Server to new versions and applying Service packs and Hot Fixes.
• Expertise in implementing advanced methologies like Transparent Data Encryption (TDE), Page Level Compression, Column Stored Indexes.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Experience in using DMV and dynamic management functions (DMF) Of Tables, Triggers, Store Procedure etc for finding out long running queries.
• Explicitly used third party backup tools like Lite Speed, Fog light and Red gate.
• Creation and maintenance of Databases, creating Roles and managing user permissions and Data Warehousing.
• Experience in Troubleshooting and documenting root cause analysis.
• Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experience working with Window 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Develop and manage reports on SharePoint Server.
• Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
• Monitoring and troubleshooting by checking Performance Monitor and Activity monitor.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R2/2008/2005

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, Perfmon.

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

Languages: T-SQL, C/C++, Java, PERL, java script, Visual Studio2010/2012, XML, HTML, ASP.NET, VB.Net.

PROFESSIONAL EXPERIENCE

Confidential, TX

SQL Server Production DBA

Responsibilities:

• Migration of databses from SQL Server, SQl Server 2012.
• DATABASE / HIGH AVAILABILITY / PERFORMANCE TUNING
• Installation, Setup and Management of Always On Availability Cluster
• SQL Server Logins and Windows Access Administration. .
• Repaired, Recovered, Database Synchronization for Disaster Recovery.
• Provided Consulting for Database Performance Tuning and also used tools such as Data Tuning Advisor and Profiler.
• Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Blob Storage.
• Performed SQL server trouble shooting for immediately issue, such as deadlocks and Blocking
• Implemented Horizontal partitioning and Page Compression for Very Large Tables.
• Implementation of TDE (Transparent Data Encryption) for HPA-Data and maintenance of Encryption Keys, Certificates and migration of Encrypted Databases across different environments.
• Downgrading SQL Enterprise Edition to DE (Developer Edition 2012/2014) in Development Environments. nstalled, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
• Involved in capacity planning, sizing and database growth projections.
• STORED PROCEDURES / JOBS PROGRAMMING /ACTIVITIES
• Implemented disaster recovery strategy and configure relative job on DR.
• Created and monitored SQL agent jobs.
• Installed and Configured Microsoft monitoring tool System Center Operations Manager (SCOM)
• Installed and integrating MOM Agents across different machines for SCOM monitoring
• Powershell scripts for Server Health monitoring and automated jobs for Blob storage
• Create alerts for AG (Availability Groups) health and Extended Events for Dead Lock monitoring.

Confidential, Cleveland, Ohio

SQL Server DBA

Responsibilities:

• Involved in the Migration of Databases from SQL Server and SQL Server .
• Involved in migrating DTS packages from SQL Server 2005/2008 to SSIS packages in SQL Server 2012 database.
• Created and optimized SSIS packages for data flow between SQL Servers.
• Extensively used SSIS and DTS packages for Data Warehousing and Archiving.
• Extensively worked on Extracting, Transforming and Loading (ETL) of Data from Excel, Flat file, Oracle to MS SQL Server using DTS Import/Export utility, BCP, DTS and SSIS Packages, Automation using SSIS
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, production support and Project review with client.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Evaluate and apply SAP Kernal patches and support packs.
• Monitor and Tune SAP application performance.
• Installation and Postinstallation procedural documentation for SAP Optimizer.
• Installed, configured and maintained transactional Replication Server.
• Automated and enhanced daily administrative tasks, including space management, backup& Recovery and performance monitoring.
• Created alerts and notifications for System errors, insufficient resources, and Fatal database errors.
• Created Triggers to enforce data and referential integrity.
• Involved in writing T-SQL Programming to implement Stored Procedures and Functions for different tasks.
• Performance Tuning, Analysis and optimizing for SQL Server Application by using Performance monitor.

Environment: MS SQL Server 2005/2008/R2/2012, SAP,Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, Erwin, companion, Idera, TSM/TDP.

Confidential, Plymouth, MN

SQL Server DBA

Responsibilities:

• Manage and administer SQL server 2005\2008\R2\2012 servers.
• Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Deployment of databases, jobs, cubes from pre-production to production.
• Building SQL 2008\R2 cluster environments on VMware or Physical windows
• Performed installations of SQL 2008\R2\2012 on clustered and standalone servers
• Upgradtions of sql server versions and applying patches and hot fixes.
• Adding nodes to already existing clustered servers as a part of data load\High availability
• Configured Transactional Replication and Log Shipping with SQL Server Management
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Work on weekly Issues reports which are generated as a part of infrastructure setup.
• Conitnuous monitoring server health with Idera
• Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans
• Configured Database mail, linked servers, Transparent Data Encryption (TDE) and Auditing
• Performance tuning of databases by windows performance monitor and SQL Profiler
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Documenting the standard procedures on regular basis.
• Working on tickets\incidents with in the SLA’s, as a part of operations support DBA
• Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration
• Resource planning and coordination for application migrations with project managers, application and web app teams
• Involved in capacity planning, sizing and database growth projections. Worked with Data warehousing team in VLDBs environment for archiving the old data
• Worked in a environment with Change management process (Service-now tool) in place for all kind of production and non production changes
• 24*7 oncall production support.

Environment: MS SQL Server 2000/2005/2008 / R2/2012, Windows 2003/2008, SSRS, SSIS, SSAS, PL/SQL, MS Access, perl script, Erwin, companion, Idera, TSM/TDP.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Performed backup/restore, created database objects such as tables, procedures, constraints, indexes and views, user security management.
• Designed database tables and relations between them through Normalization. Involved in project planning, scheduling for database module with project managers.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimizeperformance.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning and optimizing indexes using Performance Monitor, Profile and Index Tuning wizard.
• Experience on Import / Export using DTS and BCP utility.
• Worked as a developer in creating complex Stored Procedures, Functions, Triggers, and views.
• Involved in Database designing, Logical and Physical Data modeling using Erwin.
• Transformed logical model into Physical SQL Server Database. Created SQL tables using scripts and Erwin Forward Engineering Utility.

Environment: MS SQL Server 2000/2005/2008 , MS Access, DTS, Erwin, SQL Query Analyzer, SQL Developer.

Confidential, Longwood, FL

SQL server DBA

Responsibilities:

• Involvement in the Design and Development of Database.
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Involved in automation of the job and was involved in daily monitoring of the tables and indexes for performance
• Monitoring Log shipping/Replication and trouble shooting of errors
• Security issues related to logins database users and application roles and linked Servers.
• Performance Tuning of SQL 7.0
• Analyzing the problems in the production environment and try to develop new procedures and methods for monitoring the problems and send alert messages to take pro-active action.
• Backup and Restoration of data/database.
• Involvement in Development and Implementation
• Designing the database
• Creating Automatic data loading Procedures from the host system to master systems
• Used stored procedures, bcp and DTS Packages
• Security issues related to logins database users and application roles and linked Servers.
• Timely completion of activities for database backup, restoration and health check of databases.
• Involved in trouble shooting and fine-tuning of databases
• Tuning front-end applications like Visual Basic and MS Access, which query the SQL Server databases.
• Troubleshooting ODBC and OLEDB issues between the application and the server.
• Scheduling Full and Differential Database backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL SERVER 2000, MS-Access, Visual Basic 6, and Windows NT Server and Windows 2000.