MS SQL Technical Lead

Job description:Job Title: SQL DBAJob ID: 117747Position Type: Full-timeLocation: Irving, TX; San Diego,CA Role/Responsibilities This exciting opportunity shall act as a Senior Database Engineer working with multiple Application teams focused on SQL Server on Physical and On-prem Cloud   servers. The candidate shall be responsible for maintaining the current SQL Server environments along with working on architecting a plan to migrate the Databases to no-sql cloud infrastructure while pro actively working on preventing any potential performance issues in non-prod itself (before getting Promoted to Prod). Role involves support for production issues, and participation in an on-call rotation.  Qualifications & Experience  ·       Bachelor’s degree or four or more years of work experience.Experience: Expertise in managing SQL Server 2008R2\2016\2019 and 2022 Versions. Expertise with SSIS and SSRS. Expertise in implementing different types of high availability and disaster recovery mechanisms like replication models, log shipping,database mirroring, always on and clustering. Experience with Troubleshooting Performance issues like Blocking, Deadlocks, parameter sniffing, Long Running and High CPU consuming queries. Experience with Implementing Backup, Restore and Disaster Recovery Planning Using Native Local Disk backup to File share and backups to Netbackup Utilities. Experience with Data migration between SQL Server, Oracle, Postgres and Couchbase. Experience with Creating Databases and help with Table design and Index creation based on the Data and Performance. Experience with Different Types of SQL Server Database Isolation Levels. Experience in using SQL Server Tools like Import/Export Wizard, SQL Query Store, , SQL Profiler,DTA and SQL Query Analyzer. Experience with Upgrading and patching of SQL Servers.   Experience with Login creation and understanding the Importance of granting the lease required privileges. Experience with working on Very Large Databases along with Partitioning and Data compression in OLTP and OLAP Environments. Expertise in debugging and troubleshooting issues using the Execution plans and using Query Store. Expertise and Proficiency with scripting using T-sql, Powershell.  Experience with Creating and maintaining GIT repos and performing Code reviews  Minimum Requirements 12+yrs relevant experience required, demonstrated through one or a combination of work and/or military experience,  or specialized training. 10+yrs or More years of Experience with SQL Server as  DBA. 6+ yrs More years of experience with creation, Implementing and Updating SSIS and SSRS  Strong T-sql scripting skills. Experience with Migrating the DB’s Between SQL Server and NoSQL. Strong problem-solving skills and ability to work in a fast-paced environment. Excellent communication and teamwork skills.  Pay and Benefits Pay Range Minimum: $ 95,000 per yearPay Range Maximum: $ 148,000 per year    A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year We offer:HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to secure@hcltech.com for investigation.