Recommended expert

Oscar Montero

IT Specialist / DBA

Oscar Montero
Adliswil, Switzerland

Experience

Apr 2023 - Present
3 years

IT Specialist / DBA

Rothschild Private Swiss Bank

  • Act as DBA SME for MS SQL Server and primary contact for MSSQL infrastructure and long-term technology roadmap in a critical 24/7 banking environment
  • Maintain and evolve SQL infrastructure and monitoring system across development, test, UAT, and production environments (10 servers, 4 always-active Windows clusters, MSSQL 2014–2022 on VMs hosted by Inventix)
  • Automate SQL operations using Brent Ozar scripts, PowerShell, and Inventix cloud script integration
  • Build and improve ETL processes and BI applications (Power BI); plan resources and mentor BI team
  • Participate in review, delivery, and deployment of database improvements across the software development lifecycle
  • Migrate SQL Server instances from 2017 to 2019 and 2022
  • Integrate new applications requiring MSSQL databases
  • Manage and support on-premise and Azure SQL Server solutions; advise on industry standards, best practices, and creative database solutions
  • Develop automation scripts for internal systems using PowerShell and Git
  • Monitor systems with Splunk and Grafana; manage alerts, filters, data ingestion, and dashboard configuration
  • Collaborate with operations, development, and business teams to identify and resolve operational and performance issues proactively
  • Implement new SQL Server technologies such as Query Store, Extended Events, Tuning Advisor, and system traces
  • Provide on-call support and regular maintenance during evenings and weekends
  • Define and enforce system policies and standards; work closely with application managers, HR, and IT platforms in Switzerland and the UK
  • Handle 2nd/3rd level support service requests; document resolutions and cooperate with vendors
  • Use internal and external monitoring tools to detect performance trends and implement alerts and processes to prevent database issues
  • Document and share knowledge to improve technical understanding across operations and development teams; administer Confluence (installation, configuration, document management, performance, upgrades)
  • Work professionally in cross-functional teams to advise, influence, and coach development and operations teams on database topics
Feb 2015 - Feb 2023
8 years 1 month

DBA MS SQL Server

Credit Suisse

  • Supported operations database team across 400+ servers in development, test, UAT, and production with active/active and Always On Windows clusters, MSSQL 2008–2019 on physical and virtual servers, managing 3000+ databases (some >1 TB), replication, linked servers, transaction log shipping
  • Performed Level 2/3 support with 24/7 on-call rotation: migrations, installations, upgrades, and daily changes (including off-hours)
  • Troubleshot query performance, integrated new applications, and provided database and query design recommendations
  • Monitored systems using Tivoli and integrated ticketing and reporting with ServiceNow
  • Installed, configured, and supported SSAS, SSIS, and SSRS packages

From 2021-06 as Database Project Lead:

  • Led DBA support for multiple IT projects: advised on architecture and development, change control, troubleshooting, performance analysis, migrations, and roadmap/patch planning
  • Managed change control: production tickets, validation, and customer support throughout the change process
  • Supported dedicated applications lacking in-house architects or DBAs
  • Projects included:
  • Data warehouse data mining on a 3 TB+ SQL Server Always On database: 3+ years of support from architecture to development, management consulting, cross-team coordination, version and query optimization
  • Veritas to EMC storage migration: planning, execution, downtime control, and cross-team coordination
  • Deployment of new VMware clusters for SQL Server 2014
  • Hadoop Apache (Cloudera Manager) setup, configuration, performance tuning, L1–L3 support
  • Delphix administration and onboarding for new customers
  • Imperva integration for high-level data access control across SQL, Sybase, and Oracle for global C1/C2 applications
  • US mainframe DR upgrade: latency testing, Metro Mirror/HyperSwap implementation across Princeton and Raleigh
  • Scrum Master for a 16-member team on a multi-million-dollar OpenShift/ARGO CaaS DevOps transformation project
Mar 2014 - Dec 2014
10 months
Basel, Switzerland

Project Manager / DBA MS SQL Server

