Database Administrator (Senior)

Database Administrator (DBA) Resources are responsible for the administration and maintenance of the organization’s database platforms. They use established database standards, procedures, and processes to ensure that systems are healthy and functional. They build and execute scripts to modify data in organizational databases. A DBA develops and maintains highly available databases, including physical dictionaries and data models, and implements changes and performance enhancements. DBA Resources may access Federal Tax Information. Background checks required, per IRS Publication 1075, apply.

EXPERIENCE (MANDATORY):

• 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).
• Knowledge of Azure Data Factory.
• Knowledge of ETL data warehouse architecture.
• Working experience on CDC tools & replication.
• Installs, Patches, upgrades, and maintains the system health

QUALIFICATIONS (DESIRED):

• Certifications in Microsoft SQL Server.
• Experience with T SQL scripts and Batches.
• Experience with Microsoft SQL Server Integration Services (SSIS/SSAS).
• Knowledge of Non-SQL databases like Cosmos DB or Mongo DB.

SOFTWARE AND SERVICES EXPEREINCE (DESIRED):

• 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

EDUCATION (MANDATORY)

• Associate’s degree in computer science or related field, or equivalent training and experience in IT.
• 7 years of experience in enterprise RDBMS Database administration with large-scale, mission-critical applications (Microsoft SQL Server 2012+).
• Formal education in Computer Science, Information Systems, Engineering, or a related field can be substituted for the following years of experience:
  • Bachelor’s Degree – 1 year
  • Master’s Degree - 2 years

LOCATION (REMOTE)

Most work is done remotely. However, certain Work Orders may require the Resource to work on-site at 810 Jefferson Street SE, Olympia WA.

Compensation$75-$90