SUMMARY:

• An Experienced IT professional with over 20+ years emphasis in Relational Database Management Systems (RDBMS).
• Mostly as production and application Database Administrator (DBA) in the areas of maintenance, monitoring, troubleshooting, storage capacity planning, database design, data analysis and modeling.
• Good strong technical problem solving skills, installations, configurations and consultations to major companies around the world.
• As a DBA, I started as developer then administrator of RDBMS systems such as Sybase, Oracle server and MS SQL Servers on their different platforms, networks and operating systems.
• I have developed various expertise on troubleshooting, performance, tuning, daily maintenance, backup/restore procedures, installations/upgrades and patches tailored to the business needs of each company.

FUNCTIONAL/SYSTEMS EXPERTISE:

• Strong technical problem - solving skills
• Solid approach for improving performance skills
• Database designs, performance tuning, and administration (High Availability solutions)
• Good background in client/server and tier(s) system architecture
• Hardware design specifications, maintenance, capacity sizing, database design for RDBMS and application optimization.
• Good customer service support (SLA) of production, development and testing environments
• Performed, tested and documented various approaches for backup/restore procedures
• Good communication, teaching and presentation skills

TECHNICAL SKILLS:

Programming Languages/Development Tools: C, SQL, PL/SQL, Native Assembly

Databases: Sybase, SQL server(s), Oracle 7 & 8, MS SQL server v1.0 (starting)

Networking/Operating Systems: Novell, Windows NT, LAN Server, Sun Solaris

Additional Specialties: Erwin and S-Designor data modelers, BMC, Quest

Hardware: Built and troubleshoot IBM PC compatibles, clones and brand name, MAC Apple

Spoken Languages: Fluent in Spanish and English

EXPERIENCE:

Confidential, Boulder, CO

System SQL Database Administrator

Responsibilities:

• Understanding of Microsoft business applications, MS SQL Server, and integrations for interfaces
• Database tuning efforts for optimal system performance.
• Remotely audit Customer’s hardware and software to comply with the Vital Sync application’s pre-requisites.
• Maintained, diagnosed and resolved customer’s SQL Components, SQL engine, SSRS, Replication, SQL Clusters, Backups/Restores, Optimization, Performance Tuning, Job maintenance, etc…
• Implemented/cloned SQL test environments.
• Comprehend, implement and recommended options for company’s use of SQL Replication.
• Make product performance/improvement recommendations which enhance adoption and keep pace with the industry.
• Troubleshoot customers’ production issues and solved them or escalated them as appropriate via VPN connections.
• Responsible for system documentation reflecting work completed on customer systems.
• Comprehend and implement new tools and technologies that compliment Remote Patient Monitoring (RPM) products.
• Acting as a Subject Matter Expert for the RPM Professional service team in the Database Domain.

Confidential, Houston, TX

SQL Database Administrator

Responsibilities:

• Migration of SQL Server databases mostly within same version and editions for all environments Tests and Production
• Analyzed and showed potential high gain of improvements within the SQL infrastructure.
• Started implementing the framework of an easier to manage and maintain alerting and notification system within the limit of their budget and time to implement.
• Noted types of standard changes needed to be in accordance to the Best Practices in the industry and infrastructure of the enterprise.
• Tutored, among many things, standards as much as time allowed for jobs, backups, installations, naming conventions in all areas, etc…

Confidential, Houston, TX

Database Architect

Responsibilities:

• Primary DBA for an in-house application using SQL Server as its database
• Deployment application code using TFS/VS mostly for SQL Server databases and some Informix. Some SQL troubleshooting was required prior to implementation night.
• Exposure/ to SCRUM methodology
• Monitoring 3rd party tools like SolarWinds and Idera analysis concluded that a different approach to the tools would be different to get a reactive not a proactive reaction from them. The goal was to monitor all flavors of RDBMS with SQL Server being the major participant.
• Adapted to in-house SQL monitoring for a number of SQL Servers, hard to manage due to lack of information/documentation.
• Participated in a design and architecture of a single (cumulative) notification alert process for backups, jobs, etc… of different RDBMS systems to facilitate the monitoring of such different database systems (SQL Server, Oracle, Informix).
• Applied Oracle’s quarterly releases (PSU & CPU).
• Tried to implement Patch/Maintenance Plans using OEM 12c Cloud Control Patch Plan (company’s rules prohibit such options).
• Basic understanding of IBM Informix, mainly when on-call (every 6 weeks), but able to practice when time allowed.
• Prepared upgrades and implemented a number migrations from SQL Server 2008R2 to 2012R2 or other versions across all environments (i.e. Dev, Test, Stage and Production)
• Adapted and maintained none standard ‘on-call’ scenarios presenting challenges created by developers.and application owners.
• Adjusted to an infrastructure were the DBAs had were not responsible for installations, upgrades or patching the SQL Server RDBMS. Monitoring was only at the database level, if issues at the Windows/SQL Server level arise and other team couldn’t quickly identify then we were called.
• Setup proactive configurations and/or solutions for SQL Server was reduced only to the DB level: set proactive system maintenance plans, scripts, local and/or remote performance counters, etc…