Fisher Clinical Services

  • Managed SQL support, ITIL process improvements, and new developments for multiple SQL Server versions (2005, 2008, 2012) and Data Warehouse (SQL Server 2005/2008 with Oracle 11g)
  • Developed and supported SSIS (DTS packages), SSRS, and SSAS solutions with SharePoint reporting
  • Administered Windows clustering (2003/2008/2012)
  • Supported SMB SQL Server/Oracle and Data Warehouse development for internal production functions (SAP-based system)
  • Migrated SQL 2005/2008 to 2012 and updated Data Warehouse packages for various clients
  • Provided 24x7 on-call support across Germany, France, USA, UK, China, India, and Japan with rotation
  • Coached team members on SQL, data warehousing, SSIS, reporting, and SQL Server administration
Dec 2010 - Jun 2014
3 years 7 months
Brussels, Belgium

DBA Oracle / MS SQL Server

IBM Belgium

  • Delivered 24x7 on-call DBA support to 15+ clients with 1000+ databases (largest >3 TB) in an ITIL environment
  • Managed SQL Server 2000/2005/2008 clustering, replication, log shipping, mirroring (Veritas/Windows cluster), and BI solutions (SSIS, SSRS, SSAS)
  • Administered Oracle 10gR2/11gR2 on Solaris and Windows with OEM Grid Control, Data Guard, and RAC across Solaris, Linux, and Windows
  • Handled backups via Tivoli (TSM/TDP) and monitoring with Tivoli and MOM

Internal projects:

  • Led Rhodia migration (2013+): planning, installation, support, and architecture for SQL Server 2000/2005/2008 and Oracle 9i/10g/11g
  • Directed India Level 3 DBA team (2012): delegated 30% of workload, planned training, and supervised work
  • Oversaw Carrefour migration from SQL 2000/2005 to 2008 (2011–2012): managed DTS to SSIS and Control-M jobs
  • Upgraded Oracle environments from 9i/10g to 11g throughout 2012
Jan 2010 - Dec 2011
2 years

Oracle DBA Architect and SME

Sener Industrial Engineering

  • Designed and installed Oracle 11g RAC cluster (2 nodes, BMC storage) and created offsite Data Guard backup instance
  • Migrated SQL Server 2008 databases to Oracle 11g and configured Data Guard DR procedures
  • Managed Oracle 10g/11g instances via Grid Control, performed backups, DRP, patching, alarms, and 24x7 on-call operations
  • Defined disaster-recovery procedures and backup strategy; led database design with developers and project managers
  • Trained junior system engineers on Oracle DBA best practices
Jan 2008 - Dec 2009
2 years

Architect (Telefonica Terra Project)

Hewlett Packard

  • Served as technical lead for SQL Server and Oracle in a 2-data-center redesign with 2500+ servers
  • Implemented new projects, troubleshooting, production cutovers, 24x7 support, performance tuning, disaster recovery, and capacity planning
  • Managed a team of 5–10 and coordinated hardware (servers, storage, networking)
  • Administered SQL Server 2000/2005/2008 clusters on Windows 2003/2008 and Oracle 10g/11g on Solaris, Linux, and Windows
  • Implemented HA solutions: RAC, clustering, replication, log shipping, mirroring, NetApp, Veritas
  • Provided BI solutions: migrated SSIS and SSRS from SQL 2000 to 2005/2008 and managed reporting platforms
Jun 2007 - Jan 2008
8 months
Spain

Oracle and SQL Server DBA

Bankinter

  • Supported high-critical financial applications on Oracle 9i/10g RAC and SQL Server 2000/2005 clusters on Solaris and HPUX
  • Configured and tuned new Oracle 10g RAC and SQL Server 2005 A/A clusters
  • Provided 24x7 on-call support
  • Delivered BI integration: SQL 2005 OLAP, SAS/Cognos, SSRS, and DTS to SSIS migrations
Oct 2003 - Jun 2007
3 years 9 months

DBA

Capgemini

  • Worked in an 8-member team managing Oracle (7–10g), SQL Server (6.5–2005), Sybase, Informix, and Teradata environments with ITIL processes
  • Implemented 200+ replications across Madrid, Argentina, and backup sites (snapshot, transactional, merge)
  • Migrated SQL Server 7.0 to 2000 and Oracle 7/8 to 9i
  • Managed clusters, high-availability storage, raw devices, RAC, and Data Warehouse solutions with RMAN and shell scripting under Tivoli monitoring
  • Designed and managed SSIS/SSRS solutions, DTS, and OLAP cubes with SharePoint reporting
Jan 2002 - Oct 2003
1 year 10 months

DBA

