Database Administrator

Whiz Global - Atlanta, GA

Full-time

Atlanta, GA

About the position

The Database Administrator will be responsible for ensuring the performance, availability, and security of databases, primarily hosted in Azure Cloud. This role requires collaboration with development and infrastructure teams, focusing on database management, data analysis, and system security.

Responsibilities

• Manage and maintain MS SQL Server databases and PostgreSQL on Azure Cloud.
• Install, configure, and upgrade database software and related products.
• Monitor database performance and optimize queries.
• Manage Data Warehouse and Data Analytics pipelines.
• Implement and maintain database security policies and procedures.
• Perform database backups and recovery procedures.
• Troubleshoot database-related issues and provide corrective actions.
• Collaborate with development teams to optimize database schema and SQL queries.
• Implement and manage database replication, clustering, and high availability solutions.
• Ensure data integrity and availability through proper backup and disaster recovery.
• Evaluate and recommend database technologies and tools.
• Work closely with DevOps teams for IaaS and other database related activities.

Requirements

• 5-7 years of experience as a Database Administrator or similar role.
• Proficiency in managing Microsoft SQL Server and PostgreSQL on Azure.
• Knowledge of ETL/ELT data pipelines and Data warehousing on Azure.
• Experience with database performance tuning and optimization techniques.
• Solid understanding of database security and data protection.
• Experience with database backup, recovery, and replication.
• Strong knowledge of SQL and T-SQL scripting.
• Familiarity with database design, normalization techniques, and indexing.
• Experience on NoSQL and/or columnar databases like CosmosDB, MongoDB etc.
• Ability to troubleshoot database issues and perform root cause analysis.
• Excellent communication and interpersonal skills.
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Nice-to-haves

• Certification in Microsoft SQL Server and Azure Database Administration.
• Experience with other cloud-based database technologies.
• Knowledge of PostgreSQL administration and optimization.
• Familiarity with DevOps practices and tools.