Job Description

Scope: \xe2\x97\x8f 15+/10+ years of related experience.\xe2\x97\x8f Knowledge to work on latest feature of MS SQL and latest features such as always on, In-memory, Distributed Availability Group, Read Routing, row level encryption, security audit.\xe2\x97\x8f Microsoft MS-SQL Server 2016& above Configuration and Administration, ITIL.\xe2\x97\x8f Manage database servers of all database environments of PFMS\xe2\x97\x8f Developing, managing and testing back-up and recovery plans\xe2\x97\x8f Ensuring that storage, archiving, back-up and recovery procedures are functioning correctly\xe2\x97\x8f Writing database documentation, controlling access permissions and privileges\xe2\x97\x8f Maintaining data standards, including adherence to the Data Protection ActFlexible for 24x7 work environment in 8 hour shiftsYears of ExperienceMinimum 15+/ 10-year experience on working with MS SQL and its latest features.Knowledge on Always ON, IN memory, Distributed Availability Group, Read Routing, row level encryption is required. Experience required in carrying out performance, integrity and security of a database. Must have working experience of1) Installing and upgrading the database server and/or application tools.2) Planning for and allocating the database system\xe2\x80\x99s physical requirements, such as memory, disk space, network requirements, etc.3) Modifying the database structure using information provided by application developers.4) Creating users profiles, and ensuring system security by careful allocation of user permissions.5) Ensuring compliance with database vendor license agreement, including number of installations, and taking care of licensing renewals.6) Creating a backup and recovery strategy for the database, and regularly testing the backups to ensure usability.7) Monitoring technical support for both database systems and related applications.8) Creating reports by querying from database (as per need). These reports can be in the form of pre-formatted reports using the application frontend, or custom-made ad hoc reports by the database administrator.9) Monitoring and optimizing the database\xe2\x80\x99s performance using either manual or automated tools. This may be a DBA\xe2\x80\x99s most important tasks.10) Migrating database instances to new hardware and new versions of software from on premise to cloud based databases and vice versaSkillset/QualificationsQualification:BE/B.Tech/M. Tech/MCA/ME in Computer/IT/Electronics &Tele-Communication EngineeringCertification:\xe2\x97\x8f Microsoft MS-SQL Server 2012 and above Configuration and Administration,\xe2\x97\x8f Microsoft SQL Server: MCSE (Data platform and Business Intelligence) and the older MCDBA,\xe2\x97\x8f Oracle: MySQL Database Developer, MySQL Database Administrator,MongoDB: Certified DBA, Certified Developer

Invokhr