Senior Database Administrator

Job Title: Senior Database Administrator (DBA)Location: NoidaExperience: 4-5 YearsRole OverviewWe are seeking a skilled Senior Database Architect & DBA with 4–5 years of experience indesigning, implementing, and administering enterprise-grade SQL databases. The roleblends strategic database architecture with day-to-day database administration, ensuringoptimal performance, security, and availability of mission-critical systems. The ideal candidatewill be hands-on with SQL Server (and preferably Oracle/MySQL/PostgreSQL), and experiencedin high availability (HA), disaster recovery (DR), automation, and enterprise-scale datamanagement.Key ResponsibilitiesDatabase 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 databaselandscape.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 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.