Nelson Andres Zavala Jimenez
Guadalajara
Summary
Experienced professional with a solid background in effectively managing and optimizing database systems. Demonstrated success in data security, performance fine-tuning, and implementing disaster recovery measures. Collaborative team player dedicated to achieving results and adept at adapting to evolving needs. Proficient in SQL, database design, and automation with a reliable and flexible approach to overcoming challenges.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Database Administrator SQL Server
TATA Consultancy Services
10.2010 - Current
- Design and create SSIS packages to migrate data from multiple data sources
- Experience using SQL Server Management Studio (SSMS)
- Follow ITIL, Agile, Scrum models
- Capable to conceptualize, design and write SQL queries, stored procedures, Functions, CTE, Scalar and User defined Functions, Inline and Multi Statement Table Value Functions
- Creation and Maintain of Backup strategies and capacity plans
- Set and Troubleshoot issues on Always On - Availability Groups, Primary and Secondary servers
- Administration and Control of automated processes in SQL Server in all versions
- Maintain or Create Jobs, Clean-up Jobs and troubleshoot issues, schedules
- Troubleshoot database issues, checking logs, space issues, performance issues etc
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Set up and controlled user profiles and access levels for each database segment to protect important data.
- Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
- Worked with staff to develop and implement procedures to prevent data loss and maximize system availability.
Database Administrator MS SQL Server
Dell Services
02.2008 - 09.2010
- Query development using Microsoft SQL Server SSMS, working with Transact-SQL
- Installing & configuring SQL Server 2000/2005/2008
- Upgrading from Previous Versions
- Creating Indexes, Tables, Constraints, and User-Defined, functions and types
- Backing up, Restoring, and Moving Databases in SQL Server
- Experience with relational databases
- Technical support via Terminal Services
- I used to create reports using SQL Server Reporting Services (SSRS)
Junior Database Administrator MS SQL Server, Developer C
Pana Credit S.A. de C.V.
11.2006 - 01.2008
- Call Centre, Preventive and corrective maintenance of computer equipment
- Database SQL Server 2000/2005 support and administration
- Administration and Control of automated processes in SQL Server 2000, 2005
- Database Mirroring and Snapshots
- Triggers, Store procedures, backups, DTS
- Hands on SQL Server Analysis Services (SSAS)
- I used to create Queries in SQL Server 2000/2005
- Installing SQL Server 2000/2005
- Use Active Directory
Education
Bachelor's Degree - Information Technology Development
Universidad Del Valle De México (UVM)
Guadalajara, Jalisco, Mexico09.2016
Professional Certificate - English 2007-2009 TOEIC
Interlingua
12.2009
Technical Degree -
Universidad Tecnologica De Jalisco (UTJ)
Guadalajara, Jalisco, Mexico09.2002
Skills
- Database management
- Backup and recovery
- Database monitoring
- Database troubleshooting
- Relational database management
- Query optimization
- Running backups
- Stored procedures
Certification
- 02/01/17, ITIL v3 Information Technology Infrastructure Library, ExecuTrain, Guadalajara, Jalisco, Mexico
- 05/01/05, Microsoft SQL Server - MCTS: SQL Server 2005, Implementation and Maintenance, ExecuTrain, Guadalajara, Jalisco, Mexico
- 04/01/08, Microsoft SQL Server 2008 - Implementation and Maintenance, ExecuTrain, Guadalajara, Jalisco, Mexico
Hobbies and Interests
- Innovate and create my own videogames in my free time.
- Go to the Movies.
- Play Videogames.
- Read about technology.
- Exercise almost every day for good health.
Personal Information
- Place of Birth: Jalisco
- Date of Birth: 09/05/79
- Gender: Male
- Nationality: Mexican
- Marital Status: Married
Languages
English
Bilingual or Proficient (C2)
Timeline
Database Administrator SQL Server
TATA Consultancy Services
10.2010 - Current
Database Administrator MS SQL Server
Dell Services
02.2008 - 09.2010
Junior Database Administrator MS SQL Server, Developer C
Pana Credit S.A. de C.V.
11.2006 - 01.2008
Professional Certificate - English 2007-2009 TOEIC
Interlingua
- 02/01/17, ITIL v3 Information Technology Infrastructure Library, ExecuTrain, Guadalajara, Jalisco, Mexico
- 05/01/05, Microsoft SQL Server - MCTS: SQL Server 2005, Implementation and Maintenance, ExecuTrain, Guadalajara, Jalisco, Mexico
- 04/01/08, Microsoft SQL Server 2008 - Implementation and Maintenance, ExecuTrain, Guadalajara, Jalisco, Mexico
Bachelor's Degree - Information Technology Development
Universidad Del Valle De México (UVM)
Technical Degree -
Universidad Tecnologica De Jalisco (UTJ)
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services