Database Administrator

Overview:

We are seeking a highly skilled Senior Database Administrator to join our IT team. As a Senior DBA, you will be responsible for the performance, integrity, and security of our databases. You will collaborate closely with development teams, system administrators, and other stakeholders to ensure our databases meet the needs of our organization's data management and business operations.

Responsibilities:

Database Design and Architecture:

1. Design, implement, and maintain database solutions that support business requirements.

2. Define and implement database schemas, tables, indexes, and views.

Database Performance Tuning and Optimization:

1. Monitor and optimize database performance using tools and techniques.

2. Identify and resolve performance issues, bottlenecks, and inefficiencies.

Database Security and Compliance:

1. Implement and maintain database security policies, procedures, and controls.

2. Ensure compliance with regulatory requirements (e.g., GDPR, HIPAA) and industry standards.

Backup and Recovery:

1. Develop and maintain database backup and recovery strategies.

2. Perform regular backups and ensure data integrity and availability.

High Availability and Disaster Recovery:

1. Implement and manage database clustering, replication, and failover solutions for high availability.

2. Plan and execute disaster recovery procedures and tests.

Database Monitoring and Maintenance:

1. Monitor database systems to ensure availability, integrity, and reliability.

2. Perform routine maintenance tasks such as database upgrades and patching.

Automation and Scripting:

1. Automate routine tasks and processes using scripting languages (e.g., PowerShell, Python).

2. Implement database automation tools and frameworks.

Capacity Planning and Scalability:

1. Plan and forecast database capacity requirements.

2. Scale database systems to handle growing data volumes and user loads.

Documentation and Reporting:

1. Document database configurations, procedures, and troubleshooting steps.

2. Prepare and present database performance and status reports to management.

Requirements:

1. Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent work experience.

2. Proven experience as a Database Administrator, preferably in a senior or lead role.

3. Strong proficiency with database management systems (e.g., Microsoft SQL Server, Oracle, MySQL, PostgreSQL).

4. Expertise in database performance tuning, optimization, and troubleshooting.

5. Experience with database security principles and best practices.

6. Solid understanding of database backup and recovery procedures.

7. Hands-on experience with database clustering and replication technologies.

8. Proficiency in database automation and scripting.

9. Excellent analytical and problem-solving skills.

10. Strong communication and collaboration skills.

Preferred Qualifications:

1. Master’s degree in Computer Science, Information Systems, or a related field.

2. 10+ years of experience in software development, with a focus on full stack web development using Java technologies.

3. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional).

4. Experience with cloud-based database services (e.g., AWS RDS, Azure SQL Database).

5. Knowledge of NoSQL databases (e.g., MongoDB, Cassandra).

6. Familiarity with DevOps practices and tools.