Rick Obradors
Glendale,Ca.
Summary
Accomplished Lead Senior Database Administrator at Farmers & Merchants Bank, specializing in SQL database management and performance tuning. Proven track record in implementing high-availability solutions and automating processes, while effectively leading teams. Strong analytical skills combined with extensive banking knowledge drive successful project outcomes and enhance operational efficiency.
Overview
39
39
years of professional experience
3
3
Certifications
Work History
Lead Senior Database Administrator
Farmers & Merchants Bank
Seal Beach, Ca
04.2019 - Current
- Lead Senior DBA of the Infrastructure Team supporting all Banking Applications and Systems running on SQL 2019 and SQL 2022 versions in production environment.
- The Lead Senior DBA role includes DB architecture and overseeing areas including DB performance tuning, automation, upgrades, patches and deployments.
- Built and supported several SQL 2019 and 2022 Always On Clusters hosting the majority of the bank’s applications.
- Performed many database migrations from SQL Standalone systems to SQL Always On for Disaster Recovery/High Availability.
- Built ETL processes from various systems (i.e. DB2 iBMi to SQL).
- Coded many SQL scripts for automating production support tasks.
- Implemented SQL hardening and best practices for audits.
- Currently the SME for the bank’s primary backup system which includes configuration and reporting on VMs, SQL, Exchange and Active Directory.
- Played a key role in the recent Data Masking project to compare products from a few vendors, set up the environments and performed data analysis for the NPI masked data requirements.
- Extensive experience obtained with the infrastructure tools such as Zerto site replication, Nutanix, and VMWare.
- Azure SQL Database cloud support for the primary banking web site, SQL MS Assessments in Azure and Azure security admin.
Senior Production DBA/ Manager
RIA Financial Services
Buena Park, Ca
07.2013 - 04.2019
- Senior DBA and hands-on DBA Manager of 17 DBAs in USA/Spain/Malaysia for around the clock support of a highly transactional OLTP system built on versions of SQL Server 2008 R2, 2012, 2014, 2016, 2017.
- Application support and performance tuning.
- Always-on installation in our Kansas DR site including replication.
- Configuring/supporting transactional, peer to peer, merge and bi-directional replication.
- Configuring/supporting DB Mirroring, log shipping.
- SSIS/SSRS configuration and support.
- Extensive experience with TSQL, stored procedures, triggers, views, functions needed in this environment.
- Change management support/deployment support/code reviews.
Senior Production DBA
Equator, LLC
Culver City, Ca
01.2011 - 07.2013
- Production DBA role supporting over 40 production SQL 2008 R2 processes for OLTP, Data Warehouse, ODS, SSIS, replication, transactional log shipping and performance tuning for commercial web sites on SQL clustered servers.
- T-SQL and PowerShell scripting and high-end MS technologies including IIS, DNS, Active Directory.
- Change management deployment and support, SQL code review and performance tuning.
- OLTP script deployment for application support team.
- Coordinate with Infrastructure Engineers to perform routine maintenance and patching on the production SQL Servers with the load balancers and replication.
- SAS 70 audit support providing various database - related tasks.
- SSIS remediation and troubleshooting.
- Involved in database capacity planning and scalability.
- Database archiving.
- Monthly production release DBA support as primary DBA.
VP- IT Systems and Database Engineering
East West Bank
El Monte, Ca
08.2009 - 01.2011
- IT Manager of seven engineers supporting Exchange, 40 production SQL servers, SAN (Netapp/Equalogic), Citrix, and VM.
- Write and implement SQL Security policies.
- Technical documentation writing.
Senior Production DBA
East West Bank
El Monte, Ca
08.2007 - 08.2009
- SSIS package automation/error logging.
- T-SQL programming and performance tuning/indexing.
- Built and administered SQL active/active clustering for our primary banking application.
- Supported Data Warehouse team with ETL processes.
- SSRS report writing for various business units.
- Implementation of database audit and data encryption.
- Implementation of database growth reporting.
- SQL 2000 and SQL 2005 to 2008 migration.
- SQL 2008 Performance Tuning class certification.
- Database Audit remediation.
- Application upgrade support to business unit.
AVP –MGR I.T. /SQL Dev DBA – Home Construction Lending
IndyMac Bank
Pasadena, Ca
02.2006 - 07.2007
- Managed a team of nine developers and one developer DBA in the IndyMac Home Construction Lending division. Some of the team is onshore and some is located offshore in India.
- Maintain several vendor relationships and their interfaces.
- Maintain Disaster Recovery documentation for all our applications.
- Former member of the IMB Betterment Committee seeking improvements in the overall processes of the company.
- Review requirements submitted by the business unit and ensure questions are clarified before handing to the developer team.
- Support the I.T. staff with technical issues and with providing solutions.
- Maintain project plan of all capex projects and enhancements including build, testing and production release phases.
- Enforce best practices of .NET, asp, VSS and SQL code and security to assure process controls.
- Report status on all projects to the business unit, and to upper management as required.
- Estimate ROI and cost when requested for a given project.
- SQL code review for Home Construction Lending developers.
Senior Production DBA
IndyMac Bank
Pasadena, Ca
01.2001 - 02.2006
- Production SQL Support for over 40 Enterprise SQL Servers and SQL Clusters.
- SQL automation created to alert for failed jobs and processes.
- Database logical and physical design, worked with Dev teams.
- Troubleshooting DTS, replication, and SQL performance.
- Supported our Data Warehouse and Reporting teams.
- SQL programming of stored procedures, views, triggers.
- SQL Auditing implementation and SQL Security support.
SQL Server 7.0 and 6.5 DBA
Ticketmaster
Pasadena, Ca
01.1999 - 01.2001
- Transact-SQL programming: Created stored procedures, triggers, and views as requested.
- Some experience with database design and schema.
- Use of BCP and DTS for data loads into production databases.
- High level of troubleshooting experience.
- Implemented and manage an aurum database dbsync program to replicate data from the sales force in the field offices to the child server in the homes office, and from there to the parent server in the home office.
- Supported over 20 production SQL 6.5 servers and SQL 7.0 servers.
- Supporting over 10 additional SQL 7.0 development servers on Windows 2000.
- Daily tasks involve ensuring the successful completion of scheduled SQL jobs such as DBCC’s, integrity checks, optimization, and updating statistics.
- Troubleshooting errors with databases, indexes, transaction logs, and backups.
- SQL 7.0 Cluster Implementation with fiber technology.
- IIS 5.0 secure site implementation, which access multiple SQL servers.
- Altiga Cisco VPN and Windows 2000 Terminal Server implementation.
- Implementing of Exchange 5.5 cluster server for the entire organization.
- A high level of experience gained in troubleshooting with both Exchange server issues as well as Microsoft cluster server.
- Comfortable with Cisco router and Extreme switch configuration.
- Compaq Insight Manager Implementation.
Senior Systems Engineer
Data Systems West
Woodland Hills, Ca
01.1997 - 01.1999
- Support Clients with NT 4.0, 3.51 and Novell 5.0, 4.11, 3.12 networks.
- Telephone and on-site support.
- Pre-sales, consulting, implementation.
- Hardware and software installation, configuration and troubleshooting.
- Database administration with SQL server 7.0 and 6.5.
- Project management experience.
- Cisco switches and router configuration, voice mail systems, and various third-party products for both NT and Novell such as fax solutions, network backups, anti-virus products.
- Some Unix experience.
- Metaframe and Terminal Server Experience.
- Some Checkpoint and Raptor firewall experience.
- IIS 4.0 and 3.0 experience.
Systems Engineer
Computer Network Services
Northridge, Ca
01.1995 - 01.1997
- NT 4.0 and 3.51, Novell 4.11 and 3.12 troubleshooting and installations.
- Hardware and software installation, configuration and troubleshooting.
- Working for this small company provided a wide range of experience in the computer industry, from sales and proposals to engineering and implementation.
- Goldmine experience gained.
Accounts Receivable
National Commercial Recovery
Calabasas, Ca
01.1993 - 01.1995
- Representing many clients in the collection of insurance premiums.
- Experience in workers’ comp, liability, and auto premiums.
- Dictated status reports, preparation of files for litigation.
- High visibility to customers.
Mortgage Loan Broker
Warner Oaks Financial
Woodland Hills, Ca
01.1987 - 01.1993
- Building customer relations in order to obtain mortgage loan business.
- Customers were met at their home or in the office.
- Pay was based solely on commission.
- Knowledge of computers was important because marketing, advertisement, and contact management programs were a vital part of production.
Education
SQL 2008 Performance Tuning -
IDT Institute
East West Bank01.2010
PeopleTools Training -
Oracle University
East West Bank01.2010
MS Project Server 2003 Professional Training - Project Management Essentials Training
Learning Tree University
01.2006
EPMS Training and SDLC Process Training -
PMO
01.2005
Visual Basic 6.0 programming course -
Learning Tree University
Chatsworth, Ca01.2001
Associates of Arts Degree -
L. A. Pierce College
Woodland Hills, Ca01.1997
Skills
- SQL database management
- Azure SQL
- Database design
- Database modeling
- T-SQL coding
- Performance tuning
- PowerShell
- Bash
- Backup systems
- SolarWinds (NPM, DPA)
- San
- VMware
- Nutanix
- Exchange
- Extensive banking knowledge
Accreditations
- IT Information Library Foundations Certification (ITIL)
Certification
Microsoft Certified: Azure Database Administrator Associate
Languages
Spanish
Professional
Timeline
Lead Senior Database Administrator
Farmers & Merchants Bank
04.2019 - Current
Senior Production DBA/ Manager
RIA Financial Services
07.2013 - 04.2019
Senior Production DBA
Equator, LLC
01.2011 - 07.2013
VP- IT Systems and Database Engineering
East West Bank
08.2009 - 01.2011
Senior Production DBA
East West Bank
08.2007 - 08.2009
AVP –MGR I.T. /SQL Dev DBA – Home Construction Lending
IndyMac Bank
02.2006 - 07.2007
Senior Production DBA
IndyMac Bank
01.2001 - 02.2006
SQL Server 7.0 and 6.5 DBA
Ticketmaster
01.1999 - 01.2001
Senior Systems Engineer
Data Systems West
01.1997 - 01.1999
Systems Engineer
Computer Network Services
01.1995 - 01.1997
Accounts Receivable
National Commercial Recovery
01.1993 - 01.1995
Mortgage Loan Broker
Warner Oaks Financial
01.1987 - 01.1993
SQL 2008 Performance Tuning -
IDT Institute
PeopleTools Training -
Oracle University
MS Project Server 2003 Professional Training - Project Management Essentials Training
Learning Tree University
EPMS Training and SDLC Process Training -
PMO
Visual Basic 6.0 programming course -
Learning Tree University
Associates of Arts Degree -
L. A. Pierce College