Sql Server Database Administrator

Contact

+525********* (Mobile)

******@*******.***

www.linkedin.com/in/fjasqldba

(LinkedIn)

app.respondent.io/r/

fernandojacinto-693afbebcd0e

(Other)

Top Skills

Software Installation

Software

Software Development Life Cycle

(SDLC)

Languages

English (Full Professional)

Spanish (Native or Bilingual)

Certifications

Mindfulness: Cómo conseguir una

atención plena

Azure AZ-900 Prep. Cert.: Microsoft

Azure Fundamentals

Microsoft Certified: Azure Data

Fundamentals

Azure Fundamentals

Bases de datos con un café

Fernando Jacinto-Álvarez

Bachelor's Degree in electric-electronic engineering at National Autonomous University of Mexico majoring in Telecomunications, IT, cybersecurity and Data platforms.

Donna, Texas, United States

Summary

SQL Server Database Administrator & IT sysadmin with 28 years of experience and a proven track record of designing, administering, and supporting database systems. Overall 28 years of experience with most of it in SQL Server on Azure SQL, 2022, 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7, 6.5 and Windows 365, 11, 2022, 2019, 2016, 2012, 2008 R2, 2008, 2003 R2, XP, Vista, ME, 2000, NT 4.0. Experienced with creating IT solutions for a large inventory of SQL Servers using technologies such as high availability clusters, Always- On, mirroring, Log-Shipping and Replication, or any third-party software or hardware-based like Veritas S2S, Vision Solutions, VMWare, or SAN replication. Expertise experience in installation and configuration of SQL 20##, 7, 6.5 database services. Expertise Experience in provisioning and configuring Servers and Databases in Microsoft Azure Platform as a Service (PaaS) and Microsoft Azure Infrastructure as a Service

(IaaS). Expertise experience in database Performance tuning, and query optimization using DMVs and DMFs. Experience with configuring and analyzing extended Events & PSS diag, SQLRAP, SQLnexus, ClearTrace, SQL Doctor and SQL diagnostic manager from Idera, Spotlight on SQL server, and Foglight from Quest Software. Experience in installation, configuration, Architect and administration of MS Analysis Services or DataWare House. Expertise Experience in building complex SSIS and DTSX packages using Business Intelligence Development Studio for ETL or ELT workloads. Experience in the implementation of encryption strategies such as Transparent Data Encryption (TDE) or from third-party tools like Vormetric. Solid IT infrastructure foundation and skilled in automation, scripting, security, and database development. Expertise experience in handling level-one, mission-critical applications. Experience with on-call problem resolution and triage in SQL Server environments. Experience working with teams such as Infrastructure, Storage, Networking, Development, MDM and QA. Page 1 of 18

Microsoft Certified Professional for SQL Server 2005, 2008, and Azure Infrastructure and Data Fundamentals using different clouds as well and offering the best option for customers using resources and budget to optimize cost and solutions.

Experience

Agile Global Resources, LLC

Senior Database Administrator

May 2018 - October 2024 (6 years 6 months)

Florida, United States

Partner for projects to work as a Sr. SQL Server Administrator Engineer and Big Data Architect for hybrid or cloud environments. Soluciones en tecnología

Senior Specialist Software Engineering

January 2003 - September 2024 (21 years 9 months)

Mexico City, Mexico

Software Engineer with career-level experience I am responsible for the overall delivery process of a software application or service. This includes design, development, testing, deployment, production application support (e.g., troubleshooting), and maintenance, all with a strong focus on automation. Key Roles and Responsibilities:

Collaborative Requirement Gathering: Work closely with stakeholders to gather and review software requirements and user stories. Software Design & Specifications: Provide estimates, create software design specifications, and collaborate with engineers/architects to assess hardware and software interactions.

Development & Methodologies: Execute specific development methodologies through the application of various programming languages. Automated Testing: Create and execute automated test plans and strategies based on business requirements. Collaborate with engineers, architects, and clients to validate test environments, data, and results. Page 2 of 18

Code Implementation & Validation: Design and implement code fixes, validate outcomes against expected results, and produce associated reporting. Comprehensive Testing: Responsibilities may include unit testing, dynamic application security testing, interface testing, integration testing, end-to-end testing, and/or user acceptance testing.

