Position Overview:
We are seeking a motivated Mid-Level Database Administrator (DBA) with experience in SQL Server and Oracle databases, as well as familiarity with NoSQL databases. The ideal candidate will assist in the management and optimization of our company’s database systems, ensuring data availability, integrity, and performance. 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.
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.
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.
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).
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).