SUMMARY

• SQL Server DBA with around 10 + Years of experience in Administration 2017/2016/2014/2012 , 2008R 2/2008/2005/2000 Database Administration in Production, Test and Development environment.
• Experience in Analysis, Design, Development, Testing and Maintenance, Capacity Planning, Performance support of application systems of OLTP and OLAP databases in the client - server, internet\internet environments.
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 2016/2014/2012/2008 R 2/2008/2005.
• Expert in RDBMS S/W installation, database server builds, applying patches, Applying patches in VM environments (VTM), upgrading, configuring, trouble shooting of SQL SERVER on Windows 2000/03/08R2/12R2 servers and Clustered VMware Environments.
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered and standalone Environments.
• Good knowledge on new features Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture in SQL SERVER 2008.
• Expert in Disaster Recovery plans by configuring AlwaysOn, Clustering, Log-shipping, Mirroring and Replication (Snapshot and Transactional).
• Implemented High Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering.
• Hands on experience in configuring SQL Failover Clustering in Active-Active and Active-Passive nodes.
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Very good T-SQL Programming skills. Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Defrag Tables, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts.
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Data Center Experience.
• Expert in raising the Service Requests and keep tracking of requests.
• Expert in Detecting and Resolving Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Data Modeling Experience including Physical and Logical data modeling using Erwin tool
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Hands on experience in installing, configuring, managing and troubleshooting SQL Server.
• Experience in database development, for creating complex database queries, Indexes, Views, Stored Procedures and Triggers in SQL Server.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player

TECHNICAL SKILLS

Relational Databases: SQL Server 2017/2016/2014/2012 /2008/2008R2/2005/2000, MS-Access 2000/2003/2007 , My SQL 4/5, Oracle 9i/10g.

Cloud Technologies: Azure SQL Database, Azure SQL Data Warehouse, Azure Storage, AWS S2, AWS EC2

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, BCP, ODBC, SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence Studio.

Languages: C#, XML, SQL, T-SQL

Operating Systems: Windows 2016, Windows 2014, Windows 2008R2, Win ME/NT/XP, UNIX.

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS.

Tools: Azure SQL Analytics, Query Performance Insight, Dynamics CRM, MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, ServiceNow, JIRA, Remedy, Foglight, SQL Diagnostic Manager, Litespeed, SQL Safe, Veritas.

PROFESSIONAL EXPERIENCE

Confidential, Kansas

SQL Database Administrator

Responsibilities:

• Installing and configuring Windows and SQL clusters including 3 node clusters, 4 node clusters, and adding a node to an existing cluster.
• Migrating database to Azure using Extract Date-Tier Application and using DMA to generate assessment report and migrate database to Azure
• Integrating Azure AD with existing on-premise windows server directory, giving the organization ability to leverage existing on-premise investments to manage access to cloud based application
• Creating new Azure SQL Database and Azure SQL Data Warehouse databases, Configuring DTU Alerts for certain metrics
• Creating Storage Accounts on Azure to store backups
• Configuring elastic-pool, which is a cost-effective solution for managing and scaling multiple databases that have unpredictable usage demands
• Enabling Diagnostic Settings to collect different statistics/metrics logging them to Azure SQL Analytics(Preview)
• Involving in the migration of databases from SQL server 2012 to SQL server 2016.
• Performing daily support, troubleshooting, monitoring, and optimization and tuning of server and SQL server environments across entire system.
• Assigning permission to users, roles, and object. Administrate security for server’s logins with Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Configuring and managing database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Implementing High Availability in SQL 2012/2016 by configuring AlwaysOn Availability groups across Windows Server Failover Clustering using Failover Clustering Instances
• Implementing and configuring Central Management Servers to centralize and manage about 30 instances of SQL Server 2008 R2 and SQL 2014.
• Implementing Data Collector and Data Management Warehouse to collect performance data of all the SQL instances.
• Enabled Transparent Data Encryption on critical databases.
• Configuring Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configuring SSRS using configuration manager, created and maintained security roles and created new reports.
• Creating maintenance plans (database and log backups and cleanups).
• Used server scoped DMV’s and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Involving in full life cycle of the project from Requirement analysis, Design, Development and Testing
• Analyzing the requirements and significantly contributed in developing database architecture for the application.
• Responsible for creating the Entity-Relationship diagrams, Class diagrams, Sequence diagrams and Flow diagrams using Visio and documenting the project architecture.
• Trouble-shooting and fine-tuning of databases for its performance and concurrency.
• Backing up the databases and restoring them in different environments.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Creating stored procedures, views, triggers, user defined functions to apply business rules to the data.
• Working on replication and Change Data Capture.
• Responsible for creating the reports based on the requirements using SSRS.
• Responsible for maintaining versions of source code using Team Foundation Server.
• Involving and communicated test results for application level testing, and Integration Testing.
• Involving in writing System Documentation and Code Documentation.
• Providing 24/7 critical production support for data issues and given appropriate solutions.

Confidential, Frederick, MD

