We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

3.00/5 (Submit Your Rating)

Lanham, MD

SUMMARY

  • Microsoft Certified Database administrator with over 5+ years of extensive experience, Database Expert with dense technical experience, maintained and developed different systems using Microsoft technologies.
  • Experience includes all aspects of SQL Server Databases (2019, 2017, 2016, 2014, 2012, 2008/R2) in administering and maintain. Critical thinker and problem - solving skills, Team player, Good time-management skills, have great interpersonal and communication skills.
  • Also have knowledge and experience as IT Service disk analyst, troubleshooting computer problems, resolved users’ issues.

TECHNICAL SKILLS

  • SQL server Installation, upgrading, migration, Apply patch.
  • SQL server Security, SQL server Backup & Restore
  • SQL server Performance tuning, SQL server troubleshooting
  • SQL server Standalone Database High availability (Log shipping, Mirroring)
  • SQL server object level High availability (Transaction Replication)
  • SQL server group of Database High availability (Always on Availability Groups)
  • SQL server level High availability (Failover Clustering)
  • TSQL, SharePoint, PowerShell, SQLCMD
  • SQL server Reporting services (SSRS)
  • SQL Server Integration Services (SSIS)
  • Agile Methodology
  • Data Modeling
  • Used Idera, Red Gate Backup tools.

PROFESSIONAL EXPERIENCE

Confidential, Lanham, MD

SQL Database Administrator

Responsibilities:

  • Installed managed and administered SQL server 2008R 2/2012/2014/2016 , 2017,2019 SQL servers.
  • Applied Patches and Service packs, create service account different versions of MS SQL server and stand alone and cluster environment.
  • Performed Administrative tasks in SQL Server using PowerShell. And SQL Cmd
  • Configured Database mail, linked servers, Transparent Data Encryption (TDE), Change data capture (CDC) and. Change Tracking (CT)
  • Conducted various meetings with teams to meet corporate milestones for database merging and data movement.
  • Configured and maintain Transactional replication and always on Availability Groups multiple SQL Servers and remote sites.
  • Created TSQL database objects including tables, views, functions, stored procedures and indexes for different business rules and logic.
  • Served as an operational & development DBA.
  • Implemented SQL Server 2012 ALWAYS-ON High Availability groups with two secondary nodes.
  • Applying patches and hot fixes on Always-On Failover Cluster (FCI) production as well as non-production environment
  • Lead in establishing monitoring, alerting, performance tuning and diagnosing issues for production databases and environments.
  • Interacted in database enhancement, verification and architecture related to HA, DR & BCP
  • Assisted in the leadership and direction related to operational backup/recovery strategies.
  • Provided 24x7 operations support for production related issues
  • Worked with Microsoft Team Foundation server for task tracking, source control, etc.

We'd love your feedback!