Senior Ms Sql Server Dba Resume
Oakbrook Terrace, IL
SUMMARY:
A dynamic MS SQL Server Administrator with around 8 years of experience in the IT industry, seeking a challenging position in Server Administration and Technical Maintenance with state of the art technology where my managerial, analytical, problem solving skills and application knowledge can be utilized for successful execution of projects.
- Senior MS SQL Server DBA / Architect with Extensive knowledge in Managing SQL Server environment.
- Over 8+ years of experience in Database Administration, System Analysis and Administration, Design, Development & Support of MS SQL Server 2008 R2, 2005, 2000 and 7.0 in Production, Development & Replication Environments.
- 7+ years of experience in installation, configuration, and maintenance of MS SQL Server 2012/2008 R 2/2005/2000/ 7.0.
- 5+ Years of experience as a MS SQL Server Developer with extensive experience in SSIS/SSRS.
- Proficient experience in upgrading and migrating from SQL server 2000/2005/2008 to SQL server 2005/2008 R2/2012.
- Expert working in Virtual Environment using VMWARE for SQL Server.
- Experienced in Database Backup, Recovery and Disaster Recovery procedures.
- Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
- Extensive experience in maintaining High Availability using Failover Clustering, Database Mirroring and Log shipping capabilities of MS SQL Server 2008 R2/2005/2000 to provide robust database solutions.
- Expert in Active/Passive and Active/Active Clustering.
- Expert in implementing log shipping.
- Expert in implementing database mirroring.
- Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
- Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models and data integrity.
- Experience in managing security of SQL Server 2000/05/08/08 R2 by creating Database Users, roles and assigning proper permissions according to business requirements.
- Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
- Experience with Reporting Services (SSRS) and Analysis Services (SSAS).
- Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation from previous versions.
- Created maintenance plans to perform index defragmentation, re-indexing and update Statistics.
- Proficient in troubleshooting database issues.
- Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks.
- Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications.
- Team player with Good communication, interpersonal and business analysis skills.
TECHNICAL SKILLS: MS SQL Server 2008 R 2/ 2008/2005/2000, Windows Server 2008 R 2/2008/2003/2000, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS). Data Modeling, Erwin 4.0/3.5, Star Schema Modeling, Oracle 10g/9i/8i, MS SQL Server 2008/2005, OLAP Tools, HPQC 9.2, SQL, PL/SQL, Perl, Visual Basic, TOAD, SQL* Loader, IDERA Diagnostic Manager, Apex SQL Monitoring Tools.
PROFESSIONAL EXPERIENCE:
Confidential, Oakbrook Terrace, IL
Senior MS SQL Server DBA
Responsibilities:
- Worked primarily as a PRODUCTION support DBA giving 24/7 Support.
- Managed PRODUCTION, DEVELOPMENT, QA and UAT environments.
- Worked extensively on Virtual and VMware Environments.
- Worked across 90 servers and more than 200 databases with OLTP Database Size 13 TB.
- Involved in Performance Tuning on Production, QA and Staging servers of the current project.
- Configured logical drives and RAID levels Using HP Array Configuration Utility.
- Managed Production environment for High Availability in Active/Active and Active/Passive mode.
- Involved in Monitoring Performance of different production servers.
- Implemented Database Mirroring and Log Shipping for Disaster Recovery (DR).
- Maintained various databases for Production and Testing using SQL Server 2008 R2.
- Upgraded SQL Server 2008 instances to SQL Server 2008 R2 and SQL Server 2012 environment.
- Heavy duty SQL Server Upgrade/Migration from Lower version to Higher Version.
- Planning the location of data, index and transaction log files on the disk (SAN).
- Performance tuning and optimization of procedures and queries.
- Extensive use of SQL Server DMV's for Performance Tuning.
- Worked extensively with SQL server Profiler for performance problems and bottlenecks.
- Created the Backup and Restore strategy for production and development environment.
- Used Change Data Capture (CDC) to audit DML and DDL Operations on various tables.
- Used new security feature called AUDIT in SQL 2008 on both server level and database level.
- Worked with IDERA Tool by setting up alerts for the Monitors of various SQL Servers.
- 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 scheduling SQL Server Integration Services (SSIS) packages.
- Migrated DTS packages to SSIS packages.
- Managing schema objects such as tables, views, clusters, indexes, procedures, triggers and 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.
- Heavy migration using SSIS, DTS and Data Integrator.
- Used SSRS for daily client reporting.
- Created Linked Servers for data retrieval using OLE DB data sources and providers.
- Extensively worked on documentation of run books and release documents with various application teams for production deployments and other processes.
Environment: MS SQL Server 2012/2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, VMWARE, Clustering, Mirroring, Log Shipping, Replication, IDERA, RedGate, LiteSpeed, ERWIN.
Confidential, New York, NY
Senior MS SQL Server DBA/Developer
Responsibilities:
- Installed SQL Server 2008/2008 R2/2005 on Windows 2003/2008 environment.
- Worked extensively on SQL Server 2008 R2 Transactional Replication.
- Involved in monitoring and troubleshooting replication issues.
- Configured Server Memory for maximum performance and effective utilization.
- Configured Temp DB for to increase the performance of SQL Server.
- Monitoring SQL server performance using profiler to find performance and deadlocks.
- Used SQL Diagnostic Manager and SQL Compliance for analyzing locks, Blocking and Memory Utilization.
- Involved Design, Troubleshooting and Deployment of SSIS packages.
- Migrated DTS packages to SSIS packages.
- Involved in deploying XMLA scripts to SSAS and also maintained the security of SSAS databases.
- Deployed Custom Reports to QA and PROD environments by working with QA and Engineering team.
- Refresh the Production databases to DEV and QA environments for new releases.
- Used Dynamic Management Views (DMV) for monitoring the performance of the server.
- Worked and generated reports using SQL Server 2008 R2 Reporting Services (SSRS).
- Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Planner.
- Maintaining the database consistency with DBCC at regular intervals.
- Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security.
- Policies for various categories of User Support.
- Created Maintenance Plans that helped in effective disk utilization and index maintenance.
- Effectively managed disk space using LITE SPEED for Data base Backups.
- Worked on TORTOISE SVN and maintained the data in Source control.
- Created, Scheduled and monitored SQL Server Jobs, making sure jobs run successfully every night.
- Tuned stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
- Extensively worked on 24X7 Production support and also involved in on call rotation.
- Worked in REMEDY ticketing system and resolved tickets ranging from P1 to P4.
- Extensively worked with Native and SQL SAFE compression Backups.
- Extensively used IT Change Request (ITCR) tool to document, track, authorize and record.
Environment: Windows 2000/2003/2008, MS SQL Server 2005/2008/2008 R2/2012,MSCS,Mcrosoft IIS 6, SharePoint2007, Microsoft.NET, SSRS,SSAS, MS Visual Studio 6.0, REMEDY, IDERA.
Confidential, Newark, NJ
Senior MS SQL Server DBA/Developer
Responsibilities:
- Upgraded SQL server 2005 to SQL Server 2008 R2 on standalone and clustered environments and applied service pack.
- Interacted with application team at the time database migration from SQL Server 2005 to SQL Server 2008.
- Interacted with Developers in troubleshooting application and database issues.
- Identified, tested and resolved database performance issues to ensure data optimization.
- Managing Production SQL Servers on VIRTUAL and PHYSICAL environments
- Installing and Configuring SQL Server 2005/2008/2008 R2.
- Supported the business 24/7, maintaining 99.999 uptimes depending on the application and business SLA requirements.
- Involved in database design, database standards, and T-SQL code reviews.
- Configured Active/Active and Active/passive SQL Server Clusters.
- Implemented Mirroring and Log Shipping for Disaster recovery
- Configured transactional and snapshot replication.
- Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
- Documented the results from Upgrade Advisor and resolved all before and after issues migrating from SQL Server 2005 to SQL Server 2008 R2.
- Involved in troubleshooting all the performance issues for different database applications.
- Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
- Involved in setting up database mirroring for production server.
- Configured replication methods like snapshot, transactional and merge replications.
- Monitoring and scheduled jobs on production and staging environment.
- Responsible in monitoring and troubleshooting SQL Server Performance issues.
- Used the Execution Plan to improve the optimization of the T-SQL code.
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
- Resolving performance related issues to Blocking, Deadlocks and long running queries
- Provided 24 x 7 Production support for the database and application issues.
Environment: MS SQL Server 2008 R 2/ 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008 R2, 2008, 2003, ERWIN, CLUSTERING, MIRRORING, LOG SHIPPING, Data Modelling.
Confidential, PA
Senior MS SQL Server DBA
Responsibilities:
- As a Production and development support DBA responsible for maintaining SQL Servers database servers in production, Development and QA Environments.
- Installed SQL Server 2008 R2 and SQL Server 2005 on windows 2008 R2 and 2003 servers, applied service packs and security fix for all servers.
- Implemented Failover clustering for Active/Active and Active/Passive for HA.
- Managed SQL Server Clusters in a SAN environment.
- Implemented Database Mirroring on SQL Server 2008 environments for DR/HA.
- Configured and maintained Log shipping architecture to provide backup server solution for 4 environments in a DR.
- Implemented transactional replication for data refresh.
- Managed and Administered databases in SCOM.
- 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.
- Implemented Database Mirroring on SQL Server 2008 environments.
- Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
- 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 the documents.
- 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 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).
- Scheduled package execution in SSIS.
- Created extensive reports using SSRS (Tabular, Matrix).
- Created the backup schedule for production, test and development servers.
- Worked with Developers to create 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: MS SQL Server 2008/2005/2000, SSIS, SSRS, SSAS, Windows Server 2008, 2003.
Confidential
MS SQL Server DBA
Responsibilities:
- Upgraded most of SQL Server 2000 to SQL Server 2005.
- Involved with upgrade of databases from in a Clustered environment.
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
- Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
- Planned and modified the permission issues in the server.
- Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the performance of the server.
- Worked with SQL Server Reporting Services (SSRS).
- Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
- Involved in creating tables, views, indexes, cursors and stored procedures.
- Involved in creating data models and designing logical and physical models of database.
- Upgraded SQL server 2000 to SQL Server 2005 on standalone and clustered environments and applied service pack.
- Involved in designing the system models using UML and ER Diagram.
- Performance tuning, and optimization of procedures and queries.
- Worked with SQL server Profiler.
- Worked with developers to do the database schema changes and database restore requests.
- Creating, maintaining the users, roles and granting privileges.
- Worked closely with the Developers’ team and the end users while the system is being under development phase.
- Gave training sessions to the end users for the new product such as using the product.
- Involved in writing queries and optimizing the performance of the queries.