We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Perrysburg, OhiO

SUMMARY:

  • 5+ years of Database Administration and Development experience on MS SQL Server 2014/2012/2008 R2/2008/2005 in OLTP and OLAP environments.
  • Microsoft Certified Database Administrator (MCDBA) and Microsoft Certified Systems Engineer.
  • Experience installing MS SQL SERVER 2005, 2008, 2008 R2, 2012, 2014, updating with hot fix and service packs.
  • Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
  • Implemented new features in MS SQL Server 2012 like Always on HADR in prod and non - prod environments.
  • Handful experience and knowledge on High availability (HA) &Disaster recovery solutions (DR) - Log Shipping, Mirroring (High safety, High performance & High availability), Replication (Snapshot, Merge, Transactional & Peer -to- Peer), Clustering (Active-Passive &Active - Active) and Always ON (One Primary and 2 secondary replicas).
  • Implemented in place and Side by Side Migration of MS SQL SERVER 2000/2005 to 2008 R2 and 2008R2 to 2012, 2012 to 2014.
  • Experience in developing T-SQL (DDL, DML, and DCL) statements.
  • Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard.
  • Experience in Index Maintenance, Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity.
  • Experience using SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
  • Knowledge of PowerShell scripting.
  • Experience in using the DMVS, DMFS, SP PROC’s, INFORMATION SCHEMA, SYSTEM VIEWS and in-built GLOBAL VARIABLES for the instant analysis.
  • Expert in Data Integrity, Performance Tuning, Query Optimization.
  • Setup and maintain High-Availability and Disaster Recovery solutions in MSSQL using Log shipping, Mirroring, Replication.
  • Experience in identifying the I/O and memory, bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, and handling them by implementing better Query Execution plans.
  • Design indexing, referential integrity, constraints, data types, database objects like tables, views, indexes, stored procedures, triggers.
  • Worked in Objects creation such as Table, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing.
  • Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources.
  • Experience in logical and physical data modeling of the database in ERWIN and MS VISIO.
  • ITIL Process implementation (Incident/Problem/Change/Release Management).
  • Experience in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
  • Work with application teams to define database object referential integrity.
  • Handling Memory configurations for SQL Server 2012, 2008 and 2005 on Windows 2003 Server.
  • Experience in SQL Upgrades SQL 2000 to 2005 and Building SQL Clustering.
  • Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
  • Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, Event viewer for performance analysis.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Health Check, Indexing, and Updating Statistics.
  • Expert in analyzing the execution plan and index management for better Query Optimization.
  • Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
  • Worked on Repositories like Team Foundation Server (TFS).
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Diagnose and resolve performance issues, connectivity/security issues and database corruptions in a critical production environment.
  • Experience in using DMV and DBCC commands for various performance issues.
  • Used third party tools like Lite Speed, Fog light and Red gate.
  • Auditing of database for users transactions, login and database action and removing orphan users.
  • Experience with MySQL.
  • Worked with a team of business analysts, data architects, application developers, ETL developers and testers.
  • Experience in building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
  • Experience in creating deployment utility to deploy SSIS packages over Production, QA and Local System.
  • Perform MSSQL database setup, database upgrades, space management, backup & recovery.
  • Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
  • Experience working with Change control process/Change management.
  • Experience with working in Data Ware house.
  • Strong experience working with team members, documentation and 24/7 on call production support. 24*7 Production support experience.

TECHNICAL SKILLS:

Languages: Java 1.2-1.6, J2EE, XML

App. Servers: Web Sphere and JBoss

Java Technologies: Core Java, J2EE (JSP, Servlets), JDBC, Struts, Spring Framework

Data Base: Sybase, Oracle, and MySQL

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script, Shell, Sybase

Operating Systems: Windows 95/2000/2003/2008/2008 r2/2012/2012r2/XP/VISTA/7, Sun Solaris 9, VMware

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 10g/11g, MS Access

ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports

DB Utilities: SQL Server Management Utility, Query Analyzer, Toad 8.0 version

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

Data Modeling Tools: Erwin

Other Tools: Lite Speed, Red gate, Toad, Remedy, Jira Board.

PROFESSIONAL EXPERIENCE:

Confidential, Perrysburg, Ohio

SQL Server DBA

