Hcl tech is a global technology company, home to morethan 219,000 people across 60 countries, deliveringindustry-leading capabilities centered around digital, engineering,cloud and ai, powered by a broad portfolio of technology servicesand products.
we work with clients across all major verticals,providing industry solutions for financial services, manufacturing,life sciences and healthcare, technology and services, telecom andmedia, retail and cpg and public services.
senior sql databaseadministrator team culture our team is fast paced, highlyenergetic, motivated and hardworking.
we expect our candidates tobe integrated into our results-driven and solution-oriented culturefrom the get-go.
our team attains high-quality results onchallenging projects; the belief that outcomes are linked to one'seffort rather than chance and the tendency to personally setchallenging yet realistic goals.
we are seeking a highly skilledand experienced sql database administrator (dba) with expertise inbackup and restore operations to join our dba team.
the sql dbawill be responsible for managing and maintaining our organization'sdatabase systems, ensuring their optimal performance, security, andreliability.
this role is essential in safeguarding and recoveringcritical data in the event of system failures.
essential skills andcompetencies: • proven experience as a sql database administratorwith a focus on backup and restore operations.
• strong expertisein microsoft sql server (sql server 2019 and sql server 2022).
•proficiency in powershell scripting, and sql server managementstudio (ssms).
• experience in ssis and ssrs development.
•experience with database performance tuning and optimization.
•knowledge of high availability and disaster recovery solutions •excellent problem-solving and troubleshooting skills.
• strongcommunication and teamwork abilities.
• relevant certifications(e.g., microsoft certified database administrator) are a plus.activities: 1.
database administration: • administer, monitor, andmaintain sql server databases to ensure optimal performance,availability, and security.
• perform routine database maintenancetasks such as indexing, integrity checks, and statistics updates.2.
backup and restore: • develop and implement robust backup andrecovery strategies for databases to minimize data loss anddowntime.
• execute database backups and perform periodic restoresto validate the integrity of backup files.
3.
database security: •implement and manage database security measures, including useraccess control, roles, and permissions.
• ensure compliance withsecurity policies and take proactive measures to protect sensitivedata.
4.
performance optimization: • monitor database performance,identify bottlenecks, and optimize query performance.
• tackleissues related to query optimization, indexing, and resourceutilization.
5.
ssis development: • design, develop, and implementetl (extract, transform, load) processes using sql serverintegration services (ssis).
• collaborate with data managementteam and business users to understand data integrationrequirements.
• optimize and troubleshoot ssis packages forefficient data movement.
6.
ssrs development: • create, modify, andmaintain sql server reporting services (ssrs) reports.
•collaborate with business users to define reporting requirements.
•ensure the accuracy and timeliness of reports generated by ssrs 7.high availability and disaster recovery: • set up and maintain highavailability solutions like sql server always on availabilitygroups and clustering.
• develop, test, and implement disasterrecovery plans to minimize data loss in the event of a systemfailure.
8.
database upgrades and patch management: • plan andexecute database upgrades and apply patches and service packs asnecessary.
• ensure database systems are up-to-date and secure.benefits: 1.
direct hiring, 100% payroll mode.
2.
life insurance.3.
major medical expenses insurance (extends to spouse and childrenunder 25 years of age, if applicable).
4.
minor medical expenseinsurance.
5.
savings fund (up to mxn$4,300 monthly) 6.
foodvouchers (up to mxn$3,300 monthly) 7.
30 days' xmas bonus 8.
12days of vacation in the first year, increasing by 2 as dictated bylaw.
9.
extra days given by hcltech 10.
employee discounts.
dentalplan, car insurance, etc.