Database Administrator
JoinITSolutions USA
San Antonio, TX, United States
2 2023 - 4 2024
- Installed virtual machines using Hyper-V and configured virtual machines.
- Installed and Configured Windows Server 2019 on Virtual Machines and Physical Machines.
- Promoted virtual machine to Domain Controller.
- Added virtual machines to a domain.
- Created groups and added members to groups in Active Directory.
- Granted Permissions using the principle of least privilege.
- Carried out migration of databases from one virtual machine to another virtual machine.
- Installation and Configuration of SQL Server.
- Managed users and logins.(Active Directory).
- Patched SSMS to the latest cumulative update and performed application upgrades.
- Performed Backups and recoveries of Databases in the same instance and from one instance to another to ensure safety of company's data in case of any disaster.
- Automated jobs to ensure backups and performance.
- Migrated Databases, from one instance to another and within the same instance of SQL Server using different methods: Detach and attach, Backup and restore
- Encrypted Data to secure sensitive data from unauthorized users using different modes of encryption: Transparent Data Encryption (TDE), Always Encrypted, and Dynamic Data Masking (DDM).
- Ensured High Availability and Disaster recovery solutions like log shipping, Always On, and replication.