Primary Responsibilities: Responsible for ensuring that all MS SQL Database systems operate at peak efficiency and optimum availability and responsible for handling database related incidents.
Position Description
- Guides Associate Database Administrator in installing/upgrading of Database Server when needed
- Assists Team Manager in liaising with management for issues and concerns that are critical for Database Operations
- Monitors and documents success/failure of Database backups for future planning requirements
- Monitors and documents success/failure of scheduled Database jobs and escalates problems to Team Manager when needed
- Responsible for providing solutions to Database related problems At the soonest possible time by providing assistance to other staff and users, escalates to Team Manager when needed
- Responsible for providing adhoc user requests such as Data extraction and report generation, in line with the proper Database requests forms
- Assists in liaising with Database users in giving Database consultation based on business requirements and user's needs.
- Responsible for Monitoring and maintaining security of databases and Database software on corporate, application, Database, role, program, and when applicable, table, view and column levels in cooperation with security experts and Systems programmers
- Responsible for performance tuning and corrective maintenance to assure that Database are performing efficiently and as expected.
- Responsible for implementing disk space management to use as input for capacity planning requirements.
- Responsible for creating primary Database storage structures (tablespaces) after application developers have designed an application
- Responsible for modifying the Database storage structures and parameters, as necessary, from information given by application developers, and vendor consultants
- Responsible for keeping up to date with latest product patches in order to ensure Data integrity and security effectiveness.
Required Experience: 3-5 years experience in managing Oracle, Postrgres, MS SQL, Mongo, MySQL and other Database products
Other Qualifications
- Ability to use a scripting language (like Python or Peri) to automate database administration tasks.
- Relevant database administration certificates, such as Oracle Certified Professional (OCP) or Microsoft Certified Database Administrator (MCDBA).
- Experience in cloud database technologies, like Amazon RDS or Microsoft Azure.
- Knowledge of database automation tools such as Ansible, Puppet, Chef, etc.
