Principal Engineer - Database Administration

Company:MMC Corporate

Description:

MARSH & MCLENNAN

Marsh & McLennan (NYSE: MMC) is the world's leading professional services firm in the areas of risk, strategy and people. The Company's 76,000 colleagues advise clients in over 130 countries. With annualized revenue approaching $17 billion, Marsh & McLennan helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses. Marsh advises individual and commercial clients of all sizes on insurance broking and innovative risk management solutions. Guy Carpenter develops advanced risk, reinsurance and capital strategies that help clients grow profitably and pursue emerging opportunities. Mercer delivers advice and technology-driven solutions that help organizations meet the health, wealth and career needs of a changing workforce. Oliver Wyman serves as a critical strategic, economic and brand advisor to private sector and governmental clients. For more information, visit mmc.com, follow us on LinkedIn and Twitter @mmc_global or subscribe to BRINK.

MARSH

Marsh is the world’s leading insurance broker and risk adviser. With over 35,000 colleagues operating in more than 130 countries, Marsh serves commercial and individual clients with data driven risk solutions and advisory services. Marsh is a business of Marsh & McLennan Companies (NYSE: MMC), the leading global professional services firm in the areas of risk, strategy and people. With annual revenue approaching US $17 billion and 76,000 colleagues worldwide, MMC helps clients navigate an increasingly dynamic and complex environment through four market-leading businesses: Marsh, Guy Carpenter, Mercer, and Oliver Wyman. Follow Marsh on Twitter @MarshGlobal; LinkedIn; Facebook; and YouTube, or subscribe to BRINK.

What 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 platforms

What 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:

• 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:

· Strong communication skills with the ability to engage manage and influence team members and senior stakeholders.

· Results-focused, analytical approach with a strong customer / client service ethos.