Talent.com
This job offer is not available in your country.
Technical Lead Database Operations

Technical Lead Database Operations

Ameriprise FinancialNoida, Uttar Pradesh, India
13 hours ago
Job description

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 automation

Key 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 new 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 time

    Timings

    (2 : 00p-10 : 30p)

    India Business Unit

    AWMPO AWMP&S President's Office

    Job Family Group

    Technology

    Create a job alert for this search

    Technical Lead • Noida, Uttar Pradesh, India

    Related jobs
    • Promoted
    • New!
    Principal Database & Exadata Cloud DBA

    Principal Database & Exadata Cloud DBA

    OracleNoida, Uttar Pradesh, India
    As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs.This involves resolvin...Show moreLast updated: 13 hours ago
    • Promoted
    • New!
    Senior Database Administrator - Information Technology

    Senior Database Administrator - Information Technology

    United AirlinesGurugram, Haryana, India
    United's Digital Technology team designs, develops, and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions.Find yo...Show moreLast updated: 13 hours ago
    • Promoted
    Senior Oracle Exadata DBA

    Senior Oracle Exadata DBA

    CentrilogicGhaziabad, IN
    Senior Oracle Exadata DBA – Advisory Services.As part of the Advisory Services organization, the role of the Senior Oracle Exadata Database Administrator will be responsible for the implementation,...Show moreLast updated: 29 days ago
    • Promoted
    Technical Lead

    Technical Lead

    HCLTechmeerut, uttar pradesh, in
    Informatica EDC CAI / CDI Developer.Informatica CAI (Cloud Application Integration) - Integration Platform.API Development (REST / SOAP, Swagger / WSDL) - Web Services & APIs. Workflow Orchestration (Even...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Database Administrator (PostgreSQL | AWS | ETL | Snowflake)

    Senior Database Administrator (PostgreSQL | AWS | ETL | Snowflake)

    CESnew delhi, delhi, in
    We are seeking a highly skilled and proactive Senior Database Administrator to join our.This hybrid role blends traditional DBA responsibilities with modern data. Comparative data loads and ensure o...Show moreLast updated: 30+ days ago
    • Promoted
    Oracle Performance tuning - Logical DBA

    Oracle Performance tuning - Logical DBA

    AMV2 Services Pvt. Ltd.narela, delhi, in
    Performance tuning - Logical DBA.The primary responsibilities of the Database Administrator include supporting database operations including but not limited to performance monitoring, query optimiz...Show moreLast updated: 17 days ago
    • Promoted
    • New!
    Technical Lead - Backend

    Technical Lead - Backend

    AbsolutdataGurugram, Haryana, India
    Build the Big Data Infrastructure, understand the business need, recommend, and finally build and implement the most optimal solution. You will work closely with the operations and analytics teams t...Show moreLast updated: 13 hours ago
    • Promoted
    GoHighLevel - Lead Database Engineer -

    GoHighLevel - Lead Database Engineer -

    gohighlevelDelhi, IN
    Remote
    We are seeking an experienced Lead Engineer - Databases with deep expertise in Elasticsearch, Clickhouse, and other modern data systems. You will lead the design, development, and optimization of sc...Show moreLast updated: 30+ days ago
    • Promoted
    Lead Database Developer - MongoDB

    Lead Database Developer - MongoDB

    CLARIVATENoida
    We are looking for Senior MongoDB Developer to join our technology team at Clarivate.The successful candidate will be responsible for the design, implementation, and optimization of MongoDB databas...Show moreLast updated: 7 days ago
    • Promoted
    • New!
    Database Operations Engineer

    Database Operations Engineer

    Anicalls (Pty) LtdNoida, Uttar Pradesh, India
    Analyze, recommend, and implement database changes and improvements.Implement backup and recovery plan; backup and restore data. Regularly conduct tests, error checks, and data validation to preserv...Show moreLast updated: 9 hours ago
    • Promoted
    • New!
    Technical Lead, Cloud

    Technical Lead, Cloud

    Landis+GyrNoida, Uttar Pradesh, India
    Landis+Gyr empowers utilities and consumers to optimize energy usage through advanced metering, grid-edge intelligence, and powerful data analytics. Today, our global team of about.At Landis+Gyr, we...Show moreLast updated: 13 hours ago
    • Promoted
    • New!
    Senior DBA II

    Senior DBA II

    RELXGurugram, Haryana, India
    We’re looking for a Senior Database Architect to join our team.This role involves designing and maintaining database systems, mentoring team members, and collaborating with cross-functional teams t...Show moreLast updated: 13 hours ago
    • Promoted
    snowflake Cloud Database Administrator

    snowflake Cloud Database Administrator

    Leading automobile GCCnarela, delhi, in
    Cloud Platform Expertise : Familiarity with leading cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, and Snowflake is essential. Understanding their database offerings, such as AWS...Show moreLast updated: 30+ days ago
    • Promoted
    GoHighLevel - Lead Engineer - Database

    GoHighLevel - Lead Engineer - Database

    gohighlevelDelhi, IN
    Remote
    We are seeking an experienced Lead Engineer - Databases with deep expertise in Elasticsearch, Clickhouse, and other modern data systems. You will lead the design, development, and optimization of sc...Show moreLast updated: 20 days ago
    • Promoted
    • New!
    Technical Middleware Operations Lead

    Technical Middleware Operations Lead

    Ameriprise FinancialNoida, Uttar Pradesh, India
    Candidate will support and act as the function lead for the containerized applications running on Kubernetes (AWS EKS), Dockers. Including some of the applications running on Apache and Java middlew...Show moreLast updated: 13 hours ago
    • Promoted
    • New!
    Mainframe Modernization - Database Migration Engineer

    Mainframe Modernization - Database Migration Engineer

    5100 Kyndryl Solutions Private LimitedGurugram, Haryana, India
    At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward – always pushing ...Show moreLast updated: 13 hours ago
    • Promoted
    • New!
    OBIEE technical lead

    OBIEE technical lead

    Anicalls (Pty) LtdNoida, Uttar Pradesh, India
    Experience in Architecting and Developing Business Intelligence and Data warehousing solutions using Oracle Fusion Middleware, OBIA, OBIEE 11g, Informatica, DAC, and Oracle database.Experience in i...Show moreLast updated: 13 hours ago
    • Promoted
    IndiaMART - Technical Lead - Database Administration

    IndiaMART - Technical Lead - Database Administration

    IndiaMartNoida
    Job Summary : The role involves designing and developing solutions to support the business needs.Optimizing and tuning e...Show moreLast updated: 30+ days ago