Senior DBA Engineer

Alter Domus • Carmel-by-the-Sea, CA

1d • Hybrid

About The Position

We are looking for an Oracle and PostgreSQL DBA to join the Global IT Operations team. The scope of this role will be to participate in all database-related projects, in an execution and coordination role with external parties. This role involves providing hands-on expertise on systems-related projects and participating in daily ticket activity. The DBA will deploy and troubleshoot various network elements, infrastructure services, and platforms. Key responsibilities include building highly available database systems, installing, upgrading, and managing database applications, and developing processes for optimizing database security. The role also requires monitoring database performance, implementing changes, applying patches and versions, performance tuning, diagnosing and troubleshooting errors, and managing database access. Effective communication of progress and status with project stakeholders, anticipating and evaluating risks, and comprehending complex technical details to relay information to both technical and business stakeholders are crucial. The DBA will also be responsible for creating requirement documents, driving urgency for customer issues, maintaining a safe working environment, and reporting/resolving issues, risks, and dependencies. 24x7 support for critical systems is required when necessary.

Requirements

• 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: Logical backups via pg_dump and pg_dumpall, Physical backups using pg_basebackup, Incremental and differential backups with pg_backrest, AWS RDS snapshots for point-in-time recovery
• 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
• At least 4-5 years of experience in database administration
• Bachelor’s degree in computer science or a related field
• 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

Nice To Haves

• Experience with cloud services (AWS and Microsoft Azure) a plus
• Willing to travel when needed
• You are hands-on and not always play by the book.

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

Benefits

• Support for professional accreditations
• Flexible arrangements
• Generous holidays
• An additional day off for your birthday
• Continuous mentoring along your career progression
• Active sports, events and social committees across our offices
• 24/7 support available from our Employee Assistance Program
• The opportunity to invest in our growth and success through our Employee Share Plan
• Additional local benefits depending on your location

What This Job Offers

• Job Type: Full-time
• Career Level: Senior