Data Engineer & Optimization  

• Optimize database performance:
  Support developers with database design, query tuning, and indexing strategies. Review new query development, and maintain and monitor production query performance.
• Enhance database programs:
  Debug scripts, resolve conflicts, and continuously improve existing database program execution.
• Developer enablement:
  Provide hands-on troubleshooting for problematic queries. Create and deliver best practice guidance and training on database design and common pitfalls.
• Database operations:
  Perform backup/restore, indexing maintenance for PostgreSQL & MSSQL Server, and tune PostgreSQL parameters.
• Data integration & synchronization:
  Manage data migrations using ETL tools and contribute to multi-database synchronization strategies.
• Performance monitoring:
  Utilize the ELK for log and event data management to aid performance analysis.
• Business Intelligence contribution:
  Leverage optimized data to inform strategic business decisions.​​​​​​​

• Expert in SQL & Database Design: Extensive experience with SQL and strong principles of relational database design.
• Database Tuning Pro: Proven proficiency in database performance tuning, including advanced knowledge of query execution analysis, indexing strategies, and optimization techniques.
• Hands-On Database Experience: Solid experience with PostgreSQL and MySQL. Experience with MSSQL Server (including T-SQL and optimization) is preferred.
• ETL & Multi-Database Savvy: Proficient with ETL tools like SSIS, Apache Airflow, and Informatica, and comfortable working in multi-database environments with data synchronization strategies.
• Familiarity with the ELK stack (Elasticsearch, Logstash, Kibana).
• Familiarity with Python, Apache Kafka, DBaaS on Cloud, and Golang is a plus.
• Willing to Work From Office (WFO - BSD CITY)

Personal Attributes:

• Exceptional communication skills, able to explain complex technical details clearly.
• Strong analytical and problem-solving abilities with a keen eye for detail.
• Proactive, self-motivated, and a great team player.