DBA & DevOps Engineer
ob Title: DBA & DevOps Engineer
Location: Gurgaon, India
Employment Type: Full-time, Onsite
Job Description:
We are looking for a Database & DevOps Engineer to join our team in Gurgaon. The ideal candidate will have strong experience in SQL Server database management along with a good understanding of DevOps practices, especially in Azure environments. This role is ideal for someone who can manage and optimize SQL databases, develop automation scripts, and ensure smooth cloud operations.
Key Responsibilities:
SQL Server Management:
Administer, maintain, and optimize SQL Server databases.
Monitor database performance, implement changes, and apply new patches and versions when required.
Create and maintain comprehensive documentation, including ERDs, database schemas, and process flows.
Database Design and Implementation:
Collaborate with software developers, system architects, and other stakeholders to design and implement efficient and scalable database solutions.
Evaluate database requirements and recommend appropriate database platforms, technologies, and architectures.
Design and implement database schemas, tables, indexes, and views to support application requirements.
Database Management:
Install, configure, and upgrade database software and related tools.
Monitor database performance and resource utilization to ensure optimal performance and scalability.
Implement backup and recovery strategies to safeguard data and minimize downtime.
Manage database security, including user access controls, authentication, and data encryption.
DevOps in Azure:
Manage Azure services and implement automation processes for deployment, monitoring, and management of cloud resources.
Set up and maintain CI/CD pipelines in Azure DevOps.
Implement and manage Azure infrastructure using Infrastructure-as-Code (IaC) tools like ARM Templates, Terraform, or Bicep.
Ensure high availability and security of cloud services.
Database DevOps:
Automate database deployment and testing using SQL change automation tools and DevOps pipelines.
Manage database backup and recovery strategies, and implement disaster recovery solutions.
Collaborate with development and infrastructure teams to design and implement scalable database and cloud solutions.
Required Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or related field.
3+ years of experience in SQL Server management.
2+ years of experience in DevOps practices, particularly with Azure services.
Strong knowledge of CI/CD pipelines, containerization, and orchestration (Docker, Kubernetes).
Proficiency with scripting languages (PowerShell, Python) and automation tools.
Experience with performance tuning, query optimization, and monitoring tools.
Preferred Qualifications:
Bachelor’s degree in computer science, Information Technology, or a related field.
Certifications in Azure (e.g., Microsoft Certified: Azure Administrator, Azure DevOps Engineer).
Experience with Microsoft SQL Server on Azure and NoSQL databases like MongoDB or Cosmos DB.
Familiarity with cloud cost optimization strategies.
Experience with database performance tuning, optimization, and troubleshooting.
Familiarity with database security best practices and regulatory compliance requirements (e.g., GDPR, HIPAA).
Soft Skills:
Strong problem-solving and analytical skills.
Excellent communication and collaboration abilities.
Ability to work in a dynamic and fast-paced environment.