The Application DBA role is for Canada Location to develop, design, tune and support both non-prod and production oracle databases for one of our critical data driven applications in the Markets business unit, is highly sensitive and responsible to various stakeholders who uses daily market data for their various monetary key functions, thereby this APP DBA is critical position and has more responsibility to have the environment very stable with high availability and high performance. Hereunder, the expectation of necessary skills to perform this key role during NAM time zone and also to cover IST time zone as per backup plan during India Holidays.
Responsibilities:
- Hands on experience in Development / Design, Data Model, Performance tunings and troubleshooting across leading Databases in large scale applications / project teams.
- Having at least 8+ Yrs Hands on experience in Development, Design, Data Model, Performance tunings in Oracle Databases in large scale applications / project teams.
- Having hands on experience in oracle GOLDEN Gate.
- Having experience Data Management; data strategy, migration, masking, archival,….
- Having experience and good knowledge in unix, shell scripting…
- Having experience and good knowledge in Microservice, AI tools, big data, hadoop, AWS S3 and tool and techniques
- Having experience in SDLC – Agile, Scrum…., Jenkin, Bitbucket, jira, Udeploy…..
- Utilize in-depth knowledge and skills across multiple Applications Development areas to provide technical oversight across systems and applications.
- Provide evaluative judgment based on analysis of factual data in complicated and unique situations!
- Ensure essential procedures are followed and contribute to defining standards negotiating with external parties when necessary.
DBA skill:
- DB schema & Environment stability Management for both non-prod and prod databases.
- Proactively monitor the DB health and take appropriate actions timely manner using tools & techniques.
- Review and implement various strategies for betterment – for eg: Data strategy!
- Adoption of new tools and technologies
- Recommend / provide necessary technical advisory.
- Introduce appropriate features in Oracle for betterment.
- Co-ordinate Application team, DBA, Oracle teams for timely solutions for critical / unknown issues.
- Run various reports (AWR, advisory) for monitoring and control
Management Skill:
- Having experience in managing both functional and non-functional requirements
- Strong analytical and problem-solving skills to validate and prioritize requirements.
- Release management, pro-active and re-active skills
- Schema & Data Management
- Environment and Stability Management
- Capacity Management
- Tech advisory within and beyond teams
- Risk management -- identify, assessment, prioritize and mitigate in timely manners.
- Review and Implement best practices -- standard, processes and procedures
Qualifications:
- 6-10 years of relevant experience in Apps Development and database analysis role
- Extensive experience system analysis and in programming of software applications
- Experience in managing and implementing successful projects
- Subject Matter Expert (SME) in at least one area of Application Database Development and Analysis
- Ability to adjust priorities quickly as circumstances dictate
- Demonstrated leadership and project management skills
- Consistently demonstrates clear and concise written and verbal communication
Education:
- Bachelor’s degree/University degree or equivalent experience
- Master’s degree preferred
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
Job Family Group:
Technology
------------------------------------------------------
Job Family:
Applications Development
------------------------------------------------------
Time Type:
Full time
------------------------------------------------------
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View the "EEO is the Law" poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting
