Open Systems Technologies Corporation
Location
Annapolis Junction, MD | United States
Job description
Open Systems Technologies Corporation is a leader in the government contracting marketplace, providing Enterprise Security and Cloud Computing solutions to support large organizations. Our capabilities include supplying federal government entities and private businesses with software development, scientific and engineering technical assistance, systems integration, and enterprise security. Since its founding in 1996, OST has been committed to delivering high-quality, best-in-class results that bring added value to our clients while investing in our employees’ futures by providing exciting projects to work on, and robust benefits to include technical training and certifications, relocation assistance and a 401K match with immediate vesting.
Open Systems Technologies Corporation is looking for a Database Administrator to join our team of experts to assist with building state of the art data platforms for the Intelligence Community.
The selected candidate will maintain the integrity, security, and availability of multiple databases. Duties include disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data, as well as administering, maintaining, developing, and implementing policies and procedures for ensuring the security and integrity of the database. The selected candidate will evaluate and recommend available database management system products; perform database and software lifecycle activities to ensure the highest level of system performance, availability, and compliance with business requirements; and organize and format data for efficient query and storage processes.
Primary 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.
Basic Qualifications:
- Clearance: TS/SCI w FS Poly (last poly must be within the past 7 years)
- At least 4 years of experience. Additional experience may be substituted for a bachelor’s degree.
- Must have demonstrated experience as a database administrator.
- Must have 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, for example: PL/SQL.
Preferred Qualifications:
- Bachelor of Science in a Technical field
- 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 amember of an Agile team.
- Experience with database design and development
- Experience with the 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
OST is an Equal Opportunity Employer and has been operating since 1996 providing support on various contracts with Government agencies. We offer a comprehensive benefits package that includes 3 weeks paid time off, 11 Federal Holidays, medical/dental coverage, STD, LTD, Life Insurance, AD&D, 401k with up to 4% match, and end-of-year profit sharing.
#monster
Job tags
Salary
