Job
Description
The Associate Database Administrator works closely with Change Control, Release Management, Asset and Configuration Management and Capacity and Availability Management to establish the needs of users, monitoring user access and security. What you'll be doing Key Responsibilities: Under guidance, assists with the installation, configuration, and maintenance of database management systems (DBMS), including SQL Server, Oracle, MySQL, or others, as required. Under guidance, collaborates with software developers/architects to design and optimize database schemas, data models, and database-related applications. Participates in the writing of database documentation, including data standards, data flow diagrams, standard operating procedures and definitions for the data dictionary (metadata). Under guidance, monitors database performance, identifies performance bottlenecks, and optimizes queries and indexing for optimal database performance. Designs and implements robust backup and disaster recovery strategies to ensure data availability and business continuity. Under guidance, monitors production databases regularly or respond to any database issues by bringing down the database or taking the database offline. Works closely with the Change Control and Release Management functions to commission and install new applications and customizing existing applications in order to make them fit for purpose. Under guidance, plans and executes database software upgrades and applies patches to keep systems up-to-date and secure. Implements and manages security measures to safeguard databases from unauthorized access, data breaches, and data loss. Ensures data integrity and consistency by performing regular data validation, integrity checks, and data cleansing activities. Under guidance, conducts regular security audits and vulnerability assessments to maintain compliance with data protection standards and regulations. Works collaboratively with cross-functional teams, including developers, system administrators, network engineers, and business stakeholders, to support database-related initiatives. Provides technical support to end-users, assists with database-related enquiries, and conducts training sessions as needed. Performs any other related task as required. Knowledge and Attributes: Basic proficiency in database administration tasks, including database installation, configuration, maintenance, and performance tuning. Basic knowledge of SQL (Structured Query Language) to write complex queries, stored procedures, and functions. Basic understanding of database security principles, access controls, and data encryption methods. Basic working knowledge in database backup and recovery strategies to ensure data availability and business continuity. Ability to monitor database performance, identify and resolve issues, and optimize database operations. Ability to learn new technologies as needed to provide the best solutions to all stakeholders. Can communicate IT information in simplified form depending on the target audience. Effective communication and collaboration skills to work with cross-functional teams and stakeholders. Basic proficiency understanding of the principles of data architecture and data services. Basic knowledge of application development lifecycle and data access layers. Displays some problem-solving skills to troubleshoot database-related issues and implement effective solutions. Displays some ability to manipulate, process and extract value from large, disconnected datasets. Academic Qualifications and Certifications: Bachelors degree or equivalent in computer science, engineering, information technology or related field Relevant certification, such as MCSE DBA, oracles associate or equivalent Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate; Oracle Certified Professional (OCP) - Database Administrator; MySQL Database Administrator; PostgreSQL Certified Professional Completion of database management courses covering topics like database administration, data modelling, SQL, and performance tuning can provide foundational knowledge Required Experience: Entry level experience working as a Database Administrator within an Information Technology organization. Entry level experience with database backup and recovery best practices. Entry level experience running and creating health assessment reports. Entry level experience working with suppliers to deliver solutions. Entry level experience in Oracle Enterprise. Entry level experience in Microsoft SQL Server. Entry level experience managing databases.
