Profileimage by LeandroDamin Gmez Database Administrator  DBA, Analyst Tester & QA  Leader, External SQL Server Consultant from

Leandro Damián Gómez

available

Last update: 06.09.2022

Database Administrator DBA, Analyst Tester & QA Leader, External SQL Server Consultant

Graduation: Computer Science, MCSA Sql Server, Ethical Hacking, Pentest Certification
Hourly-/Daily rates: show
Languages: English (Limited professional) | Spanish (Native or Bilingual)

Attachments

CV Leandro Damian Gomez - English.pdf

Skills

Lead Database Administrator • DBA • Century Link Database Administration

Database Administration on SQL Server 2008, 2012 & 2014:
• High Availability setups (Replication + MS Clusters). • Monitor databases in a high-volume production environment. • Install, patch and upgrade SQL server. • Maintain database security policy, permissioning, and user accounts. • Manage database backup and data retention strategy. • Troubleshooting. • Performance Tests. • Integration Services (ETL).
• Knowledge of Power Bi. Gateways configuration.
• Management and administration of VMware. Analysis and Programming - SQL / T-SQL (Microsoft SQL Server): • Installation, configuration, upgrade and migration of the whole databases of the companies. • Planning, modeling, design and development of new data structures. • Collection and analysis of user requirements in order to obtain conceptual and logical models that accurately reflect the data requirements of the company. • Tunning, maintenance and performance of productive databases. • Development and implementation of indexing and updating statistic routines. • Monitoring, identification and resolution of bottlenecks by using DMV's, traces, Performance Monitor, etc. • Dimensioning, partition and maintenance of data files. • Improving of queries performance (execution plan analysis etc). • Backup and Restore (design - implementation - recovery test etc). • Security databases. Authentication, authorization and permanent audit of internal and external users. • Maintenance data on / off line. (integrity - swipe historical – etc.). • Continuous review of data structures / implementation alerts. • Scripting documentation task and data dictionary maintenance. • Performing of regular Stress Test. • Support to Administration Department on reconciliations traffic and other issues. • Support to Software Development Department. (permanent Inter-relationship in t-sql scripting, database access, tuning issues, permissions , etc).
Database Administration on SQL: • Mirroring setup • Backup & Restore strategies • Installations, Configurations • Automation tasks.

Analyst Tester & QA • Leader • Crédito Regional Compañía Financiera S.A.
• Preparation of User Stories
• Creation of monitoring reports
• Follow-up of BCRA Audit Observations
• Documentation of the Development Process
• Documentation of Work Methodology and Incident Report
• Performing leadership tasks.
Used tools:
• Jira (Administration and monitoring of incidents)
• SQL Server (Database Administration)
• MS PROJECT

Project history

12/2014 - Present
Lead Database Administrator
Crédito Regional C.F. (Banks and financial services, 50-250 employees)

Database Administration on SQL Server 2008, 2012 & 2014:
• Installation of new instances of SQL Server with experience in Migrations. • Implementation and maintenance of high availability of databases (Microsoft Clustering, Mirroring, Log Shipping and Replication) • Migrations and project planning. • Patching: Application of patches and Services Packs in SQL Server. • Security: Creation, Modification, and Elimination of users and logins. Permit Management. • Maintenance Tasks: Backup and Restore, Disaster Recovery, Maintenance Plans. • Performance Tasks (Reorganization and Rebuild of indexes). • Maintenance of Jobs and Alerts. • Experience in managing and implementing Reporting Services / Analysis services / Integration Services features. • Execute and analyze traces on databases before incidents in applications (SQL Server Profile).
• Knowledge of Power Bi. Gateways configuration.
• Management and administration of VMware.

06/2005 - 12/2014
Analyst Tester & QA * Leader
Crédito Regional Compañía Financiera S.A.

Compañía Financiera S.A.

* Preparation of User Stories

* Creation of monitoring reports

* Follow-up of BCRA Audit Observations

* Documentation of the Development Process

* Documentation of Work Methodology and Incident Report

* Performing leadership tasks.


Used tools:

* Jira (Administration and monitoring of incidents)

* SQL Server (Database Administration)

* MS PROJECT

03/2011 - 12/2013
Professor of the PC Assembly and Repair Course
IAC Instituto Argentino de Computación

Computación

Professor in charge of the PC Assembly and Repair course. I had 18
students in charge per course.

03/2011 - 12/2013
Professor of the PC Assembly and Repair Course
IAC Instituto Argentino de Computación

Computación

Professor in charge of the Microsoft Network Administration course. I
had 15 students in charge per course.

03/2010 - 12/2010
Professor of the PC Assembly and Repair Course
IAC Instituto Argentino de Computación

Computación

Professor in charge of the Programming course in Visual Basic and
Asp.net language.

Local Availability

Only available in these countries: Argentina

Other

I am a person oriented towards the goals and objectives of the organization, applying my knowledge to achieve a coordinated job that allows the growth of the company as well as my personal and professional growth.
Profileimage by LeandroDamin Gmez Database Administrator  DBA, Analyst Tester & QA  Leader, External SQL Server Consultant from Database Administrator DBA, Analyst Tester & QA Leader, External SQL Server Consultant
Register