C4 Technical Services
DBA (MonetDB, PostgreSQL)
C4 Technical Services, Minnetonka, Minnesota, United States, 55345
Sr. DBALocation:
no location requirement, CST and EST preferred (Chicago would be nice)
Key Areas of Responsibility:
Installing PostgreSQL and its related extensions on different flavors of Linux environment.Health check of a PostgreSQL instances monitoring whether it is up and running all the time.Tunning PostgreSQL configuration parameters as per the server specs.Creating Databases, Tablespaces, and users/Schemas.Work closely with business, IT Associates and outside vendors to effectively choose, Plan, Deploy and maintain system changes.Develop standardization documentation and research for new features for best practices.Understand DBA challenges, deliver technical solution that meet the unique needs of DBAs with innovation and automation.Learn continuously, leveraging training resources and self-directed training, Sharing knowledge and skills with rest of the team.
Key Desired Skills, Experience, & Knowledge:
Minimum 10 + years of hands-on experience on PostgreSQL and Monet databases on Linux.The candidate should have good communication skills and strong technical knowledge on PostgreSQL.Hands on experience in performance fine-tuning, monitoring and administration in production instances required.Ability to estimate and perform capacity planning on required phases on environment.Should have exposure on different kinds of backups and restore activities.Should have good knowledge on PostgreSQL high availability features.Experience in Disaster recovery setups, Active-Active PG configurationsAbility to perform maintenance activities to improve performance.Good Experience in data migration activities from oracle to PostgreSQL using ora2pg.Should have experience on third party tools such as pgbadger, barman and pgbackrest.Ability to perform upgrading of PostgreSQL clusters from lower version to higher version.Ability to setup the foreign data wrapper mechanisms for cross database access.Should have experience in configuring and managing the pgpool and troubleshoot for any kind of issues.Should have experience in tuning the application queries and recommends for changes accordingly.Ability to perform maintenance activities like performing full vacuum and analyze operations.Skills in other open-source databases will be a plus.Experience working offshore-onshore model will be a plus#DICEjpeter@c4techservices.com
no location requirement, CST and EST preferred (Chicago would be nice)
Key Areas of Responsibility:
Installing PostgreSQL and its related extensions on different flavors of Linux environment.Health check of a PostgreSQL instances monitoring whether it is up and running all the time.Tunning PostgreSQL configuration parameters as per the server specs.Creating Databases, Tablespaces, and users/Schemas.Work closely with business, IT Associates and outside vendors to effectively choose, Plan, Deploy and maintain system changes.Develop standardization documentation and research for new features for best practices.Understand DBA challenges, deliver technical solution that meet the unique needs of DBAs with innovation and automation.Learn continuously, leveraging training resources and self-directed training, Sharing knowledge and skills with rest of the team.
Key Desired Skills, Experience, & Knowledge:
Minimum 10 + years of hands-on experience on PostgreSQL and Monet databases on Linux.The candidate should have good communication skills and strong technical knowledge on PostgreSQL.Hands on experience in performance fine-tuning, monitoring and administration in production instances required.Ability to estimate and perform capacity planning on required phases on environment.Should have exposure on different kinds of backups and restore activities.Should have good knowledge on PostgreSQL high availability features.Experience in Disaster recovery setups, Active-Active PG configurationsAbility to perform maintenance activities to improve performance.Good Experience in data migration activities from oracle to PostgreSQL using ora2pg.Should have experience on third party tools such as pgbadger, barman and pgbackrest.Ability to perform upgrading of PostgreSQL clusters from lower version to higher version.Ability to setup the foreign data wrapper mechanisms for cross database access.Should have experience in configuring and managing the pgpool and troubleshoot for any kind of issues.Should have experience in tuning the application queries and recommends for changes accordingly.Ability to perform maintenance activities like performing full vacuum and analyze operations.Skills in other open-source databases will be a plus.Experience working offshore-onshore model will be a plus#DICEjpeter@c4techservices.com