Senior Database Engineer Remote Preference is candidate in FLORIDA
Senior Database Engineer Remote Preference is candidate in FLORIDA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Hi
Hope you are doing well
Please find the job description given below and let me know your interest.
Position: Senior Database Engineer Location: Remote ( Preference is candidate in FLORIDA) Duration: 6 Months Job Description:About JOB:
What is driving the need
Need someone to help rearchitect 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
TOP SKILLS REQUIRED
SIZZLES PLEASE INCLUDE 4 BULLETS HIGHLIGHTING THE SKILL SET REQUIRED. THANK YOU!
1
812 years experience
2
Reporting & performance tuning
3
PL/SQL MySQL
4
AWS how to scale set up clusters
CLIENTS FORMAL JOB DESCRIPTION
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 denormalizing it based on the Current KC requirements.
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.
Please share your updated resume and suggest the best number & time to connect with you.
Thanks & Regards
Raveena Mourya
US IT Recruiter DMS Visions Inc
Employment Type
Remote
Company Industry
Key Skills
- Entertainment
- Aircraft
- Journalism
- AC Maintenance
- Agricultural
- Application Programming
