Database Administrator - PostgreSQL/MariaDB/MongoDB

Qualification :

- B. / B. Tech in any specialization or MCA.

- DBA certification or related certifications is preferable.

Skills/Requirements :

- Skilled in working with relational databases such as PostGres, MariaDB and nonrelational databases like MongoDB.

- 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 :

- Contribute to the design and implementation of scalable and secure database solutions that align with organizational needs.

- 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 :

- Manage and maintain operational health of production and non-production databases, ensuring optimal uptime and performance.

- 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 :

- Ensure database security through role-based access control, encryption, and secure configurations.

- 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 :

- Analyze database workloads to identify and address performance bottlenecks.

- 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 :

- Coordinate the deployment of database updates, patches, and schema changes with minimal operational impact.

- 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 :

- Implement and manage monitoring tools to track database performance, uptime, and resource utilization.

- 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 :

- Maintain accurate documentation for database configurations, maintenance procedures, and incident resolutions.

- 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 :

- Work closely with business and application teams to understand data requirements and support solution development.

- 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 :

- B. / B. Tech in any specialization or MCA.

- 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