Senior Database Administrator

1 Month ago • 3 Years +

Job Summary

Job Description

As a Senior Database Administrator, you will be responsible for the installation, configuration, and maintenance of PostgreSQL databases across various platforms including Linux, Unix, and Windows. Your tasks will include performance tuning and optimization of database queries, implementing and managing backup and recovery solutions, designing and enforcing security protocols, and utilizing Python and PowerShell for automation. You'll also deploy and manage PostgreSQL databases on AWS, troubleshoot database-related issues, and collaborate with development teams. This role requires strong database administration skills and a focus on ensuring data integrity, security, and optimal performance, with at least three years of PostgreSQL experience.

Must have:

3+ years of PostgreSQL database administration experience.
Proficiency in MS SQL Server for database management.
Strong scripting skills in Python for automation.
Experience with PowerShell for task automation.
Experience with AWS cloud services.
Familiarity with Linux/Unix operating systems.
Excellent troubleshooting and problem-solving skills.
Strong verbal and written communication skills.

Good to have:

Relevant certifications in PostgreSQL, MS SQL, AWS, or database administration.
Experience with cloud platforms like Azure.
Ability to manage and lead database-related projects.

11 skills required

11 skills required for this role

Add these skills to join the top 1% applicants for this job

unix

azure

aws

python

sql

powershell

linux

postgresql

communication

scalability

problem-solving

Job Details

Responsibilities:

Database Management: Install, configure, and maintain PostgreSQL databases on various platforms (Linux, Unix, Windows).
Performance Tuning: Conduct performance tuning and optimization of database queries to ensure efficient data retrieval and processing.
Backup and Recovery: Implement and manage backup solutions to ensure data integrity and availability.
Security: Design and enforce security protocols to protect sensitive data and ensure compliance with industry standards.
Automation: Utilize Python and PowerShell to automate routine database tasks and improve operational efficiency.
AWS Integration: Deploy and manage PostgreSQL databases on AWS, leveraging cloud services for scalability and reliability.
Troubleshooting: Identify and resolve database-related issues, ensuring minimal downtime and optimal performance.
Collaboration: Work closely with development teams to design and implement database solutions that meet business requirements.

Required Skills:

PostgreSQL: 3+ years of experience in PostgreSQL database administration.
MS SQL: Proficiency in MS SQL Server for database management and migration tasks.
Python: Strong scripting skills for automation and data manipulation.
PowerShell: Experience with PowerShell for task automation and system management.
AWS: Experience with AWS cloud services for database deployment and management.
Linux/Unix: Familiarity with Linux/Unix operating systems for database deployment and management.
Problem-Solving: Excellent troubleshooting and problem-solving skills.
Communication: Strong verbal and written communication skills to collaborate effectively with team members and stakeholders.

Preferred Qualifications:

Certifications: Relevant certifications in PostgreSQL, MS SQL, AWS, or database administration.
Cloud Experience: Experience with AWS and other cloud platforms like Azure for database deployment and management.
Project Management: Ability to manage and lead database-related projects.