Database Administrator

Responsibilities :

• Design, implement, and maintain high-performance, scalable, and secure database systems, ensuring data integrity and availability.
• Monitor and optimize SQL queries, indexes, and database configurations to support efficient data retrieval, especially under high load conditions.
• Perform regular database updates, migrations, transformations, and scripting tasks while minimizing downtime and ensuring data consistency.
• Analyze database performance through load testing, identify bottlenecks, and recommend actionable improvements to enhance stability and speed.
• Manage data security, encryption, backup policies, and disaster recovery strategies to ensure compliance and business continuity.
• Collaborate with DevOps, development, and analytics teams to troubleshoot performance, connectivity, and data inconsistency issues and implement best practices.
• Develop and maintain effective database architectures, schemas, and documentation such as data dictionaries and architecture diagrams.
• Proactively monitor database growth and recommend appropriate scaling strategies and resource optimization.
• Contribute to the design, maintenance, and enhancement of data lakes and data warehouses to support analytics and reporting needs.
• Leverage multi-database experience, including technologies such as OpenSearch, Firebase, Firestore, and PostgreSQL, to manage a diverse and dynamic data environment.
• Stay updated on emerging database technologies, tools, and industry best practices to continuously improve system performance and :
• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience); MCA or M. Tech is a plus.
• 4+ years of proven experience as a Database Administrator (DBA) working across both relational and non-relational database technologies.
• Strong command of database security, performance monitoring, backup, and recovery processes.
• Experience in database monitoring, troubleshooting, and resolving performance and connectivity issues.
• Solid understanding of relational and dimensional data modeling.
• Hands-on experience with cloud databases, particularly AWS.

ref : hirist.tech)