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