Responsibilities:

  • Manage and administer SQL server 2012/2014 servers.
  • Worked on production, and test server.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Reorganizing or Rebuilding Indexes based on the Index fragmentation.
  • Managed the use of disk space, memory and connections.
  • Performed DBCC utilities and fixed data corruption in application databases.
  • Using 3rd party tool Red Gate.
  • Performance optimization Update statistics
  • Worked on Agile Methodology.
  • Exposure to always on.
  • Created Backup strategies and scheduling them as a part of database maintenance plans.
  • Scheduling and maintaining back up jobs
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Reorganizing or Rebuilding Indexes based on the Index fragmentation.
  • Monitoring SQL server performance using profiler to find performance and deadlocks.

Environment: MS SQL Server 2012/2014, Windows 2003/2008R2/2012, SSIS, MS Access, Red Gate.

Confidential, NC

SQL Server DBA

Responsibilities:

  • Manage and administer SQL server 2000\2005\2008\R2\2012\2014 servers.
  • Maintaining SQL agent jobs.
  • Experience in writing DDL, DML statements, Indexes, Partitioning.
  • Provided RAID level suggestion for data files, log files and temp dB drives.
  • Used Index tuning wizard for optimal query performance.
  • Worked on both production and development environment.
  • Monitoring SQL Server LOGS, Application logs and analyzing the logs.
  • Experience in creating SQL Server Reports using SSRS 2005 and 2008, 2012.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Worked on different type of backups like full backup, differential and transactional.
  • Worked with T-SQL development and performance tuning in T-SQL code.
  • Participated in Performance Tuning of Code using execution plan and SQL profiler.
  • Added Indexes to improve performance on tables.
  • Used multiple join statements to retrieve data from multiple tables.
  • Experience with Data Migrations using SSIS, BCP.
  • Configuring and implementing SQL Server contained database.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • Migrations of databases from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
  • Deployment of databases, jobs, cubes from pre-production to production.
  • Building SQL 2008\R2 cluster environments on VMware or Physical windows.
  • Performed installations of SQL 2008\R2\2012 on clustered and standalone servers.
  • Up gradations of SQL server versions and applying patches and hot fixes.
  • Adding nodes to already existing clustered servers as a part of data load\High availability.
  • Configured Transactional Replication and Log Shipping with SQL Server Management.
  • Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
  • Use of Idera tools for Performance monitoring and Backup/Restores.
  • Work on weekly Issues reports which are generated as a part of infrastructure setup.
  • Reorganizing or Rebuilding Indexes based on the Index fragmentation.
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Deployment of databases, jobs, cubes from pre-production to production.
  • Performed installations of SQL 2005\2008\2012\2014 on clustered and standalone servers.
  • Upgradations of Sql server versions and applying patches and hot fixes.
  • Adding nodes to already existing clustered servers as a part of data load\High availability.
  • Configured Transactional Replication and Log Shipping with SQL Server Management
  • Worked with LDAP.
  • Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
  • Work on weekly Issues reports which are generated as a part of infrastructure setup.
  • Continuous monitoring server health with Idera monitoring tool.
  • Creating and scheduling maintenance plans for updating statistics, checking fragmentation, checking database integrity and backup plans.
  • Configured Database mail, linked servers.
  • Extensively worked on Transparent Data Encryption (TDE) and Auditing.
  • Performance tuning of databases by windows performance monitor and SQL Profiler.
  • Created Stored Procedures, Triggers, Views and Functions for the Application.
  • Working on the Performance of the Stored Procedures.
  • Working on JIRA as project management tool.
  • Mentoring junior team members and creating documents on daily basis.
  • 24* 7 on-call production support.

Environment: MS SQL Server 2005/2008/2008 R2/2012/2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL, MS Access, JIRA, PUMA

Confidential

SQL Server DBA

Responsibilities:

  • Installation and configuration of MS SQL Server 2008/2008R2.
  • Troubleshoot Performance issues on production environments using Performance counters, extended events/Profiler to find the resource bottlenecks.
  • Resolve locking and blocking issues.
  • Refresh non-prod environments with production data on regular basis.
  • Implemented data availability solutions like online restore, online index, database snapshot and fast recovery.
  • Used Joins and sub-Queries to simplify complex queries involving multiple tables, added Columns, triggers.
  • 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 the physical design for database.
  • Writing Stored Procedures to meet the 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 2005.
  • Used log shipping for synchronization of database.
  • Experience in writing DDL, DML statements, Indexes, Partitioning.
  • Provided RAID level suggestion for data files, log files and temp dB drives.
  • Used Index tuning wizard for optimal query performance.
  • Monitoring SQL Server LOGS, Application logs and analyzing the logs.
  • 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 2008 for faster execution and developed database structures.

Environment: MS SQL Server 2008/2005, T-SQL, MySQL, Windows NT/2000/2003

Hire Now