We provide IT Staff Augmentation Services!

Sql Server Dba, Senior Advisor Resume

2.00/5 (Submit Your Rating)



  • 7+ years of experience as Database Administrator, Architect and Developer in Production, Development and Testing Environments.
  • 24/7 On Call Support for Production server
  • Extensive experience in Installation, Configuration and Administration for SQL Server in a Clustered and Non - Clustered environments with single and Multi Instances.
  • Strong working knowledge with 32 and 64 bit Windows 2000/2003/2008 servers.
  • Experience in migrating teh databases from SQL Server 2000 to SQL Server 2005/2008.
  • Extensive experience in Upgrading SQL Instances using Side by Side and In-place Upgrade.
  • Experience in scheduling Backups, Restore and Maintenance plans using Native and Third-party tools (Lite Speed)
  • Experienced in using different Recovery models Simple, Full and Bulk-logged depending on Application requirement.
  • Experienced in high availability solutions with SQL Server Failover Clustering, Database Mirroring in (Synchronous and Asynchronous modes).
  • Experienced in implementing Log shipping and Replication (Snapshot, Transactional and Merge Replications)
  • Experienced in planning and implementation of Storage Area Network (SAN) for Clustering in Active-Active/Active-Passive Environments.
  • Experienced in Log Shipping with single and multi stand by Databases with scripts and Tools (Lite speed)
  • Experienced in Installing, Configuring, Developing and Deploying SSRS using local, scale out and scale up Topologies.
  • Experience in Designing, Developing, Testing and Deploying SSIS packages.
  • Experience in creating and automating jobs, alerts, SQL Mail Agent and SSIS packages in SQL Server.
  • Extensively worked in Designing, processing and Administration of cubes using SSAS.
  • Experience in analyzing execution plan, me/O statistics, index tuning for SQL queries.
  • Good skills in optimizing teh performance of teh database and running Database Consistency Check scripts for databases.
  • Creating Linked Servers for OLEDB Databases.
  • Extensive experience with data modeling, logical and physical database design.
  • Experience with establishing and maintaining security integrity controls.
  • Solid experience with creating alerts, schema management, database reorganization, data loading.
  • Extensive experience in controlling teh User Privileges, Monitoring teh Security and Audit issues as per SOX Standards.
  • Experience in Performance Tuning Query Optimization, Client/Server Connectivity, and Database consistency checks using DBBC utilities.
  • Worked in development environment, with knowledge of Query estimation, Index tuning wizard and database Optimization techniques.
  • Hands on experience with SQL Server and T-SQL in constructing triggers, joins, user defined functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Proficient in server Capacity Planning in clustered, non-clustered and SAN environment.
  • Implementing SQL server best practices and improvising server and instance consolidation, understanding of RAID-1, RAID-5 implementation for highly OLTP environment.
  • Implemented Third party tools Litespeed, IDERA SQL compliance, SQL Diagnostic manager, SQL solutions deadlock detector, Redgate SQL Compare for schema comparison, SpotLight performance monitoring and performance improvement.
  • Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.


Languages: T-SQL, HTML, XML, C/C++.

Operating Systems: Windows 2000/2003/2008/XP/VISTA/7

Databases: MS-SQL Server 6.5/7.0/2000/2005/2008/2012, MS Access

ETL Tools: Data Transformation Services, SSIS

DB Utilities: SQL Server Management Utility, Query Analyzer

Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite

Third party Tools: Erwin, Visio, SQL DB Control, Red gate, Lite Speed, Idera, Quest, SQL Solutions Etc.


Confidential, MD

