I have been working in the field of IT since 2016, assuming various roles and responsibilities. I began my career as a Technical Deployment Specialist and later transitioned into the role of a Database Administrator.
- Proficient in database administration tasks such as database installation, configuration, performance tuning, backup and recovery, and security management.
- Skilled in writing complex SQL queries, stored procedures, and triggers to extract, transform, and load data.
- Experience in database design principles, including normalization, indexing, and query optimization
- Assisted with database migrations, server migrations, and database engine upgrades/patching.
- Proficient in Virtualization and Domain Controller administration.
- Experienced in implementing High Availability and Disaster Recovery (HA/DR) solutions for ensuring business continuity and data protection.
- Additionally, I have expertise in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Agent. These tools allow for seamless integration of data across different systems, generating comprehensive reports, and automating tasks through scheduling and job management. With my proficiency in these technologies, I can effectively utilize their capabilities to enhance data integration, reporting, and automation processes.
- Here are the MSSQL versions I have hands-on experience with:
Versions
- SQL Server 2008
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022
- Worked with Azure SQL Databases, Azure SQL Managed Instances & Azure SQL VM
- Imported & Exported data using SSIS packages as well as Data-Tier.
- Assisted with Migration to the cloud.
- Leveraged Powershell for the automation.
- Deployed EC2 instnaces using Cloudformation templates.
- Leveraged CLI for the automation.
- Deployed domians using Route 53.
- Used S3 buckets for large objects and archival data.