Ruben C.

Database Developer

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

Mon expérience

Voir plus

DBA & Data Engineer - Tiempo DevelopmentJuin 2019 - Présent

DBA & Data Engineer for one of the leading software engineering companies in the US designing, building, and deploying software that delights clients.
  • Designing data pipelines and platforms for large-scale, integrating data from several data sources.
  • Analyzing, diagnosing and identifying bottlenecks in data workflows. 
  • Monitoring and reporting the performance of data management systems. 
  • Data migration between different platforms. 
  • Data security and compliance.
  • Designing the Big Data strategy using Amazon Data Lakes and Spark. 
  • Data extract and transformation from MongoDB and MySQL using Python and JavaScript.
Voir plus

Cloud Engineer - Farrera y AsociadosNovembre 2018 - Juin 2019

Cloud Engineer within a Human Resources & Staffing company based in Guadalajara.
  • Supporting and administering internal Cloud and Azure Cloud, EDW SQL Server. 
  • Development ofscripts in Power shell. 
  • Backup and recovery with Commvault. 
  • Data Storage Management.
Voir plus

SAP HANA Senior Database Administrator - SAPAvril 2018 - Novembre 2018

SAP HANA Senior Database Administrator for a market leader in enterprise application software, helping companies of all sizes and in all industries run at their best.
  • Supporting daily operations performing DBA activities: installingconfiguring and administering system landscape, replication. 
  • Doing version upgrades, solving performance issues, analyzing EWA and Minichecks, memory sizing, applying SAP Notes solutions and workarounds. 
  • Performing table redistribution, reorganization of row store tables.
Voir plus

Manager – Development Team - Hewlett Packard EnterpriseMars 2015 - Février 2018

Manager – Development Team within an American multinational Information Technology organization that provides hardware and software services to small, medium and large sized businesses across industries.
  • Managing activities of ICs.
  • Supervising developer’s activities. 
  • Applying strong subject matter knowledge to manage staff activities in solving moderate to complex business/technical issues within established policies.
  • Understanding, articulating, and optimizing application and process capabilities for use by multiple business organizations. 
  • Directing and controlling activities for business. 
  • Planning, directing, and monitoring high-end operational activities of staff and driving the strategic plan for the team. 
  • Supporting and enabling innovation.
  • Understanding, articulating, and optimizing application and process capabilities for use by multiple/all business.
Voir plus

Oracle & SQL Server Senior Freelance Database Consultant - FreelanceJanvier 2010 - Janvier 2018

Oracle & SQL Server Senior Freelance Database Consultant 
  • Configuration & Administration of Oracle RAC 11/12, ASM Management.
  • Configuring, installing, migrating and administering SQL Server databases for all versions. 
  • Performance tuning for Oracle and SQL Server databases. 
  • Windows and Linux OS installation and configuration.
Voir plus

Manager - HPMars 2013 - Mars 2015

Manager for an American multinational Information Technology organization that provides hardware and software services to small, medium and large sized businesses across industries.
  • Leading the Global BI Development & Engineering data platform and development Team. 
  • Managing people who administer and develop systems such as Informatica Power Center, SAS, OLAP, OEMP, HARP, BOSS / BOE, QlikView and R.
Voir plus

DBA Team Lead - HPDécembre 2010 - Février 2013

DBA Team Lead for an American multinational Information Technology organization that provides hardware and software services to small, medium and large sized businesses across industries.
  • Leading the SQL Server local team.
  • Responsible in the day to day activities and guidance of team members. 
  • Setting targets, implementing guidelines, and assisting with any major issue on databases. 
  • Helping other DBAs to grow-up in their SQL Server knowledge. 
  • Providing advance training to rest of the DBA team. 
  • Following strategies, working with remote teams, using technology, workplace diversity. 
  • Dealingwith several management styles, mediation, macro, and micro-management.
Voir plus

DBA Oracle RAC / SQL Server - SOFTTEKNovembre 2008 - Novembre 2010

