ABOUT US: As a world leading provider of integrated solutions for the alternative investment industry, Alter Domus (meaning “The Other House” in Latin) is proud to be home to 90% of the top 30 asset managers in the private markets, and more than 6,000 professionals across 24 jurisdictions. With a deep understanding of what it takes to succeed in alternatives, we believe in being different in what we do, how we work, and most importantly in how we enable and develop our people. Invest yourself in the alternative, and join an organization where you progress on merit, where you can speak openly with whoever you are speaking to, and where you will be supported along whichever path you choose to take. Find out more about life at Alter Domus at careers.alterdomus.com JOB DESCRIPTION: We are looking for Oracle and PostgreSQL DBA to join the Global IT Operations team. The scope of his/her work will be to participate in all database related projects, in an execution and coordination role with external parties. Your role: <ul> <li style="font-size:12.0pt">Provide hands-on expertise on systems related projects and participate on the daily tickets activity </li> <li style="font-size:12.0pt">Deploy and troubleshoot various types of network elements, infrastructure services and platforms </li> <li style="font-size:12.0pt">Build database systems of high availability </li> <li style="font-size:12.0pt">Install, upgrade and manage database applications </li> <li style="font-size:12.0pt">Develop processes for optimizing database security </li> <li style="font-size:12.0pt">Monitor database performance, implement changes and apply new patches and versions when required </li> <li style="font-size:12.0pt">Performance tuning of database systems </li> <li style="font-size:12.0pt">Diagnose and troubleshoot database errors </li> <li style="font-size:12.0pt">Manage database access </li> <li style="font-size:12.0pt">Manage clear communication of progress/status with project stakeholders </li> <li style="font-size:12.0pt">Anticipate and evaluate risks </li> <li style="font-size:12.0pt">Comprehend complex technical details and relay information to both technical and business stakeholders </li> <li style="font-size:12.0pt">Creation of requirement documents upon completion of each project </li> <li style="font-size:12.0pt">Drive urgency towards customer lab/field issues with the support organization and internal development teams </li> <li style="font-size:12.0pt">Maintains safe and clean working environment by enforcing procedures, rules, and regulations </li> <li style="font-size:12.0pt">Reporting and resolution of issues, risks and dependencies, proactively identifying potential planning gaps, suggesting mitigations to risks, actions to close issues or complete open items </li> <li style="font-size:12.0pt">24x7 Support for Critical systems when required </li> </ul> Technical Competencies: Oracle: <ul> <li style="font-size:12.0pt">Experience in installing Oracle Software of different versions like 11g,12c,19c,21c on various Operating Systems. </li> <li style="font-size:12.0pt">Responsible for the daily maintenance tasks and Health Check of all Oracle databases. </li> <li style="font-size:12.0pt">Manage Control files and Redolog files </li> <li style="font-size:12.0pt">Manage Table spaces, Datafiles and other database objects </li> <li style="font-size:12.0pt">Experience with backup and recovery planning and implementation in Oracle environments using RMAN. </li> <li style="font-size:12.0pt">Experience working with Oracle utilities, like, RMAN, Exp/Imp/DATAPUMP. </li> <li style="font-size:12.0pt">Monitor Alert log for error information. </li> <li style="font-size:12.0pt">Storage and space management including table spaces and data files. </li> <li style="font-size:12.0pt">Database Migration from Windows to Linux with 12cR2 version. </li> <li style="font-size:12.0pt">Database cloning using RMAN. </li> <li style="font-size:12.0pt">Data Guard Configuration (Physical Standby). </li> <li style="font-size:12.0pt">Generate AWR and ADDM report. </li> <li style="font-size:12.0pt">Work with OEM 11g,13c. </li> <li style="font-size:12.0pt">RMAN cloud backup, restore, recovery using OSB. </li> <li style="font-size:12.0pt">Database Patching using Opatch utility. </li> <li style="font-size:12.0pt">Automate and schedule database monitoring scripts using shell scripts. </li> <li style="font-size:12.0pt">Goldengate installation and administration. </li> <li style="font-size:12.0pt">Knowledge of Linux/Unix operating systems and shell scripting. </li> <li style="font-size:12.0pt">Knowledge of RAC installation and administration. </li> <li style="font-size:12.0pt">WebLogic Administration </li> <li style="font-size:12.0pt">Understanding of monitoring and reporting platforms, and associated tasks or operations </li> <li style="font-size:12.0pt">Being familiar with ITIL framework, tickets and Change management and associated workflows. </li> </ul> PostgreSQL: <ul> <li style="font-size:12.0pt">Proven experience in AWS Aurora PostgreSQL deployment, configuration, and ongoing administration </li> <li style="font-size:12.0pt">Design, launch, and configure Amazon RDS instances with appropriate specifications and parameters </li> <li style="font-size:12.0pt">Perform comprehensive database maintenance including vacuuming, indexing, and query optimization </li> <li style="font-size:12.0pt">Monitor and enhance database performance through systematic analysis and tuning </li> <li style="font-size:12.0pt">Monitor database health and diagnose performance bottlenecks using CloudWatch, Enhanced Monitoring, and Performance </li> <li style="font-size:12.0pt">Insights </li> <li style="font-size:12.0pt">Analyze and interpret AWR, Statspack, and PgBadger reports to identify optimization opportunities </li> <li style="font-size:12.0pt">Collaborate with Infrastructure teams to troubleshoot network-related issues including VPC, Subnet Groups, and DNS </li> <li style="font-size:12.0pt">configurations </li> <li style="font-size:12.0pt">Resolve issues related to PostgreSQL engine version upgrades and migrations </li> <li style="font-size:12.0pt">Install, configure, and troubleshoot PostgreSQL Community and Enterprise editions (versions 13, 14) on Linux platforms </li> <li style="font-size:12.0pt">Manage database access controls through PostgreSQL.conf and pg_hba.conf configuration files </li> <li style="font-size:12.0pt">Create and maintain database objects including tables, indexes, and materialized views </li> <li style="font-size:12.0pt">Monitor and resolve replication server errors to ensure data consistency </li> <li style="font-size:12.0pt">Implement and execute comprehensive backup strategies using multiple methodologies: </li> <li style="font-size:12.0pt">Logical backups via pg_dump and pg_dumpall </li> <li style="font-size:12.0pt">Physical backups using pg_basebackup </li> <li style="font-size:12.0pt">Incremental and differential backups with pg_backrest </li> <li style="font-size:12.0pt">AWS RDS snapshots for point-in-time recovery </li> <li style="font-size:12.0pt">Perform database restoration procedures and environment refreshes as required </li> <li style="font-size:12.0pt">Configure and maintain streaming and logical replication for high availability </li> <li style="font-size:12.0pt">Utilize diagnostic tools (pg_stat_database, pg_activity, pg_stat_statements) for proactive database monitoring and tuning </li> <li style="font-size:12.0pt">Monitor system resources including mount point utilization, CPU, and memory consumption </li> <li style="font-size:12.0pt">Execute routine maintenance operations including VACUUM/VACUUM FULL, ANALYZE, and reindexing procedures </li> <li style="font-size:12.0pt">Maintain database currency through strategic patching and upgrades using pg_dump, pg_restore, and pg_upgrade </li> <li style="font-size:12.0pt">Implement security best practices using Security Groups, Network ACLs, and role-based access controls </li> <li style="font-size:12.0pt">Manage database roles, privileges, and user authentication protocols </li> <li style="font-size:12.0pt">Configure event subscriptions for proactive alerting and monitoring </li> <li style="font-size:12.0pt">Develop and maintain custom scripts tailored to specific operational requirements </li> <li style="font-size:12.0pt">Implement automated backup solutions using cron jobs with appropriate retention policies </li> <li style="font-size:12.0pt">Configure archival cleanup processes to maintain storage efficiency </li> <li style="font-size:12.0pt">Deploy and manage PostgreSQL extensions to extend database functionality </li> </ul> Your profile: <ul> <li style="font-size:12.0pt">At least 4-5 years of experience in database administration </li> <li style="font-size:12.0pt">Bachelor’s degree in computer science or a related field </li> <li style="font-size:12.0pt"> Experience with cloud services (AWS and Microsoft Azure) a plus </li> <li style="font-size:12.0pt">Team player with strong interpersonal skills </li> <li style="font-size:12.0pt">Willingness to work with teams in multiple time zones </li> <li style="font-size:12.0pt">Able to interact with all levels of management </li> <li style="font-size:12.0pt">Experienced in manage challenging situations with key clients requirements and third party constrains, and expert in building consensus in such situations </li> <li style="font-size:12.0pt">You are able to work under pressure and time constraints, and you maintain strict attention to detail in high-pressure situations </li> <li style="font-size:12.0pt">Able to coordinate multiple 3rd party providers </li> <li style="font-size:12.0pt">You are fluent in English </li> <li style="font-size:12.0pt">Willing to travel when needed </li> <li style="font-size:12.0pt">You are hands-on and not always play by the book. </li> </ul> WHAT WE OFFER: We are committed to supporting your development, advancing your career, and providing benefits that matter to you. Our industry-leading Alter Domus Academy offers six learning zones for every stage of your career, with resources tailored to your ambitions and resources from LinkedIn Learning. Our global benefits also include: <ul> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">Support for professional accreditations </li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">Flexible arrangements, generous holidays, plus an additional day off for your birthday!</li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">Continuous mentoring along your career progression </li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">Active sports, events and social committees across our offices </li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">24/7 support available from our Employee Assistance Program </li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">The opportunity to invest in our growth and success through our Employee Share Plan </li> <li style="font-family:tahoma, arial, helvetica, sans-serif;font-size:12.0pt">Plus additional local benefits depending on your location </li> </ul> Equity in every sense of the word: We are in the business of equity, in every sense of the word. For us, this means taking action to ensure every colleague has equal opportunity, valuing every voice and experience across our organisation, maintaining an inclusive culture where you can bring your whole self to work, and making Alter Domus a workplace where everyone feels they belong. We celebrate our differences, and recognise that our success relies on diverse perspectives and experiences, as we work towards shared goals and a common purpose. We take pride in creating a workplace where all our people are empowered to be truly invested in the alternative and bring their whole selves to work. We are committed to ensuring a welcomling recruiting and onboarding process for everyone. Please contact our hiring team if you require any accommodations to make our recruitment process more accessible for you. Alter Domus is an Equal Opportunity Employer: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status. (Alter Domus Privacy notice can be reviewed via Alter Domus webpage: <a style="color:#0563c1;text-decoration:underline" title="https://alterdomus.com/privacy-notice/" href="https://alterdomus.com/privacy-notice/" target="_blank" rel="noopener">https://alterdomus.com/privacy-notice/</a>) #LI-HYBRID #LI-DH1

Senior DBA Engineer (Carmel, US) @ Alter Domus Participations SARL

About this role

Ready to apply?