Database Administrator - MariaDB/PostgreSQL

Description :

Qualification :

- DBA certification or related certifications is preferable.

Skills/Requirements :

- Expertise in database design, normalization, and optimization.

- Knowledge of SQL and query optimization.

- Familiarity with backup and recovery procedures.

- Understanding of high availability and disaster recovery solutions.

- Experience with database security and access control.

- Proven track record of managing and maintaining large- scale databases.

- Experience with both on-premises and cloud-based database environments.

- Strong analytical and problem-solving skills related to database performance and scalability

- Installed, configured, and maintained database systems based on organizational needs.

- Implemented and optimized database parameters to ensure optimal performance

- Conducted performance tuning and optimization of queries and database structures.

- Monitored and analyzed system performance, making recommendations for improvements

- Designed and implemented backup and recovery strategies to ensure data integrity and availability.

- Conducted regular testing of backup and recovery procedures

- Provided timely and effective support for database- related issues.

- Conducted root cause analysis for incidents and implemented preventive measures.

- Maintained comprehensive documentation of database configurations, procedures, and best practices

Responsibilities :

Database Strategy & Architecture :

- Work collaboratively with IT and development teams to support the development of reliable and efficient database architectures.

- Apply database design best practices and assist in enforcing standards across development and production environments.

- Support the evaluation and adoption of new database tools, technologies, and frameworks under the guidance of technical leads.

Database Administration & Maintenance :

- Perform routine database maintenance tasks such as backups, indexing, archiving, and patching.

- Implement and regularly test disaster recovery plans, ensuring data availability and integrity.

- Monitor system logs, resolve issues related to slow queries, deadlocks, or storage bottlenecks, and escalate where needed.

Security & Compliance :

- Monitor for unauthorized access or unusual activity, working with the security team to respond to threats.

- Support compliance initiatives by ensuring databases adhere to relevant regulatory standards (e.g., GDPR, HIPAA, or local data laws).

- Maintain and implement database security policies and assist in audits and reviews as required.

Performance Tuning & Optimization :

- Optimize SQL queries, indexes, and execution plans for better efficiency.

- Participate in capacity planning and help forecast database scaling needs.

- Collaborate with developers to review and optimize database schemas and application queries.

Database Deployment & Integration :

- Support database migration and integration efforts across systems and applications.

- Assist with cloud platform integrations and ensure database components interact smoothly with analytics tools and data pipelines.

Database Monitoring & Reporting :

- Generate routine health check reports and highlight areas for improvement.

- Provide input into database performance dashboards and reporting tools used by the IT or DevOps teams.

Documentation & Best Practices :

- Follow and contribute to database management policies and operational standards.

- Keep troubleshooting guides and knowledge base entries up to date for use by the IT support team.

Collaboration with Business Teams :

- Ensure databases are structured to support reporting, analytics, and business intelligence tools.

- Assist in designing and maintaining data models that reflect evolving business processes.

Qualification :

- DBA certification or related certifications is preferable.

- Overall Experience in design, implementation and management of database systems.

- 7 or more years of experience in large and complex IT systems development and implementation projects.

- Experienced in Database Management.

- Fluency in English and Hindi (Speaking, reading & writing).

- Fluency in Assamese preferable