SM2G

Amat Victoria Curam

Explore View Projects

Skills

Soft Skills
Languages
🇫🇷 French Native speaker
🇬🇧 English Fluent
🇨🇳 Chinese Beginner
🇮🇱 Hebrew Beginner
Hard Skills
Computer Languages
SQL

Expert in SQL, PL/SQL and Oracle database administration.
Python

Python autodidact, website creation using the Django framework. Created a Bitcoin trading bot in Python.
HCL

Expert level on HCL language, used by Terraform and OpenTofu to manage infrastructure environments.
Git

Good knowledge of Git and Github user for personal projects.
Docker

Deployed many contenerized applications using Docker for portability and reliability.
Infrastructure & Providers
AWS

Certified AWS Solutions Architect.
Azure

Certified Microsoft Azure Solutions Architect Expert & Azure Security Engineer Associate.
Linux & OSS

Proficient with Bash, ZSH console, scripting, system administration and Open source software.

Latest Articles

development
2016-10-20

Install Oracle JDK 8 on Raspberry Pi

#oracle #java

In this post, I’ll show you how to download and install Oracle JDK 8 on a Raspberry Pi. Visit Oracle download website and click the download button for Java Platform (JDK) 8. Then accept the licen... Read more

20 Oct 2016 - less than 1 minute read
database
2016-09-20

Last rowcount in MySQL

#mysql

Suppose you want to count the number of lines returned by the last SQL statement issued. For select statements you can use the FOUND_ROWS construct: SELECT SQL_CALC_FOUND_ROWS something FROM your_... Read more

20 Sep 2016 - less than 1 minute read
database
2016-08-20

Implement an MD5sum function in Oracle

#oracle

A few days ago, I was looking for a way to get an MD5sum function to work directly in Oracle, like the MD5() function in MySQL. After some searching I found out that there was no direct way to gene... Read more

20 Aug 2016 - less than 1 minute read

database
2016-07-20

MySQL punch user creation DDL

#mysql

You can get the DDL necessary to duplicate an existing user with the following system command: MYSQL_CONN="-uroot -ppassword" mysql ${MYSQL_CONN} --skip-column-names -A -e "SELECT CONCAT('SHOW GRA... Read more

20 Jul 2016 - less than 1 minute read
database
2016-06-20

InnoDB table rebuild

#mysql

PROBLEM On a MySQL 5.6 database server, the ibdata1 file includes 5 InnoDB tables in the mysql schema. mysql> select table_name from information_schema.tables -> where table_schema='mys... Read more

20 Jun 2016 - 1 minute read
system
2016-05-20

Transfer multiple files simultaneously using SCP

#linux

I have been using the Secure Copy (scp) utility for copying files between my local server and development server. Sometimes I have to copy more than one file. Copying each file can be very annoying... Read more

20 May 2016 - 1 minute read

database
2016-04-20

Resolve the ORA-01157 Error

#oracle

Another day at the office, I was investigating a performace issue when I encountered the following error: Select count(*) from purchase.table where CREATION_DATE > SYSDATE - 40; Execution Plan... Read more

20 Apr 2016 - less than 1 minute read
database
2016-03-20

Kill locked sessions

#oracle

Sometimes, when there’s many database sessions connected and depending on the user activity, locks can occur on a database. While this may only affect a few users, the problem is that with many ses... Read more

20 Mar 2016 - 1 minute read
database
2016-02-20

MySQL regexp Replace

#mysql

MySQL provides you with a useful string function called REPLACE that allows you to replace a string in a column of a table by a new string. The REPLACE function is very handy to search and replace ... Read more

20 Feb 2016 - 1 minute read

database
2016-01-20

PostgreSQL Survival Guide

#postgresql #database

PostgreSQL has been gaining a lot of popularity these days, so let’s have a look at the basics of administering a PostgreSQL database. We’ll cover the structure exploration, object manipulation and... Read more

20 Jan 2016 - 3 minute read
database
2015-12-20

Extract tablespace DDL

#oracle

Should you need to perform a large data export and import on different Oracle databases, you’ll need to make sure that the tablespace configuration matches your export and import parameters. Wheth... Read more

20 Dec 2015 - less than 1 minute read
database
2015-11-20

Fixing the ORA-00600: [ktfbtgex-7] error

#oracle

It was a normal day at the office, when I noticed an ORA-00600 on a production database. Upon investigation, I found the following details in the alert.log file: ORA-00600: internal error code, ar... Read more

20 Nov 2015 - 1 minute read