US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 15th Nov 2023
* Drive design, creation, and management of large, complex Oracle databases running on Oracle 19c environments on Exadata, LINUX, AIX with features for data compression, partitioning, RAC, RMAN, Data Guard
* Drive design, creation, and management of large, complex Oracle databases running on Oracle 19c environments on Aurora Postgres, Oracle RDS and Oracle EC2
* Participate in design, development, and implementation of database architecture and database solutions for “Speed-to-Market” Agile projects underway
* Perform advanced tuning with expertise on Oracle performance analysis tools such as ASH and AWR along with SQL Plan Baselines, SQL Profiles
* Master the latest DB features and apply them to provide a measurable value on applications
* Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades
* Work to reduce complexity and cost in database environments through analysis, simplification, and automation using Ansible, Python, terraform
* Manage and maintain Exadata environments with expert knowledge of Oracle Exadata architecture including Database Machines, Storage Cells, networking, and database functionality specific to Exadata
* Conduct Oracle database configuration reviews, audits, and troubleshooting on version 19c for all platforms supported by Oracle.
* Proficient in Data Modeling including physical and logical data modeling.
* Control and monitor user access to databases and maintain database security
* Manage capacity planning and forecasting for various platforms.
* Facilitate databases migration from an on-prem system to the Cloud
* Maintain documentation of systems and standard operating policies and procedures
* Collaborate and participate in application release planning and implementation.
* Provide technical assistance and mentor junior members of the team
* Work with HIG onshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.
* Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation
*Qualifications:*
* Solid knowledge of Oracle 19c and technical database concepts, including logical relational data modeling, physical data modeling, tuning large instances, resource management, data replication and backup/recovery techniques
* Automation skills, such as Ansible, Python, terraform for IAC
* Knowledge and experience of AWS or Oracle Cloud Infrastructure and Cloud Service
* Hands-on cloud migration experience is preferred
* Postgres Database administration is preferred
* Requires at least 8 plus years of experience with implementations, upgrades, conversions, and consolidation projects with Oracle databases
* Requires strong organizational and communication skills with the ability to handle multiple priorities
* Bachelor’s degree in Computer Science or a related discipline