David Mantecon Email & Phone Number

Naples, Florida Area

Naples, Florida Area

* Designed and implemented the Physical and Logical layout of the SAN storage array.* Set overall performance standards, priorities for one or more database professionals to operational goals.* Install & manage several MS SQL Server 2008 R2 Databases.* Monitored database load and work closely with development teams to assist the SQL tuning of procedures, triggers, and indexes.* Batch job processing, scheduling, upgrading, and applying patches on the databases.* Performance tuning and troubleshooting, Disc fragmentation, and schedule jobs, Real-time Monitoring of the Database Servers, and data clean up. * Implement an operational data store as first step for a data warehouse.

Naples, Florida Area

* Installs, diagnoses, troubleshoots, and repairs all computer systems hardware and software including Microsoft Windows, network and stand-alone application software on stand-alone computers and all related technology equipment.* Utilizes network utilities (IPConfig, Ping, Traceroute, etc.) to troubleshoot basic network connectivity issues.* Maintains virus protection software on all workstations and client systems.* Accesses, inputs and retrieves information and data from a computer.* Performs regular maintenance of all personal computers and related systems including regular reimaging of personal computers, software updates, systems optimization.* Regularly works with teams to install, maintain, and repair network technology equipment throughout the District.

Naples, Florida Area

Providing a complete Infrastructure re-design and re-configuration for Pain Management Center of Naples (PMC), and Advanced Gastroenterology of Naples (AGN). Afterwards, I will be doing a complete re-design of their web presence www.naplesgastro.com to include state-of-the-art web technologies.Finished working on a project of physical and personal security; which includes wired and wireless systems. The system is monitored by a Windows 2008 server, running MS SQL Server 2008.Previously, worked on a project for a startup construction company to design & implement a complete IT infrastructure. The design incorporated high-availability, performance enhancements, scalability and efficiency.

* Define and direct company’s activities with database administration, ETL processes, automation of production jobs and reports, and data warehouse.* Establish and implemented the physical/logical layout, operational tactics for policies, strategies, and best practices of the Oracle 10g & SQL Server 2008 infrastructure for optimal performance.* Performance tuning, troubleshooting, conduct regular system backups, Disc fragmentation, schedule jobs using OEM, real-time monitoring, and data clean up of the database servers.* Served as DBA or project lead in the completion of 100+ medium- to large-scale implementations; managing projects from business requirements analysis to solutions delivery and support.* Set overall performance standards, priorities for one or more database professionals to operational goals.* Establish and monitor budget within approval set by CIO or other members of executive management. * Work closely with development team to assist in the SQL tuning of procedures, triggers, and indexes.* Designed and configured Oracle 11g w/RAC & SQL Server 2008 servers with replication in a development and test environments.

* Designed and implemented the Physical and Logical layout of the IBM FasT700 SAN storage array.* Set overall performance standards, priorities for one or more database professionals to operational goals.* Installed & managed Oracle Databases (8.1.7(8i)), and several MS SQL Server 2000 Databases.* Hot and cold backups of production databases, and Running DBV on Datafiles.* Monitored database load and work closely with development teams to assist the SQL tuning of procedures, triggers, and indexes.* Establish and monitor budget within approval set by CIO or other members of executive management. * Batch job processing, scheduling, upgrading, and applying patches on the databases.* Performance tuning and troubleshooting, Disc fragmentation, and schedule jobs using svrmgrl, OEM and Real-time Monitoring of the Database Servers and data clean up. * Implemented an operational data store as first step for a data warehouse.

* Manage, recruit, and coordinate priorities for one or more database professionals to operational goals.* Install & manage seven Oracle Database (8.0.5-8.1.7(8i)), one Sybase Database (over a terabyte of data), and five MS SQL Server Databases (7-2000).* Hot and cold backup using UNIX shell scripts to monitor backups, data loads and online support of production databases.* Monitor database load, administer changes to load control files, and work closely with development teams to assist the SQL tuning of procedures, triggers, and indexes.* Batch job processing, scheduling, upgrading, and applying patches on the databases.* Performance tuning and troubleshooting, Disc fragmentation, and schedule jobs using svrmgrl, OEM and Real-time Monitoring of the Database Servers and data clean up. * Implemented an operational data store as first step for a data warehouse which will gather data from Sybase and MS SQL Server using Oracle Transparent Gateways.

* Manage, recruit, train, coordinate, and mentor 15+ web developers and database professionals.* Project Management, Cost to salaries ratios, and implemented the Capability Maturity Model.* Managed Oracle Database versions 8.0.4 to 8.1.6(8i).* Hot and cold backup of databases; wrote UNIX shell scripts to monitor backups and data loads.* Monitored UNIX scripts to use IBM AIX clustering for seamless failover. * Data clean-up and online support of production databases.* Monitor database load and administer changes to load control file and work closely with development teams to assist the SQL tuning of procedures, triggers, and indexes.* Batch job processing, scheduling and production support, upgrading and applying patches on the databases.* Performance tuning and troubleshooting, Disc fragmentation, and schedule jobs using svrmgrl and OEM and Real-time Monitoring of the Database Servers and all other DBA functions.* Actively involved in the design, architecture and writing of web applications in Java using JBuilder3.* Configured and Implemented the Integration of Oracle Production data to MS SQLServer Accounting package database to be used for seamless accounting procedures.

* Manage Oracle Database version 8.0.4 including writing stored procedures, Backup and recovery of databases, tuning and troubleshooting, database design, modeling and implementation of new application systems, and Running DBV on all Datafiles. * Hot and cold backup of databases wrote UNIX shell scripts to monitor backups and data loads. * Data clean-up and online support of production databases. * Monitor database load and administer changes to load control file and work closely with development teams to assist the SQL tuning of procedures, triggers, and indexes. * Batch job processing, scheduling and production support, upgrading and applying patches on the databases. * Performance tuning, Disc fragmentation, and schedule jobs using svrmgrl and OEM and Real-time Monitoring of the Database Servers and all other DBA functions. * Implementation of 2 "Standby Database" Servers, including UNIX shell scripts for unattended failure recovery. * Install & manage Solaris UNIX servers, ranging from 70 to 100 users, and Windows NT servers & 50 Windows95&NT clients. Write numerous applications in Developer/2000. * Assemble numerous Solaris 2.6 (SPARC & INTEL) servers from scratch, including OS and Database installation of versions ranging from 6 to 8.0.4.3.

* Manage 5 SCO UNIX servers, ranging from 3.4.2 - 5.0.4, Main SCO Unix server range up to 140 users, and 3 WindowsNT servers & 20 Windows95&NT clients, Hubs, Digiboards, Modems, & CSU/DSU Units. * Assemble numerous SCO, WindowsNT servers & Windows95 clients from scratch, including OS installation, Design, Build, & Manage Oracle Database version 8.0.4. * DBA functions in adding users, writing stored procedures, "Cold" & “Hot" Backups, DBV on all Datafiles, and Implement a "Standby Database", Restore from tape backups and recover the database. * Write numerous applications in JAM, Foxplus, Informix, and Developer/2000 & Lotus 1-2-3.

Aa, Accounting And Business Administration

Bachelor Of Science (Bs), Computer Science