Job Description
As a Database Engineer, you will be responsible for the design, development, maintenance, and optimization of database systems critical to the organization's data management needs. Your role will involve working 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 Design and develop database systems that meet the organization's 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 (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. 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. Skills And Qualifications Strong proficiency in MySQL, MS SQL, and PostgreSQL, including query optimization and performance tuning. Experience with Google BigQuery for data analytics, data warehousing, and complex queries. Knowledge of database design principles, data modelling, and schema management. Familiarity with data migration tools and techniques. Proficiency in database security, including user access control and encryption. Understanding of backup and recovery procedures. Strong analytical and problem-solving skills. Excellent communication and teamwork abilities. Knowledge of other database technologies and NoSQL databases is a plus. Relevant certifications in database administration or data analytics are a bonus. Benefits & Perks Competitive Salary PTO and Paid Holidays Medical PPO or HMO, Dental, and Vision Insurance About BrightEdge BrightEdge is widely recognized as a global leader in SEO and Digital marketing. The most innovative customers across more than 80 countries trust BrightEdge to modernize their Digital Marketing stack for todays digital world. We are helping thousands of organizations, including many of the worlds largest companies, transform their businesses and drive more revenue. The continuous innovation of our product is supported by what we believe to be our most valuable assets our people. Our employees are industry experts at the forefront of digital transformation. Come join us and help us share the future of SEO
Employement Category:
Employement Type: Full time
Industry: Others
Role Category: DBA / DatawarehousingApplication Programming / Maintenance
Functional Area: Not Applicable
Role/Responsibilies: Database Engineer
Keyskills:
MySQL
MS SQL
PostgreSQL
Query Optimization
Data Migration
Performance Tuning
Database Monitoring
Collaboration
Documentation
Data Analytics
Data Warehousing
Database Design
Database Security
Analytical Skills
Communication Skills
Teamwork
BigQuery
Data Backup
Recovery
Data Modelling
Schema Management
Backup
Recovery Procedures
Problemsolving Skills
NoSQL Databases