Senior Database Administrator
Description
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.