Architecture Senior Analyst – DBA and Goldengate, Citi

Citi

Location:
India, Pune

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Job Responsibility:

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
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

Requirements:

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
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
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
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
Leadership, Ownership and Accountability
Excellent Communication
Very good analytical skills
Multi-tasking
Project Management
Team player & cross functional team interactions
Experience with financial firms

Additional Information:

Job Posted:
April 29, 2025

Employment Type:

Fulltime

Work Type:

Hybrid work

View All Jobs In This Company

Job Link Share:

Architecture Senior Analyst – DBA and Goldengate