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