Sql Server Dba Resume
Dallas, TexaS
SUMMARY:
- With 8+ years of IT experience specializing in SQL Database administration, Disaster recovery, Technical support, Storage, Data center management, Data Migration, Risk management, installation/Configuration, Data Warehouse architecture and Troubleshooting. Solid expertise in System analysis, Design, Development of MS SQL servers in Production, QA, Reporting services, Development environments, Replication and Cluster Server environments.
- Experience in SQL Server security by assigning logins, server/database roles and server permissions.
- Experience in upgrading SQL Server 2012 from SQL Server 2008 and 2005.
- Provided 24/7 support in monitoring, troubleshooting, optimizing and tuning of SQL server environments and Good hands on performance and tuning issues, developing and implementing emergency fixes, resolving database problems.
- Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
- Experience in High availability using Database Backup and Restore, Database Snapshot, Partitioning, Replication, Log shipping, Clustering (Active/Passive), Database Mirroring and SQL Server 2012 Always On.
- Implementing high availability with Always On Availability Groups and failover clustering.
- Experience in trouble shooting SQL Server Jobs, and job monitoring tool.
- Involved in automation of administrative tasks such as creating jobs, schedules, alerts using SQL Server agent, monitoring and troubleshooting the jobs.
- Implementation of Database maintenance plan for Database consistency.
- Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks.
- Experience in SSIS, DTS, BCP, Import, Export, Backup, Database Monitoring tools and Application support.
- Experience in applying patches and service packs to keep the database at current patch level.
- Extract, Transform and Load (ETL Tools) data using DTS Import/Export utility, deployment utility DTS Packages and SQL Server Integration Services (SSIS).
- Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
- Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
- Good verbal, written communication, presentation, problem solving and conflict resolution skills.
- Detail oriented with client interaction and knowledge transfer.
TECHNICAL SKILLS:
Databases: MS SQL Server 2012/2008 R 2/2008/2005/2000
Operating systems: Windows Server 2012/2008/2008 R2/2003.
Programming SQL, PL/SQL:
Tools: Management Studio, SQL Profiler, Performance Monitoring, SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services), Query Analyzer, Enterprise Manager.
Reporting Tools: SQL Server Reporting Services, Cognos
Data Migration: DTS, SSIS, BCP, Import/Export Wizard.
Domain Knowledge: Banking, Finance, Healthcare, Manufacturing, High Technology, IT
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, Texas
SQL Server DBA
Responsibilities:
- Installation, configuration and administration of SQL Server 2012/2008 on windows, applying service pack and security fixes as necessary.
- Day - to-day management of a centralized MSSQL Server platform.
- Implementing high availability with Always On Availability Groups and failover clustering.
- Install, manage & troubleshoot multi node multisite SQL Server clusters (Active/Passive).
- Deploy and scheduled SSIS package and reports as per user requests. Migrated SSIS package from SQL Server from Dev to higher environments.
- Working with application development and support teams to resolve service requests and incidents within agreed upon SLAs.
- Reviewing and fixing issues with database backups, maintenance, monitoring and performance and other common faults
- Create and manage user databases and their sizes. Migrate databases from Dev to Higher environment.
- Used query execution plan to improve query performance by identifying expensive operators and optimizing them by restructuring the query and adding necessary indexes.
- Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
- Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
- Review Stored Procedure, analyze and create recommendation on it to improve performance such as creating indexes to avoid deadlock, key lookup.
- Expertise in SQL server Reporting Services (SSRS).
- Used SQL Profiler to identify long running queries and optimize them, capture and analyze deadlock graphs to resolve deadlocks and blocking.
- Using PowerShell scripts on regular basis for getting instance specific details.
- Perform code reviews on the database objects created by developers, enforcing best practices and coding standards.
- Working with Avamar team for backup and restore of Database for all environments.
- Implemented yearly password management/maintenance procedures involving production updates of password changes for SQL Services, Replication, Reporting services and Database connection strings.
- Used DBCC to troubleshoot issues related to database consistency.
- Participated in the organization’s change management process for production releases with different application groups. Managed version upgrades working with Development, Extract and Testing Teams.
- Work with individual application resources to coordinate testing of new releases and upgrades from application perspective.
Environment: SQL Server 2012/2008, SSAS, SSRS, SSIS, Windows 2012/2008R2/2003, SQL Profiler, DTS/SSIS, T-Sql.
Confidential, Tampa, FL
SQL Server DBA
Responsibilities:
- Installed Microsoft SQL Server 2005 and 2008 R2 on New Production and Test servers with latest Security updates involving Service Packs and Security patches as they are released.
- Involved in the SQL Migration Process (both in-place and side-by-side).
- Upgraded SQL servers from R2 SP1 version.
- Enabled Resource Governor to manage SQL Server 2008 database workload and evaluating critical system resource consumption.
- Evaluated indexes at regular intervals and rebuilt as necessary for performance improvement.
- Analyzed and identified unused indexes in the databases using Catalog Views and DMV’s and dropping them.
- Archived/purged data in database tables using TSQL and executed as a job.
- Used Windows Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Performed code reviews on the database objects created by developers, enforcing best practices and coding standards.
- Troubleshoot Database connectivity issues from the applications and resolve the same.
- Designed and implemented comprehensive Backup plan.
- Monitored Double-take console to check the status of mirroring/replication of backup files cross the network.
- Reviewed DBA Daily status report to troubleshoot the low disk space, consistency checks, server configuration and DB growth in proactive and submitting to Manager.
- Responded to issues that have been escalated with Change Control Processes and adherence to standards and documentation.
Environment: SQL Server 2008/2005, Windows Server 2008/2003 Enterprise/Standard Edition, SSIS, SSRS, Visual Studio 2008/2010, Double-Take, SQL Profiler, BMC Ticketing System.
Confidential, St. Petersburg, FL R
SQL Server DBA
Responsibilities:
- Responsible for 24*7 production support.
- Actively involved in different stages of Project Life Cycle.
- Upgraded databases from SQL Server 2008 to SQL Server 2012.
- Created Users, Roles and managed security and permissions of the database.
- Installation of SQL Server, applying service pack and security fixes as necessary.
- Involved in Database optimization, performance tuning, monitoring and capacity planning.
- Worked with development team to create Stored Procedures and triggers as per application needs and deploying the same.
- Worked with SQL Profiler for troubleshooting and performance tuning.
- Worked with Index tuning wizards for development databases.
- Involved in analyzing execution plans for database optimization.
- Participated in Query tuning processes for SQL developers.
- Configured and maintained transactional replication for production servers.
- Performed Backup, Restore and Disaster Recovery.
- Prepared Step by Step Installation document.
Environment: MS SQL Server 2008/2005, Windows Server 2003, SSAS, SSRS, SSIS, T-SQL, SQL Profiler.
Confidential
SQL Server DBA
Responsibilities:
- 24*7 critical production supports for production and test servers
- Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 servers. Installed service packs.
- Upgrade SQL Server 2000 servers to MS SQL Server 2005 servers.
- Maintained critical production SQL servers and troubleshoot database problems
- Created a procedure to recover databases in the disaster situations
- Used SQL Server tuning techniques to optimize SQL queries and stored procedures
- Created the SOP (Standard operating procedures) for all SQL Server activities like Backup and Restores, Security and regular Database administration tasks
- Installed SQL Server, applied service packs and security fixes as necessary
- Experienced with improving server performance using Performance monitor tool by analyzing CPU, disk and memory devices
- Created the maintenance plans for optimization and integrity checks for all available SQL Servers
- Responsible for securing SQL Server environment, Involved in creation and granting permissions on various Objects.
Environment: MS SQL Server 2005, Windows Server 2003, SQL Profiler.
Confidential
SQL Server DBA
Responsibilities:
- DBA for SQL Server serving 4 remote locations and 15 SQL Servers
- Perform Full Backups and Transaction Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
- Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
- Monitoring SQL server, Application logs and analyzing the logs.
- Maintaining both Dev and Production servers in sync.
- Resolving various performance issues and running DBCC commands, SQL Profiler and NT monitoring tools.
- Provided administrative support for Oracle database in UNIX environment.
- Actively participate in all major oracle database activity like 9i to 10g migration and creation of physical standby