SQL Server Dba

**Location**:Pune, India

**Team**:Engineering Services

**Work Type**:Full Time
- Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto “
- _Building Success Together®_,” Nisum has grown to over 1,800 professionals across the United States, Chile,Colombia, India, Pakistan and Canada. A preferred advisor to leading Fortune 500 brands, Nisum enables clients to achieve direct business growth by building the advanced technology they need to reach end customers in today’s world, with immersive and seamless experiences across digital and physical channels.

**What You'll Do**:

- SQL Database/Database server Install/Configure/Decommission.
- SQL Database Upgrade/Patch Recommend/Test/Install(2008 ,2012, 2014, 2016,2017 & 2019 )
- SQL Database Monitoring of MS SQL Servers, space usage, etc.
- SQL Database Storage (Capacity) recommendation and Capacity management for Databases.
- SQL Database Backup/Recovery/Refresh and backup tools.
- SQL Database Security/Compliance.
- SQL Database Maintenance/Purge.
- SQL Database Disaster Recovery Plan/Procedure/Test.
- SQL Database backups, Restore, recovery, and disaster recovery Plans.
- SQL Server Migration and upgrading on-premises
- Configuring MS SQL Server security and managing permissions
- Build and configure HA (SQL Failover Clustering) active/active & active/passive.
- Configuring and troubleshooting Replication, log shipping,& Always-On (2008 ,2012, 2014, 2016,2017 & 2019 )
- Managing database object permissions, user accounts, and passwords.
- Creation of MS SQL Server databases and database objects.
- We are developing and implementing the DBA maintenance plan - ola hallengren scripts.
- Scheduling and managing jobs & alerts on MS SQL Server.
- Database Performance Tuning/Optimization/Troubleshooting
- Managing reports and calls with clients on Critical Incidents and Changes for MS SQL servers.

**What You Know**:

- Hands-on experience in Managing and Configuring Elastic Pool and Azure SQL Database.
- Responsible for the migration from on-prem to Azure SQL VM and Azure SQL.
- Cloud migrations from On-Premises to Azure using tools like DMA & DMS (Offline & Online).
- Strong knowledge in T-SQL & Power Shell Scripting.
- Provide 24x7 support for critical production systems.
- The role is to install, Migrate, implement, upgrade, and optimize the performance of databases.
- Expertise in Microsoft SQL servers and having knowledge of oracle databases would be an added advantage.
- Design and implement various backup and recovery strategies in multiple database environments—recovery of the database with no or mínimal data loss.
- Configure and maintain database servers and processes, including monitoring system health and performance, to ensure high performance levels, availability, and security.
- Command on all versions of Windows Servers. Extensive understanding of various patch-level compatibilities with database releases.
- Good working knowledge of ITIL framework: Incident, Change, Release, and Problem management.
- Experience in High Availability Concepts like Always on, Mirroring, Log shipping, clustering, and Replication.
- Experience in monitoring tool SQL sentry and spotlight.

**Education**:

- Master’s degree or foreign degree equivalent in Computer Science, Business Administration, Finance, or related field and three (3) years of experience in the job offered or a related role.

**Benefits**:

- In addition to competitive salaries and benefits packages, Nisum India offers its employees some unique and fun extras:

- ** Continuous Learning - **Year-round training sessions are offered as part of skill enhancement certifications sponsored by the company on an as need basis. We support our team to excel in their field.
- ** Parental Medical Insurance** - Nisum believes our team is the heart of our business and we want to make sure to take care of the heart of theirs. We offer opt-in parental medical insurance in addition to our medical benefits.
- ** Activities -** From the Nisum Premier League's cricket tournaments to hosted Hack-a-thon, Nisum employees can participate in a variety of team building activities such as skits, dances performance in addition to festival celebrations.
- ** Free Meals - Free snacks and dinner is provided on a daily basis, in addition to subsidized lunch**
- Nisum is an Equal Opportunity Employer and we are proud of our ongoing efforts to foster diversity and inclusion in the workplace.