Data Engineer/DBA

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 DBMSCreating and maintaining database objects such as tables, views, index, constraints for data platform and custom applicationsDeveloping, 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 toolsImplementing automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production, and non-production environmentsAdministering PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environmentEnhancing and maintaining logical and physical database designs from application requirementsDesigning and implementing automation using SQL scripts and database functionsResponding to user reported errors in a timely manner.Monitoring systems performance and identifying problems that may arise.Liaison with developers and IT project managersRecommending changes and enhancements for database performance and protectionMaintaining an awareness of trends and developments in database development and administrationLeveraging 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/FSPBachelor's degree in computer science, software engineering, or related field of study6+ 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 PostgreSQLExperience with optimizing database performance through exhaustive proactive testing and ongoing real-time monitoringExperience with SQL scripting and database functionsExperience 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 languagesExcellent verbal and written communication skillsAdditional 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 plusWorking knowledge of COTS tools supporting data governance.Experience with Financial Management Systems.