Data EngineerDBA
Data EngineerDBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
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 frontend data analytics and reporting.
- Driving endtoend 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 preproduction and nonproduction environments
- Administering PostgreSQL databases throughout the nonproduction (Sandbox development test UAT Training) preproduction (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
- Bachelors degree in computer science software engineering or related field of study
- 6 years of experience in administering onprem/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 realtime 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 opensource DBMS tools such as pgAdmin pgModeler or DBeaver.
- Experience with data modeling and EntityRelationship Diagrams (ERDs)
- Experience with Structured Query Language (SQL)
- Possess analytic problemsolving 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.
Required Experience:
Senior IC
Employment Type
Full-Time
