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