Job Description
Database Technology:
In-depth understanding of RDBMS components and Knowledge of database architecture, including storage structures, indexing, query processing, and transaction management.
Knowledge on different databases flavors like relations and non-relational like document DB/Graph databases/Key-value pair databases.
· Performance Monitoring and Query Optimization:
Proficiency in writing and optimizing SQL queries and stored procedures.
Understanding of query execution plans and query tuning techniques.
Understanding of performance tuning methodologies, indexing strategies, and statistics management.
Understanding of monitoring tools and techniques for identifying and addressing performance issues.
Cloud Platform:
In-depth understanding of public cloud platforms and databases available on Public Cloud.
Knowledge of Cloud Databases on PAAS and IAAS platforms.
Knowledge on Cloud Migrations.
PowerShell. Python and SQL:
Familiarity with scripting languages such as T-SQL, PLSQL, PowerShell, or Python for automation and task scheduling.
Backup and Recovery:
Proficiency in database backup and recovery concepts, including full, differential, and transaction log backups.
Security Management:
Familiarity with managing user access, permissions, roles, and auditing to secure the database environment.
Knowledge of database security concepts, access controls, and encryption.
Performance Monitoring and Tuning:
Basic understanding of monitoring tools and techniques for identifying and addressing performance issues.
Troubleshooting Skills:
Ability to diagnose and troubleshoot common database-related problems such as connectivity issues, query performance, performance bottlenecks and data corruption.
HA&DR:
Familiarity with High Availability and Disaster Recovery concepts and understanding the significance of RTO and RPO.
Database Upgrades and Migrations:
Understand the process of upgrading Database Server to newer versions and migrating databases to new servers and Migrating databases to Cloud platforms.
Skills
· Technical Skills: Understanding of database management systems, SQL, and programming languages. Familiarity with operating systems, network infrastructure, and cloud-based database platforms.
· Problem-Solving Skills: Troubleshooting and resolving database issues.
· Communication Skills: Effective communication with team members and non-technical stakeholders.
· Organizational Skills: Managing multiple tasks and projects simultaneously.
· Attention to Detail: Exceptional attention to detail due to serious consequences of database mistakes.
· Continuous Learning: Proactively staying updated with new technologies and best practices.
· Experience with cloud services (AWS, Microsoft Azure, GCP)
· Excellent Skills of data backup, recovery, security, integrity and SQL
· Skills in database installation, configuration, and maintenance.
· Proven working experience as a Database Administration
Skill in creating and maintaining technical documentation for database configurations, procedures, and operational practices.