Database Administrator
Are you ready to take on a dynamic role in a vibrant, tech-savvy environment? We're looking for a talented Database Administrator (DBA) to join our team, working with cutting-edge technologies and diverse platforms. Our enterprise setup includes multiple stand-alone Postgres 14 databases, Java applications on Apache Tomcat, Ubuntu Linux, and Proxy Servers. As our DBA, you'll collaborate with software developers, the DB team, system admins, and the network team, utilizing various operating systems like Ubuntu Linux and Windows.
In this role, you'll have the freedom to innovate and lead organizational transformations while fully embracing open-source technologies. If you've got a knack for database administration, data replication, DevOps, and middle-tier administration, we want to hear from you. Prior experience with Time Series optimized databases is a big plus!
You'll provide database administration and application support throughout the system development life cycle, handling daily operations, monitoring, backup and recovery, performance tuning, installation, configuration, and patching of databases. Working closely with System Analysts and the Data Manager, you'll optimize logical data models and database scripts, implementing them into the physical database.
JOB REQUIREMENTS
- Strong analytical thinking and problem-solving skills
- Excellent communication skills
- Ability to learn, absorb, and apply new knowledge quickly
- Meticulous attention to detail
- Team player with a proactive approach
- Ability to thrive under pressure
TECHNICAL REQUIREMENTS
- Database Administration: 4+ years of hands-on experience with Postgres in a production setting, including new JSON/JSONB features.
- NoSQL Database Experience: Familiarity with JSON query paths.
- PostgreSQL Development: Proficiency in PL/pgSQL.
- Scripting: Experience with Shell Scripting.
- Data Modeling and Security: Skilled in SQL data modeling, database security, and permissions.
- Backup and Recovery: Expertise in database backup and disaster recovery processes and procedures (pgBackrest).
- SQL Tools: Proficient with tools like pgAdmin, DBeaver, or DataGrip.
- Version Control: Experience with git or other source control software.
- Agile and DevOps: Understanding of Agile frameworks and DevOps methodologies.
- Research and Innovation: Ability to research software and technology, making recommendations for their use.
- Database Performance: Strong skills in responding to and resolving database access and performance issues.
- Error Handling: Ability to interpret database error messages and execute recovery operations.
- Replication and High Availability: Experience with PostgreSQL streaming replication, Patroni, native logical replication, and table partitioning.
- High Availability Tools: Familiarity with high availability setups and hot-standby servers, including PGBouncer.
- Kubernetes: Experience running PostgreSQL on Kubernetes using an operator.
- Time Series Databases: Knowledge of Time Series databases like TimescaleDB is a plus.
- ETL and Reporting: Proficiency in ETL, triggers, and data extraction operations for report generation.
- Education: A BS in Computer Science, Computer Engineering, or a related technical discipline is desirable.
Top Skills
What We Do
Mi-C3 International Limited is a Malta based company that was established in 2014 by the CEO and founder, Glen Scott.
The history and the philosophy of Mi-C3 is in its name which is a combination of two acronyms. The genesis of the technology was in supporting Command and Control for organisations that needed technology to improve their situational awareness to manage and secure their facilities. However, our technology enabled Command and Control to be enhanced with Collaboration (C3) as organisations were empowered with multi-directional communications that took command and control to a new level as more decision-making could be automated and information flows organised in a way that reams of data are transformed into meaningful intelligence (Mi).
Generations of the Mi-C3 software started as a project in the early 2000’s as a solution to support a large oil and gas company operating across multiple countries to help manage its complex operation and considerable security risk spread over a wide and poorly accessible geographical area before the Internet of Things (IoT) was widely understood, and has subsequently grown to over 30,000 sites, and monitoring more than 1 million end points.
Over the years, this solution has evolved into our award winning* flagship product, AFFECTLI, and has delivered significant value to clients through the use of a combination of cutting-edge technologies in the fields of Digital Process Transformation, smart workspaces, AI, machine learning, data management and analytics.
AFFECTLI is an established, flagship product of Mi-C3 that won the Malta MCA eBusiness Award for Best B2B Application 2018, was shortlisted for a nomination in the World Summit Awards 2018 under the Business & Commerce category, is ISO 9001:2015; ISO/IEC 20000:2011 and SOC 2 Type II compliant.
