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
Core Skills/Competencies
- Flexible, open-minded, team worker, with a friendly and pleasant personality
- Self-driven, able to work under pressure (deadlines)
- Strong interpersonal and communication skills
- Ability to manage, prioritize and solve problems quickly and completely
- Recent experience with SQL Server, Windows Server and Linux
- Basic scripting knowledge: Bash/Perl/Python scripting
- Exposure to cloud-based database platforms (Azure, AWS, GCP)
- Basic awareness of other infrastructure technologies – for example; Linux, Windows administration, storage, or data networking
- Good analytical and troubleshooting experience on above
- Experience in large enterprise supporting numerous servers and databases preferred
- Willing to work occasionally in nonstandard working hours (on call and planned work)
- Experience in mission critical, high availability, high reliability environments
- 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
- In-depth understanding of database maintenance and performance tuning including the following: installation, configuration, upgrade, monitor, manage, performance tuning of Sybase, SQL Server and Postgres
Mandatory Technical Skills Required to Do the Job
- Microsoft Office
- Experience with various RDBMS, e.g., SQL, Postgres
- Knowledge of NoSQL databases
- Experience with Data Modeling and Database design
- Experience with SQL coding and optimization
- Experience with fundamentals such as: Backup as well as recovery of databases, Tuning database, performance management, monitoring and DB Security
- Experience with scripting in Perl, Python, Bash
- Experience with cloud-based solutions
- Experience with Big Data
- Matric
- IT Qualification would be advantageous
- Industry-related certification
- 4 – 5 years experience as a Database Administrator
- Retail experience is advantageous
- Proven track record of successful implementation
Recruitment Process
- Competency-based interview to assess above requirements
If 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