Database Administrator – Operations / Intermediate Level

Role Overview

We are looking for a skilled Database Administrator (DBA) – Operations / Intermediate Level to support day-to-day database administration, monitoring, maintenance, and operational activities across enterprise database environments.

The successful candidate will be responsible for ensuring database availability, stability, performance, and operational continuity by executing routine administration tasks, monitoring database health, handling first-line troubleshooting, and supporting database maintenance activities.

The role requires hands-on experience with at least one of the following database technologies: Oracle, Microsoft SQL Server, PostgreSQL, MongoDB, IBM Db2, or MySQL.

The DBA will work under established operational procedures and collaborate closely with Senior DBAs and Subject Matter Experts (SMEs) to resolve complex technical issues and maintain enterprise database environments.

Key Responsibilities

• Database Operations & Administration

• Perform routine database monitoring, health checks, and availability checks.
• Monitor database alerts, services, and operational performance indicators.
• Execute standard database operational procedures and approved changes.
• Monitor scheduled database jobs, backup activities, and maintenance tasks.
• Manage database users, roles, permissions, and standard access requests.
• Monitor database storage utilization, capacity, and growth trends.
• Perform routine database maintenance and housekeeping activities.
• Monitor database replication, connectivity, and associated services.
• Maintain database operational logs, records, and technical documentation.

2. Backup, Recovery & Maintenance

• Monitor and validate scheduled database backups.
• Execute documented backup and restoration procedures.
• Support database patching, version upgrades, and migrations.
• Assist with database maintenance activities and service restarts.
• Ensure operational procedures align with established backup and recovery policies.

3. Incident Management & Troubleshooting

• Perform first-level troubleshooting of database-related incidents.
• Investigate basic database performance and availability issues.
• Collect diagnostic information, logs, and performance metrics.
• Identify and escalate complex database issues to Senior DBAs or SMEs.
• Participate in incident resolution, root cause analysis, and problem management activities.
• Support application and infrastructure teams in resolving database-related issues.

4. Performance Monitoring & Optimization

• Monitor database performance, resource utilization, and workload trends.
• Identify basic performance bottlenecks and abnormal database behaviour.
• Assist with SQL query analysis, indexing, and execution-plan reviews.
• Monitor CPU, memory, storage I/O, connections, and database wait events.
• Track database growth, replication latency, and capacity utilization.
• Provide operational recommendations to improve database stability and performance.
• Support Senior DBAs/SMEs in implementing performance optimization initiatives.

5. IT Service Management & Operational Support

• Follow established ITIL processes for Incident, Request, Problem, and Change Management.
• Ensure all database changes are appropriately approved and documented.
• Maintain operational runbooks, SOPs, and knowledge documentation.
• Coordinate with application, infrastructure, cloud, and network teams.
• Participate in 24x7 operational support and on-call rotations, where required.

Platform-Specific Technical Requirements

Candidates should possess hands-on administration experience in at least one of the following database platforms.

Oracle Database Administrator

• Oracle Database administration and monitoring.
• SQL analysis and execution-plan interpretation.
• Basic performance tuning and troubleshooting.
• Oracle RAC and Data Guard, where applicable.
• RMAN backup and recovery.
• ASM administration.
• Database patching, upgrades, and migrations.
• Capacity monitoring and database growth management.
• Backup, restore, and recovery procedures.

Microsoft SQL Server DBA

• SQL Server installation, configuration, and administration.
• SQL performance monitoring and query optimization.
• Execution-plan analysis.
• Index and statistics maintenance.
• Wait-statistics analysis.
• Blocking and deadlock troubleshooting.
• Always On Availability Groups, where applicable.
• SQL Server Agent and scheduled job management.
• Backup, restore, and recovery.
• Database patching, upgrades, and maintenance.
• Capacity and performance monitoring.

PostgreSQL DBA

• PostgreSQL database administration and monitoring.
• SQL query optimization and indexing.
• Vacuum and Analyze operations.
• Replication monitoring and troubleshooting.
• Backup and recovery management.
• High availability configuration and monitoring.
• Database upgrades and migrations.
• Capacity management and performance troubleshooting.

MongoDB DBA

• MongoDB administration and monitoring.
• Replica Set management and monitoring.
• Sharding concepts and administration, where applicable.
• Query analysis and index optimization.
• Database performance monitoring and tuning.
• Backup and restore procedures.
• Replication troubleshooting.
• Security, user, and access management.
• Database upgrades and maintenance.

IBM Db2 DBA

• IBM Db2 database administration and monitoring.
• SQL optimization and performance troubleshooting.
• Database backup and recovery.
• Routine database maintenance.
• High availability and replication monitoring, where applicable.
• Database upgrades and migrations.
• Capacity monitoring and operational troubleshooting.

MySQL DBA

• MySQL database administration and monitoring.
• SQL query optimization and indexing.
• Replication monitoring and troubleshooting.
• Backup and recovery management.
• High availability monitoring.
• Performance tuning and database maintenance.
• Database upgrades and patching.
• Capacity and storage management.

Performance & Optimization Expectations The DBA team is expected to contribute to proactive database performance monitoring and optimization rather than operating exclusively on an incident-driven basis.

Responsibilities include monitoring and identifying improvement opportunities across:

• Database configuration and parameter optimization.
• SQL query performance and execution plans.
• Index optimization and maintenance.
• CPU and memory utilization.
• Storage I/O performance.
• Database growth and capacity planning.
• Connection and session management.
• Locking, blocking, and deadlocks.
• Replication health and latency.
• Database wait events and performance bottlenecks.
• High availability and database resilience.
• Backup and recovery performance.
• Application-to-database interactions.
• Infrastructure dependencies.
• Performance baselines, historical trends, and capacity forecasting.

The DBA is expected to identify potential performance concerns, document findings, and provide recommendations to Senior DBAs/SMEs for further assessment and implementation.

Required Experience & Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related discipline.
• Relevant hands-on experience in database administration and operations.
• Practical experience with at least one of the specified database platforms.
• Experience in database monitoring, backup and recovery, maintenance, and troubleshooting.
• Understanding of SQL, database architecture, and performance monitoring.
• Familiarity with high availability, replication, and disaster recovery concepts.
• Experience working within ITIL-based operational environments.
• Ability to work in enterprise production environments and follow established change management procedures.
• Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Skills

• Experience supporting enterprise-scale production databases.
• Exposure to database monitoring and observability tools.
• Familiarity with scripting and automation.
• Exposure to cloud database services and hybrid infrastructure environments.
• Relevant database vendor certifications.
• Experience working in 24x7 managed services or outsourced DBA operations.

Role Expectations

This is an Intermediate-Level Operational DBA position, focused on hands-on database administration, monitoring, maintenance, and first-line troubleshooting.

The individual is expected to independently execute standard operational activities while escalating complex performance, architectural, and recovery issues to Senior DBAs or SMEs.

Advanced database architecture, complex performance engineering, and enterprise-wide optimization ownership will remain with the Senior DBA/SME function.