Post Job Free

Resume

Sign in

Sql Server Manager

Location:
Santa Monica, CA
Posted:
August 18, 2017

Contact this candidate

Resume:

RUTH ELIZABETH ROMERO-ESCAMILLA

Cellular phone 323-***-****

Santa Monica, California

Email: ac1wdw@r.postjobfree.com

Objective:

Secure a challenging Information Technology position commensurate with skill set that provides challenging work and professional growth opportunity.

Professional Summary:

Over 15yrs of professional work experience in technically demanding positions. Extreme attention to detail coupled with solid leadership and interpersonal communication skills. Strong expertise in: Object-oriented programming, DBA, System Administration, Network management, Possesses a strong quantitative background in programming, database programming, and statistical analysis. Highly focused and disciplined with the ability to independently plan, manage, and execute multiple projects simultaneously, while also responding to any ad-hoc tasks, ETL.

Education:

Masters Project Mgmt/Business Consulting – Universidad Nacional El Salvador-ASIMEI (DEC 1999)

BS Computer Science Engineer – Universidad Centro Americana José Simeón Cañas-UCA El Salvador (Sept 1994)

Certifications:

•Microsoft Network administrator Windows NT Certify.

•Microsoft Certified Solutions Expert (MCSE)

•Communication, SharePoint, Business Intelligence, Desktop Infrastructure.

•Microsoft Administrator SQL Server v6.5 and SQL Server 2005, SQL 2008 R2, SQL 2010/2012/2014.

•Administrator Database SYBASE.

•Oracle Database Certify, Form and Reports, PL/SQL

•Introduction to the communication protocols Certify

•Installation, configuration and use of Tools of CA-UNICENTER TNG (Network management) Certify

•Introduction to bridges, gateways and routers Certify

•Technical tutorial TCP/IP and overview Certify

•Hand on TCP/IP Networking Windows NT Certify

•CCNA - Cisco Networking Academy Certify (I modulate I, II, III and IV)

•Adobe Master Collection CCS3, CCS5, CCS6 (Suit Dreamweaver, Flash, Photoshop, Bridge, Contribute, Encore, Fireworks, Illustrator, Premier Pro).

Language:

Visual Basic, C, C++, Fox Pro 2.5, Fox Prow 6.0, Visual Fox, Power Builder, Star Designer, Informatics, Oracle Developer Forms and Reports, Java Script, HTML, PowerBuilder, C#, PL/SQL, SQL, T-SQL, SSIS, SSRS, Visual Studio 2012/2014, XML, VBA, VB Scripting, Adobe Master Collection CCS3, CCS5,CCS6, Macro, Python, PERL.

Software:

MS SQL 6/5 Server, SQL 2005, SQL 2008 R2, SQL 2010/2012/2014, SYBASE SQL 10.0, Oracle 8.1.6i, 9.0i, 10G and 11G, SQL Enterprises Manager, Service Manager, SQL Server BI Tools, Import Export Data, T-SQL, PL/SQL, MDX, Crystal Reports 9/10, SSAS, SSIS, SSRS, HTML, Dimensional Modeling, DW architecture, Tableau, ETL Frameworks, Troubleshooting, C, C++, TNG CA Unicenter installation and configuration(Software Delivery, Software Asset Management, Console TNG Administration).

Operating Systems:

MSDOS, Windows XP, Windows 98, Windows 2003 Server and 2000 Server, Windows2000, Windows 2007, Windows Vista, Windows 8, Windows 10, Unix/Linux system, file systems, shell scripting. UNIX shell scripting/bash process, Power Shell Scripting, work experience with UNIX (Solaris, AIX, Linux) and Microsoft Windows system administration.

