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 Post Gres, 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…