Tech Lead Database Ops Tech Lead Database Ops …

Ameriprise Financial, Inc.
in Gurgaon, Haryana, India
Permanent, Full time
Be the first to apply
Competitive
Ameriprise Financial, Inc.
in Gurgaon, Haryana, India
Permanent, Full time
Be the first to apply
Competitive
Tech Lead Database Ops
Job Description

This position will be responsible for all functions associated with the design, reporting and performance optimization of SQL, UDB and Oracle DBs along with Design and implement automated solutions for deployment monitoring and alerting.

Responsibilities

• Responsible for all functions associated with the design, reporting and performance optimization of SQL, UDB and Oracle DBs
• Design and implement automated solutions for deployment monitoring and alerting.
• Manage all technical aspects of the databases and processes
• Troubleshoot SQL/Oracle/UDB Server service outages as they occur, including after-hours and weekends
• Lead in maintaining and improving database operational efficiency through performance engineering activities
• Perform daily, weekly, and monthly reporting and analysis with recommendations on improvements
• Assist other Ameriprise performance engineers on process improvements at a database and DBMS platform improvements
• 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) and performance SLAs
• Configure SQL/Oracle and UDB 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

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.
• Proficient in two programming/scripting languages. (PowerShell, Python, Bash)
• Familiar with DevOps. (Jira, GIT, Continuous Integration, Continuous Deployment, Ansible)
• Familiar with AWS and AWS RDS
• 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

• 7 -10 years' experience with a degree in Computer Science or Some other advanced degree with increasing scope and responsibility (e.g. software development, database) expertise in SQL Server 2016 or 2019 and/or in Oracle 12c or19c
• Familiar with DevOps. (Jira, GIT, Continuous Integration, Continuous Deployment, Ansible)
• Strong written and verbal communication skills.
• Extensive experience in troubleshooting and resolving database issues, including performance tuning and capacity planning.
• Proven understanding of more than one of these DBMS SQL and Oracle required understanding performance implications and translating performance changes required to developers, vendors, business, and technical resources.
• Experience with database design, administration, and maintenance in distributed and mainframe environments.
• Proven expertise in database design, to include solid understanding of related programming languages, clustering, back-up/restore technologies, replication, and security.
• Working Knowledge of HACMP, HADR in DB2 UDB, Oracle RAC and MS SQL High Availability environments.

Preferred Qualifications

• 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.
Ameriprise Financial, Inc. logo
More Jobs Like This
See more jobs
Close
Loading...
Loading...