Database Engineer

BrightEdge - Database Engineer - Remote

As a Database Engineer at BrightEdge, you will play a pivotal role in designing, developing, maintaining, and optimizing database systems that underpin our organization's data management needs. Your responsibilities will involve collaborating with various database technologies such as MySQL, MS SQL, PostgreSQL, and BigQuery to ensure data availability, integrity, and performance for data analytics and reporting.

Key Responsibilities:
Database Design and Architecture: You will design and develop database systems that meet the organization's requirements, including data modeling, schema design, and database structure optimization. This will involve leveraging your expertise in database design principles, data modelling, and schema management.
Database Administration: As a Database Engineer, you will administer, maintain, and monitor database systems to ensure high availability, performance, and data security. This includes implementing and managing data backup and recovery procedures to ensure data integrity and disaster recovery capabilities.
Query Optimization: You will write and optimize SQL queries for various database platforms (Clickhouse, MySQL, MS SQL, PostgreSQL) to enhance data retrieval efficiency and performance. This will require strong proficiency in query optimization and performance tuning, as well as experience with database monitoring tools.
Data Migration: Plan and execute data migration projects when transitioning between database systems or upgrading versions. This involves using data migration tools and techniques to minimize downtime and ensure seamless data transfer.
Performance Tuning: Identify and resolve database performance issues through tuning, indexing, and monitoring, ensuring efficient data retrieval and processing. This requires strong analytical and problem-solving skills, as well as knowledge of other database technologies and NoSQL databases.
Collaboration: Collaborate with cross-functional teams, including data analysts, developers, and system administrators, to support their database-related needs. This involves effective communication and teamwork abilities, as well as a willingness to share knowledge and best practices.
Documentation: Maintain comprehensive documentation of database configurations, procedures, and changes. This ensures that all team members have access to accurate and up-to-date information, promoting collaboration and reducing errors.
BigQuery Data Analytics: Utilize Google BigQuery for data analytics, including data warehousing, querying large datasets, and generating insights from data. This requires experience with BigQuery and data analytics tools, as well as a strong understanding of data visualization and business intelligence concepts.

Skills and Qualifications:
Strong proficiency in Clickhouse , MySQL, MS SQL, and PostgreSQL, including query optimization and performance tuning. Experience with Google BigQuery for data analytics, data warehousing, and complex queries is also highly desirable.
A strong foundation in database design principles, data modelling, and schema management is essential. Familiarity with data migration tools and techniques is also beneficial. Additionally, proficiency in database security, including user access control and encryption, is necessary. Understanding of backup and recovery procedures is also required.
Analytical and problem-solving skills are crucial, as is excellent communication and teamwork abilities. Knowledge of other database technologies and NoSQL databases is a plus, and relevant certifications in database administration or data analytics are also a bonus.