Software AG

  • Supported Windows NT/2000/2003 and UNIX environments with Informix 7.8 and Oracle 9i RAC on Solaris
  • Managed Data Warehouse (>1 TB), PLSQL development, RMAN, shell scripting, raw devices, and 24x7 on-call operations
  • Administered SQL Server 6.7/2000 with multi-type replication and high-availability storage
  • Maintained web systems: ISA Server, IAS, IIS, WebLogic
Jan 2001 - Jan 2002
1 year 1 month

Database Administrator

Oracle

  • Developed PL/SQL and supported Oracle 7i/8i/9i databases in Oracle Support
  • Managed customer issue resolution
Oct 2000 - Jan 2001
4 months

Technical Support

Hewlett Packard

  • Installed, configured, and maintained HP server hardware and RAID systems on Windows NT, HPUX, and Solaris
  • Provided troubleshooting for SQL Server 7/2000

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Information Technology (13 years), Banking and Finance (11.5 years), Professional Services (3.5 years), Telecommunication (2 years), and Pharmaceutical (1 year).

Information Technology
Banking and Finance
Professional Services
Telecommunication
Pharmaceutical

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (25 years), Business Intelligence (12.5 years), Operations (11 years), Project Management (9 years), and Customer Service (1.5 years).

Information Technology
Business Intelligence
Operations
Project Management
Customer Service

Languages

Spanish
Native
German
Advanced
English
Advanced
French
Advanced
Italian
Advanced

Education

Oct 1997 - Jun 2004

Pontifical University of Salamanca in Madrid

Bachelor’s and Master’s in Technical Systems Engineering, MSc IT · Technical Systems Engineering · Madrid, Spain

Certifications & licenses

Microsoft Azure Cloud Database Administrator Associate (DP-300)

Microsoft Azure Cloud Administrator Associate (AZ-104)

Oracle Cloud Infrastructure Architect Associate (1Z0-1072)

Scrum Master Certification

PMP Certification

ITIL V3

OCP Oracle 11G Certification

MCSE SQL Server 2012 Certification

Oracle 11G Data Warehouse

Oracle Belgium

MCITP SQL Server 2008 Certification

OCA Oracle 11G Certification

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Oscar based?

Oscar is based in Adliswil, Switzerland.

What languages does Oscar speak?

Oscar speaks the following languages: Spanish (Native), German (Advanced), English (Advanced), French (Advanced), Italian (Advanced).

How many years of experience does Oscar have?

Oscar has at least 25 years of experience. During this time, Oscar has worked in at least 10 different roles and for 10 different companies. The average length of individual experience is 2 years and 3 months. Note that Oscar may not have shared all experience and actually has more experience.

What roles would Oscar be best suited for?

Based on recent experience, Oscar would be well-suited for roles such as: IT Specialist / DBA, DBA MS SQL Server, Project Manager / DBA MS SQL Server.

What is Oscar's latest experience?

Oscar's most recent position is IT Specialist / DBA at Rothschild Private Swiss Bank.

What companies has Oscar worked for in recent years?

In recent years, Oscar has worked for Rothschild Private Swiss Bank and Credit Suisse.

Which industries is Oscar most experienced in?

Oscar is most experienced in industries like Information Technology (IT), Banking and Finance, and Professional Services. Oscar also has some experience in Telecommunication and Pharmaceutical.

Which business areas is Oscar most experienced in?

Oscar is most experienced in business areas like Information Technology (IT), Business Intelligence, and Operations. Oscar also has some experience in Project Management and Customer Service.

Which industries has Oscar worked in recently?

Oscar has recently worked in industries like Banking and Finance.

Which business areas has Oscar worked in recently?

Oscar has recently worked in business areas like Information Technology (IT), Project Management, and Business Intelligence.

What is Oscar's education?

Oscar holds a Master in Technical Systems Engineering from Pontifical University of Salamanca in Madrid.

Does Oscar have any certificates?

Oscar has 11 certificates. Among them, these include: Microsoft Azure Cloud Database Administrator Associate (DP-300), Microsoft Azure Cloud Administrator Associate (AZ-104), and Oracle Cloud Infrastructure Architect Associate (1Z0-1072).

What is the availability of Oscar?

The availability of Oscar needs to be confirmed.

What is the rate of Oscar?

Oscar's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Oscar?

To hire Oscar, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1400
1050
700
350
Market avg: 1100-1260 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.