Hardware/Networking:

Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 & 6, .NET., Networks LAN and WAN and communication protocols, Implementation of atmosphere protocol TCP/IP Windows, Handling of Software of Network Management CA-Unicenter TNG, Automatic distribution of Software, Services of Inventory of Software and Hardware, graphical interfaces for the handling of the SNMP in servers, compatible Routers, Hubs and devices with this protocol, Implementation and configuration of servers DNS, DHCP and WINS, VOIP, networking, routing experience, TCP/IP knowledge, Core Java programming, Java Programming and Queries Java, HP OpenView software (provided large-scale system and network management of an organization's IT infrastructure)

Technical Skills:

Overall PL/SQL and SQL Server Performance tuning, DB tuning, Query optimization, Experience in PL/SQL and SQL development T-SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor, PL/SQL, Shell Scripting, SQL Server Integration Services, SQL Server Reporting Services. SQL Server Administration – SQL Server configuration, Optimizing SP configure, Backup/Restore, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in PL/SQL and SQL Server analysis, SSIS, SSRS, design and implementation of ETL/ELT framework for complex warehouses/marts, app monitoring/management tools, Business Availability Center, HP Open view, C, C++, Tableau, Power Shell Scripting, PowerBuilder.

Professional Experience:

KForce / Dynamic Medical System

April 2016 to Present

Lead consultant of IT department with duties in:

Programming - Created custom web interfaces using C, C++, Visual Studio 2012/2014, for users to map various fields between the client’s dashboard and their associated database. This in turn allowed client to efficiently respond to client’s request for customized fields and forms on their system. shell scripting/bash process, work experience with Microsoft Windows system administration, SQL Server, SQL 2008 R2, SQL 2010/2012/2014, Visual Studio 2012, ETL/Data stage .

Database Administration – Create Data Base with tables, indexes, Primary keys and Conducted tuning of major databases, utilizing various tool sets (SQL PLUS Scripts and Triggers, SSIS, SSRS and PL/SQL) Conducted backups, restores, and recovery disasters, file systems, shell scripting, Power Shell Scripting. Implemented SAN Storage management, Software Asset Management installation and configuration, anti-viruses with automated run-times, firewalls, security integration: software, switches, routers, hardware, and data base.

Networking – Implemented router with switch and anti-intrusion detection. Set up shared peripheral networking, integration for client server, file systems, and shell scripting. Received telephone calls on hardware, software, and SNA and Ethernet problems; troubleshooting for root cause and resolution. Including LAN, WAN, controllers, lines, routers, terminals, and printer problems; software problems including file transfer using FTP; resetting VM and MVS passwords; resetting user ids through SNA and Ethernet connecting on VM systems.

Design and implementation of Web Page- Suit Dreamweaver, Fireworks, Photoshop, Illustrator, Flash, Bridge, Contribute, After Effect, HTTP, HTML

American Hallmark Technologies

Santa Monica, CA

April 2013 to April 2016

Lead consultant in charge of IT department with duties in:

Programming - Created custom web interfaces using C, C++, Visual Studio 2012 for users to map various fields between the client’s dashboard and their associated database. This in turn allowed client to efficiently respond to client’s request for customized fields and forms on their system. UNIX shell scripting/bash process, work experience with UNIX (Solaris, AIX, Linux) and Microsoft Windows system administration, ETL/Data stage,.

Database Administration – Conducted tuning of major databases, utilizing various tool sets (Oracle RMAN, SQL PLUS Scripts and Triggers, SSIS, SSRS and PL/SQL), SQL 2008 R2, SQL 2010/2012/2014. Conducted backups, restores and recovery disasters, file systems, shell scripting, Power Shell Scripting. Implemented SAN Storage management anti-viruses with automated run-times, firewalls, security integration: software, switches, routers, hardware, and data base, Software Asset Management installation and configuration.

Networking – Implemented router with switch and anti-intrusion detection. Set up shared peripheral networking, integration for client server, file systems, and shell scripting. Received telephone calls on hardware, software, and SNA and Ethernet problems; troubleshooting for root cause and resolution. Including LAN, WAN, controllers, lines, routers, terminals, and printer problems; software problems including file transfer using FTP; resetting VM and MVS passwords; resetting user ids through SNA and Ethernet connecting on VM systems.

Design and implementation of Web Page- Suit Dreamweaver, Fireworks, Photoshop, Illustrator, Flash, Bridge, Contribute, After Effect, HTTP, HTML

C Prints L.A.

Los Angeles, CA

Feb 2011 to Dec 2012

Senior IT System Administrator:

Main server installation and configuration

Microsoft Exchange

User Configurations

Security (HTMS)

System Administration (SQL), SSIS, SSRS and PL/SQL

Unix/Linux (SQL PLUS, PL/SQL)

Software Accounting installation and configuration

Software Asset Management installation and configuration

Networking Configuration

Design and implementation of Corporative Website

Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Enterprise Manager, Photoshop, Suite Dream Weaver

Implementation and Monitoring Networks LAN and WAN and communication protocols.

Implementation of atmosphere protocol TCP/IP Windows Servers, printers and terminals

VOIP, networking, routing implementation, TCP/IP and FTP transfers files

UNIX shell scripting/bash process, Power Shell Scripting, work experience with UNIX (Solaris, AIX, Linux) and Microsoft Windows system administration.

Government of El Salvador

El Salvador, San Salvador

Feb 2001 to Dec 2009

Programming and Implementation of DUI (Unit Document Identity For Government of El Salvador)

Implementation of Civil IAFIS for Unit Document Identity for Government of El Salvador: The Integrated Automated Fingerprint Identification System, or IAFIS, is a national fingerprint. IAFIS provides automated fingerprint search capabilities, latent search capability, electronic image storage, and electronic exchange of fingerprints and responses

Implementation of Network Branch of RNPN-DUICENTROS (Registro Nacional de Personas Naturales) for El Salvador Government

Implementation of SAP financial software for ISSS (Salvadorian Institute of Social Secure of Government of El Salvador)

Implementation of Network and communication for Presidential and Deputy Election for Government of El Salvador TSE(Tribunal Supreme Election of El Salvador)

Implementation and Configuration of Workflow Software Onbase OCR, Rational Rose and Enterprise Manager for Presidential and Deputy Election for Government of El Salvador TSE(Tribunal Supreme Election of El Salvador)

Manager of Data Center of ANDA (Power and Water Administration) for El Salvador Government

Implementation and configuration of servers DNS, DHCP and WINS for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Programmer analyst in the department of informatics Development, ETL/Data stage, PowerBuilder, Management of Computer science of Data Center for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Analyst in Committee of Improvement for Automatization Department of Credits and invoices of ANDA (Power and Water Administration)

Support for Update of Operating system in Servers NT, UNIX, HP SAN Storage for for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Database Administration for: MS SQL 6,5 Server and SQL 2005, SYBASE SQL 10.0, SSIS, SSRS and PL/SQL, Oracle 8.1.6i, 9.0i, 10G and 11G, file systems, shell scripting for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Database SQL Developer, SSIS, SSRS and PL/SQL: Overall SQL and PL/SQL Server Performance tuning, DB tuning, Query optimization, Experience in SQL and PL/SQL development T-SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor file systems, shell scripting for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador) and RNPN (Registro Nacional de Personas Naturales)

