Oscar Montero
IT Specialist / DBA
Experience
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
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
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
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
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
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
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
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
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
Database Administrator
Oracle
- Developed PL/SQL and supported Oracle 7i/8i/9i databases in Oracle Support
- Managed customer issue resolution
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).
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).
Languages
Education
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
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Oscar based?
What languages does Oscar speak?
How many years of experience does Oscar have?
What roles would Oscar be best suited for?
What is Oscar's latest experience?
What companies has Oscar worked for in recent years?
Which industries is Oscar most experienced in?
Which business areas is Oscar most experienced in?
Which industries has Oscar worked in recently?
Which business areas has Oscar worked in recently?
What is Oscar's education?
Does Oscar have any certificates?
What is the availability of Oscar?
What is the rate of Oscar?
How to hire Oscar?
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a IT Specialist / DBA
Nearby freelancers
Professionals working in or nearby Adliswil, Switzerland