Jobs

Scholarships

Courses

Companies

Placements

Community

Home >

Jobs >

Job Opportunity : Cloud Database Engineer I

Haryana, India (Hybrid)

Job Opportunity : Cloud Database Engineer I

1 Month ago • All levels • Administrative • Undisclosed

About the job

8 skills required for this role

Add these skills to join the top 1% applicants for this job

microsoft-azure

azure

aws

data-structures

python

sql

powershell

organisational-skills

Job Description

This Cloud Database Engineer I role requires in-depth knowledge of RDBMS components, database architecture, and various database flavors (relational and non-relational). Responsibilities include writing and optimizing SQL queries, understanding query execution plans, performance tuning, database backup and recovery, security management, and troubleshooting. Experience with cloud platforms (AWS, Azure, GCP) and scripting languages (T-SQL, PL/SQL, PowerShell, Python) is essential. The position involves database upgrades, migrations to cloud platforms, and familiarity with HA/DR concepts. Strong problem-solving, communication, and organizational skills are crucial.

Must have:

In-depth understanding of RDBMS
Proficiency in SQL query optimization
Cloud platform expertise (AWS, Azure, GCP)
Experience with database backup/recovery
Knowledge of database security
Troubleshooting skills

Good to have:

Experience with scripting languages (PowerShell, Python)
Understanding of HA/DR concepts
Database migration experience
Familiarity with monitoring tools

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.

undefinedundefinedundefined

View Full Job Description