09/06/2022 updated
100 % available
Database Administrator DBA, Analyst Tester & QA Leader, External SQL Server Consultant
Argentina
Argentina
Computer Science, MCSA Sql Server, Ethical Hacking, Pentest CertificationWindows ServerSQL ServerSQLSecurityDatabasedba sqlDatabase AdministrationDatabase Administratordatabase analystTestingDBA SQL Server
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
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
Languages
EnglishGoodSpanishNative speaker
Project history
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.
• 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.
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
* 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
Computación
Professor in charge of the PC Assembly and Repair course. I had 18
students in charge per course.
Professor in charge of the PC Assembly and Repair course. I had 18
students in charge per course.