Database Administrator

Job Description

Job Requirements 7+ years of hands-on experience in database administration, design, implementation, and support. Expertise in PostgreSQL (installation, configuration, tuning, and maintenance). Strong proficiency in SQL including writing complex queries, stored procedures, triggers, indexing, and performance tuning. Proven experience in backup and recovery strategies, including point-in-time recovery (PITR). Familiarity with replication, clustering, and high availability architectures. Hands-on experience with database monitoring tools and query performance analysis. Knowledge of database security, roles, and access controls. Experience working in cloud-based environments (e.g., AWS RDS, Azure Database for PostgreSQL) is a strong plus. Good understanding of DevOps practices, CI/CD, and version control tools (e.g., Git) in relation to database development. Strong problem-solving and troubleshooting skills. Ability to mentor junior DBAs and work collaboratively in a cross-functional team. Key responsibilities: Manage, monitor, and maintain PostgreSQL and SQL Server database environments. Design and implement database schemas, objects, and indexes to support application requirements. Perform performance tuning and query optimization for large-scale databases. Create and maintain database backup and disaster recovery plans. Implement and monitor replication and high availability solutions. Conduct routine database health checks, patching, and upgrades. Collaborate with developers and architects to optimize database performance and structure. Automate routine database tasks and improve operational efficiency. Create comprehensive documentation for database configurations, standards, and procedures. Provide on-call support for production database systems as needed.