Specialist - System Management
Vivantify Technology Solutions India Pvt. Ltd.
Experience: 5–7 Years
About The Role
We are seeking an experienced Microsoft SQL Server DBA to manage the installation, configuration, performance, security, availability, and maintenance of SQL Server environments. The role includes supporting Amazon RDS, database migrations, high availability, backup and recovery, and production troubleshooting for mission-critical applications.
Job Description
The role involves administering Microsoft SQL Server across production and non-production environments, including installation, configuration, upgrades, performance monitoring, query optimization, and routine database maintenance. The DBA will work with Amazon RDS and support cloud database administration and monitoring.
The position requires implementing backup, restore, and disaster recovery strategies, configuring SQL Server Always On Availability Groups, and supporting database replication and clustering. The candidate will also perform migrations from on-premises SQL Server environments to Amazon RDS.
The DBA will manage database security, troubleshoot performance bottlenecks, maintain data integrity and compliance, automate administrative activities, and collaborate with development teams on database design and performance improvements. The role also includes production incident support and maintaining technical documentation.
Key Responsibilities
- Administer and maintain Microsoft SQL Server databases across production and non-production environments.
- Support and manage cloud databases on Amazon RDS.
- Install, configure, upgrade, and migrate SQL Server instances.
- Monitor database performance and optimize queries using Transact-SQL (T-SQL).
- Implement backup, restore, disaster recovery, and high-availability strategies.
- Configure and maintain SQL Server Always On Availability Groups, replication, and clustering where required.
- Manage database security, including logins, roles, and permissions.
- Troubleshoot production issues, automate administrative tasks, and maintain database documentation.
- Microsoft SQL Server DBA
- SQL Server installation, configuration, upgrades, and maintenance
- Amazon RDS
- T-SQL and query performance optimization
- Database backup, restore, and disaster recovery
- SQL Server Always On Availability Groups
- Database migration from on-premises to Amazon RDS
- Database security, logins, roles, and permissions
- Replication and clustering
- Index and statistics maintenance
- Database monitoring and performance troubleshooting
- Database deployments and production support
- Bash / Shell scripting
- Ubuntu Linux Administration
- Oracle Linux Administration
- Red Hat Linux Administration
The ideal candidate will have 5–7 years of database administration experience, with strong hands-on expertise in Microsoft SQL Server, Amazon RDS, performance tuning, backup and recovery, and high-availability solutions. The candidate should be comfortable supporting production environments, resolving critical database issues, and collaborating with development and infrastructure teams.
Benefits Package
- Competitive salary and benefits package
- Opportunities for professional growth and development
- A collaborative and inclusive work environment
- The opportunity to work on exciting and challenging projects with leading clients