Full Job Description
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
QL 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.
Developing and implementing DBA maintenance plan – ola hallengren scripts.
Scheduling and managing jobs & alerts on MS SQL Server.
Database Performance Tuning/Optimisation/Troubleshooting
Managing reports and calls with clients on Critical Incidents and Changes for MS SQL servers.
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.
What You Know
Cloud migrations from On-Premises to Azure using tools like using DMA & DMS (Offline & Online).
Strong knowledge in T-SQL & Power Shell Scripting.
Provide 24x7 support for critical production systems.
Role is to install, Migrate, implement, upgrade, and optimize the performance of databases.
Expertise on Microsoft SQL server having knowledge of oracle databases would be an added advantage.
Design and implement various backup and recovery strategies on multiple database environments. Recovery of database with no or minimal data loss.
Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
Command on all versions of Windows Servers. Extensive understanding of various patch level compatibilities with database releases.
Good working knowledge on 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 se
Bachelor’s degree in Computer Science, Information systems, Engineering, Computer applications or related field
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.