Sr. Performance Engineer

Company: Threadneedle group
Location: Minneapolis
Posted on: November 15, 2024

Job Description:

SQL performance engineer/DBA responsibilities will be to manage cloud engineering activities for SQL Server databases 24/7/365 and would also drive automation activities along with providing SME support to SQL performance team.We are looking for a skilled Performance Engineer / DBA with expertise in performance tuning, database optimization, and automation for Oracle, SQL Server, and RDS databases. The ideal candidate will have a strong technical background in database performance management, an aptitude for automation (preferably with Ansible), and the ability to maintain high performance and reliability across our database systems.Key Responsibilities

• Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures.
• Manage all technical aspects of the databases and processes.
• Database Performance Tuning: Conduct analysis and tuning for Oracle, SQL Server, and RDS databases to enhance performance, reduce latency, and ensure system stability.
• Optimization: Diagnose and resolve bottlenecks, optimize queries, indexing, and manage database configurations to meet performance and reliability standards.
• Automation: Develop and implement automation scripts (using Ansible or similar tools) for routine DBA tasks, monitoring, deployment, and troubleshooting.
• Monitoring & Troubleshooting: Regularly monitor database health, resolve issues proactively, and implement solutions to maintain optimal database performance.
• Database Maintenance: Perform backup and recovery, manage database patches, upgrades, and security updates.
• Collaboration: Work closely with cross-functional teams, including application developers, platform engineers, and DevOps, to ensure database alignment with application needs.
• Documentation: Maintain documentation for performance metrics, tuning activities, and automation processes.
• Troubleshoot SQL Server 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 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).
• Configure SQL Server monitoring utilities to minimize false alarms.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Configure SQL Server instances, high availability (Mirroring, Always ON) and patching of these instances.
• Troubleshoot issues related to SQL Server infrastructure (Patching, High availability etc.).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.
  • Thorough knowledge of SQL Server configuration, High availability configuration, setting up the environment.Required Qualifications:
    • 4+ years of technology experience of increasing scope and responsibility (e.g. software development, database) expertise in SQL Server 2005, 2008, 2012, 2014, 2016, 2019.
    • Experience with database design, administration and maintenance in distributed environments.
    • Experience in troubleshooting and resolving database issues, including performance tuning and capacity planning.
    • Basic understanding of automation scripts such as Shell, batch, or PowerShell scripts, writing SQL queries to automate DB related jobs.
    • Familiar with the automation tools like Ansible.
    • Knowledge in SQL Server installations and High availability configuration.
    • Knowledge in SQL Server patching and troubleshooting.Preferred Qualification:
      • Strong working knowledge of industry-standards database management tools.
      • Demonstrated, successful experience working in a matrixed, multi-vendor technology environment.
      • Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
      • Strong written and verbal communication skills.About Our CompanyAmeriprise 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-TimeFull timeTimings(4:45p-1:15a)India Business UnitAWMPO AWMP&S President's OfficeJob Family GroupTechnology
        #J-18808-Ljbffr

Keywords: Threadneedle group, Brooklyn Park , Sr. Performance Engineer, Engineering , Minneapolis, Minnesota