Malena V.

Average 0 of 5

Freelancer activity: IT & Programming

Chile

Skills (Maximum: 3)
Languages
Work history
Malena Salomé Villegas


Estado Civil:  Soltera
Nacionalidad:  Argentina
Edad:  24 años
Fecha de nacimiento: 26/1/1989
Teléfono fijo: 005629356988
    Dirección:  Carlos Antúnez 1831 Dpto. 816 - Providencia 
Ciudad: Santiago de Chile
Teléfono móvil:  0056968481789
E-mail:  male.villegas89@gmail.com



Curriculum Vitae

    
Experiencia Laboral    
•    Octubre 2012 – Actualidad

Galatea Ldta

DBA MS-SQL Server 2000/2005/2008
DBA MySQL

Responsabilidades:

    Interpretación de modelos relacionales de bases de datos
    Instalación y configuración de MSSQL Server engine, SSIS, SSAS, SSRS
    Actualización y migración de bases de datos MSSQL & MySQL
    Creación y mantenimiento de bases de datos relacionales en MSSQL & MySQL
    Implementación de políticas de seguridad
    Tuning de queries en MSSQL & MySQL
    Creación e implementación de auditoría a través de Triggers DDL
    Capacitación en buenas prácticas al equipo de desarrollo
    Importación y exportación de data
    Análisis y solución de problemas relacionados con baja performance de Instancias MSSQL y Scripts
    MSSQL Server 2000, 2005, 2008 / R2
    Optimización de procesos a través de índices.
    Programación y optimización de scripts MySQL





•    Enero 2011 – Julio 2012

International Business Machines - IBM Argentina

Perfil: Administrador Semi-Senior base de datos Microsoft SQL Server.

DBA MS-SQL Server  2000/2005/2008 / 2008 R2

Responsabilidades:

    Focal account en NiSource company
    Crear y mantener soluciones de alta disponibilidad de SQL Server:
o    Log shipping
o    Mirroring
o    Replication
o    Windows clustering
    Crear y mantener bases de datos requeridas ambientes de
desarrollo, testeo y producción
    Planear e implementar estrategias de backup y recovery
    Manejar usuarios / logins
    Ejecutar cambios en la estructura de bases de datos basados eninformación otorgada por desarrolladores
    Asegurar la disponibilidad de las bases de datos
    Asegurar la seguridad de las instancias de SQL Server
    Aplicar parches de seguridad en instancias de SQL Server
    Monitorear y optimizar la performance en bases de datos
    Restaurar los servicios de bases de datos para situaciones de
DisasterRecovery
    Restaurar bases de datos en caso de falla de hardware o software
    Crear procesos de detección de errores y alertas para monitoreo deambientes.
    Aplicar y mantener encriptación con TDE (Transparent Data Encryption)
    Monitoreo a través de Management tolos (Performance Monitor, SQL Diags, Profiler).




    •    Marzo 2009 – Enero 2011

Villegas e hijos

Tarea: Atención personalizada a clientes vía telefónica.
Control de compras, pedidos y recepción de productos.

    Pagos a proveedores.
    Control de Stock.
    Diseño web mediante CMS.




•    Diciembre 2007 - Febrero 2009

Teleperformance

Tarea: Atención telefónica bilingüe (Helpdesk).
Realización de trabajos de Back Office.






Certificaciones    •    70-432 : Microsoft SQL Server 2008, Implementation and Maintenance (MCTS) – Junio de 2012.

https://mcp.microsoft.com/authenticate/validatemcp.aspx
Transcript ID: 1004263
Access Code: MVILLEGAS
Educación    •    Estudios Universitarios: INACAP
Cursando 1 año de Ingeniería en Informática.

•    Estudios Secundarios: Instituto Don José de San Martín.
Titulo: Bachiller en Ciencias Naturales R.M. 4625/98 382/03 y
6247/03 2007
Idiomas    •    Inglés - Escrito: Bilingue.

•    Inglés - Oral:  Bilingue.


Conocimientos en programación    

•    MS SQL Server (T – SQL)
•    C++