SQL DBA, SSIS, SSRS and PL/SQL: PL/SQL and SQL Server Administration – PL/SQL and SQL Server configuration, Optimizing SP configure, Backup/Restore file systems, shell scripting, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in SQL Server analysis is plus for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador) and RNPN (Registro Nacional de Personas Naturales)

Administration Tools of Communication: Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 &6 for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Implementation and Monitoring Networks LAN and WAN and communication protocols for RNPN-DUICENTROS Branch.

Implementation of atmosphere protocol TCP/IP Windows Servers and terminals for RNPN-DUICENTROS Branch.

VOIP, networking, routing implementation, TCP/IP and FTP transfer files for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Enterprise Manager, Photoshop, Suite Dream Weaver for ANDA (Power and Water Administration), TSE(Tribunal Supreme Election of El Salvador)and RNPN (Registro Nacional de Personas Naturales)

UNIX shell scripting/bash process, work experience with UNIX (Solaris, AIX, Linux) and Microsoft Windows system administration.

CITI Bank El Salvador

Santa Tecla, El Salvador

Jan 1996 to Jan 2001

Coordinator of Project and Implementation of software CA-UNICENTER TNG (Network Management) of the CITI Bank (Cuscatlán Bank El Salvador).

Handling of Software of Network Management CA-Unicenter, Automatic distribution of Software, installation and configuration of Asset Management Software with Services of Inventory of Software and Hardware, graphical interfaces for the handling of the SNMP in servers, compatible Routers, Hubs and devices with this protocol.

Implementation and configuration of servers DNS, DHCP and WINS

Programmer analyst in the department of informatics Development, Management of Computer science of Data Center

Analyst in Committee of Improvement for Automatization Department of Credits CITI (Cuscatlán) Bank El Salvador.

Support for Update of Operating system in Servers NT, Project 2000 CITY (Cuscatlán) Bank El Salvador.

Database Administration for: MS SQL 6,5 Server and SQL 2005, SQL Server 2010/2012/2014, SYBASE SQL 10.0, SSIS, SSRS and PL/SQL, Oracle 8.1.6i, 9.0i, 10G and 11G

Database PL/SQL and SQL Developer: Overall SQL Server Performance tuning, DB tuning, Query optimization, Experience in SQL development T-SQL, SSIS, SSRS and PL/SQL, Views, Tables, SP, Triggers and functions, Indexing, Query plan analysis, DMV, Disk IO analysis, Migrating large quantities of data and writing complex queries for data analysis, BCP - migration, Informatics Resource monitor file systems, shell scripting.

PL/SQL and SQL DBA: SQL Server Administration – PL/SQL and SQL Server configuration, Optimizing SP configure, Backup/Restore, DB move, File Group, database file allocation and optimization, Transactional Replication and Always on, Experience in SQL Server analysis, SSIS, SSRS and PL/SQL, file systems, shell scripting, ETL/Data stage.

Administration Tools of Communication: Lan Work Place for Win3.11 and Windows 95, FTP, Cisco Routers, Switches, Vlans, Fiber Optic, UTP Cables cat 5 &6.

Implementation and Monitoring Networks LAN and WAN and communication protocols for Branch.

Implementation of atmosphere protocol TCP/IP Windows Servers and financial terminal

VOIP, networking, routing implementation

TCP/IP and FTP transfers files

Programming and developer Tools of Office: Lotus, Project, Word Perfect, Visio, Corel Draw, Flow, News, Harvard Graphics, Mac Finish and Photo Finish, Office, Excel, PowerPoint, Access, Publisher, Office Pro, AutoCAD 2000, Rational Rose, Manager, Photoshop, Suite Dream Weaver, HTML, HTTP, C, C++.

UNIX shell scripting/bash process, work experience with UNIX (Solaris, AIX, Linux) and Microsoft Windows system administration.



Contact this candidate