CrawlJobs Logo
Citi Logo Citi · IT - Software Development

Architecture Senior Analyst – DBA and Goldengate

India, Pune · Job Posted April 29, 2025

Job offer has expired

Job Link Share

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
Citi - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Architecture Senior Analyst – DBA and Goldengate

8 matching positions

New

Entry Level Manager Trainee

The Manager Trainee is a full-time, entry-level position designed to prepare you...
Location
Location
United States , Las Vegas
Salary
Salary:
46000.00 - 50000.00 USD / Year ▼
84 lumber
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Education: High school diploma or GED equivalent
  • Availability: Full-time schedule (48+ hours/week, overtime included)
Job Responsibility
Job Responsibility
  • Payroll, Invoicing, Inventory and POS Systems
  • Microsoft Office Suite (previous experience preferred)
  • Interpreting and analyzing common financial reports
  • Reading blueprints and creating material lists
  • Responding to common inquiries or complaints from customers
What we offer
What we offer
  • Monthly performance incentives (both store and personal-level bonus potential)
  • Paid Time Off (PTO), sick and personal days
  • Medical, dental and vision insurance
  • Holiday pay
  • Flexible Spending Accounts (FSA) for medical and dependent care
  • Annual profit sharing and 401(k) with employer match (based on company profits)
  • Discounts on building materials and other retail partnerships
  • Fulltime
Read More
Arrow Right
New

L3 Technical Support Consultant - APAC

We are looking for a L3 Technical support consultant to join our professional an...
Location
Location
Colombia , Bogotá
Salary
Salary:
Not provided
3shape.com Logo
3Shape
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • More than 3 years of experience in advanced technical support, preferably in medical or dental technology environments
  • 3rd line, externally facing technical support role
  • Solid background in handling complex, escalated cases
  • Self-driven, able to work independently and own tickets end to end
  • Customer centric approach, with clear and empathetic communication
  • Strong root cause analysis and problem-solving skills
  • Technical background important, but often a people person with great technical skills is better suited than an out and out technical
  • Ability to mentor new employees and coordinate their learning process
  • Knowledge of case management tools, technical support platforms, and CRM systems
  • Advanced English (written and spoken), with the ability to interact in a global professional environment.
Job Responsibility
Job Responsibility
  • To provide advanced technical solutions to complex problems related to products, ensuring customer satisfaction
  • Manage escalation processes, properly document cases and ensure their prompt resolution, working together with the relevant areas
  • Provide guidance and support to new employees, ensuring their proper integration into the team and transfer of technical knowledge
  • Develop, update, and improve articles in the knowledge base, facilitating the resolution of recurring problems
  • Identify areas of opportunity and propose improvements to optimize processes and results
  • Participate in the planning and execution of internal training to strengthen the team's technical skills
  • Working effectively in multicultural environments, ensuring alignment with global best practices
  • Provide product feedback to the Product Management and Development teams.
  • Fulltime
Read More
Arrow Right
New

Junior Accountant, Accounts Payable

Join one of the most exciting Danish tech companies in the medical device indust...
Location
Location
Poland , Szczecin
Salary
Salary:
Not provided
3shape.com Logo
3Shape
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Around 1 year of experience in Accounting / Accounts Payable and strong willingness to develop in this area
  • Good command of English (B1/B2) – used in day-to-day communication
  • Basic understanding of accounting principles is an advantage
  • Good knowledge of MS Office (especially Excel)
  • ERP experience is a plus
  • University degree in Finance, Accounting or similar
  • Attention to detail and accuracy
  • Good organisational skills and ability to prioritise tasks
  • Positive, proactive attitude and willingness to learn
  • Strong communication and teamwork skills
Job Responsibility
Job Responsibility
  • Processing and entering supplier invoices into the accounting system
  • Supporting end-to-end invoice processing (verification, approval flow, posting)
  • Maintaining and updating vendor master data
  • Performing supplier account reconciliations and supporting issue resolution
  • Handling queries from suppliers and internal stakeholders (via email and ticketing tools)
  • Supporting smooth daily operations within the Accounts Payable team
  • Cooperating with internal departments (e.g. Procurement, Finance) to ensure timely processing
What we offer
What we offer
  • Attractive office with relax zones located in Szczecin, Poland
  • A vibrant and international environment with social, diverse, and highly skilled and cooperative colleagues
  • An attractive Luxmed healthcare package with additional dentistry care
  • Fresh fruits, delicious and healthy lunches cooked by our canteen
  • We provide a great social work environment with many optional activities
  • Good work/life balance
  • Hybrid work possibility
  • Language courses with qualified teachers
  • Fulltime
Read More
Arrow Right
New

Product Owner II