Application Support: Provide support for applications and solve configuration and environment issues.

Deployment Support: Assist in the software deployment process to ensure smooth transitions. Microsoft Azure/AWS/GCP/OCI/HEC environment using programming languages: Python, PowerShell, HTML, SQL and native or 3rd party tools.

Teleperformance

Bilingual Agent

June 2024 - August 2024 (3 months)

Mexico City, Mexico

I was helping on Debit Card Prevention Fraud team to fix issues with ATM and DC customers of Chase bank in USA and other countries. Upwork.com

Senior Database Administrator

September 2015 - July 2024 (8 years 11 months)

Remote

Working as a freelancer helping customers to make your database Servers faster an more reliable on premises and clouds like AWS, Azure, GCP, Blumix, HEC, Oracle, Rackspace, etc.

User Research International

Usability Consultant

April 2017 - June 2024 (7 years 3 months)

Redmond, Washington, United States

Provide feedback regarding software and improve product development for new releases and future versions for customers like Microsoft Azure new versions of portals and new releases for clouds or on-premises applications and data tools.

Appen

Page 3 of 18

Data Collector

December 2014 - May 2024 (9 years 6 months)

United States

Freelance consulting for several projects for different companies, like Facebook, Google, Microsoft, and clouds to test and load new products and cloud services and applications using AI and new technologies. Test.io

Software Quality Assurance Analyst

August 2023 - April 2024 (9 months)

United States

Testing applications on any device and different platforms, clouds like Azure or AWS, screen sizes, and operating systems to help customers deploy apps on stores or marketplaces without issues.

sqlservercheckup.com

Senior Database Consultant

December 2021 - March 2024 (2 years 4 months)

remote

Hardening of Microsoft SQL Server database clusters, instances or standalone servers to comply with best practices and recommendations to improve performance, fix configuration and implement less privilege principle after executing health checks, assestments and migration to clouds if needed to improve performance, ROI or budget.

Respondent

Participant

November 2019 - February 2024 (4 years 4 months)

New York City Metropolitan Area

You can apply to different projects.

Innovative Group

Senior Database Administrator

November 2023 - December 2023 (2 months)

Mexico City, Mexico

Implementation of a database environment with MySQL database server and Microsoft SQL Server with Machine Learning in Microsoft Azure cloud for the comprehensive management of waste for recognition of playe and cardboard images with the different clients where equipment was installed so that everything could be done the required logistics and documentation in various applications and databases, with a sustainable destination and Page 4 of 18

circular economy alternatives separating the productive environment of virtual machines from the corporate one to be in a different subscription for Mexico and Central America

The Walt Disney Company

Senior Database Administrator

February 2023 - August 2023 (7 months)

Burbank, California, United States

Attending database tickets with a global team based in America and Asia, main responsabilities:

Design and implement database & cloud / hybrid solutions Work with product and engineering teams to understand requirements, and evaluate new features & architecture to drive decisions Build collaborative partnerships with architects and key experts within other functional teams

Analyze business problems & technical environments to design high-quality technical solutions

Participate actively in code review and solutions testing to ensure it meets best practices

Build and foster a high-performance engineering culture, supervise and lead junior/middle tech team members

Write project documentation on Confluence

Technologies

MS SQL Server, PostgreSQL, Oracle

Fault Tolerance (Clustering, Replication, AlwaysOn AG, etc.) SQL optimization and relational DB principles, etc Cloud providers stack (AWS / Azure / GCP): Storage, Compute, Networking, Identity and Security RDBMS and Cubes, NoSQL, Data Processing, Data Analysis and Visualization, ETL

What I Have to help to my team:

Strong knowledge of complex performance tuning

Ability to analyze the on-prem infrastructure (DR, HA, Security) Understanding the housekeeping processes (archiving, purging, retention policies, hot/cold data, etc.)

Expertise in data security (audit, data masking and obfuscation) Page 5 of 18

Hands-on development experience using classic and modern cloud data components

Background in designing, implementing, deploying and monitoring scalable and fault-tolerant data solutions in the cloud

Proficiency in CI/CD principles and best practices Solid skills in data solutions troubleshooting, monitoring and support Competency in performance tuning and optimization, bottleneck problem analysis.

