Database Engineer - Level - PostgreSQL DBA
Database Engineer - Level - PostgreSQL DBA
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
This role is for Database Engineering team. Database Engineering team is part of Platform as a Service (PaaS) division under Operations & Infrastructure org. The team is responsible to architect design and build highly available and reliable secure and cost-effective database solutions. The team is responsible for delivering multiple database technologies (both RDBMS and NoSQL) and automated services to provision and manage databases on premise and in public cloud.
The role is for highly experienced database engineer with expertise in PostgreSQL and Oracle DB technologies. The responsibilities include but are not limited to
- Architect design and build deployment standards of PostgreSQL and Oracle DB technologies
- Develop and maintain scripts for database automation tasks using Python Ansible or similar languages.
- Implement Infrastructure as Code practices using tools like Terraform Ansible or CloudFormation.
- Develop and implement robust backup and recovery strategies ensuring databases are protected against data loss and can be recovered in case of failure.
- Maintain comprehensive documentation for database configurations procedures and policies.
- Set up and maintain database monitoring tools to ensure database health and performance.
- Troubleshoot and resolve database related issues in a timely manner as part of Level-3 support
- Provide technical influence and subject matter expertise for the database technologies tackling complex problems and identifying innovative solutions
- Work closely with our development teams to ensure database designs align with application requirements leading to more efficient and effective application development.
- The role serves as a technical and functional specialist working independently with guidance only in the most challenging situations.
This is a hybrid position. Expectation of days in office will be confirmed by your Hiring Manager.
Qualifications :
Basic Qualifications:
- 10 years of relevant work experience with a Bachelors Degree or at least 8 years of experience with an Advanced Degree (e.g. Masters MBA JD MD) or 6 years of work experience with a PhD OR 10 years of relevant work experience.
Preferred Qualifications:
- 10 or more years of relevant work experience with a Bachelor Degree or 8 or more relevant years of experience with an Advanced Degree (e.g. Masters MBA JD MD) or 6 or more years of experience with a PhD
- 6 years of DB Engineering/Administration experience primarily with PostgreSQL and Oracle databases
- 8-10 years of DBE/DBA experience primarily with PostgreSQL and Oracle DB technologies both on premise and public cloud.
- 3 years of experience managing complex bi-directional replication topology
- Good experience with Python Ansible and IAC-Terraform scripting
- Experience with public cloud services such as AWS Google Cloud Platform or Microsoft Azure
- Strong understanding of PostgreSQL & Oracle database fundamentals and Architecture.
- Strong understanding of PostgreSQL streaming and logical replication and experience with repmgr and pglogical
- Good understanding and experience with Oracle Golden Gate and Oracle Data Guard
- Experience with PostgreSQL tools (e.g. Barman PgBouncer) and prominent PostgreSQL extensions
- Experience configuring PostgreSQL monitoring using Prometheus Grafana.
- Knowledge of DevOps tools e.g. GIT Jenkins
- Should have good Troubleshooting and Performance Improving Skills including index creation query optimization change in data model
- Strong Unix/Linux platform skills and understanding of network storage tiered application environments and security.
- Good interpersonal skills along with effective communication skills.
- Demonstrate ability to work in a complex organization to determine business and customer needs providing the best solution to meet those needs.
Additional Information :
Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race color religion sex national origin sexual orientation gender identity disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.
Remote Work :
No
Employment Type :
Full-time
Employment Type
Full-time
