[Hiring] Senior Database Engineer @DMS Vision

Role Description

The Senior Database Engineer will be responsible for re-architecting and redesigning the database organization to support a new reporting platform. Key responsibilities include:

• Optimizing the database and queries for enhanced reporting functionality.
• Reviewing and proposing improvements to schemas and database servers.
• Proposing solutions for long-running SQL queries.
• Designing database structures for planned projects like file management and smart tagging.
• Ensuring proper optimization of queries and indexing of tables.
• Adjusting database configuration parameters to match hardware resources and workload.
• Implementing partitioning and sharding for load distribution as needed.
• Evaluating and normalizing or de-normalizing database schemas based on current requirements.
• Establishing a reporting strategy that balances frequency with data availability.
• Exploring various reporting tools for functionality, scalability, and integration.

Qualifications

• 8-12 years' experience in database engineering.
• Expertise in reporting and performance tuning.
• Proficient in PL/SQL and MySQL.
• Experience with AWS, including scaling and setting up clusters.

Requirements

• Ability to optimize SQL queries for performance.
• Experience in creating and managing database indexes.
• Knowledge of database configuration and resource allocation.
• Familiarity with partitioning and sharding techniques.

Benefits

• Remote work flexibility.
• Opportunity to work on innovative projects.
• Collaborative work environment.