Data Engineer/DBA

Job Description

Cohere is seeking fully cleared, dynamic technical professionals to join our team as a Member of an agile team you will work with the government customer to help shape a new phase of applications into the cloud environment. You will work closely with multiple contractor teams and the customer to transform approved requirements into features during each sprint. You will help to develop the new suite of applications one sprint at a time. As a Database Administrator/ Engineer, you will deliver services within a cloud environment, while working within an Agile project team. You will also be responsible for participating in collaborative discussions and helping to establish DB administration norms and practices to ensure consistency across the multiple development and integration efforts.

As a Database Administrator/ Engineer you will be responsible for the following:

Providing technical expertise and support in the use of PostgreSQL DBMS

Creating and maintaining database objects such as tables, views, index, constraints for data platform and custom applications

Developing, implementing, and maintaining database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.

Creating views to drive front-end data analytics and reporting.

Driving end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools

Implementing automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production, and non-production environments

Administering PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment

Enhancing and maintaining logical and physical database designs from application requirements

Designing and implementing automation using SQL scripts and database functions

Responding to user reported errors in a timely manner.

Monitoring systems performance and identifying problems that may arise.

Liaison with developers and IT project managers

Recommending changes and enhancements for database performance and protection

Maintaining an awareness of trends and developments in database development and administration

Leveraging experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)

The ideal Database Administrator/ Engineer candidate should demonstrate the following skills:

Active TS/SCI w/FSP

Bachelor’s degree in computer science, software engineering, or related field of study

6+ 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

Experience with optimizing database performance through exhaustive proactive testing and ongoing real-time monitoring

Experience with SQL scripting and database functions

Experience 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 managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 or PostgreSQL DB.

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

Additional desired skills for the Database Administrator/ Engineer candidate include the following:

Experience implementing and deploying databases in Amazon Web Services (AWS)

Experience with AGILE / DEVOPS a plus

Working knowledge of COTS tools supporting data governance.

Experience with Financial Management Systems.

Powered by JazzHR

hsD9u2YHCB