Posted today · be early

Database Administrator (PostgreSQL & MongoDB) - India

ACCUMED

IndiaremotePosted 1 day ago

Skill Required

Database-AdministratorDatabase-EngineerDatabase-Reliability-EngineerCloud-Database-EngineerPostgreSQL-DBAPostgreSQL-AdministratorPostgres-DBADatabase-Administration-JobsDatabase AdministratorPostgreSQLMongoDBBackup and RecoveryQuery OptimizationnetworkingObservabilityCryptographysecurityetc.)TestNGdesignMySQLAzureCloudSQLAWSGCPandFulltime

Key highlights

Required experience: 3-5 years as a Database Administrator
Preferred certifications: MongoDB, PostgreSQL
Manages both NoSQL (MongoDB) and SQL (PostgreSQL) databases
Uses cloud platforms AWS RDS, Azure DB, GCP
Focus on security, compliance, and disaster recovery
Position is for a health claim management solution

Role overview

Responsible for managing and optimizing the database infrastructure including setup, configuration, security, backups, monitoring and performance tuning. Supports data governance, integrity and regulatory compliance requirements. We are seeking a Database Administrator to manage the database infrastructure for our health claim management solution. You will set up, configure, optimize, audit and disaster recover database environments, including NoSQL databases (MongoDB) and SQL databases (PostgreSQL). Ensure availability, integrity, security, optimal performance, compliance and sustainability of mission-critical data used across the solution while minimizing risks and costs.

Responsibilities

Collaborate with architects, developers, business analysts and information security teams to understand data requirements, schemas, relationships, queries, reports, integrations, policies and key metrics. Determine appropriate database technologies (document DBs, wide-column stores, key-value stores, etc.) and configurations to meet needs securely and sustainably.
Install, configure, monitor and optimize database instances on-premises or on cloud infrastructure (AWS RDS, Azure DB, GCP Dedicated Hosts). Setup high availability for production databases with replication, multi-AZ deployment and failover.
Administer user access, activity monitoring, security, auditing and permissions for database accounts and roles. Enforce policies including authentication, authorization, encryption, access control, audit trails and anomaly detection. Prevent unauthorized access or malicious activity.
Provide disaster recovery through backup scripts, replication, cloud disaster recovery and business continuity planning. Recover databases rapidly and accurately in the event of outages or corruptions.
Migrate databases between on-premises and cloud environments or different technologies (MongoDB to SQL, etc.) while minimizing downtime and data loss. Conduct impact analyses, planning and testing to ensure a successful migration.
Apply database tuning tools, metrics and best practices to optimize costs, performance, storage usage and scale. Upgrade/consolidate hardware and database versions as needed.
Advise developers and analysts on best practices for database design, modeling schemas, auditing data and querying efficiently. Review solutions for compliance, quality, auditability, performance and sustainability.
Stay up-to-date with innovations in database management, administration, security, compliance, disaster recovery, performance optimization and emerging technologies. Maintain expertise through continuous learning and strategic networking.