Job Title : Senior Database Administrator (DBA)
Location : Noida
Experience : 4-5 Years
Role Overview
We are seeking a skilled Senior Database Architect & DBA with 4–5 years of experience in
designing, implementing, and administering enterprise-grade SQL databases. The role
blends strategic database architecture with day-to-day database administration, ensuring
optimal performance, security, and availability of mission-critical systems. The ideal candidate
will be hands-on with SQL Server (and preferably Oracle / MySQL / PostgreSQL), and experienced
in high availability (HA), disaster recovery (DR), automation, and enterprise-scale data
management.
Key Responsibilities
Database Architecture & Design
- Design scalable and secure database architectures for enterprise workloads.
- Develop conceptual, logical, and physical data models aligned with business needs.
- Collaborate with developers and solution architects to optimize schema and queries.
- Evaluate emerging technologies and recommend improvements for the database
landscape.
Database Administration (Routine & Advanced)
Install, configure, and maintain SQL Server instances (on-premises and cloud).Perform routine DBA tasks including :o Daily monitoring of database health, logs, and performance dashboards.
o Regular database backups, restores, and integrity checks.
o User account provisioning and role-based access control (RBAC).
o Managing storage allocation, index maintenance, and statistics updates.
o Scheduling and monitoring SQL Server Agent jobs.
o Applying patches, service packs, and upgrades.
o Troubleshooting and resolving blocking, deadlocks, and failed jobs.
Ensure high availability through clustering, Always On Availability Groups,replication, and log shipping.
Implement disaster recovery strategies and perform regular DR drills.Security & ComplianceImplement data encryption, auditing, and access controls.Monitor for security vulnerabilities and apply fixes proactively.Ensure compliance with organizational and industry standards (ISO 27001, GDPR,HIPAA, etc.).
Performance Monitoring & Optimization
Use tools like SQL Profiler, Extended Events, DMV queries, and Query Store.Tune queries, indexes, and stored procedures for optimal performance.Conduct capacity planning and performance forecasting.Collaboration & Leadership
Work closely with development, DevOps, and infrastructure teams to integratedatabases into CI / CD pipelines.
Provide mentorship and knowledge transfer to junior DBAs and developers.Act as a Subject Matter Expert (SME) in database technologies during solution designand reviews.
Required Skills & Competencies
4–5 years of proven experience as a Database Architect / DBA in enterpriseenvironments.
Expertise in Microsoft SQL Server (2016 / 2019 / 2022) administration and architecture.Hands-on experience in backup / recovery, performance tuning, and HA / DRsolutions.
Strong T-SQL skills (queries, stored procedures, triggers, functions).Knowledge of cloud databases (Azure SQL, AWS RDS, Azure Managed Instance).Familiarity with ETL pipelines (SSIS / ADF), BI tools (SSRS / Power BI) is a plus.Exposure to NoSQL / Big Data systems (Cosmos DB, MongoDB, Hadoop) desirable.Soft Skills
Strong analytical and problem-solving skills.Excellent communication and documentation skills.Ability to work in cross-functional teams and handle multiple priorities.Proactive, detail-oriented, and customer-focused mindset.Education & Certifications (Preferred)Bachelor’s or Master’s in Computer Science, IT, or related field.Microsoft Certified : Azure Database Administrator Associate or SQL Server DatabaseAdministration.
Certifications in Performance Tuning, Security, or Cloud Databases areadvantageous.