Data Engineer

Job Overview:

We are seeking an experienced and highly skilled Database Engineer to join our dynamic team. The ideal candidate will have over 3 years of hands-on experience in database development, management, architecture, migration, and optimization. Proficiency in SQL Server is mandatory, with additional expertise in Python, Snowflake, and Cloud technologies considered a plus.

Key Responsibilities:

• Database Development and Management:
• Design, develop, and maintain SQL Server and Other databases (MySQL, PostgreSQL).
• Write efficient, complex queries, stored procedures, and functions.
• Collaborate with application developers to design and optimize database structures.
• Implement and manage database security, backup, and recovery plans.
• Monitor and optimize the performance of the database systems.
• Database Architecture and Design:
• Design and implement database systems based on business requirements.
• Ensure database architecture aligns with enterprise standards and best practices.
• Create and maintain data models and database diagrams.
• Database Migration and Optimization:
• Plan and execute data migrations between systems, ensuring data integrity and minimal downtime.
• Optimize database performance through indexing, query tuning, and hardware/software configuration.
• Implement and maintain data replication and clustering solutions.
• Security and Compliance:
• Implement database security measures to protect sensitive data.
• Ensure compliance with relevant data protection regulations and policies.
• Conduct regular security audits and vulnerability assessments.
• Support and Troubleshooting:
• Provide technical support and troubleshooting assistance for database-related issues.
• Respond to and resolve database access and performance issues.
• Collaborate with development teams to assist with database-related application issues.

Qualifications:

• Education:
• Bachelors degree in Computer Science, Information Technology, or a related field.
• Experience:
• Minimum of 3 years of hands-on experience in database development, management, architecture, migration, and optimization.
• Proven experience with SQL Server, Python and Snowflake is mandatory. MySQL, PostgreSQL are preferable.
• Technical Skills:
• Strong knowledge of SQL and T-SQL scripting.
• Experience with NoSQL databases (e.g., MongoDB, Cassandra) is preferred.
• Familiarity with Snowflake data warehousing solutions.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) and cloud-based database services.
• Knowledge of database security, backup and recovery, and disaster recovery procedures.
• Understanding of database replication, clustering, and high availability solutions.
• Soft Skills:
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.
• Detail-oriented with a focus on accuracy and quality.

Preferred Certifications:

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Data Analyst Associate
• Snowflake SnowPro Certification
• AWS Certified Database - Specialty