Technical Specialist - PostgreSQL DBA at Datavail Career Site

Hyderabad, Telangana, India -

Full Time

Start Date

Immediate

Expiry Date

11 Jun, 26

Salary

0.0

Posted On

13 Mar, 26

Experience

10 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PostgreSQL Open Source, EDB PostgreSQL, AWS, Microsoft Azure, GCP, Pgbadger, PgAdmin, Pgbouncer, BARMAN, Pgbackrest, Repmgr, Patroni, Pg_repack, Shell Scripts, Query Tuning, Performance Improvement

Industry

IT Services and IT Consulting

Description

Job Title: Technical Specialist Education: Any Graduate Experience: 8 to 15 years Location: Bangalore/Hyderabad/Mumbai Key Skills: * PostgreSQL Open Source and EDB PostgreSQL. * AWS, Microsoft Azure and GCP - PostgreSQL. * Pgbadger, PgAdmin, Pgbouncer, BARMAN, pgbackrest, repmgr, Patroni and pg_repack Job Description: * 7+ years of relevant PostgreSQL DBA 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. * Strong experience in Query Tuning and performance improvement. * 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 and query tuning on Aurora PostgreSQL * Configured Query Store and Analytics workspace on MS Azure Cloud. Datavail is a leading provider of data management, application development, analytics, and cloud services, with more than 1,000 professionals helping clients build and manage applications and data via a world-class tech-enabled delivery platform and software solutions across all leading technologies. For more than 17 years, Datavail has worked with thousands of companies spanning different industries and sizes, and is an AWS Advanced Tier Consulting Partner, a Microsoft Solutions Partner for Data & AI and Digital & App Innovation (Azure), an Oracle Partner, and a MySQL Partner. Datavail’s Team of PostgreSQL Experts Can Save You Time and Money We have extensive experience with just about everything in PostgreSQL. Our consultants, architects, DBAs, and database development team have extensive hands-on experience in traditional on-prem PostgreSQL and in Cloud too. Our experts have an average of 15 years of experience. They’ve overcome every obstacle in helping clients manage everything from databases, analytics, reporting, migrations, and upgrades to monitoring and overall data management. You can free up your IT resources to focus on growing your business rather than fighting fires. Our PostgreSQL experts can guide you through strategic initiatives or support routine database management. Datavail’s Comprehensive PostgreSQL Database Services Datavail offers PostgreSQL consulting services that allow you to take advantage of all the features of the PostgreSQL database. By providing high availability solutions, building high end database systems, architectural support, and managed service support our team can ensure optimal performance for your database on-prem or in the cloud. PostgreSQL Database Managed Services Datavail’s business focuses on helping you use your data to drive business results through cost-saving services. The success of your business depends on how well you understand and manage your data. Our managed cloud services give you the power to unleash your organization’s potential. We provide comprehensive and technically advanced support for PostgreSQL installations to ensure that your databases are safe, secure, and managed with the utmost level of care. Our delivery performance in data management leads the industry. We offer highly trained PostgreSQL database administrators via a 24×7, always on, always available, global delivery model. With the combination of a proven delivery model and top-notch experience ensures that Datavail will remain the database experts on demand you desire. Datavail’s flexible and client focused services always add value to your organization. Are you a seasoned PostgreSQL Database Administrator? Does working in a multi customer, multi domain environment on global scale motivates you? If yes, this role could be a good fit for you. Datavail is seeking a highly skilled, self-motivated, and passionate PostgreSQL DBA to join our PostgreSQL Global Practice. As a PostgreSQL DBA, you will be working on the latest Opensource technologies in the industry. This position is based out of our global delivery centers in Mumbai, Hyderabad, and Bangalore in India. Datavail is one of the largest data-focused services company in North America and provides both professional and managed services and expertise in Database Management, Application Development and Management, Cloud & Infrastructure Management, Packaged Applications and BI/Analytics. Why should you work at Datavail? * Learn from a vast pool of global PostgreSQL DBAs with over 500 combined years of industry experience. * You would be working with multiple customers in a multi domain environments.Work range: On-Prem core PostgreSQL DBs, AWS RDS & Aurora, and Azure - PostgreSQL. * 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.

Responsibilities

The specialist will be responsible for installing, configuring, and maintaining PostgreSQL databases on-premise and in cloud environments, handling backups, restorations, upgrades, and replication setups. Key duties include performance tuning, managing database corruption issues, and executing migrations from Oracle to PostgreSQL.