Responsible for managing the organizations data infrastructure, ensuring databases are secure, efficient and accessible
Proficient in Database Management Systems
Relational Databases: MySQL, MariaDB, MsSQL
NoSQL Databases: MongoDB
Cloud Databases: Amazon RDS: MySQL, MariaDB
Advanced SQL skills
Query writing - ability to understand and write complex SQL queries, stored procedures, triggers and functions
Query optimization - analyze and optimize queries for performance improvement
Indexing strategies - understand importance of indexing, the various indexing techniques available for each DBMS and how to implement them
Database design and modelling
Data modelling - proficient in designing or advising on efficient database schemas using Entity-Relationship diagrams
Normalization/Denormalization - knowledge of normalization for less data redundancy and denormalization for performance tuning
Capacity planning - estimate future database growth and resource planning
Performance monitoring and tuning
Performance metrics - understand key metrics like CPU usage, memory allocation, disk I/O, query response times etc
Troubleshooting - identify and resolve performance bottlenecks in databases
Backup and recovery
Backup strategies - implement full, incremental and differential backups to safeguard data
Recovery techniques - proficient in restoring databases from backups and performing point-in-time recoveries
Disaster recovery planning - develop and maintain plans to ensure business continuity in case of data loss or system failures
Security management
Access control - implement role-based access control (RBAC) and manage user permissions
Data encryption - ensure data is encrypted both at rest and in transit
Compliance - Adhere to regulations like GDPR or PCI-DSS to maintain data privacy and security
Scripting and automation
Scripting languages - proficient in languages such as python, powershell, bash or perl for automation of routine tasks
Automation tools - experience with tools like ansible or chef to streamline database management processes
High availability and scalability
Clustering and replication - set up and manage database clusters and partitions and replication to ensure high availability
Load balancing - distribute database load across multiple servers to enhance performance and reliability
Sharding - implement sharding techniques to distribute data across multiple databases for scalability
Data warehousing and ETL processes
Data warehousing - understand data warehousing concepts and OLAP vs OLTP
ETL tools - experience with Extract, Transaction Load (ETL) tools like Talend for data integration
Cloud computing and virtualization
Cloud platforms - proficient in cloud services like AWS and Azure, in particular, the database offerings of each
Virtualization technologies - experience with vritualization tools such as VMWare or Hyper-V, containerization with Docker
Experience with Development and DevOps practices
DevOps integration - understand DevOps methodologies and tools to facilitate continuous integration and deployment (CI/CD) involving databases
Version control systems - familiar with systems like GIT and liquibase for managing database scripts and configurations
Migration and upgrades
Database migration - skilled in migrating databases between systems or versions with minimal downtime
Upgrade planning - plan and execute database upgrades, ensuring compatibility and system stability

data base admin

Job Description

Required Skills