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/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 problems quickly and completelyRecent experience with SQL Server, Windows Server and LinuxBasic scripting knowledge: Bash/Perl/Python scriptingExposure to cloud-based database platforms (Azure, AWS, GCP)Basic awareness of other infrastructure technologies – for example; Linux, Windows administration, storage, or data networkingGood analytical and troubleshooting experience on aboveExperience in large enterprise supporting numerous servers and databases preferredWilling 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 tuning of Sybase, SQL Server and PostgresMandatory Technical Skills Required to Do the Job Microsoft OfficeExperience with various RDBMS, e.g., SQL, PostgresKnowledge 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 scripting in Perl, Python, BashExperience with cloud-based solutionsExperience with Big DataMatricIT Qualification would be advantageousIndustry-related certification4 – 5 years experience as a Database AdministratorRetail experience is advantageousProven track record of successful implementationRecruitment ProcessCompetency-based interview to assess above requirementsIf you are interested in applying, please email your updated CV to ******.
Please add the name of the vacancy to the subject line of your email.
#J-18808-Ljbffr