Intermediate Database Administrator supporting systems on various database technologies for asset management firm. Collaborating with developers and data scientists for high - performance data systems.
About the role
- Associate Database Administrator specializing in PostgreSQL for Datavail, handling installation, backup, and migration tasks. Focused on delivering cloud and on-prem solutions across multiple platforms.
Responsibilities
- 5+ years of relevant experience.
- Good knowledge of PostgreSQL Database Architecture.
- Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies.
- Strong experience in handling Database Logical and Physical Backups.
- Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR).
- Expertise in Applying database patches from lower version to higher version.
- Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade).
- Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool.
- Expertise in Streaming Replication (Including Cascading Replication).
- Configuring pgbouncer for connection pooling.
- Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.
- Handling Database corruption issues.
- Have done Oracle to PostgreSQL Migration for multiple clients.
- Strong knowledge on PostgreSQL configuration parameter for tuning the DB health.
- Managed Users and Tablespace on PostgreSQL Servers.
- Configuring Heterogeneous DB connections between Oracle, PostgreSQL.
- Expertise in Shell scripts for performing Online Backup and maintenance activity.
- Strong experience in setting up RDS & Aurora Cluster.
- Tuning parameter group and configuring Aurora cluster for Read Replica.
- Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket.
- Experience on Reviewing performance Metrics on Aurora PostgreSQL.
Requirements
- 5+ years of relevant experience.
- Good knowledge of PostgreSQL Database Architecture.
- Installing, configuring PostgreSQL using source code, RPM, one-click installation on-prem and Cloud Technologies.
- Strong experience in handling Database Logical and Physical Backups.
- Hands on experience on restoration techniques on PostgreSQL like pg_restore and Point in time recovery (PITR).
- Expertise in Applying database patches from lower version to higher version.
- Major and Minor upgrade of PostgreSQL DB's on multiple platforms (pg_dump/pg_restore & pg_upgrade).
- Implemented PostgreSQL DR servers and PostgreSQL load balancing using pgpool.
- Expertise in Streaming Replication (Including Cascading Replication).
- Configuring pgbouncer for connection pooling.
- Configuring pgbadger for generating statistic report on the basis PostgreSQL log file.
- Handling Database corruption issues.
- Have done Oracle to PostgreSQL Migration for multiple clients.
- Strong knowledge on PostgreSQL configuration parameter for tuning the DB health.
- Managed Users and Tablespace on PostgreSQL Servers.
- Configuring Heterogeneous DB connections between Oracle, PostgreSQL.
- Expertise in Shell scripts for performing Online Backup and maintenance activity.
- Strong experience in setting up RDS & Aurora Cluster.
- Tuning parameter group and configuring Aurora cluster for Read Replica.
- Configuring RDS & Aurora PostgreSQL Logs to push to S3 Bucket.
- Experience on Reviewing performance Metrics on Aurora PostgreSQL.
Benefits
- Learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience.
- Your Certifications would be on us.
- Future Opportunity for permanent deputation on H1B to work in US.
- Leverage the DV Training program to upscale the technical skills.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Database Administrator working with financial clients to ensure database performance and reliability. Collaborating with development teams and implementing backup and recovery processes in Azure.
Lead Database Administrator supporting multiple RDBMS and Snowflake Data Warehouse production. Collaborating with Fidelity Business Units and implementing data analytics strategies in the cloud.
Lead Database Administrator optimizing database performance in a growing Cloud Operations team at Vendavo. Collaborate with teams and manage large databases using innovative technologies.
Senior Database Administrator at Boeing managing SAP HANA and SQL Server infrastructures across multiple locations. Collaborating with teams to design and implement solutions in a dynamic environment.
Database Administrator maintaining Oracle databases and supporting analyst and developer teams. Managing database changes, improvements, and new project designs.
Oracle, MySQL, and MongoDB Database Administrator responsible for 24/7 support at Deutsche Börse Group. Requires 5 - 6 years experience and knowledge of risk/security requirements.
Oracle Database Administrator overseeing design and integration of database solutions at Gainwell. Ensuring performance tuning, data security, and backup strategies in a fast - paced environment.
DBA Architect to design, govern, and optimize enterprise database platforms with a strong focus on Azure SQL services. This role owns database architecture, high availability, performance, security, and automation.
Client Database Administrator to support the accuracy and maintenance of client data for compliance. Working in hybrid setting for a KPO company in Clark, Philippines.