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/My SQL/Postgre SQL), 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, Dev Ops, 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 No SQL / Big Data systems (Cosmos DB, Mongo DB, 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.