Rene Lopez Jr

SQL Database Administrator at Datalogic Software

View Rene Lopez Jr Emails (It's free) 10 Emails free

Rene Lopez Jr's Summary

SQL SERVER DBA Certified Database Administrator with proven excellence in handling Advanced IT projects. Possesses skills in Microsoft SQL Server tools and technologies with knowledge of the Database Lifecycle Management including Backup/Restore Operations, Database Architecture, Database Design, Disaster Recovery, High Availability, Maintenance, Server Configurations, Service Packs, Software Upgrades, SQL Development, and T-SQL Programming for diverse and multiple clients. Delivered mission-critical outcomes in the industries of technical consulting, education, gaming software, healthcare, insurance, manufacturing, and the United States government. EXPERTISE IN * Backup and Recovery – Performing scheduled and unscheduled database backups and restores for sandbox, testing, QA, and production environments. * Communication - Maintaining a high level of discussions, feedback and interaction with users, business owners, and managers during the entire project scope. * High Availability – Implemented high availability technologies to include Clustering, Log Shipping, Replication, Database Mirroring, and Full Recovery database settings as required by the client or the current project. * Security – Allowed specific and approved users with limited database access to production servers. Performed semi-annual security audit of all user permissions and modified/disabled user profiles as needed. * SQL Administration – Monitoring and optimizing all production and non-production SQL systems using SQL Management Studio (SSMS) and customized SQL scripts. Administration tasks include SQL installations/updates, user management, and release management. * SQL Development – Writing customized and Ad Hoc SQL scripts for creating database objects (tables, indexes, stored procedures, functions), data migrations, database updates and user management. Used SQL Server Integration Services (SSIS) to create packages that read, transformed, and wrote data from a source system to a destination system. * Technical Documentation – Authoring technical and user documentation for new and existing applications. Topics included Installation/configuration of SQL Server, Trouble-shooting guidelines, Database and Object creation, Internal business processes, and specialized topics. * Troubleshooting – Performing technical troubleshooting and analysis on application, server, and database performance issues. Used SQL Profiler to capture any technical database issues. [email protected] ReneLopezJr.com