We provide IT Staff Augmentation Services!

Sql Server Dba Resume

PROFESSIONAL SUMMARY:

  • Experience in data modeling including physical and logical, ERwin and Toad Data Modeler as well as script generation for forward/backward engineering.
  • Experience in Installing, Configuring, Managing, Monitoring, SQL Server 2005, 2008R2, 2012, and 2014.
  • Expertise in implementation of security models; creating users, roles, permission, Transparent data encryption (TDE), data masking as well as server authentication modes.
  • Experienced in writing Stored Procedures, Functions, and Triggers using T - SQL.
  • Upgrade from SQL server 2005 to 20008 R2 and 2012 by using side-by-side, in place as well as the documentations.
  • Architecture planning and install for upgrading to SQL server 2014.
  • Windows Service Pack, hot fixes, cumulative updates, and patches on windows server 2003, 2008R2, and 2012R2.
  • Strong work experience and knowledge with SQL Server Database Mirroring, Replication, Log shipping.
  • Configured and managed AlwaysOn in Cluster Environment.
  • Expertise on Business Intelligence Solutions to Create SSRS Reports, SSIS Packages, and SSAS with OLAP.
  • Performed data transformations between servers using BCP, DTS, SSIS, and bulk insert.
  • In depth knowledge of native SQL Server tools, such as SQL Profiler, Index Tuning Wizard, Query Analyzer, Activity monitor.
  • Proficient in resolving performance problems, lock, block and deadlocks.
  • Database Consistency Checks using DBCC and DMV's and Re-indexing, Updating Statistics.
  • Monitoring Event Viewer, SQL Server Error logs, and Log File Viewer for Software and hardware related errors.
  • T-SQL, Trigger, and Stored-Procedures.
  • Assisted Database Developers to optimize SQL queries and Stored Procedures.
  • Expert in data warehouse (designing Star Schema, snowflake schemas with identifying Facts & Dimensions).
  • Experience in supporting very large database (VLDB) more than 1.00 TB and troubleshooting problems.

TECHNICAL SKILLS:

Database: SQL Server 2005, 2008R2, 2012, 2014.

Operating System: Windows Server 2012R2, 2008R2, 2003, VMware.

Data Modeling: Toad Data Modeler, ERWin, SSDD (SQL Server Database Diagram).

SQL Tools: Query Analyzer, Profiler, Query Execution Plan, Management Studio.

ETL Tools: SSIS/DTS, BCP, SSDT-BI SSIS/DTS, BCP, SSDT-BI.

Performance Monitoring Tool: Profiler, PerfMon, Activity Monitor, Database Tuning Advisor, Execution Plan, DMV.

Reports Development/Management: SSRS (SQL Server Reporting Services), MS Access, Excel.

Programming: SQL, T-SQL, JOIN, Stored Procedures, Trigger, Functions.

Networking: Active Directory, TCP/IP.

Hardware/Storage: SAN, RAID, Cloud.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

  • Installed and Upgraded from SQL Server 2005 to SQL server 2008 R2 and 2008 R2 to 2012.
  • Migrated Databases from SQL Server 2005 to SQL server 2008 R2, also 2008R2 to 2012 and 2014.
  • Prepared documentation for the Disaster Recovery Plan and performed Backup and Restore.
  • Worked in Active-Passive, Active-Active Cluster as a High Availability solution.
  • Configured and maintained Database mirroring with High Safety and High Availability automatic failover.
  • Created new database objects like Tables, Procedures, Functions, Indexes, and Views using T-SQL in development and production environments.
  • Designed data integration jobs with Error Handling and email notifications.
  • Performed query tuning on slow running queries using Profiler and Statistics I/O by using different methods in terms of evaluating joins, indexes, updating Statistics, and code modifications.
  • Created Stored Procedures, Triggers, Cursors, Tables Joins, and Statements for Applications by using T-SQL.
  • Worked with TDE (Transparent Data Encryption), Data Masking, table compression, database compression, and merge statements using SQL server 2008 R2 and 2012.
  • Generated periodic reports based on the Statistical Analysis of the data using SSRS.
  • Experience with OLTP and OLAP databases to include reporting and data modeling.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Experience in database security and integrity planning.
  • Daily DBA routine tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.

Environment: MS SQL Server 2012, 2008 R2, and 2005, T-SQL, Red Gate, ASP.Net 3.0, SSAS, SSIS, SharePoint, (ETL), SSRS, Windows 2003 R2 and 2008 R2 Servers.

Confidential

SQL DBA

Responsibilities:

  • Installed and configured SQL server 2012 on virtual machine.
  • Applied patch to SQL server on a virtual machine.
  • Managed SQL instances/servers on a two node cluster.
  • Migrated SQL databases from physical cluster server to a virtual machine.
  • Administering Microsoft servers and Microsoft SQL server databases.
  • Creating and managing disaster recovery procedures
  • Automating jobs such as backup, index building and index reorganizing
  • Actively managing database and backup growth(purging)
  • Responding to incident tickets.
  • Creating and resolving remedy tickets
  • Extracting and exporting data from development, test, pre-production and production environment.
  • Auditing database error logs
  • Auditing database security using splunk server.
  • Monitoring database growth.
  • Creating and assigning permissions to user accounts.
  • Deploying database change codes.
  • Managing and administering cluster for Microsoft SQL servers.
  • Monitoring server and database security.
  • Creating and executing database maintenance plans.

Hire Now