Job Description

Job Title
Jr. SQL Server Administrator
Role Summary & Role Description
This SQL Server Database Admin will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our client applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.• Requirements analysis and system design.
• Download and install SQL Server service packs and updates.
• Configure and maintain SQL Security controls
• 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 T-SQL query tuning
• 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
• In charge of big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
• Integrate SQL Server with corporate applications
• T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
• Write stored procedures and T-SQL.
• 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.


Core/Must have skills• 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.
• In-depth knowledge of standard concepts, practices and procedures related to database management
• 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.
• Knowledge of AWS cloud.
• 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)


Good to have skills
Good to have AWS/AZURE Cloud Knowledge
Work Schedule
Hybrid
Keywords (If any)
SQL Server DBA
Why this role is important to us
Our technology function, Global Technology Services (GTS), is vital to State Street and is the key enabler for our business to deliver data and insights to our clients. We're driving the company's digital transformation and expanding business capabilities using industry best practices and advanced technologies such as cloud, artificial intelligence and robotics process automation.
We offer a collaborative environment where technology skills and innovation are valued in a global organization. We're looking for top technical talent to join our team and deliver creative technology solutions that help us become an end-to-end, next-generation financial services company.
Join us if you want to grow your technical skills, solve real problems and make your mark on our industry.
About State Street
What we do. State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world. From technology to product innovation, we're making our mark on the financial services industry. For more than two centuries, we've been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investment research & trading and investment management to institutional clients.
Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary by location, but you may expect generous medical care, insurance and savings plans, among other perks. You'll have access to flexible Work Programs to help you match your needs. And our wealth of development programs and educational support will help you reach your full potential.
Inclusion, Diversity and Social Responsibility. We truly believe our employees' diverse backgrounds, experiences and perspectives are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift programs and access to employee networks that help you stay connected to what matters to you.
State Street is an equal opportunity and affirmative action employer.
Discover more at StateStreet.com/careers