Database Administrator (6-8 yrs)
CareerFit.ai
posted 19hr ago
Key skills for the job
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 descriptionPrepare for Database Admin roles with real interview advice