Oracle DBA / Developer (VP Level)

Job Overview : Citi is seeking a highly experienced Oracle DBA / Developer (VP Level) to lead and support application database initiatives across its Reference Data applications. This role involves hands-on development, performance tuning, architecting resilient database solutions, and guiding junior team members. Ideal candidates will have deep experience in Oracle databases, GoldenGate, performance tuning, and modern DevOps tools. Key Responsibilities : Lead application database administration and development efforts. Modify and optimize data models (logical & physical), implement changes, and build CI / CD deployment packages using tools like Client Project. Promote changes to UAT, Production, and COB environments using SDLC practices. Architect and implement resilient and high-performance database solutions. Diagnose and resolve performance issues using tools like AWR, ADDM, ASH. Administer and optimize Oracle 19c / 23ai, including development of procedures, triggers, packages, and indexes. Collaborate on the design of data warehouses, star schemas, and normalization. Administer Oracle RAC, ASM, and ACFS on RedHat Linux (RHEL 7 / 8) systems. Support implementation and maintenance of Oracle GoldenGate 12c / 19c / 23ai. Use DevOps tools such as UDeploy, Ansible, Autosys, and scripting in Shell / Python. Manage database compression, purging, and retention strategies. Participate in weekend deployments, ensuring stability and uptime. Provide mentorship and leadership to mid-level DBAs and developers. Engage cross-functional teams to integrate systems and deploy enhancements. Ensure adherence to regulatory and security standards including TPAM, CyberArk, and ServiceNow usage. Required Skills & Technologies : Databases : Oracle 19c / 23ai, MySQL, PostgreSQL, MS SQL Server, Sybase, MongoDB Scripting / Tools : PL / SQL, T-SQL, Shell Scripting, Python, Ansible Infrastructure : RHEL 7 / 8, Oracle RAC / ASM / ACFS Integration & DevOps : Oracle GoldenGate, UDeploy, Autosys, ServiceNow, Client Project Security : TPAM, CyberArk Data Modeling : Entity-Relationship Modeling, Star Schema, Normalization Performance Tuning : AWR, ADDM, ASH reports, Index tuning Strong understanding of SDLC, Release on Demand, and Change Control Management Qualifications : 12+ years of experience in Application DBA and database performance tuning. Proven experience with Oracle GoldenGate and designing high availability systems. Strong project leadership, team collaboration, and mentoring abilities. Ability to manage complex priorities and deliver results in a fast-paced environment. Excellent verbal and written communication skills. Education : Bachelor's degree in computer science, Information Technology, or related field (required) Master's degree (preferred) Soft Skills : Leadership and initiative-taking Strong sense of ownership and accountability Team-oriented with a collaborative mindset Effective communication and problem-solving abilities