Job Description
Database Engineer at BrightEdge
We are seeking a skilled Database Engineer to design, develop, maintain, and optimize our database systems. As a key member of our team, you will work with various database technologies to ensure data availability, integrity, and performance for data analytics and reporting.
Key Responsibilities:
• Database Design and Architecture: Design and develop database systems that meet our requirements, including data modeling, schema design, and database structure optimization.
• Database Administration: Administer, maintain, and monitor database systems to ensure high availability, performance, and data security.
• Query Optimization: Write and optimize SQL queries for various database platforms (Clickhouse, MySQL, MS SQL, PostgreSQL) to enhance data retrieval efficiency and performance.
• Data Migration: Plan and execute data migration projects when transitioning between database systems or upgrading versions.
• Performance Tuning: Identify and resolve database performance issues through tuning, indexing, and monitoring, ensuring efficient data retrieval and processing.
• Data Backup and Recovery: Implement and manage data backup and recovery procedures to ensure data integrity and disaster recovery capabilities.
• Database Monitoring: Set up and utilize monitoring tools to proactively identify and resolve issues and maintain database health.
• Cross-Functional Collaboration: Collaborate with cross-functional teams, including data analysts, developers, and system administrators, to support their database-related needs.
• Documentation: Maintain comprehensive documentation of database configurations, procedures, and changes.
• BigQuery Data Analytics: Utilize Google BigQuery for data analytics, including data warehousing, querying large datasets, and generating insights from data.
Requirements:
• Database Technologies: Strong proficiency in Clickhouse, MySQL, MS SQL, and PostgreSQL, including query optimization and performance tuning.
• Google BigQuery: Experience with Google BigQuery for data analytics, data warehousing, and complex queries.
• Database Design Principles: Knowledge of database design principles, data modelling, and schema management.
• Data Migration Tools: Familiarity with data migration tools and techniques.
• Database Security: Proficiency in database security, including user access control and encryption.
• Backup and Recovery Procedures: Understanding of backup and recovery procedures.
• Analytical and Problem-Solving Skills: Strong analytical and problem-solving skills.
• Communication and Teamwork Abilities: Excellent communication and teamwork abilities.
• Additional Skills: Knowledge of other database technologies and NoSQL databases is a plus; relevant certifications in database administration or data analytics are a bonus.
We are seeking a skilled Database Engineer to design, develop, maintain, and optimize our database systems. As a key member of our team, you will work with various database technologies to ensure data availability, integrity, and performance for data analytics and reporting.
Key Responsibilities:
• Database Design and Architecture: Design and develop database systems that meet our requirements, including data modeling, schema design, and database structure optimization.
• Database Administration: Administer, maintain, and monitor database systems to ensure high availability, performance, and data security.
• Query Optimization: Write and optimize SQL queries for various database platforms (Clickhouse, MySQL, MS SQL, PostgreSQL) to enhance data retrieval efficiency and performance.
• Data Migration: Plan and execute data migration projects when transitioning between database systems or upgrading versions.
• Performance Tuning: Identify and resolve database performance issues through tuning, indexing, and monitoring, ensuring efficient data retrieval and processing.
• Data Backup and Recovery: Implement and manage data backup and recovery procedures to ensure data integrity and disaster recovery capabilities.
• Database Monitoring: Set up and utilize monitoring tools to proactively identify and resolve issues and maintain database health.
• Cross-Functional Collaboration: Collaborate with cross-functional teams, including data analysts, developers, and system administrators, to support their database-related needs.
• Documentation: Maintain comprehensive documentation of database configurations, procedures, and changes.
• BigQuery Data Analytics: Utilize Google BigQuery for data analytics, including data warehousing, querying large datasets, and generating insights from data.
Requirements:
• Database Technologies: Strong proficiency in Clickhouse, MySQL, MS SQL, and PostgreSQL, including query optimization and performance tuning.
• Google BigQuery: Experience with Google BigQuery for data analytics, data warehousing, and complex queries.
• Database Design Principles: Knowledge of database design principles, data modelling, and schema management.
• Data Migration Tools: Familiarity with data migration tools and techniques.
• Database Security: Proficiency in database security, including user access control and encryption.
• Backup and Recovery Procedures: Understanding of backup and recovery procedures.
• Analytical and Problem-Solving Skills: Strong analytical and problem-solving skills.
• Communication and Teamwork Abilities: Excellent communication and teamwork abilities.
• Additional Skills: Knowledge of other database technologies and NoSQL databases is a plus; relevant certifications in database administration or data analytics are a bonus.
💡 Quick Summary
Seeking a career-building opportunity? The Database Engineer position is now open for candidates interested in the Database Administrator sector. This role in Mumbai offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.