Logo
Omm IT Solutions

Database Administrator (Senior Level)

Omm IT Solutions, Olympia, Washington, United States, 98502


Job Description 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.

Requirements

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

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. Candidate have experience with the following Software and Services: 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