We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)

Hoboken, NJ


  • 7+ years of experience in Database Administration and Development for very large and complex databases on SQL Server 2012, 2008 and SQL Server 2005/2000.
  • Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
  • Experience with SQL 2012 ALWAYS ON and upgrades from SQL 2008
  • Implemented the new SQL Server 2008 R2 mechanisms like DDL triggers, data compressions, backup compression, online indexing, security with principals and securable.
  • Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
  • Experience in high availability SQL Server solutions, including Log Shipping, Replication, Mirroring and SQL Server Clustering.
  • Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, clustering, Replication and SRDF).
  • Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer and also Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS).
  • Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
  • Expertise in planning and implementing MS SQL Server Security and database Permissions.
  • Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis.
  • Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
  • Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008.
  • Experience in Data Migration from MS SQL server and from .
  • Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive environment.
  • Administering SQL Server High Availability and Disaster Recovery strategies.
  • Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
  • Strong experience in mentoring team members and writing documentation.24 X 7 Production Database on Call Support.
  • Good interpersonal skills, committed team player with team driven skills.
  • Good communication skills, written and verbal presentation skills.


Databases & Services: SQL Server 2000/ 2005/2008/2012 , MS - ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs,, ODBC, JDBC

Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services

Programming/Scripting: T-SQL Programming

Operating Systems: Windows XP/NT/ 2000/2003/2008 , Vista, UNIX

Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.


Virtualizations: VMware vSphere client, ESX 3.0, 4.0 and ESXi4.1.


Confidential, Hoboken, NJ

SQL Server DBA


  • Managed security on Production and Development environments.
  • Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
  • Creating and maintaining various databases on Production and development environments usingSQLServer 2008/2012.
  • Created jobs to import/ export data obtained from various States to update the GIS servers.
  • Installed and configured SQL Server Reporting Services. Installed necessary Service Packs for SQL server 2005.Installed SQL server2005,2008and2012on a test environment to be the future production environment. Upgraded legacy 2000 databases to SQL server2005/2008.
  • Involved inDatabase Backupandrecovery.
  • Implemented high availability on the various servers usingreplication/mirroring.
  • Tuned databases for better performance.
  • Created and maintained various logins and managed security based on the required access.
  • Implemented and tested the point in time recovery of the production databases.
  • Involved in migrating share point from one server to the other.
  • Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
  • Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
  • Optimized the performance of queries with modifications inT-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
  • Loaded the data into another data sources (Oracle, SQL Server) usingSSIS.
  • Created variousSSISpackages based upon the requirement.
  • Created various reports usingSSRS.
  • Scripting theDatabase Consistency Checks(DBCC), scheduling the scripts to run daily and weekly basis.
  • Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes andfine tuningStored Procedures).
  • Data migration usingDTSservices across different databases like Oracle, MS access & flat files.
  • Contacted various users in gathering the requirements and documented the necessary changes.
  • Analyzed variousbackupcompression tools available and made the recommendations.
  • Created necessary templates for various requirements gathering anddocumentation.

Environment: Windows 2000/2003, MS SQL Server 2005/2008/2012 , ETL, Oracle10g/11g, SSRS, DTS, SSIS, SQL Server Profiler,VB.Net, T-SQL, Erwin 4.0, Erwin 3.5.2, Database engine tuning Advisor, IIS.

Confidential, Jersey City, NJ



  • Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
  • Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
  • Implemented SQL Server high availability solutions including clustering, replication and log shipping.
  • Worked in Active/Passive and Active/Active cluster environment.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
  • Experience in Database Backup and Recovery procedures.
  • Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
  • Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
  • Migration of databases from SQL server 2000 to SQL server 2005.
  • Disaster recovery and Log shipping of SQL Servers meeting the Service level agreements for the various customers.
  • Experience in implementing different types of Replication models like Transactional replication.
  • Successfully planned and implemented SQL Server 2005 Database Mirroring.
  • Implemented Database Mirroring on SQL Server 2008 environments.
  • Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
  • Implemented transactional replication for data refresh.
  • Providing 24x7 technical database supports for SQL Database systems.
  • Experience in supporting and managing multiple Production, Staging & Development instances.
  • Managed all Publisher, Distributor and Subscriber database environments for the replication.

Environment: MS SQL Server 2008/2005/2000 , Windows 2003/2000 Server Operating systems, IIS 6.0, .NET, T-SQL,SSIS, SSAS, XML.

Confidential, San Francisco, California



  • Performing SQL server daily health check and preparing a report based on it.
  • Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
  • Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
  • Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
  • Participated in DR installation and trouble shooting(Mirroring, Logs hipping and High availability Cluster.
  • Applying Service Packs and Security patches for the Servers as released.
  • Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
  • Monitoring the Log Space for successful execution of all the specified jobs.
  • Managing backups on a daily basis and recovery (as per request).
  • Reviewing SQL Server and SQL Server Agent Error Logs.
  • Monitoring of server performance by profiler during peak periods of server utilization.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
  • Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
  • Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.
  • Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.

Environment: SQL Server 2005, SQL Server 2008, Windows 2008, Windows 2003 EE, Cluster.

Confidential - Alpharetta, GA



  • Extensively involved in database mirroring, creating Back up Strategy. Resolving Dead locks and blocking issues.
  • Extensively Involved in Designing (Logical and Physical) of Customer Database. Created & managed the Database Users, Login and Security.
  • Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. Removed fragmentation from indexes.
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.
  • Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail
  • Administrator tasks such as managing users, roles, and profiles.
  • Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server.
  • Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
  • Experienced in performance tuning using Windows performance monitor and SQL profiler of SQL server.
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP. Extracting, Transforming and loading of data using SSIS.
  • Deployed and scheduled SSIS Package. Performed analysis and design of the application.
  • Experience in with tools like Microsoft Reporting Services (SSRS). Created and deployed and scheduled report using SSRS.

Environment: SQL Server 2005/2000, (Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler), Clustering, MS Access, My SQL, MS Excel, MS Word, and Windows XP




  • Wrote T-SQL statements using DML and DDL for retrieval of the data.
  • Used DTS service for the data transformation from source to target database.
  • Supported clustering and replication for servers.
  • Created complex stored procedures, triggers and cursors in SQL Server.
  • Developed source to target specifications.
  • Maintained cluster servers to provide high availability.
  • Developed stored procedures, functions, views and triggers.
  • Created DTS package to schedule the jobs for batch processing.
  • Scheduled the DTS packages using the Data transformation services SQL2005.
  • Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows Server 2003, SSRS, SSIS, Transact-SQL, DTS


MS SQL Developer


  • Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
  • Designed application database on coded objects such as stored procedures and views.
  • Utilized SQL scripts and complex queries to analyze and extract data.
  • Supported business applications using T-SQL.
  • Provided database coding support using SQL server environment.
  • Tested the quality of application developers including data file for counterfeits.
  • Normalized the status of new discovered processes and applications.
  • Identified business needs and requirements including business securities.
  • Modified existing applications to ensure data integrity and security.
  • Performed disaster recovery plans for all data services.

Environment: MS SQL Server 2000, 2005, Windows Server 2003, 2000, SSIS, SSRS.

We'd love your feedback!