• Supporting the data persistence technologies and data design relationships on our data platforms and associated applications.
• Developing and implementing technology solutions in an RDBMS environment (PostGres, MySQL and Oracle) including tuning packages, stored procedures, functions, triggers, and views.
• Developing search solutions on ElasticSearch based search technologies, including optimizing indexes, creating/organizing facets & filters.
• Engineering data models including data structures, metadata modeling and data governance.
• Performing logical and physical schema design, parent-child relationships, many-to-many relationships, normalization, denormalization, clusters, indexes, and IOTs.
• Participating in a quality-first Agile scrum development team, providing story point estimates and tracking effort against tasks, weekly grooming sessions, sprint planning, and daily stand-ups, communicating effectively in written and verbal form with teammates and manager.
• Honoring our core behaviors, treating others with respect, honoring commitments to the team, seeking out & integrating feedback.
• Participating in code reviews and providing actionable, objective feedback to peers.
We're looking for someone with:
Experience in configuring, tuning, and optimizing RDBMS solutions on AWS Aurora and RDS on PostGres or MySQL, with storage expertise in indexing, access methods, locking, logging, caching, transaction processing, replication, backup/restore and buffer management.Experience in design, development, and management of data on graph database clusters and nodes, including performance, capacity planning, and cost forecasting.Experience with database engine internals (query processing): query compilation, optimization, execution, parallel execution.Experience in NoSQL system implementation, distributed systems, consensus-based quorum replication.Experience in data security and encryption algorithms.Knowledge of middleware caching strategies such as Redis, Couchbase, ElasticSearch and other NoSQL Cache systems.Engineering (design and code) solutions in the clearest, most concise, and optimal way possible based on time and other constraints; coordinating the best development approach with Architects, Engineers, Database Developers, and others.A quality-first approach to the user experience, demonstrating empathy towards the user experience and system integration throughout an enterprise feature(s) workflow.Understanding of event-driven system architectures.Knowledge of the layers of connectivity from a service call to the DB, transaction control, isolation level, etc.; reviewing existing code and recommending refactoring where applicable.100% remote, 8 hours per day with 40 hours per week.
- Need to be able to work in US time zone hours, available during EST hours. Once a month, may need to be available for all hands-on deck expectation if something were to occur that would require them. - Looking for someone who has worked on platforms supported by databases that require millions of transactions a day. - Not looking for someone who works on internal facing systems. MUST HAVES: 5 years plus experience as a Database Engineer.Need to have recent two to three years' experience managing databases in AWS - Excellent English verbal, written, interpersonal and organizational communication skills.Able to work with a large team.Take ownership and responsibility. Plus if they have search solution experience.Interview process: 3 total - first with HM for 30-45 minutes, second and third panel team for 1-hour duration each.
#J-18808-Ljbffr