SQL Server DBA, Senior Advisor


  • Responsible for installation and maintenance of all teh SQL Server 2005/ 2008 R2 servers with teh design, document, development, enhancement and support of MS SQL Server databases.
  • Involved in Architectural design for teh databases and database tables and capacity planning.
  • Responsible to assign permission to user(s), role(s), and object. Support column level permission and Administrate security for server’s logins (Windows and SQL Accounts).
  • Involved in setting up teh SQL Server Integration Services (SSIS) and SQL Data Transformation Services (DTS) for data migration and Extracting and Transforming data between different servers.
  • Implementing and administrating Transactional replication as disaster recovery solution
  • Configure, maintain and troubleshoot replication for databases as large as 40 TB.
  • Implemented methodologies such as making changes to teh distributor properties, subscription stream parameters etc., to improve teh latency of heavily replicated articles.
  • Prepared scripts for manual configuration replication both by snapshot and by database refresh.
  • Troubleshooting log reader latency issues, distributor latency issues, data consistency issues while replicating deferred updates.
  • Prepare and notify teh management about daily status of replication and latency
  • Taking schema only backups and refresh teh databases with schema, compare schema on teh databases and finding out teh abrupt changes
  • Developed new database Maintenance plans which involves Create statistics, Update statistics, rebuilding teh Indexes, Database Integrity checks for all teh newly built SQL Server 2008 R2 servers.
  • Performed all aspect of database administration, including backup, recovery and Log Shipping for SQL 2008 R2.
  • Identifying and analyzing deadlocks investigate teh statements and provide suggestions to developers.
  • Design and schedule jobs regarding reclaiming space in a timely manner for better performance of teh servers.
  • Monitor teh indexes fragmentation status and schedule teh reorganize and teh rebuild jobs accordingly.
  • Experience in scheduling Backups, Restore and Maintenance plans using Native & Third-party tools (Lite Speed)
  • Migrating DTS Packages into SSIS using Upgrade Advisor and DTS Designer.
  • Rebuilding teh Indexes at regular intervals for better performance.
  • Tuned SQL queries and Stored procedures using SQL Profiler.
  • Experienced in implemented Log shipping and Replication (Snapshot, Transactional and Merge Replications)
  • Involved in teh performance fix deployments, new code deployments, Migration of teh servers, Rebuilding databases.
  • Provided on-call support for performance activities such as data purging and operations processing and maintenance tasks.
  • Work with Microsoft support to troubleshoot disk related performance issues and unidentified abrupt system shutdown issues.
  • Involved in database and log backups & restoration, backup strategies, scheduling.
  • Backing up master & system databases and restoring them when necessary.
  • Verify backups and error logs on teh servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
  • Spontaneously responding to teh tickets assigned to me and fixing any database issues and working on projects that me have been assigned to as a resource from teh Database Management team.

Confidential, Irving, TX

SQL Server DBA


  • Installation and Maintenance of SQL Server 2005/2008(R2) on Test, Development and Production Environments.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Usage of new compression Techniques in SQL Server 2005/2008(R2) for backup and restore jobs.
  • Experience working with TSM Backups and Restore.
  • Disaster Recovery Planning, Testing and Analyzing and continuous update of documentation.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Creating Logins and Roles with appropriate permissions.
  • Creating and Maintaining Database Maintenance Plans.
  • Configured Database Mail for failure Job notifications
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Tune slow running queries using SQL Server Profiler
  • Worked with database tuning advisor, SQL server profiler, Performance monitor and activity monitor for Performance tuning
  • Experience working with IDERA in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Extract, Transform, and Load data from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Plan, analyze and develop Ad-hoc Reports using SQL Server Reporting Services (SSRS) and Report Manager to support various user requirements.
  • Worked with DTS Packages to load data into Data Warehousing System.
  • Create and manage database objects that include Tables, Views, User-defined Functions, Stored Procedures, Constraints and Triggers to implement Business Logic.
  • Create Clustered and Non-Clustered Indexes to improve teh performance of database access.
  • Extensively worked on performance issues like Update statistics and Autostats
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Optimized teh database server usingDMV’s and DMF’sand performed acode reviewandtuningfor teh best performance of teh application.
  • Involved in Logical and Physical Data Modeling process using MS Visio.
  • Use MS Visual Source Safe as a Version Control System.
  • Involved in Change Data Capture process.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Mentored team members to optimize SQL Queries.

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 (R2), Microsoft SQL Server 2005, Windows 2003/2008 Server, IIS Server 7, MS Visual Source Safe, IIS 6.0, XML.

Confidential, Atlanta, GA

