Cloud Database Administrator - Cloud Data Warehousing

Job Title : Cloud Database Administrator - Cloud Data Warehousing

Location : Hybrid Onsite in Issaquah, WA

Job Type : Direct Hire

Job Description :

Database Administrators are responsible for establishing database management systems, standards, guidelines and quality assurance for database deliverables, such as : conceptual design, performance tuning, logical database, capacity planning, external data interface specifications, data loading plan, data maintenance plan, and security policy.

Database Administrators (DBA) are responsible for the maintenance, performance and availability of database management systems. This includes standards, guidelines and quality assurance for database deliverables, such as : performance tuning, capacity planning, cost optimization, high availability, disaster recovery, physical data model features (i.e. partitioning, indexing, etc.), database maintenance plan, and data security implementation.

The Data Warehousing DBA, is responsible for the upkeep of the Data Warehousing databases. The ideal candidate will have in-depth knowledge and experience working with Azure Synapse, Google BigQuery, and / or related technologies. The candidate will have hands-on experience supporting critical databases including Cloud implementations. The DBA will be actively involved in the evaluation, review, and management of database resources and services across the organization. This role also will partner closely with Product Owners, Data Architects, Platform / DevOps Engineers, Data Engineers etc. to design, build, test, implement, and maintain database resources.

Role & Responsibilities :

• Maintains database security, integrity, and availability.
• Manages database performance and capacity.
• Works with team members to establish routine maintenance; monitoring; alerting; metrics collection / logging to proactively identify database related issues, ensuring the database is highly responsive at all times
• Reviews performance stats and recommends changes for SQL query tuning / optimization
• Develops automation for repetitive tasks
• Assumes ownership of database issues; pursues problem resolution and root cause analysis
• Works with the Cloud vendors / providers to create a strategy for migrating / upgrading databases to minimize business impact
• Stays current on the key facets of the applications that leverage the databases being supported.
• Learns and stays current on the features and functionality of Google BigQuery and Azure Synapse
• Develops a thorough knowledge and understanding of cross system interactions as well as an enterprise view of our Data Warehousing landscape
• Maintains detailed documentation.

Required :

Recommended :