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.

Please refer the Job description for details