Responsibilities:
expert technical consultant - database sme for disaster recovery team
job description/responsibilities
responsibilities include but not limited to:
- maintain synchronization between production & dr environments for payments products, ensure changes /configurations implemented in production are simultaneously implemented in dr environment, the replication is in healthy state on a real time basis.
- sop creation as per industry best standards for week long true failovers, ensuring customer can run their business seamlessly from dr environment for a week.
- ensure documentation (deployment diagrams, internal and client facing runbooks) are timely updated, maintained and peer reviewed.
- when production/uat issues reported by the client and/or implementation team are addressed within acceptable timelines ensure the same changes are implemented in dr simultaneously.
- ability to debug database logs and produce technical solutions associated with data flow or processes involved or performance aspects.
- work closely with the implementation team to understand the process flow, solution challenges if any and work towards implementing & supporting a seamless sync between production & dr infrastructure.
- work closely with the implementation & product teams to explore & reuse tools/processes for effective maintenance of dr environment.
- ensure automation is introduced wherever possible to reduce system stability time post failover to dr.
- should focus towards acquiring adequate understanding of the technical & functional aspects/flows of the implemented products within short span of time.
- regular internal health checkups, internal tests are performed prior client facing dr tests and maintain high level resiliency.
- be able to effectively participate in dr plannings, work on rca's, provide dr updates and identify risks with mitigation plans.
- be flexible to learn, collaborate & contribute across teams.
the required skills, knowledge & experience
must have:
- exposure to payments domain and finastra payments products i.e., gpp or p2g is an added advantage.
- willingness to work in shifts and provide on-call support on rotation including weekends.
- experience as a database administrator (oracle & sql) or similar role, should possess fair knowledge across multiple platforms such as linux, windows on azure.
- experience in generating oracle reports and addressing issues pertaining to it, should have knowledge of weblogic & ibm websphere reports.
- hands on knowledge and experience in mysql, microsoft sql server, version:12c, 19c, 21c etc.
& postgresql.
- should have good knowledge and hands on experience of dataguard technology.
exadata knowledge is preferred.
- familiarity with general monitoring principles, as well as tools such as site 24 x 7, grafana, etc.
experience in different automation concepts (ex.
ci/cd, infra as code) and devops tools (ex.
azure devops, jenkins, docker, terraform, chef, etc).
strong communication skills both written and verbal, should be able to co-ordinate with cross functional teams.
good to have:
- experience in cloud technologies such as azure and aws.
- familiarity with atlassian tools such as jira, snow and confluence.
- technical consulting and implementation experience in client facing projects is an added advantage.