Principal Engineer Database Administration

Job Description

Company: MMC CorporateDescription:Marsh McLennan is seeking candidates for the following position based in the Noida office:Principal Engineer - Database AdministrationPrincipal Engineer - Database AdministrationWhat can you expect:The purpose of this position is to ensure timely, high-quality database support by executing production database-related tasks including requests to store data for a client, fix data errors, manage disk space or storage, monitors database performance, develops scripts and provides outstanding technical support to the internal end-user community. This role helps to set the strategic direction for the database platformsWhat is in it for you:Planning and executing on strategic database activities including on more complex issues:

• Support in Installation, configuration and upgrading Oracle software and products as per guidelines given. Oracle 11G and above knowledge is a must
• Creating and sizing database storage structures and database objects
• Planning for and actual backup and recovery of database information
• Work on Change Orders as per implementation plan

We will count on you to:Daily operations responsibilities include handling and serving as the team member on the following items/activities:(NYSE: MMC) is the worldxe2x80x99s leading professional services firm in the areas of risk, strategy and people. The Companyxe2x80x99s more than 85,000 colleagues advise clients in over 130 countries. With annual revenue of $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. data-driven risk advisory services and insurance solutions to commercial and consumer clients. develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and well being for a changing workforce. serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit , or follow us on and .Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one xe2x80x9canchor dayxe2x80x9d per week on which their full team will be together in person.

• Monitoring database usage.
• Monitoring system alerts and errors and resolve issues independently
• Controlling and monitoring different shell scripts
• Controlling and monitoring user access to the database
• Controlling and monitoring Standby and replication process.
• Monitoring and Troubleshooting Space Issues
• Application Patching
• Backup/Restore (RMAN and Disk based)
• Support Users in Deployment in Dev/QA/Prod
• Manage RAC clusters and associated grid infrastructure software
• Manage disk space via ASM
• Monitor databases using OEM and scripts
• Data Migration to Cloud
• Experience with Golden Gate is desirable
• Experience with Apex is desirable
• IaaS and PaaS knowledge
• Writing Cron Jobs/Shell scripting for database administration tasks
• Troubleshooting database Alerts.
• Application Specific Database Tasks such as creation of Full Vol schema etc.
• Peer review support team database activities and work with support team issues that impact the database

Support activities include:

• SR creation and follow-up Experience with Oracle Support
• Ability to provide technical assistance and recommendations to developers.
• Provide off-hours(Night Shift) and Weekend on-call database support

Daily operations responsibilities include handling and serving as the team member on the following items/activities:

• Monitoring database usage.
• Monitoring system alerts and errors and resolve issues independently
• Controlling and monitoring different shell scripts
• Controlling and monitoring user access to the database
• Controlling and monitoring Standby and replication process.
• Monitoring and Troubleshooting Space Issues
• Application Patching
• Backup/Restore (RMAN and Disk based)
• Support Users in Deployment in Dev/QA/Prod
• Manage RAC clusters and associated grid infrastructure software
• Manage disk space via ASM
• Monitor databases using OEM and scripts
• Data Migration to Cloud
• Experience with Golden Gate is desirable
• Experience with Apex is desirable
• IaaS and PaaS knowledge
• Writing Cron Jobs/Shell scripting for database administration tasks
• Troubleshooting database Alerts.
• Application Specific Database Tasks such as creation of Full Vol schema etc.
• Peer review support team database activities and work with support team issues that impact the database

Support activities include:

• SR creation and follow-up Experience with Oracle Support
• Ability to provide technical assistance and recommendations to developers.
• Provide off-hours(Night Shift) and Weekend on-call database support

What you need to have:

• 3-5 years of database Administration.
• Should have worked on UNIX platforms preferably on HP, Linux, and Solaris.
• Experience in Oracle RAC, Datagaurd, RMAN.
• Sound knowledge Shell Scripting.
• Knowledge of 3rd party tools like (SQL Developer /Toad/Foglight/Spotlight).
• Knowledge of Data Grid.
• Knowledge of Autosys.
• Knowledge of Golden Gate
• Knowledge of APEX
• Client Handling in High Pressure Situation

What makes you stand out:xc2xb7 Strong communication skills with the ability to engage manage and influence team members and senior stakeholders.xc2xb7 Results-focused, analytical approach with a strong customer / client service ethos.(NYSE: MMC) is the worldxe2x80x99s leading professional services firm in the areas of risk, strategy and people. The Companyxe2x80x99s more than 85,000 colleagues advise clients in over 130 countries. With annual revenue of $23 billion, Marsh McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. data-driven risk advisory services and insurance solutions to commercial and consumer clients. develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. delivers advice and technology-driven solutions that help organizations redefine the world of work, reshape retirement and investment outcomes, and unlock health and well being for a changing workforce. serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit , or follow us on and .Marsh McLennan is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age, background, caste, disability, ethnic origin, family duties, gender orientation or expression, gender reassignment, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law.Marsh McLennan is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh McLennan colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one xe2x80x9canchor dayxe2x80x9d per week on which their full team will be together in person. Marsh McLennan