PostgreSQL DBA Required For Hitachi MGRM Net Ltd

₹ 75,000.00 — 150,000.00 INR
About the Company



Hitachi MGRM Net Ltd is a global organization that crafts social innovation solutions across different sectors

covering the citizen life-cycle.
We focus on partnering with citizens, institutions and governments and

digitally transforming the lives of people, communities and society and enabling their full potential.

With over various business bases in India, the Hitachi MGRM Net initiatives ranges from Educational EGovernance Technologies, Healthcare Technologies, Insurance Technologies, Automotive Technologies, Information & Telecommunications Systems, Smart City Solutions, Data Center Solutions, Digital Solutions & Services, Infrastructure Systems, Industrial Systems and many more.



More details on our products and services can be obtained from www.hitachi.mgrmnet.com.



Requisite Skill Set & Work Experience



Candidate must have DBA and SQL experience.
Detailed JD mentioned below:

• Should have experience in PostgreSQL database administration activities like installation, monitoring,

backup and restore, access control etc

• Must have experience in PostgreSQL database architecture, logical and physical design, automation,

documentation, installs, shell scripting, PL/ SQL programming (stored procedures, views and materialised

views), catalogue navigation, query tuning, system tuning, resource contention analysis, backup and recovery,

standby, replication

• Hands-on Experience in implementing data partitioning, data encryption and database security.

• Hands-on Experience in implementing high performance and high availability PostgreSQL& MySQL

clustering, replicability and connection pools.

• Experience in writing PostgreSQL job-schedulers using pg_cron or any other scheduler tool

• Hands-on Experience in designing data warehouse and OLAP databases with postgresql and mysql

• Experience in using ETL tools like Pentaho Data integration or any other opensource tools

• Experience in conversion of Oracle database objects to PostgreSQL/MySQL database objects

• Similar experience for MySQL database is preferred.

• Must have strong knowledge on Linux.

• Strong understanding of command line and server administration.
Knowledge of shell scripting (e.g., Bash,

Perl).

• Has strong Python programming skill and be able to develop dba applications for system automation and

integration.

• Be responsible for defining and documenting architecture, capturing and documenting non-functional

(architectural) requirements, preparing estimates and defining technical solutions;

• Experience in addressing non-functional requirements such as availability, scalability;

• Experience in Micro Services would be added advantage;

• Track record for excellence in previous organization(s).



Educational Qualification

• B.
Tech/B.
E./MCA with 4-10 years of relevant technology specific experience.

Similar Freelance jobs:

