Azure PostgreSQL Database Administrator with 5-8 years of experience. #Azure #postgresqldatabaseadm

Hiring Azure PostgreSQL Database Administrator
Number of Resources = 1
Location = Remote (anywhere from India)
Seniority = 5 to 8 Years
Start Date = ASAP
Office = 100% Remote Work
You will join an Operations Team, responsible for supporting a data warehouse providing business critical data for our Canadian Bank customers. As a Sr. PostgreSQL DBA, you will be accountable for the overall database health, security, and performance. You have good verbal and written communication skills and can work effectively within a global support team. You will work primarily during Canadian business hours (Eastern Time), after hours on-call work is required.
Primary Responsibilities
Installation and Configuration:
Set up and configure Azure Database for PostgreSQL instances according to the functional and non-functional requirements.
Manage database parameters and configuration settings to optimize performance, security, and resource usage.
Database Design and Modeling:
Collaborate with developers and architects to implement efficient and scalable database structures (tables, views, data models, etc.).
Assist in planning and implementing data migration strategies between different Azure PostgreSQL instances or other database systems.
Performance Tuning and Optimization:
Proactively monitor and analyze database performance metrics to identify bottlenecks and areas for improvement.
Implement best practices for query optimization, indexing, and database configuration settings to enhance performance.
Enhance and maintain monitoring frameworks.
Backup and Recovery:
Define, implement, and maintain a comprehensive backup and recovery strategy for Azure PostgreSQL databases, according to established policies and standards.
Regularly test backup and recovery procedures to ensure data integrity and availability. Adapt and refine backup and recovery procedures and documentation, accordingly.
Security and Compliance:
Implement and enforce database security policies, including user access control, encryption, and data masking.
Monitor and audit database activities to ensure compliance with organizational and regulatory requirements.
High Availability and Disaster Recovery:
Design, configure, and manage high availability and disaster recovery solutions for Azure PostgreSQL instances, such as read replicas and failover groups.
Regularly test and review the effectiveness of these solutions to ensure business continuity.
Monitoring and Maintenance:
Proactively monitor database health, performance, and resource usage using Azure Monitor, Query Store, and other monitoring tools.
Perform routine database maintenance tasks, such as updating statistics, reorganizing indexes, and managing storage.
Troubleshooting and Support:
Diagnose and resolve database-related issues, collaborating with developers, infrastructure teams, and other stakeholders to ensure smooth operations.
Provide technical support and guidance to users and developers on PostgreSQL-related matters.
Documentation and Knowledge Sharing:
Create and maintain accurate documentation of database architectures, procedures, and policies.
Share knowledge and best practices with team members and other stakeholders to enhance overall database administration skills and expertise.
Staying Updated:
Keep up to date with the latest Azure and PostgreSQL features, updates, and best practices.
Continuously learn and adapt to new technologies and techniques to improve database management and performance.
Nice to Have
Previous data warehouse / DBA experience in banking environment
Oracle DBA or SQL Server DBA experience
Note : Only shortlisted will receive email to process further. No agencies are allowed. Only Indiavidual profiles are considered. Interview call will be scheduled for only shortlisted profiles.
Please send resumes to if you only have relevant experience.
#hiringnow #hiringimmediately #immediatejoiner #azureopenings #PostgreSQL #sqldatabaseadmin #hiringnow #mindcrestechnologies