The position has the responsibility for researching, troubleshooting, and supporting multiple clients' applications located in LATAM region who uses a wide brand of technologies and environments. The role ofOracle Apps DBArequires the expertise and skills to diagnose serious issues and provide exceptional support for mission-critical applications as part of Platform Services Team.
Essential Responsibilities
Manage and maintain the organization's application databases, ensuring optimal performance, availability, and security.
Collaborate with developers to design, implement, and optimize database structures that align with application requirement.
Perform database tuning and optimization, including indexing, query analysis, and resource allocation to maximize efficiency.
Oversee database patching, upgrade, and migrations, ensuring minimal downtime and system reliability.
Ensure the backup and recovery plans to safeguard data integrity and support disaster recovery strategies.
Monitor database performance and proactively identify and resolve bottlenecks and issues
Implement and enforce database security policies, ensuring compliance with organizational and regulatory requirements.
Troubleshoot and resolve complex database issues in collaboration with development and infrastructure team.
Document database architectures, processes, and procedures to support operational and troubleshooting needs.
Provide technical guidance and support to application teams on database-related topics and best practices.
Provisioning of development and testing environments.
Work closely with development/dba team to fine tune SQL and PL/SQL code.
Work in conjunction with Unix Admins to support of root level activities.
Work in conjunction with Middleware team to support app/web servers level activities.
Respond promptly to incidents and service requests, diagnosing and resolving issues efficiently.
Participate in On-call support to ensure the highest standards of availability, resilience, integrity, security, and performance required by business.
Provide technical support and guidance to end-users of the application and databases.
Provide system information as requested during audits. Enforce policies and procedures.
Other job-related duties and responsibilities may be assigned from time to time.
Soft Skills and Expectations
Focus on customer support and the ability to build successful working relationships with Clients.
Excellent interpersonal, presentation and communication skills, verbal & written.
Extreme focus on Client satisfaction and client relationship management
Exceptional verbal and written communication.
English Language skills, both written and verbal are a must.
Ability to work calmly and professionally in high pressure situations.
Attention to detail and the ability to learn quickly.
Must be extremely comfortable interacting with customers.
Must have strong problem solving and troubleshooting skills.
Must be able to learn new software products and embrace new technology.
Trustworthy, reliable, and dependable.
Positive team player.
Basic Qualifications
Bachelor's degree in computer science, Information Technology or equivalent professional experience
5+ years of experience as a Database Administrator, preferably in application database environments.
Proficiency in database management systems such as Oracle and SQL Server.
Strong understanding of SQL, PL/SQL for query optimization and troubleshooting.
Experience with database performance tuning and monitoring tools.
Familiarity with backup and recovery solutions, HA and DR.
Knowledge of database security practices, including encryption, roles, and permissions.
Solid understanding of database design, normalization, and data modeling principles.
Experience working with ETL tools, APIs, or integration framework for data transformation.
Proficiency in LINUX/Unix operating systems
Demonstrated scripting skills through Python, Shells or others.
Excellent problem-solving skills and attention to detail in diagnosing and resolving issues.
Strong communication skills to collaborate effectively with developers and other IT teams.
------------------------------------------------------
Job Family Group:
Technology------------------------------------------------------
Job Family:
Systems & Engineering------------------------------------------------------
Time Type:
Full time------------------------------------------------------
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi") invite all qualified interested applicants to apply for career opportunities. 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 reviewAccessibility at Citi.
View the "EEO is the Law" poster. View theEEO is the Law Supplement.
View theEEO Policy Statement.
View thePay Transparency Posting