We are looking for a Product Owner II to guide product delivery and ensure busin...
Location
Location
United States , Dallas
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of experience in product management, product ownership, or a closely related role
  • Hands-on experience working with Agile Scrum teams throughout the product development lifecycle
  • Strong ability to manage backlog grooming, prioritization, and sprint-ready work preparation
  • Proven skill in translating business requirements into technical tasks and user stories
  • Proficiency with Atlassian Jira for backlog administration, workflow tracking, and issue management
  • Experience with bug tracking, defect prioritization, and coordination with development teams on resolution
  • Effective communication skills with the ability to work across business and technical stakeholders
Job Responsibility
Job Responsibility
  • Shape and prioritize the product backlog so development efforts remain focused on the highest-value work
  • Convert business objectives and user needs into well-defined stories, acceptance criteria, and delivery plans for technical teams
  • Collaborate daily with engineers, Scrum team members, and stakeholders to clarify scope, remove ambiguity, and support execution
  • Help drive sprint planning and refinement activities to maintain alignment between roadmap commitments and team capacity
  • Review defects, triage issues, and partner with teams to track resolution and improve product quality
  • Use Jira and related tools to manage work items, monitor progress, and maintain visibility into delivery status
  • Gather input from business partners and incorporate feedback into product decisions and backlog updates
  • Support Agile ceremonies and encourage practices that improve team efficiency, transparency, and delivery outcomes
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • Enrollment in company 401(k) plan
Read More
Arrow Right
New

Finishing Joiner

We are looking for a skilled and experienced Finishing Joiner for an immediate s...
Location
Location
United Kingdom , Leeds
Salary
Salary:
23.00 - 24.00 GBP / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
June 26, 2026
Flip Icon
Requirements
Requirements
  • A valid Blue or Gold CSCS Card (Skilled/Advanced)
  • Your own full PPE and high-quality tools for first-class finishing work
  • Proven experience in high-end second fix and finishing joinery
  • Reliability, punctuality, and an eye for detail
  • Fulltime
Read More
Arrow Right
New

Forklift Driver (Fld) / Telehandler Operator

Randstad CPE team are seeking a highly skilled and safety-conscious Forward Tipp...
Location
Location
United Kingdom , Fordingbridge
Salary
Salary:
19.50 - 21.50 GBP / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
August 25, 2026
Flip Icon
Requirements
Requirements
  • Valid CPCS Card or NPORS card (with CSCS logo) for Telescopic Handler (All Sizes)
  • Minimum of 2-3 years of consistent experience operating a telehandler on fast-paced residential or major housing developments
  • Excellent spatial awareness and a flawless safety record on site
  • Full UK Driving License
  • Full PPE (Hard hat, high-vis, steel toe cap boots)
Job Responsibility
Job Responsibility
  • Safely operating the telehandler machine to load, unload, transport, and stack materials across the site
  • Distributing materials to various plots and assisting bricklayers, joiners, and roofers by placing packs exactly where they need them
  • Conducting daily pre-start safety checks on the vehicle, maintaining logbooks, and reporting any defects immediately
  • Assisting the site management team with general logistics and occasionally stepping out of the cab to help manage materials if required
Read More
Arrow Right
New

Part 2 Scaffolder

Job title: Part 2 scaffolder. Location: Brighton. Duration: Start Monday 1st Jun...
Location
Location
United Kingdom , Brighton
Salary
Salary:
17.00 - 18.00 GBP / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
June 26, 2026
Flip Icon
Requirements
Requirements
  • CSCS Card, part 2 scaffolding
  • PPE (personal protective equipment)
  • Previous experience working on a construction site (Ideally commercial or residential)
Job Responsibility
Job Responsibility
  • Under the supervision of the Main contractor Site manager
  • The project is a commercial build and has a 2 year duration
  • Parttime
Read More
Arrow Right
New

Telehandler

Randstad is recruiting for an experienced telehandler operator to join an active...
Location
Location
United Kingdom , Bath
Salary
Salary:
20.00 GBP / Hour
https://www.randstad.com Logo
Randstad
Expiration Date
August 25, 2026
Flip Icon
Requirements
Requirements
  • A current CPCS or NPORS card is essential
  • Full PPE: Hard hat, high-vis, and steel-toe boots
  • Proven Experience: You'll need solid references from your previous contractors
  • Reliability: You show up early, work hard, and operate safely
Job Responsibility
Job Responsibility
  • Precision Operating: Safe and efficient operation of the Telehandler/Forklift
  • Trade Support: Supplying materials to various trades to keep the workflow steady
  • Complex Lifts: Assisting with a variety of lifts and moving bulk materials across site
  • Collaboration: Working closely with the site management team and ground crews
Read More
Arrow Right