SQL 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 engineering team SQL Server Engineer with strong expertise in SQL Server configuration and administration AWS-hosted SQL environments T-SQL scripting PowerShell automation Ansible for infrastructure automation Bitbucket for version control and deployment automationKey Responsibilities Perform Database Administrator functions with SQL Server Manage backup and recovery procedures and Database Performance Issues Monitor Space usage plan to close the Space Gaps by taking necessary action Following standards write maintain and document monitoring scripts needed in support of applications Migrate the database objects from one environment to other Help in tuning the SQL queries for the Application Team Create new SQL Server databases as per the Ameriprise Standards Work with the Application teams to setup Security Model for their applications running on SQL Server databases Configure the databases in High Availability Environments and troubleshoots issues related to the same Monitor the SQL Server databases and make sure that they are up and running Resolve the day-to-day incidents assigned to the team Expert in Performance Tuning Known to Database Modeling for creation of Database Objects Client handling experience Required Qualifications 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 recent projects including design and implementation of physical databases based on logical data models Experience in Database Backup Restore strategies Experience in Clustering Mirroring Replication HA DR strategies Experience in setting up the security model for the application using SQL Server as a back-end database 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 Experience in keeping the SQL database up and running and perform the health checks for the databases on periodic basis Experience in helping the Application Team in tuning the SQL queries batches Experience in overall monitoring of SQL Server Databases Expertise in writing scripts such as Shell batch or Power-Shell scripts writing SQL queries to automate DB related jobs Familiar with the automation tools like Ansible Expertise in SQL Server installations and High availability configuration Expertise in SQL Server patching and troubleshooting Expertise in SQL Server Up gradation Preferred Qualifications Strong working knowledge of industry-standards database management tools Demonstrated successful experience working in a matrix multi-vendor technology environment Demonstrated ability to work effectively in urgent situations with high pressure and visibility Strong written and verbal communication 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 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 timeTimings 2 00p-10 30p India Business Unit AWMPO AWMP S President s OfficeJob Family Group Technology