Job Description

:

Job Title – Database Administration The Purpose of Your Role Personal and Workplace Investing (PWI) helps millions of people save and invest through individual retail accounts and workplace savings plans. PWI builds lifetime relationships with customers and provides employers with cost-effective, integrated employee benefit solutions. The company serves customers online, over the phone, and through a nationwide network of investor centers. PWI administered over $1.5 trillion in customer assets. The PWI PSS PI Database Administration Support group provides database services related to the Oracle infrastructure for multiple client facing applications. Production Support which includes 7x12 oncall support, Database Infrastructure Support, performance monitoring, 1st level performance troubleshooting, Risk/Audit compliance and Non-Prod database refreshes. Database and Oracle Application Maintenance includes Oracle Database upgrades, Database reorganizations, Security Patching, Application Upgrades. The Value You Deliver The selected candidates will provide database application life cycle support including database design, development, implementation, and support in the development and production environments. This candidate will also provide recommendations and solutions on database and application architecture, database integrity, security and availability as well as application tuning support. Technical / Behavioral

• Setting up and monitoring database alerts through OEM / CRONTAB.
• Setting up & Monitoring Replication (Oracle GoldenGate).
• Setting up, Monitoring & troubleshooting Dataguard & RAC.

Ø Oracle Database Administration

• User management
• Space management
• Performance tuning
• SQL tuning
• Backup and Recovery
• Disaster Recovery Management

Ø Provide 12x7 support and ensure that all critical database problems are resolved in a timely manner. Ø Perform/support RDBMS software maintenance and database instance creation Ø Oracle / Tomcat Application Server administration activities including installation, monitoring.

• Shell scripting (knowledge to understand the existing scripts and the ability to write based on requirement)
• Prior experience in cloud migration would be added advantage

Experience and Qualifications and skills:

• 4+ years of total experience with at least 3 years as an Oracle DBA.
• Knowledge of Oracle Golden Gate, Oracle Datagaurd and Oracle RAC is must.
• Knowledge in Oracle 12c will be an advantage.
• Should have a strong understanding of Oracle Database Concepts, Installation, Patching, Cloning and System Administration work.
• Should be able to perform DBA activities like instance tuning, schema management, space management, backup and recovery, disaster recovery, database refresh, and SQL programming and tuning
• Should have good exposure to performance tuning.
• Excellent communication skills

The Skills that are Good To Have for this role

• Process oriented.
• Good knowledge of performance tuning.
• AWS or Azure cloud knowledge.
• Multiple RDBMS will be a plus.

How Your Work Impacts the Organization You would be able to contribute in maintaining stability of our end points by upkeeping infrastructure uptime through structured software, distribution and patch management mechanism thereby helping associates to perform their day to day tasks seamlessly. The Expertise We’re Looking For

• 4+ years of Oracle DBA.
• Graduate

Company Overview At Fidelity, we are focused on making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. Fidelity India has been the Global Inhouse Center of Fidelity Investments since 2003 with offices in Bangalore and Chennai. For information about working at Fidelity, visit India.Fidelity.com. Fidelity Investments is an equal opportunity employer. Location : Chennai / Bangalore Shift timings: 11:00 am - 8:00pm

Certifications:

Company Overview At Fidelity, we are focused on making our financial expertise broadly accessible and effective in helping people live the lives they want. We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. Fidelity India has been the Global Inhouse Center of Fidelity Investments since 2003 with offices in Bangalore and Chennai. For information about working at Fidelity, visit India.Fidelity.com. Fidelity Investments is an equal opportunity employer.