Database Administrator

THE PURPOSE OF THE ROLEThe 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 ResponsibilitiesMaintain and Monitor DatabasesDatabase up-timeVisibility of DB healthSQL optimization and best coding practicesSQL runs without impacting the software negativelySQL procedures and functions run efficientlyEnsure developers are following best practicesNew Server and Database SetupsConfigure new server and databases - a functioning databaseDatabase RecoveryEnsure all data is intactDisaster RecoveryEnsure documented disaster recovery planCore Skills/CompetenciesFlexible, 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 JobMicrosoft 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 RequirementsMatricIT 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