Responsibilities:
Make changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages and promote them to higher environments (UAT, Production and Cob) following SDLC
Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes using Oracle 19c
Should be able to help in finding current issues and provide solutions to improve performance
Working knowledge of Linux Redhat, File System, Cluster Management and Oracle ASMC and ACFS
System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc
Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout
Ensure weekend activities complete successfully through assignment, coordination, oversight and validation. This may require weekend work.
Experience with Oracle Golden Gate 19c implementation and support will be an added advantage
Along with above technical requirements candidate will get opportunities to work with existing team on
Applications Support:
Respond to customer requests regarding outages, performance degradation and project status.
Maintain flexible work schedules, which may include evenings, weekends or holidays to work on deployments or regularly scheduled maintenance.
Resolve customer technical issues through diligent research, reproduction and troubleshooting.
Document all technical inquiries, develop and review content for knowledgebase using tool set.
Work directly with other team members to resolve problems in a timely manner.
Develop work schedules and project plans in support of various App Dev requests.
Maintain server, software, licenses and other inventories.
Ensure weekend activities complete successfully through assignment, coordination,



oversight and validation and Checkout. This may require weekend work.
Desired skills
10+ years of working experience.
Experience with private or public cloud database solutions.
Experienced as Solutions Architect to meet business needs.
Concepts and architectural expertise with commercial RDBMS systems.
Oracle, SQL Server, MongoDB, MS SQL, PostgreSQL
Experience with database high availability solutions and architecture.
ISG being Oracle heavy shop –
Expert on Oracle concepts and architecture.
Expert on Oracle RAC systems.
Experience with Oracle Data Guard and database backups
Expert on data compression and table partitioning techniques
Expert on database performance tuning
Expert on database monitoring, alerting and resolution automation.
Expert on database release management, coordination, and automated execution.
Database upgrades, migrations, and PSU maintenance.
Expert on SQL and shell scripting.
Experienced with database automation tasks to reduce MPT.
Tablespace resizing, automated DR failover/switchover.
Risk & Control –
Audit and compliance monitoring and resolution.
Familiar with regulatory mandates – OCC, App-J compliance.
Experience with Service Now, Autosys, AppDynamics and CyberArk.
Experience with data replication technologies, Oracle Golden Gate
Design solution and implementation
Familiar with Hub and Spoke Architecture.
Experience with Uni-directional or Bi-directional replications.(One to many and many to one replication).
Experience with data discrepancies,



troubleshooting and remediation.
Automation of replication monitoring and alerting techniques.
Experience with Database Encryption – Oracle, MS SQL Server, MongoDB
Design solution and implementation.
Database Key Generation & external key stores (HSM – Hardware Security Module).
Encrypted key corruptions and restoration techniques.
Disaster recovery of HSM appliance (external key stores).
Knowledge of HSM upgrades and maintenance.
Knowledge or experience with database storage devices (SAN, Scale IO)
Knowledge or experience with database networking
Soft skill sets –
Leadership, Ownership and Accountability
Excellent Communication
Very valuable analytical skills
Multi-tasking
Project Management
Team player & cross functional team interactions
Experience with financial firms.
Education:
Bachelor's degree/University degree or equivalent experience
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 employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
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 Citi's
EEO Policy Statement
and the
Know Your Rights
poster.

📌 Avp Architecture Senior Analyst Dba And Goldengate (Maharashtra)
🏢 Citi
📍 Maharashtra