Database Engineer

BTree Solutions Inc, Los Angeles, CA (United States)

Category: Programming

Posted on: 20 Nov 2020

DevOps MongoDb MySQL Oracle Python Redis SQL

Job Description

Job Title: Database Engineer
Location: LA/Santa Monica (Remote until covid)
Duration: 12+ Months
Visa: USC, GC, H1B and EAD
Contract Type: W2

Job Description:

Top Three Skills:

1) Experience with either primarily ElastiCache, CassandraDB and MySQL supporting database functions by designing and coding utilities.
2) Deep experience in designing and building high volume, scalable, data-intensive database systems
3) Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.

Job Description:

(Redis/ElastiCache Expert) (MongoDB Expert) (Postgres Expert)
Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
Solid understanding of database hardware, including RAM, CPU, Permanent Storage, I/O, and other capacity related resources
Solid understanding of Redis and ElastiCache internals, Replications and Security.
Working knowledge on implementing SOX and PCI controls in AWS ElastiCache.
Strong technical acumen, able to ensure that technical solutions, strategies, practices, and governance deliver business and customer value
Having strong working knowledge on MySQL, Postgres, MongoDB, and Cassandra.
Nice to Have are working experiences on AWS RDS MSSQL, Migrating from on-prem to AWS and Monitoring database in AWS.
Experience with Python is preferred.
Supports database functions by designing and coding utilities.
Deep experience in designing and building high volume, scalable, data-intensive database systems
Highly skilled in SQL performance tuning and real time troubleshooting
Solid understanding of database hardware, including RAM, CPU, Permanent Storage, I/O, and other capacity related resources
Solid understanding of MySQL 5.7 internals, Replications and Security.
Experience with Oracle MySQL Enterprise
Working knowledge on implementing SOX and PCI controls
Strong technical acumen, able to ensure that technical solutions, strategies, practices, and governance deliver business and customer value
Having strong working knowledge on PostgreslSQL, MSSQL, MongoDB, Cassandra or Redis.
Working experiences on AWS Aurora, Migrating from on-prem to AWS and Monitoring database in AWS.
Experience with Python is preferred.
- About 70% of databases are MySQL and the other 30% is a mixed bag
- Currently they are unplugging MySQL, creating new databases in AWS, cutting over the application on-prem to new databases in target to create minimal downtime
- About 200 databases on-prem left to migrate to AWS
- Prateek's team consisting of 11 engineers (database and DevOps mixed skillset) are working on this project
- There will be training needed for DynamoDB and Elastic Cache for some members of the team
Yes, they are migrating from on-prem MySQL to AWS Aurora MySQL
They are leveraging MySQL dump currently they tried AWS DMS for certain load but there was a bug at the time they were using it. Using MySQL dump is a little downtime (5 min).
Who is doing the data migration? 11 people on Prateeks' team but as of now they feel they have the required count to complete the work.
Testing for load testing, manual and automate testing they use different team (Subscription Billing has a few testers they utilize and Ad Team: Franck L [I've been trying to get in front of him). But Prateek's team does a lot of the testing for non-prod, connections, CPU memory, etc.
"We are looking for a person who already has prior hands-on experience and in-depth expertise working with highly critical large scale online databases. The technologies we work with are MySQL, Redis, Cassandra, Mongo, and are moving quickly into AWS, working specifically with Aurora MySQL, ElastiCache Redis, DynamoDB, Document DB, and may be AWS Keyspaces.
Apart from general maintenance of our database infrastructure, this person would be expected to troubleshoot issues with highly critical databases in real-time, and help design data store solutions for either new applications, or existing ones that we would be migrating over to AWS managed database solutions."


Want more jobs like this?

Apply Now

By clicking "Apply Now" or "Subscribe and Apply" you will be redirected to an external website. By clicking "Subscribe & Apply" you give TechieJobs consent to process and store your data, and send you job alerts to provided email.

Job Source: Ziprecruiter (Will expire by: 2021-01-04 00:00:00)

Apply Now

Quick poll
How did COVID-19 affect your employment?
  • Nothing's changed
  • I now work from home
  • My salary decreased
  • I lost my job

* This poll is anonymous.