Provide technical expertise and support in the use of DBMS
Evaluate and recommend available DBMS products to support validated user requirements
Define file organization, indexing methods, and security procedures for specific user applications
Create and maintain database objects such as tables, views, indexes, constraints, etc. for data platforms and custom applications
Ability to design and extract key data items as part of a conversion to SAP.
Able to recommend and enhance (where needed) existing data models and design to facilitate better and more accurate data throughput.
Work with the data migration team to provide extracted data from 1 or multiple sources to facilitate an ERP conversion.
Design and implement automation using scripts, must be proficient in scripting
Create and maintain detailed documentation of all data models and systems created
Qualifications
At least six (6) years of experience in administering on-prem/cloud-based multi-user environments with expertise in planning, designing, building, and implementing complex database systems
Experienced in Data ETL, Data Modeling and Analysis, SAP (BODS), and Oracle.
2 positions available. SAP HANA and AWS RDS are preferred for one of the positions
Knowledge of the EDB PostgreSQL DB architecture
AWS cloud base Postgres database administration experience
Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools
Implemented automated methods and industry best practices for consistent installation and configuration of EDB PostgreSQL for production, pre-production, and non-production environments
Administrated PostgreSQL databases throughout the non-production (Sandbox, development, test, UAT, Training), pre-production (Staging), and production lifecycles in an AWS environment
Experienced with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring
Experienced in scripting and database functions
Experience in testing database security and enterprise policy guidelines according to established best practices
Monitored and maintained the backups for database recoverability for all production databases
Must have experience 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 EDB PostgreSQL DB is preferred
Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or experience.