Oracle Database Developer / Administrator

DESCRIPTION OF RESPONSIBILITIES :

• Provide database and computer administrator support of JTS databases and associated database interfaces capabilities, to include installing and maintaining all network connectivity clients for workstations requiring Oracle or other database access.
• Provide technical database support for a multitude of database and operating environments to include, but not limited to : Oracle RDBMS, Application Server, Portals, and Oracle InterMedia; Interbase; MYSQL, Microsoft SQL Server, and TOAD.
• Maintains database information security and integrity, including applying security patches, verifying, and managing storage, maintaining database accounts, and performing database backups and recovery in case of problems.
• Resolve Oracle database performance issues, database capacity issues, replication, and other distributed data issues. Develop performance tuning techniques to ensure the Oracle Database Server operates efficiently and accurately.
• Design new database tables, procedures, and techniques to ensure database grows in a scalable manner.
• Install and configure Oracle and SQL Server in hosted and enterprise environments.
• Coordinate complex queries with the researchers and data extractors / miners utilizing PL / SQL, Java, TOAD, Oracle Discoverer, and other query tools to provide complex datasets for research analysis.
• Develop database applications in concert with the database processing needs for clinical and research requirements utilizing complex query and other programming toolsets.
• Support data mining and integration requirements with a number of COTS and in-house developed systems including COLLECTOR, DoDTR, JTTR, ICDB, and IRDB, as well as legacy applications such as Mercury and Pre-Hospital Trauma Registry.
• Run multiple monitors and systems to check their accuracy and workability, as well as troubleshoot any errors found.
• Manage backup and recovery routines.
• Trouble shoot individual patient database records and recover data as needed.
• Add validated new users, delete departed users, and ensure all users have current HIPAA and Cyber Awareness training documentation (Deliverable 11) on file. Assist with password resets as needed.
• Other duties as assigned by Supervisor.

REQUIRED DEGREE / EDUCATION / CERTIFICATION :

PREFERRED DEGREE / EDUCATION / CERTIFICATION :

ORACLE or higher certification OR proof of formal education in ORACLE or higher, and Oracle SQL certification

REQUIRED SKILLS AND EXPERIENCE :

REQUIRED CITIZENSHIP AND CLEARANCE :

The Alaka`ina Foundation Family of Companies (FOCs) is a fast-growing government service provider. Employees enjoy competitive salaries. Eligible employees enjoy a 401K plan with company match; medical, dental, disability, and life insurance coverage; tuition reimbursement; paid time off; and 11 paid holidays.