Job Title – Principal - Database Administration
The Purpose of This 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
The Skills that are Key to this role
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,
Experience and Qualifications and skills
➢ 10+ years of total experience with at least 10 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
- 10+ years of Oracle DBA.
11:00 am - 8:00pm
12x7 oncall on rotation basis
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.