Posted Nov 10, 2021 2 views
The current enterprise environment consists of multiple stand-alone databases Postgres 12 as well as Java Application deployed on Apache Tomcat, Ubuntu Linux and Proxy Servers.
- The role requires the DBA to work in a dynamic environment with software developers, DB team, System admin and Network Team, using various operating systems such as Ubuntu Linux, Windows, and VMW are.
- The ability to work with minimal supervision and the ability to work in a team in an agile environment is required.
- The role requires someone who has fully embraced open source technologies and has previous experience in leading organizational transformations.
- Prior exposure to alternative DB technologies such as Time Series optimized databases would be a plus. Experience and innovative ideas in database administration, data replication, DevOps and middle-tier administration are highly desired.
- The Database Administrator will provide database administration/application support to the entire system development life cycle.
- The individual will be responsible for daily operations, monitoring, backup and recovery, performance tuning, installation, configuration and patching of databases.
- The role requires the DBA to work with System Analysts and the Data Manager to review and optimize logical data models/database scripts and implement them into the physical database.
JOB REQUIREMENTS
- Analytical thinkingExcellent communication Ability to learn, absorb and apply new knowledge Strong attention for detail Working in a team Proactive approach Working under pressure TECHNICAL REQUIREMENTS Hands-on experience in database administration and performance tuning.
- 4+ years’ technical knowledge and experience with Postgres in a production setting and new JSON/JSONB features.
- NoSQL database experience is desired.
- PostgreSQL Development experienceExperience with Shell Scripting Experience with SQL development, data modelling and database security.
- Experience with Database backup, disaster recovery processes and procedures.
- Experience with SQL tools as required for the database solution such as pgAdmin or DataGrip.
- Experience with git or other source control software.An understanding of the Agile framework and the DevOps approach.
- Experience researching software & technology and making recommendations on their use.
- Strong problem solving and analytical skills.
- Very good communication skills and interpersonal skills.
- Experience responding to and resolving database access and performance issues.
- Experience interpreting database error messages and the ability to execute recovery of the database instance, data or other pertinent database components Experience with PostgreSQL streaming Replication and replication manager (repmgr)Experience with PostgreSQL logical replication and replication clients such as wal2json and debezium is desired.
- Experience with PostgreSQL Database Partitioning,Experience with High Availability and Hot-standby servers Experience with PGBouncer and how it is related to High availability Experience with PGBarmanExperience with Docker Containers and docker-compose Experience with Time Series databases such as Druid Experience with ETL and general data extraction operations for report generation BS in Computer Science or Computer Engineering, or related technical discipline is desirable.*
Job Details
Mi C3 International
Mi-C3 International Limited is an international software-as-a service company based in Malta. The company has offices in Skopja - Macedonia, Lahore - Pakistan, and a satellite branch in Lagos - Nigeria. The company provides a suite of digital operations management tools, collectively named Affectli, to several industries worldwide. The leading platform is primarily developed for operations management, servicing blue-chip companies in varied industries requiring a detailed and real-time oversight of highly complex operations. We are currently in the process of setting up our offices in Lahore. This process is in the final stages of completion.
What is your Competitive Advantage?
Similar Job Titles
Ayesha Shaukat
Social Media Marketing Manager
Ivoke
Muzammil Baig
Digital Marketing Manager
IT Services Group
Zubair Anjum
Business Excellence Specialist
Nestle Pakistan
Mona Sharif
Senior Team Lead
Konext PVT. LTD
Ali Aziz
CEO
Shopistan
Zohaib Ali
Marketing Manager
Digital Online Devices
Sehrish Azhar
Motivational Speaker & Blogger
Living Upbeat
Babar Ahmed Khan
Territory Sales Manager
Engro Foods
Usman Habib
Recruitment & Training Executive
ACS Synergy (Pvt) Ltd.
Aqib Irshad
Head of HR, Training & OD
FINCA
