Overview
job summary -
looking for postgresql database administrator for one of largest fintech company in the world.
responsibilities
* 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 stakeholders 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.
requirement
* strong hands-on 6+ year experience in database administration of postgresql, developing, documenting, and advocating best practices.
* 2+ years 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, 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 minimal 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.
#j-18808-ljbffr