Databaseprogrammerere Jobs

We have Oracle and MS-SQL environments that need expert support, and for compliance purposes the work must be performed by someone who is physically located in Canada. Here is the immediate scope: Oracle upgrades – Plan and execute version upgrades on Development and Production databases, ensuring minimal downtime and a clean rollback path. – Review current backup, recovery and high-availability strategies and adjust them to suit the new versions. Ongoing operational support – Handle day-to-day administration, performance tuning, security patching and capacity planning. – Document every change clearly so our internal team can trace what was done and why. Integration assistance for active projects – Our developers are building Web and...

I have several bank statements saved as PDFs where each transaction is presented line-by-line. I need a small utility that can read those files, pull out every transaction, and insert the information into an SQLite database. The essential fields are the date, description and amount shown on each line; if a running balance is available it would be great to capture that as well. Accurate numeric handling is critical—please strip currency symbols, recognise minus signs or debit/credit markers, and make sure amounts are stored as real numbers rather than text. I use macOS but a cross-platform command-line solution is ideal. Python with pdfplumber / PyPDF2, pandas and the built-in sqlite3 module would suit me perfectly, though I’m open to another stack if you clearly outline the a...

I have a set of PDF bank statements and I need every transaction imported into a single, well-structured SQLite database. The database only has to hold one field—Amount—so you can ignore dates and descriptions unless you find them useful for your own processing logic. You can choose whichever parsing approach you prefer (Python + PyPDF2, tabula-pdf, or any other reliable library) as long as the final result is a self-contained .sqlite file I can open directly with standard SQLite tools. Deliverables • The populated .sqlite file with an Amount column containing every transaction value from the PDFs • The script or notebook you used, clearly commented so I can rerun it on future statements • A short read-me explaining setup and execution steps Acceptance Cri...

I need an experienced data specialist to take an old-format XLS file and move it into my SQL database after applying several transformations. The raw worksheet contains multiple sheets of mixed data types, so before anything is loaded I’ll need column mapping, type casting, and a few calculated fields added (we can review the exact logic together). Once the transformation rules are approved, please import everything into the live SQL instance and provide: • A repeatable script or ETL package (Python, SSIS, or similar) • A short README explaining how to rerun the job and tweak the mappings • Verification that every record landed in the correct table with accurate data types and relationships I’ll supply the sample XLS, the current SQL schema, and the t...

I am putting together a concise genetics study guide and need my material turned into clear, well-structured typed notes. The sole focus is on genetic mutations—point, frameshift, chromosomal, you name it—so every line has to revolve around mechanisms, examples, and biological significance. You will receive a mix of handwritten pages and rough paper sketches; translate everything into clean, typed text. If a drawing is essential, simply describe it in words or insert a quick ASCII outline—I do not need polished digital diagrams this time. Deliverables • A single editable document (Word or Google Doc) with logical headings, bullet points where helpful, and a short glossary of key mutation terms. • All scientific names and gene symbols italicised or form...