GENERAL DUTIES:

Provide technical expertise and support in the use of PostgreSQL DBMSCreate and maintain database objects such as tables, views, index, constraints for data platform and custom applicationsDevelop, 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 applicationsCreate views to drive front-end data analytics and reportingDrive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party toolsEnhance and maintain logical and physical database designs from application requirementsDesign and implement automation using SQL scripts and database functionsRespond to user reported errors in a timely mannerMonitor systems performance and identifying problems that may ariseLiaison with developers and IT project managersRecommend changes and enhancements for database  performance and protectionMaintaining an awareness of trends and developments in database development and administrationLeverage experience to provide support in the areas of data mapping, data extraction, transformation, and loading (ETL)

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 systemsExperience with AWS RDS or Aurora for PostgreSQLFamiliar with open-source DBMS tools such as pgAdmin, pgModeler, or DBeaverExperience with data modeling and Entity-Relationship Diagrams (ERDs)Experience with Structured Query Language (SQL)Possess analytic problem-solving skillsKnowledge of computer software applications, including database technologies and programming languagesExcellent verbal and written communication skills

DESIRED QUALIFICATIONS:

Bachelor’s degree in computer science, software engineering, or related field of studyExperience 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 toolsImplemented automated methods and industry best practices for consistent installation and configuration of PostgreSQL for production, pre-production and non-production environmentsAdministrated PostgreSQL databases throughout the non- production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environmentExperienced with optimizing database performance through BILLET TBD exhaustive proactive testing and ongoing real-time monitoringExperienced in SQL scripting and database functionsExperience in testing database security and enterprise policy guidelines according to established best practicesMonitored and maintained the backups for database recoverability for all production databasesExperience 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

CLEARANCE:

Full Scope Polygraph minimum

‍