Key Responsibilities
- Install, configure, upgrade, and maintain Microsoft SQL Server (On Prem & Azure) THROUGH Azure Pipelines (Azure Devops and Octopus Deploy).
- Automate backup, restore, disaster recovery, and high availability (Always On, Failover Groups, Log Shipping).
- Monitor database health, capacity, and performance.
- Identify and resolve performance bottlenecks using execution plans, indexing strategies, and query tuning.
- Optimize database schemas, stored procedures, and SQL queries.
- Implement proactive monitoring and alerting.
- Manage databases using Azure Portal, Azure Monitor, Log Analytics, and Azure Advisor.
- Ensure security best practices using Azure AD authentication, TDE, Key Vault, and firewall rules.
- Support scalability, cost optimization, and resource governance in Azure.
- Design and maintain CI/CD pipelines for database deployments using:
- Automate schema changes, version control, and deployment approvals.
- Work closely with development teams to enable Database DevOps (DBOps).
- Implement Automatic rollback, validation, and release strategies for database changes.
- Manage user access, roles, and permissions.
- Implement auditing, encryption, and compliance standards.
- Support vulnerability assessments and security reviews.
- Partner with application, infrastructure, and DevOps teams.
- Provide L3 support for production issues and root cause analysis.
- Create and maintain documentation, runbooks, and SOPs.
Required Skills:
- Strong experience with Microsoft SQL Server (2016+)
- Hands on experience with Azure SQL services
- Strong knowledge of T SQL, Backup & Recovery, HA/DR solutions ( Always On Availability Groups, Log Shipping), Indexing & performance tuning
- Strong experience with CI/CD tools (Azure DevOp and Octopus Deploy)
- Scripting skills: PowerShell and T-SQL
- Experience with version control systems (Git)
- Azure Skills including Azure SQL Database / Managed Instance, Azure Monitor & Log Analytics, Azure Key Vault & Security features, ARM/Bicep or Terraform
- Knowledge of Infrastructure as Code
- Exposure to Agile/Scrum environments.
About Us:
Stratacent is an IT Managed Services firm, headquartered in Jersey City, NJ, with two global delivery centres in New York City area and New Delhi area plus offices in London, Canada and Pune, India.
We are a leading IT services provider focusing in Financial Services, Insurance, Healthcare and Life Sciences. We help our customers in their digital transformation journey and provide solutions around cloud infrastructure, containers, AI, Client & Analytics and Automation.
We have partnerships with SAS, Automation Anywhere, Snowflake, Azure, AWS and GCP.
(To learn more: www.stratacent.com ).
Stratacent is an equal opportunity employer. As such, to the extent defined by federal, state, and municipal law, Stratacent will not discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, age, sex, national origin, ancestry, handicap, or any other factor protected by law.