We were a team of technologists, strategists and designers. We help Disney transform their business through our engineering expertise, design thinking, and business consulting. We foster creativity and unconventional ways of doing things.

Panasonic North America

Senior Database Administrator

November 2022 - February 2023 (4 months)

Mexico City Metropolitan Area

Work with database engineers responsible for maintaining over 400 instances across multiple platforms, data centers, & consisting of over 999 TB of production data.

Support system and environment architecture, team goals, maintenance of existing systems, ensuring availability, stability, integrity, and recoverability, managing security, instance standardization, and coordinating on- and off- shore resources for 24/7 on-call support

Planned and coordinated production upgrades and migrations, including 2012 to 2016/17/19/22 version upgrades, stand-alone instances to clustered (FCI and AlwaysOn), unplanned recovery cutovers, and transitions to newer OS and hardware but retaining the same version of SQL Server (due to hardware - obsolescence).

Identification and remediation of NPPI in non-production systems in support of passing internal and GLBA/SOX audits, including creating a centralized data- driven scrubbing system for refreshing lower environments. Managed day-to-day (BAU) operations, ensuring requests, tickets, and changes were handled appropriately and generated/provided supporting metrics to upper management.

Maintained and enhanced job monitoring and alerts using internal and third- party tools.

Page 6 of 18

Created extensive centralized collection, tracking, and monitoring system for dictionary, environmental, security, and performance metrics supporting multiple data platforms using PowerShell.

Work on projects and coordinated with DevOps and Application DBA teams to improve the deployment automation process using SVN, Git, PowerShell, T-SQL, and File Tables and prepare for Continuous Integration/Continuous Improvement (CI/CD) including a collection and reporting system for providing project implementation and deployment statistics to management. Used in-house PowerShell to deploy across the company and worked with KT learning sessions, tutoring, and work on several escalation/projects, ETL, ELT Azure DevOps and moving a Dataware House and reporting services to Snowflake.

Axity

Advanced Database Administrator Engineer

January 2022 - February 2023 (1 year 2 months)

México, Mexico

Position's General Duties and Tasks:

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Database performance tuning.

Planning, deploying, maintaining, troubleshooting of high-availability database environments (Always-On, Clustering, Mirroring, etc.). Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

Refine and automate regular processes, track issues, and document changes, for efficiency and cost optimization.

Perform scheduled maintenance and support release deployment activities after hours.

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Work directly with end customer, business stakeholders as well as technical resources.

Multi-task and context-switch effectively between different activities and teams Sharing knowledge of High Availability (HA), Disaster Recovery (DR), Replication, SQLServer Database management, Database Tuning, Migration, Page 7 of 18

Upgrades, patching experience on On-Perm and Azure DBs, SSIS: ETL and or ELT, SSRS, T-SQL scripting, complex query tuning and schema refinement, supporting Logical DBA activities.

Managing, maintaining and implementing databases on customer datacenters and administering on different clouds like Acloud aka Axity cloud offering hybrid environments to customers on AWS, Azure, GCP or other clouds helping to reduce cost and optimize usage or sometimes returning to datacenters to minimize cost or because of compliance and regulations that do not allow to have information outside specific countries. Hildebrando

SQL Database Administrator

October 2010 - August 2022 (11 years 11 months)

Mexico City Metropolitan Area

Migrating databases to the last version and improving performance of queries implementing best practices assigned on customer site at Toluca datacenter facilities for HSBC Bank. Supporting ICW Group database operations helping customers remotely attending tickets using SNOW and histories on Jira and deploying with Gitlab and red-gate tools regarding database infrastructure using VMWare VDI connection and then jumping by RDP or SSMS and Azure Data Studio to connect databases instances. running SQL Server, Postgress, or any other database engine, deploying ETL packages using SSIS. Migraring database infrastructure to AWS Cloud to improve HA and DR and implement or migrate to new offerings and reduce licensing costs. Carhartt

Senior Database Administrator and Engineer

July 2018 - December 2021 (3 years 6 months)

Irapuato Mexico; Dearborn, Michigan, USA. and finally remote because of pandemic

