Ruben C.

Database Developer

Contact us for this profile

My experience

More

DBA & Data Engineer - Tiempo DevelopmentJune 2019 - Present

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.
More

Cloud Engineer - Farrera y AsociadosNovember 2018 - June 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.
More

SAP HANA Senior Database Administrator - SAPApril 2018 - November 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.
More

Manager – Development Team - Hewlett Packard EnterpriseMarch 2015 - February 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.
More

Oracle & SQL Server Senior Freelance Database Consultant - FreelanceJanuary 2010 - January 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.
More

Manager - HPMarch 2013 - March 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.
More

DBA Team Lead - HPDecember 2010 - February 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.
More

DBA Oracle RAC / SQL Server - SOFTTEKNovember 2008 - November 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.
More

Database Administrator SQL Server / Oracle - CONTINENTAL AGJune 2007 - October 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.
More

Database Administrator - FLEXTRONICSApril 2006 - May 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. 
More

Project Leader / Software Engineer / DBA - General ElectricNovember 2003 - April 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.
More

Systems Manager - GRUPO ZETA GASOctober 1999 - October 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. 

My stack

Spoken languages

ENGLISH: Advanced
SPANISH: Native speaker

Agile

Lean, Scrum

Technologies

Apache Spark

Environment of Development

Borland Delphi

Languages

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

Analysis Methods and Tools

Agile Methods

Miscellaneous

Autonomy, ITIL, Six Sigma

Networks and Systems

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

DBMS

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

Web Technologies

JSON, AWS S3

Business Intelligence / ETL

SAS, QlikView, Crystal Reports, OLAP, Informatica PowerCenter

My education and trainings

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