Database Administrator

TMC Technologies is in search of a Database Administrator to support a federal client. The candidate must be a US citizen and possess a minimum of anactive Secret clearanceto start due to federal contract requirements. This position is considered to be a remote position; however staff may be required to support limited face-to-face meetings with the business line or end users. There is potential for face-to-face SAFe ceremonies on limited occasions. The Database Administrator will need:

Database experience of working in different OS platforms like Linux RHEL and Windows
Experience in Oracle/Postgres database administration support implantation configuration and upgrade.
Solid understanding of SQL (writing optimizing queries normalization and indexing)
Experience with backup & recovery (pgdump pgbasebackup PITR)
Experience in Oracle/Postgres database performance tuning using explain plans and monitoring tools
Working experience of AWS Cloud Services (Cloud Watch Cloud Trail EC2) and Databases (Oracle Aurora & Postgres RDS)
Strong understanding of postgres schema user roles access control and security model.
Postgres script writing (PL/pgSQL) with loops conditions and variables
Performance tuning hardware replacement firmware upgrades and patching to all COTS software products including operating systems.
Experience in shell scripting to enhance and update daily monitoring tasks.

- Bachelors Degree and minimum of 3 years experience required; equivalent working experience may be considered in lieu of degree
- Experience in Oracle Data Guard RMAN (Backup & Recovery) Cloning Resource Management OEM Grid administration and Implementation for version 19C/21C databases.
- Experience in Oracle database performance tuning using AWR/ASH/ADDM reports for troubleshooting performance issues.
- Database performance tuning database upgrades and database patching to all COTS database products.
- Database script writing (PL/SQL) database storage management database interfaces external application database interfaces and other systems database interfacing.