Technical Support Sql Server

Rene Lopez, Jr.

1-512-***-**** ****.*****.**@*****.*** https://www.linkedin.com/in/rene-lopez-jr

EXPERTISE IN

Backup and Recovery – Performing scheduled and unscheduled database backups, restores, and migrations for sandbox, testing, QA, and production environments.

Customer Service – Providing technical support to the entire enterprise to include on-call responsibilities and off-hours/holiday support.

SQL Administration – Monitoring and optimizing all production and non-production SQL systems using SQL Management Studio (SSMS) and SQL scripts. Administration tasks include SQL installations/Service Packs, user management, release management, SQL jobs, utilizing the Tuning Advisor and Upgrade Advisor.

SQL Development – Writing customized scripts for creating Ad Hoc reports, databases, database objects (indexes, tables, stored procedures, users), data migrations, and SQL jobs.

Technical Documentation – Authoring technical and user documentation for new and existing applications. Topics included SQL Server Installation/Configuration, Trouble-shooting methods, Database and Object creation, The SDLC Process, and internal business operations.

WORK EXPERIENCE

Independent Consultant San Antonio, Texas January 2014 – Present

Providing technical and non-technical services and advice to diverse clients. Establishing requirements for new and existing projects. Documenting the Statement of Work. Performing the required tasks to complete the project. Obtaining client approval on the completion of the project including sign-off.

Collaborating with up to 20 clients on a regular basis while completing projects and maintaining the relationship.

Providing 24x7 on-call support as needed, sometimes visiting client sites, giving the clients added confidence and value.

Providing recommendations for hardware, software, and business processes to sustain and promote business development and growth.

San Antonio Independent School District San Antonio, Texas

Database Administrator March 2022 – October 2022

Supporting over 50 SQL Server systems. Gathering data requirements from developers and users for new and existing systems. Writing/updating SQL code to create over 60 various database objects.

Managing 75+ database backup/restore/migration jobs including unscheduled executions.

Provided technical support to the enterprise including the usage of SQL Query Editor, SQL Profiler, and viewing Execution Plans.

Creating/Modifying 50+ technical documents. Managing the documentation library in the areas of SQL programming, technical support, data migrations, database backup/restore operations.

Collaborating with multiple departments to define specifications, provide timely feedback on projects while managing the release of all database updates.

Datalogic Software Inc. Harlingen, Texas

IT Database Specialist November 2021 – January 2022

Supporting over 40 production/non-production SQL systems for clients in the healthcare market.

Providing metrics for data usage and database growth for 50+ production and QA systems to assist in capacity planning.

Collaborating with the development team to define specifications/requirements for projects and complete existing projects while being compliant with HIPAA policies.

Building a technical library with over 40 documents for areas including Business Processes, Data Flow Diagrams, Software Installation, and Help Desk support.

Northeast Independent School District San Antonio, Texas

SQL Server DBA February 2018 – November 2021

Monitoring 60+ SQL Server systems, on physical and VMWare environments to include server availability, successful job execution and disk space usage. Optimizing all SQL production systems by utilizing index management, file growth support, data/log file shrinking, and updating table statistics.

Defining and enforcing database configuration, backup and restore methods, data storage, HIPAA security, and data retention policies as required by the school district.

Implementing high availability solutions by utilizing SQL Clustering and Log Shipping across 25 SQL Server systems.

Creating and supporting the technical documentation library in areas such as: Help Desk, Customer On-Boarding, Technical Support, Software Installation, and Data Flow Diagrams.

Biobridge Global San Antonio, Texas

Database Administrator March 2013 – December 2017

Collaborating with the Infrastructure team to operate and maintain 30+ production SQL Server systems and 40+ Development and QA servers using SQL Management Studio and Solar Winds.

Providing exceptional customer support across the organization, including weekend support.

Implementing Log Shipping and Clustering for highly visible production SQL Server systems.

Authoring and maintaining documents used for Software Installation, Definition of Internal Processes, the Software Development Lifecycle, Introduction to Relational Databases.

EDUCATION

Master of Science (Computer Information Systems) - St. Mary's Univ., San Antonio, TX

Bachelor of Arts (Computer Science/Applied Statistics) - St. Mary's Univ., San Antonio, TX

CERTIFICATIONS

Microsoft Certified Technology Specialist (MCTS) - SQL Server 2008

Oracle Certified Professional (OCP) – Oracle 8i

ADDITIONAL INFORMATION

Hobbies include bike riding, bowling (I have established a 200 average), fictional writing (I am a published author), guitar playing, music/lyric writing, and walking.

Easy going, easy to talk to/get along with, goal oriented, and team player.

Contact this candidate