Database Administrator
Open Systems Technologies Corporation - Annapolis Junction, Maryland, United States, 20701Work at Open Systems Technologies Corporation
Overview
- View job
Overview
Want to make an application Make sure your CV is up to date, then read the following job specs carefully before applying. Responsibilities Perform daily database administration, monitoring, and troubleshooting of system database and replication issues. Monitor database performance and memory allocations using standard tools. Perform system updates and Information Assurance Vulnerability Alert (IAVA) patching. Troubleshoot and resolve database problems. Perform database recovery actions. Modify existing database scripts to enhance systems support and create new database scripts for recurring database issues. Develop and execute SQL queries for routine and ad hoc requests. Transition/ingest legacy data. Translate requirements and data into usable database schemas by creating or recreating ad hoc queries, scripts and macros, making updates to existing queries, and creating new queries to manipulate data into a master file. Recommend design and implementation practices that optimize the performance of GOTS/COTS databases and applications. Assist in the development of database structures that fit into the overall architecture of the system under development. Assist in developing databases, database parser software, and database loading software. Required Skills: Clearance: TS/SCI w FS Poly. Poly must be in the last 5 years. Must have at least three (3) years of demonstrated experience as a database administrator. Must have at least three (3) years of Oracle Database Administration experience. Must have experience implementing and maintaining database security. Must have experience conducting database performance tuning and monitoring. Must have experience troubleshooting and resolving database problems/issues. Must have experience installing, configuring, and upgrading RDBMS software. Must have experience with procedural languages such as PL/SQL. Preferred Skills: Bachelor's degree ?in a technical discipline. At least 10 years of high-level, in-depth database experience.? Experience with real time highly available data replication technologies such as Oracle Data Guard, Oracle Streams, Oracle Golden Gate, Sybase Replication Server.? Experience with the Scaled Agile Framework (SAFe) methodology and/or as a member of an Agile team. Extensive experience with database design and development Extensive, in-depth understanding of databases, primarily Oracle and/or other relational and non-relational/NoSQL databases such as PostgreSQL and MongoDB. Experience using Oracle SQL/PLSQL, and SQL in general. Experience with Mongo and/or Cassandra. BENEFITS Our company OST has been operating since 1996 and have various contracts with Government agencies. We offer a comprehensive benefit package that includes 3 weeks paid time off, 11 Paid Holidays, medical/dental coverage, STD, LTD, Life Insurance, AD&D, 401k with up to 4% match, and end of year profit sharing paid out in 401k. PDN-9cd2e834-f7de-412f-aa75-83eb878bf45c