Upload Button Icon Add office photos
filter salaries All Filters

49 CareerFit.ai Jobs

Database Administrator (6-8 yrs)

6-8 years

Database Administrator (6-8 yrs)

CareerFit.ai

posted 19hr ago

Job Description

A leading IT company is looking for Database Administrator/ Designer for Gurugram (Haryana ) Location.

Candidates from Gurugram or Delhi / New Delhi ( nearby location only need to apply).

JD for DBA Administrator/ Designer.

Max Budget : 20 LPA.

location : Gurugram.

Minimum exp : 6+ years ( 6 year-15 years).

Position Overview :


The Database Designer/Administrator is responsible for designing, managing, optimizing, and securing databases to ensure high availability, performance, and compliance for TnD Project applications.

This role focuses on operational database management, data modeling, automation, backup strategies, query optimization, and system observability while working closely with Database Architects, DevOps Teams, and Security Engineers.

Primary Responsibilities :

- Design and manage logical and physical data models using Erwin Data Modeler to ensure scalable and optimized database structures.

- Ensure high availability (HA) and disaster recovery (DR) strategies for mission-critical databases.

- Monitor and optimize database performance, indexing, and query execution using advanced analytics tools.

- Automate database provisioning, patching, and maintenance workflows using Infrastructure as Code (IaC).

- Ensure security best practices and compliance with SOC2, GDPR, and internal IT audit policies.

Execution :

Database Design & Data Modeling :

- Design and manage logical and physical data models using Erwin Data Modeler.

- Work closely with Database Architects to implement changes in schema design.

- Define data relationships, indexing strategies, and normalization/denormalization approaches.

Database Performance & Query Optimization :

- Tune SQL queries, indexing strategies, and memory management for optimal performance.

- Use pg_stat_statements, AWS Performance Insights, and Query Execution Plans for proactive analysis.

- Conduct slow query analysis and optimization to enhance system responsiveness.

High Availability & Disaster Recovery (HA/DR) :

- Implement AWS Aurora Multi-AZ, Oracle DB high availability strategies, read replicas, and automated failover.

- Define Recovery Time Objective (RTO) and Recovery Point Objective (RPO) for database resilience.

- Automate backup retention, point-in-time recovery, and data restoration processes.

Security & Compliance :

- Implement IAM-based access control, role-based privileges, and fine-grained security policies.

- Ensure encryption-at-rest and encryption-in-transit for all database connections.

- Maintain audit logs, API endpoint security (AWS RDS Proxy), and regular security patching.

Database Automation & Observability :

- Automate database provisioning and schema management using Liquibase or Flyway.

- Integrate real-time monitoring with AWS CloudWatch, Prometheus, and Grafana dashboards.

- Enable AI-driven query performance analysis and anomaly detection for proactive issue resolution.

DataOps & Schema Versioning :

- Implement version-controlled schema changes to ensure consistency across environments.

- Work with DevOps teams to integrate database changes into CI/CD pipelines.

- Maintain detailed documentation of schema modifications, stored procedures, and access controls.

Cost Optimization & Resource Scaling :

- Analyze AWS RDS/Aurora and Oracle DB cost trends and optimize instance sizing based on usage.

- Implement serverless database scaling strategies for dynamic workload demands.

- Conduct performance benchmarking to balance cost efficiency and query execution speed.

Technology Exposure Required :


Database Technologies : AWS Aurora (PostgreSQL), Oracle DB, Redis, DynamoDB (Optional).

Data Modeling & Schema Documentation : Erwin Data Modeler, Lucidchart, or equivalent tools.

Query Performance Monitoring : pg_stat_statements, AWS Performance Insights, Query Execution Plans.

Backup & HA Strategies : AWS Multi-AZ, Oracle Data Guard, Read Replicas, PITR, Failover Automation.

Security & Compliance : IAM, RDS Proxy, Role-Based Access Control (RBAC), GDPR, SOC2.

Automation & IaC : Terraform, Liquibase, Flyway, AWS CloudFormation.

Monitoring & Cost Optimization : AWS CloudWatch, Prometheus, Grafana, Cost Explorer.

Team Collaboration :


- Work closely with Database Architects and DevOps Engineers to implement scalable database solutions.

- Support Developers in writing efficient SQL queries and managing schema changes.

- Collaborate with Security Teams to ensure compliance with regulatory and IT policies.

Key Result Areas :


- Optimized database performance and reliability for all TnD applications.

- Secure and compliant data management strategies, aligned with industry standards.

- Automated database maintenance workflows, reducing manual intervention.

- Proactive monitoring and cost optimization, ensuring efficient resource utilization.


Functional Areas: Software/Testing/Networking

Read full job description

Prepare for Database Admin roles with real interview advice

Compare CareerFit.ai with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

HDFC Bank

3.9
Compare

Infosys

3.6
Compare

ICICI Bank

4.0
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare

Genpact

3.8
Compare

Teleperformance

3.9
Compare

Concentrix Corporation

3.8
Compare

Axis Bank

3.8
Compare

Amazon

4.1
Compare

Jio

3.9
Compare

iEnergizer

4.6
Compare

Reliance Retail

3.9
Compare

IBM

4.0
Compare

LTIMindtree

3.8
Compare

Similar Jobs for you

Database Admin at Nowwin International Pvt Ltd

5-8 Yrs

₹ 12-25 LPA

Database Admin at CarWale

4-8 Yrs

₹ 12-24 LPA

Database Admin at Catalyst IQ

3-6 Yrs

₹ 12-18 LPA

Database Admin at Risk Resources

3-8 Yrs

₹ 10-24 LPA

Database Admin at Deltaclass Technology Solutions Pvt. Ltd.

4-6 Yrs

₹ 12-20 LPA

Database Admin at Explorance

6-8 Yrs

₹ 15-25 LPA

Database Admin at Zifcare

4-6 Yrs

₹ 12-18 LPA

Database Admin at PayTabs

3-6 Yrs

₹ 12-19 LPA

Database Admin at One Degree North HR Services

3-8 Yrs

₹ 12-20 LPA

Database Admin at Servion

6-14 Yrs

₹ 18-38 LPA

Database Administrator (6-8 yrs)

6-8 Yrs

19hr ago·via hirist.com

SQL Server Developer (8-10 yrs)

8-10 Yrs

19hr ago·via hirist.com

Frontend Developer - React.js/AngularJS (10-13 yrs)

10-13 Yrs

19hr ago·via hirist.com

UI/UX Designer - B2B SaaS Domain (8-10 yrs)

8-10 Yrs

19hr ago·via hirist.com

Java Developer - Spring/Hibernate (5-9 yrs)

5-9 Yrs

19hr ago·via hirist.com

AI Engineer - NLP/LLM (3-5 yrs)

3-5 Yrs

19hr ago·via hirist.com

Product Owner (15-18 yrs)

15-18 Yrs

2d ago·via hirist.com

Recently Viewed

COMPANY BENEFITS

ICICI Bank

Kakinada

6 benefits

COMPANY BENEFITS

ICICI Bank

Junagadh

1 benefit

JOBS

Innovacx Tech Labs

No Jobs

COMPANY BENEFITS

Tech Mahindra

No Benefits

JOBS

Trigent Software

No Jobs

JOBS

Strategic Skill Tech

No Jobs

JOBS

Strategic Skill Tech

No Jobs

REVIEWS

Tech Mahindra

No Reviews

JOBS

Dealsdray Online

No Jobs

JOBS

Tanla Platforms

No Jobs

write
Share an Interview
How was your last interview experience?
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent