Heredia, CRI
41 days ago
DBA Database Administrator
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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
Confirmar seu email: Enviar Email