Database Administrator

The Database Administrator is responsible for the design, implementation, maintenance, and performance tuning of critical database systems to ensure high availability, security, and optimal performance. The Database Administrator will work closely with application teams, system administrators, and project stakeholders to ensure that database systems are robust, scalable, and aligned with organizational goals, while also managing data integrity, access controls, and compliance with relevant policies and standards.

• No of Vacancies: 2
• Experience: 7+ years
• Qualification: B.E./ B. Tech in any specialization or MCA.
• DBA certification or related certifications is preferable.
• Location: Guwahati, Assam.

Qualification:

• B.E./ 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 preferrable.
• 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.

Skills:

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