Senior Specialist - System Management

General InformationPurpose of Role ExpectationFor Professional Services Project Delivery1 Plan and install upgrades of database management system software to enhance database performance2 Identify evaluate and recommend hardware or software technologies to achieve desired database performance3 Demonstrate database technical functionality such as performance security and reliability4 Create and enforce database development standards5 Design databases to support business applications ensuring system scalability security performance and reliability6 Develop and document database architecturesIdeal Candidate Profile Experience BE B Tech M Tech with 12 -18 years of relevant experienceFunction IMTSSubFunctionDelivery SupportSpan ScaleProject Delivery Individual SME Contributor and sometimes leading small teamsAssessment CertificationSpecific Vendor Certifications Microsoft Azure PMP Prince2Working hours TravelWillingness to work in shift andor odd hours to support customer deliverables major production outages and technical responses to proposals solutionFlexible to travel on short noticeKey responsibilitiesS No Description Criteria1 Extensive hands on experience on Oracle database administration Must2 Experience in deploying architecting Oracle Environment Stand Alone RAC oracle Data guard ALWAYS ON Mirroring log shipping and replicationMust3 Good exposure on Data migration Transformation Implementation of HighAvailability solutions DR setupMust4 Hands on experience on Configuring RAC Data guard RMAN ALWAYS ON Mirroring log shipping and replication Must5 Experience in performance tuning optimizationMust6 Experience in Database migration to heterogeneous environment Must7 Good understanding of data center management and orchestration and enterprise application environments Must8 Well verse with Capacity and performance managementMust9 Experience in database design Must10 Migrate data from legacy systems to new solutionsGood to have11 Knowledge of data mining and segmentation techniquesGood to have12 Knowledge of ETL process toolGood to have13 Knowledge of multiple data protection and DR solutionsMust14 Experience in configuring DR as per design by leveraging on premise datacenters and cloud environmentsMust15 Conducting detailed analysis of technical environments and provide solutionsMust17 Experience in any cloud environment Must19 Advanced troubleshooting skills on code application related issuesMust20 Knowledge on GoldengateExadataAlwayson Replicationmirroring and replicationGood to haveCapabilities Competencies31Technical CapabilitiesS NoTechnical Capability Description Proficiency levelBeginner Functional Proficient ExpertQualifying Capability1 Presales supportAbility to work on RFP responses and build solution optimized for specific clientAbility to analyze requirements design implement FunctionalY2 Capability and CapacityBest practices analysisCreate RCACreate Knowledge base and train othersIdentify skill gap and recommend appropriate trainingsConduct Proof of ConceptsFunctionalY Delivery SupportAssist delivery teams during critical issuesAssist in automating routine taskCreating and auditing SoPsFunctionalYBehavioral CapabilitiesS No Behavioral Capability Description Proficiency levelBeginner Functional Proficient ExpertQualifying Capability1 Communicating for ImpactDemonstrates the ability to customize messaging to suit target audience and situationCan handle difficult conversations with sensitivity and clarityCan facilitate meetings and discussions in crossfunctional groupscan negotiate effectively to influence others in routine transactions may be internal or external stakeholdersProficientY2 Design Thinking innovationFramework approach Factory approach Automation thinking for scalable and speedy service delivery to lower cost for clientsCan come up with alternate solutions for most client organizational problemsis open to new ideas and encourages out of the box thinkingconstantly focuses on improving optimizing work processes to enhance value deliveredFunctionalY3 Building CapabilitiesIs effective in leading teams and acting as the team advocate with key stakeholdersprovides constructive feedback to team members and mentor and guides them on his her area of expertiseFunctional Y