Skilled Database Administrator bringing more than 7 years of experience in the administration of databases, as well as key skills in the modeling and warehousing of data. Proven skills in security management, database maintenance and establishing backup and recovery process to safeguard data. Proficient in technical software, languages, and tools, and able to learn new strategies quickly. Collaborative and team-oriented with first-rate oral and written communication, complex problem-solving and decision-making abilities.
SKILLS
- Experience working with various SQL versions; SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2019.
- Worked on linked server to setup Heterogeneous connections coming to SQL Server from ORACLE, TERADATA, MS Access, DB2, etc.
- Experience working with CAB Process implementing Incident and Change management modules.
- Monitor Performance PERFMON used to resolve system hardware bottlenecks and DBCC utilities for database consistency checks.
- Extensive work on setting up FCI Clustering, AlwaysOn Availability Groups (AG), Mirroring, Log Shipping and Replication as HA and DR solutions for Business Continuity strategies.
- Worked on Excel to make good reports and build reports with the team using SSRS.
- Experience as SQL Server DBA in multiple client enterprises and SCRUM/Agile and ITIL environments.
- Collaborated on numerous management initiatives, including Data security, data Management & Data Retention, Resource tracking, Change control, disaster Recovery Planning and High Availability.
- Extensive work on Performance tuning of long running queries and troubleshooting bottlenecks.
- SQL Server Database Backup/ Restore processes with SQL native and Quest Lite Speed.
- Migration of databases with enterprise upgrades from SQL Server versions to higher versions and cloud (AWS / Azure).
- Experience with building DR plans and performing DR Test exercises.
- Experience with Installation, configuration, administration, maintenance, performance tuning, security, SSIS, SSAS & SSRS administration.
- Creation of database maintenance plans, SQL Agent jobs, setup alerts and operators.
- Hands on experience on Replication for load balancing and Data autonomy.
- Extensively used SQL and system counters to monitor bottlenecks on the disk IO and throughputs.
- SQL Server Profiler Trace and Quest tools like spotlight for identifying query bottlenecks causing performance issues.
- Extensive knowledge in Microsoft SQL Server databases as well as SSIS, DTS packages, T-SQL and performance tuning.
- On call Production DBA for 24 x 7 in an OLTP Mission critical systems/environment.