Aurora PostgreSQL Da....
Aurora PostgreSQL Database Specialist
Posted on :
16-04-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Req ID : 2722430
Resource Profile
- The AWS Aurora/Postgres Database Specialist with expertise will set up maintain and monitor Aurora/Postgres database or other database systems as required.
Resource Responsibilities
Ensure smooth and continuous operation of new and existing database performance and availability of the client s database systems through:
- Manage and maintain Aurora/Postgres databases on AWS.
- Optimize database performance through configuration tuning index optimization and query optimization.
- Implement and manage database backups replication and disaster recovery strategies.
- Monitor database health and performance metrics proactively identifying and resolving issues.
- Collaborate with development and operations teams to design and implement database solutions that meet performance and scalability requirements.
- Stay updated on AWS database technologies and best practices recommeWSnding and implementing improvements as necessary.
- Automate repetitive tasks and processes to improve efficiency and reliability.
- Provide technical guidance and support junior members of the team.
Identify opportunities for improving service delivery methods and procedures; review with appropriate management staff and implement improvements; work with ITC and business users to maintain revise or improve the overall reliability availability and serviceability of the database systems and IT operations by:
- Monitoring considering risk and tuning databases to ensure optimal function in order to maintain the highest degree of database performance.
- Reviewing analyzing and documenting logs charts diagrams and data to advise on and recommend application or system improvements.
- Investigating cost saving opportunities conducting research to refine tune modify and adjust different database technology products.
- Assessing current database architecture setup and developing strategies to optimize database capacity and performance.
3. Create and maintain libraries of all database documentation for past and current projects. This includes database standards policies and Problem Log Knowledge base with detailed problem description resolution and root cause for incident tickets and service requests user procedures manuals technical references standards and guides.
4. Perform other related duties as assigned or required.
Requirements
Knowledge & Skills
- Experience in managing and maintain Aurora/Postgres databases on AWS
- Experience implementing and managing backups restoration replications and snapshots
- 10 years hands of experience with SQL Server database administration
- Handson experience with database troubleshooting
- Proficient in creating technical documentations and providing knowledge transfer
- Experience in Agile product development in Scrum or Kanban would be an asset
- AWS certification(s) such as AWS Certified Database Specialty would be an asset
Skillset
- Experience in managing and maintain Aurora/Postgres databases on AWS
- Experience implementing and managing backups restoration replications and snapshots
- 10 years hands of experience with SQL Server and/or Azure Synapse database administration
- Handson experience with database troubleshooting
- Excellent communication and interpersonal skills
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
