Job description for SQL Server Administrator with Performance tuning
Role Description:
This role is for a SQL Server Administrator with Performance tuning
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
Don't want to miss the next one?
Subscribe to daily email alerts for roles matching your interests.
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.
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
6 plus years of experience in SQL Server Administration
Azure Cloud DevOps experience.
T-SQL (Transact-SQL) Programming Perform any extra responsibilities that are allocated to you
Write stored procedures and T-SQL scripts.
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.
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 big data ETL into SQL Server, as well as authoring and modifying SQL Server Reporting Services reports
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.
About State Street
Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.
We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.
As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.
Discover more information on jobs at StateStreet.com/careers
Read our CEO Statement
Similar roles you might like
More openings like this one — take a look before you go.
