Job Description
GENERAL DUTIES :
Provide technical expertise and support in the use of PostgreSQL DBMS
Create and maintain database objects such as tables, views, index, constraints for data platform and custom applications
Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications
Create views to drive front-end data analytics and reporting
Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
Enhance and maintain logical and physical database designs from application requirements
Design and implement automation using SQL scripts and database functions
Respond to user reported errors in a timely manner
Monitor systems performance and identifying problems that may arise
Liaison with developers and IT project managers
Recommend changes and enhancements for database performance and protection
Maintaining an awareness of trends and developments in database development and administration
Leverage experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)
Required Skills
REQUIRED QUALIFICATIONS :
At least 5 years of experience in administering on-prem / cloud based multiuser environment with expertise in planning, designing, building, and implementing complex database systems
Experience with AWS RDS or Aurora for PostgreSQL
Familiar with open-source DBMS tools such as pgAdmin, pgModeler, or DBeaver
Experience with data modeling and Entity-Relationship Diagrams (ERDs)
Experience with Structured Query Language (SQL)
Possess analytic problem-solving skills
Knowledge of computer software applications, including database technologies and programming languages
Excellent verbal and written communication skills
CLEARANCE :
Full Scope Polygraph minimum
Desired Skills
DESIRED QUALIFICATIONS :
Bachelor’s degree in computer science, software engineering, or related field of study
Experience implementing and deploying databases in Amazon Web Services (AWS)
Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
Implemented automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production and non-production environments
Administrated PostgreSQL databases throughout the non- production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment
Experienced with optimizing database performance through BILLET TBD exhaustive proactive testing and ongoing real-time monitoring
Experienced in SQL scripting and database functions
Experience in testing database security and enterprise policy guidelines according to established best practices
Monitored and maintained the backups for database recoverability for all production databases
Experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle / SQL Server / DB2 with a minimum of two (2) years of PostgreSQL DB
Experience with AGILE / DEVOPS a plus
About Procession Systems
About us
Database Administrator - Security Clearance Required
We are recruiting for a Database Administrator who will support the critical functions for mission clients in the Intelligence Community. Develop and implementing databases and database services (ex. Lightweight data engineering like cleaning and conditioning data from data calls and existing extern...
Database Administrator IV
A company is looking for a Database Administrator IV with PostgreSQL experience. ...
Database Administrator
Summary of Essential Skills: Expertise in Database management, performance optimization & troubleshooting - Oracle and PostgreSQL Basic knowledge of Java development & Spring components for database interaction Deep knowledge of DevOps practices for database management, and security tools specific t...
Associate Database Administrator
A company is looking for an Associate Database Administrator (DBA) to ensure the reliability and performance of database infrastructure. ...
Discovery Database Administrator (DBA) (Top Secret Clearance Required)
Discovery Database Administrator (DBA). CGS is seeking a dedicated Discovery Database Administrator to join a fast-paced and hard-working team to assist with any legal accounts. As a Discovery Database Administrator, you will play a key role in supporting various aspects of the company's portfolio. ...
Database Administrator
Identify user requirements, set up computer databases, and test and coordinate modifications to the computer database systems. Develop and design all elements of the database. Ensure the performance of the system, understand the platform on which the database runs, and ads new users to the system. P...
Senior Database Administrator (DBA) - SQL Server - Top Secret clearance
The Senior Database Administrator (DBA) shall support the Information Technology (IT) team to provide high-performance, highly available, and secure Microsoft SQL Server database (DB) services in direct support of the activity's business and mission needs. Senior Database Administrator (DBA) - SQL S...
Database Administrator - Silver Spring, MD
Develop and maintain, administer databases, and business applications running on MS SQL, MySQL, Azure Managed SQL instances, and database hosted on Linux server instances. Collaborate in scanning database vulnerabilities and assist security team for tracking and closing vulnerabilities reported arou...
Senior Database Administrator (Lead)
Tuva is seeking a senior-level Oracle database administrator to join our team supporting our Federal Government client in North Bethesda, Maryland. Identifies and resolves database issues related to performance and capacity. Migrates databases within and across different platforms. Discusses databas...
Database Administrator, Junior
Job Summary - The Database Administrator, Junior is responsible for maintaining and administering the company's databases and data warehouses, including managing database access, configurations, performance, and capacity. Job Title – Database Administrator, Junior . Assist in database cap...