We provide IT Staff Augmentation Services!

Sql Server Dba Resume

4.00 Rating

Madison, WI

PROFESSIONAL SUMMARY:

  • Over 7+ years of IT Experience in SQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server2012/2008 R / 2000 in Development
  • Test and Production Environments on various business domains like State government, Product based, Emergency Services and Manufacturing.
  • Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000 on Clustered and Standby Environments.
  • Migration from SQL server and 2000/ by using In - Place upgrade process and as well as side-by-side upgrade process, And documented the Upgrade Process and also expert in migrating DTS packages to SSIS Packages
  • Experience in implementing and Monitoreddifferent types HA and DR scenarios like Replication, log shipping and Configure Database Mirroring in Cluster Environment on Production, QA and Dev environments.
  • Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
  • Experience in supporting Very Large Database (VLDB) more than 2TB and troubleshooting problems
  • Expertise in Database Backup and Recovery procedures by using Native, TDP/TSM and LiteSpeed to/from Disk /Legato server (Tape).
  • Very Good Experience working with SCOM Monitoring
  • Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
  • Experience in using Performance Monitor/Profiler to resolve Dead locks/Long running queries. And also good experience in data (table) partitioning.
  • Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMV’s and DMF’s, Re-indexing, Updating Statistics and online indexing.
  • Experience in Data operations for transaction Processing
  • Experience in data modeling like physical data modeling and logical data modeling by using ERWIN tool
  • Expert in data warehouse modeling (designingStar Schema, snowflakeschemas with identifying Facts and Dimensions).
  • Expertise in writing Stored Procedures, Functions and Triggers using T-SQL and also expert in tuning Complex Queries.
  • Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Checking the threshold values and baselines and monitoring in perfmon and SCOM
  • Created linked servers between SQL Server 2000 & Oracle 9i, 10g & 11g and Teradata and DB2.
  • Expertise on Business Intelligence Tools to Create SSRS Reports, SSIS Packages and SSAS with OLAP.
  • Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
  • Expertise in performing data transformations between servers using BCP, DTS, SSIS and bulk insert. And also Expert in using DMV’s, DMF’s.
  • Good understanding in database and data warehousing concepts (OLTP & OLAP). Experience with logical and physical data modeling and database design using Erwin.
  • Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
  • 24 X 7 Production Database on Call Support.
  • Strong Technical background with excellent problem solving and communication skills. Strong time management skills and excellent team player with reputation of integrity and an ability to work on multiple technologies.

TECHNICAL SKILLS:

Languages: C, C++, DDL, DML, T-SQL.

RDBMS: MS SQL Server 2012,2008R2, 2008, 2005, 2000, SQL Server Management Studio(SSMS), SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access.

Front End: MS Visual Basics 6.0.

Web Technologies: ASP.Net, WCF Web Forms, XML Web Services, HTMLMiddle Tier MSMQ, Microsoft .Net Technology.

Tools: SQL DB Access, Performance Monitor, Backup Utility, TDP/TSM, LiteSpeed, RedGate, FogLite Crystal Reports, SSRS, VSS

Web Server Technologies: IIS 5.1/6.0.

Data Modeling Tool: ERWIN 4.0, Visio 2003, Office Visio 2007

Operating System: Windows 2008, 2003, 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP.

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

SQL Server DBA

Responsibilities:

  • Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012 and Some servers upgrades Standard to Enterprise edition
  • Migrated Databases from SQL Server 2000 to SQL server 2005 and 2008, 2012.
  • Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution And Always on.
  • Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
  • Used Policy Based Administration feature (SQL Server 2008).
  • Worked with SCOM Monitoring
  • Created Table Valued Parameters (SQL Server 2008) of a table value data type and be able to pass this variable into a stored procedure.
  • Rendered Reports to Microsoft Word using SQL Server 2008.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
  • Performing Backup/Restore to/from Legato server (Tape) and Disk
  • Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
  • Expert to write the auditing scripts for SQL server
  • Expert in Performance Tuning of the Stored Procedures.
  • Checking Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning.
  • Experience in Database security and integrity planning
  • Prepared Documentation for the Disaster Recovery plan
  • Designed Data Integrator jobs with Error Handling and email notifications.
  • Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
  • Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Routine DBA jobs like Backups and Restores
  • Good experience in data modeling and metadata services.

Environment: MS SQL Server 20012,2008 R2, 2008, 2005 and 2000, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007 and 2010, Windows 2003 and 2008 Servers.

Confidential, Peachtree City, GA