SQL Server DBA

Responsibilities:

• Worked on 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 MS SQL Server 2014, 2012, 2008r2, 2008, 2005.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshooted issues with the same. Applied hot fixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshooted issues with witness servers.
• Worked on 2014 AlwaysOn High Availability node and the Availability Groups
• Involved in migration of SQL 2012 TO SQL 2014.
• Performed daily backups and developed recovery procedures.
• Patching all the SQL Servers 2008, 2008R2, 2012, 2014 with the latest service packs
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Developed T-SQL Scripts with joins, sub queries and co-related sub queries where required.
• Designed and Created databases, tables, views, stored procedures and DDL & DML triggers.
• Implement SQL Server security and object permissions such as maintain database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Design and implementation of large databases and data warehouses utilizing both relational and dimensional design concepts.
• Proficiency in analyzing large sets of data.
• Experienced in performance tuning using windows performance monitor and SQL profiler of MS SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• 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
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
• Provided support to the application developers on the application databases
• Handled the database components of application releases
• Handled 24/7 production issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using SSRS.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Working with Remedy Tickets (Any changes on staging and development environment need to Create Remedy Tickets).
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Proactively monitored, determined and solved issues at SQL/database/server levels.

Confidential, Jacksonville FL

SQL Server Database Administrator

Responsibilities:

• Providing 24/7 support for critical production databases of Confidential Datacenters.
• Providing Primary DBA responsibilities for around 100 applications.
• Migrated the SQL Server 2008 to SQL Server 2012.
• Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
• Managed 2000+ databases and few huge databases which are more than 7TB.
• Installed SQL Server 2008 on hundreds of machines/clusters.
• Installed of MS SQL 2008 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications (begin to end support).
• Planning for backup and recovery of database information and maintaining Hot Backups, Cold Backups.
• Working with Foglight(Monitoring tool) and Litespeed(Backup tool).
• Administering the MS SQL Server 2012, 2008, 2005 & 2000 by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Performed Physical and Logical Data Modeling using Erwin tool for databases of varied sizes including VLDBs.
• Designing, Creating and Migration of DTS/SSIS packages to Development and QA Servers.
• 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.
• Migrated databases from existing 2000/2005 to 2008R2/2012 servers.
• Involved in General Database Administration, Query Performance tuning.
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008/2012 , Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working with Nexus Tickets (Any changes on staging and development environment need to Create Nexus Tickets).
• Working with Maximo Change Request (Any changes in Production database need to Create Maximo Tickets this should be approved by Global DBA team after changes made in stage and development environment).
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Confidential

SQL Server DBA

Responsibilities:

• Installing, Configuring and Administering SQL server 2012, 2008R2.
• Developed backup strategies for Database Recovery.
• Performing Database maintenance activities like Backups, Restoring.
• As a part of the DBA team providing 24/7 production support to the clients.
• Creating and Monitoring the Scheduled jobs.
• Implemented and maintaining Log shipping, Replication, Mirroring High-Availability options.
• Configured and administered SQL Clusters (Active/Passive, Active/Active).
• Experience in Understanding structured data analysis, data models and data normalization.
• Good experience in resolving blocking/locking and dead locks Issues.
• Verifying Index Fragmentation and performing re-org and rebuild as per %.
• Troubleshooting Log shipping and Database Mirroring and the failed jobs.
• Worked on migration from SQL 2005 to SQL 2012/2008R2 including databases, logins, users, jobs, DTS packages.
• Worked on setting up backup jobs for OLAP databases.
• Monitored and resolved Log shipping out of sync issues.
• Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation.
• Performing daily tasks like Backup & DBCC job verifications and check in failures.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
• Verifying all error log files for any new entries.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2005, 2008 and databases.

Confidential

SQL Database Administrator

Responsibilities:

• Migrated Databases from SQL Server 2005 to SQL Server 2008R2 in Production and test Environments.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
• Creating databases and logins and users with permissions in SQL server 2005/2008.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Configuring and Troubleshooting Service Broker Objects in Service Broker for Stored Procedures.
• Backup and Recovery of Production Databases and Tuning them for better Performance.
• Deploying and Troubleshooting SSIS packages with a multitude of Data sources and complex data conversion logics.
• Creating Databases and Logins & users with permissions in SQL Server 2005/2008.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Created Linked servers accordingly in between the different servers based on the requirement.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Implementation of Backup, Re-index, DB Shrink, Log Shipping and other database maintenance jobs through Stored Procedures.
• Implemented Pager options to inform corresponding DBA basis on Each Job Status.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Define database scripts versioning system to keep track of database versions for all environments.
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Enabled Transparent Data Encryption on critical databases.
• Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Created and scheduled maintenance plans (database and log backups and cleanups).
• Used server scoped and database scoped DMV’s to trouble shoot issues.
• Identified and analyzed deadlocks in databases using SQL Server Profiler.
• Involved in full life cycle of the project from Requirement analysis, Design, Development and Testing.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources to SQL databases.