Role & Responsibilities
- Administer and support MS SQL Server, Oracle and PostgreSQL databases (cloud/on-premises) across development, staging, production and client environments ensuring performance, availability and security.
- Monitor and optimize database performance through query tuning, index optimization, and resource utilization tracking to ensure responsiveness for both internal users and external clients.
- Enforce robust database security policies, managing access based on the least privilege and Need-to-Know principles to protect sensitive data and comply with client-specific security requirements.
- Design, implement and regularly test backup and disaster recovery (DR) strategies to guarantee data integrity and business continuity for both in-house and client-hosted environments.
- Support client onboarding, database setup and custom configuration for product deployments, assist in resolving client-reported database issues.
- Collaborate with development and DevOps teams to support agile delivery cycles, including schema design, data versioning, migration planning, and automated deployment integration.
- Integrate database operations within CI/CD pipelines, supporting automated testing and release of updates across client and internal systems.
- Conduct proactive database health checks, capacity planning, and performance tuning to prevent downtime and ensure optimal system behavior under varied workloads.
- Maintain detailed technical documentation for schemas, configurations, release notes and client-specific database setups to enable support continuity and regulatory compliance.
- Plan and execute patches and upgrades in coordination with internal teams and clients, ensuring minimal disruption to ongoing operations.
- Take ownership of any additional technology-related tasks or cross-functional responsibilities as assigned by management, aligned with business and client goals.
Ideal Candidate
- MS SQL Server & Oracle Database Administration (cloud/on-premises).
- Performance Tuning & Optimization (queries, indexing, execution plans).
- Backup, Recovery & Disaster Recovery (DR) Planning.
- Database Security & Access Control (least privilege, need-to-know).
- CI/CD & DevOps Integration for Database Deployments.
- Database Upgrades, Patch Management & Maintenance.
- Strong Documentation & Compliance Practices.
Skills : data,database (ref:hirist.tech)
