Database Administrator

Bellevue, WA

Professional, Scientific, and Technical Services

About the position

The position involves designing and managing data warehouses and databases, ensuring data maintenance and integrity. The role requires collaboration with developers to optimize queries and refine schemas, as well as managing SQL Server databases across various product lifecycle environments. The candidate will also be responsible for configuring and maintaining database servers, applying data modeling techniques, and analyzing security threats related to data management.

Responsibilities

• Design and implement Data Warehouse in our upcoming platform/system and deploying them without interrupting existing business.
• Perform investigation, rapid prototyping, and evaluation of new technologies, new SQL Server version/features that can be used in our services.
• Work closely with Service layer developers and Front-end developers to do complex query tuning and schema refinement.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems including backup and restore for existing data, Disaster Recovery when needed.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Understand mitigation and monitoring capabilities (Firewalls, Intrusion Detection Systems, Log Analysis, anti-malware, SIEM etc.) and how they help prevent and detect attacks.
• Research, identify, prioritize, and analyze preventive and detective use cases that will help identify threat trends and anomalies impacting the company.
• Review security events and alerts, vulnerability and configuration data, and other information from the production environment, combined with intelligence, to identify potential & active threats to systems and data.
• Analyze modern Finance, security related subjects and trends, for example, Advanced Persistent Threat (APT), rootkits, Spear Phishing, PtH, Projected budget and Actual Revenue and other credential compromise techniques.
• Help generate intelligence products using a variety of data visualization techniques.

Requirements

• Bachelor's (or foreign degree equiv.) degree in Computer Science, Software Engineering or related.
• 1 year experience or related.