Ameriprise Financial Services, LLC Logo

Ameriprise Financial Services, LLC

Technical Lead - Database Analyst

Posted 4 Days Ago
Be an Early Applicant
2 Locations
Senior level
2 Locations
Senior level
The role involves operational database support and performance tuning in SQL Server, troubleshooting database issues, and ensuring system optimization through effective monitoring and documentation.
The summary above was generated by AI

Operationally support all aspects of databases including SQL and cloud-based environments to complete standard DBA responsibilities and provide thought leadership on how to automate, improve or do another way for all activities in the database. Performance tuning and working with our customers to optimize all interactions between our systems and their applications. Monitor database environments, identify existing or potential performance issues and effectively tune when needed.

Key Responsibilities

  • Perform Database Administrator functions with SQL Server.
  • 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).
  • End to end responsibility of troubleshooting Database Performance issues, recommending and implementing the changes in lower environment and propagating to the production environment.
  • Following standards, write, maintain, and document monitoring scripts needed in support of applications.
  • Help in tuning the SQL queries for the Team.
  • Gain thorough understanding of data requirements and business/client needs. Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements. Ensure design and implementation meet architectural standards, company guidelines and client requirements. Develop, edit and maintain required documentation.
  • Resolve the day-to-day incidents assigned to the team. 

 
Required Qualifications

  • Bachelors degree or equivalent in Computer Science, Information Systems or related technical field; or equivalent work experience.
  • 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.
  • 7 to 10 years of Application DBA experience in SQL Server on preexisting and new projects, including design and implementation of physical databases based on logical data models.
  • 7+ years of experience with database design, administration and maintenance in distributed environment.
  • 7+ years of experience troubleshooting and resolving database issues, including performance tuning and capacity planning. .
  • Experience in setting up the Resource Governor / Maintenance Plans and SQL Agent Jobs.
  • Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.
  • Experience in writing SQL Stored Procedures / Functions / Views etc.
  • Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers. Strong knowledge of MS SQL and tools like Spotlight.

 
Preferred Qualifications

  • Strong working knowledge of industry-standards database management and developmenttools.
  • 4+ years AWS, etc. (specific technology skill requirements will vary by role and domain).
  • Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
  • Strong written and verbal communication skills. 
  • Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
  • Strong written and verbal communication skills.
  • Thorough knowledge of SQL Server configuration, High availability configuration, setting up the environment
     

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

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology

Top Skills

AWS
SQL Server

Similar Jobs

15 Hours Ago
Hybrid
Hyderabad, Telangana, IND
Senior level
Senior level
Financial Services
The Director of Infrastructure Engineering will lead cloud-based application teams, drive public cloud initiatives, and enhance resiliency and automation in systems management.
Top Skills: AnsibleArtifactoryAWSCloudwatchDatadogDockerDynatraceGitGoJavaJenkinsKubernetesNode.jsPrometheusPythonScalaSplunkSQLTerraform
15 Hours Ago
Hybrid
Hyderabad, Telangana, IND
Senior level
Senior level
Financial Services
The Senior Lead Software Engineer will enhance, build, and deliver technology products within an agile team at JPMorgan Chase, providing technical guidance and developing high-quality code. Responsibilities include influencing product design, driving operational decisions, and contributing to the engineering community while fostering a culture of diversity and inclusion.
15 Hours Ago
Hybrid
Hyderabad, Telangana, IND
Mid level
Mid level
Financial Services
As a Software Engineer III, you will design and deliver technology products, troubleshoot issues, maintain high-quality code, and drive improvements in software applications.
Top Skills: J2EeJavaReact Js

What you need to know about the Kolkata Tech Scene

When considering the industries shaping India's tech scene, gaming might not immediately come to mind. However, in the last decade, increased internet usage and greater access to mobile devices have catapulted the industry to new heights, with Kolkata-based companies like Virtualinfocom, Red Apple Technologies and Digitoonz, at the forefront, driving the design and animation of new gaming titles for players.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account