Database Administrator

Job Description

Job Description

Position Overview:

The role will involve working on database maintenance, performance tuning, backups, and troubleshooting, while also collaborating with various teams to support database-related applications.

Key Responsibilities

Database Maintenance & Support:

• Assist in the administration and management of SQL Server and Oracle databases.
• Monitor database performance, ensure system availability, and implement necessary improvements to optimize performance.
• Perform database backups, restores, and ensure disaster recovery plans are in place for all database environments.
• Assist in setting up new databases, including installation, configuration, and version upgrades.
• Troubleshooting & Issue Resolution:
• Provide support in resolving database issues including slow performance, data integrity, and connectivity problems.
• Troubleshoot issues with SQL Server and Oracle databases and collaborate with teams to resolve issues promptly.
• Address minor issues with NoSQL databases like MongoDB or Redis as needed.

• Perform regular backup procedures for SQL Server and Oracle databases and validate the recovery process.
• Assist in setting up automated backups and manage retention policies for databases.

• Assist in managing user access and security policies across SQL Server and Oracle databases.
• Ensure that database security measures are followed, including user role assignments and access permissions.

• Help monitor database performance using available tools (e.g., SQL Server Management Studio (SSMS), Oracle Enterprise Manager).
• Assist in identifying and resolving database performance bottlenecks, such as slow queries, indexing, and configuration changes.

• Maintain documentation for database configurations, procedures, and issues encountered.
• Prepare simple performance reports and assist in maintaining the inventory of all databases.

Requirements

Professional Experience:

• 2-4 years of experience in database administration, with a focus on SQL Server and Oracle databases.
• Basic familiarity with NoSQL databases such as MongoDB, Cassandra, or Redis is a plus.
• Experience in monitoring, troubleshooting, and optimizing databases.

• Good knowledge of SQL (T-SQL for SQL Server, PL/SQL for Oracle).
• Familiarity with database backup and recovery procedures.
• Experience with SQL Server Management Studio (SSMS), Oracle Enterprise Manager, or similar database management tools.
• Basic understanding of database security principles and user management.
• Knowledge of NoSQL databases (MongoDB, Redis, etc.) is an advantage.

• Experience with cloud-based databases (e.g., Azure SQL Database, AWS RDS, Oracle Cloud).
• Knowledge of basic automation or scripting (e.g., PowerShell, Bash, or SQL scripts).

Working Conditions

Full-time position with some flexibility for on-call or after-hours support when required.

Education

Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

check(event) ; career-website-detail-template-2 => apply(record.id,meta) mousedown=lyte-button => check(event) final-style=background-color:#0D0D0D;border-color:#0D0D0D;color:white; final-class=lyte-button lyteBackgroundColorBtn lyteSuccess lyte-rendered=>