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.