Design and improve new database platforms including maintaining and growing the existing systems to enhance and optimize performance and operations. To ensure sound implementation, develop and generate logical and physical database designs, resulting data dictionaries and flow diagrams, test plans, and risk assessments. Research technological advancements to ensure that the database platforms are continuously improved, supported, and aligned with industry and company standards. Evaluate new data platforms to understand their potential and recommend future direction. Participate in and potentially lead cross-functional teams driving the development of solutions in support of new business and new applications. Lead the planning, Page 8 of 18

design, and implementation of new initiatives, working and collaborating with customers, vendors, and VARs to define requirements, manage projects, and communicate project status on the entire life-cycle of the project. Perform level-3 troubleshooting and diagnostics on all components within the various database platforms, including but not limited to SQL Server, ETL, and Talend MDM. Create task and procedure documentation, as well as communicate timely status on all relevant project information to appropriate personnel via incident tracking on ServiceNow and Jira task tracking systems. Analyze problems and look for trends, always keeping management informed of problem areas using Microsoft tools like EDI, SSMS, SSDT & Visual Studio 201x & 20xx to migrate SQL Server databases to the latest version and to Microsoft Azure and Oracle clouds for better performance on next months as a corporate goal and starting POC for SAP running on Windows and SQL Server for dev environment before migrate to SAP HANA on Azure as well. Testing POC to migrate SQL Server to Azure Cosmos DB, PostgreSQL, MySQL using the Azure Migration tool from Microsoft on Azure cloud using different environments in Azure VMWare Services, AWS, RackWare, Oracle and SAP HEC clouds.

CELERIS S. A. de C. V.

Sql Server Database Administrator

December 2010 - September 2018 (7 years 10 months) Mexico City, Mexico

I migrated and Implemented server side traces for audit trail purposes after updating databases to SQL 2005 from 2000 at ADT customer HQ and a failover cluster for ISSSTE using SQL Server 2012 migrating from 2008 and sending SSRS server to a different server to distribute workload and provide High availability.

IT Gurus Of Atlanta

Technical Support

June 2018 - July 2018 (2 months)

Mexico City Metropolitan Area

I was providing support on Nokia facilities in Santa Fe and Cuautitlan offices as a Hammerbach project assignation by hours.

SAP

Senior HANA Database Administrator

August 2017 - January 2018 (6 months)

Monterrey Area, Mexico

Page 9 of 18

HANA Database administrator as a member of Managed Cloud Delivery

(MCD) providing global support services (GSS) solving 3rd level tickets for customers from all over the world hosted on HANA Enterprise Cloud aka HEC and on-premise data centers and migrating or syncing databases on AWS, Azure, Google, Oracle, Citrix or VMWare clouds for clients running apps on Oracle, Sybase, SQL Server or any other database engine for SAP applications.

HCM Cloud Delivery Database team is a key organization, responsible for Operating SAP’s HCM Cloud Products Databases. Team needs to ensure, that the various Database landscapes are running well.

Installation, Configurations and maintenance of database software Database upgrades, patching, data migrations

Deploy & Implement database backup/replication & Disaster Recovery solutions

Control system resources usage and perform capacity planning, perform troubleshooting and diagnostics activities

Collect and analyze database performance information; identify and implement solutions to resolve performance related problems

Query optimization and tuning skills including cross database and cross server queries, analysis and troubleshooting interactions between databases, operating systems and applications with regard to performance and resources usage

Experience in database programming concepts including structured query language, stored procedures and triggers

Creating database tables, setting up indexes, data constraints and DB views. Analyze, predict through trend analysis and resolve database system, storage and application issues

Monitor SQL jobs in production and be responsible for load/hardware analysis mapping, fault tolerance and security.

Evaluate and implement database technologies and utilities Review and implement database changes

Provide timely response to system alerts and participate in the on-call schedule

Participate in 24x7 rotation shift supporting production and non-production databases

Drive Operational efficiency topics

Lane Automotive

Senior Database Administrator

March 2017 - July 2017 (5 months)

Page 10 of 18

Watervliet, Michigan, United States

i. Assist in, and document requirements gathering from project stakeholders and customers.

ii. Design, Implement, and Support the Lane Automotive’s Application Ecosystem using industry best practices.

