Database admin, DB modelling, proficiency in writing complex queries, Store Procedures, performance tuning, data warehousing skills.
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.

Database admin

Job Description

Required Skills