Database Administrator

Position Overview

The Database Administrator (DBA) is charged with overseeing the installation, configuration, maintenance, performance, security, availability, and reliability of the organization's database systems. This role ensures databases function efficiently and securely, delivering consistent access to business applications and users. Responsibilities span installation, upgrades, monitoring, backups, optimizations, migrations, troubleshooting, capacity planning, and collaboration with developers, system admins, cybersecurity teams, and other stakeholders across on-premises, cloud, or hybrid infrastructures.

Key Responsibilities

• Install, configure, maintain, and upgrade database management systems and associated infrastructure.
• Administer both relational and non-relational databases, including but not limited to Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and MongoDB.
• Monitor database performance, availability, resource use, storage capacity, and connectivity to ensure system health.
• Identify and remediate performance bottlenecks by optimizing queries, indexing strategies, analyzing execution plans, and tuning databases.
• Develop robust backup, restoration, disaster recovery, and business continuity procedures; regularly verify their effectiveness through testing.
• Manage database user roles, permissions, authentication, and security controls following company policies.
• Implement comprehensive security measures such as encryption, auditing, patching, and access monitoring to safeguard databases.
• Guarantee database integrity, consistency, and availability across production, development, and testing environments.
• Oversee migrations, upgrades, platform changes, system integrations, and deployments ensuring minimal disruption.
• Collaborate with development teams on database schema design, indexing, stored procedures, and query optimization.
• Review and provide expert guidance on database-related changes to enhance design, scalability, and operational excellence.
• Resolve incidents related to slow performance, deadlocks, connectivity failures, job failures, storage constraints, data corruption, and application database errors.
• Conduct root cause analyses for recurring issues and implement preventive solutions to enhance stability.
• Monitor and plan for database storage growth to accommodate future business demands.
• Manage high-availability solutions, clustering, replication, failover, and other resilience mechanisms.
• Apply patches, updates, and version upgrades with proper testing and change management.
• Automate routine administration, monitoring, maintenance, and reporting tasks using scripting or automation tools.
• Maintain detailed documentation of database architecture, configurations, backup and recovery processes, permissions, and operational standards.
• Support audits by providing database records, security evidence, and compliance documentation.
• Coordinate with IT and cybersecurity teams to identify risks and enhance database security and reliability.
• Participate in incident response, disaster recovery drills, testing, and business continuity planning.
• Offer technical guidance and support to users, developers, system administrators, and project teams regarding database issues.
• Research and assess new database technologies, cloud services, and administration methodologies for improved scalability and efficiency.
• Generate regular reports on performance, availability, incidents, capacity, maintenance, security, and improvement initiatives.

Qualifications and Requirements

• Bachelor’s degree in Computer Science, IT, Software Engineering, Database Management, or related field.
• Demonstrated experience as a Database Administrator, Database Engineer, Systems Administrator, or related role.
• Proficient knowledge of database management systems including Microsoft SQL Server, Oracle, MySQL, PostgreSQL, and MongoDB.
• Advanced SQL capabilities, including developing, analyzing, optimizing, and troubleshooting complex queries and stored procedures.
• Strong understanding of database architecture concepts such as schemas, normalization, indexing, transactions, integrity, and performance tuning.
• Hands-on experience with backup, restore, disaster recovery, replication, high availability, and failover processes.
• Knowledge of database security best practices including user management, permissions, authentication, encryption, auditing, and access control.
• Experience monitoring and troubleshooting issues related to CPU, memory, storage, network, locking, and query performance.
• Familiarity with database migration, patching, upgrades, and change management.
• Exposure to cloud database services such as Microsoft Azure, AWS, or Google Cloud is beneficial.
• Preferred skills with automation and scripting using PowerShell, Python, Bash or equivalent.
• Experience using monitoring, logging, ticketing, and IT service management tools.
• Strong problem-solving, analytical, and incident management capabilities.
• Ability to collaborate effectively with various teams including developers, infrastructure, cybersecurity, and project management.
• Excellent communication, documentation, organizational, and time management skills.
• Upholds confidentiality and professionalism when handling sensitive business data.
• Certifications in database technologies (e.g., Microsoft SQL Server, Oracle, PostgreSQL, AWS, Azure, ITIL) are advantageous.