Senior DBA Engineer Job Carmel area,Indiana USA,IT/Tech

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

JOB DESCRIPTION:

We are looking for Oracle and Postgre

SQL 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 :

Provide hands‑on expertise on systems related projects and participate on the daily tickets activity
Deploy and troubleshoot various types of network elements, infrastructure services and platforms
Build database systems of high availability
Install, upgrade and manage database applications
Develop processes for optimizing database security
Monitor database performance, implement changes and apply new patches and versions when required
Performance tuning of database systems
Diagnose and troubleshoot database errors
Manage database access
Manage clear communication of progress/status with project stakeholders
Anticipate and evaluate risks
Comprehend complex technical details and relay information to both technical and business stakeholders
Creation of requirement documents upon completion of each project
Drive urgency towards customer lab/field issues with the support organization and internal development teams
Maintains safe and clean working environment by enforcing procedures, rules, and regulations
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
24x7 Support for Critical systems when required

Technical

Competencies:

Oracle:

Experience in installing Oracle Software of different versions like 11g,12c,19c,21c on various Operating Systems.
Responsible for the daily maintenance tasks and Health Check of all Oracle databases.
Manage Control files and Redolog files
Manage Table spaces, Datafiles and other database objects
Experience with backup and recovery planning and implementation in Oracle environments using RMAN.
Experience working with Oracle utilities, like, RMAN, Exp/Imp/DATAPUMP.
Monitor Alert log for error information.
Storage and space management including table spaces and data files.
Database Migration from Windows to Linux with 12cR2 version.
Database cloning using RMAN.
Data Guard Configuration (Physical Standby).
Generate AWR and ADDM report.
Work with OEM 11g,13c.
RMAN cloud backup, restore, recovery using OSB.
Database Patching using Opatch utility.
Automate and schedule database monitoring scripts using shell scripts.
Goldengate installation and administration.
Knowledge of Linux/Unix operating systems and shell scripting.
Knowledge of RAC installation and administration.
Web Logic Administration
Understanding of monitoring and reporting platforms, and associated tasks or operations
Being familiar with ITIL framework, tickets and Change management and associated workflows.

Postgre

SQL:

Proven experience in AWS Aurora Postgre

SQL deployment, configuration, and ongoing administration
Design, launch, and configure Amazon RDS instances with appropriate specifications and parameters
Perform comprehensive database maintenance including vacuuming, indexing, and query optimization
Monitor and enhance database performance through systematic analysis and tuning
Monitor database health and diagnose performance bottlenecks using Cloud Watch, Enhanced Monitoring, and Performance Insights
Analyze and interpret AWR, Statspack, and PgBadger reports to identify optimization opportunities
Collaborate with Infrastructure…