Database Principal Engineer
We are looking for someone who could help manage our 250++ databases as the engineering organization grows. You will be involved in operational tasks and leading in designing and implementing automated processes to manage database tasks like data modification requests, provisioning, configuration, backups, monitoring, performance optimization, and deployment, aiming to streamline operations, reduce manual intervention, and improve overall database reliability and efficiency.
About the job:
- Developing automation scripts: Writing scripts using programming languages like Python, PowerShell, or SQL to automate repetitive database management tasks.
- Integrating with tools: Implementing and configuring database automation tools to manage database lifecycle, including provisioning, scaling, and patching.
- Data migration automation: Automating data migration processes between different database environments.
- Envisioning database engineering roadmap: Imagining the potential futures, outlines the short-term and long-term team roadmap that align with the organization’s vision.
- Performance monitoring and optimization: Setting up automated monitoring systems to identify performance bottlenecks and implementing optimization strategies.
- Backup and recovery automation: Automating database backup and restore processes to ensure data integrity and disaster recovery capabilities.
- Security automation: Implementing automated security measures to control database access and protect sensitive data.
- Compliance management: Ensuring database operations comply with relevant regulatory standards through automated checks.
- Troubleshooting automation issues: Identifying and resolving issues related to automated database processes.
About you:
- Strong understanding of database concepts, SQL, and database management systems (DBMS).
- Familiarity with DevOps principles and tools for continuous integration and deployment (CI/CD).
- Assisting in hardware capacity planning as well as re-sizing.
- Ability to diagnose and troubleshoot complex database automation issues.
- Creating documentation for database design, implementing, and maintaining database structures to meet business requirements.
- Proficiency in scripting languages like Python, PowerShell, or other automation tools.
- Analyze and improve efficient, scalability, and stability of application relational databases.
- Contributing to database replication, database migration, performance optimization, tuning, and database troubleshooting.
- Regularly monitoring and detecting performance issues related issues both during working hours as well as scheduled on call times.
- Participate in the creation of development, staging, and production database instances and the migration from one environment to another.
- Responsible for developer SQL code(DDL, DML) review to ensure queries are optimized and tuned to perform efficiently before the production release.
#LI-RR1