Sr Database Developer

T+S

USC/GC

CTH

Need Pitcure ID

• Need someone to help re-architect and redesign the way this database is organized to eventually help build a new reporting platform.
• Come in and help optimize database and queries to help with reporting functionality
• This is critical to fix and implement
• We are seeking an AWS Database Developer with extensive hands-on experience with large-scale
• Experience in Oracle database 11g and above Extensive knowledge in Oracle SQL
• Proficiency in AWS data services such as Aurora, Redshift, S3, Athena, Glue, and R3 Spectrum
• Deep understanding of cloud-native data architecture principles and best practices
• Expertise in database performance optimization, troubleshooting, and tuning in cloud environments
• Excellent knowledge of SQL, ETL processes, and data modeling
• tables, indexes, partitions, DB links, and experience in Oracle Advanced Pl/SQL
• Experience in tuning SQL queries & PL/SQL code for optimum performance
  
  

1

8-12 years experience

2

Reporting & performance tuning

3

PL/SQL, MySQL

4

AWS – how to scale, set up clusters

Short Term

Review & 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 de-normalizing 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 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.