Confidential

Database Administrator

Responsibilities:

• Compared and correlate results from SQL Servers and databases with those queried in the Windows registry. Used a combination of jobs, sched. Tasks, T-SQL, SSIS, powershell, bcp-isql-osql-sqlcmd, etc…
• Wrote T-SQL scripts/batch for those regions where automation was allowed by the infrastructure (Americas, Europe, UK, Middle eastern countries, rest of the world)
• Wrote/test minor powershell scripts to remotely retrieve data from as fewer servers feasible and compare that data with the above, turned out PSv2 was against BP’s policy.
• All data collected was stored into a SQL Server database then merged relative data to a table to provide ease of analysis (to BP’s business analysts), decision and tracking for remediation and consolidation of the current inventory (close to 4300 databases collected so far over 300 instances)
• Authored the steps to follow for the different scenarios that were known to happen when execution phase begins.
• Prepared first implementation plans for the change control window (decommissions). Upgrades and migration were next to come
• Used AD (Active Directory) and other networking tools to help identify the region’s DBA groups within each server and also to request and obtain proper access to those servers.

Confidential

Database Administrator

Responsibilities:

• Daily work in resolution of Remedy incident tickets related to the databases supported.
• Daily support responding and resolving internal alert messages.
• Monitoring, troubleshooting, maintenance (including patching) of all databases on a daily basis.
• Monitoring, analysis and troubleshooting of daily backups when necessary.
• Re-wrote monitoring/maintenance reports from Unix into SQL Server HTML & SSRS emails
• Re-wrote legacy independent SQL stored procedures into generic versions (T-SQL)
• Centralized monitoring & maintenance of all SQL Servers into a single instance
• Created new SQL Server store procedures for added monitoring, maintenance and reporting also in HTML & SSRS email format
• Analyzed, planned, submitted and implemented change management requests for installing, patching, maintenance and upgrades on both SQL Server and Oracle.
• Implemented SSIS one-off loads of data files and/or Oracle tables into SQL Server tables to help in centralized reporting
• Tested feasibility to convert current DBA monitoring and maintenance alerts/reports into SSRS delivered email alerts.
• Responsible for SQL Servers and Oracle instances in the Americas geographic region (including Brazil).
• Databases: SQL 2K, 2K5, 2K8r2; Oracle 8i, 9i, 10g, 11g; Platforms: Solaris, Linux, Windows

Confidential

Database Specialist, SQL Server Support

Responsibilities:

• Software development company with emphasis in RDBMS systems (Oracle & MS SQL Server), tune and troubleshoot new database systems.
• Lead installation, configuration and troubleshooting of active/passive Windows 2003 Server Clustered and SQL Server 2005 with Clustering Service using a NAS storage device for the share databases.
• Troubleshoot and diagnosed in-house 3 tier application simulating a 911 Emergency service overseas and provided my manager with the findings.
• Provided technical support for deployment of SQL based applications in a high availability clustered environment after diagnosing and fixing a non-functioning SQL Server Cluster
• Assisted in their understanding, need and implementation of log shipping for reporting uses.
• Analyzed server, database and tables from results of stress testing simulating months and years worth of data.

Confidential

Production Support SQL Server and Oracle DBA

Responsibilities:

• Created an inventory of all RDBMS systems (MS SQL Server v7, v2000, v2005 & v2008, Oracle v10g) to comply with Federal mandate for financial institutions.
• Documentation of proposals to improve performance, create database security, implement, at least, a basic RDBMS infrastructure as well as a monitoring tool (in for all discovered databases systems).
• Created performance & tuning, backups/restore and maintenance plans implementations procedures for database environments up to 1.5 TB in size; on some SQL servers this proved to be challenging since the organization’s culture showed RDBMS are “owned” by project managers, thus hindering progress.
• Designed and planned new installations of MS SQL Servers under windows virtual environment VMWare High Availability.
• Consolidated, analyzed and supported databases and SQL Servers under VMWare virtualization.
• Solved DBA maintenance, monitoring, performance, ETL, file sizes, backup and restore problems in all RDBMS systems.
• Created and in other cases improved backups and maintenance jobs for SQL Server but applications and/or business rules prevented implementation of the traditional DBA basic roles and responsibilities.
• Performed normal daily duties and troubleshooting of a production SQL Server.
• Implementing any combination of these newest technologies via either automation Perl scripts or manual standard Oracle procedures (Resulting in the same outcome)
• Creating basic databases using most of applicable technologies already in implementation in HP.
• Creation of standby databases for mission critical applications; this implied the usage of Data Guard Environment and ‘new’ Log Miner logistics; also the usage of Cluster Ready Services (CRS), Oracle Service Control (SRVCTL), the improved Recovery Manager (RMAN).

