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 :

(ref : hirist.tech)