Sql Server Dba Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 6+ years’ experience in SQL database administration for very large and complex databases in SQL server 2005 through 2017 across multiple platforms.
- Performed all day - to-day aspects of MS SQL database administration. Responsibilities include database design, installation, configuration, upgrades, security, managing users and logins, performance monitoring and tuning, database availability, backup, and recovery, troubleshooting and problem resolution
- Configured High Availability Solution- Clustering, always on and Log Shipping and replication.
- Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical databases.
- Creating and Modifying Tables, Views, Indexes, store procedures and Triggers as requirements on SQL Server Environments.
- Installed SQL Server on following Confidential best practices, applied Patches and security fixes
- SQL Server Profiler, Extended Events, Query Store and Database Engine Tuning Advisor (DTA) for performance
- Build simple SSIS Packages and SSRS reports as needed Deploy and troubleshoot Packages in the production environment. Azure Cost Management solutions.
- Configure different kinds of replication and contain databases.
- Implement Backup and Recovery Strategies Configure TDE for critical DB Encryption Provides on call-support
- Basic SQL Script and PowerShell scripts review for developers. Proficiency using Jira as a: Ticketing tool
- Performed Database Migration from an On-Premises SQL environment to Azure Database in the cloud.
- Managed and reduced cost by effectively monitoring the databases elastic pool
PROFESSIONAL EXPERIENCE
SQL SERVER DBAConfidential
Responsibilities:
- Installed and configured SQL Server .
- Performed Backups, DBCC utilities, updated index statistics, monitored database and disk space.
- Managed the migration of SQL Server 2012 databases to SQL Server 2016
- Created and maintained databases, users, Logins, tables, indexes, stored procedures, roles, permissions, and other schema objects.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies.
- Rebuilding the indexes at regular intervals for better performance.
- Responsible for Stored Procedures optimization, Performance tuning & index tuning.
- Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
- Used Always on for synchronization of database.
- Implemented and maintained Log shipping as a DR solution
- SQL Server 2005/2008/2012/2016/2017/2019 Administration.
- Reviewing and optimizing virtual machines environment.
- Reviewing and optimizing storage.
- Responsible to monitor and troubleshooting Log shipping.
- Used Data partitioning, Snapshot Isolation in SQL server.
- Update statistics, database integrity check and backup operations.
- Creating and Maintaining database maintenance plans.
- Configured High Availability Solution- Clustering, Always On, Database Mirroring and Log Shipping.
- Planning and implementation of Database backup/restore and disaster recovery.
- Installed SQL Server 2012 on advanced servers, applied security fixes.
- SQL Server Profiler, Extended Events, for performance.
- Implementation of snapshot isolation.
- Configured and supported replication and log shipping in both SQL 2008 and 2019.
- Maintained database response times in 24/7 Production environments.
- Monitoring standby Databases to ensure high availability.
- Automation of DBA Tasks and monitoring.
- Configured and managed Contained Database.
- Configured and supported replication and log shipping in both SQL 2008 and 2019.
SQL SERVER DBA
Confidential
Responsibilities:
- Automate Backup and Restore Jobs following company service level agreement (SLA) based on Retention point objective (RPO), Retention time objective (RTO) and Retention policy.
- Upgrading SQL in our environment
- Setting up always on, replication and Traditional failover (Failover cluster).
- Windows and SQL Server patching.
- Reviewing and optimizing storage.
- Troubleshoot and resolve SQL Server performance issues using both SQL Server inbuilt and 3rd party tools.
- Automate SQL Server administrative tasks using Maintenance plans.
- Assess Databases for cloud Migration using the DMA tool, correct Migration blockers, and save cost up to $500,000 annually.
- Migrate databases to Azure SQL, Azure managed instance
- Configured Azure SQL database/elastic pools for scale performance.
- Responding to ticket queue (refreshing databases, creating logins and users).
- Database migration to Confidential Azure
- SQL 2008/R2 Upgrades, SQL 2012 Upgrades, Application Migration and SQL Server Consolidation.
- Applying windows and SQL Server patches on Production/Non-Production Servers
- Configured database backups and restoration, monitored and tuned database.