Confidential, Austin, TX

DBA Contractor’ for Oracle, MS SQL Server and Sybase

Responsibilities:

• Primarily maintained a ‘business as usual’ policy on the Agency’s databases, fixed any immediate problem on a database(s) assigned for my support (Oracle 8i,9i,10g and MS SQL Server v6.5, v7,v2000 and v2005). Database environments ranged up to 800GB in size.
• Satisfied any requirements from either IBM or State Agency which involved relational databases.
• Started monitoring/supporting any RDBMS (Oracle, MS SQL server, etc…, any version & platforms) from the Agencies in any environment these databases where in (Windows, Unix any flavor, Novell Netware.
• Created, maintained and published different documents (versions & types: Word, Excel, etc…) for IBM’s database baseline, inventory and security on each Agencies RDBMS; including their platforms (or environment and database types and versions).
• Supported user/client community requests as good as possible mostly in the physical level of Database Administration and trying not cross into logical level as per IBM and Confidential contract.
• Performed several database restores and/or data migrations
• Prepare Databases for newer standards in order to facilitate movement to Data Center.

Confidential, Houston, TX

Data Engineer

Responsibilities:

• Became familiar with Oracle’s Parallel Server Option and then configured further installations.
• Created an in-house reporting growth/capacity planning trend tool to aid upper management in their monthly budget decisions.
• While performing day-to-day duties, served as lead/tutor/mentor for second level DBA(s).
• Planned, revised, tested and documented backup and recovery procedures for several RDBMS (Oracle and SQL server).
• Gathered and analyzed data to aid in the decisions that would create a healthy RDBMS system. Become more proactive instead of reactive, especially on RDBMS.
• Audited and standardized network of existing SQL Servers which had no former team or ownership (i.e. DBA team or Data Services team).
• Setup standards for On-Call pager/phone to be accessed by each RDBMS system; these included guarantying connectivity, clear messages, consistency of SQL messages /non-defaulted text, any possible calculations within message.
• Migrated Oracle databases from v7.4.1/Windows to v8i/AIX 32-bit
• Migrated SQL server databases from v6.5 to v2000 Enterprise (no data lost )
• Customize TSQL scripts to run as batch processes for loading dump data (ETL/DTS) from mainframe into flat tables of 2k+ columns and excess of 15GB data rows; then convert flat tables into some normalized version of SQL tables. Used fast bulk copy method.
• Migrated Oracle 8i DB from a stand-by IBM RISC 6000 to a fail-over HACMP configuration.
• Exposure and work with IBM Tivoli Monitoring tape backup library solution.
• Setup standards for both RDBMS (Oracle, SQL Server)in order to maintain consistency and database server transparency (i.e. configuration, architectural layout, naming conventions, installations, etc…).
• Installed and monitored red of DBMS with BMC’s Patrol and Sql*Dba. Prepared tailored reports within the tools provided by BMC’s software family.
• Performed all testing levels of Oracle 9i on an IBM AIX server.
• Database environments managed include databases over 2TB and versions from MS SQL v6.5 to v2005 and Oracle v7 to v9i.

Confidential, Houston, TX

SQL Server Systems DBA

Responsibilities:

• Troubleshoot possible causes for a MS Cluster server and SQL Cluster server crash.
• Re-install SQL server cluster, optimize it, test it and prepared a new backup strategy.
• Prepared scripts to move over data and users from temporary ‘prod’ server to final destination as requested by client.

Confidential, Houston, TX

Senior DBA / Developer

Responsibilities:

• Quickly analyzed a series of small SQL servers that support internal business rules.
• Familiarized with their CRM tool (Onyx) and most of the interactions with the tool (printing via template, printing labels, e-mailing, Web interface, etc…)
• Became rapidly familiar with XLS and VBA code using stored procedures as a source.
• Became familiar with newer ways of report writing (i.e. VBA, XLS, ADO code).
• Analyzed stored procedures to later modify them as business rules changed.
• Troubleshoot and monitored a couple of SQL servers v6.5 & 7.0 for performance and reliability.
• Became active in their team member procedural actions and lack of.
• Production support included overseas usage of the systems on 24X7 basis.

Confidential, Houston, Dallas, TX

Senior DBA, Consultant

Responsibilities:

• To create an audit of three applications and their databases. Include the current database status, growth capabilities/capacity planning (in years and volume), tuning and performance requirements and documentation of findings. Also implement new changes as requested by users or developers.
• Analyzed WEB Application and back - end database for production migration V6.5 to 7.0
• Analyzed and tune a Database/Data mart repository for supply planning.
• Analyze and redesigned or modeled database for Keyboard Internet connectivity.
• Coordinated work with Compaq s System DBAs in Oracle and SQL Server
• Provide quick solutions for migration, performance problems.

Confidential, Dallas, TX

Production Support Consultant for SQL Server

Responsibilities:

• Rotation support of on - call Worldwide Network of SQL server. As a senior member develop a series of documents and procedures to facilitate spool-up of other members. Analyze vast log information to determine areas of needed improvements.
• Provided 7x24 production supports for a worldwide SQL Server network.
• Analyzed and solved problems for the applications using SQL Server and its tools.
• Analyzed SQL Server outputs/errors and developed trends with their plan of action.
• Work with Sybase s Direct Connect in order to troubleshoot connectivity.
• Support backup/restore procedures for applications linking SQL Server and Oracle.
• Create and maintain optimized SQL Servers throughout the network.
• Performed trivial DBA duties such as Create Devices, Dumps, Grants, Etc
• Moved Databases to different SQL Servers and performed related tasks associated with moving databases

Confidential), Houston, TX

