Please upgrade to the business membership to download freelancers' CVs.
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.