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 an active Secret clearance to 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 (pg_dump, pg_basebackup, 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.