Find Jobs
Hire Freelancers

PL/SQL coder needed for one time freelance work.

zł90-750 PLN

Në vazhdim
Postuar about 6 years ago

zł90-750 PLN

Paguhet në dorëzim
I am an individual and work as an IT professional myself. This is a quick one time requirement and a simple and straight forward task. I need someone to write a script to generate alerts for long running sqls from Oracle database and send it via email with the following information. - Capture distinct long running sql ids > 30 mins elapsed time - Provide sql execution history with hash value changes - Provide explain plan for each hash value - Capture the tables involved in the sqls - If not partitioned, provide table level stats info(stale or not) - If partitioned, provide table level stats info(stale or not) and info - - Regarding any partitions or subpartitions only if their stale - Provide dba_tab_modifications info on the stale tables, partitions or subpartitions The coder should also be willing to explain parts of the script if requested.
ID e Projektit: 16472700

Rreth projektit

19 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
I am an Oracle OCE expert 12 and I already have these scripts created. I accept paypal. The way to look into stale stats is much easier. The rest is pretty easy...
zł500 PLN në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
19 freelancers are bidding on average zł475 PLN for this job
Avatari i Përdoruesit
A proposal has not yet been provided
zł211 PLN në 2 ditë
5,0 (1 review)
1,5
1,5
Avatari i Përdoruesit
Hey let’s have discussions around requirement. I am sure I can work on same as I have 13 years of playlist development experience. Looking forward to contact you soon.
zł666 PLN në 5 ditë
5,0 (1 review)
1,6
1,6
Avatari i Përdoruesit
Good afternoon! Currently working with Business Intelligence, where my job is to turn data into relevant information and present it in reports and dashboards. I work daily with multiple data sources at the same time to analyze the information, see what are duplicates, if a request is in all systems, then I believe that I am fit for the project. Software used: Builder Dashboards and Reports: Tableau, Power B.I ETL(Data processing) Integration Services and Pentaho Data Integration Databases: Oracle,SQL Server, MySQL Best regards.
zł466 PLN në 10 ditë
5,0 (1 review)
0,6
0,6
Avatari i Përdoruesit
A proposal has not yet been provided
zł466 PLN në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am freelancing database acrhitect and BI analyst with more than 18 years of experience in designing, implementing and maintaining reporting solutions and data integration platforms for financial reporting systems. My database stack consists of design, development and fine-tuning of data models, procedural code and data integration scripts across Oracle (20 years), MySQL (3 years), PostgreSQL (2 years). My ETL stack comprises visual tools Talend (3 years), ODI (2 years), IBM Datastage (2 years), scripting tools Perl (4 years), Python (3 years) and database native loaders of Oracle (10 years) and PostgreSQL (2 years). My technology experience comprises following - Custom PL/SQL devlopment in Oracle, daily tasks for already 20 years - Front-development with Oracle Forms 6i, 10g, 11g, daily tasks for already 12 years - Report design with Oracle Reports (6i and 10g) and Oracle XML Publisher, for already 12 years - Oracle peformance tuning tasks, for already 12 years • ETL jobs design in Talend, ODI, Datastage. Happy to help you with your needs in Oracle Reports - have a good experience with Crystal Reports as well.
zł450 PLN në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Half part I will complete immediately like long running queries and explain plan , later scrits coding I will need some times.
zł500 PLN në 14 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi I am a software engineer with a strong expertise in sql. I write queries, stored procedures and reports using SSMS and SSRS everyday at my day job. Let’s talk more about what all you have and what you need to so I can get started for you.
zł555 PLN në 1 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I have 4 years of experience in oracle apps & i have worked on similar requirement for alerts, i have generated explain plans earlier also
zł466 PLN në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
zł211 PLN në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
I am currently working as a PLSQL developer in a reputed organization for more than 2.5 years and worked on many complex items as part of my everyday task
zł466 PLN në 3 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
Hi, Please let me know what you like to have in call then we can come on pricing or complete detail or maintenance service will be provided for monthly
zł666 PLN në 5 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
A proposal has not yet been provided
zł555 PLN në 5 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i
0,0
0
Anëtar që nga mar 12, 2018

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.