Professional Summary

• 5+ years of experience in SQL server Database Administration using MS SQL Server versions 2005, 2008, 2008 R2, 2012, 2014 and 2016
• Experienced in setting up high availability and DR options like log shipping, mirroring, replication ( Transactional or Snapshot) and AlwaysOn Availability Groups
• Proficient with SQL Server Disaster Recovery, Backup/Restore and creating Business Continuity Planning.
• Experience in Database Migration, Migrated SQL Server 2008 to SQL 2008R2, SQL Server 2008R2 to 2012.
• Proven experience in creating implementing Database objects like Stored Procedures, Triggers, Views, User Defined Functions
• Well experienced in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV's.
• Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail.
• Experienced in using Joins and Sub Queries for the simplification of complex queries including more than one tables
• Experience in implementing SQL Server security and managing permission to the Database through Database roles, Creating Users and Logins.
• Experience in writing and tuning T - SQL (Transact-SQL) (DML/DDL/DCL) Queries.
• Hands on experience in maintaining SQL Server Clustering (Active-Active/Active-Passive)
• Experience in ETL (Extract, Transform and Load) using SSIS (SQL Server Integration Services) in SQL Server 2012 with Import/Export Data, Bulk Insert.
• Solid experience in troubleshooting and performance tuning by using activity monitor, performance monitor, DBCC, DMVs, DMFs and third party tools such as Spotlight, Idera monitoring
• Experienced on working with production Servers and 24 x 7 On-Call environments.
• Applied Service Packs and security updates for SQL server instances
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills as well as flexible to learn advancements in the IT industry.

  WORK EXPERIENCE

  Confidential, Frisco, TX

  SQL Server DBA

  Responsibilities:

  • Installed, Configured and Maintained SQL Server 2014 / 2012 / 2008 R2 in multiple database environments.
  • Installed and configured SQL Server in a standalone or Clustered Environment.
  • Handled Performance Tuning and Optimization of slow running queries
  • Detected and resolved CPU, memory, I/O, disk space and other resource contention issues
  • Migrated SQL server 2008 R2 to SQL server 2014
  • Worked on Priority 1 and 2 Critical Incidents to meet the Response and Resolution Service Level Agreements (SLA)
  • Resolved Security related issues to logins, users and application roles and linked Servers.
  • Created SQL server Agent jobs and maintenance plans to automate tasks such as to run Index Maintenance, Index Defragmentation, Rebuild, Update statistics and capturing deadlocks using Trace flags.
  • Performed Database Consistency Checks (DBCC), scheduling the scripts to run daily or weekly depending on the need
  • Performing routine tasks like disk space check, Consistency checks, looking for slow/long running queries and hung jobs.
  • Performed SQL server post-installation activities (Configuration changes) and best practices to improve the overall server and database performance.
  • Performed service packs update, security updates and hot fixes on clustered and standalone servers.
  • Diagnose system problems, evaluate alternative solutions and take initiative to solve problems.
  • Monitored index usage and tuned them where appropriate
  • Performed production code deployments, verification and rollback (only when needed) and supported maintenance window activities

  Environment: SQL Server 2008 R2, 2012, 2014, Windows 2008 R2, and 2012 R2, Spotlight, SharePoint 2003, ServiceNow, SSIS, SSRS, Management Studio, SQL Profiler and Database Engine Tuning advisor

  Confidential, Lewisville, TX

  SQL Server DBA

  Responsibilities:

  • Installed, configured and maintained MS SQL on clustered and standalone production servers, Staging and development environment
  • Optimized slow running queries and stored procedures
  • Implemented security standards for HIPPA (Health Insurance Portability and Accountability Act) to protect patient's information
  • Excellent experience on configuring and maintaining replication like transactional and snapshot replication
  • Implemented High Availability and Disaster Recovery solutions with SQL Server DB Mirroring, Log Shipping and Failover Clustering (Active-Passive / Active-Active)
  • • Experience in SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
    • Created Database and Server level Audit specification using the SQL Server Audit Feature and analyzed the audit results.
    • Created a SQL Batch Job of the same and maintained to the optimal needs.
    • Used new features like row and page compression mechanism, Data Compression, and Backup compression
    • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures and data changes
    • Managed Capacity planning for the primary assigned servers to ensure adequate CPU, Disk space and Memory.
    • Experienced with SSIS and SSRS package creation and deployment.

  Environment: SQL Server 2008, 2008R2, 2012, SSRS SSIS, TSQL, TFS (Team Foundation Server), Windows Server 2008, 2008 R2, 2012

  Confidential, Ethiopia

  SQL Server DBA

  Responsibilities:

  • • Installed new SQL instances, applied service packs, performed in-place and side-by-side upgrades based on the build requests.
    • Created Stored Procedures, triggers, cursors, tables, and views and Join statements for applications by using T-SQL.
    • 24x7 Production DBA support and monitoring to ensure a proactive problem recognition and resolution of database issues.
    • Maintained the table performance by normalization, creating indexes and collected statistics by using query optimization, query execution plans, SQL Server Profiler and Database engine tuning Advisor.
    • Troubleshooting issues in Production, Development, QA, and Testing environments
    • Scheduled backups and performed restore operations for system test data depending on developers’ requirement.
    • Involved in disaster recovery procedures for production servers.
    • Performed T-SQL tuning and optimizing queries.
    • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.

  Environment: Windows Server 2003, SQL Server 2008 and 2008 R2, SQL Profiler, SQL Query Analyzer, SSIS, Upgrade Advisor, DTS Designer Tools

• TECHNICAL SKILLS:
• SQL Server Tools: SSMS, SSIS, SSRS, Profiler, Extended Events, Query Analyzer

  Languages: T-SQL, PowerShell

  Operating System: MS-DOS, Windows 7, 8, XP; Windows Server 2012 R2, 2012, 2008, 2003

  Database Tool: Red Gate tool belt, Spot Light, Idera

  ETL Tool: SQL Server Integration Services (SSIS)

  Migration Tool: SQL Server Migration Assistant (SSMA)