Database Administrator

Position Overview

The Database Administrator is responsible for overseeing and managing the database environments of an organization, ensuring their performance, availability, security, and dependability. This role involves installation, configuration, monitoring, maintenance, and upgrading of database systems, guaranteeing stable and efficient access for business applications and users.

Key Responsibilities

• Set up, configure, administer, maintain, and improve database management systems and supporting infrastructure.
• Handle relational and NoSQL databases including Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MongoDB, or others as required.
• Continuously monitor database uptime, performance metrics, resource usage, storage, and connectivity.
• Address performance issues by optimizing queries, improving indexes, adjusting configurations, analyzing execution plans, and tuning databases.
• Develop and uphold solid backup, restoration, disaster recovery, and business continuity protocols.
• Regularly verify backup and recovery procedures to ensure timely and reliable restoration in case of failures or data loss.
• Administer database user accounts, roles, permissions, and authentication methods aligned with security policies.
• Implement comprehensive security measures such as encryption, audits, access monitoring, patch management, and prevention against unauthorized intrusion.
• Ensure database integrity, consistency, and reliability across various environments including production, development, and testing.
• Facilitate migrations, upgrades, platform switches, system integrations, and deployments minimizing service interruptions.
• Collaborate with development teams on schema design, indexing, stored procedures, functions, and SQL query optimization.
• Review and advise on database-related changes focusing on design, scalability, performance, and operational needs.
• Resolve incidents relating to slow responses, connection failures, deadlocks, failed jobs, data corruption, or application database errors.
• Analyze root causes of recurring issues and apply corrective measures to enhance system stability.
• Track storage usage and forecast capacity requirements to support future growth.
• Configure and uphold high availability solutions including replication, clustering, failover, or similar technologies.
• Apply patches, security fixes, version updates while following testing and change control procedures.
• Automate repetitive administration, monitoring, and reporting tasks using scripting or automation tools where feasible.
• Maintain thorough documentation on database architecture, configurations, access policies, backup/restoration processes, maintenance routines, and standards.
• Provide support for audits by supplying necessary database records, security evidence, and compliance reports.
• Partner with IT infrastructure and cybersecurity teams to identify vulnerabilities and enhance security posture and reliability.
• Participate in incident responses, disaster recovery drills, system tests, and business continuity planning.
• Offer expert assistance to users, developers, system administrators, and projects for database-related concerns.
• Continuously evaluate new database technologies, cloud services, tools, and administration techniques to boost efficiency and scalability.
• Prepare regular reports highlighting database health indicators, incidents, maintenance, security, and suggested improvements.

Required Qualifications and Experience

• Bachelor’s degree in Computer Science, IT, Software Engineering, Database Management, or related field.
• Demonstrated experience as a Database Administrator, Database Engineer, or similar role involving database operations.
• In-depth knowledge of database management systems such as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, MongoDB, or similar.
• Proficiency in SQL with expertise in writing, analyzing, troubleshooting, and optimizing complex queries, stored procedures, and functions.
• Comprehensive understanding of database design, normalization, indexing, transactions, data integrity, and performance tuning.
• Hands-on experience with backup, restoration, disaster recovery planning, replication, high availability, and failover mechanisms.
• Experience implementing database security, managing users, permissions, authentication, encryption, auditing, and access control.
• Skill in monitoring database performance and resolving issues involving CPU, memory, storage, connectivity, locking, and query bottlenecks.
• Familiarity with processes related to database migrations, upgrades, patching, maintenance, and change management.
• Knowledge of cloud database platforms (Microsoft Azure, AWS, Google Cloud) is advantageous.
• Preferred experience in scripting or automation via PowerShell, Python, Bash, or similar technologies.
• Familiar with monitoring, logging, ticketing, IT service management, and administration tools.
• Strong problem-solving, analytical, troubleshooting, and incident management skills.
• Ability to collaborate effectively with developers, infrastructure, cybersecurity, project managers, and business teams.
• Excellent documentation, communication, organization, and time management capabilities.
• Ability to handle confidential business data responsibly and with professionalism.
• Relevant certifications in database technologies or methodologies (e.g., Microsoft SQL Server, Oracle, PostgreSQL, AWS, Azure, ITIL) are beneficial.