RENE LOPEZ, JR.

San Antonio, Texas • 512-***-**** • ad4662@r.postjobfree.com

DATABASE ADMINISTRATOR

SQL DBA • Query Optimization • Database Security • Disaster Recovery (DR)

Analysis • High Availability Solutions (HA) • SQL Development • Technical Writing

Received Recognition For 5 Years of loyal Service at BioBridge Global.

EXPERIENCE

San Antonio Independent School District; San Antonio, Texas March 2022 - Oct 2022

Database Administrator

Oversaw over 50 production and non-production SQL Server systems in the education industry running under SQL versions 2012 – 2019.

Monitored SQL Server systems for performance to determine the level of database tuning.

Provided a high quality of customer service across the enterprise to include development teams, school administrators, teachers, and parents.

Responsible for database backups, data refreshing, database restoring, and data migrations as needed or required by a project.

Implemented robust failover clustering & transaction log backups as high availability (HA) and disaster recovery (DR) solutions for both production & QA environments.

Captured disk usage metrics to determine database growth rates for capacity planning.

Datalogic Software; Harlingen, Texas Nov 2021 - Jan 2022

Database Specialist

Successfully supervised 20 production and 25 non-production SQL Server (2016-2019) systems, catering to clients in the healthcare insurance sector.

Created and implemented a disaster recovery plan and documented it.

Collaborated with IT teams to resolve technical issues for the Customer Service department.

Executed 2-4 daily data refreshes, aiding development teams with project completion.

Enhanced 20 technical and user documents including SQL installation guides, basic SQL tech support manuals, introduction to SQL databases, and database backup/restore policies.

Conducted regular audits of user logins to maintain system security.

Northeast Independent School District; San Antonio, Texas Feb 2018 - Nov 2021

SQL Server DBA

Maintained and monitored over 60 SQL Server (2000-2016) production and QA systems within the education industry using SSMS, PerfMon (Performance Monitor) and Activity Monitor.

Modified and executed 35+ SSIS packages for data modification and migration; executed 40+ custom SQL scripts for the creation of tables, indexes, stored procedures, and views.

Created, managed, and reviewed all SQL logins for users and service accounts for security.

Initiated comprehensive SQL Server backups, installations, updates, hotfixes, and security patches.

Optimized SQL systems with DBCC, index reorganizing strategies, and table statistics updates.

Implemented Failover Clustering and Transaction Log backups as high availability (HA) and disaster recovery (DR) solutions for both production & QA environments.

Biobridge Global; San Antonio, Texas March 2013 - Dec 2017

Database Administrator

Efficiently operated and meticulously maintained 30 production SQL servers (2000-2012) and 50 non-production SQL servers within a HIPAA compliant 24x7 healthcare environment.

Utilized Performance Monitor, Activity Monitor, and SQL Profiler to capture performance data.

Supervised structured code walk-throughs of all SQL code before promoting it into production.

Improved the performance of SQL Server systems with DBCC, index reorganizing/rebuilding, table statistics updates, and disk defragmentation.

Executed SQL installations, patches, upgrades, and disaster recovery solutions.

Utilized Solar Winds software for system monitoring of all production servers.

Authored comprehensive technical documentation with sample code and 'How To' guides, offering a convenient reference for database troubleshooting and programming.

Avanade/Accenture; San Antonio, Texas Feb 2010 - Dec 2012

Systems Engineer

Delivered comprehensive 24x7 SQL Server, Sybase, and Oracle database solutions and decision support systems to global clients in the technology, insurance, and manufacturing Industries.

Implemented Failover Clustering, Replication, & Transaction Log backups as high availability (HA) and disaster recovery (DR) solutions for client production environments.

Ensured adherence to Service Level Agreements via thorough issue resolution.

Worked with teams to identify and promptly solve database-related problems.

Assisted clients with SQL Server installations, SQL Development, SQL code reviews, production implementations, system documentation, and technical recommendations.

Traveled to client sites to provide technical assistance and ensure the completion of projects.

EDUCATION

St. Mary’s University, San Antonio, Texas

Master of Science, majoring in Computer Information Systems

St Mary’s University, San Antonio, Texas

Bachelor of Arts, majoring in Computer Science and Applied Statistics

TECHNOLOGIES

Activity Monitor, DBCC, Microsoft Excel, Microsoft SQL Server 2005-2019, Microsoft Office, Oracle 8i, Oracle 9i, Oracle Forms, Oracle Reports, Performance Monitor, PL/SQL, Redgate Backup, Rubrik Backup, Solar Winds, SQL Server Integration Services(SSIS), Structured Query Language SQL Server Management Studio(SSMS), SQL Server Reporting Services(SSRS), SQL Query Analyzer, SQL Profiler, Toad, Transact-SQL, Visual Studio, Windows Desktop, Windows Server, Visio, VMWare, Microsoft SQL Server 2005-2019, Microsoft Clustering Services

CERTIFICATIONS

Microsoft Certified Technology Specialist - SQL Server 2008

Microsoft Certified Technology Specialist - SQL Server 2005

Oracle Certified Professional - Oracle 8i

Contact this candidate