Pg Technology Jobs in Indiana (NOW HIRING)

Job Summary:
Alter Domus is a world leading provider of integrated solutions for the alternative investment industry. They are seeking a Senior DBA Engineer to join their Global IT Operations team, responsible for managing and optimizing Oracle and PostgreSQL databases, ensuring high availability and performance, and collaborating with stakeholders on database-related projects.
Responsibilities:
• 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
Qualifications:
Required:
• At least 4-5 years of experience in database administration
• Bachelor’s degree in computer science or a related field
• 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
• WebLogic Administration
• Understanding of monitoring and reporting platforms, and associated tasks or operations
• Being familiar with ITIL framework, tickets and Change management and associated workflows
• Proven experience in AWS Aurora PostgreSQL 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 CloudWatch, Enhanced Monitoring, and Performance Insights
• Analyze and interpret AWR, Statspack, and PgBadger reports to identify optimization opportunities
• Collaborate with Infrastructure teams to troubleshoot network-related issues including VPC, Subnet Groups, and DNS configurations
• Resolve issues related to PostgreSQL engine version upgrades and migrations
• Install, configure, and troubleshoot PostgreSQL Community and Enterprise editions (versions 13, 14) on Linux platforms
• Manage database access controls through PostgreSQL.conf and pg_hba.conf configuration files
• Create and maintain database objects including tables, indexes, and materialized views
• Monitor and resolve replication server errors to ensure data consistency
• Implement and execute comprehensive backup strategies using multiple methodologies
• Perform database restoration procedures and environment refreshes as required
• Configure and maintain streaming and logical replication for high availability
• Utilize diagnostic tools (pg_stat_database, pg_activity, pg_stat_statements) for proactive database monitoring and tuning
• Monitor system resources including mount point utilization, CPU, and memory consumption
• Execute routine maintenance operations including VACUUM/VACUUM FULL, ANALYZE, and reindexing procedures
• Maintain database currency through strategic patching and upgrades using pg_dump, pg_restore, and pg_upgrade
• Implement security best practices using Security Groups, Network ACLs, and role-based access controls
• Manage database roles, privileges, and user authentication protocols
• Configure event subscriptions for proactive alerting and monitoring
• Develop and maintain custom scripts tailored to specific operational requirements
• Implement automated backup solutions using cron jobs with appropriate retention policies
• Configure archival cleanup processes to maintain storage efficiency
• Deploy and manage PostgreSQL extensions to extend database functionality
• Team player with strong interpersonal skills
• Willingness to work with teams in multiple time zones
• Able to interact with all levels of management
• Experienced in manage challenging situations with key clients requirements and third party constrains, and expert in building consensus in such situations
• You are able to work under pressure and time constraints, and you maintain strict attention to detail in high-pressure situations
• Able to coordinate multiple 3rd party providers
• You are fluent in English
• Willing to travel when needed
• You are hands-on and not always play by the book.
Preferred:
• Experience with cloud services (AWS and Microsoft Azure) a plus
Company:
Alter Domus is a fully integrated Fund and Corporate services provider, dedicated to international private equity & infrastructure houses. Founded in 2003, the company is headquartered in Luxembourg, LUX, with a team of 5001-10000 employees. The company is currently Late Stage.