Position: MS SQL Database Administrator (Riga)
Company: ITSM Delivery
Experience required: 2y
Category: SQL
English level: upper
Published: 2020-05-01T00:00:00+03:00

Requirements:

Strong experience in administering Microsoft SQL databases, AlwaysOn Availability Groups, Database Mirroring, replication solutions;
Good MS SQL performance tuning skills (experience of Query Tuning, Indexing, Dynamic Management Views, Extended Events, etc.);
Good scripting skills (Powershell);
Experience in Microsoft application server administration and troubleshooting (MS IIS, Reporting Services, etc.);
Ability to document tasks, system features, procedures;
Ability to drive technical incident resolution; work independently in proactive way with involved parties;
Ability to plan and implement system changes;
Ability to work on many tasks simultaneously in a high-pressure environment;
Must have good written and verbal communication skills; good knowledge of English (spoken and written);
Must be knowledgeable and experienced in administering Windows operating systems;

Advantage if you have knowledge of:

Application/proxy server administration and troubleshooting (wildfly, jboss, tomcat, haproxy, nginx);
Experience in administering and configuring webserver and Microsoft related products;
MySQL, Postgres (administration, replication, tuning, backups)
Experience in administering Linux;
Reading and understanding Microsoft .NET written applications

Responsibilities:

Setup and maintain SQL Server instances and high availability solutions based on Microsoft technologies (AlwaysOn, database mirroring, failover clustering, replication, etc.);
Maintain the existing environment of applications, databases and User Interfaces including security, backups, etc. according to SLA;
Develop and enhance system monitoring;
Execute routine tasks on daily basis (environment configuration, release deployment, environment refresh, etc.);
Resolve system related incidents and problems ;
Evaluate performance of overall solution and make recommendations for improvements / upgrades;
Develop and maintain scripts for system support purposes;
Provide delivery for technical and legal system audit purposes;
Plan and implement system changes;
Support in proactive manner development, operation and business teams;
Learn and administer custom applications solutions;
Establish, maintain and document system configuration (backup/recovery policies, maintenance procedures;
Participate in 24x7 on-call responsibilities including driving Root Cause Analysis (RCA);
Work off hours to perform maintenance and upgrades;
Company offers: 

International experience
Very stable, professional and friendly environment
Social security and benefits (including health insurance, etc.)
Professional trainings
Possibility to work from home occasionally;
Team building events and sport activities
Additional information:

2000-3600 eur gross