Principle Engineer - Database Architecture

Responsibilities :

- Prepare a long-term plan for smooth Database management, including DB architecture to support future initiatives, multi-tenancy, scaling of infrastructure, etc.

- Monitor DB health, storage growth, and predict potential performance issues ahead of time.

- Query cost analysis and tuning of queries identified during DB performance analysis.

- Work with the DB Managed Services vendor to proactively identify DB performance issues and mitigate them.

- Work with AWS for regular operational and performance reviews of existing databases.

- Develop and update specific standards and check for deviations from the established best practices.

- Analyse per DB and per-team costs and help reduce the overall cost for DB setup.

- Ensure the timely setup and renewal of Reservations to reduce cost.

- Work with each development team and review and optimize the DB queries over time.

- Plan and work on minor and major maintenance activities.

- Oversee the activities and performance of the DB Managed Services Vendor.

- Evaluate and review the monitoring setup, alerts, thresholds, and alert recipients periodically.

- Perform regular database upgrades.

- Ensure database hardening is carried out periodically and vulnerabilities are eliminated.

- Work on Data Security requirements, including Encryption and data sanitisation during Non-Prod DB refresh activities.

- Work on user security and handle audit activities.

- Evaluate tools and newer capabilities.

- Work on preparing best practices for development teams.

Requirements :

- Bachelor's degree in computer science or equivalent practical experience.

- Experience coding in one or more of the following programming languages : Java, Python, and/or Go.

- Experience in algorithms and data structures.

- Experience designing, analyzing, and troubleshooting large-scale distributed systems.

- Experience with Microservices / Distributed event-based architectures is desired.

- Ability to debug, optimize code, and automate routine tasks.

- Ability to systematically approach problem-solving and take initiative with a sense of accountability.

- Must be able to work independently and enjoy working in a fast-paced start-up environment, and be adept at experimenting with new technologies.

- Must have excellent communication (verbal and written), interpersonal, leadership, and problem-solving skills.