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

Leandro Damián Gómez

available
Contact

Last update: 10.11.2020

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. (50-250 employees)
Banks and financial services
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.

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.

Contact form

Contact details