iii. Complete other Database Administrative tasks as required, acting as Lane’s Tier 1 support for all critical and non-critical database instances and be on-call for after hours duties as required by projects, failures, upgrades and/or support needs. Assigned by Qstride.

iv. Migration from MongoDB to Cosmos DB using Azure DocumentDB Data Migration Tool for a DMZ database containing documents and replicating databases using AlwaysOn Availability Groups to Rackspace cloud provider that was used for DR and HA on Boston and Texas datacenters. EY

Technical Architect

March 2017 - March 2017 (1 month)

Saltillo, Coahuila, Mexico

I used to work as a SQL Server Database Administrator for a short project. Patient Education Genius by CoherentRx

SQL Server Security Consultant

October 2016 - February 2017 (5 months)

Troy, Michigan, United States

As a SQL Server Security Consultant I used to work with the Database Architects to develop and implement encryption methods and practices to ensure that our data is as secure and protected as it can be from hackers and other malicious agents.

Responsibilities:

# Arquitecture planning and Installation, configuration and administration of Microsoft Windows Servers running SQL Server.

# Work with the new SQL Server 2016 Always Encrypted features, the TDE, and/or security certificates to encrypt sensitive data.

# Develop plans to rotate keys and decrypt/re-encrypt data after an encryption keys have expired.

# Work with Database Architects to devise an expiration date for encryption keys based off of best practices.

# Debug and test encryption methods.

# Work with Web Application team to ensure that data is being properly decrypted and encrypted as it is being transferred from and to the database. Page 11 of 18

# Master Data Services and BIDS using BIML for manage customer and dashboards information for KPI.

Environment: SQL Server 2016 Always Encrypted, PowerShell, Visual Studio 2015, VMWare Cloud, Fortinet VPN, Windows Server 2012 R2, Microsoft Azure for disaster recovery and test workloads, Google Workspace. Interware de México

Senior Sql Server Database Administrator

August 2016 - October 2016 (3 months)

Miguel Hidalgo, Mexico City, Mexico

DBA assigned at Zurich to help with SQL, DB2 and Oracle tickets through service now.

Articulate complex technical solutions to a wide range of audiences in a clear, concise manner. I was working with multiple clients as part of a highly skilled technical team working in a fast-paced and demanding environment.

• Monitoring and responding to alerts posted from client databases.

• Troubleshooting SQL Server service outages as they occur. Track and resolve database related incidents and alerts within client service levels by following incident management procedures.

• Responding to client/chat email requests.

• Performing daily maintenance including monitoring backups, managing disk space, and maintaining database objects.

• Providing database security administration such as User ID’s, Passwords, roles, etc.

• Cloning and refreshing of databases.

• Participating in change management processes including deploying database changes in all environments as requested, following client change management standards and procedures.

• Assisting clients with disaster recovery rehearsals.

• Performing SQL Server installations, upgrades, migrations, and patching.

• Monitoring and tuning SQL Server database performance

• Maintaining client documentation including database topology, connection procedures, and special instructions.

• Mentoring, instructing, and providing guidance to lower level team members.

• Participating in on-call rotation and working occasionally after hours or on weekends.

SQL Server database administration including maintenance, troubleshooting and support; showing-depth understanding of SQL Server databases including versions SQL Server 2000, 2005, 2008, 2008R2, 2012, 2014, and 2016. DB2 and Oracle as well.

Page 12 of 18

Siscon

Senior Sql Database Administrator

November 2010 - July 2016 (5 years 9 months)

Tlalpan, Mexico City, Mexico

Providing support per hour or full days to customers as a second tier for database duties for ADT and other customers.

Honeywell

Sr. Database Administrator

September 2015 - May 2016 (9 months)

San Luis Potosí, San Luis Potosí, Mexico

Provide leadership and support in owning the operational performance of global database services. Responsible for driving strategy, oversight of the policies, procedures and activities related to operational effectiveness and performance improvement across global datacenters. Ensure a collaborative partnership with suppliers and key stakeholders in the organization that demonstrates teamwork, shared vision and organizational goals.

•Responsible and own the customer experience in regards to operational database effectiveness, driving reduction of the reworked incident tickets by 20%.

