We leave you some of the Service formats and type Clients on which we offer our work, and some projects that will allow you to assess both the technical solvency of our company and the type of projects we undertake.
Evolutionary maintenance
- Support and maintenance of your SQL Serverplatform.
- SQL Server environment with cluster technology, mirror, replication and Report Services.
- More than 10 servers, productive environments 7×24.
- Management of Production / Preproduction and Development environments. Consulting, advice and implementation of high availability solutions for the DB environments.
- Telephone support for incidents and queries.
- Secure remote access for urgent incidents and for monitoring actions on the database.
- Support and evolutionary maintenance of the platformOracle, SQL-Server of the client
- Management of Production / Preproduction and Development environments. Consulting, advice and implementation of high availability solutions for the DB environments.
- Telephone support for incidents and queries.
- Secure remote access for urgent incidents and for monitoring actions on the database.
- Multiplatform service Oracle, SQL Server, MySQL, MongoDB.
- Support for installation projects, configuration and migration of environments in SQL Server, Oracle, MySQL and MongoDB.
- Support to the HP/DXC project team to perform the implementation tasks of the different projects in this customer.
- Management of second and third level support tickets for your Oracle, SQL-Server and MongoDB environment.
- Support and maintenance of the platform Oracle.
- The environment consists of two Standalone servers running Oracle 12.2 Standard Edition on a Windows platform.
- Tuning work
- Review of instances with optimization report
- Monthly reporting on updates and patchesets.
- Support and maintenance of platform Oracle, PostgreSQL and MySQL.
- The environment consists of 5 Oracle servers, 3 PostgreSQL servers and 1 MySQL server.
Tasks:
- Telephone support for incidents and queries.
- Secure remote access for urgent incidents and for monitoring actions on the database.
- Support and maintenance of your SQL Serverplatform.
- The environment consists of 10 SQL Server servers with cluster, mirror, replication and Report Services technology.
- Support and evolutionary maintenance of the platformOracle, SQL-Server of the client
- Management of Production / Preproduction and Development environments.
- Consulting, advice and implementation of high availability solutions for the DB environments.
Consulting projects
- Configuring the backup policy of the Oracle Exadata environment with RMAN and Cloud Control.
- Planning the tasks with the RMAN tool and its integration with DataDomain for the multiplexing of the copies
- Generation of scriptsto configure historical archiving to maintain copies of productive environments.
Enterprise Manager Cloud Control installation, Grid Infrastructure 19 installation, Oracle 19c installation and migrations through backup/restore rman and upgrade to optimize time.
Integrated in the HP-led team we addressed the part that deals with the Oracle platform and the migration of A3Media’s Oracle environments to new servers with upgraded storage and new OS versions to run on Oracle 19c. More than 30 databases and 12 environments.
- Migration of SQL Server instance of the main Datawarehouse to a new server in 2019 version with redistribution of storage and partitioning of tables.
- Configuration of all maintenance jobs and automation of the migration process through scheduled scripts.
Various Consulting and Hourly Exchange projects to support the Database team, from 2020-
Cloning of development and production environments in ASM for new versions of PEGA support project.
HA Solutions and Migration of environments.
EVOLUTIO/GC_ HA PostgreSQL Solution
Implement a Cluster and Replica architecture with PostgreSQL for the customer’s Remedy platform.
- Design of a solution.
- Installation of the architecture with 4 Postgresql version 10 servers. It will consist of two servers with synchronous replication, a third with asynchronous replication and a witness node.
- Configuration. This will be done with repmanager to facilitate the automatic switching tasks between the first two servers. The database, the users and the configuration provided by the manufacturer will be left created.
- Tests. Failure tests will be performed to validate the solution.
- Go live.
- Documentation of tests and basic switching and recovery commands.
Evolutio/Wizink Zerebro (2021). SQL-Server
Creation of data extraction process from Navision of Wizink for its subsequent exploitation by the client. A custom development has been made to create queries dynamically and their subsequent export to flat files with different formats.
Customer feedback on our services and products
“From Pernod-Ricard, we value the professionalism and commitment of the GPSOS staff, as they are able to adapt to any of our circumstances, whether in customized requests or operational assistance, always seeking to solve our requests in the most diligent way and providing their knowledge proactively. It is a very good option to have them as a partner”.
“GPSOS guarantees the correct operation of our DB environments, both ORACLE and SQL Server, demonstrating excellent technical knowledge and offering 360-degree support to the deployed environments. The company’s commitment and high degree of agility has allowed us to solve multiple types of incidents in record time. In a proactive way, they help us manage all the parameters of our environments, ensuring proper operation and optimal performance, while advising us on the latest technologies on the market.” Translated with www.DeepL.com/Translator (free version)
“Our degree of satisfaction with the service provided by your company during 2015 has been quite high, since you have always covered the needs that we have transferred to you, and it is worth highlighting your spirit of collaboration with us at all times.”
“I wanted to pass on the congratulations I received yesterday on the achievement of the BRS/Jazztel project goals, especially for reaching the date with almost all the systems agreed upon, thank you and good job!”
“I wanted to report on the Oracle database migration that we have managed to do in the City Council of Rivas. We have migrated from a version 11.2 to a version 19 with very few incidences. I have to thank the people at GPS Open Source for helping us analyze this migration with their GPS Query Performance tool.”
“We have installed Query-Perfomance and have access to all Oracle databases in our environment. Last week we had a performance problem in one database and we took advantage of Query-Performace to analyze the problems in the queries. David, our DBA, told us that the tool worked very well, that it is very fast and that he got the information of what could be the problem in a much faster and easier way than with the usual Oracle tools. We think it could be very interesting for development teams as well, we will request a proof of concept for their platform.” Translated with www.DeepL.com/Translator (free version)
“Your collaboration, as I expected, has been fantastic. The projects have been completed on schedule and will allow us to continue coordinating more work with you.”
“At Moralejo Selección we are totally satisfied with the work of GPSOS. From the beginning we have worked as a team and they are integrated with us as an extension of our own IT department. Professionalism, speed and proximity are words that best describe them.”
“The migration has gone flawlessly, the database part flawlessly and we will be going out to production.”