Oracle Applications Database Administrators
Millipore Corporation

Job Title: Oracle Applications Database Administrators Employer: EMD Millipore Corporation, 400 Summit Drive, Burlington, MA 01803 Job Location: EMD Millipore Corporation, 400 Summit Drive, Burlington, MA 01803 Job

Responsibilities:

The Oracle Applications Database Administrator is responsible for maintaining and improving the health of the Oracle Application and Database for optimal performance.

Responsibilities:

include: Evaluating architectural requirement, proposing solutions on upgrade/installation and configuration for multi node, high availability, clustered EBS finance application & database;Perform ongoing database administration, maintenance, performance, installation, upgrades, backup and recovery of Oracle EBS 11i application & 10g,11g,12c or 19c databases, where required;Design, build, and maintain internal cloud applications for the organization, work on cloudformation, ansible, and terraform to build infrastructure as code for deployment of containerization, Kubernetes and pipeline to automate CI/CD process using tools like Jenkins, Azure dev ops and Gitlab;Manage AWS services using automated scripts, work on git, CI/CD pipeline and yaml scripting for service deployment on AWS, management of S3 buckets, Cloudformation, EC2 machines, databases, SNS, and AWS lambda services;Optimize AWS platform management service, building policies, standards, network and infra to handle connectivity within cloud infrastructure and perform architectural consultation whenever required;Engage in performance tuning of several accounting & technical modules of E-Business suite Finance (EBS) & database during month end critical activities to avoid business disruptions;Ensure continued high customer satisfaction and review and help application developers to correct SQL Code for performance improvement; andManage the offshore Database Administration (DBA) team provided by external partners and ensure effective flow of communication between the DBA team, customers and management (this responsibility includes overseeing, leading, assisting, and coordinating the database activities but does not include supervision and personnel authority over other team members). Job Requirements: Employer requires candidate to have a Bachelor's degree in Engineering, Mathematics, Statistics, Business/Commerce, Finance, or a closely related field. (Employer is willing to accept three years of post-secondary education in Engineering, Mathematics, Statistics, Business/Commerce, Finance, or a closely related field in lieu of a Bachelor's degree in Engineering, Mathematics, Statistics, Business/Commerce, Finance, or a closely related field.) Candidate must have at least seven years of work experience as systems analyst, database architect, technical architect, or a closely related occupation working independently on Oracle Applications E-business Suite 11i and R12 Development/QA/UAT and critical Production environments for installations, upgrade, migration, advanced configurations including Real Application Clusters, Integrated SOA gateway, Oracle Application Express (Apex), Real Application Testing, PCP, Enterprise Manager Cloud control, Dataguard, OID, Golden Gate, and PostgreSQL database administration. Candidate must also have the following: Demonstrated ability implementing and leading projects including EBS 11i/R12/R12.2 upgrade and migrations, database upgradation (9i/10g/11g/12c/19c) and migration (platform/single- RAC), RAC configuration, RAC node addition/deletion, 12c OEM configuration, DR configuration, and Drill gained through seven years of work experience;Demonstrated knowledge of performance tuning of several accounting and technical modules including AP, AR, GL, FND, AD, TXK, PO, Sub-ledger accounting of E-Business suite Finance (EBS) and database during month end critical activities gained through seven years of work experience;Demonstrated knowledge of automating health check process to proactively monitor EBS and database services; setting up important alert and notifications; and reviewing database time model, physical and logical IO, CPU statistics, wait events, operating system statistics, memory management data, fragmentation data, optimizer data, session information, SQL execution/time elapse/ wait time and metrics to determine root cause of application, database performance and provide mitigation fixes to avoid business disruption gained through seven years of work experience;Demonstrated knowledge in Oracle Application (11i. R12), database (9i,10g,11g,12c,19c) and Fusion middleware apps (10g,11i,19c) to analyze and evaluate requirements on architectural, compliance, security, upgrade, implementation, Integration, administration and deep troubleshooting to support such environments gained through at least five years of work experience;Demonstrated ability working on OCI & AWS cloud for providing instances, database, network design, VCN, VPC, identity management, Gateways, DRG, Site to Site and VPN configuration gained through at least two years of work experience;Demonstrated ability managing backups and object storage and managing autonomous DB for ATP and ADW, including EC2, RDS, S3, security Groups, Sagemaker, Glue, CloudTrail, Route53, Lambdas, Kubernetes, and Networking in AWS gained through at least two years of work experience;Demonstrated ability providing infrastructure on AWS using cloud formation, terraform and CI/CD pipeline and building modern software approaches using dev ops tools and technologies including ansible, python, NodeJS, git, Chef, Puppet, Kafka, RabbitMQ, Redis, GraphQL, SQLServer, Postgres, MongoDB, Couchbase, and yaml gained through at least two years of work experience. All years of experience may be gained concurrently. This position is eligible for the EMD Millipore Corporation Employee Referral Program. Applicants can mail resumes to EMD Millipore Corporation., 400 Summit Drive, Burlington, Massachusetts 01803 (Attn: req# 272388 or apply online at https://www.emdgroup.com/en/careers/job-search.html)