Database Expert

Job Summary

The Database Expert will be responsible for database administration, maintenance, performance optimization, data integrity, backup and recovery, security, and troubleshooting. The role will ensure reliable data storage, high availability, and seamless data integration across Smart City applications and Integrated Command and Control Centre (ICCC) systems.

Key Responsibilities

• Perform database installation, configuration, administration, and maintenance.
• Monitor database performance and optimize queries, indexes, and database configurations to improve efficiency.
• Ensure data integrity, consistency, availability, and reliability across databases.
• Manage database backup, restoration, and recovery procedures to minimize data loss and downtime.
• Implement database security measures, including user access management, authentication, authorization, and access controls.
• Monitor database health, identify performance bottlenecks, and troubleshoot database-related issues.
• Support database replication, high availability, and disaster recovery mechanisms.
• Maintain database documentation, operational procedures, and configuration records.
• Coordinate with application, infrastructure, and technical teams to resolve database issues and support application integration.
• Support reliable data storage and seamless integration across Smart City applications and ICCC systems.
• Perform routine database maintenance, capacity planning, and preventive health checks.

Mandatory Skills

• Strong knowledge of database administration and maintenance.
• Hands-on experience with SQL and relational database management systems (RDBMS).
• Experience in database performance monitoring and optimization.
• Knowledge of database backup, restoration, and recovery procedures.
• Understanding of data integrity, database security, and access management.
• Troubleshooting skills for database performance and availability issues.

Educational Qualifications

• Bachelor's Degree in Engineering, Computer Science, Information Technology (IT), or Electronics and Communication Engineering (ECE).

Experience

• Minimum 6 years of relevant professional experience in database administration and management.

Certifications

• Relevant certifications in Database Administration, such as Microsoft Certified Solutions Associate (MCSA) in SQL Server or equivalent database certifications.

Domain

Smart City / ICCC (Integrated Command and Control Centre)

Preferred Experience

• Experience supporting Smart City projects, Integrated Command and Control Centre (ICCC) systems, or other large-scale application environments.
• Familiarity with database availability, replication, and disaster recovery.
• Experience coordinating with application development, infrastructure, and operations teams.

Key Competencies

• Analytical and problem-solving skills.
• Strong troubleshooting and incident-resolution capabilities.
• Attention to data accuracy, security, and system reliability.
• Ability to collaborate with cross-functional technical teams.