G2i

Job Summary:
RIT Solutions, Inc. is seeking a Senior Database Engineer to help re-architect and redesign their database organization for a new reporting platform. The role involves optimizing database performance, improving SQL queries, and establishing a reporting strategy.
Responsibilities:
• Review & propose.
• 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 de-normalizing it based on the Current KC requirements.
• 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 real-time decision-making.
• 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.
Qualifications:
Required:
• 8-12 years experience
• Reporting & performance tuning
• PL/SQL, MySQL
• AWS – how to scale, set up clusters
Company:
Jobdiva Job Portal: https://www1.jobdiva.com/candidates/myjobs/searchjobsdone.jsp?a=xbjdnwgjodtga1y1im2g881fkkeiwd0775lbvq8yqgps8vb2q36w2vj1ga6xxork&compid=-1 Recruitment (contingency search and campus selection). Founded in 2019, the company is headquartered in Arlington, USA, with a team of 201-500 employees. The company is currently Growth Stage.