11 Nov
|
Volto Consulting
|
Noida
11 Nov
Volto Consulting
Noida
Position: SQL Database Administrator (SQL DBA)
Experience: 3+ Years
Location: Noida
Work Mode: 5 Days Work from Office
Shift: US Pacific Time Zone Alignment (Mandatory)
Interview Process: Face-to-Face (Mandatory)
Cab Facility: Not Provided
Shift Allowance: Not Provided
About the Role
We are looking for a skilled SQL Database Administrator (SQL DBA) with 3+ years of experience in managing, maintaining, and optimizing Microsoft SQL Server environments. The ideal candidate will be responsible for ensuring database availability, performance, security, backup and recovery, and overall database health while supporting critical business applications.
Key Responsibilities
Install, configure, administer, and maintain Microsoft SQL Server databases across development, testing, and production environments.
Monitor database performance, identify bottlenecks, and implement tuning recommendations for optimal efficiency.
Manage database backups, restores, disaster recovery planning, and high-availability solutions.
Perform database capacity planning and storage management to support business growth.
Create and maintain database objects including tables, views, indexes, stored procedures, functions, and triggers.
Monitor SQL Server health using native and third-party monitoring tools.
Troubleshoot database issues related to performance, locking, blocking, deadlocks, and query optimization.
Implement and maintain database security, user access control, authentication, and authorization policies.
Support database migrations, upgrades, patching, and version management activities.
Collaborate with application development teams to optimize queries and improve database design.
Ensure database compliance with organizational security standards and best practices.
Develop and maintain operational documentation, runbooks, and standard operating procedures.
Participate in incident response and provide timely resolution of database-related issues.
Support business continuity initiatives through regular testing of backup and recovery processes.
Required Technical Skills
Database Administration
Strong hands-on experience with Microsoft SQL Server 2016/2019/2022
Expertise in SQL Server installation, configuration, and administration
Database backup, restore, recovery, and maintenance strategies
Experience with SQL Server Agent Jobs and Maintenance Plans
Performance Tuning & Optimization
Query optimization and execution plan analysis
Index management and performance tuning
Troubleshooting blocking, locking, deadlocks, and resource contention
Experience with Performance Monitor, SQL Profiler, and Extended Events
High Availability & Disaster Recovery
SQL Server Always On Availability Groups
Database Mirroring, Replication, and Log Shipping
Disaster Recovery planning and testing
Recovery Point Objective (RPO) and Recovery Time Objective (RTO) understanding
Database Security
User and role management
Encryption, Transparent Data Encryption (TDE)
Auditing and compliance implementation
Database security best practices and access controls
Scripting & Automation
Solid proficiency in T-SQL
PowerShell scripting exposure preferred
Automation of routine DBA activities
Monitoring & Troubleshooting
Experience with SQL Server monitoring tools
Root cause analysis and issue resolution
Capacity planning and database health checks
Preferred Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related discipline.
Microsoft SQL Server certifications are preferred.
Experience supporting mission-critical production environments.
Exposure to cloud database platforms such as Azure SQL Database or Azure Managed Instance is an added advantage.
Knowledge of database security, compliance, and auditing standards.
📌 SQL Database Administrator (Noida)
🏢 Volto Consulting
📍 Noida