SQL Server DBA


  • Installed and configured SQL Server 2005/2008 on teh server and client machines, provide connections and manage databases.
  • Create and maintain various databases for Production, Development Servers using MS SQL Server 2005/2008.
  • Planning teh location of data, indexes, and Transaction log files on teh disk.
  • Use of DBCC Utilities to maintain teh consistency and integrity of each database in teh production server.
  • Conducted root cause analysis of application availability and narrow down teh issues related to coding practices, database bottlenecks, or network latency.
  • Resolve locking and blocking issues.
  • Experience in memory configuration for SQL server on 32-bit boxes
  • Tuning teh Production server to get teh performance improvement.
  • Running Index tuning wizard for optimal query performance.
  • Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery
  • Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
  • Experience working with SQL Solutions tool in Server Monitoring for Performance Monitoring, Dead Lock, Blocking.
  • Monitoring SQL Server LOGS, Application logs and analyzing teh logs.
  • Providing 24*7 support to SQL application developers in implementing teh applications on production server.
  • Reorganizing or Rebuilding Indexes based on teh Index fragmentation
  • Maintaining both DEVELOPMENT and PRODUCTION Servers in sync.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Creating Backup strategies and scheduling them as a part of database maintenance plans.
  • Created teh SSIS packages for executing teh required tasks. Created teh Jobs and scheduled for daily running.
  • Involved in Performance Tuning for source databases, target databases.

Environment: MS SQL Server 2005, MS SQL server 2008, Windows 2000/2003/2008 server, IIS Server 5.0, SSIS, Reporting Services, XML.

Confidential, Milwaukee, WI

SQL Server DBA


  • Worked on Client/Server tools like SQL Server Management studio (2005)/(2008), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
  • Migrated SQL server 2000 databases into SQL server 2005 and SQL server 2005 databases into SQL server 2008 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
  • Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
  • Migrated DTS packages into SSIS packages.
  • Handled up to 2 TB Size databases with clustered and stand alone environment
  • Configured Transactional replication on migrated server.
  • Wrote teh packages using SSIS in SQL2005.
  • Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks.
  • Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
  • Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks.
  • Planned teh Complete Backing up of Database and Restoring teh Database from Disaster Recovery.
  • Used DTS packages to move logins and jobs from one server to another server.
  • Used log shipping for synchronization of database.
  • Good experience in data modeling and metadata services.
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Created Stored Procedures, Triggers, Views and Functions for teh Application.
  • Extensive testing on teh Performance of teh Stored Procedures.

Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY ANALYSER, C#, WINOWS SERVER 2003/2008, SSAS.


MS SQL Server Developer/DBA


  • Installing and configuring and tuning and providing 24X7 support for SQL Server 2000 and 2005 in development and production environments.
  • Created and scheduled jobs to setup log shipping between production servers.
  • Implemented Database Mirroring on teh SQL Server 2005 production databases.
  • Job Monitoring and making sure all jobs run successfully every night.
  • Creating databases and logins with permissions in SQL Server 2005 as per teh developer’s request.
  • Worked extensively on SQL Server Reporting Services to generate reports.
  • Created Linked Servers between SQL server 2000 and 2005 servers.
  • Involved in Migration from SQL Server 2000 to 2005.
  • Created Database Diagrams using ERWin Data Modeler.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
  • Migrated and tested DTS packages to SQL Server 2005 Integration Services.
  • Created Database Maintenance Plans for teh Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Involved in teh creation of cubes in teh MS SQL Analysis Services.
  • Restore Development and Staging databases from production backups as per teh requirement.
  • Extensively used SSIS to move data from text files to SQL Server.
  • Monitor backup jobs daily and run teh jobs manually in case of failure depending upon teh necessity.
  • Prepare daily report on teh job failures, backup failures and disk space.
  • Extensively used Database Performance Monitoring tools for performance tuning.
  • Designed and implemented database maintenance plan.
  • Used Index tuning wizard and rebuilding indexes for faster Query Performance.
  • Involved in resolving dead lock issues and performance issues.

Environment: MS SQL Server 2000/2005, IIS Server 5.0, Windows 2000/2003 servers, Outlook Express, .NET, MS Access.


SQL Server Developer


  • Installation and configuration of MS SQL Server 2003/2000/7.0
  • Created Stored Procedures, User defined functions, Views and Wrote T- SQL codes maintaining query standards for teh project.
  • Involved in Optimization and normalization of database and tables.
  • Involved in conceptual and physical modeling of data using ERWin tool.
  • Developed stored procedures, triggers and functions and added/changed tables for data extraction and transformation, and data loading (ETL).
  • Part of team for analyzing and implementing teh physical design for database.
  • Writing complex Stored Procedures to meet teh business requirements.
  • Designing logical and physical database structure to facilitate analysis of data from both operational and customer perspectives.
  • Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
  • Designing and building data load procedures, using MS SQL Server.
  • Wrote DTS ActiveX scripts that extract data from database tables and write teh data to text files
  • Responsible for transferring of database and database objects from Development to Production Server using DTS.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
  • Involved in Analysis and tuning complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures.

We'd love your feedback!