Ameriprise Financial Services, LLC Logo

Ameriprise Financial Services, LLC

Senior Technology Operations Analyst

Posted 2 Days Ago
Be an Early Applicant
Hyderabad, Telangana
Senior level
Hyderabad, Telangana
Senior level
The Senior Technology Operations Analyst will manage DB2 and Oracle databases, oversee cloud engineering activities, drive automation, and support performance teams. Responsibilities include database design, implementation, maintenance, troubleshooting, and ensuring operational efficiency while conducting upgrades and performance tuning.
The summary above was generated by AI

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

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

(4:45p-1:15a)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology

Top Skills

Db2
Oracle
SQL

Similar Jobs

Be an Early Applicant
5 Days Ago
Hyderabad, Telangana, IND
7,456 Employees
Entry level
7,456 Employees
Entry level
Software • Consulting
The Technology Operations Analyst is responsible for supporting technology operations, monitoring systems, and ensuring the availability and performance of IT services.
2 Days Ago
Hyderabad, Telangana, IND
2,194 Employees
Mid level
2,194 Employees
Mid level
AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
The Business Analyst will support various Business Units by providing operational and strategic analytical insights, updating financial models, interpreting data, preparing reports, and creating data visualizations. Responsibilities also include reconciling data in Salesforce and collaborating with stakeholders to present information effectively.
2 Days Ago
Hyderabad, Telangana, IND
2,194 Employees
Entry level
2,194 Employees
Entry level
AdTech • Artificial Intelligence • Marketing Tech • Software • Analytics
The Business Systems Analyst will lead the analysis and development of marketing platform solutions by translating business needs into technical requirements while collaborating with stakeholders. Key responsibilities include designing systems, proposing technical solutions, gathering client requirements, and ensuring alignment between business objectives and technology.

What you need to know about the Hyderabad Tech Scene

Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account