Application DBA – PostgreSQL / Snowflake / MongoDB / Apache Iceberg

Job Title: Application DBA – PostgreSQL / Snowflake / MongoDB / Apache Iceberg
Location: Remote

Job Summary

We are seeking an experienced Application Database Administrator (Application DBA) with expertise in Cloud SQL for PostgreSQL, Snowflake, MongoDB, Apache Iceberg, and data modeling. The ideal candidate will be responsible for database administration, performance optimization, data architecture, schema design, and ensuring the availability, security, and reliability of enterprise data platforms.

The candidate should have experience managing relational and NoSQL databases, supporting cloud-based data environments, and collaborating with application development, data engineering, and analytics teams.

Key Responsibilities

• Administer, configure, monitor, and maintain Cloud SQL for PostgreSQL, Snowflake, and MongoDB environments.

• Manage database availability, performance, scalability, security, and reliability.

• Perform database performance tuning, query optimization, indexing, and execution-plan analysis.

• Design, implement, and maintain database schemas, tables, views, stored procedures, and indexes.

• Develop and maintain logical and physical data models based on business requirements.

• Support database migrations, upgrades, patching, backup, and recovery activities.

• Monitor database health, capacity, resource utilization, and performance metrics.

• Implement database security, access controls, authentication, authorization, and auditing.

• Troubleshoot database connectivity, locking, concurrency, and performance issues.

• Support application teams with database design, SQL development, and production issue resolution.

• Work with data engineering teams to support data lakehouse architectures using Apache Iceberg.

• Manage database integrations with cloud-native applications and data pipelines.

• Establish database standards, documentation, operational procedures, and best practices.

• Collaborate with developers, architects, DevOps engineers, and data engineers to improve database reliability.

• Participate in disaster recovery planning, high-availability implementation, and business continuity activities.

Required Technical Skills

1. Cloud SQL / PostgreSQL

• Strong experience with PostgreSQL database administration.

• Experience with Google Cloud SQL for PostgreSQL or similar managed PostgreSQL services.

• Expertise in SQL, query optimization, indexing, and execution-plan analysis.

• Experience with database schema design, stored procedures, functions, and triggers.

• Knowledge of backup, restore, replication, and high-availability configurations.

• Experience troubleshooting database performance and connectivity issues.

2. Snowflake

• Hands-on experience with Snowflake database administration and platform management.

• Understanding of Snowflake architecture, virtual warehouses, databases, schemas, and tables.

• Experience with SQL query optimization and warehouse performance tuning.

• Knowledge of role-based access control (RBAC), user management, and security.

• Experience managing data loading, storage, and query execution.

• Understanding of Snowflake cost optimization and resource monitoring.

3. MongoDB

• Experience administering and maintaining MongoDB databases.

• Knowledge of document-oriented data modeling and schema design.

• Experience with indexing, query optimization, and performance monitoring.

• Understanding of replication, sharding, backup, and recovery.

• Experience managing database security and access controls.

• Ability to troubleshoot database performance and application connectivity issues.

4. Apache Iceberg

• Understanding of Apache Iceberg table formats and modern data lakehouse architecture.

• Experience working with large-scale analytical datasets.

• Knowledge of table metadata, snapshots, schema evolution, and partition evolution.

• Understanding of ACID transactions and time-travel capabilities in data lakehouse environments.

• Familiarity with integration between Apache Iceberg and query engines or data processing frameworks.

• Knowledge of data storage and processing platforms such as Amazon S3, Spark, Trino, or similar technologies is an advantage.

5. Data Modeling

• Strong knowledge of conceptual, logical, and physical data modeling.

• Experience designing normalized and denormalized data models.

• Ability to translate business requirements into efficient database schemas.

• Understanding of relational and NoSQL data modeling techniques.

• Experience defining primary keys, foreign keys, indexes, relationships, and constraints.

• Knowledge of data integrity, data quality, and database design best practices.

• Ability to optimize data models for transactional and analytical workloads.

Additional Technical Skills

• Experience with cloud platforms such as Google Cloud Platform (Google Cloud Platform), AWS, or Azure.

• Proficiency in SQL and database scripting.

• Knowledge of database monitoring and observability tools.

• Experience with database migration and ETL/ELT processes.

• Familiarity with Git, CI/CD, and database change-management practices.

• Understanding of production support, incident management, and root-cause analysis.

• Knowledge of data governance, compliance, and security best practices.

Preferred Qualifications

• Experience supporting enterprise applications and production database environments.

• Experience working with both relational and NoSQL database platforms.

• Exposure to cloud-based data warehouses and lakehouse architectures.

• Experience supporting data engineering and analytics teams.

• Relevant database or cloud certifications are a plus.

Regards,

Radiantze INC