Database Administrator Fully Remote

Database Administrator Fully 

remote

Mi-C3 International

Lahore.

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 thinking
• Excellent 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 experience

• Experience with Shell Scripting

• Experience with SQL development, data modeling 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 PGBarman

• Experience 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.

• BS in Computer Science or Computer Engineering, or related technical discipline required

Mi-C3 International

Link:> https://pk.indeed.com/rc/clk?jk=53e35123c281ae38&fccid=7aeddffaa01bea41&vjs=3