Sr. Sql Dba Resume
Coppell, TX
SUMMARY:
- Around 8 years of IT experience in SQL Server Administration with 32bit, 64 - bit Microsoft SQL SERVER in Production, Development and Testing in Clustered and Standalone Server Environment.
- Experience installing MS SQL SERVER 2000, 2005, 2008, 2008 R2, 2012, 2014; updating with hot fix and service packs.
- Solid experience and outstanding knowledge on High availability (HA) &Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
- Well Experience in file and file group’s management and Supported for very Large databases (VLDB) up to 4TB and Complex Databases.
- Upgraded databases from MS SQL Server 2008 to MS SQL Server 2012/2014, MS SQL Server 2005 to MS SQL Server 2008 and MS SQL Server 2000 to MS SQL Server 2005.
- Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
- Experience in Change Data Capture (CDC) to track important tables for clients.
- Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks, Update Statistics to check Data Integrity.
- Expert level skills in Objects creation such as Table, Views and Stored Procedures, Normalization, Indexes, Cursors, Triggers and other SQL joins and query writing.
- Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
- Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
- Experience in performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement.
- Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
- Experience in comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
- Experience in Backing up, restoring the data base manually and automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server agent and monitoring and troubleshooting the jobs.
- Explicitly used third party tools like Lite Speed, and Red gate.
- Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
- Expert in creating SQL Server Reports using SSRS 2012.
- Extensive experience in the development of Reports using SQLServer 2000/2005/2008/2012 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, and drilldown reports in multiple formats using multi - dimensional objects.
TECHNICAL SKILLS:
Project Domain: Application Development, Systems Integration and Database,Administration of MS SQL Server 2014/ /2005/2000/7.0
Data Modeling: Dimensional Data Modeling, Star Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
ETL Tools: Data transformation services (DTS), SQL Server bulk insert and BCP utilities.
Tools: DTS, Lite-Speed, Spotlight, Visual Studio 2003/2005/2008/2010/2012/2013 , Team Foundation Server (TFS), Enterprise manager, Performance counters, SQL Profiler and Red gate.
Databases: SQL Server 2014/2012/2008 R 2/2008/2005/2000/7.0 , MS Access.
Skills: Designing and developing Databases in MS SQL Server 2000, 2005, 2008 R2,2012
BI: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
Languages: T-SQL, PL/SQL, C, C++, HTML, XML.
Packages: Microsoft Office 2013/2010/2007/2003/2000
Operating Systems: Windows NT/2000/XP/VISTA/ 2003/2008/2011/2012 , Unix
PROFESSIONAL EXPERIENCE:
Confidential, Coppell, TX
Sr. SQL DBA
Responsibilities:
- Architect, Design and Maintain Data Models using CA’s data modeling tool Erwin.
- Migrated database from SQL 2008 R2 to SQL 2012 using backup-restore, attach-detach, mirroring-session and SAN-swing methodologies
- Design and architect Database objects, write and review deployment and rollback scripts (create/alter/drop database objects) and elevate into all environments including production
- Have tuned data warehouse queries that were posing performance bottleneck, leveraging existing indexes to bring down response time from 3+ hours to 15 minutes
- Implemented Database Log-shipping, SQL Replication (Snapshot, Transactional), Database Mirroring, Always On Availability Groups
- Maintained data partitioning (partition switching) for sliding windows and developed an automated process for automatic partition sliding.
- Used DMVs adequately to obtain information on SQL execution, I/O activities, Index usage, locking-blocking activities, and operating system bottleneck for various monitoring and performance reasons.
- Rebuilding Clustering Index on fairly large table using bcp-in - out process.
- Performed administrative activities such as taking Database Backups (full and differential), Transaction Log Backups, Reorganizing and Rebuilding Indexes, Shrinking Databases (non-critical and for storage needs only), Data Compression, Database File Movement, Create SQL Agent Jobs, Linking Servers etc.
- Monitoring and Troubleshooting server issues. Disk I/O, CPU. Database issues. Transaction locking and blocking, resource-waiting, poor response time, space issues with temp db, user data and transaction log files, insufficient access rights etc.
- Created new reports using SSRS for the internal DBA tool.
- Created SQL-inventory using SMO and shell scripting (PowerShell)
- Presented usage of Power shell (scripting) involving SMO and WMI; Locking, Concurrency and Isolation; Proportionate Fill Strategy and several other topics to our SQL DBA team
- Designed and developed a scripted full-phase DB2 tool to replace CA’s RC Query and presented to the DB2 DBA team
Environment: Microsoft SQL Server 2012/2008 R2, Windows 2012/2008 Servers, T-SQL, SSRS, SMP, PowerShell.
Confidential, Atlanta, GA
Sr. Database Administrator
Responsibilities:
- Installed and administered SQL SERVER 2008 R2 and 2012 on Windows Server 2008 R bit.
- Performed migration from SQL Server 2005 databases to SQL Server 2012.
- Configured the Transactional and Merge replication in SQL Server 2008 R2 instances.
- Performed the data compression and databases backup compression in SQL Server 2008 R2.
- Database Administrator, Database Programming.
- Relocation of Databases from one server to another server using attach and detach databases.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Rebuilding the indexes at regular intervals for better performance.
- Upgrading SQL server versions and applying patches and hot fixes.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies.
- Migrated DTS packages from Legacy system to SQL SERVER 2008.
- Using the Lite speed to take backups.
- Implemented log shipping between two instances of servers using Database Maintenance Plan.
- Configured and Maintained High Availability and disaster recovery Setups (Always On, Transactional Replication, 2 nodes and 3 node clustering, Mirroring and Log Shipping).
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
- Monitored and modified Performance using execution plans and Index tuning.
- Recovering the databases from backup in disasters.
- Maintaining the database consistency with DBCC at regular intervals.
- Monitoring SQL server performance using profiler to find performance and Dead locks.
- Maximum performance and uptime in production environment.
- To analyze long running slow queries and tune the same to optimize application and system performance.
- To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases.
- To perform installations &performance tuning, manage capacity planning& user accounts, and implement database security for multiple instances of development,, QA, and production SQL Servers databases.
- Planned and implemented Data Compression, Transparent Data Encryption (TDE), Resource Governor, Policy Based Management, Backup Compression and Change data capture (CDC).
- Provided on-call 24/7 support regarding production-related database problems.
Environment: SQL Server 2008/2012 AlwaysON, Clustering, Replication, T-SQL, Windows bit, Profiler, Visual Studio Management, ETL tools, Lite speed
Confidential, Santana, CA
SQL Server DBA
Responsibilities:
- Installed SQL SERVER 2008/2008 R2 FAILOVER Cluster and standalone installation on Windows Server 2008 R2 64 bit system and Hyper - V in PROD/TEST/DEV from scratch.
- Installed Service packs and hot fixes on to cluster and standalone environment.
- Migrated SQL Server 2008 databases to SQL Server 2012.
- Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor
- Configured Linked servers between different servers.
- Implemented T-SQL features like Data Partitioning, Error handling and Snapshot Isolation.
- Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
- Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
- Involved in up gradation of Touch works Database.
- Implemented SQL Logins, Roles and Authentication modes as a part of Security in SQL Server and SSRS.
- Identified, tested and resolved database performance issues (monitoring and tuning) to ensure database optimization.
- Supported Windows Team SAN Migration by moving the User Databases.
- Developed stored procedures and triggers for data porting for very large databases.
- Used DMV’s and DMF’s for the performance of data collection and monitoring.
- Configured and Maintained High Availability and disaster recovery Setups (Always On, Transactional Replication, 2 node and 3 node clustering, Mirroring, Log Shipping)
- Designed and implemented comprehensive Backup plan and disaster recovery strategies.
- Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.
- Installed and Configured SSRS and Deploying SSIS packages.
- Performed data base Backups (Full/Differential/Transaction Log Backups into Disk) and restoring on requirement.
- Resolving performance issues using DMVs (Dynamic Management View).
- Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans.
- Provided on-call 24/7 support regarding production-related database problems.
Environment: MS SQL Server 2008/2012, MS Access, DTS, SQL Query Analyzer.
Confidential, Houston, TX
SQL Server DBA
Responsibilities:
- Upgraded SQL SERVER 2005 to SQL SERVER 2008 R2 (In place and Side-by-Side) server for high volume processing databases.
- Worked closely with application team, manager and other DBA’s for planning and implementation of the migration.
- Design and Implemented Disaster Recovery Procedures.
- Implemented High Performance Database mirroring on medium scale SQL2008 R2/2005 database servers.
- Performance Tuning and optimizing the code.
- Installed and Configured 2- node High availability SQL Active/Passive clusters.
- Designed the best back up strategy on the mission critical running application on databases considering our business requirements.
- Used Idea SQL Safe tool for compressing the backups in order to perform efficiently and reduce the space.
- Reviewing the Design Document provided by the onshore/offshore development teams for future enhancements upon the requirements.
- Performing Performance tuning using Data Tuning Advisor, SQL profiler and Windows Performance monitor.
- Maintain database including consistency checks, and index defragmentation using DBCC and DMV s respectively
- Responsible for applying service packs and hotfixes.
- Active involvement in installing and managing multiple 2 node failover cluster set up in active/passive environment as a High Availability mechanism.
- Successfully implemented database mirroring with high availability mode in SQL Server 2005/2008 R2.
- Implemented log shipping in SQL Server 2005/2008 R2 from primary server to standby server to support DR solution.
- Configured transactional Replication from multiple subscribers for reporting purpose.
- Involved in performance tuning, optimization of stored procedures and queries.
- Create and maintain various databases for Production, Development and Testing using SQL Server 2005/2008 R2. Planning the location of data, index, and Transaction log files on the disk.
- Solved issues related to server performance and disk space
- Support Development team in deploying and testing the application.
- Experience in contacting Microsoft and other vendors for product and technical support.
- Providing 24*7 supports to SQL application developers in implementing the applications on production server.
- Conducted root cause analysis of application availability and narrow down to issues related to coding practices, database bottlenecks, or network latency.
- Creating users and assigning permissions.
- Used SQL Lite speed on Production servers to increase space and time efficiency.
Environment: MS SQL Server 2005/ 2008 R2, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2008/2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML.
Confidential, Saint Louis, MO
SQL Server Database Admin
Responsibilities:
- Supporting Microsoft approved SQL technologies like SQL Server 2005/ 2008
- Design, implement and maintained 100 database servers.
- Prepared and planned index optimization jobs on non-production and production environments.
- Defined and developed strategies for patch upgrades, rolling patches and rolling upgrades in Clustered Environments.
- Planned and configured Disaster Recovery between data centers in various locations by Clustering, Log-shipping, Mirroring and Replication.
- Continuous check of databases health and taken necessary steps to fix consistency errors.
- Prepared backup and restore backup processes using Lite Speed and scheduled automated jobs.
- Recovered data for objects using object level recovery of Lite Speed.
- Used index tuning wizard and profiler extensively to fix performance issues.
- Trouble shooter job failures and provided permanent fix.
- Prepared root cause analysis for issues and documented.
- Generate daily database reports and provide builds status to counties.
- Implemented Backup, Restore, Recovery, Update statistics, Rebuilding, Reorganizing indexes, and defragging strategies. Used dynamic management views to find and solve Performance Issues of databases.
- Documented processes and procedures.
- Successfully implemented the Capacity planning for different servers.
- Creating and Maintaining Database Maintenance Plans.
- Installed and configured SQL Server clustered databases.
- Modifying Stored Procedures and complex T-SQL Queries to improve query execution process.
- Created Linked servers between non-production to production and vice versa.
- Maintained database User Permissions, server Logins and Security standards across all databases.
- Monitored Event Viewer, SQL Error logs and Log Files Viewer for errors and provided fix.
- Worked in 24/7 environment to maintain and administer databases also to fulfill user requirements.
Environment: SQL Server 2005/2008, Visual Studio Management, Transact-SQL, Enterprise Manager, Query Analyzer, MS-ACCESS and Windows 2003.
Confidential, Tampa, FL
SQL Server Developer
Responsibilities:
- Responsible for SQL Server 2005 database support, troubleshooting, planning and migration.
- Responsible for installation, configuration and troubleshooting the active batch jobs on windows environment.
- Responsible for review, test and apply all database changes to all environments including QA, Development and Production Servers.
- Monitor SQL Error Logs, Schedule Tasks, database activity, eliminate Blocking & deadlocks, user counts and connections/locks etc.
- Worked with SQL server Profiler to generate traces.
- Monitored the database and alerts from fog light application and also performance monitor for the performance.
- Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity..
- Monitoring MS SQL Server performance and network issues.
- Responsible for 24x7 dedicated support including production, test and development servers.
Environment: Windows NT, Windows 2003, SQL Server 2005, DTS, T-SQL, XML, MS SQL Reporting Services, Profiler.