Technical Lead - Database Analyst

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.