Manager Sql Server

Fabian de Lara

**********@*****.***

https://www.linkedin.com/in/fabiandelara/

Local Address:

Miguel Aleman s/n 7-102, Texcoco, Mexico, 56130

Mobile: +52-55-333*-****

IT & Operations Manager / DBA Roles

Professional Summary

10+ years of experience in Database Administration and Developer for large and complex databases in SQL Server 2016, 2012, 2008 R2, 2005 and 2000

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance

Working knowledge in Analysis Services (SSAS) and Reporting Services (SSRS)

Expertise in T-SQL writing Stored Procedures, Triggers and Functions

Administering SQL Server High Availability (Failover Clustering, Log Shipping and AlwaysOn)

Knowledge in data transformation services like SSIS, DTS, BCP and Bulk Insert

Proficiency in Backup and Recovery

Troubleshoot performance problems, fine-tuning of databases and Index Analysis

Powershell Scripting to report SQL Server health status

Experience on Data Center Servers

Handling memory configurations for SQL Server

Experience in batch processes, Import, Export, Backup, Database monitoring tools and application support

Linked Servers and DTS’s configuration between SQL Server and Oracle, MySQL, Foxpro, Excel and Text Plain data sources

24 X 7 Production database support experience

Experience in mentoring team members and writing databases documentation

Professional Experience

OMSASI - Telmex – IT and Operations Manager

12/2013 – Present

Architect Corporate Business Intelligence Applications; Coordinate Datawarehouse interactions to extract, transform and load information into the information database, Mentor and motivate team members to learn and implement new technologies.

Key projects:

Predictive analytics extracting and analyzing information to build integrated marketing campaigns

Interaction with telecommunications Mexican regulator, internal and external auditors, ensuring the information integrity, accurate reporting on KPI’s and mandates with strict confidentiality

Statistical analysis and predictive analytics development using Python to improve quality of service and design sales campaigns

Business Intelligence platform redesign implementing Tableau solution

DBA Hands-on role to install, manage and support SQL Server and MySQL databases

Dashboard development to deploy Financial, Sales and Operational Key Performance Indicators for decision-making of company stakeholders

Information Extraction and Analysis to build integrated marketing campaigns

Telefonos de Mexico SAB de CV – IT Manager /DBA (Hands-on)

02/2006 – 11/2013

Manage 24/7 systems operations; establish a system of policies and procedures to enhance the correct systems operations area, handle servers performance tuning and conduct regular systems and databases backups on Triara©DataCenter. Ensure technical and functional designs meet business requirements.

Key projects:

Operations management of technical supervision to secure a stable Information and Communications Infrastructure (ITIL) on Triara© Queretaro DataCenter

Definition of policies and procedures to keep servers updated and backed up, including windows and antivirus updates, and incremental, differential and total File Systems and Databases backups SQL Server and MySQL database modeling, implementation and support

Coauthoring of Information System SI©, copyright registration number 03-2009-051913551800-01, including different activities such as project management, implementation and application support

Information System SI© LATAM implementation and support for Financial Statements Reporting

Sharepoint business portal implementation leader in 288 shops for management decision making

Telefonos de Mexico SAB de CV – Senior systems engineer

9/1996 – 1/2006

Responsible for server, workstation and databases continuous operation.

Key projects:

Served as database administrator (DBA) in the completion of 2+ medium scale implementations, managing projects from business requirements analysis to solutions delivery and support

Argos© sales system development and implementation for vendor team support

Responsible for the installation, configuration, support and migration of 23 servers to Corporate Data Center

Coordination and hands on remote and in-site technical support to PC, Laptop and LAN of 420 final users

Administration of PBX (Private Brach Exchange) Meridian 1 Option 61 with 350 Digital Extensions

Staff member of monitoring process on ten digit migration of Mexican Digit Numbering Plan

Mexican Telecommunications Institute – Junior network administrator

09/1992 – 8/1996

LAN Administrator, providing final users in-site support, configuring printers and installing required software

Key projects:

Installation and support of Novell and Windows NT Network Servers

LAN & Internet service implementation

Structured cabling specification and installation coordinator

Visual interface programming in Borland C for agricultural applications

Administration of PBX (Private Brach Exchange) Meridian 1 Option 11 with 120 digital extensions

Education& Training

Data Science for Predictive Analysis; Bayes Forecast

01 / 2016

Strategic Planning, Customer Centricity and Data Mining Certified; ITAM

12 / 2011

Master of Business Administration; Tec de Monterrey

07 / 2004

New Business Development; IE Business School; Madrid

07 / 2003

Bachelor of Science, Electronics and Telecommunication Engineering; Instituto Politecnico Nacional

07 / 1993

Certified Training: SQL Server, Microsoft Windows Server, Web development, Reporting Services and Business Intelligence, VoIP, MPLS, Routers and IP Data Networks

Contact this candidate