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.
• 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) Sybase v4.2 * higher, Oracle 7 & higher, MS SQL server v1.0 (starting)

Networking/Operating Systems: Novell, Windows NT, LAN Server, Linux, Unix (Sun Solaris, AIX, HP-UX)

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

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Senior Application Specialist, Database Administrator

Responsibilities:

• Senior Application Analyst Database Administrator: Manages the administration of all the organizations database resources including local/primary and secondary/remote offices.
• High levels of support and troubleshooting RDBMS given the database behind the application. When allowed access complete understanding of all the tiers in the design of an application (e.g. from the database to web servers, application servers and any additional layer for the functioning of the application plus good business behavior. Maintaining inherited complex systems of SQL Servers and Oracle databases along with their particular scheduled jobs, backups/restores and typical maintenance tasks of already RDBMS systems working together.
• Understanding of high levels of Microsoft MS SQL Servers (from v2005 up)
• Integration of production and development environments, SQL and Oracle all the same
• Maintaining each RDBMS using their respective maintenance tools and for some 3 rd party tools, also including their form of replication (log-shipping/replication, data guard) in addition to daily maintenance and performance procedures (i.e. backups/restore using scripting & RMAN, job monitoring, system & database monitoring and health, system performance & utilization, etc…)
• Easily adapt to shell scripting as well as PL/SQL under Red Hat Linux.
• Typical database performance & tuning with or without 3 rd party tools.
• Started to design an integrated proactive monitoring environment, reactive mode kept on being the day to day dominant factor.
• Evaluated, installed, tested 3 rd party monitoring tool such as Solarwinds - DPA (database performance analyzer)
• Custom build procedures to support monitoring outside DPA for speed and convenience
• Setup basic and custom alerts from Solarwinds - DPA
• Started to put together a plan for upgrading databases (SQL and/or Oracle) to their latest possible version depending on the application vendor and affordable licensing.
• Relies on extensive experience and judgment to plan and accomplish goals
• Oversees and performs SQL server and Oracle Database installation, configuration, design and architecture
• Performs performance monitoring, troubleshooting, maintenance and tuning of SQL servers and Oracle Databases
• Works with System and application administrators on implementing best practices
• Oversees and performs profiling, monitoring, bottleneck detection, code and server optimization
• Performs organizing load and stress tests, analyzing the results and providing reports based on collected stats
• Oversees and performs the deployment of database change scripts provided by third party vendors or by myself

Confidential, Boulder, CO

System SQL Database Administrator

Responsibilities:

• Database Analyst with deep understanding of Microsoft business applications, MS SQL Server, and integrations for interfaces between various business systems, and a custom developed database application, like Covidien Vital Sync. Key leadership position, acting as a SME for software deployment, monitoring, and maintenance for the Remote Patient Monitoring Business.
• Develop methods for deploying and maintaining software around the globe
• 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/Training 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:

• Conducted EoSL (End of Serviceable Life) audits of all SQL Servers known within the entire BP organization (worldwide). This included Number of instances, databases, sizes, status, versions, etc… Especial access had to be granted to my profile to access all regions.
• 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

Responsibilities:

• 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.

Confidential, Houston, TX

Data Engineer III

• 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

Part-time / on-call SQL server DBA

• Joined this family of consultants to provide an on-call or part-time service to their clients .

Confidential, Houston, TX

Senior DBA/Database Group Leader

• Lead DBA role included: Review of current database used to launch eBanking software. Prepare documents and procedures for tutoring members in the DBA arena. Analyze feasibility of moving application to other RDBMSs
• 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

• Duties: 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.

Confidential, Houston, TX

Senior DBA/Interface Programmer and Network Admin

• Duties as Network Admin: Maintained Novell network for entire company (70nodes). Create new users, adding PCs, Config. PCs, Backups and Restores, File & Database servers hardware/software installations, cabling design and overview installations.
• Duties as Programmer: Developed a set of APIs to ease application interchange with Sybase, Oracle and/or SQL server RDBMS. Add any kind of new functionality required by Business rules into the database design.
• Duties as DBA: Create installation and maintenance procedures for each RDBMS in order to simplify client installation along with application. Administer Backups & Restore procedures. Tune and troubleshoot application using in-house standard set of DLL calls. Monitor indexes, storage and procedures for best performance via the application only. Analyze several RDBMS and third party tools to adhere to business development. Occasionally teach classes to clients in the best usage and maintenance procedures of the RDBMS.
• Install Sybase V4.2, V10, V11 and Oracle7 on NetWare, Solaris, and SQL server v1.0 on LAN server.
• Maintained RDBMS systems (Oracle, Sybase and SQL server) for development and testing of application performance. Perform backup and restoration from files and/or tapes.
• Install Netware on several file servers for clients.
• Developed and maintained a generic set of API libraries, in C & Assembly, to work transparently with Sybase Open Client (DBLIB) and Oracle Call Interface (OCI).
• Utilized features such as stored procedures, triggers, index, and segments.
• Evaluated Btrieve, Ctree, Raima and SQL Server V1.0 databases.
• Provide DBA consultation and training to the company’s clients.
• Installed Sybase V4.2, V10, V11 and Oracle7 on NetWare, Solaris, and SQL server v1.0 on LAN server.
• Maintained both RDBMS systems for development and testing of application performance. Backup and restoration from files and/or tapes.
• Installed Netware on several file servers for their clients.
• Developed and maintained a generic set of API libraries, in C & Assembly, to work transparently with Sybase Open Client (DBLIB) and Oracle Call Interface (OCI).
• Utilized features such as stored procedures, triggers, index, and segments.
• Evaluated Btrieve, Ctree, Raima and SQL Server V1.0 databases.
• Provided DBA consultation and training to the company’s clients.