Overview:
*job summary*
- looking for postgresql database administrator for one of largest fintech company in the world.
*responsibilities*:
*job description*
- reporting to the sr manager database, the sr/postgresql dba will be the primary technical resource in developing and maintaining finastra's large database infrastructure.
your primary responsibility is to manage finastra's client facing databases in azure (paas/iaas) deployments.
- prepare postgresql roadmap for the future, comfortable in acting as product owner, manage stake holders across the organization.
- the incumbent is responsible for building/managing business critical postgresql databases in azure paas maintaining, enhancing, and tuning existing and new postgresql databases, and supporting production operations.
- you are an experienced postgresql dba with 10+ years of experience in managing databases of various sizes, 5+ years of strong working knowledge of postgresql flex server in azure.
- you are also well versed with other flavors of postgresql databases in azure.
- working experience with azure flex-server for postgresql is a must.
- should have working experience on oracle databases.
qualifications:
*requirement*
- strong hands on 6+ year experience in database administration of postgresql, developing, documenting, and advocating best practices.
- 2+ yrs working experience in oracle databases 12c/19c.
- mentor and share best practices on postgresql within team.
- managing / supporting postgresql azure paas/iaas configuration specifically azure flex-server.
- well versed with other servers/flavors of pg databases in azure, like cosmos db for pg(citus)
- experience in setting up ha/dr/replication in azure-paas/iaas models.
- setting up backup/recovery, performance tuning, enabling monitoring/alerting for postgresql flex-server.
- build best practices/standard and provide guidance to the development team regarding database design and usage.
- strong in-depth knowledge of pg internals.
- demonstrated experience writing complex stored procedures and queries.
- develop automation technologies to speed up loading data into the end target.
- design and develop relational databases.
- develop appropriate corrective actions to resolve production data issues, not limited to performance tuning, recovery etc.
- design database schema to meet new enhancement requirements.
- develop etl strategies for integrating or migrating data from multiple sources
- proven experience with integration from oracle to postgresql.
- experience in operational and incident management / resolution.
- enhanced documentation skills - prepare sop / best practices to be shared with the team.
*skills & knowledge -*
- university degree/college diploma in computer science or a related field of study.
- ability to troubleshoot and, diagnose and resolve complex database issues.
- good understanding of the differences between oltp and olap systems and the different physical modeling and design considerations needed for each.
- knowledge of any of the following would be advantageous:
previous experience in financial services management, analysis and reporting.
- self-motivated individual who enjoys technical challenges and takes pride in delivering high quality work in fast paced environment.
- capable of managing multiple projects concurrently while maintaining a high level of attention to detail on each project with mínimal supervision.
- ability to learn new technologies as needed to provide the best solutions to our customers.
- ability to work effectively in a team environment to encourage collaboration, innovation, and continuous improvement.