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 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.
Want more jobs like this?
Get jobs in Guadalajara, Mexico delivered to your inbox every week.
- 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 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.