Usi-eh24-dttl-gcs-dba Tech Specialist @ Quess Corp Magna

Job Description

Summary Position Summary Real Time Experience in MS SQL 2019/2017/2016 with Microsoft SQL Server Azure cloud (IaaS and PaaS). MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database consistency checks using DBCC. Database Backup, Recovery and Disaster Recovery procedures Troubleshooting Database issues. Maintaining Database Authentication Modes, Creation of users, configuring permissions and Assigning roles to users. Experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring, Log Shipping & DR activity like (using Always On technology, storage level DR activity, Using Log shipping and mirroring) Hands on experience on setting up Multi subnet failover cluster for SQL cluster and Always on AG. Configure, setup and troubleshoot on SQL Clustering Active - Passive and Active- Active. Well experienced in troubleshooting issues like. Always ON & Replication. Well experienced in analyzing Performance, Query optimization and tuning. Experience in Index Maintenance Index tuning, Rebuild Reorganizing accordingto Index fragmentation, running DBCC checks and Update Statistics to check Data Integrity. Extensively used tools like SQL Profiler (server-side trace), Index Tuning Wizard, Windows Performance Monitor, PSSDIAG Tool and Perfinsight tool for monitoring and tuning MS SQL Server performance. Azure Cloud Migration and Support: (SQL PaaS & IaaS) Monitored and modified Performance using execution plans and Index tuning. Tuning and Optimization of Transact - SQL Stored Procedures. Using Performance Monitor/Profiler to solve Dead Locks/Long running queries Applying necessary SQL Server database service packs and windows patches. High Availability Solutions including SQL Server Clustering, Replication, Mirroring & SQL Always ON Migration & Up gradation of different SQL Servers Implementing Changes on Production servers with the proper change management approach. Scripting (T-SQL, Power Shell) is desired Certifications on SQL Server or MS Azure is desired On-Call Support Qualifications - Education: Bachelor's degree in computer Science. Engineering or Equivalent Master's degree in computer Science. Engineering or Equivalent Recruiting tips From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you. Our people and culture Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work. Learn more about our inclusive culture. Our purpose Deloittes purpose is to make an impact that matters for our clients, our people, and in our communities. We are creating trust and confidence in a more equitable society. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. We are focusing our collective efforts to advance sustainability, equity, and trust that come to life through our core commitments. Learn more about Deloitte's purpose, commitments, and impact. Professional development From entry-level employees to senior leaders, we believe theres always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career. Requisition code: 169690

Employement Category:

Employement Type: Full time
Industry: Management Consulting / Strategy
Role Category: General / Other SoftwareStatistics / Analytics
Functional Area: Not Applicable
Role/Responsibilies: Usi-eh24-dttl-gcs-dba Tech Specialist

+ View Contact

Keyskills:   MS SQL Microsoft SQL Server IaaS PaaS installation configuration performance tuning query optimization Database Backup Recovery Disaster Recovery Troubleshooting High Availability Clustering Replication Mirroring Log Shipping Performance Query optimization SQL Profiler IaaS TSQL Azure cloud clientserver connectivity backuprecovery Database consistency checks Database Authentication Modes Creation of users configuring permissions Assigning roles Disaster Recovery solutions Always ON DR activity Multi subnet failover cluster SQL cluster Always on AG SQL Clustering Active Passive Active Active Index Maintenance Index tuning Rebuild Reorganizing DBCC checks Update Statistics Index Tuning Wizard Windows Performance Monitor PSSDIAG Tool Perfinsight tool Azure Cloud Migration SQL PaaS Performance MonitorProfiler Power Shell Certifications on SQL