Pune, Maharashtra, India
Finance & Banking
Full-Time
Accolite
Overview
Job Title: Database Engineer
Position Overview
As a Database Engineer, you will be responsible for managing and optimizing our databases to ensure the reliability, scalability, and performance of our systems. You will work with a variety of databases, including PostgreSQL, MySQL, and cloud-based solutions in AWS and GCP, ensuring data integrity and security. Your expertise in these technologies will help drive the growth of our platform and contribute to the development of efficient and high-performing systems.
Key Responsibilities
Position Overview
As a Database Engineer, you will be responsible for managing and optimizing our databases to ensure the reliability, scalability, and performance of our systems. You will work with a variety of databases, including PostgreSQL, MySQL, and cloud-based solutions in AWS and GCP, ensuring data integrity and security. Your expertise in these technologies will help drive the growth of our platform and contribute to the development of efficient and high-performing systems.
Key Responsibilities
- Database Management: Design, implement, and maintain PostgreSQL databases, ensuring high availability, scalability, and reliability.
- Performance Optimization: Optimize query performance, indexing strategies, and database schemas to ensure optimal system performance and response times.
- Cloud Database Solutions: Manage AWS RDS and GCP Cloud SQL environments, ensuring smooth operations, backups, and scaling of databases in the cloud.
- Citus Implementation: Work with Citus to implement distributed PostgreSQL for scaling large, complex datasets across multiple nodes.
- MySQL Management: Work with MySQL databases in AWS and GCP, ensuring efficient data operations and troubleshooting any database-related issues.
- Database Security: Implement best practices for database security, including encryption, user management, access control, and backup strategies.
- Database Troubleshooting: Troubleshoot performance and data issues, including slow queries, deadlocks, and integrity issues, ensuring minimal downtime.
- Automation & Monitoring: Set up and maintain monitoring systems for proactive detection of performance bottlenecks, failures, and issues across all databases.
- Collaboration: Work closely with DevOps, software engineering, and data teams to integrate database systems into applications and ensure that database performance aligns with product needs.
- Documentation: Maintain documentation of database configurations, architectures, and processes, ensuring knowledge sharing across teams.
- Strong experience with PostgreSQL and database administration, including performance tuning, indexing, and query optimization.
- Hands-on experience with AWS RDS and GCP Cloud SQL, including configuration, scaling, and management of cloud-hosted databases.
- Familiarity with Citus and distributed PostgreSQL solutions for scaling large databases across multiple nodes.
- Proficiency in MySQL management in AWS and GCP environments.
- Solid understanding of database replication, backups, disaster recovery, and high-availability configurations.
- Experience with database monitoring, automated alerting, and performance optimization tools.
- Familiarity with cloud-native tools and services, including backup, scaling, and security.
- Strong troubleshooting skills and the ability to debug database-related performance issues.
- Ability to collaborate with cross-functional teams to integrate databases into applications and services.
- Excellent written and verbal communication skills.
- Experience with Docker and containerization of database environments.
- Familiarity with NoSQL databases like MongoDB, Cassandra, or Redis.
- Knowledge of CI/CD pipelines and integration with database management processes.
- Experience with Terraform or other Infrastructure-as-Code tools to automate cloud infrastructure management.
- Familiarity with database migration tools and strategies for migrating databases between cloud platforms.
Similar Jobs
View All
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in