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. - Bachelor’s 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. We are equal opportunity/affirmative action employers, committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status, or any other protected characteristic under state or local law.