Sr Database Platform Analyst-Oracle DBA

Full–time
Job Description

Oracle DBA responsibilities will be to manage operational activities for Oracle databases and would also support Oracle Exadata and Multitenant /Autonomous cloud/Automation initiatives.

All critical aspects of BAU operations for DM Oracle Operations. Daily Monitoring of database platforms, closing incidents, resolving Issues, performing change functions through the environments.

Responsibilities
• Responsible for all functions associated with the implementation and maintenance of Oracle databases including security, back-up, logging, reporting and recovery procedures
• Manage all technical aspects of the databases and processes
• Troubleshoot Oracle DB outages as they occur, including after-hours and weekends
• Transform data via standardization, cleaning, data repair, matching, and de-duping
• Manage data from multiple sources including internal, external, and 3rd party data
• Assist in maintaining and improving database operational efficiency
• Perform daily weekly, and monthly data maintenance tasks
• Assist in developing feeds to Data Warehouse and Marts and data management processes
• Tuning SQL queries to improve performance
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
• Perform quarterly patching as well as applying one off patches as required.
• Oracle enterprise manager administration including OEM patch as well as configuring and adding new targets in OEM.
• Work on ZDLRA appliance for backup and recovery scenario.
• Working on Data guard broker for switchover and creating DG broker configuration for newly created databases.
• Working with OSWATCHER and generating RAC check reports.

Required Qualifications
• 4-7 years of technology experience of increasing scope and responsibility (e.g. software development, database) expertise in Oracle 11g ,Oracle 12c ,RAC, Dataguard and Oracle enterprise manager.
• Experience with database design, administration and maintenance in distributed environments.
• Experience in troubleshooting and resolving database issues, including performance tuning and capacity planning.
• Proven expertise in database design, to include solid understanding of related programming languages, clustering, back-up/restore technologies, replication and security.
• Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.
• Sound knowledge of Red Hat Linux including shell scripting and automation routine database task’s
• Worked on Oracle PSU/CPU updates, oracle wallet and SCAN configuration.
• Good knowledge of AWR ,ASH and ADDM reports.
• Experience in ZDLRA preferred with backup and recovery scenario.

Preferred Qualifications

Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements. Develop, edit and maintain required documentation.
• Proactively evaluate, recommend and perform database upgrades and changes. Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing. Stay abreast of and recommend improvements in technology and methodology to meet changing business needs and market demands, as well as provide for overall optimization of database administration function.
• Pro-actively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues.
• Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and performance).
• Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems. Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities.
• Provide ongoing support to operations and support teams as needed. Escalate and manage escalated issues as appropriate.

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if you're talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.

Full-Time / Part-Time

Full time

Timings

India Afternoon (2:00p-10:30p)

India Business Unit

Technology

Job Family Group

Technology

Cab Provided

Yes