Database Engineer

Please Note: As of July 22 2021 our team will require that all candidate submissions include a LinkedIn profile. Please do not submit any candidates that do not have a LinkedIn.

NA has a client that is seeking a Database Engineer in Trinity FL.

Responsibilities:

Short Term Review and propose:

• Schemas and database server in the queries being executed
• Propose solution for SQL long queries
• SQL queries to improve performance
• Monthly Reports solutions for all equipment at customer level
• Design database structure for planned projects like file Management and Smart Tag
• Optimize Queries Ensure that queries are properly optimized
• Tables and create indexing; Ensure that tables are indexed on columns frequently used in WHERE clauses JOIN conditions and ORDER BY clauses
• Adjust database configuration parameters (such as memory allocation cache sizes and connection limits) to match the hardware resources and workload of our system
• Add partitioning and sharding to distribute load if required
• Large tables consider partitioning them based on certain criteria (such as range or hash partitioning)
• Evaluate database schema and consider normalizing or denormalizing it based on the Current KC requirements

Long Term Reporting Strategy:

• Purpose reporting tool for automated report and dashboard
• Establish a reporting cadence that provides timely insights without overwhelming stakeholders
• Balance frequency with the availability of relevant data and the need for realtime decisionmaking
• Explore various reporting tools available in the market; Consider factors such as functionality ease of use scalability cost integrations with existing systems and support for data visualization

.

Required Skills : * Around 812 years of experience * Reporting * Performance tuning SQL tool * PL/SQL MySQL * AWS how to scale set up clusters * Document DB * Need someone to help rearchitect and redesign the way this database is organized to eventually help build a new reporting platform * Able to come in and help optimize database and queries to help with reporting functionality; Critical to fix and implement
Rank :A3
Requested Date :