Database administrator

Object Technology Solutions, Inc (OTSI) has an immediate opening for a Database Administrator

Database Administrator

Job Location: Mumbai, Chembur

MAJOR RESPONSIBILITIES: 

• Should have good knowledge of SQL database 2016 and above Installation and configuration of SQL server, related services, and additional server components.
  
• Implementation of SQL server cluster instance.
  
• Planning and execution of Migration Creation of databases and tables. Managing and configuring SQL server instances and databases.
  
• Manage database integrity Monitor database activities (sessions, blocking, resource utilization) and queries (query store, extended and trace events, execution plans) Troubleshooting performance problems with tools Manage backup and restore of SQL databases.
  

SKILLS AND ABILITIES REQUIRED: 

• Working with indexes, DB statistics, and audit configuration. Managing SQL logins, database permissions, and roles. Patching and upgrading of SQL instances.
  
• Installation and configuration of SQL server reporting services.
  
  Implementation of High availability features such as Always-ON, replication, and mirroring.
  
• Must have experience in handling backups, Always on / In memory table concepts, Roles Management, Index fragmentation, and Reporting Services.
  
  Min. 5 (Five) years of experience in Administration and Maintenance of Windows SQL Server (i.e. 2008, 2012, 2016 or later) Standard/Enterprise versions.
  

      QUALIFICATIONS AND EXPERIENCE

•  B. E. / B. Tech. / M.Sc. in Computer Science or Computer Engineering or Information Technology or MCA with minimum passing marks of 60%.
  
•  5 years of relevant experience in managing Microsoft SQL database server.
  
•