Nagpur, Maharashtra, India
Information Technology
Full-Time
State Street
Overview
Role Description:
This role is for a Azure DevOps engineer.
Key Responsibilities:
- Requirements analysis and system design.
- Download and install SQL Server service packs and updates.
- Configure and maintain SQL Security controls
- A deep understanding of CI/CD tools and a strong desire to help teams release frequently to production with a focus on creating reliable high-quality results.
- Expertise in DevOps, DevSecOps and emergent experience with DataSecOps and Data Governance practices — deep experience with managing and scaling container-based infrastructure-as-code technologies from the CNCF and related orbits
- Make recommendations for system architecture per Microsoft SQL Server best practices
- Manage database backup and recovery, as well as disaster recovery planning, in coordination with the IT manager and System Engineer
- Create, change, and improve SQL Server Agent tasks and maintenance plans
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible
- Troubleshoot application sluggishness and poor performance
- In charge of database migrations and server updates
- Create documentation and training for routine database administration activities, as well as train server operations employees on them
- Integrate SQL Server with corporate applications
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Production support as needed.
- End to end understanding of software architecture, design, development and implementation.
- Continuous integration and build process, test automation and deployment.
Primary Skills (Must Have):
- Strong Practical experience using Scrum, Agile modelling and adaptive software development.
- Proven problem solving, communication, interpersonal and analytical skills
- Extensive knowledge of data warehousing concepts and data analysis.
- 6+ years of Azure Cloud DevOps experience
- Experience in working on various MS SQL Database versions 2016,2017, 2019, 2022
- Experience in applying SQL Server service packs and database upgrades on same server and new server.
- Experience in Database performance tuning and troubleshooting users and application related issues
- Experience in continuous process improvement and automation using PowerShell
- Experience in HA solutions like Always ON setup and maintenance, Log shipping, Database mirroring and replication
- Experience in SQL Server cluster
- Experience in Upgrade, Patching and migration to On Prem and Cloud
- Experience in Database security and encryption setup using TDE and masking
- Manage database backup and recovery, as well as disaster recovery planning
- Create, change, and improve SQL Server Agent tasks and maintenance plans.
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed processes, and address issues as soon as possible.
- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
- Monitoring performance and managing parameters to provide fast query responses to front-end users
- Excellent English communications skills (written and verbal)
Secondary Skills (Good to Have):
- Certification on Azure and AWS
- In charge of T-SQL query tuning
- In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
- T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
- Write stored procedures and T-SQL.
- Ability to multi-task, meet aggressive timelines and have strong work ethics.
- Experience of working in the financial industry
Qualification:
Bachelor’s/Master’s Degree level qualification in a computer science.
State Street's Speak Up Line
Similar Jobs
View All
18 Hours ago
Data Analyst (Telugu Speakers)
AI & Machine Learning Advancement
- 1 - 20 Yrs
- Andhra Pradesh, Telangana, India
For thousands of years, maps have provided humans with the knowledge they need to make decisions. As a Maps Evaluator, you will have the opportunity to provide ground truth for your town, city or country.
At Peroptyx, we are looking for Data Ana...
20 Hours ago
Technical Writer
Information Technology
- 1300000 - 1600000 INR - Annual
- 3 - 7 Yrs
- Pune
THE POSITION
We’re looking for a motivated, driven and collaborative Software Technical Writer that will be an integral member of a small software technical writing team. As a Technical Writer with my client, you will be working with multiple team...
1 Day ago
Quality Assurance Automation Engineer
Information Technology
- 3 - 7 Yrs
- Mumbai, Nashik, Mumbai (All Areas), Pune
Job Title: QA Automation Engineer
Location: Hybrid ( Mumbai, Pune, Nashik )
Experience: 3+ years
Job Summary:
We are looking for a detail-oriented and experienced QA Automation Engineer to join our team. You will be responsible for designing an...
1 Day ago
Morningstar - Senior Software Engineer - C#/.Net
Information Technology
Job DescriptionTitle : Senior Software EngineerLocation : Vashi, Navi MumbaiCompany : Morningstar is a leading provider of independent investment research in North America, Europe, Australia, and Asia. We offer a wide variety of products and solutio...
1 Day ago
Senior Cloud Engineer/Consultant Specialist
Information Technology
Job DescriptionSome careers shine brighter than others.If you’re looking for a career that will help you stand out, join HSBC, and fulfil your potential. Whether you want a career that could take you to the top, or simply take you in an exciting new...
1 Day ago
Sr. Software Engineer - 10268 - Ruby on Rails
Information Technology
Apply for this JobCoupa makes margins multiply through its community-generated AI and industry-leading total spend management platform for businesses large and small. Coupa AI is informed by trillions of dollars of direct and indirect spend data acr...
1 Day ago
Senior Manager, Appian Software Developer
Information Technology
Job DescriptionSenior Manager-Appian Software DeveloperThe Opportunity Based in Hyderabad, join a global healthcare biopharma company and be part of a 130- year legacy of success backed by ethical integrity, forward momentum, and an inspiring missio...
1 Day ago
Junior Scrum Master - Agile Methodologies
Information Technology
- Noida, Uttar Pradesh, India
Job Title: Agile Scrum Executive / Junior Scrum MasterExperience: 13 YearsLocation: Delhi / Gurgaon (On-site / Hybrid depending on company policy)Employment Type: Full-timeRoles And Responsibilities Assist the Scrum Master or Agile Coach in facilit...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in