Senior Database Engineer  

Responsibilities:

• Analyze and improve efficiency (Performance), scalability, and stability of JULO’s application relational databases.
• Build, secure, and scale various types of data stores for upcoming new services and applications using both open source and commercial cloud technologies as needed.
• Apply modern engineering methodologies such as infrastructure as code, encrypting sensitive data, and automated tests.
• Provide best practice guidance to the development team with regard to database design and usage.
• Regularly review database schema design of developers for meeting new enhancement requirements.
• Build and execute backup and archival strategies for the databases.
• Build and execute replication, HA and clustering strategies for optimal performance and failovers.
• Be accountable and responsible for the owned database systems.
• Regularly monitor and quickly respond to any database related issues both during working hours as well as scheduled on call times.
• Develop simple and complex stored procedures, functions and views to meet enhancement requirements.

Skill Requirements

• 3-5 years of experience designing, building, and scaling RDBMs for large and high throughput OLTP database systems.
• Possess excellent problem solving skills, ability to break down problems and explain complex concepts, strong attention to detail.
• Must be highly skilled in Linux based OS and open source tools.
• Have a great knowledge of SQL and database design skills.
• Have good understanding and knowledge of performance tuning of the queries, database indexing and internals of the databases like PostgreSQL.
• Good knowledge of tooling for close monitoring and alerting of database systems.
• Experience with replication strategies, secure backup and building HA systems with tools like Patroni.
• Deep expertise in Postgresql preferred.
• Have excellent communications skills to be able to articulate the detailed information among team members and also externally to non-technical groups.
• Able to communicate using English both verbally and in writing.
• Experience with other databases (relational, NoSQL, document, graph etc) and database technologies will be a plus.
• Experience with cloud native architecture will be considered a plus.