Job details

Work Location

Guadalajara, Mexico City, Monterrey

State / Region / Province

Jalisco, Mexico, Nuevo Léon

Country

Mexico

Domain

Delivery

Interest Group

Infy Mexico

Skills

Technology|Database administration|mySQL administration, Technology|Database Administration|Teradata Administration, Technology|Database|Teradata, Technology|infrastructure-database administration|SQL administration

Company

Infosys Mexico

Requisition ID

132212BR

Job description

Job Description:

• Supports the day-to-day availability and performance of SQL Server and Teradata operational support systems, including the ability to troubleshoot and isolate moderate to complex system/application issues for SQL Server and Teradata-based operating systems and hardware.
• Proposes and implements complex system enhancements (software and hardware updates) that will improve the performance and reliability of SQL Server and Teradata systems. Manages the configuration of both SQL Server and Teradata databases.
• Supports the rollout of complex projects that impact SQL Server and Teradata operational support systems. Installing, configuring, and testing different product sets on SQL Server 2008R2, 2012, 2014, 2016, 2017, 2019, and Teradata.
• Provides 24x7 support on a rotating basis and is responsible for performing the job in accordance with Client vision and values.

Roles & Responsibilities:

• Responsible for supporting 1000+ SQL DB servers (2000 to 2019) and Teradata databases, providing on-call support.
• Responsible for all operational aspects of SQL Server and Teradata database systems, including performance, integrity, and security.
• Plan and execute database migration from Microsoft SQL Server to PostgreSQL and Teradata upgrades/migrations.
• Respond to incidents, troubleshoot issues, and provide advice on improving database performance for both SQL Server and Teradata.
• Monitor performance of the databases and database servers; determine optimal performance parameters for the database servers, operating systems, etc., and tune as needed.
• Carry out periodic maintenance of the databases, including table extents, indexes, etc.
• Carry out periodic maintenance of the database platforms in terms of software updates, security updates, and service packs.
• Plan, test, and execute data migrations from Microsoft SQL Server DBMS to PostgreSQL DB and Teradata.
• Ensure that redundant database systems are properly maintained and available for activation as and when required.
• Carry out database design tasks in conjunction with the software development team and implement enhancements and modifications to the databases.
• Monitor database logs and take corrective action on issues if required.
• Participate in 24x7 on-call support on a weekly rotating schedule, including weekends.
• Develop and maintain Standard Operating Procedures/documentation.
• Experience in legacy DB versions (SQL Server 2000, 2005, 2008) as part of migrations to PostgreSQL and upgrades to SQL Server 2019.
• Provide escalation support for database-related issues.
• Share knowledge and mentor junior team members as needed.
• Develop administration automation and monitoring scripts as needed.

Required Industry Experience:

• 5 to 7 years of experience in SQL Server and knowledge of other RDBMS DBs.
• 3 to 5 years of experience in Teradata database administration.

Required Functional Experience:

• Excellent communication, interpersonal, and analytical skills.
• Planning and coordination skills.
• Experience with project management.
• Experience in vendor management.
• Experience with ITIL Incident, Change, Problem, and Release management processes.
• Experience and desire to work in a management consulting environment.
• Experience resolving more complex technical problems through a defined escalation process.
• Excellent written and verbal communication skills.
• Strong time management, process improvement, and scheduling skills.
• Able to work and communicate across multiple departments.
• Provides strategic/visionary recommendations.
• Establishes methods and procedures for the team.
• Initiates and owns process improvements and conveys changes to others, gaining organizational support for making changes.
• Extensive knowledge of key Client systems and processes.

Required Education and Certifications:

• Bachelor's degree from an accredited institution.
• Microsoft SQL Server administration (preferred).
• Teradata certification (preferred).

Additional Requirements:

• Experience with backup technologies such as IBM TSM, Avamar, and DELL DDBoost.
• Experience in working on ITSM tool BMC Remedy.

About Us
Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO
Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.