(3 Days Left) Senior Dba

About Aeris For more than three decades Aeris has been a trusted cellular IoT leader enabling the biggest IoT programs and opportunities across Automotive Utilities and Energy Fleet Management and Logistics Medical Devices and Manufacturing Our IoT technology expertise serves a global ecosystem of 7 000 enterprise customers and 30 mobile network operator partners and 80 million IoT devices across the world Aeris powers today s connected smart world with innovative technologies and borderless connectivity that simplify management enhance security optimize performance and drive growth Built from the ground up for IoT and road-tested at scale Aeris IoT Services are based on the broadest technology stack in the industry spanning connectivity up to vertical solutions As veterans of the industry we know that implementing an IoT solution can be complex and we pride ourselves on making it simpler Our company is in an enviable spot We re profitable and both our bottom line and our global reach are growing rapidly We re playing in an exploding market where technology evolves daily and new IoT solutions and platforms are being created at a fast pace A few things to know about us We put our customers first When making decisions we always seek to do what is right for our customer first our company second our teams third and individual selves last We do things differently As a pioneer in a highly competitive industry that is poised to reshape every sector of the global economy we cannot fall back on old models Rather we must chart our own path and strive to out-innovate out-learn out-maneuver and out-pace the competition on the way We walk the walk on diversity We re a brilliant and eclectic mix of ethnicities religions industry experiences sexual orientations generations and more - and that s by design We see diverse perspectives as a core competitive advantage Integrity is essential We believe in doing things well - and doing them right Integrity is a core value here you ll see it embodied in our staff our management approach and growing social impact work we have a VP devoted to it You ll also see it embodied in the way we manage people and our HR issues we expect employees and managers to deal with issues directly immediately and with the utmost respect for each other and for the Company We are owners Strong managers enable and empower their teams to figure out how to solve problems You will be no exception and will have the ownership accountability and autonomy needed to be truly creative Job Title Senior Oracle Database Administrator DBA - GCP Location Noida India We are seeking a highly skilled and experienced Senior Oracle DBA to manage and maintain our critical Oracle 12c 18c 19c 21c single instance with DG and RAC databases hosted on Google Cloud Platform GCP The ideal candidate will possess deep expertise in Oracle database administration including installation configuration patching performance tuning security and backup recovery strategies within a cloud environment They will also have expertise and experience optimizing the underlying operating system and database parameters for maximum performance and stability Responsibilities Database Administration Install configure and maintain Oracle 12c 18c 19c 21c single instance with DG and RAC databases on GCP Compute Engine Implement and manage Oracle Data Guard for high availability and disaster recovery including switchovers failovers and broker configuration Perform database upgrades patching and migrations Develop and implement backup and recovery strategies including RMAN configuration and testing Monitor database performance and proactively identify and resolve performance bottlenecks Troubleshoot database issues and provide timely resolution Implement and maintain database security measures including user access control auditing and encryption Automate routine database tasks using scripting languages e g Shell Python PL SQL Create and maintain database documentation Database Parameter Tuning In-depth knowledge of Oracle database initialization parameters and their impact on performance with a particular focus on memory management parameters Expertise in tuning Oracle memory structures SGA PGA for optimal performance in a GCP environment This includes Precisely sizing the SGA components Buffer Cache Shared Pool Large Pool Java Pool Streams Pool based on workload characteristics and available GCP Compute Engine memory resources Optimizing PGA allocation PGA AGGREGATE TARGET PGA AGGREGATE LIMIT to prevent excessive swapping and ensure efficient SQL execution Understanding the interaction between SGA and PGA memory regions and how they are affected by GCP instance memory limits Tuning the RESULT CACHE parameters for optimal query performance considering the available memory and workload patterns Proficiency in using Automatic Memory Management AMM and Automatic Shared Memory Management ASMM features and knowing when manual tuning is required for optimal results Knowledge of how GCP instance memory limits can impact Oracle s memory management and the appropriate adjustments to make Experience with analysing AWR reports and identifying areas for database parameter optimization with a strong emphasis on identifying memory-related bottlenecks e g high buffer busy waits excessive direct path reads writes Proficiency in tuning SQL queries using tools like SQL Developer and Explain Plan particularly identifying queries that consume excessive memory or perform inefficient memory access patterns Knowledge of Oracle performance tuning methodologies and best practices specifically as they apply to memory management in a cloud environment Experience with database indexing strategies and index optimization understanding the impact of indexes on memory utilization Solid understanding of Oracle partitioning and its benefits for large databases including how partitioning can affect memory usage and query performance Ability to perform proactive performance tuning based on workload analysis and trending with a focus on memory usage patterns and potential memory-related performance issues Expertise in diagnosing and resolving memory leaks or excessive memory consumption issues within the Oracle database Deep understanding of how shared memory segments are managed within the Linux OS on GCP Compute Engine and how to optimize them for Oracle Data Guard Expertise Deep understanding of Oracle Data Guard architectures Maximum Performance Maximum Availability Maximum Protection Expertise in configuring and managing Data Guard broker for automated switchovers and failovers Experience in troubleshooting Data Guard issues and ensuring data consistency Knowledge of Data Guard best practices for performance and reliability Proficiency in performing Data Guard role transitions switchover failover with minimal downtime Experience with Active Data Guard is a plus Operating System Tuning Deep expertise in Linux operating systems e g Oracle Linux Red Hat CentOS and their interaction with Oracle databases Performance tuning of the Linux operating system for optimal Oracle database performance including Kernel parameter tuning e g shared memory settings semaphores file descriptor limits Memory management optimization e g HugePages configuration I O subsystem tuning e g disk scheduler selection filesystem optimization Network configuration optimization e g TCP IP parameters Monitoring and analysis of OS performance metrics using tools like vmstat iostat top and sar Identifying and resolving OS-level resource contention issues CPU memory I O Good to Have GCP Environment Management Provision and manage GCP Compute Engine instances for Oracle databases including selecting appropriate instance types and storage configurations Configure and manage GCP networking components VPCs subnets firewalls for secure database access Utilize GCP Cloud Monitoring and Logging for database monitoring and troubleshooting Implement and manage GCP Cloud Storage for database backups Experience with Infrastructure as Code IaC tools like Terraform or Cloud Deployment Manager to automate GCP resource provisioning Cost optimization of Oracle database infrastructure on GCP Other Products and Platforms Experience with other cloud platforms AWS Azure Experience with NoSQL databases Experience with Agile development methodologies Experience with DevOps practices and tools e g Ansible Chef Puppet Experience with GoldenGate Qualifications Bachelor s degree in Computer Science or a related field Minimum 12 years of experience as an Oracle DBA Proven experience managing Oracle 12c 18c 19c and 21c single instance with DG and RAC databases in a production environment with strong Data Guard expertise Extensive experience with Oracle database performance tuning including OS-level and database parameter optimization Hands-on experience with Oracle databases hosted on Google Cloud Platform GCP Strong understanding of Linux operating systems Excellent troubleshooting and problem-solving skills Strong communication and collaboration skills Oracle Certified Professional OCP certification is highly preferred GCP certifications e g Cloud Architect Cloud Engineer are a plus Aeris may conduct background checks to verify the information provided in your application and assess your suitability for the role The scope and type of checks will comply with the applicable laws and regulations of the country where the position is based Additional detail will be provided via the formal application process Aeris walks the walk on diversity We re a brilliant mix of varying ethnicities religions cultures sexual orientations gender identities ages and professional personal military experiences - and that s by design Diverse perspectives are essential to our culture innovative process and competitive edge Aeris is proud to be an equal opportunity employer Powered by JazzHR