Job Description
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 of
Oracle Apps DBA requires 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
------------------------------------------------------
Most Relevant Skills
Please see the requirements listed above.
------------------------------------------------------
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
------------------------------------------------------
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
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 review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.