We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Santa Monica, CA

SUMMARY

  • IT Professional with 6+ years of experience in SQL server Database Administration and SQL Server development.
  • Experience in installation, maintenance of different versions of SQL Servers (2014, 2012, 2008R 2/2008/2005/2000 ) in both OLTP and OLAP lower regions and Production environments.
  • Implemented High Availability & Disaster Recovery techniques like Always ON Availability Groups, Clustering (Both Active - Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
  • Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012.
  • Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014 new features.
  • Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and Database Maintenance.
  • Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
  • Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
  • Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
  • Experience in Physical and logical data modeling using ERWIN & VISIO.
  • Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
  • Experience in developing and tuning SQL Server Integration Services (SSIS) packages and SSRS reports.
  • Configuring and maintaining Report Manager and Report Server for reporting services
  • Handled numerous Change Management requests on production servers and Supported 24 X 7 Production on Call.
  • Documenting procedures in runbooks.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and Database,Administration of MS SQL Server 2014/ /2005/2000 /7.0 ,Oracle.

ETL Tools: MS SSIS and DTS, TSQL, SQL Server bulk insert and BCP utilities

Tools: IIS, SSIS, DTS, Lite Speed, Spotlight, Visual Studio 2003/2005, Team Foundation Server (TFS), Visio 2003, Enterprise manager, query analyser, Perfmon, SQL Profiler, Idera, Foglight, Red gate, Tivoli, Symantec Net Backup

Languages: SQL, TSQL, C, C#

Markup Languages: HTML, XML

Operating Systems: Windows NT/2000/XP/2003, 2008/2008R2/windows2012/Windows 2012R2, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

SQL Server DBA

Responsibilities:

  • Installed SQL Server 2014/2012/2008 R2 on Windows Clustered and standalone environments with latest service packs.
  • Upgraded SQL server databases from 2008R2 to 2012/2014
  • Experience in working and troubleshooting2TB Very Large databases (VLDB) in OLTP Environment.
  • Configured AlwaysON availability groups in SQL server 2012
  • Configured log shipping for multiple databases as a part of DR.
  • Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
  • Extensively worked with SQL Profiler, Activity monitor, Perfmon, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues.
  • Analyze long running slow queries and tune the same to optimize application and system performance.
  • Reorg/Rebuilding the indexes at regular intervals for better performance
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
  • Involved in trouble shooting and fine-tuning of databases for its performance.
  • Improve the performance of SQL Queries and stored procedures using SQL Profiler.
  • Configuring TEMP DB on files and file groups and capacity planning of databases.
  • Configuring and deploying SSIS packages and SSRS reports.
  • Documenting procedures in run books.

Environment: SQL Server 2014, 2012, 2008R2, 2005, Windows 2012, 2003 Server, Symantec netbackup, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

  • Managed and Administrated the SQL Server 2012/2008R 2/2008/2005/2000 production and Non-production servers.
  • Installation of SQL Server 2012/2008R2/05 on Windows Server Clustered environment.
  • Upgraded/Migrated SQL Server 2005/2008 databases to SQL Server 2008R2 and SQL server 2012 databases.
  • Migrated SQL Server 2005 databases to SQL Server 2008r2 databases including DTS to SSIS packages.
  • Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
  • Configured Backups, optimization jobs and involved in restoring database to point in time in case of issues, troubleshooting long running queries, locks, deadlocks and performance issues.
  • Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression, SQL Server Auditing, Resource Governor and MERGE statement in T-SQL.
  • Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
  • Monitored Log shipping/ Transactional Replication and troubleshooting errors.
  • Extensively worked on Profiler, Perfmon, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
  • Managed Security using SQL Logins, Roles and Security Modes for various users.
  • Configured and deployed SSIS Packages from Test to Production Environments.
  • Supported 24 X 7 Production On call

Environment: SQL Server 2000/20 R2/2012(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, Dallas, TX

SQL Server DBA

Responsibilities:

  • Installing and Maintaining SQL server 2008/2008R2
  • Upgrading SQL server databases from SQL 2000/2005 to SQL2008R2
  • Recovering the databases from backup in disasters
  • 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
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Working with customers on Application rollouts and server migrations.
  • Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers.
  • Troubleshoot performance problems and fine-tuning of databases.
  • Involved in Index Analysis and Performance Tuning.
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, SQL LiteSpeed 4.5, Visio. Enterprise Manager, SQL Query Analyzer, SQL Profiler.

Confidential, WA, DC

SQL Server DBA/DEVELOPER

Responsibilities:

  • Upgrading SQL Server 2000 to SQL Server 2005/2008.
  • Installing and maintaining SQL Server 2000/20 r2.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Designed the reporting databases using ERWIN.
  • Used Query hints to Tune the SQL queries for maximum efficiency and performance.
  • Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
  • Performance testing on stored procedures, indexes, and triggers.
  • Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
  • Worked in active/active and active/passive cluster environment
  • Data migration using bulk copy program and DTS.
  • Helping the front-end application developers with their queries.
  • Job Monitoring and making sure all jobs run successfully every night.
  • Performing low-level scripting, fixing of codes and software enhancement process.
  • Performed Database backups with tools like litespeed.
  • Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
  • Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services.
  • Suggest Replication techniques to meet business needs.
  • Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
  • Analyzed execution plans, and tuned queries and databases for better optimal performance.
  • Fixing Missing Indexes and Excess indexes.
  • Generated script files when changes applied to stored procedures and functions.

Environment: MS SQL 2000/2005/2008 , Windows NT/2000/XP, SSIS, SSRS, SSAS, MS Access, MS Excel, VB.NET, C#, OLAP.

Hire Now