Database Administrator

Responsibilities:
• Manage database servers of all database environments of PFMS.
• Developing, managing, and testing backup and recovery plans.
• Ensuring that storage, archiving, backup, and recovery procedures are functioning correctly.
• Writing database documentation, and controlling access permissions and privileges.
• Maintaining data standards, including adherence to the Data Protection Act.
• Flexible for a 24x7 work environment in 8-hour shifts.
• Planning for and allocating the database system's physical requirements, such as memory, disk space, network requirements, etc.
• Modifying the database structure using information provided by application developers.
• Creating user profiles, and ensuring system security by careful allocation of user permissions.
• Ensuring compliance with database vendor license agreement, including number of installations, and taking care of licensing renewals.
• Creating a backup and recovery strategy for the database, and regularly testing the backups to ensure usability.
• Monitoring technical support for both database systems and related applications.
• Creating reports by querying from the database (as needed). 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.
• Monitoring and optimizing the database's performance using either manual or automated tools. This may be a DBA's most important task.
• Migrating database instances to new hardware and new versions of software from on-premise to cloud-based databases and vice versa.

Requirements:
• Minimum 15+/10 years of experience working with MS SQL and its latest features.
• Knowledge of Always ON, IN memory, Distributed Availability Group, Read Routing, and row-level encryption is required.
• Experience required in carrying out performance, integrity, and security of a database.
• Must have working experience of Installing and upgrading the database server and/or application tools.
• 15+/10+ years of related experience.
• Knowledge working on the latest features of MS SQL and latest features such as always-on, In-memory, Distributed Availability Group, Read Routing, row-level encryption, and security audit.
• Microsoft MS-SQL Server 2016 and above Configuration and Administration, ITIL.
• BE/B. Tech/M. Tech/MCA/ME in Computer/IT/Electronics and Telecommunication Engineering.