Customize Teedy Dms Source Code And Deploy For Production
Teedy is an open source, lightweight document management system for individuals and businesses. I need help to setup the open source code on my local computer and add some customization for deployment. The freelancer will be given access via remote desktop to setup Visual Studio and Tomecat for the wep application deployment and also assist in hosting the application on my hosting space. Customization includes adding another user authentication level and little adjustment to the theme.
Full Description of Customize Teedy DMS Source Code and deploy for…
Tuning Db Mysql
Kami membutuhkan yang bisa melakukan tuning DB mysql di AWS cloud dgn tipe provision agar menghasilkan performance yg optimal.
Full Description of Tuning DB mysql
Devops Kubernetes Environment
Dockerize and script high availability environment on Kubernetes for SpringBoot Java application and databases.
Full Description of Devops Kubernetes Environment
Setup Postgresql Replication
We run a customer service environment where we use postgresql as db. We need help configuring master slave environment. Read more in attached specification. Give an estimate of costs and write down your qualifications. Thanks /Dan Erik Ollas (Sweden)
Full Description of Setup PostgreSQL replication
Full Stack Developer For Wms/oms Saas Project, With Hasura, React, Nextjs Nodejs Api Building
We're trying to develop and Admin panel for our company new service. We provide managed service to e-commerce entrepreneurs helping them with warehouse operations, courier allocations, tracking Reconciliation and remittance of cash payments (COD)to them Core of the products are: Authentication Admin and Sub user system with role based permissions Display of order sync data that our client will import linking Shopify or Woo commerce. They can edit the orders details and mark them further for processing. Display of Shipment…
Full Description of Full stack developer for WMS/OMS SAAS project, with…
Mysql Large Db Optimization And Performance Tuning. Fulltext Queries
The developer is required to work on an existing copy of our MySql DB and optimize its performance. The DB is composed of around 30 tables and is around 2.6Gb big. The biggest table alone is about 2Gb because it stores a lot of text in a text field. This table uses MyISAM engine and this must be preserved, cannot be partitioned because we run fulltext queries on it. Fulltext select are very slow and we need to solve this…
Full Description of Mysql large DB optimization and performance tuning. Fulltext…
To Pull Data From 3 Different Apis And Save Into A Single Database And Have Standard Function Admin Panel With Lav
I would like to integrate 3 different apis into 1 database and have that turn into an single api firebase or pub/sub Then to test the data pulls and displays in android and ios properly by connecting to database or API whatever is best. Must be something better than or same as themeforest admin api themes . `We are recreating the 3 highly documented apis into 1 single api system to be used for websites/ios/android app and ready to use…
Full Description of To pull data from 3 different apis and…
Oracle, Sql
Hello, I have some issues on my sql project, need help to fix my inserts and 2 trigger.
Full Description of Oracle, SQL
Setup Osm Tile Server
Configuração de um server OpenStreetMap Tile Server on Ubuntu 20.04 tile server como exemplificado neste link: https://www.linuxbabe.com/ubuntu/openstreetmap-tile-server-ubuntu-20-04-osm Idealmente será necessário adicionar um estilo bright aos mapas: https://github.com/mapbox/osm-bright Temos preferência de alguém com experiência neste tipo de configurações, neste momento vamos apenas fazer setup a uma máquina para testes, de futuro vamos precisar de 4 configurações iguais em 4 servidores.
Full Description of setup OSM tile server
Upload 2500 Products
i have around 2500 products .i have excel ready with all information . you have run a script and upload all products and images . important thing to note . we have 10 languages in our website there fore 10 lanauges . product descriptions have already been translated and are in excel file . All product descriiptions are same only atrribute values differ eg size , name colour price etc , however product description in 10 langugaes are all same…
Full Description of upload 2500 products
Australian Wineries
Hi, I'm in search of someone who can assist me in putting together a list of Australian wineries, to find wines that must meet specific requirements in terms of region, grape variety and vintage year.
Full Description of Australian wineries
Get Data From 3 Different Apis And Save Into A Single Database And Have Standard Function Admin Panel With Lav
I would like to integrate 3 different apis into 1 database and have that turn into an single api firebase or pub/sub Then to test the data pulls and displays in android and ios properly by connecting to database or API whatever is best. Must be something better than or same as themeforest admin api themes . `We are recreating the 3 highly documented apis into 1 single api system to be used for websites/ios/android app and ready to use…
Full Description of Get Data from 3 different apis and save…
Data Engineer
Using SQL and Python programming languages, create and maintain optimal ETL and data pipeline architecture, Assemble large, complex data sets that meet functional / non-functional business requirements from a variety of data sources to the AWS Data Lake Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Maintain the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS…
Full Description of Data Engineer
Necesito Experto Para Base De Datos
Necesito que me ayuden a formular una base de datos para hacerla más automatizada y optima
Full Description of Necesito Experto para base de datos
Saas Django Project
I have Django + React project and need a candidate who fix some issue in my project. The candidate must know Python, Django, React. If it goes well, we can work forward to continue. Let me know who can work for me for a long term. Thanks.
Full Description of Saas Django project
© 2006 — 2024 hirelancer.com is an affiliate website, listing the freelance projects. We are collaborating with other sites like getFreelancer.com. Feel free to bid on any project and good luck! You will need register first, before bidding or posting projects. Basic memberhsip is always free. We might earn commissions from referring you. You will never ever pay additional fees for we referred you.