Apply on Employer Site

Bering Straits Native Corporation (BSNC) · 5 months ago

Database Developer / Administrator (Oracle, PostgreSQL)

Suitland, MD

Full-time

Onsite

Mid Level

3+ years exp

Bering Straits Native Corporation (BSNC) is seeking a qualified Database Developer / Administrator with expertise in Oracle and PostgreSQL databases. The role focuses on database design, development, administration, and security while contributing to a migration to PostgreSQL, ensuring data integrity, and optimizing performance.

ConsultingFinancial ServicesInsurance

No H1B

U.S. Citizen Only

Responsibilities

Commitment to maintaining database security and integrity. This involves implementing security measures and procedures to protect sensitive information and ensure data accuracy, understanding and implementing NIST REV controls, conducting regular analysis of potential vulnerabilities, and collaborating with the Census database administration team to ensure successful patching and configuration of database servers

Support both incoming and outgoing interfaces with external data sources, ensuring data integrity between systems. This includes creating, maintaining, and troubleshooting these interfaces, encompassing jobs, data feeds, and files

Strong experience in database design and modeling, specifically with Oracle. This includes working with tables, keys, and constraints, as well as developing and maintaining functions and procedures (PL/SQL). You should also be proficient in using the scheduler to create and maintain database jobs

Managing database schema and data changes under version control (GitHub), similar to application code, allowing for change tracking, facilitating rollbacks, and ensuring consistency across environments

Qualification

OraclePostgreSQLPL/SQLCI/CDGitHubAWSDatabase designDatabase administrationData integrityAutomation

Required

A bachelor's degree is required

3-5 years of experience in database development or administration

Ability to work independently with minimal oversight

Familiarity with Oracle's

Experience with CI/CD and automation, including the ability to automate database changes using pipelines (Jenkins or GitHub Actions)

Well-versed in version control for database management

Ability to write and optimize complex database queries, including the use of materialized views, to ensure efficient data retrieval

Strong experience with general Oracle database administration tasks, including configuring and managing backups and restores, and ensuring optimal database performance