Database Administrator within a global company and the largest provider of IT services from Latin America.
  • Administration of 2 Oracle RAC environments (QA and Production) for GE Money using Oracle 10gR2, performing the following activities: 
    creating users, schemes, table spaces, solving performance issues, applying CPU, proactive monitoring, managing ASM, RAC services, exporting, importing and managing RMAN. 
  • Management of SQL Server 2008 instances, migration between SQL Server versions, performance of high availability systems,  sizing, stress tests, job scheduling and proactive monitoring, tuning performance, cluster administration.
Voir plus

Database Administrator SQL Server / Oracle - CONTINENTAL AGJuin 2007 - Octobre 2008

Database Administrator SQL Server / Oracle within a German multinational automotive parts manufacturing company specializing in brake systems, interior electronics, automotive safety, power train and chassis components, tachographs, tires and other parts for the automotive and transportation industries.
  • Administration, monitoring and performance of 30 instances of SQL Server 2000 and 2005, 1 instance of Oracle DB.
  • Setup and administration of Nagios as monitoring tool.
  • Full attendance (24x7) of the operation and monitoring
  • Leading of SQL Server domain migration with the integration of New Continental infrastructure.
  • Migration of SQL Server 2000 to SQL Server 2005 and Oracle 8 to 10g.
  • Project Leader of new Change Management Control over GDL IT Infrastructure based on ITIL policies.
Voir plus

Database Administrator - FLEXTRONICSAvril 2006 - Mai 2007

Database Administrator within a Singaporean-domiciled multinational technological manufacturer providing electronics manufacturing services.
  • Administration, monitoring and performance of 50 instances of SQL Server 2000 and 2005, 2 instance of Oracle DB, 10 Clusters of SQL Server 2005.
  • Fullattendance (24x7) of the operation and monitoring with Nagios. 
  • Created and led a group in India to provide support follow the sun. 
Voir plus

Project Leader / Software Engineer / DBA - General ElectricNovembre 2003 - Avril 2006

Project Leader / Software Engineer / DBA for an American multinational conglomerate operating through the following segments: aviation, healthcare, power, renewable energy, digital industry, additive manufacturing, venture capital and finance and lighting.
  • Project Leader for new customers working with groups of 5 or 6 team members.
  • SQL Server 2000 database administration.
  • System development using Visual Basic 6.0.
  • Designing reports in a Crystal Reports.
  • Technical support to productions systems.
Voir plus

Systems Manager - GRUPO ZETA GASOctobre 1999 - Octobre 2003

Systems Manager for a company operating mainly in the Oil & Gas sector.
  • Implementation of Windows active directory infrastructure.
  • SQL Server databases administration and development
  • Project Leader of a development team. 
  • Coaching theHelp desk support team.
  • Windows 2000 server’s administration (PDC, Domain Controller’s, Child Domain, Member Server, Stand Alone). 
  • Implementation of Active Directory Group Policies. 

Mes compétences

Langues parlées

SPANISH: Native speaker
ENGLISH: Advanced

Agile

Lean, Scrum

Web Technologies

JSON, AWS S3

Technologies

Apache Spark

Languages

Visual Basic, JavaScript, C/C++, SQL, Visual Basic 5, Scala, PowerShell, Python

Networks and Systems

AWS Lambda, Amazon Relational Database Service (RDS), Linux, UNIX, Windows Server, Azure Cloud, Amazon EC2, Azure

Analysis Methods and Tools

Agile Methods

Miscellaneous

Autonomy, Six Sigma, ITIL

DBMS

MongoDB, Microsoft SQL Server, Oracle, AWS Aurora, MySQL

Environment of Development

Borland Delphi

Business Intelligence / ETL

Crystal Reports, Informatica PowerCenter, OLAP, SAS, QlikView

Mes études et formations

Computer Science Degree - Institute of Technology of Chihuahua II.1992 - 1998