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
1 Day ago
TrueFan - Senior Machine Learning Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
About UsTrueFan is at the forefront of AI-driven content generation, leveraging cutting-edge generative models to build next-generation products. Our mission is to redefine content generation space through advanced AI technologies, including deep ge...
1 Day ago
Salesforce commerce cloud consultant
Information Technology
- Thiruvananthapuram, Kerala, India
Salesforce Commerce Cloud consultant 5+ Years of Experience 6 to 12 months Mode - Remote 1.1LPM - 1.2LPM Max Key Responsibilities Translate business requirements into scalable Salesforce Service Cloud solutions, in collaboration with CAE's technic...
1 Day ago
Cloud Infrastructure Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
DescriptionInvent the future with us. Recognized by Fast Company’s 2023 100 Best Workplaces for Innovators List, Ampere is a semiconductor design company for a new era, leading the future of computing with an innovative approach to CPU design focuse...
1 Day ago
Devops Engineer- Intermetiate
Information Technology
- Thiruvananthapuram, Kerala, India
BackJD: Dev ops Engineer:As a DevOps Specialist- should be able to take ownership of the entire DevOps process, including Automated CI/CD pipelines and deployment to production.They should also be comfortable with risk analysis and prioritization.Le...
1 Day ago
Sr Data Scientist (London)
Information Technology
- Thiruvananthapuram, Kerala, India
AryaXAI stands at the forefront of AI innovation, revolutionizing AI for mission-critical, highly regulated industries by building explainable, safe, and aligned systems that scale responsibly. Our mission is to create AI tools that empower research...
1 Day ago
Software Test Engineer
Information Technology
- Thiruvananthapuram, Kerala, India
By clicking the “Apply” button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Takeda’s Privacy Notice and Terms of Use. I further att...
1 Day ago
Software Developer 5 (Java Fullstack)
Information Technology
- Thiruvananthapuram, Kerala, India
Job DescriptionBuilding off our Cloud momentum, Oracle has formed a new organization - Oracle Health Applications & Infrastructure. This team focuses on product development and product strategy for Oracle Health, while building out a complete platfo...
1 Day ago
Java Developer - Spring Frameworks
Information Technology
- Thiruvananthapuram, Kerala, India
Java DescriptionWe are looking for a passionate and talented Java Developer with 2-3 years of hands-on experience to join our growing development team.The ideal candidate should have a strong foundation in Java technologies and the ability to develo...
Talk to us
Feel free to call, email, or hit us up on our social media accounts.
Email
info@antaltechjobs.in