Database Administrator

**About Us**:
Kran Consulting Pvt Ltd, with Headquarters in Thiruvananthapuram, Kerala, is an innovative IT consulting company with almost 3 decades of industry presence with a primary focus on Public Administration. We have established ourselves as an organization delivering mission critical projects to Government Clients across the country. We confirm to Global Quality Standards including CMMI DEV/5, ISO 9001:2013, ISO 20000 and ISO 27001. Currently we are working on Government Projects in multiple states in the Country.

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

**Database Deployment & Integration**
- Coordinate the deployment of database updates, patches, and schema changes with mínimal operational impact.
- 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**
- Ensure databases are structured to support reporting, analytics, and business intelligence tools.
- Assist in designing and maintaining data models that reflect evolving business processes.

**Skills 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.

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