What are the responsibilities and job description for the Data Engineer / DBA with Security Clearance position at Cohere Technology Group?
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.
