System Engineer Consultant Resume Profile
Torrance, CA
PROFESSIONAL SUMMARY:
Oscar Esquivel has over 10 years of IT experience as a Systems Engineer and Administrator with extensive experience and knowledge of databases, operating systems and networks. He is very well versed in SQL and Oracle Databases, along with UNIX Shell Scripting. He also has over 8 years of experience expanding SAN and NAS environments for new data warehousing and business object projects. His experience deploying and supporting data warehouses and business intelligence solutions through their full system development life cycle is extensive. He is comfortable managing and driving multiple projects, while being able to resolving issues in an efficient and effective manner. He is well spoken, adaptable and excited about the opportunity to work in a healthcare setting with various technology groups and system users. Bilingual in English and Spanish
TECHNICAL SUMMARY:
SQL Server 7.0, 2000, 2005 2008R2,2012 , SQL Server DBA, SSIS, SSRS, SSAS, Visual Studio 6.0-.NET , Visual Basic VB , Oracle Databases, ETL Extract Transfer Load , VMWare 3.5, Microsoft Office Suite, Unix Shell Scripting, Windows 3x/9x/2000/2003/XP Workstation, Server, Advanced Server, Server Enterprise Edition, x86-16, x86-32, x86-64 , Active Directory, Exchange, SAN, NAS, LAN, WAN, WINS, DNS, AD, WINS, DHCP, IIS, File/Print, MSMQ, Proxy, Terminal Service, Exchange, OWA, Share Point Portal, Cluster, Siebel and Backup Exec services, Powershell.
PROFESSIONAL EXPERIENCE:
Confidential
System Engineer Consultant
- Database Administration in SQL Server 2005 and 2008R2 , 2012 SSRS/SSIS
- Clustered environment with multiple nodes
- Management of IIS 5,6 7.1
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, connectivity issues, security issues etc.
- Managed SQL Server related CPU,memory,I/O, disk space and other resource contention. SQL native, Idera, .
- Utilized ETL to collect data from various sources to assist with business needs.
- Creating and Maintaining Databases along with tables and indexes for all applications.
- Quality assurance, system testing and data cleansing for data processes
Confidential
Systems Engineer
- Implemented Document Management Software enabling clients have a paperless office. Supported sales teams in pre-sales presentations and was part of helpdesk support for clients.
- Account Manager
- Monitored and managed NetApp storage and VMWare 3.5.
- Installed and maintained Scanners for clients.
- Set up and maintained the EMC SAN for clients.
Confidential
System Engineer Consultant
- Managed and supported many firms in San Diego with their time and billing servers as well as their Document management Software servers.
- Manage and Support installations, upgrades and training in Elite Information Systems utilizing SQL Server and VMWare.
- Managed Backup and restore procedures
- Deployed and supported data warehouses and business intelligence solutions through their full system development life cycle.
- Collected data using ETL setup Powershell scripts
- System testing and data cleansing for data processes
- I supported 12 Different firms remotely with 3 environments Production, Development and QA
Confidential
3E Senior Support Upgrade Analyst
- Performed expert technical support for company products and technical integration. Delivered integrated solutions and technical support to Law firms technicians through the country.
- Maintained technical expertise on all products along with SQL Server 2005/ 2008, SSIS, SSRS, SSAS.
- Designed, implemented and handled problems regarding Windows 2000/2003 Server systems and IIS to enable successful application publication.
- Data collection using ETL
- Delivered technical troubleshooting for customer support.
- Coordinated and performed product upgrades for customers and on internal servers.
- Managed coordination of new product introductions as they related to product support.
- Provided general guidance and trained 5-10 support staff.
- Wrote, implemented and published step-by-step procedural documentation for 3E software.
Confidential
System Engineer Consultant
- Designed and oversaw the implementation of integrated network solutions at client sites dealing with hardware, software, operating system configuration, and installation training and maintenance for clients throughout the United States, Canada, Mexico, the UK, Brazil and Argentina.
- Manage and implement the business and marketing backbone, and mentor the team in provision of installations, upgrades, support and training in Elite Information Systems utilizing SQL Server, Oracle and ETL tools.
- Handle all product and project strategies for next generation network designs supporting three-tier architectures covering nine types of UNIX, NT and Windows 2000 client server systems.
- Work directly with clients to configure economic mission critical back office systems capable of supporting all types of network topologies and delivering the highest levels of performance.
- Deployed and supported data warehouses and business intelligence solutions through their full system development life cycle.
- Quality assurance, system testing and data cleansing for data processes.
- Coordinated with EMC to set up and expand clients existing SAN/NAS environment for new data warehousing and Business Objects project.