*responsibilities*:
- 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 task, weekly grooming sessions, sprint planning, and daily stand ups, communicating effectively in written and verbal form with teammates and manager
- honors our core behaviors, treating others with respect, honoring commitments to the team, seeking out & integrating feedback.
- participate in code reviews and provide actional, 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.
- engineer (design and code) solution in the most clear, concise, and optimal way possible based on time and other constraints; coordinate best development approach with architects, engineers, database developers, and others.
- 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.; review existing code and recommend refactoring where applicable.
- *-need to be able to work in us time zone hours, available est hours. Once a month you may need to available for all hands-on deck expectation if something were to occur that would require them. *_
- *-looking for someone who worked on platform supported by database and supported a databases that requires millions of transactions a day. *_
-*:
- not looking for someone who works internal facing systems.*_
*we offer*:
- direct contract with unosquare.
- 100% remote possition.
- growth plan.
- long term possition.
- great work environment.
- and more...