AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
111 Ameriprise India Jobs
Senior Technology Operations Analyst
4-9 years
Hyderabad / Secunderabad, Gurgaon / Gurugram
1 vacancy
Senior Technology Operations Analyst
Ameriprise India
posted 3mon ago
Job Role Insights
Fixed timing
Key skills for the job
Job Description
UDB/ Oracle DBA responsibilities will be to manage cloud engineering activities for DB2 and Oracle databases 24/7/365 and would also drive automation activities along with providing SME support to performance team.
Key Responsibilities
- Responsible for all functions associated with the design, implementation and maintenance of UDB Server databases including security, back-up, logging, reporting and recovery procedures
- Manage all technical aspects of the databases and processes
- Troubleshoot Database service 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, Marts and data management processes
- Tuning 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
- Database and application disaster recovery.
- Experience with Service Now
- Fix pack upgrade experience.
- UDB Level upgrade experience.
Preferred Skills:
- 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.
Required Qualifications
-
- 5+ years of technology experience of increasing scope and responsibility (e.g. software development, database) expertise in DB2 UDB 10.5 and 11.1
- 5+ years of AIX/Linux experience.
- Working Knowledge of TSA (Tivoli System Automation), HADR (High Availability Disaster Recovery) in DB2 UDB environment.
- Data Server Manager (DSM) Performance Manager.
- Experience with database design , administration and maintenance in distributed and mainframe 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 understanding performance implications and translating requirements to application developers.
- Pearl and/or PowerShell Programming
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Operations Analyst roles with real interview advice
What people at Ameriprise India are saying
Operations Analyst salary at Ameriprise India
reported by
2
employees
with 3-7
years exp.
₹10.2
L/yr - ₹13
L/yr
122%
more
than the average Operations Analyst Salary in India
View more details
What Ameriprise India employees are saying about work life
based on 111 employees
Strict timing
Monday to Friday
No travel
Day Shift
Ameriprise India Benefits
View more benefits
Compare Ameriprise India with
SBI Cards & Payment Services
Compare
Axis Direct
Compare
Kotak Securities
Compare
Aadhar Housing Finance
Compare
ICICI Home Finance
Compare
Pine Labs
Compare
Sharekhan
Compare
Morningstar
Compare
Synchrony
Compare
Ocwen Financial Solutions
Compare
Edelweiss
Compare
Fidelity National Financial
Compare
Wonder Home Finance
Compare
ICICI Prudential Mutual Fund
Compare
Apex Group
Compare
Better.com
Compare
Franklin Templeton Investments
Compare
Sun Life Financial
Compare
Religare
Compare
TIAA Global Business Services
Compare
Senior Technology Operations Analyst
4-9 Yrs
Hyderabad / Secunderabad, Gurgaon / Gurugram
Share an Interview