| Senior Database Engineer || Remote ( Preference is candidate in FLORIDA) || Contract || Only USC or GC ( If GC must born before 1984) at Florida, New York, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1865267&uid= From: Raveena Mourya, DMS Visions Inc [email protected] Reply to: [email protected] 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 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 TOP SKILLS REQUIRED SIZZLES PLEASE INCLUDE 4 BULLETS HIGHLIGHTING THE SKILL SET REQUIRED. THANK YOU! 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. 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. 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 972-452-6160 / 972-325-9476 dmsvisions.com/ [email protected] 4645 Avon Lane, Suite 210, Frisco, TX 75033 linkedin.com/in/raveena-mourya-766314250 Keywords: information technology procedural language Delaware Texas Senior Database Engineer || Remote ( Preference is candidate in FLORIDA) || Contract || Only USC or GC ( If GC must born before 1984) [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1865267&uid= |
| [email protected] View All |
| 09:28 PM 22-Oct-24 |