Server Technology Oracle & SQL Server DBA

Responsibilities:

• Responsible for writing PL/SQL code to add/modify application features as requested by user community.
• Provided support for the GOLD Call Center application.
• Develop ad-hoc reports in PL/SQL for call analysis.
• Develop/modify stored procedures and database interfaces using PL/SQL.
• Oracle8 Application DBA
• Lead DBA role duties plus coordination of tasks, specs. Declaration, data gathering, management and project progress decisions.
• Redesign the database model during ongoing development of the application.
• The new model tracked all table spaces needed/used, their assignments, sizes, locations.
• The model also recorded critical triggers, indexes, packages that were required before application launch.
• Perform tuning of the database and application queries as needed during development and testing phases.
• Coordinate changes and support with the production/systems DBA team.
• Administer Library of all Database Objects for consistency, clarity, documentation and report writing.
• Developed part of the PL/SQL library used by the application team.
• Created batch and scheduling jobs for daily loading and processing of the application.
• Provide daily support and maintenance during development and after production implementation (24X7 pre-prod).
• MS SQL Server 6.5 Application DBA
• Responsible for: Monitoring all databases on daily basis before and after loading business data. Recommended changes for improvements, reliability and/or performance, whichever applied best to user satisfaction. Provided 24x7x12 support for any issue involving databases/application supported. Train team members in all support activities so that rotation could be implemented.
• Redesign TIRS databases within the constraints of the application and installation policies.
• Maintain databases throughout the development of a repository of Intranet activity, driving a series of report writing applications.
• Provided support to application development, developing stored procedures, triggers, cursors, views, performance tuning of queries and databases.
• Provide daily support and maintenance to production applications and their databases assuring worldwide availability. Include monitoring batch jobs, scheduling jobs, and troubleshooting problems.
• Organized and implemented developer’s additions to production applications in order to keep consistency in the current environments (Change Management)
• Set up automatic SQL Server e-mailing/pager for critical areas during the daily loads.
• Redesigned and implemented a solution to integrate the changes to database tables, stored procedures and ASP scripts for faster and easier support.

Confidential, Houston, TX

Senior DBA/Database Group Leader

Responsibilities:

• Managed database developers and implemented coding standards for MS SQL Server 6.5.
• Evaluated and reverse engineered existing databases, and re-modeled tables.
• Wrote an application skeleton for the Internet with form linkage and database connectivity, addressing the requirements of SQL Server, Sybase, and Oracle.
• Study feasibility of incorporating Oracle into the business application.
• Contributed in the rapid development of an Internet based application using Cold Fusion and SQL Server (4 months working prototype)
• Set up automatic SQL Server e-mailing/pager for critical areas.

Confidential, Clear Lake, TX

Senior Oracle DBA

Responsibilities:

• Troubleshoot database for a daily system crash and suggest possible solutions.
• Analyze behavior of application while in development to tailor best practices.
• Tutor developer and users on maintenance and standard procedures for a database.
• Consulted as Oracle7 database administrator.
• Resolved RDBMS’ problems with the application and the rollback segments.
• Authored procedures for database backup and restore.
• Analyzed and resolved issues for a new application’s initial deployment.
• Maintained the database and monitored its growth and performance.