Project overview
Writing triggers and stored procedure as per requirement for existing database.
Candidate must have knowledge in aws / Google cloud. Working environment will be remotely using anydesk, os environments windows & Linux, ============================================================================== Must have: ============================================================================== - Highly Skilled in C# or Python - Strong verbal and written communication skills in English. - Strong problem-solving skills. - Deep understanding of backup and disaster recovery. - Deep understanding of linux servers, security and service deployment. — Experience with MySQL (Latest Version) — Experience with Firebird or Google Cloud ( at least one is Compulsroy) - Proficient with NodeJS, and Angular. UI development is a plus. — Experience with AWS and Redshift DB ============================================================================== Deliverable include: ============================================================================== — Understanding and experience with Transactions and Isolation levels — Experience in DB programming (usage Functions, Stored Procedures, Triggers etc.) - Reviewing query performance and optimizing code - Writing queries used for front-end applications (websites, desktop applications, or cloud apps) - Designing and coding database tables to store the application’s data - Data modeling to visualize database structure - Working with application developers to create optimized queries - Creating database triggers for automation, e.g., automatic email/Whatsapp notifications - Creating table indexes to improve database performance - Programming views, stored procedures, and functions – Determining what data must be returned to the application and writing queries for it – Creating and designing tables when new new modules are added to a software product – Reviewing current database design and making suggestions for better performance – Creating table indexes that optimize query speeds – Defining triggers on necessary tables – Determining the right stored procedures, views, and functions for the application ==============================================================================