Remote Network And System Administration Job In IT And Networking

Stored procedure

Find more Network And System Administration remote jobs posted recently Worldwide

Looking for a DBA who can write a stored procedure to do the following

1 create mytable as copy of parent table
2 Everytime the procedure runs(every 30 min ), it should do the following
- look if any rows are added on parent table.if added add those to my table
- check to see if any data is changed on the parent table. If it is changed , add that as new row with changed data on my table.

I know this table would become big at some point of time. We will later purge it or create a roll-up table . That is not a part of this project.


About the recuiter
Member since Mar 14, 2020
Aldrin Fernande
from Suceava, Romania

Skills & Expertise Required

Microsoft SQL Server Programming 
Open for hiringApply before - Jul 30, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$19.14

Cost

Offer to work on this project closes in 13 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Web development for wordpress single product template - Fixed
template for my landing page - Hourly
Custom frame v plotter and input iOS app - Fixed
Name Generator - Hourly
CAD/3D kitchen planner - Hourly
Home automation integration - Hourly
Advance Networking CIT41500 Lab 6 DHCP - Fixed
Content writer for Goa.biz - Hourly
Advanced D3, JS &Angular project. (Reporting tool) - Fixed
Wanted: eBay Lister and Title Optimizer - Hourly
Developer needed for creating an e-commerce static website - Fixed

Similar Projects

ASP.Net 4.6 developer and will be used SQL Server 2017

Develop a two-phase, web-based barcoding application free of any third-party software or mobile application dependencies. The first phase will consist of functionality to enable the addition, removal and maintenance of items in inventory as a standal...read more

kodi developers for IPTV

kodi developers for IPTV
I need a person who creates an application to enter the kodi in which to display the data sent from my computer to TV .In the form of an advertisement, there will be films shown in the background. attachment file Network...read more

Looking for expert database administrator to optimize MS SQL Database

We are Looking for someone who is a expert in database administrator to optimize our MS SQL Database on AWS RDS.

SQL Server Performance EXPERT

We have customers with 10**9 records.

We need to delete 10**7 records NOT in SQL Server Management Studio - SQLCMD or (better) our CLI.

The expert must be able to provide practical solution/code (script) snippets/documentation onread more

MS SQL Server Consultant

General Roles and Responsibilities:
Senior level DBA to support with problem management, reporting and troubleshooting.
Ensure efficiency and operational performance of SQL Server Infrastructure and databases.
Setup high-availability and...read more

Submit A Proposal