Sr. Sql Server Dba Resume
Charlotte, NC
SUMMARY
- Around 8 years of IT experience with more than six years in SQL Server Database Administration, Design, System analysis, Development, Testing and Support of MS SQL server 2014/2012/2008 R 2/2008/2005/2000 .
- Expert in MS SQL Server Database Architecture, Administration and Implementation (in Web based, Production, OLTP, and Development environments).
- Expert in Installation, configuration and Upgrades, Database Maintenance, Implementing Data Integrity, Disaster Recovery (DR), Data Migration and Scrubbing, Database Security, Replication, Fail - over Clustering, Log Shipping, Database Mirroring, Blocking and Deadlocking, Remote Administration of the databases, and Database storage specifications.
- Experience in installing Service Packs for SQL Server and OS.
- Developed backup and recovery strategies for production environment.
- Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
- Excellent in system tables, DMV’s and stored procedures using T-SQL.
- Experience in Extracting, Transforming and Loading of Data from Excel, Flat file, Sybase, Oracle to MS SQL Server by using BCP and DTS Import/Export utility, SQL Server Integration Services (SSIS).
- Experience in Logical Data Modelling and Entity relationship diagram(ERD).
- Good experience in Installing, configuring and maintaining SQL Server Active/Active and Active/Passive clusters with multi-instances.
- Experience in working with RAID (redundant array of independent disks) for performance improvement.
- Maintained database changes in Development, QA, Staging and Production.
- Experience in designing of data structures and involved in the design of data access components.
- Worked with Project manager and Technical lead in various phases like Technical Design, development, work effort needed etc.,
- Experience in the manual failover & fail back process to make the DR server as the active server.
- T-SQL coding and testing: indexes, views, triggers, functions, cursors, stored procedures, etc.
- Expert in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2005 and SQL Server 2008 in OLTP environments.
- Expertise in Database High Availability Solutions with Always On Availability Groups, Database Mirroring, Standby/Replication and Log shipping.
- Extensive experience in space allocation, database migrations and database security.
- 24x7 Production support on call support.
- Excellent communication skills.
- Good team player with strong analytical skills.
- Microsoft Certified IT Professional, Database Administrator.
TECHNICAL SKILLS
Platforms: Windows- 95/98/2000, XP/2003 server/2008 server/ 2008 R2/2012/2012R Server and Windows7, 8
Programming: C, C++, SQL, PL/SQL, VISUAL BASIC
Databases: MS SQL SERVER 2014/2012/2008 R 2/2008/2005/2000 , ORACLE
Web Technologies: HTML, XML, ASP, Java Script
Security Tools: MS Baseline Security Analyzer (MBSA), NGSSQuirrel for SQL Server, Scuba by Imperva
Tools: SQL Server Management studio (SSMS), SQL Profiler, DTS Import/Export, SQL Navigator, SSIS, SSAS, SSRS, Enterprise Manager, MS Office 2000/2003, Visual Studio 2005/2008, Foglight, VERITAS, PowerDesigner, Quest Litespeed, Excel Macro 2007/2003, Erwin, Toad, ER/Studio, Hyper-V.
PROFESSIONAL EXPERIENCE
Confidential, Charlotte, NC
Sr. SQL Server DBA
Responsibilities:
- 24/7 Production support for SQL server environment.
- Installing, Upgrading and configuring SQL Server 2012, 2008 and 2008R2.
- Fine-tuned and Monitored SQL Servers in Web based and Transaction intensive environments. Implemented Active/Passive, Active/Active SQL Server Cluster servers.
- Configured and maintained database mirroring for high availability.
- Implemented different types of Replication Models like Snapshot and Transactional.
- Extensively worked on Dynamic Management Views (DMV’s).
- Patched server with latest SQL Server service packs and Cumulative updates.
- Managed Microsoft Active\Active and Active\Passive Clustered SQL Server 2000, 2005 and 2008/R2 environments.
- Performed DBCC utilities and fixed data corruption in User databases.
- Developed, deployed and monitored SSIS Packages tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application including upgrading DTS to SSIS.
- Migrated SQL Server 2000 to SQL Server 2008/2008R2 and SQL Server 2005 to SQL Server 2008/2008R2 which include installing of SQL Server.
- Strong in developing, deploying packages using SSIS from OLTP to OLAP.
- Worked on monitoring and tuning of SQL scripts.
- Created upgrade scripts for production database and supported it.
- Created and managed schema objects such as tables, views, indexes, procedures, triggers, and maintained Referential Integrity.
- Performed Server & Application fine-tuning & troubleshooting.
- Monitored MS SQL Server performance and network issues.
- Helped Development Team in deploying and testing the application, which uses SQL Server as a database.
- Worked on more than 10 Data modeling projects and generated E-R Diagram.
- Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries.
- Maintained Log Shipping, Mirroring and SRDF for disaster recovery.
- Scheduled the backups for Databases and Transaction log. Performed restoration operations. Suggested backup strategies.
- Controlled user access rights, and managed data security.
- Involved in trouble shooting, Performance Tuning, Query Tuning, Index Tuning using DMV’s, Wizards and SQL Profiler.
- Implemented Backup and Restore in SQL Server using Third party tool VERITAS Net Backup, SRDF, TSM and LITESPEED.
- Maintained multiple instances SQL Servers with maximum availability.
- Involved in 24x7 on call support.
Environment: SQL Server 2012, 2008/2008R2, Visual Basic, .net, Windows 2008 data centre/advance server, SQL Server integrated services, SQL Server Reporting Services, Internet Information Server 6, HTML, .Net Framework 2.0, VB.Net.
Confidential, Boise, ID
Sr. MS SQL DBA
Responsibilities:
- Migrated from SQL server 2008R2 to 2012 by using side-by-side upgrade process, and documented the Upgrade Process.
- Performed huge data transfers between various servers using BCP and SSIS for developer requests. Migrated data across various environments. Performed backup and archiving of data for various business requests.
- Provided 24x7 production supports to the clients and application groups.
- To protect databases, took Full backups, Transaction Log Backups, and Differential Backups daily.
- Created and maintained the SQL Agents jobs and configured them to send the alerts and email on failure to DBA group.
- Created Database Maintenance Plan for the Performance of SQL Server which coveredDatabase Integrity Checks, Update Database Statistics and Re-indexing.
- Security Administration by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granted privileges to users and groups.
- Installing, upgrading and applying the latest service packs/hot fixes.
- Provided High availability through Clustering (Active/Active and Active/Passive), Mirroring, Log Shipping, Replication (Transactional), and Always On.
- Installed, configured and maintained Log shipping to create Standby Server.
- Troubleshoot Locking, Blocking, and Deadlocks.
- Reviewed the SQL ServerError LogsandApplication Logs to resolve the issues.
- Tuned the SQL queries using SQL Server Profiler and creating non-clustered missing indexes.
- Monitored issues proactively before user complaints.
- Attended team meetings to keep up to date with the information and suggested team to for database storage spaces.
- Quarterly perform disaster recovery exercise.
- Worked closely with developers to support them with backups as per their need and help them with the SQL queries.
- Configured, Migrated, and Deployed SSIS, SSAS and SSRS packages.
Environment: Windows 2008/2003, MS-SQL Server 2012/2008R2, SSIS, SSAS, SSRS, System Monitor/ Performance Monitor, Spotlight and Redgate.
Confidential, Houston, TX
SQL Server DBA
Responsibilities:
- As a Production and development support DBA responsible for maintaining 150 SQL Servers out of which 170 servers are production servers in which 100 were mission critical and 70 were business critical servers, remaining test and development servers.
- Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2, applied service packs and security fix for all servers.
- Implemented Failover clustering for ACTIVE/ACTIVE and Active/Passive SQL Server 64 bit environment.
- Managed SQL Servers in 32/64 bit Clustered environments.
- Implemented Database Mirroring on SQL Server 2008 environments.
- Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
- Implemented transactional replication for data refresh.
- Managed all Publisher, Distributor and Subscriber database environments for the replication
- Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
- Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
- Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
- Created SSIS packages to Extract and Load data from diverse source (flat file, excel, xml and oracle).
- Created Data Flow’s for Aggregate, sort, lookup, merge, union all and fuzzy lookups.
- Used containers for repetitive control flow tasks.
- Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS.
- Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS.
- Scheduled package execution in SSIS.
- Installing packages on multiple servers in SSIS.
- Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
- Created extensive reports using SSRS.
- Installed, configured and maintained MS SQL Fail over clustering to provide server high availability solution for 6 different environments.
- Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
- Created the standard documents for Disaster recovery testing and implemented them.
- Experienced with database sizing and capacity planning for production servers.
- Experienced with creating logical and physical database design for development projects.
- Experienced with improving SQL Server using windows performance monitor to improve the server performance.
- Created the backup schedule for production, test and development servers.
- Worked with developers to do the database schema changes and database restore requests.
- Involved in restore operations to refresh the data from production to test servers.
- Experienced in troubleshooting production servers and fixed the user and application issues.
Environment: SQL Server v2008 R2, SQL Server v 2005/2000, Used 40+ database, SQL Optimizer, DTS, SQL Log Manager, Win 2003, Win 2008 R2 Server, ASP, ASP.Net, SSIS, Reporting Service, PC Anywhere.
Confidential
MS SQL server DBA
Responsibilities:
- Installing multiple instances of SQL Server 2008 R2 and database migration from SQL Server 2000 to SQL Server 2008 R2.
- Implemented SQL Server with high availability architecture using SAN.
- Migration of New SQL server 2008 R2 from SQL server 2000.
- Create and modification of the database according to the requirement.
- Data migration using BCP utility and attach/ detach database.
- Create the jobs and also maintain the jobs as daily basis as well as weekly basis.
- Implemented a Disaster Recovery plans.
- Creating snapshot replication and transactional replication in the SQL Server 2008 R2.
- Transfer bunch of tables using SSIS packages.
- Partitioned a lot of tables, which had frequent inserts, deletes and updates to reduce the contention and to improve the performance.
- Wrote SSIS Script for data transfer and involved in the system designing.
- Installing service packs and security patches SQL Server 2005/2008 R2.
- Created logical and physical data modeling for development projects.
- Rebuild the indexes using DBCC re-index and also check index fragmentation.
- Testing QA server data with production servers.
- Check blocking process and send them via e-mail notification.
- Actively involved in Normalization and de-normalization database.
- Capacity planning in estimating and sizing of tables.
- Provided a support for data issues and support to the application developers on application database and given appropriate solutions.
- Set up SQL Mail and crated Jobs to automate and scheduling many tasks.
- Created heavy SSIS packages on SQL Server and Reporting Services on SQL Server 2008.
- Refreshing production databases. Development of policies and procedures for ensuring their security and integrity, analyzing the queries for performance.
- As a DBA, managing 10 different production Servers and several QA Servers in multiple countries supporting several hundreds of users.
- Maintained the production, test and development databases, tuned the database by improving relations, integrity constraints and written T-SQL procedures for transactions.
- Created documentation of database design, reporting, data analysis, security, administration.
Environment: MS SQL Server 2000/2005/2008 , Windows Enterprises 2003/2008 servers, IIS Web server, Toad for SQL Server, Litespeed, JavaScript, CSS, HTML, SSIS, SSRS, NetBackup, C#, VB.Net, ASP.Net.
Confidential
SQL Server DBA
Responsibilities:
- Upgraded most of SQL Server 2000 to SQL Server 2005
- Involved with upgrade of databases from in a Clustered environment.
- Worked on SQL Server 2005 with latest Service Packs.
- Involved in Performance Tuning on Production, QA and Staging servers of the current project.
- Involved in Monitoring Performance of different production servers.
- Implemented Database mirroring for disaster recovery.
- Maintained various databases for Production and Testing using SQL Server 2005.
- Planning the location of data, index, and Transaction log files on the disk.
- Performance tuning, and optimization of procedures and queries.
- Worked with SQL server Profiler.
- Created the backup and restore strategy for production and development environment.
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
- Experience in creating and executing SQL Server Integration Services (SSIS) packages.
- Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications.
- Administering the MS SQL Server 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.
- Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them.
- Performing fine Tuning of Database Application. Cleansing and solving Database troubles.
- Used BCP and Bulk Insert utilities.
- Worked with SQL Server Reporting Services (SSRS).
Environment: SQL Server 2000 Enterprise Edition, SQL Server 7.0 Enterprise Edition, MS Reporting Service 2000, ODBC, VBScript, Windows 2000/2003 Server, IIS 5.0.