•Work cross functionally with Sr. Leadership to drive and deliver of key projects including SQL2008, 12, 14 and 2016 migrating from Oracle to SQL Server Clusters x DR/HA & subsequent upgrades to reduce licensing costs.

•Ensure organization’s operational resilience and cybersecurity practices are maintained and followed.

•Manage Supplier to drive service improvement and efficiency. Monitor and review processes, inputs and outputs for improvement recommendations and changes.

•Prepare executive reports and represent database operational performance at monthly meetings.

•Lead global support team, utilizing ITIL best practices for managing global (IT) infrastructure, development and operations.

•Manage day-to-day team operations: prioritizes work for week, Incident Management, root cause analysis and resolution activities. Properly communicates and escalate operational issues to upper management and business leads.

•Continuously provide guidance to service support team including: monitoring and VMWARE VRealize

Page 13 of 18

•Collaborate with Honeywell’s security and technology solutions team to ensure that required configuration management, backup and recovery, security management, and disaster recovery plans are in place and being followed.

•Monitoring global delivery of key integration between Service Management System and Oracle, SAP and Siebel CRM, BizTalk.

•MS SQL tuning & performance optimization.

T-Systems México

Senior Sql Database Administrator

September 2013 - September 2015 (2 years 1 month)

Huejotzingo, Puebla, Mexico

Solution delivery Team supporting several customers like DHL, National Grid, OneAmerica, McKesson, PHS, Presbiterian Hospitals and others from all over the world for new SQL Server projects, last project supporting Sql server databases for SAT datacenter as a "Sinergia de negocio" consultant. Dextra Technologies

Sql Server Database Administrator

April 2015 - August 2015 (5 months)

Toluquilla, Jalisco

Supporting split of HP on 2 new companies, HPI and HPE for SQL Server Databases using MOM and Microsoft SQL Server tools like: SSMS, SSRS, SSIS, Veritas site to site for replication, Log Shipping and HP Openview to and Manager for tickets.

ITSLN

Senior Database Architect

July 2007 - March 2015 (7 years 9 months)

Benito Juárez, Mexico City, Mexico

PAFE offering service from gold partner assigned in Citi, Banamex-CF, INEGI, UVM-UNITEC, CFE, Sonda, SCJN, ISSSTE, Mondelēz international, SAT as Database administrator and Architect for DWH on Triara VMWare virtual machine migrating from SQL 2012 to 2014 to improve Performance. Publicis Groupe

Senior Database Administrator

April 2014 - August 2014 (5 months)

Santiago de Querétaro, Querétaro, Mexico

Attending customers from all over the world for using Service Now ITIL webapp to manage database and related infraestructure, providing remote support using checkpoint VPN to administer several OLTP engines and Page 14 of 18

PeopleSoft applications running on SQL Server as RDBMs and starting migration from PeopleSoft to SAP and SQL 2014 also planning for setup Always On AGs on Azure as geographic replication for DR between USA and France Datacenter.

Tools: Microsoft Biztalk Server, PeopleSoft, Quest Automate to deploy changes, SAP, Lotus Notes, SQL Server.

Contacto Humano Consultores en Talento Humano

PAFE PArtner Field Engineer

April 2005 - August 2013 (8 years 5 months)

Mexico City Metropolitan Area

Microsoft Premier Local Support assigned by Qualita Services attending onsite for Banamex-Credito Familiar compliance integration implementing best practices based on policy configured by CITI group, Issste, SCJN and other government and private customers like UVM

and Unitec Universities during the integration project and relocation to a new datacenter as a SQL server database administrator, DB auditor compliance or best practices recommender, helping Technical Account Manager to deliver according to SLA and KPI goals.

Tools: OnBase, Veritas Backup and restore robot for backups, SQL Server, IIS, Banner, SQL Server Integration Services, Exchange, Visual Studio, Kyocera for patching servers, McAfee epo Antivirus, Genie backup pro for SQL Databases.

Ellucian

SQL Server Database Administrator I

November 2010 - April 2013 (2 years 6 months)

Atlixco, Puebla, Mexico

Solving service now tickets remotely from home. Responsibilities:

# Installed and Implemented SQL Server 2008. # Installed and monitored Replication.

# Implementing as an expert database best practices.

# Created and design databases for any requirement

# Implement systems on sql

Contact this candidate