Senior Database Administrator

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 & Compliance

• Implement 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 integrate

databases 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 design

and reviews.

Required Skills & Competencies

• 4–5 years of proven experience as a Database Architect / DBA in enterprise

environments.

• Expertise in Microsoft SQL Server (2016/2019/2022) administration and architecture.

• Hands-on experience in backup/recovery, performance tuning, and HA/DR

solutions.

• 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 Database

Administration.

• Certifications in Performance Tuning, Security, or Cloud Databases are

advantageous.