Sr. SQL Database Administrator - Charlotte, United States - ThemeSoft

Description

Role:
Sr


Database EngineerLocation:
Remote

Apply (by clicking the relevant button) after checking through all the related job information below.

Required Skills:
PostgreSQL DB AdminIBM DB2 LUW DB Admin, PostgreSQL DB AdministrationResponsibilities:Experienced with PostgreSQL Installation & Configuration.
Should have experience on Upgrade and patches.
Experience on migrations from Oracle to PostgreSQL and on-prem to cloud.
Database user roles and Security related permissions.
PostgreSQL Index Management.
Good knowledge of ITIL processes.
PostgreSQL Partitioning and System Catalogs.
Backup, Recovery and PITR.DR Replication monitoring and configuring streaming replication.
Database Performance tuning. Should be proficient in tuning the shared_memory, work_mem, maintenance_work_mem areas, Buffer Cache, Rollback Segments, Redo/Undo Mechanisms.


OS:
Linux and any cloud Knowledge

Tools:
PGAdmin4, PGPool, PEM, BART, BARMAN, ORA2PG, and all pg backup and restore utilities

High Availability:
Streaming replication, WAL replication and fail-over of replication. Knowledge on Patroni cluster or any 3-node cluster with DR setup.


Qualification:
Must have a strong foundation in PostgreSQL DB Administration with proven experience.
Experience in Admin Services & Prod related domains is essential.
Demonstrated ability to work independently and as part of a team.
Excellent problem-solving skills and attention to detail.
Strong communication and interpersonal skills are required.
Ability to manage multiple tasks and projects in a fast-paced environment.
RegardsPraveen KumarTalent Acquisition Group – Strategic Recruitment Manage
#J-18808-Ljbffr