Senior Database Architect

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.