THE PURPOSE OF THE ROLE
The key function of a Database Administrator (DBA) includes installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.
Key Responsibilities
- Maintain and Monitor Databases
- Database up-time
- Visibility of DB health
- SQL optimization and best coding practices
- SQL runs without impacting the software negatively
- SQL procedures and functions run efficiently
- Ensure developers are following best practices
- New Server and Database Setups
- Configure new server and databases - a functioning database
- Database Recovery
- Ensure all data is intact
- Disaster Recovery
- Ensure documented disaster recovery plan
- Provide real time support to maintain the necessary functionality and respond to issues as they arise
- Support technical users by identifying and resolving user problems
Core Skills / Competencies
Flexible, open-minded, team worker, with a friendly and pleasant personalitySelf-driven, able to work under pressure (deadlines)Strong interpersonal and communication skillsAbility to manage, prioritize and solve problemsBasic awareness of other infrastructure technologiesGood analytical and troubleshooting experienceExperience in large enterprise supporting numerous servers and databasesWilling to work occasionally in nonstandard working hours (on call and planned work)Experience in mission critical, high availability, high reliability environmentsProvide real time support to maintain the necessary functionality and respond to issues as they ariseSupport technical users by identifying and resolving user problemsIn-depth understanding of database maintenance and performance tuning including the following : installation, configuration, upgrade, monitor, manage, performance tuningMandatory Technical Skills Required To Do The Job
Microsoft OfficeExperience with various RDBMS (e.g., SQL, Postgres)Experience with Linux, WindowsKnowledge of NoSQL databasesExperience with Data Modeling and Database designExperience with SQL coding and optimizationExperience with fundamentals such as : backup as well as recovery of databases, tuning database, performance management, monitoring and DB securityExperience with Script, Perl, Python, bashExperience with cloud base solutionsExperience with Big DataMinimum Requirements
MatricIT Qualification would be advantageousIndustry related certificationA minimum of 3 years' experience as a Database AdministratorRetail experience is advantageousStable work historyProven track record of successful implementation#J-18808-Ljbffr