- Analyze and improve efficiency, scalability, and stability of application relational databases.
- Build, secure, and scale various types of data stores for upcoming new services and applications.
- Apply modern engineering methodologies such as infrastructure as code, encrypting sensitive data, and automated tests.
- Regularly review database schema design
- Build and execute backup and archival strategies for the databases.
- Build and execute replication, HA, and clustering strategies for optimal performance and failovers.
- 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.
A successful candidate will have:
- Possess more than 4 years of experience designing, building, and scaling RDBMs for large and high throughput OLTP database systems.
- Possess proficiency 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.
- Able to communicate using English both verbally and in writing.
- Experience with other databases (relational, NoSQL, document, graph etc) and cloud native will be a plus.
Flexible working arrangement
Opportunity to develop database administration practices
Michael Page