What are the responsibilities and job description for the Database Administrator position at TriOptus?
Title: Database Administrator
Location: Olympia, WA
Job Description:
· Experience with Database Server Performance and Optimization tools.
· Experience managing database backup, restore and data archiving tasks.
· Experience with Microsoft SQL Server security best practices.
· Advanced knowledge of AlwaysOn, Transactional Replication, Clustering and T-SQL.
· Experience with implementing database upgrades.
· Experience with Database PAAS solutions in a cloud solution.
· Experience with CI CD process and setup from database end.
· Scripting knowledge for automating day to day tasks (Shell script, Power shell).
- Certifications in Microsoft SQL Server.
- Experience with T SQL scripts and Batches.
- Experience with Microsoft SQL Server Integration Services (SSIS/SSAS).
Knowledge on No SQL databases like Cosmos DB or Mongo DB.
· Knowledge on Azure Data Factory.
· Knowledge on ETL data warehouse architecture.
· Working experience on CDC tools & replication.
· Installs, Patches, upgrades, and maintains the system health
· SQL Server
· Azure Data Factory
· Power Shell
· Azure cloud
· DB setup, Patching, Security, upgrades
· CI CD
· Migration
· Replication
· Change data capture tools
· T SQL scripts
· Ansible
· Terraform
· Datadog
