Senior DBA Engineer

About the role

We are looking for an 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.

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
• Maintain 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
• Create requirement documents upon completion of each project
• Drive urgency towards customer lab/field issues with the support organization and internal development teams
• Report and resolve 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

Oracle Technical Competencies

• 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

PostgreSQL

• 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
• 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
• 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

Qualifications

• At least 4-5 years of experience in database administration
• Bachelor’s degree in computer science or a related field
• Experience with cloud services (AWS and Microsoft Azure) a plus
• Team player with strong interpersonal skills
• Able to interact with all levels of management
• Experienced in managing challenging situations with key client requirements and third party constraints, and expert in building consensus in such situations
• Able to work under pressure and time constraints, and maintain strict attention to detail in high-pressure situations
• Able to coordinate multiple 3rd party providers
• Fluent in English
• Able to travel when needed
• Hands-on and not always play by the book