Solution Architect Database as a Service

Dice

Worldwide
Full-time
Software Development
python
aws
ruby

Description

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Capital IT Inc., is seeking the following. Apply via Dice today!

Title: MySQL

Location: Remote (Post covid onsite) with limited Travel (All over USA)

Position: Fulltime

JD:

Skills:

(Database as a service (DBaaS) is a cloud

computing managed service offering that

provides access to a database without requiring the

setup of physical hardware, the installation of

software or the need to configure the database) Remote (Post covid onsite)

Skills & Tools Knowledge:

Minimum 8 Years Of Experience In Database Administration.

Experience with AWS architecture.

Experience in designing and supporting Database as a Service (DBaaS) platform.

Understand end-to-end configuration, technical dependencies, and overall behavioural characteristics of DBaaS.

Experience in one or more of the following: Python, Ruby, Perl, Shell, or PowerShell

Experience with DBaaS/Managed Cloud database technologies such as MySQL, Mongo, Casandra, CosmosDB, Managed SQL (RDS, SQL Database)

Experience in In-memory (Cache for Redis, ElastiCache)

SQL*Plus, SQL Developer, Oracle, TOAD for Oracle, Explain Plan, TKProf Job Responsibilities

Primary Responsibilities –

Database Performance related Activities:

Experience working in Agile Scrum, Kanban.

Active participation in platform management, and capacity planning.

Using Chaos Engineering to test the robustness of the systems and applications.

Good knowledge of MYSQL server clustering, Replication and physical logical schema.

Troubleshoot, resolve, provide root cause analysis and document solutions to complex problems.

Design and create schemas, tables, stored procedures, triggers and more by using DML, DDL, DRL and TCL.

Reduce false alarms to a minimum by configuring database monitoring utilities.

Improve performance with the most effective solution, such as Infrastructure Changes, server configuration changes, or index/query changes

Give advice on database design, tuning options, and other possible issues

Establish the baseline for system performance, recognize deviation, and suggest and implement improvements to slow running queries

SQL Code Optimization (using tools such as Explain Plan, TKProf etc) and recommend application developers to write and tweak/optimize SQLs

Experience in Database profiling and Drive towards Enhanced databases.

Data modelling to visualize database structure
  • provided by Dice

Job Summary

Job ID:120
Company:Dice
Location:Worldwide
Job Type:Full-time
Primary Tag:Software Development

To claim this job, send an email to admin@remoteng.com from your work email with the job ID.

More Details


Website:

https://www.dice.com/

Job Posted:

3 years ago