Jose Armando B.

Database Administrator

Externalisation nearshore
13 ans
Guadalajara, MEXICO
Contactez-nous à propos de ce profil

Mon expérience

Voir plus

World-renowned travel web platformMars 2021 - Présent

Database Administrator.

SKILLS
MySQL, MsSQL, PostgreSQL
Voir plus

KAZ ConsultingAoût 2018 - Janvier 2021

Database Manager within a company providing consultancy services.
  • Creation of work plans and compliance management.
  • Team coordination.
  • Management and control changes.
  • Coordination of tests, identification and mitigation of risks.
  • Close collaboration with suppliers.
  • Database administration using MsSQL Server, MySQL, PostgreSQL.
  • Decision making related to the databases department.
  • Installation and administration of operative systems (Windows Server, Linux RedHat and Centos).
  • Implementation production, Quality Assurance and databases environment development using SQL Server MySQL and PostgreSQL.
  • Modeling and designing relational databases.
  • Migrating SQL Server databases to MySQL and PostgreSQL.
  • Migration of physical infrastructure databases to virtual and cloud (AWS, Azure).
  • Installation and configuration of a high availability databases environment.
  • Active Directory, Clustering and databases management in Always On.
  • Configuration authentication mode (SQL Server and Windows authentication mode) logins, server roles, database users and users based on certificates or asymmetric keys.
  • Configuration or change of the Default port in SQL Server.
  • Tuning on Stored Procedures or Very Cost query.
  • Configuration and monitoringreplications of Transnational, Merge and Snapshot of databases, with one Publication and a lot of subscriptions.
  • SQL Server encryption hierarchy, transparent data encryption and always encrypted and dynamic data masking.
  • Logical policy implementation and physical backup, recovery and compression.
  • Capacity growth projection of databases.
  • Creating policies regarding the safety standard and databases.
  • Installing SQL Server database engine 2000-2017 versions to stand alone, virtual machines and Cloud (IaaS, Paas, SaaS).
  • Configuring and managing high availability environments (cluster, AG).
  • Configuration of SSIS, SASS, SSRS and Poly-base services.
  • ETL medium with SSIS and Pentaho Data Integration.
  • Definition of programming and scheduling administrative tasks for maintaining the database (Back UP, Back up Log Rebuilt index or reorganize, Update statistics, Referential integrity, Clean Log, Monitoring space free and Growth of data files and monitoring locks in databases).
Voir plus

PromologisticsAvril 2012 - Août 2018

Senior Database Administrator within a company providing logistics services.
  • Installation and administration of operative systems (Windows Server, Linux RedHat and CentOS).
  • Production implementation, Quality Assurance and databases environment development using SQL Server MySQL and PostgreSQL.
  • Database administration using MsSQL Server, MySQL, PostgreSQL.
  • Modeling and designing relational databases.
  • Migrating SQL Server databases to MySQL and PostgreSQL.
  • Migration of physical infrastructure databases to virtual and cloud (AWS, Azure).
  • Installation and configuration of a high availability databases environment.
  • Active Directory, Clustering and databases management in Always On.
  • Configuration authentication mode (SQL Server and Windows authentication mode) logins, server roles, database users and users based on certificates or asymmetric keys.
  • Configuration or change of the Default port in SQL Server.
  • Tuning on Stored Procedure or Very Cost query.
  • Configuration and monitoring replications of Transnational, Merge and Snapshot of databases, with one Publication and a lot of subscriptions.
  • SQL Server encryption hierarchy, transparent data encryption and always encrypted and dynamic data masking.
  • Logical policy implementation and physical backup, recovery and compression.
  • Capacity growth projection of databases.
  • Creating policies regarding the safety standard and databases.
  • Installing SQL Server database engine 2000-2017 versions to stand alone, virtual machines and Cloud (IaaS, Paas, SaaS).
  • Configuring and managing high availability environments (cluster, AG).
  • Configuration of SSIS, SASS, SSRS and Poly-base services.
  • ETL medium with SSIS and Pentaho Data Integration.
  • Definition of programming and scheduling administrative tasks for maintaining the database (Back UP, Back up Log Rebuilt index or reorganize, Update statistics, Referential integrity, Clean Log, Monitoring space free and Growth of data files and monitoring locks in databases).
  • Safety administration and configuration logins.
  • Design and implementation of contingency plans for disaster prevention and contingencies.
  • Implementing reports with PowerBI.
  • Upgrading databases, performance tuning, query optimization.
  • Detection of bottlenecks and resource governance.
  • Audits and Standard Databases.
  • Monitoring the databases, processing and scheduling reports, collecting data and email alert settings.
  • Documentation and standardization of operating instructions.
  • Tracking changes and versions of objects.
  • Generating ER diagrams for documenting the database data dictionary.
Voir plus

CE ConsultingAoût 2008 - Mars 2012

Senior Database Administrator within a company providing consultancy services.
  • Modeling and designing relational databases.
  • Migrating SQL Server databases to MySQL and PostgreSQL.
  • Migration of physical infrastructure databases to virtual and cloud (AWS, Azure).
  • Installation and configuration of a high availability databases environment.
  • Active Directory, Clustering and databases management in Always On.
  • Configuration authentication mode (SQL Server and Windows authentication mode) logins, server roles, database users and users based on certificates or asymmetric keys.
  • Configuration or change of the Default port in SQL Server.
  • Tuning on Stored Procedures or Very Cost query.
  • Configuration and monitoring replications of Transnational, Merge and Snapshot of databases, with one Publication and a lot of subscriptions.
  • SQL Server encryption hierarchy, transparent data encryption and always encrypted and dynamic data masking.
  • Logical policy implementation and physical backup, recovery and compression.
  • Capacity growth projection of databases.
  • Creating policies regarding the safety standard and databases.
  • Installing SQL Server database engine 2000-2017 versions to stand alone, virtual machines and Cloud (IaaS, Paas, SaaS).
  • Configuring and managing high availability environments (cluster, AG).
  • Configuration of SSIS, SASS, SSRS and Poly-base services.
  • ETL medium with SSIS and Pentaho Data Integration.
  • Definition of programming and scheduling administrative tasks for maintaining the database (Back UP, Back up Log Rebuilt index or reorganize, Update statistics, Referential integrity, Clean Log, Monitoring space free and Growth of data files and monitoring locks in databases).
  • Safety administration and configuration logins.
  • Design and implementation of contingency plans for disaster prevention and contingencies.
  • Implementing reports with PowerBI.
  • Upgrading databases, performance tuning, query optimization.
  • Detection of bottlenecks and resource governance.
  • Audits and Standard Databases.
  • Monitoring the databases, processing and scheduling reports, collecting data and email alert settings.
  • Documentation and standardization of operating instructions.
  • Tracking changes and versions of objects.
  • Generating ER diagrams for documenting the database data dictionary.

Mes études et formations

Bachelor's Degree in Computer Systems Engineering - ESCOM Superior School of Computing.2001 - 2006