Sr. Ms Sql Dba Resume
Portland, OR
SUMMARY
- 8 years of experience in Database Administration, Analysis, Design, Development and support of MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005 in Production, Test and Development Environment.
- Good experience in installation, upgrade and configuration of MS SQL Server 2008 to MS SQL Server 2008 R2, from SQL Server 2012 and SQL Server 2014 in clustered and non - clustered environment.
- Experience in upgrading SQL server software to new versions and applying service packs and patches.
- Experience on High Availability/Disaster Recovery (HADR) solutions, Failover Clusters and Always On Availability Groups, Replication and Mirroring.
- Successfully tested and implemented Log Shipping Technique used for warm backup solution for MS SQL Server 2014/2012/2008 R2/2005 databases.
- Experienced in Importing/Exporting Data from various data sources like Oracle, DB2, Excel and Flat files using DTS utility.
- Involved in transformation of OLAP data to the Data Warehouse using DTS and SQL commands.
- Recovering the databases from backup in disaster situations.
- Expert in creating Views.
- Created Transact-SQL (stored procedures, views, triggers, sub-queries, joins)
- Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
- Extensive experience with Power Shell scripting.
- Maintained the Security in SQL Server like Authentication Modes.
- Database Consistency Checks using DBCC Commands.
- Handled multiple SQL Instances on Cluster environment for server Consolidation projects built on SAN using RAID levels.
- Backup and restore using LiteSpeed tool through T-SQL.
- Expertise in planning and implementing MS SQL Server security and database permissions.
- Experience in Installing and Configuring SQL server on virtual machines (VMware).
- Expert in using SQL Profilers, DTA, DMVs, DMFs and other third party tools to resolve deadlocks, bottlenecks and slow running queries..
- Explicitly used third party tools like Lite Speed, Fog light and Red gate.
- Monitoring the Logs for successful execution of all the specified jobs.
- Experienced with Table Design, Index Design and Performance tuning.
- Experience in Converting DTS packages into SSIS packages.
- Experience in handling the Change Data Capture (CDC) with different retention time.
- Troubleshooting SQL Server for Blocking, Locks, Deadlocks and Jobs.
- Maintaining database-specific documentation and ensuring it is Up-to-date.
- Experience in providing good production support for 24x7 on rotation basis.
- Ability to work in a team environment or independently.
- Good at multi-tasking and working well under tight deadlines with high efficiency.
TECHNICAL SKILLS
Languages: T - SQL, VB Script, C, C++, XML, HTTP, JavaScript
Databases: Microsoft SQL Server 2014/2012/2008 /2005, MS-Access
ETL & Reporting Tools: Data Transformation Services(DTS), SQL Server Integrated Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Statistical Analysis Software(SAS)
Operating Systems: Windows Server 2008/2003, Windows 2000 Advanced Server, Windows NT 4.0/3.5.1, Windows 95/98/XP
Application Software: Visual Studio 2010/2008/2005 , Visual Source Safe, Team Foundation Server, MS Office Suite
Data Modeling Tools: SQL DB Access, Performance Monitor, Backup Utility, Idera, SQL LiteSpeed,, Red gate, Visio 2000 DB UtilitiesSQL Server Management Utility, Query Analyzer
PROFESSIONAL EXPERIENCE
Confidential, Portland, OR
Sr. MS SQL DBA
Responsibilities:
- Experience in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
- Implemented Always-ON (AAG) on SQL Server 2016
- Rebuilding / monitoring the indexes at regular intervals for better performance.
- Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Worked on using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Created Server Login roles for the users
- Installed and Configured SQL Server 2016/ 2014/2012/2008 R2/2008 Enterprise edition on Active/Passive Cluster and standalone Environment.
- Added Databases in the Availability Groups and tested for synchronization
- Worked on configuring Availability Group Listeners
- Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2012.
- Complete documentation about the database. Recovering the databases from backup in disasters, Always on Availability Groups, Files and File groups, Partition Strategy and Recovery model.
- Experience on working Microsoft SQL Server Management Studio 2016
- Perform SQL Server service pack and Windows Service pack upgrades
- Used log shipping, Always On Availability Groups and Replication for synchronization of databases.
- Design/ developing SSIS(ETL) MDXdeveloping components.
- Involved in complete database design including conceptual, logical and physical models.
- Performed Loading & Extracting of data to/from the servers, planning & executing database backup and recovery tasks.
- Expertise in designing databases and capacity planning.
- Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
- Monitored Log shipping/ Transactional Replication and troubleshooting errors.
- Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
- Developed SSIS packages and schedule jobs for loading data between different sources.
- Implemented encryption of sensitive data in the databases using Data Encryption Standards like TRANSPARENT DATA ENCRYPTION (TDE).
- Analyzed execution plans, and tuned queries and databases for better optimal performance.
- Fixing Missing Indexes and Excess indexes
- Generated script files when changes applied to stored procedures and functions.
- Configured and deployed SSIS Packages from Test to Production Environments.
- Supported 24 X 7 Production On call
- Performed Loading & Extracting of data to/from the servers, planning & executing database backup and recovery tasks.
- Implemented Replication for Reference Data across different Instances of the application.
- Extensively worked on Profilers, Pref-mon, DMVs, DMFs and DTA to tune the databases, servers.
- Created automatically running stored procedure for day-end operation using SQL Server agent.
- Performed Automatic and manual Test Failover on the nodes
- Developingstored procedures, triggers, viewsand adding/changing tables for data load and transformation, and data extraction.
- Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
- Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
- Checked which Primary node is connected using Availability Listeners
- Experience in Implementing and Monitoring the Log Shipping.
- Managing Backups on a daily basis and Recovery as per request.
Environment: SQL Server 2016/ 2014/2012/2008 R2, Windows server 2008/2003, SQL Profilers, Erwin, SQL Server Tuning Advisor Idera’s SQL Diagnostic Manager.
Confidential, Atlanta, GA
Sr. MS SQL DBA
Responsibilities:
- Installed and Configured SQL Server 2016/ 2014/2012/2008 R2/2008 Enterprise edition on Active/Passive Cluster and standalone Environment.
- Provided 24X7 On Call support for critical production databases.
- Worked on SQL Server 2016 Installation and migration from SQL Server 2008 to 2016 and also to 2014.
- Monitoring/Maintaining/Troubleshooting High Availability options being used in servers Log Shipping, Replication, Mirroring and clustering.
- Created various Data marts and assisted in complete Life Cycle including Design, Development and Testing of an application. Expertise in mapping data between Data Marts and the Enterprise Data Warehouse.
- Worked on Transactional Replication to achieve Load balancing using network authentication.
- Used log shipping, Always On Availability Groups and Replication for synchronization of databases.
- Involved in creating database Schemas, Logins, Clustered and Non-Clustered Indexes, Views, Functions, building Tables and writing Stored Procedures.
- Exported and Imported data from text file and excel to SQL Server Database using Bulk copy insert and BCP utility.
- Performed Server & Application fine-tuning & troubleshooting. Monitored MS SQL Server performance and network issues.
- Developed Backup and Restore scripts for SQL Server 2016.
- Involved in Optimization and normalization of database and tables.
- Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2012/2016
- Installed and administered Two-Node Cluster Configuration (Active/Active and Active/Passive) in SQL Server 2016.
- Design/ developing SSIS(ETL) MDXdeveloping components.
- Involved in complete database design including conceptual, logical and physical models.
- Designed tables, created, and managed Sybase server to hold Sales, Support, Operations, and Billing data (read only).
- Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and deliveringETLprocesses for end-userOLAPand reporting initiatives (Used report services as andOLAPclient schedule reporting tool ).
- Automated various DBA tasks and created alert mechanisms for CPU, Memory utilization, SQL errors and backup failures using power shell.
- Created stored procedures/Views/Triggers for the application developer’s team as per the business rule.
- Created logins and roles with the appropriate permissions.
- Performed DBCC utilities and fixed data corruption in application databases.
- Setting up of ALWAYS ON with configuration of AG Listener and Load Balancing via TSQL/GUI.
- Monitor backup jobs on all enterprise database and perform routine disaster recovery scenarios.
- Ensure that every user is connected to the Database Server and troubleshoot whenever there is any problem in the connectivity.
- Checking the free space of database, status of backup, troubleshooting the failed backups and restoration of databases.
- Used SQL Packager, Red gate tool to create an .exe file of the Database and deploy it to Development and QA.
- Database Backup and restores, and periodical database refreshes, using Red Gate.
- Performance monitoring using SQL Server profiler to find long running queries and dead locks.
- Expertise in Performance Tuning, Query Tuning, Index Tuning, Maintenance Troubleshooting.
- Created ADHOC reports using SSRS in BIDS.
- Used dynamic management views to track long running queries, most frequently used queries.
- Statistical mining SSAS, entity relationship diagram (ERD) database and used Erwin for physical and logical data modelling.
Environment: SQL Server 2016/ 2014/2012/2008 R2, Windows server 2008/2003, SQL Profilers, Erwin, SQL Server Tuning Advisor Idera’s SQL Diagnostic Manager.
Confidential, Bloomington, MN
Sr. SQL SEVER DBA
Responsibilities:
- Installed, configured and maintained SQL Server 2012/2008R2/2008 and applied hot fixes, cumulative updates and service packs.
- Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2012/2008R2 on VM Ware Clustered and Standby Environments.
- Successfully migrated from SQL Server 2005/2008R2 to SQL 2012.
- Pre installation check before installing SQL Server 2008 that identified unsupported configurations.
- Experienced in Memory configuration for SQL Servers 2008 and 2012 on Windows 2008R2.
- Worked on Import/Export and Attach/Detach of the database.
- Implemented the new SQL Server 2012 mechanism like data compressions, online indexing, Contained Databases, security principles.
- Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, Mirroring, database integrity verification, indexing and statistics updates.
- Configured Transactional and snapshot replication on SQL 2008R2 Servers.
- Installed and administered Two-Node Cluster Configuration (Active/Active and Active/Passive) in SQL Server 2008R2.
- Created and configured the database, with 2 file groups, created the tables having required constraints.
- Developingstored procedures, triggers, viewsand adding/changing tables for data load and transformation, and data extraction.
- Created and managed schema objects such as tables, views, indexes, procedures, and triggers & maintained Referential Integrity.
- Designed tables, created, and managed Sybase server to hold Sales, Support, Operations, and Billing data (read only).
- Familiar with Data Warehousing designs in Star and Snow flake Schemas.
- Design, Implement and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
- Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
- Distributed workloads across multiple computers, network links, and central processing units by usingLoadBalancingas a computer networking.
- Created Shell scripts and also used power shell to automate database operations.
- Automated the regular DBA tasks and Migration project using the POWERSHELL scripting.
- Rebuilding and Reorganizing the Indexes on weekly basis for better Performance.
- Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby Servers.
- Implemented the Data Collector to capture the CPU, DISK, Memory counters.
- Used tools like SQL Server Management Studio (SSMS), SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.
- Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
- Database and SQL Tuning to improve performance of loads.
- Migrated new database structures, such as tables, indexes and stored procedures from development to the production environment.
- Worked on SSIS packages to load the data from application database to reporting database.
- Developed stored procedures to load the date from application database to reporting database.
- Provided 24X7 dedicated support for SQL Server production server.
Environment: MS SQL Server 2012/2008R2/2008, Microsoft SQL Server Integration Services, Stored Procedures, Microsoft SQL Server Reporting Services, Microsoft OFFICE SUITE.
Confidential, Dallas, TX
MS SQL DBA
Responsibilities:
- Development of T-SQL Stored Procedures for Export & Import of data from databases and Transaction Databases of different agencies.
- Create, Deploy and Manage Standard Business Reports using SSRS.
- Developed SSIS packages and schedule jobs for loading data between different sources.
- Write T-SQL Scripts for database backup jobs and automating the same.
- Installed, configured and maintained SQL Server 2005/2008 instances on Active-Active and Active-Passive Clusters.
- Understanding Business High-Availability needs and Implementing Backup and Recovery Procedures.
- Production Code Deployment and handling Concurrent user requests.
- Develop and Schedule SSIS and DTS packa0ges.
- Scheduling, Migrating, Deploying and Troubleshooting SSIS Packages.
- Created Views and Index Views to reduce database complexities for the end users.
- Performed Loading & Extracting of data to/from the servers, planning & executing database backup and recovery tasks.
- Implemented Replication for Reference Data across different Instances of the application.
- Setup Disaster Recovery solutions as per availability SLAs and participate in annual DR exercise.
- Continuous monitoring of SQL Server Performance.
- Document server and database policies and procedures.
- Reviewed third party tool (Idera) so as to help automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
- Manage enterprise-reporting (SSRS) Dashboard.
- Generated ad-hoc reports using MS-Access and Crystal Reports.
- Develop and Schedule SSIS and DTS packages.
- Provide 24X7 dedicated support for SQL Server production server.
Environment: SQL Server 2008R2/2008, Transactional-SQL, TSQL, Crystal reports 8.0, Visual Studio.net, Third party tools (Idera diagnostic tools).
Confidential, Eden Prairie, MN
MS SQL DBA
RESPONSIBILITIES:
- Involved in various stages like system analysis, development, design, and creating stored procedures.
- Implementation of SQL Logins and Authentication Modes as part of Security Policy for various categories of user support.
- Security features were implemented for restricted set of users.
- Analyzing business requirements and build logical data models that describe all the data and relationships between the data.
- Wrote SQL stored procedures to implement business logic.
- Designing and validating the forms according to client requirements by using Visual Basic.
- Importing and Exporting of the Database using DTS utility.
- Involved in physical and logical design and schema for databases of new applications.
- Involved in Database Maintenance, Release, created SQL Agent jobs, Alerts.
- Database Management like adding secondary files, expanding file sizes, and shrinking data files when we get Space issues.
- Designed reports on the monitoring of SQL servers Performance. This report gives a detail report to the management on the performance of the server.
- Writing Stored Procedures, Functions and triggers based on the requirement.
- Fine tuning the Database settings as well as the Server Settings.
- Planning and implementation of database backup/restore and disaster recovery.
- Had good experience in 24X7 production support.
Environment: SQL Server 2008R2/2008/2005, Microsoft SQL Server Data Transformation Services, Microsoft Office Suite, Microsoft SQL Server Reporting Services.
Confidential
SQL SEVER DBA/DEVELOPER
RESPONSIBILITIES:
- Maintaining database for production and solving issues as and when needed.
- Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
- Involved in creating the quarterly data required for Data Warehousing needs.
- Created logins as and when required for the application team and giving appropriate permissions to these Logins.
- Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for the project.
- Created ER diagrams.
- Giving 24x7 ON call support to the application team.
- Involved in Optimization and normalization of database and tables.
- Involved in conceptual and physical modeling of data using ER Win tool.
- Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
- Installation and maintenance of SQL Server installations.
- Involved in creating Stored Procedures, views, tables, constrains.
- Dropped and recreated the indexes on tables for performance improvements.
Environment: SQL Server 2005, Microsoft Office Suite, Third party tools.