$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Database Administrator Python Backend Developer
Juan Carlos Farina
,
Stevenage, United Kingdom
Experience
Other titles
Skills
I'm offering
I've been working with relational and NoSQL databases (SQLite, MySQL, MariaDB, Percona Server, PostgreSQL, MSSQL, MongoDB, and Cassandra) for more than 15 years. During all that time I have used Python for database automation, ETL processes, industrial devices integration, web scraping, etc...
On the other side, I've been involved in large as well as small projects, so I can easily adapt to the work needs in a very short time.
Having said that, I believe that I can fulfill any project requirements very well.
Please do not hesitate to contact me at your earliest convenience so we can discuss further details.
On the other side, I've been involved in large as well as small projects, so I can easily adapt to the work needs in a very short time.
Having said that, I believe that I can fulfill any project requirements very well.
Please do not hesitate to contact me at your earliest convenience so we can discuss further details.
Markets
United Kingdom
Language
English
Fluently
Spanish
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - 2019
job
Senior DBA and Python Backend developer
Actual.
Compare the Market is one of the UK's most loved price comparison websites. It is best known for offering an independent and impartial comparison on car and home insurance products. As an insurance intermediary it does a whole lot more besides. It provides a comparison of the price, cover and features of van, bike, travel, pet and life insurance as well as energy tariffs, broadband and mobile phone packages and financial products such as mortgages, credit cards, loans, savings and current accounts.
Database Department.
Role: Senior DBA and Python Backend developer.
• Deploy new MongoDB instances in AWS needed for the migration, using Terraform
• MongoDB migration from On Premises and Amazon based environments to Mongo Atlas
• MS-SQL Server Monitoring and daily resolution of production related issues.
• ETL Processes performed with Python
• Prepare MongoDB environments (Test, Load, Shadow, UAT) to prepare migration to Atlas.
• Python, MongoDB and SQL procedures to generate GDPR reports.
• MongoDB patching and upgrade procedures to maintain MongoDB up to date.
• Define Python standards and ensure implementation and use.
• Setup a Logs rotation policy.
• Improve existing development with new rules.
https://www.comparethemarket.com
Database Department.
Role: Senior DBA and Python Backend developer.
• Deploy new MongoDB instances in AWS needed for the migration, using Terraform
• MongoDB migration from On Premises and Amazon based environments to Mongo Atlas
• MS-SQL Server Monitoring and daily resolution of production related issues.
• ETL Processes performed with Python
• Prepare MongoDB environments (Test, Load, Shadow, UAT) to prepare migration to Atlas.
• Python, MongoDB and SQL procedures to generate GDPR reports.
• MongoDB patching and upgrade procedures to maintain MongoDB up to date.
• Define Python standards and ensure implementation and use.
• Setup a Logs rotation policy.
• Improve existing development with new rules.
https://www.comparethemarket.com
Implementation, UP, Processes, Backend, Energy, Energy, Production, Server, Mongo, Development, Insurance, Amazon, Monitoring, Sql, Developer, It, Test, GDpr, ETL, Database, Websites, MongoDB, SQL Server, AWS, Backend, Python
2018 - 2019
job
Python Backend developer
RSAGroup.
DEC/2018 - JU/2019. RSA is a world leader insurance company with 13,500 employees, serving 9 million customers in over 100 countries. The GeoRisk database is based on a MS-SQL Server platform, and data extraction and transformation is performed with Python development.
GeoRisk Area.
Role: Python Backend developer.
• ETL Processes performed with Python
• Development of Accumulation Reports, using Python and Excel.
• Adding support for geographic objects to PostgreSQL using PostGIS.
• Setup Python and SQL procedures to refresh the Address Based Premium (ABP) database.
• Expand the Flooding model to calculate risk exposure and forecast future floods.
• Develop a standard Logging module to be used by all Python software.
• Setup a rotation policy and corresponding procedures to rotate logs.
• Define Python standards and ensure implementation and use.
https://www.rsagroup.com/
GeoRisk Area.
Role: Python Backend developer.
• ETL Processes performed with Python
• Development of Accumulation Reports, using Python and Excel.
• Adding support for geographic objects to PostgreSQL using PostGIS.
• Setup Python and SQL procedures to refresh the Address Based Premium (ABP) database.
• Expand the Flooding model to calculate risk exposure and forecast future floods.
• Develop a standard Logging module to be used by all Python software.
• Setup a rotation policy and corresponding procedures to rotate logs.
• Define Python standards and ensure implementation and use.
https://www.rsagroup.com/
Implementation, Processes, Backend, Forecast, Server, Software, Development, Insurance, Support, Transformation, Sql, Developer, ETL, Database, PostgreSQL, SQL Server, Backend, Python, Excel
2016 - 2018
job
YOOX NET-A-PORTER
YNAP.
is one of the largest eCommerce platform in the World, focused on fashion and luxury shopping. Since launching in June 2000, NET-A-PORTER has established itself as the world's premier luxury fashion destination. A pioneer of innovation, NET-A-PORTER speaks to a monthly audience of over 6 million via a global multi-channel ecosystem, including The EDIT digital magazine, PORTER magazine, and net-a-porter.com, offering a seamless shopping experience across mobile, tablet and desktop. All this e-Commerce structure is supported with several hundred of servers deployed across the world (New York, London, Bologna, Moscow, Hong Kong, etc ), running more than 200 Terabytes of data. The main objectives of the project are: to support the production, to implement the migration of multiple servers from physical environments to virtual environments (VMWare) and to implement the migration of MySQL from versions 5.5 and 5.6 to 5.7.
Database Administration and Architecture.
Role: Database Production Support. MySQL, PostgreSQL, MSSQL and MongoDB.
• Design and Setup Clustering and Replication (MySQL and PostgreSQL).
• Ensure 24x7 production support (MySQL & PostgreSQL).
• Ensure High Availability for all database platform, including AWS.
• Monitor and control database replication among regions (PostgreSQL & MySQL).
• Monitor that databases perform within established KPIs (MySQL & PostgreSQL).
• Analyze and Improve database performance (MySQL & PostgreSQL).
• Review DB Architecture and propose alternative models when needed.
• Deploy new database servers to create clusters for migration (using puppet).
• Design and implement a migration plan (3 Tb from MySQL 5.5 to MySQL 5.7).
• Database Security (All Platforms).
• Keep Database documentation updated (All Platforms, including AWS).
• Periodically test the failover procedures to minimize Disaster Recovery times.
Python and Bash development
• Using bash, develop a script to run the daily backups with Percona Xtrabackup.
• Develop an ETL application, using Python, to extract data from several MySQL PostgreSQL and MongoDB databases and load it into an Oracle instance to produce MIS reporting.
• Develop a Python script to grant users security to specific MySQL reporting slaves in some MySQL clusters.
• Develop several scripts in Python to retrieve KPI (i.e: memory usage, disk usage, TPS, errors recorded in the logs, innodb internal indicators, replication lags) from several MySQL clusters to feed the Grafana monitoring system and also to inform the users by mail.
https://www.net-a-porter.com/gb/en/
Database Administration and Architecture.
Role: Database Production Support. MySQL, PostgreSQL, MSSQL and MongoDB.
• Design and Setup Clustering and Replication (MySQL and PostgreSQL).
• Ensure 24x7 production support (MySQL & PostgreSQL).
• Ensure High Availability for all database platform, including AWS.
• Monitor and control database replication among regions (PostgreSQL & MySQL).
• Monitor that databases perform within established KPIs (MySQL & PostgreSQL).
• Analyze and Improve database performance (MySQL & PostgreSQL).
• Review DB Architecture and propose alternative models when needed.
• Deploy new database servers to create clusters for migration (using puppet).
• Design and implement a migration plan (3 Tb from MySQL 5.5 to MySQL 5.7).
• Database Security (All Platforms).
• Keep Database documentation updated (All Platforms, including AWS).
• Periodically test the failover procedures to minimize Disaster Recovery times.
Python and Bash development
• Using bash, develop a script to run the daily backups with Percona Xtrabackup.
• Develop an ETL application, using Python, to extract data from several MySQL PostgreSQL and MongoDB databases and load it into an Oracle instance to produce MIS reporting.
• Develop a Python script to grant users security to specific MySQL reporting slaves in some MySQL clusters.
• Develop several scripts in Python to retrieve KPI (i.e: memory usage, disk usage, TPS, errors recorded in the logs, innodb internal indicators, replication lags) from several MySQL clusters to feed the Grafana monitoring system and also to inform the users by mail.
https://www.net-a-porter.com/gb/en/
ETL, Production, Development, KPI, Monitoring, Support, It, Net, Security, Architecture, Test, Bash, Database administration, Fashion, SoMe, Design, Database, E-commerce, MSSQL, VMware, Innovation, PostgreSQL, MongoDB, Oracle, AWS, Ecommerce, Administration, .Net, Python, Mysql
2016 - 2016
job
DBA
unknown.
O2 London-United Kingdom, AUG/2016 - OCT/2016. O2 is an important mobile operator and Internet Service Provider (ISP) in the UK, working as a subsidiary of Telefonica de España. The main goal of the project is to provide production support to the O2 Wifi platform as well as improving the architecture and help with the migration of several DB instances still running under all versions of MySQL.
Database Administration and Architecture.
Role: Database Production Support. MySQL, MariaDB DBA.
• Migrate all databases to SSD drives to improve performance.
• Monitor and control database replication among regions.
• Analyze and Improve database performance.
• Review DB Architecture and propose an alternative model to scale up readings.
• Analyze migration from Galera Cluster to native MariaDB replication using MaxScale.
• Keep Database documentation updated.
http://www.o2.co.uk
Database Administration and Architecture.
Role: Database Production Support. MySQL, MariaDB DBA.
• Migrate all databases to SSD drives to improve performance.
• Monitor and control database replication among regions.
• Analyze and Improve database performance.
• Review DB Architecture and propose an alternative model to scale up readings.
• Analyze migration from Galera Cluster to native MariaDB replication using MaxScale.
• Keep Database documentation updated.
http://www.o2.co.uk
Mysql, Administration, Database, Database administration, Service, Architecture, Mariadb, Support, Internet, WiFi, Http, Production, Native, UP
2014 - 2014
job
restaurants and specialist supermarkets
EUROFOODS.
New Port (Wales)-United Kingdom, NOV/2014 - DEC/2014. EUROFOODS is a wholesale supplier to the catering industry, restaurants and specialist supermarkets.
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MariaDB DBA. Architecture & Development Team).
• Database Design (Logical and Physical).
• Design and Setup Clustering and Replication.
• Install Servers (Operating System and RDBMS)
• Document installation.
• Design and implement Backup and Disaster Recovery Plans.
http://www.kukd.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MariaDB DBA. Architecture & Development Team).
• Database Design (Logical and Physical).
• Design and Setup Clustering and Replication.
• Install Servers (Operating System and RDBMS)
• Document installation.
• Design and implement Backup and Disaster Recovery Plans.
http://www.kukd.com
Design, Mysql, Administration, Database, Database design, Architecture, Mariadb, Development, Backup, Http, Wholesale
2014 - 2014
job
I+D (MySQL DBA. Migration Team)
IPACCESS.
Cambridge-United Kingdom, DEC/2014 - MAR/2014. IPACCESS is a company specialized in manufacturing end-to-end Small Cell solutions for Tier 1 & Tier 2 operators around the world, Gateways and Management Systems.
Database Architecture and Administration (DBA).
Role: I+D (MySQL DBA. Migration Team).
• Design a High Availability Database platform to support a software application (Presence Collector) with intensive traffic (around 30.000 TPS).
• Deploy, install and setup the above platform for DEV, UAT and PROD environments.
• Document all the installation.
• Design and implement Backup and Disaster Recovery Plans.
• Identify and implement Database Security Controls.
• Help Development group, giving guidance and advice on best practices and standards
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
http://www.ipaccess.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL DBA. Migration Team).
• Design a High Availability Database platform to support a software application (Presence Collector) with intensive traffic (around 30.000 TPS).
• Deploy, install and setup the above platform for DEV, UAT and PROD environments.
• Document all the installation.
• Design and implement Backup and Disaster Recovery Plans.
• Identify and implement Database Security Controls.
• Help Development group, giving guidance and advice on best practices and standards
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
http://www.ipaccess.com
Design, Mysql, Administration, Database, Management, Architecture, Security, Support, Development, Backup, Software, Http, Scalability
2014 - 2014
job
I+D (MySQL and MongoDB DBA. Migration Team)
MASTERNAUT.
Leeds-United Kingdom, MAY/2014 - NOV/2014. MASTERNAUT is a company that provides mobile assets tracking software products based on satellite applications.
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MongoDB DBA. Migration Team).
• Production support to different production units (Spain, France, UK, etc ).
• Document all the installation.
• Design and implement Backup and Disaster Recovery Plans.
• Installation MongoDB database for all environments
• Design a backup procedure for MongoDB and check that backups are usable.
• Verify Users permissions in MongoDB
• Check performance in all MongoDB instances in production.
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
• Develop a ETL application to read data from MongoDB and MySQL databases and load it into another MySQL instance used as a Datawarehouse.
http://www.masternaut.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MongoDB DBA. Migration Team).
• Production support to different production units (Spain, France, UK, etc ).
• Document all the installation.
• Design and implement Backup and Disaster Recovery Plans.
• Installation MongoDB database for all environments
• Design a backup procedure for MongoDB and check that backups are usable.
• Verify Users permissions in MongoDB
• Check performance in all MongoDB instances in production.
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
• Develop a ETL application to read data from MongoDB and MySQL databases and load it into another MySQL instance used as a Datawarehouse.
http://www.masternaut.com
Design, Mysql, Administration, MongoDB, Database, ETL, Architecture, It, Support, Backup, Software, Http, Scalability, Production
2014 - 2014
job
I+D (MySQL and MariaDB DBA)
WONGA.
Dublin-Ireland, APRIL/2014 - APRIL/2014. WONGA is a digital finance company providing short term credit to consumers and businesses, operating in several European countries.
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MariaDB DBA).
• Production support to different production unites (Spain, UK and Ireland).
• Performance tuning.
• Design and implement Backup and Disaster Recovery Plans.
• Database migration from Windows servers to Linux based servers.
• Setup Replication and HA.
http://www.wonga.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL and MariaDB DBA).
• Production support to different production unites (Spain, UK and Ireland).
• Performance tuning.
• Design and implement Backup and Disaster Recovery Plans.
• Database migration from Windows servers to Linux based servers.
• Setup Replication and HA.
http://www.wonga.com
Design, Mysql, Linux, Administration, Database, Finance, Windows, Architecture, Mariadb, Support, Backup, Http, Production, Tuning
2013 - 2013
job
I+D (MySQL DBA. Migration Team) and MSSQL production support
Financial Times.
London-United Kingdom, AUG/2013 -DEC/2013. The Financial Times (FT) is a British English-language international daily newspaper with a special emphasis on business and economic news in the United Kingdom and internationally. The FT has an average daily readership of 2.2 million people worldwide. FT.com has 4.5 million registered users and over 285.000 digital subscribers as well as 600.000 paying users.
Database Architecture and Administration (DBA).
Role: I+D (MySQL DBA. Migration Team) and MSSQL production support.
• Design a migration plan to go from MySQL 5.0 to MariaDB 5.5 for all environments (PROD, TEST, INTEGRATION and DEV).
• Design and implement new schemas.
• Implement Cluster and HA for specific subsystems
• Help DevOps to automate system delivery
• Identify the hardware resources (servers and storage) needed for the migration.
• Identify the people responsible in each area (systems, networking, development, etc ).
• Implement a LAB environment to test applications working in the new database.
• Prepare old servers (aprox. 400 instances with more than 1000 databases) to be migrated.
• Implement the migration plan for each application/environment identified.
http://www.ft.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL DBA. Migration Team) and MSSQL production support.
• Design a migration plan to go from MySQL 5.0 to MariaDB 5.5 for all environments (PROD, TEST, INTEGRATION and DEV).
• Design and implement new schemas.
• Implement Cluster and HA for specific subsystems
• Help DevOps to automate system delivery
• Identify the hardware resources (servers and storage) needed for the migration.
• Identify the people responsible in each area (systems, networking, development, etc ).
• Implement a LAB environment to test applications working in the new database.
• Prepare old servers (aprox. 400 instances with more than 1000 databases) to be migrated.
• Implement the migration plan for each application/environment identified.
http://www.ft.com
Architecture, Go, Production, Http, International, Storage, Development, Hardware, Support, Mariadb, Design, Test, Integration, Database, MSSQL, DevOps, Networking, Administration, Mysql
2013 - 2013
job
DBA
WHIZZ Education.
London-United Kingdom APR/2013 - JUL/2013. Whizz is a company dedicated to deploy personalized learning solutions, delivering services worldwide throughout Jordan, Kazakhstan, New Zealand, Russia, United Arab Emirate, United Kingdom and the United States.
Database Architecture and Administration (DBA).
Role: I+D (MySQL & MS SQL Server DBA. Production Support and Architecting).
• Testing AWS Lambda Services in UAT to determine application in production.
• Analyze the database configuration to detect issues affecting performance.
• Analyze slow queries affecting the production environment (MS SQL & MySQL).
• Migrate from MySQL 5.0 to MySQL 5.5, from Amazon EC2 to Amazon RDS Services
• Define partition criteria for several big tables and implement partitioning.
• Daily maintenance and optimization of HA EC2 & RDS Installations
• Ensure stability, scalability, best performance of the MySQL and MS SQL data platform.
• Work with development group, giving guidance and advice on best practices and standards.
• Support development groups during deployments
• Identify and implement security controls to protect the database (MS SSQL and MySQL).
• Define and implement procedures to refresh UAT Instances from production.
• Design and implement backup and security policies (MS SSQL and MySQL).
http://www.whizz.com
Database Architecture and Administration (DBA).
Role: I+D (MySQL & MS SQL Server DBA. Production Support and Architecting).
• Testing AWS Lambda Services in UAT to determine application in production.
• Analyze the database configuration to detect issues affecting performance.
• Analyze slow queries affecting the production environment (MS SQL & MySQL).
• Migrate from MySQL 5.0 to MySQL 5.5, from Amazon EC2 to Amazon RDS Services
• Define partition criteria for several big tables and implement partitioning.
• Daily maintenance and optimization of HA EC2 & RDS Installations
• Ensure stability, scalability, best performance of the MySQL and MS SQL data platform.
• Work with development group, giving guidance and advice on best practices and standards.
• Support development groups during deployments
• Identify and implement security controls to protect the database (MS SSQL and MySQL).
• Define and implement procedures to refresh UAT Instances from production.
• Design and implement backup and security policies (MS SSQL and MySQL).
http://www.whizz.com
Support, Production, Scalability, Http, Lambda, Server, Backup, Testing, Development, Amazon, Design, Security, Architecture, Database, SQL Server, AWS, Administration, Sql, Mysql
2012 - 2013
job
DBA. Production Support & Project Management-MySQL, PostgreSQL & MongoDB
AIMIA.
London-United Kingdom OCT/2012 - APR/2013. Aimia is a global leader in loyalty management, present in the 5 continents, serving the biggest companies worldwide.
Database Architecture and Administration (DBA).
Role: DBA. Production Support & Project Management-MySQL, PostgreSQL & MongoDB.
• Design & Setup the database platform (MySQL & PostgreSQL) in the cloud (Amazon EC2).
• Redefine and implement the cluster and replication solution using Amazon techniques
• Daily maintenance and optimization of HA EC2 Installations (MySQL/PostgreSQL/Mongo
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
• Work with development group, giving guidance and advice on best practices and standards.
• Support development groups during deployments
• Design procedures for ensuring data integrity and quality.
• Keep updated the database related documentation (All Platforms).
• Identify and implement security controls to protect the database (All Platforms).
• Migrate data from Oracle databases to MySQL and PostgreSQL (Several Tb)
• Define and Implement Backup Policy.
• Daily monitoring of backup procedures (All Platforms).
• Monitor the server's performance and define procedure to upgrade when necessary.
• Project Management (defines scope, follow up timings).
http://www.aimia.com
Database Architecture and Administration (DBA).
Role: DBA. Production Support & Project Management-MySQL, PostgreSQL & MongoDB.
• Design & Setup the database platform (MySQL & PostgreSQL) in the cloud (Amazon EC2).
• Redefine and implement the cluster and replication solution using Amazon techniques
• Daily maintenance and optimization of HA EC2 Installations (MySQL/PostgreSQL/Mongo
• Ensure stability, scalability, best performance and HA of the MySQL data platform.
• Work with development group, giving guidance and advice on best practices and standards.
• Support development groups during deployments
• Design procedures for ensuring data integrity and quality.
• Keep updated the database related documentation (All Platforms).
• Identify and implement security controls to protect the database (All Platforms).
• Migrate data from Oracle databases to MySQL and PostgreSQL (Several Tb)
• Define and Implement Backup Policy.
• Daily monitoring of backup procedures (All Platforms).
• Monitor the server's performance and define procedure to upgrade when necessary.
• Project Management (defines scope, follow up timings).
http://www.aimia.com
Security, UP, Production, Scalability, Http, Server, Mongo, Backup, Development, Amazon, Monitoring, Support, Design, Architecture, Management, Cloud, Database, PostgreSQL, MongoDB, Oracle, Administration, Project Management, Mysql
2012 - 2012
job
Database Administrator (DBA)
ECKOH Ltd.
Hertfordshire-United Kingdom JAN/2012 - SEP/2012. Eckoh is the UK's leading provider of customer service solutions using speech recognition and complementary services on the web and mobile, servicing several tens of thousands of calls every day that always end up being stored in databases.
Database Administrator (DBA).
Role: I+D (DBA and Production Support for MySQL and MSSQL Server).
• Redefine and implement the cluster and replication solution.
• Design the systems platform to be used (MySQL and PostgreSQL).
• Ensure stability, scalability and best performance of MySQL & PostgreSQL databases.
• Work with development group, giving guidance and advice on best practices and standards.
• Design procedures for ensuring data integrity and quality.
• Identify the best working tools for data modeling and database administration.
• Keep updated the database related documentation.
• Set up, Control and Monitor Clustering and Replication to ensure HA and scale-out.
• Define, approve and control uploads to production (those that affect database)
• Out of Hours support, on a rotation basis.
Functions. DBA (install, implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for MySQL Database Platform, installed in three data centers (databases over 100.000.000 records with 400 Tb of storage capacity) servicing customers from all over the world.
http://www.eckoh.com
Database Administrator (DBA).
Role: I+D (DBA and Production Support for MySQL and MSSQL Server).
• Redefine and implement the cluster and replication solution.
• Design the systems platform to be used (MySQL and PostgreSQL).
• Ensure stability, scalability and best performance of MySQL & PostgreSQL databases.
• Work with development group, giving guidance and advice on best practices and standards.
• Design procedures for ensuring data integrity and quality.
• Identify the best working tools for data modeling and database administration.
• Keep updated the database related documentation.
• Set up, Control and Monitor Clustering and Replication to ensure HA and scale-out.
• Define, approve and control uploads to production (those that affect database)
• Out of Hours support, on a rotation basis.
Functions. DBA (install, implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for MySQL Database Platform, installed in three data centers (databases over 100.000.000 records with 400 Tb of storage capacity) servicing customers from all over the world.
http://www.eckoh.com
Support, UP, Speech recognition, Tuning, Production, Administrator, Scalability, Http, Server, Web, Storage, Backup, Development, Monitoring, Design, Mssql server, Security, Service, Customer service, Database administration, Data Modeling, Database, MSSQL, Scripting, PostgreSQL, Administration, Mysql
2011 - 2011
job
Database Administrator (DBA)
TELEFONICA.
Madrid-España JUL/2011 - DEC/2011. TELEFONICA is one of the biggest European ISP's servicing users in all the continents, specially in Europe and America.
Database Administrator (DBA).
Role: I+D (DBA and Production Support - The Cloud Computing Project).
• Design the physical and logical database solution (network layer, clustering, replication).
• Implement cluster and replication solution.
• Define the systems platform to be used (hardware and Operating System level).
• Define data models and the related technology solutions for the various line of business currently operating in the company.
• Ensure stability, scalability, best performance and High-Availability data platform.
• Work closely with development team to ensure the integrity of the data architecture. Guide and advice the group on best practices and standards.
• Design procedures to ensure data integrity and quality.
• Identify the best working tools for data modeling and data administration.
• Keep updated the documentation of the data base architecture and implement processes for approval of changes.
• Set up, Control and Monitor the replication process and the Clustering System to ensure scale-out, data redundancy and High Availability.
• Define, approve and control uploads to production (those affecting databases)
Functions. DBA (install, implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for MySQL Database Platform, installed in three data centers (400 servers and 500 databases with 500 Tb of storage capacity) servicing customers from all over the world.
http://www.telefonica.com/es/home
Database Administrator (DBA).
Role: I+D (DBA and Production Support - The Cloud Computing Project).
• Design the physical and logical database solution (network layer, clustering, replication).
• Implement cluster and replication solution.
• Define the systems platform to be used (hardware and Operating System level).
• Define data models and the related technology solutions for the various line of business currently operating in the company.
• Ensure stability, scalability, best performance and High-Availability data platform.
• Work closely with development team to ensure the integrity of the data architecture. Guide and advice the group on best practices and standards.
• Design procedures to ensure data integrity and quality.
• Identify the best working tools for data modeling and data administration.
• Keep updated the documentation of the data base architecture and implement processes for approval of changes.
• Set up, Control and Monitor the replication process and the Clustering System to ensure scale-out, data redundancy and High Availability.
• Define, approve and control uploads to production (those affecting databases)
Functions. DBA (install, implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for MySQL Database Platform, installed in three data centers (400 servers and 500 databases with 500 Tb of storage capacity) servicing customers from all over the world.
http://www.telefonica.com/es/home
Hardware, UP, Processes, Tuning, Guide, Production, Administrator, Scalability, Http, Storage, Backup, Development, Monitoring, Design, Support, Security, Network, Architecture, Technology, Data Modeling, Cloud, Database, Scripting, Administration, Mysql
2008 - 2011
job
Database Administrator (DBA)
SECURITAS DIRECT.
Madrid-España MAY/2008 - JUL/2011. SECURITAS is a 3800 employees company, providing security systems to 1.000.000 customers in Europe and South America.
Database Administrator (DBA).
Role: I+D (MSSQL/MySQL Production Support and Project Management).
• Design the physical and logical database solution (network layer, clustering, replication).
• Implement cluster and replication solution.
• Define the systems platform to be used (hardware and Operating System level).
• Define data models and the related technology solutions for the various line of business currently operating in the company.
• Ensure stability, scalability, best performance and High-Availability of the data storage platform, consisting of Sybase ASE, Sybase IQ, MS-SQL Server and MySQL DBMS.
• Remain vigilant, working closely with development team to ensure the integrity of the data architecture. Guide and advice the group on best practices and standards.
• Design and implement solutions for data exchange with clients and suppliers.
• Design procedures for ensuring data integrity and quality.
• Identify the best working tools for data modeling and data administration.
• Implement the main guidelines of the ISO 27001 standard.
• Maintain the database documentation and implement processes for approval of changes.
• Design and implement bulk data transfer processes among the different data base platforms of the company (ETL Processing Tools).
• Monitor replication process to ensure that all production environments are synchronized.
• Ensure that data transformation between SYBASE and SQL Server or SYBASE and MySQL is working fine in order to feed all MIS Systems as required.
• Define, approve and control uploads to production (those that affect database)
• Define and Implement backup policies.
• Servers Optimization.
Functions. DBA (implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for all database environments (SYBASE ASE, SYBASE IQ, SQL Server, MySQL) installed in two data centers (1500 servers and 2000 databases, 2000 Tb of storage capacity and 2000 communication lines), servicing several branches in the company (Spain, France, Portugal, Chile and Brazil).
Key Achievements.
• To improve response to disaster recovery situations, we split our production environment into three different scenarios (primary, secondary and tertiary). Transactions are now replicated from primary to secondary and tertiary scenarios. I was responsible for re-designing our database architecture as needed, setting up, configuring and implementing replication, installing all database instances in secondary and tertiary scenarios, and defining security specifications.
• As part of the same project, we put in operation a second Data Centre, installed in a different building. I was responsible for the project coordination, installation of all database instances and operating system installation (windows and Linux) of several servers (more than 800).
• Redesign the database architecture in order to convert the software from our main production system to a multi-country platform.
http://www.securitasdirect.es/
Database Administrator (DBA).
Role: I+D (MSSQL/MySQL Production Support and Project Management).
• Design the physical and logical database solution (network layer, clustering, replication).
• Implement cluster and replication solution.
• Define the systems platform to be used (hardware and Operating System level).
• Define data models and the related technology solutions for the various line of business currently operating in the company.
• Ensure stability, scalability, best performance and High-Availability of the data storage platform, consisting of Sybase ASE, Sybase IQ, MS-SQL Server and MySQL DBMS.
• Remain vigilant, working closely with development team to ensure the integrity of the data architecture. Guide and advice the group on best practices and standards.
• Design and implement solutions for data exchange with clients and suppliers.
• Design procedures for ensuring data integrity and quality.
• Identify the best working tools for data modeling and data administration.
• Implement the main guidelines of the ISO 27001 standard.
• Maintain the database documentation and implement processes for approval of changes.
• Design and implement bulk data transfer processes among the different data base platforms of the company (ETL Processing Tools).
• Monitor replication process to ensure that all production environments are synchronized.
• Ensure that data transformation between SYBASE and SQL Server or SYBASE and MySQL is working fine in order to feed all MIS Systems as required.
• Define, approve and control uploads to production (those that affect database)
• Define and Implement backup policies.
• Servers Optimization.
Functions. DBA (implement, administrate, design, replicate, migrate, tuning, monitoring, backup recovery, security, scripting and high availability/clustering) for all database environments (SYBASE ASE, SYBASE IQ, SQL Server, MySQL) installed in two data centers (1500 servers and 2000 databases, 2000 Tb of storage capacity and 2000 communication lines), servicing several branches in the company (Spain, France, Portugal, Chile and Brazil).
Key Achievements.
• To improve response to disaster recovery situations, we split our production environment into three different scenarios (primary, secondary and tertiary). Transactions are now replicated from primary to secondary and tertiary scenarios. I was responsible for re-designing our database architecture as needed, setting up, configuring and implementing replication, installing all database instances in secondary and tertiary scenarios, and defining security specifications.
• As part of the same project, we put in operation a second Data Centre, installed in a different building. I was responsible for the project coordination, installation of all database instances and operating system installation (windows and Linux) of several servers (more than 800).
• Redesign the database architecture in order to convert the software from our main production system to a multi-country platform.
http://www.securitasdirect.es/
Http, ISO 27001, Sybase, Hardware, Monitoring, Development, Backup, Storage, Software, Data Storage, Server, Support, Scalability, Administrator, Production, Redesign, Guide, Tuning, Processing, Processes, UP, Database, Mysql, Sql, Project Management, Linux, Administration, SQL Server, Exchange, Scripting, MSSQL, Design, ETL, Data Modeling, Management, Windows, Technology, Architecture, Network, Security, Transformation
1990 - 2008
job
IT Manager
MEDYCSA.
Role. IT Manager responsible for Development, Infrastructure and Production, leading a division with 15 members, in a 1.500 employees company dedicated to Health Care and Risk Prevention services, with a daily production of 1000 clinical exams y 2000 clinical analyses.
Functions.
Identify and cordinate application development as needed.
Manage the opening of new offices following internal operating procedures.
Design and implement security plans. Design and implement training plans for all users. Coordinate End User Support area (support to 400 users).
Implement and administrate the database (SQL Server 2000/2005). Install and manage a virtualisation platform based on VMWare servers.
Design and implement the network across the country, based on Windows 2000/2003 and CISCO technologies (including Active Directory, DNS, DHCP Services) and Novel Netware.
Design and implement a software platform to integrate Health/Medicine devices with the rest of the application. This development was made with Python and covered microscopes, laryngoscopes, endoscopes, echographs, ergometers and laboratory analyzers, integrating the results and the images produced during a test with the patient's profile in the database.
Develop software to extract data from MSSQL and produce the patient's final report to be delivered after a Health Check.
Design and implement a set of ETL developments, using Python, to fetch data from MSSQL, DBF Files and spreadsheets, transform data as needed and load it to another instance of MSSQL to create the data platform to feed the MIS system.
Key Achievements.
Premium Care. Opening the first Premium Care Clinic, a maximum priority project, designed to deliver premium quality medical services for high-level clients.
Teleform. The key goal of this project was the implementation of a platform for capturing high volumes of data using scanners and electronic forms. This platform processes 600 clinical exams which are stored on an SQL Database, validated and delivered to patients.
ALFA. This project involved the development of two key applications for the company; one for clinical exams processing (1000 p/day) and the other for laboratory analysis processing (2000 p/day). Initially developed using 16 bits technology, was then converted to .NET platform (VB Basic and SQL Server 2000) a few years later.
http://www.medycsa.com
Functions.
Identify and cordinate application development as needed.
Manage the opening of new offices following internal operating procedures.
Design and implement security plans. Design and implement training plans for all users. Coordinate End User Support area (support to 400 users).
Implement and administrate the database (SQL Server 2000/2005). Install and manage a virtualisation platform based on VMWare servers.
Design and implement the network across the country, based on Windows 2000/2003 and CISCO technologies (including Active Directory, DNS, DHCP Services) and Novel Netware.
Design and implement a software platform to integrate Health/Medicine devices with the rest of the application. This development was made with Python and covered microscopes, laryngoscopes, endoscopes, echographs, ergometers and laboratory analyzers, integrating the results and the images produced during a test with the patient's profile in the database.
Develop software to extract data from MSSQL and produce the patient's final report to be delivered after a Health Check.
Design and implement a set of ETL developments, using Python, to fetch data from MSSQL, DBF Files and spreadsheets, transform data as needed and load it to another instance of MSSQL to create the data platform to feed the MIS system.
Key Achievements.
Premium Care. Opening the first Premium Care Clinic, a maximum priority project, designed to deliver premium quality medical services for high-level clients.
Teleform. The key goal of this project was the implementation of a platform for capturing high volumes of data using scanners and electronic forms. This platform processes 600 clinical exams which are stored on an SQL Database, validated and delivered to patients.
ALFA. This project involved the development of two key applications for the company; one for clinical exams processing (1000 p/day) and the other for laboratory analysis processing (2000 p/day). Initially developed using 16 bits technology, was then converted to .NET platform (VB Basic and SQL Server 2000) a few years later.
http://www.medycsa.com
Server, Net, It, Implementation, Support, Infrastructure, Development, Health, Software, Security, Http, Production, Vb, Processing, Processes, Manager, Basic, Database, Sql, Python, SQL Server, Active Directory, Training, VMware, Cisco, MSSQL, Design, ETL, REST, DNS, Test, Windows, Technology, Network
1989 - 1993
job
IT Manager
BANKERS TRUST COMPANY.
Role. System Administration and Production Support. Assuring the daily banking operations.
Functions. Managing the daily production cycle of the corporate system (ONS). Control the communication with the Wide Area Network regional node based in London.
Develop and implement solutions for banking products (i.e. FRAS, Payroll, Certificate of Deposit) not supported by the corporate system. Coordinate software updates with the development team based in London. Implement a Local Area Network and integrate it with the rest of European branches (i.e.: Milan, Frankfurt and Paris). Coordinate End User Support area (supporting 100 users). Manage the installation of a structured cabling system for voice and data.
https://www.bankerstrust.com
Functions. Managing the daily production cycle of the corporate system (ONS). Control the communication with the Wide Area Network regional node based in London.
Develop and implement solutions for banking products (i.e. FRAS, Payroll, Certificate of Deposit) not supported by the corporate system. Coordinate software updates with the development team based in London. Implement a Local Area Network and integrate it with the rest of European branches (i.e.: Milan, Frankfurt and Paris). Coordinate End User Support area (supporting 100 users). Manage the installation of a structured cabling system for voice and data.
https://www.bankerstrust.com
Administration, Operations, REST, System administration, Node, Banking, Network, It, Support, Development, Software, Production, Manager
1986 - 1989
job
Project Manager
THE CHASE MANHATTAN BANK.
Role. As a member of a special project team; design, manage and implement the conversion plan that allowed the branch to go from an IBM System 4331 to an IBM AS/400.
Functions. Design and implement a Management Information System to control the annual budget. Design and implement a local reporting system to accomplish with Bank of Spain and Head Office information requirements. Analyse and implement conversion software to replace the actual system functionalities in the new one. Design and implement the training plan for all employees.
https://www.chase.com/
Functions. Design and implement a Management Information System to control the annual budget. Design and implement a local reporting system to accomplish with Bank of Spain and Head Office information requirements. Analyse and implement conversion software to replace the actual system functionalities in the new one. Design and implement the training plan for all employees.
https://www.chase.com/
Design, Project Manager, Budget, Training, Management, Office, Software, Go, Manager
My education
1980
-
1983
Elementary School Escuela Nacional
N/a, N/a
N/a, N/a
Escuela Técnico
N/a, Escuela Técnico-Industrial
N/a, Escuela Técnico-Industrial
Universidad Católica
Systems Analysis, N/a
Systems Analysis, N/a
Juan's reviews
Juan has not received any reviews on Worksome.
Contact Juan Carlos Farina
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Juan directly in Worksome.
38200+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark