Position: Microsoft SQL Server DBA
Category: SQL
English level: intermediate
Years of experience: 5


•	SQL Server Administration (2012,2019) *on premise only
•	T-SQL
•	SSIS as ETL
•	Windows Server
•	Linux (RHEL like)
•	Hyper-V


My current employer is a call center with their own call center platform that automatically distributes incoming calls, chats, and automatic outgoing calls.

I have been working here for last 10 years on different positions and 5 of them in IT. So I have different but not deep experience

After I took my current position, I received SQL Server 2012 with Windows Server 2012, which was running out of disk space and expanding the disk subsystem that year was not possible. So the first task was to solve this problem in any way, which was eventually solved by removing huge unused indexes and moving some useless information to the NAS in backups.

Later, I improved the situation with DB locks and huge I/O overload by catching heavy queries that were created by SSRS reports created by a reporting specialists(including me in the past). together we have improved performance for all of them.

Last year I proved management we need new hardware and moved everything to Windows \ SQL Server 2019 with new hardware.
I have tried Always On high Availabilty for tests but unfortunately it's a bit not optimal using it on production for us in Standart edition with it's restrictions. So legacy mirroring is currently used.

I spend most of my time maintaining applications related to our call center platform. I provide assistance to customers who have installed our solution locally and to internal customers. This includes reading logs and reporting errors.
I also participate in the business analysis process for the further development of the platform.
Setting up application infrastracture using Hyper-V and Linux(RHEL forks)  machines is also among my tasks.

This year I set domain auth on all production linux machines using active directory Security Groups that helped the whole team with the headache changing their passwords on every machine every month.