Cursos de SQL Server (IBM)        70-432  Maintaining & Implementing a Microsoft SQL Server 2008 R2 Database:

    Install SQL Server 2008 and related services - file locations; default paths; service accounts
    Configure SQL Server instances - sp_configure
    Configure SQL Server services - configuration manager; SQL browser
    Implement database mail - set up and configure
    Configure full-text indexing - enable/disable, index population
    Manage SQL Server Agent jobs - create and schedule jobs; notification of job execution; disable/enable jobs; change job step order; logging
    Manage SQL Server Agent alerts - performance condition alerts; SQL event alerts; Windows Management Instrumentation (WMI) alerts
    Manage SQL Server Agent operators - operator schedules; fail safe operator; add a new operator; notification methods
    Implement the declarative management framework (DMF) - create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a condition
    Back up a SQL Server environment - operating system-level concepts
    Manage logins and server roles- create logins; disable/enable logins; security model (authentication mode); password policy enforcement; fixed server roles; alter logins
    Manage users and database roles - user mapping; user-defined roles; fixed roles; guest, public, dbo; creating and deleting user roles
    Manage SQL Server instance permissions- logon triggers; permissions vs fixed role membership; cross-database ownership chaining; impersonation
    Manage schema permissions and object permissions- manage schema ownership
    Audit SQL Server instances- use DDL triggers and logon triggers; C2; common criteria; login failures; event notifications
    Manage transparent data encryption- impact of transparent data encryption on backups
    Manage and configure databases- files, file groups, and related options; database options; recovery model; attach/detach data
    Manage database snapshots- create, drop, revert
    Maintain database integrity- DBCC CHECKDB; suspect pages
    Maintain a database by using maintenance plans- Maintenance Plan Wizard; Maintenance Plan Designer
    Import and export data- BCP; BULK INSERT; OPENROWSET; GUI tools
    Manage data partitions- switching data from one partition to another; add a filegroup; alter a partition function; alter a partition scheme
    Implement data compression- sparse columns; page/row
    Maintain indexes- create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offline
    Manage collations- column collation; database collation; instance collation
    Identify SQL Server service problems- DB Engine service; SQL Agent service; SQL Browser service
    Identify concurrency problems- blocks, locks, deadlocks, activity monitor; relevant Dynamic Management Views
    Identify SQL Agent job execution problems- proxy accounts; credentials; job history
    Locate error information- error log; agent log; job execution history; event logs
    Implement Resource Governor
    Use the Database Engine Tuning Advisor
    Collect trace data by using SQL Server Profiler
    Collect performance data by using Dynamic Management Views (DMVs)
    Collect performance data by using System Monitor
    Use Performance Studio
    Implement database mirroring- monitoring, configuring, failover
    Implement a SQL Server clustered instance- monitoring, configuring, failover
    Implement log shipping- monitoring, configuring, failover
    Implement replication- monitoring, configuring, failover




    70-431 Microsoft SQL Server 2005 - Implementation and Maintenance
    Install SQL Server 2005.
    Verify prerequisites.
    Upgrade from an earlier version of SQL Server.
    Create an instance.
    Configure SQL Server 2005 instances and databases.
    Configure log files and data files.
    Configure the SQL Server DatabaseMail subsystem for an instance.
    Choose a recovery model for the database.
    Configure SQL Server security.
    Configure server security principals.
    Configure database securables.
    Configure encryption.
    Configure linked servers by using SQL Server Management Studio (SSMS).
    Implementing High Availability and Disaster Recovery
    Implement database mirroring.
    Prepare databases for database mirroring.
    Create endpoints.
    Specify database partners.
    Specify a witness server.
    Configure an operating mode.
    Implement log shipping.
    Initialize a secondary database.
    Configure log shipping options.
    Configure a log shipping mode.
    Configure monitoring.
    Manage database snapshots.
    Create a snapshot.
    Manage transactions.
    Run the bcp utility.
    Monitor replication.
    Plan for, stop, and restart recovery procedures.
    Maintaining Databases
    Implement and maintain SQL Server Agent jobs.
    Set a job owner.
    Create a job schedule.
    Create job steps.
    Configure job steps.
    Disable a job.
    Create a maintenance job.
    Set up alerts.
    Configure operators.
    Modify a job.
    Manage a job.
    Manage databases by using Transact-SQL.
    Manage index fragmentation.
    Manage statistics.
    Shrink files.
    Perform database integrity checks by using DBCC CHECKDB.
    Back up a database.
    Perform a full backup.
    Perform a differential backup.
    Perform a transaction log backup.
    Back up filegroups.
    Restore a database.
    Implement indexes.
    Specify a partition scheme when creating an index.
    Disable an index.
    Create an online index by using an ONLINE argument.
    Create user-defined types.
    Create a Transact-SQL user-defined type.
    Specify details of the data type.
    Implement a full-text search.

    2778A - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
    2779B - Implementing a Microsoft SQL Server 2005 Database
    2780B - Maintaining a Microsoft SQL Server 2005 Database
    2788A - Designing High Availability Database Solutions Using Microsoft SQL Server 2005
    2789B - Administering and Automating Microsoft SQL Server 2005 Databases and Servers
    6231B - Maintaining a Microsoft SQL Server 2008 R2 Database
    6232B - Implementing a Microsoft SQL Server 2008 R2 Database
    10158 - Implementing High Availability and Replication in Microsoft SQL Server 2008
    

Otros conocimientos    
•    Windows 9x, Windows 2000, Windows 2003 Server, Windows 2008 Server, Windows 7,  Windows XP 
•    Office 9X, 2000, 2003, 2007
•    Microsoft Outlook 98, 2000, 2002, 2003, 2007.
Hire
Activity and ratings

Last login: 3 years ago

Joined: 3 years ago


Ranked: Not ranked

Profile level: Iron

What is profile
level iron?

Iron is the starter level for freelancers in Workana. The more objectives they fulfill, and the more projects they win, allows them to reach higher levels. Read more

Loading...