Specialized IT Consultant - Intermediate
Projectdeliverables :
Theservices and deliverables to be provided by the Vendor will includethefollowing :
- ProvidingOracle database support to projectteams
- BuildOracle database Infrastructure in AzureCloud
- Provideongoing support to all nonproduction and production databaseenvironments
- Refreshingthe nonproduction databases from productiondata
- Tuneall Oracle instance components including SQL andPL / SQL
- Providedata migration and data extractsupport
- Realtimedata replication using Oracle Golden Gatetechnology
- Providehigh availability using Active Data Guardtechnology
- Controlaccess permissions andprivileges
- Maintaindata standards including adherence to the Data ProtectionAct
- Testand enable new database features and customize them in order tomake them fit thepurpose
- Installconfigure and test Oracle Enterprise Manager (OEM) gridagent
- Provideperformance tuning and optimization of Oracledatabases
- Providedatabase documentation including standards procedures anddefinitions
- Monitorand ensure CPU memory I / O and storage are functioning asexpected
- Collaboratewith the project manager IT leads database administrators projectteams andvendors
- Supportdeployment and releaseactivities
Requirements
Experienceand Skill SetRequirements :
Requirements :
Azure / CloudTechnologies : : Experience with Compute Storage NetworkingMonitoring Security Backup & Restore High Availability (HA)& Disaster Recovery (DR).
You also have knowledge anddemonstrated experience in Azure Monitor using App Insights LogAnalytics Network Watcher andAlerts
Azure Oracle : Experience ofBuilding and installing Oracle database server in Azure with DataGuard data masking security monitoring and performance tuning usingAzure cloudtechnologies
SkillSet / ExperienceRequired :
TechnicalSkills andExperience :
- 10years experience with Azure Cloud and Oracle Database andtechnologies including Data Guard Automatic Storage Management(ASM) Oracle Wallet and Oracle Enterprise Manager (OEM) on Solarisand Windowsplatforms
- 2years of experience with Oracle GoldenGate
- Experiencewith upgrading 12c version of databases to Oracle19c
- Workingknowledge of new features such as Oracle Multitenant option OracleActive Data Guard Far Sync inmemory database information lifecyclemanagement enhancements and new datatypes
- Experiencewith Oracle database upgrade andmigration
- Experiencewith install patch and maintenance of all Oraclesoftware
- Experiencewith tuning all Oracle instance components including SQL andPL / SQL
- Experiencewith installing and testing new versions of the RBMS andmaintaining data standards while adhering to the Data ProtectionAct
ProblemSolvingSkills :
- 5years experience with troubleshooting problem solving performancetuning and hardware and system software infrastructure architecturedesign
- Proficientin troubleshooting root cause analysis and implementingsolutions
Project ManagementSkills :
2years experience with project planning andexecution
SoftSkills :
- Abilityto communicate regularly with technical application and operationalteams
- Excellentanalytical problemsolving and decisionmakingskills
- Strongleadership and collaborationskills
- Proventrack record for building strong workingrelationships
- Ademonstrated team player with a track record for meetingdeadlines
Public SectorExperience :
Previousexperience working within the public sector would be anasset
Experience and Skill Set Requirements : Requirements : Azure / CloudTechnologies : : Experience with Compute, Storage, Networking,Monitoring, Security, Backup & Restore, High Availability (HA)& Disaster Recovery (DR).
You also have knowledge anddemonstrated experience in Azure Monitor using App Insights, LogAnalytics, Network Watcher, and Alerts Azure Oracle : Experience ofBuilding and installing Oracle database server in Azure with DataGuard, data masking, security, monitoring and performance tuningusing Azure cloud technologies Skill Set / Experience Required : Technical Skills and Experience : 10+ years experience with AzureCloud and Oracle Database and technologies including, Data Guard,Automatic Storage Management (ASM), Oracle Wallet, and OracleEnterprise Manager (OEM) on Solaris and Windows platforms 2+ yearsof experience with Oracle Golden Gate Experience with upgrading 12cversion of databases to Oracle 19c Working knowledge of newfeatures such as Oracle Multitenant option, Oracle Active DataGuard Far Sync, in-memory database, information lifecyclemanagement enhancements, and new data types Experience with Oracledatabase upgrade and migration Experience with install, patch, andmaintenance of all Oracle software Experience with tuning allOracle instance components including SQL and PL / SQL Experience withinstalling and testing new versions of the RBMS and maintainingdata standards while adhering to the Data Protection ActProblem-Solving Skills : 5+ years experience with troubleshooting,problem solving, performance tuning, and hardware and systemsoftware infrastructure architecture design Proficient introubleshooting, root cause analysis, and implementing solutionsProject Management Skills : 2+ years experience with projectplanning and execution Soft Skills : Ability to communicateregularly with technical, application, and operational teamsExcellent analytical, problem-solving, and decision-making skillsStrong leadership and collaboration skills Proven track record forbuilding strong working relationships A demonstrated team playerwith a track record for meeting deadlines Public Sector Experience : Previous experience working within the public sector would be anasset