Database Administrator
Install, configure, secure, optimise, and maintain the database systems that store every organisation's critical data — ensuring databases are fast, available, backed up, and protected.
A Database Administrator (DBA) is responsible for the performance, security, availability, and integrity of an organisation's database systems. Every digital organisation — banks, hospitals, telecoms, e-commerce companies, government agencies — stores its critical operational data in relational or non-relational databases. DBAs ensure that those databases work correctly, run fast, recover from failures, and are protected from data loss and unauthorised access. The DBA role splits into two main types: operational DBAs focus on day-to-day administration, monitoring, backup, and recovery; development DBAs (also called data DBAs) focus on database design, query optimisation, and supporting application developers. In practice, especially in smaller organisations, one DBA covers both. The relational database landscape is dominated by Oracle (the traditional enterprise standard in Sri Lanka, especially at banks and telecoms), Microsoft SQL Server (dominant in Windows-based enterprise environments), and PostgreSQL (the leading open-source alternative, growing rapidly in cloud-native applications). MySQL is widely used in web applications. Cloud-managed database services — AWS RDS, Azure SQL Database, Google Cloud SQL — are changing the DBA role: routine administration is increasingly automated, while optimisation, security, and architecture become more important. In Sri Lanka, DBAs are in steady demand at banks (Commercial Bank, HNB, Sampath Bank, BOC use Oracle and SQL Server extensively), telecoms (Dialog, Mobitel, SLT maintain large billing and operational databases), government agencies, and IT services companies. The Oracle certification pathway (OCA → OCP → OCM) is the most valued database certification in Sri Lankan enterprise, and Oracle DBAs at senior level command some of the highest salaries in the local IT market.
What a Database Administrator does daily
- Install and configure database software — Oracle Database, Microsoft SQL Server, PostgreSQL, MySQL; setting up instances, tablespaces, filegroups, storage, memory, and process parameters for optimal performance
- Design and implement database schemas — working with developers to design tables, indexes, foreign keys, normalisation, and data types; reviewing ERDs (Entity-Relationship Diagrams)
- Monitor database performance — query execution plans, wait statistics, slow query logs, I/O throughput, memory pressure; identifying and resolving performance bottlenecks
- Optimise SQL queries — EXPLAIN PLAN, query hints, index tuning, statistics updates, partitioning; reducing query execution times from hours to seconds
- Implement backup and recovery — full, incremental, and transaction log backups; RMAN (Oracle), SQL Server Agent backup jobs, pg_dump; testing recovery procedures regularly
- Manage high availability and disaster recovery — Oracle Data Guard, SQL Server Always On Availability Groups, PostgreSQL streaming replication; ensuring minimal downtime for critical business systems
- Enforce database security — role-based access control, column-level encryption, Transparent Data Encryption (TDE), auditing access to sensitive data (PII, financial records)
- Perform database migrations and upgrades — moving databases between versions, platforms, or cloud; minimising downtime during critical business system upgrades
- Manage storage and capacity planning — monitoring database growth, projecting future storage requirements, archiving old data to keep databases performant
- Support application teams — helping developers write efficient SQL, reviewing stored procedures, advising on database design, explaining query plans
Step-by-Step Career Roadmap
- Learn what a database is — "Database Basics" on Khan Academy (free); understanding that databases are structured stores of information that can be queried is the starting point
- Install DB Browser for SQLite (free) — create a simple database: a table of students with name, age, and grade; run SELECT, INSERT, UPDATE, DELETE; this hands-on introduction is the best way to understand database basics
- Learn basic SQL — W3Schools SQL Tutorial (free); covers SELECT, WHERE, ORDER BY, GROUP BY, JOIN; the foundational SQL every DBA needs
- Understand the concept of primary keys and foreign keys — how tables relate to each other; a student table with a class_id foreign key pointing to a classes table; normalisation basics
- Look at real database systems — SQLite powers many apps on your phone; understanding that your WhatsApp messages are stored in a SQLite database on your device makes databases tangible
- DB Browser for SQLite: create a school timetable database (tables: Students, Classes, Teachers)
- W3Schools SQL Tutorial (free) — complete all basic exercises
- Khan Academy "Intro to SQL" (free) — all modules
- "How databases work" Crash Course Computer Science (YouTube, free)
- SQLZoo beginner exercises (free)
- SQL is one of the most useful skills you can learn in computing — it is used by developers, analysts, DBAs, data scientists, and business analysts; the time invested in SQL pays off across many different careers; even if you end up not being a DBA, SQL will serve you well