SQL Server DBA

Responsibilities:

  • Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
  • Implemented SQL Data Compression Using Sql server 2008 For Compressing Data and Log Files, Back Up Level.
  • Migrating Databases from SQL Server 2005 to SQL Server 2008 by using REDGATE.
  • Worked with the table partitioning (Sql Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
  • Used Policy Based Administration feature (SQL Server 2008).
  • Created Table Valued Parameters (Sql Server 2008) of a table value data type and be able to pass this variable into a stored procedure.
  • Compare and synchronize your database schemas or data by using REDGATE
  • Rendered Reports to Microsoft Word using SQL Server 2008.
  • Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
  • Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
  • Used DTSXchange tool for migrating DTS packages to SSIS
  • Worked in Active Active Cluster environment as a High availability solution.
  • Recovered the System and User databases from suspect mode
  • Performing Backup/Restore to/from Legato server (Tape) and Disk
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Extensively used Litespeed backups
  • Expert in configuring Tempdb.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 300 TB.
  • Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Expert in Performance Tuning of the Stored Procedures.
  • Checking Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning.
  • Experience in Database security and integrity planning
  • Used log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan
  • Designed Data Integrator jobs with Error Handling and email notifications.
  • Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Routine DBA jobs like Backups and Restores
  • Good experience in data modeling and metadata services.

Environment: MSSQL Server 2008 and 2005, T-SQL, Erwin, ASP.Net 3.0, SSAS, SSIS (ETL), SSRS, SharePoint Server 2007, Windows 2003 Server, IIS 6.0.

Confidential, Detroit, MI

SQL Server DBA

Responsibilities:

  • SQL Server 2005 Database Administration.
  • Installed and configured more than 2GB RAM in SQL Server 2005.
  • Performed the migration of SQL Server 2000 to SQL Server 2005.
  • Configured the servers on 32 bit and 64 bitclustered and standalone server environments
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Responsibleto Monitor and troubleshooting Log Shipping.
  • Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services
  • Experience in trouble shooting Client connections, viewing error logs and application logs.
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file groupmodifications, and adding scheduled jobs to re-index and update statistics in databases.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
  • Expertise in SQL Server Analysis Services.
  • Expertise in creating and supporting in OLAP Cubes
  • Managed VERITAS net backups and Litespeed backups.
  • To analyze long running queries and tune the same to optimize application and system performance.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Environment: MS SQL Server 2005, ANSI SQL, SSAS, SSIS, BO XI, Informatica, MS SQL Server Reporting Services 2005 (SSRS), COGNOS, DDL, Erwin, SharePoint Moss Server, ASP.Net, ETL, Erwin, C#.Net, SAP, CSS, Java Script, XML, HTML.

Confidential, Detroit, M

SQL Server DBA

Responsibilities:

  • Database Administrator, Database Programming.
  • Relocation of Databases from one server to another server using attach and detach databases.
  • Involved in Up gradationof Touch works Database.
  • Touch works application was implemented in Active Passive clustered environment.
  • 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.
  • Migrated DTS packages from Legacy system to SQL SERVER 2005.
  • Using the Litespeed to take backups.
  • Involved in Weekly Change Management, in which code developed by developers is being run on production server.
  • Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Recovering the databases from backup in disasters.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Used DTS packages to move logins and jobs from one server to another server.
  • Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • To set up SQL Server configuration settings.
  • Used Data Partitioning in SQL Server 2005.
  • Using log shipping for synchronization of database.
  • Good experience in data modeling and metadata services.
  • Expertise in SQL Server Analysis Services (SSAS).
  • Expertise in SQL Server Reporting Services (SSRS).
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Maximum performance and uptime in production environment.
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2005, SSIS, SSRS, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.

Confidential

SQL Server Developer/ SQL Server DBA

Responsibilities:

  • Actively participated in gathering of User Requirement and System Specification.
  • Created new database logical and physical design to fit new business requirements, and implemented new design into SQL Server 2000.
  • Succeeded migrating old data from legacy system into SQL Server 2000 using DTS and Backup and Restore option.
  • Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensured database optimization by using Index Tuning Wizard, SQL Profiler and Query Analyzer (execution Plan).
  • Created Users and Roles, and managed security and permission of database.
  • Created stored procedures for Automatic Scripting to backup transaction logs, log files, maintain archive of objects.
  • Actively participated in User Acceptance Testing, and debugging of the system.

Environment: SQL Server 2000 Enterprise Edition, .NET, VB, Crystal Reports.

We'd love your feedback!