Database Administrator - PostgreSQL MariaDB MongoDB

Qualification :

• B. / B. Tech in any specialization or MCA.
• DBA certification or related certifications is :
• 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
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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.
  
  

• 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