Database Administrator(SQL & Oracle)

Job Description

This role involves performance tuning, backup management, and issue resolution, while actively supporting application teams and contributing to the overall efficiency of database operations.

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.
• Backup & Recovery:
• 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.
• Security & User Management:
• 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.
• Database Monitoring & Optimization:
• 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.

Documentation & Reporting:

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

Required Skills & Qualifications:

Experience:

• 7 plus 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.

Skills:

• 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.

Preferred Qualifications:

• 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).

Education:

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