Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in india
>
Ironbook AI
>
Database Consultant

Database Consultant

Ironbook AI

5 - 7 years

0 Lacs

india

Posted:1 day ago| Platform:

Apply

Skills Required

database relational security scalability data design model logical etl sql code logic migration synchronization integration metrics query tuning indexing strategies configuration replication backup dynamodb azure networking controls iam network refactoring consulting development documentation training developer server postgresql mysql writing monitoring automation datadog troubleshooting nosql mongodb containerization docker kubernetes certifications aws redshift

Work Mode

On-site

Job Type

Full Time

Job Description

Database Consultant

🔑 Key Responsibilities

Database Design and Development

Design and model highly performant, scalable, and secure database schemas (conceptual, logical, and physical) for new and existing applications.
Develop, optimize, and maintain complex stored procedures, functions, triggers, and ETL processes using SQL and T-SQL/PL/SQL.
Conduct thorough code reviews for database scripts and stored logic to enforce best practices and ensure optimal performance.
Manage data migration, data synchronization, and database integration projects.

Performance and Optimization

Proactively monitor database performance metrics, identifying bottlenecks and areas for improvement.
Perform advanced query tuning, indexing strategies, and physical database configuration adjustments.
Manage and troubleshoot high availability and disaster recovery solutions (e.g., Replication, Always On Availability Groups, backup/restore).

Cloud Database Implementation

Consult on and implement database solutions in cloud environments, leveraging services such as
Amazon RDS, Aurora, DynamoDB, Azure SQL Database, and Azure Cosmos DB.
Design and deploy cloud database security policies, networking, and access controls (e.g., IAM roles, security groups, Azure Network Security Groups).
Assist in evaluating and migrating on-premises databases to the cloud (lift-and-shift and refactoring approaches).

Consulting and Documentation

Act as a Subject Matter Expert (SME) to development teams, providing guidance on database best practices and architectural decisions.
Create and maintain comprehensive documentation, including design specifications, operation runbooks, and disaster recovery plans.
Conduct knowledge transfer sessions and training for internal teams on new database technologies and cloud services.

📚 Required Skills and Experience

Experience:
5-7 years in a Database Administrator (DBA), Database Developer, or Database Consultant role. Immediate joiners preferred and open to move overseas for project.
Core Databases:
Expert-level proficiency in at least one major relational database system (
Microsoft SQL Server, PostgreSQL, MySQL, or Oracle
).
Cloud Platforms (Mandatory Exposure):
Proven experience implementing and managing database solutions in
AWS
(e.g., RDS, EC2 with database) and
Azure
(e.g., Azure SQL, Managed Instance).
SQL Mastery:
Expert proficiency in writing and optimizing complex SQL queries, views, stored procedures, and understanding execution plans.
Database Tools:
Experience with database monitoring, backup, and automation tools (e.g., Redgate, DataDog, native cloud tools).
Problem-Solving:
Strong analytical and troubleshooting skills, particularly in high-pressure production environments.

➕ Preferred Qualifications

Experience with NoSQL databases (e.g., MongoDB, Cassandra, Redis).
Familiarity with containerization technologies (Docker, Kubernetes) and their impact on database deployment.
Relevant professional certifications (e.g., AWS Certified Database - Specialty, Microsoft Certified: Azure Database Administrator Associate).
Experience with Data Warehousing and BI concepts (e.g., AWS Redshift, Azure Synapse Analytics).

More Jobs at Ironbook AI

Senior Database Developer

Delhi, India

7.0 - 7.0 yrs

Salary: Not disclosed

AI Lead – Model Fine-Tuning & Federated Learning

india

6.0 - 6.0 yrs

Salary: Not disclosed

Data Scientist

india

3.0 - 5.0 yrs

Salary: Not disclosed

Database Developer

india

7.0 - 7.0 yrs

Salary: Not disclosed

Presales Solutions Architect

india

5.0 - 5.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.