MYSQL DBA Architects

Overview

On Site
Up to $85
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)

Skills

InnoDB
MYSQL
Redis /KeyDB
MariaDB

Job Details

Role:MYSQL DBA Architects

Location:Los Angeles,CA

Duration:Long term

JD:

Minimum 3 years experience configuring and supporting MySQL/MariaDB database management and data modeling. Databases running in Linux environments first, with strong domain knowledge.

Solid database concepts and database design knowledge (ACID, abstraction levels, schemas and constraints, stored procedures, replication, etc.)

Strong troubleshooting skill in database performance analysis and improvements.

Good knowledge of storage, networking, and other systems directly impacting database performance.

Solid experience in the administration and performance tuning of database-related tools and environments.

Experience with monitoring systems like Grafana, Prometheus, Zabbix, etc.

Experience with planning, executing, and managing large - scale system deployments, ensuring high availability and performance.

Skilled in system scripting and automation to streamline deployment processes and operational tasks, utilizing tools such as Ansible, Chef, Terraform, etc.

Solid scripting skills (e.g., Python, Ruby, Bash, Perl, etc)

Proven working experience in configuring and troubleshooting UNIX/Linux-based environments.

Strong work ethic and communication skills both spoken & written

Flexibility to work a variety of shifts with availability to work overtime

BS/MS degree in Computer Science, Engineering or a related subject.

What You'll Be Doing:

Maintain and support the current MYSQL/InnoDB & Redis /KeyDB database, including the creation of new DB's, migrations, backups, and replications.

Design, plan and deploy database schemas.

Review the existing databases and provide recommendations and drive the implementation to fine-tune and growth-proof the performance and scalability of our databases, including multi-sites replication.

Ensure that data is properly backed up and consistent.

Defines customers needs and functionality in a service development cycle.

Provide and communicate the best practices and specific detailed information for database management, including present and future capacity requirements.

Provide documentation as required to ensure accurate and current information is available for each database schema, relationships, performance bottleneck, and data flows.

Assists in the coordination of various teams testing and evaluating for the development of design and its implementation including database tools and software selection, including present and future capacity requirements.

Ensures the highest level of database and systems availability, stability and scalability.

Implements warranty and support activities.

Plans and implements system automation as required for better efficiency.

Oversees the development of customized software and hardware requirements.

Willing to stay up-to-date with security best practices and drive implementation accordingly

Collaborates with other professionals to ensure high-quality deliverables within organization guidelines, policies, and procedures.

Run diagnostics to resolve customer-reported issues

Deals with work process, optimization methods, and risk management tools in the given projects for successful accomplishments according to the requirements of the stakeholders.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.