Database Administrator - SQL Server

Roles And 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 reliability.

Qualifications & Skills :

ref : hirist.tech)