Offer summary

Qualifications:

Bachelor's degree or higher education in a relevant field., Experience in migrating databases from Oracle to PostgreSQL using tools like ora2pg., Proficiency in managing databases with DBMS tools for backup, performance tuning, and security management., Strong understanding of database schema maintenance and user access management..

Key responsibilities:

Install and set up PostgreSQL databases and manage their performance.

Monitor database security and prevent unauthorized access.

Perform regular backups and disaster recovery procedures.

Provide best practice guidance to the development team and resolve production data issues.

Omm IT Solutions (Omm) is a Columbia, Maryland based 8(a) certified Women Owned Small Business (WOSB), providing Information Technology (IT) consulting and contracting services on Federal, State government and commercial contracts . We provide custom solutions and services while keeping focus on the goals and objectives of our clients in mind. Omm specializes in modern & niche technologies such as Machine Learning, Natural Language Processing, Full Stack Web Development using React.js, Node.js, Angular.js, AI, Data Science & Analytics, and Private & Public Cloud consulting, to name a few. Our team consists of leaders who provide a unique balance of expertise, vision and humility. At Omm, we strongly believe in what we do and how we do it, consistently delivering results with integrity, focus, teamwork, and respect. Additionally, Omm is a ISO 9001:2015 certified, MDOT certified Minority and Small Business Enterprise (MBE, SBE, DBE).Please visit the following link for our current career opportunities: https://www.dice.com/company/90934554

Job description

This is a remote position.

Please Note:

This is a 100% Remote Position.
Candidate should willing to work in the PST time zone

Position Description

Installation and set
Migration exp from Oracle to PostgreSQL with tools like ora2pg
Create the objects in the database, such as triggers, indexes, etc.
Monitor the performance of the database and ensure optimum performance.
Identify potential issues in the database to solve them early.
Maintain backups and perform disaster recovery.
Monitor security and prevent any unauthorized access to the database.
Schedule consistent maintenance on the server
Maintain database schema.
Manage database availability.
Give best practice guidance to the development team.
Resolve any production data issues.
Taplespace management

Requirements

Bachelor's degree or Higher education
Migration experience from Oracle to PostgreSQL with tools like ora2pg
Role management
Develop automation technologies to accelerate the process of data loading.
Develop relational databases.
Ensure data integrity.
Manage user access and permissions by adding and removing users as required.
Maintain the database using different utilities. This includes using like pg_ctl and psql
Proficiency in managing databases using DBMS tools like Backup/Restore, Performance Tuning, Security Management etc.