Database Administrator (DBA)

Company Overview

[Company information is not specified.]

Job Summary

The Database Administrator (DBA) is responsible for the performance, integrity, and security of the organization’s databases. This role involves managing database systems to ensure their availability, reliability, and scalability, contributing to the overall efficiency and effectiveness of the organization’s data management strategies.

Responsibilities

• Manage and maintain database environments, including AWS RDS, PostgreSQL, Amazon Redshift, and Microsoft SQL Server.
• Implement backup strategies, replication, and high-availability configurations to ensure data integrity and availability.
• Optimize SQL development through performance tuning and query optimization, ensuring efficient database operations.
• Develop and manage database monitoring solutions, utilizing various tools to track performance and troubleshoot issues.
• Oversee database release management processes and conduct script reviews to ensure best practices are followed.
• Collaborate with development teams to write complex SQL queries and debug existing code for optimal performance.

Qualifications

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
• Experience: Minimum of 8 years in database administration with a strong focus on SQL server technologies.
• Proficiency in SQL development, including performance tuning and query optimization.
• Solid understanding of database design principles and best practices.
• Knowledge of SSIS, SSRS, and SSAS development and management.
• Familiarity with database partitioning, compression, and online performance monitoring/tuning.
• Experience with disaster recovery procedures, including database mirroring and Always On Availability Groups (AAG).
• Knowledge in data modeling, database optimization, and relational database schemas.

Preferred Skills

• Exposure to MySQL and Oracle databases.
• Familiarity with Azure Database Services (e.g., Azure SQL, Azure Database for PostgreSQL).
• Proficiency in scripting languages such as Python or Bash for automation.
• Experience working in Agile/Scrum environments.
• Knowledge of Java, PowerShell, or Python is preferred.

Experience

• A minimum of 8 years of relevant experience in database administration with a strong emphasis on SQL technologies.

Environment

[Work setting and location details are not specified.]

Salary

[Salary information is not specified.]

Growth Opportunities

[Career advancement opportunities are not specified.]

Benefits

[Offered benefits are not specified.]