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 negativelySQL procedures and functions run efficientlyEnsure developers are following best practicesNew Server and Database Setups
Configure new server and databases – a functioning databaseDatabase Recovery
Ensure all data is intactDisaster RecoveryEnsure documented disaster recovery planCORE 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, PostgresExperience 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