We provide IT Staff Augmentation Services!

Sql Server Dba Resume

5.00/5 (Submit Your Rating)

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
Environment: SQL Server 2000/2005, Oracle 9l/10g, AIX UNIX & Windows NT 4.

We'd love your feedback!