Experience

Blueberry Consultants Ltd

• United Kingdom
• Software Development
• 1 - 100 Employee

• DevOps Engineer

  • Jun 2016 - Present

  I am working remotely from Venezuela using the following DBMS: MS SQL Server 2008, 2012, 2014, 2016, 2017 / MySQL 5.1, AWS Aurora, AWS RDS • DEVOPS experience by using the following tools: Jenkins/Gitlab/ Python/ Powershell / Bash/ Ansible / Terraform. • Perform all tasks related with Database administration like Backup/Restore, performance tuning, advanced troubleshooting to SQL server database performance issues for every database that belong to internal projects and external projects (I mean for many customers located in UK). • Advanced troubleshooting for .net application, I can perform troubleshooting to find the root cause of a web Application Hang / High CPU usage / Crash by taking memory dumps and then analyzing them by using WINDBG which is an advanced tool used by Microsoft support. • Create PowerShell/Python scripts to automate Sysadmins/DBA tasks (e.g., Create snapshots of every VM on each AWS account) • Manage Disaster and recovery techniques, snapshots, Security Rules, create test and live virtual machines, EIPs (Elastic IPs), IAM users and several related tasks on Amazon EC2. • Create reports using SQL server reporting services 2014 (SSRS) and onwards • Responsible for installing and configuring web sites using IIS7 on windows server 2008/2012R2/2016 • Apply updates and upgrade Virtual Machines. • Responsible of Windows Servers administration (2008/2012/2016), Linux server, LDAP, Jenkins • SSRS reports Development • LDAP administration Show less



Cadena Capriles

• Newspaper Publishing
• 1 - 100 Employee

• Database Administrator and System operating Administrator

  • Jan 2010 - 2015

  * Worked with the Rackspace hosting technicians and windows azure technicians in order to fix all issues that was affecting our operations. We first started hosting our web sites with Rackspace, then we migrated our infrastructure to Windows Azure. * Advanced experience working with wait statistics in Sql Server 2005, 2008R2 and 2012 this technique provide me a high level understanding to diagnose performance issues on this DBMS. * Advanced experience about how to debug application issues using Windbg to analize memory dumps to determine where the .Net application crashed or why it was consuming high CPU. * Responsible for installation and configuration of web sites using IIS7 on windows server 2008R2, as well as virtual machines in Windows Azure using Powershell to automate this process. * Strong Knowledge about the Windows azure Platform, I have knowledge about what are the best practices that we must to follow in order to run high performance and scalable web sites using distributed computing. * Implemented database standards and naming convention for the database objects. * Experience Creating and configuring an OLTP replication database for disaster recovery purpose. * Worked with developers to tune SQL queries using SQL Profiler and my own experience about how to create queries that works efficiently. * Provided 7 x 24 production supports for the databases and application issues. * Implemented Backup and Recovery plans for all the databases using Oracle 11g, Sql server 20012, MYSQL 5.0 * Implemented several jobs that monitor the sql server indexes in order to avoid fragmentations and to be sure that the indexes work efficiently every day. * Baselining and capacity planning of all the hardware related with the database servers. * Experienced in resolving deadlock and blocking issues for concurrent users Show less



Consorcio Credicard (Venezuela)

• Chacaito, Venezuela

• Database Administrator

  • Aug 2007 - Dec 2009

  MS SQL Server DBA/AS-400 / Mysql 5.0 / Oracle 10g, 9i Consorcio Credicard is a core banking company that creates credict cards to another banks in Venezuela, it also offers several services such as real-time electronic banking. I worked with the following tools: Pl/Sql , SqlPlus, Toad, Sql Navigator and Oracle Enterprise Manager, AS/400 V5R4M0, RPG ILE, RPG III, RLU, SDA, SEU, * Responsible for administering databases such as Db2 for AS-400 V5R4M0, Mysql 5.1, SQL Server 2000, 2005, Oracle 9i, Oracle 10g over the following operating systems over AIX 5.3, Windows 2003, AS-400 * Responsible to give support and help developers to tune their queries. I reduced the query execution times from 2 hours to 5 minutes in the DBMS DB2 for AS-400. So that helped to the whole batch process that run every night to reduce their full execution time from 8 hours to 5 hours. * Responsible for creation, configuration and tuning of the Oracle database for the SUAF system, SUAF is a fraud prevention system that handles the 70% banking transaction of Venezuela from years 2006 to 2009. * Responsible for database monitoring using the tool Oracle Enterprise Manager. * Updating with latest service packs and security patches. * Implementing stand by servers and Log shipping. * Troubleshooting Problems by using SQL server profiler. * Baselining and capacity planning of all the hardware related with the database servers. Later I suggested disk capacity, processors and memory based on the capacity planning. * Implemented database standards and naming convention for the database objects. * Involved in the development of SQL scripts to maintain administration tasks. Show less



Aserca Express

• Programador

  • 2000 - 2003

• Programador

  • 2000 - 2003