SUMMARY:

• Results oriented Database Administrator with emphasis in AWS, solutions architecture, infrastructure, security, networking and database implementations of large scale 24/7, clustered MSSQL Servers and MySQL databases into RDS. EC2/RDS snapshot migrations and upgrades into production, test and development environments. Implemented cross - region (DR) disaster recovery using CloudBasic and DMS. Experienced in AWS architecture, design, development, deployment and maintenance of critical environments in the Amazon Web Service (AWS) Cloud for public facing customers. Experienced in implementing DW/BI systems using AWS Redshift, Matillion ELT/ETL, S3, Alteryx, and Tableau data visualization. Experienced in AWS security, solutions architecture and design, database migrations, clustering, performance tuning, data warehousing management, data architecture, design, development, configuration, integration, and implementations of MySQL, PostgreSQL, SQL Server 2016, 2014, 2012. Implemented MSSQL Server Always-On Availability Groups, Failover Cluster Instance and 2008R2 log-shipping and mirrored databases. Experienced in Oracle 12c, 11gR2, and 10g.
• Over 10 years of experience, in database administration and architecture with expertise in validated systems, Oracle 11g, 10g, 9i, relational databases in both UNIX and Windows platforms, management design, development, administration, migration, integration, backup and recovery warehousing, project management, process management, and knowledge management, for business intelligence, scientific data, R&D, and IT.
• Database administrator, responsible for managing and administering over 100 medium to large MS SQL Server and Oracle Database servers with the County of San Diego.
• Responsible for the architecture design, administration, management, development, virtualization, migration, upgrades, integration, implementation, and management of several databases on multiple projects, involving implementation of new MS SQL Server 2012 Always-On, 2008R2 mirroring
• Experienced with SharePoint 2010 and SharePoint 2013 Enterprise environments and production implementations through a formal SDLC. Oracle 11gR2, 10g, 9i and 8.1.7 Relational Database Management Systems (RDBMS) running on Sun Solaris OS 5.8, 5.9 and Solaris 10 - involved in planning the stages of the lifecycle of database design, development, administration, optimization, migration, backup and recovery.
• Integrated and implemented Storage Area Networks (SAN) using various RAID Array configurations, switches, and hubs connected over high-speed optical network dedicated to task of storing and protecting Oracle and SQL Server databases and application servers.
• Developed and provided business analysis, project plans documentations, established project goals and objectives with emphasis on database and information system needs that supported corporate data model, leading to a suitable database management system (DBMS), for database applications and development.
• Experienced in database architecture, administration, design, development , and management of Relational Database Management Systems (DBMS ) and Resources .
• Defined scope of database and information system needed that supported corporate data models and DBMS requirements .
• Leadership and creative problem solving skills in both strategic and tactical areas in database management, systems design, development, integration, migration, implementation and training.
• 6 years as a Confidential Instructor - 3 courses in both SQL Server and Oracle RDBMS and SQL Programming.
• Member of Confidential Advisory Goal Oracle and SQL Server

TECHNICAL SKILLS:

Programming Languages: TSQL; PL/SQL, XML, HTML, Python, Node.js, C++

Operating Systems: Windows Server 2016, 2012, 2008, Windows 10, 8, 7, XP, Sun Solaris 10, 9 UNIX, HP UNIX, Linux Ubuntu, Redhat, Oracle

PROFESSIONAL EXPERIENCE:

Confidential, San Diego, CA

Instructor SQL Database Administration and Programming

• 6 Years as an Instructor at the Confidntial University - Courses in Introduction and Intermediate SQL and Oracle Database and SQL Programming
• Responsible for developing two course materials in SQL Programming for a Confidential Certification Program - Blended Type Courses with class materials available online using Blackboard and classes

Confidential, San Diego, CA

Database Administrator AWS Solutions

• Responsible for performance tuning, management, administration of the company’s production MySQL RDS databases in AWS.

Confidential

• Responsible for large scale global IT DevOPS database architectural integrations, design, databases migrations, security, high availability, performance tuning, disaster recovery and data warehouse on cloud based systems in Amazon’s AWS as well as in Microsoft’s Azure.
• Project Manager and Technical Lead in all AWS database upgrades, migrations, implementations of production, development and test environments.
• Familiar with using Elasticache, memcache and Redis in AWS.
• Sr. DBA responsible for providing database services, project management, architecture, security, design, performance tuning, migrations, backup and recovery, high availability, disaster recovery, and data warehousing using MySQL, MSSQL Servers, Oracle, PostgreSQL in Redshift, AWS Athena, Quicksight, Glue, Shield, DMS, DynamoDB, S3, and EC2 in (e.g. Windows and UNIX platforms)
• MySQL MSSQL Server database migrations in AWS/DMS or using native BCP, security, consolidation, integration, test and validation of IT and MIS systems, applications, and DataWarehouse in Amazon’s Redshift, Quicksight, Glue, Athena, S3, EC2, RDS, Matillion, Tableau, Alteryx.

Confidential

Database Administrator and Project Management

• Experienced in large scale global IT integration, for mergers and acquisitions.
• Project Lead and Sr. DBA responsible for providing database services, project management (e.g. Windows and UNIX platforms), in the migration, consolidation, integration, test and validation of IT and MIS systems, applications, Oracle 10g databases and 11gR2, and MS SQL 2012, 2008 R2 Server databases, for the County of San Diego.
• Responsible for analysis and fact finding of IT and MIS systems and all related Oracle and MS SQL Server databases, information gathering, and documentation of Business Systems, system applications, database applications, databases, hardware and software requirements, for migration, integration, consolidation, administration, upgrades, and validation of all Oracle 11gR2, 10g and MS SQL Server 2008, and 2005 databases, for the County of San Diego.
• Experienced in database instance creation and deployment, database development, maintenance and customer support.
• Experienced in database resource management administration, design, development, implementation, conversion of SQL Server 2000 and 2005 DTS Packages to SQL Server 2008 R2 SSIS Packages, SSRS, Analysis Services, TDE Encryptions, MS clustering and MS SQL Server Database Kerberos/SSL configurations.
• Responsible for identifying, mapping, analysis, migration, test, integration, implementation, database administration and support of the County of San Diego’s PCMS, ARCC, CSG, HHSA, CSG and FGGG Oracle and SQL server databases, and systems, for business processes and procedures.
• Responsible for migration installation of several Unix and Window based Oracle databases, (i.e., 9i, 10g), for the County of San Diego’s ARCC system for Legato TTC, Millennium database for the County Library and databases for the County website and Oracle Applications Portal .
• Collaborated with Business Leads, Business Analysts, Systems Engineers, DBA’s, Programmers, and other Project Managers from HP and the County of San Diego point of contacts, for the migration and integration of IT and MIS Systems, for the county of San Diego.
• Responsible for the design, development, testing, integration, implementation of the LAC system, designed to allow the County of San Diego, to effectively manage their resources on the displacement of County of San Diego residents during the 2007 emergency fires and evacuations.

Confidential San Diego, CA

Database Administrator and Project Management

• Database administrator, responsible for managing and administering over 30 medium to large MS SQL Server and Oracle Database servers for the County of San Diego.
• DBA Technical Lead during the 2006 database migrations involving all RDBMS systems for the County of San Diego.
• Responsible for the architecture design, development, virtualization, migration, integration, implementation, and management of multiple projects involving implementation of new MS SQL Server 2008, 2005, 2000, 7.0 Enterprise Edition and Standard Editions through a formal SDLC.
• Experienced in database instance creation and deployment, database development, maintenance and customer support.
• Experienced in database administration, design, development, implementation, convertion of SQL Server 2000, 2005 and 2008 DTS Packages to SSIS Packages, SSRS, Analysis Services, TDE Encryptions, clustering and MS SQL Server Database Kerberos configurations.
• Experienced in large scale global IT integration, for mergers and acquisitions.
• Project Lead and Sr. DBA responsible for providing database services, project management(e.g. Windows and UNIX platforms), in the migration, consolidation, integration, test and validation of IT and MIS systems, applications, Oracle 8i, 9i and 10g databases, and MS SQL Server databases, for the County of San Diego.
• Responsible for analysis and fact finding of IT and MIS systems and all related Oracle and MS SQL Server databases, information gathering, and documentation of Business Systems, system applications, database applications, databases, hardware and software requirements, for migration, integration, consolidation, administration, upgrades, and validation of all Oracle 10g, 9i, 8i and MS SQL Server 2008, 2005, 2000, 7, databases, for the County of San Diego.
• Responsible for identifying, mapping, analysis, migration, test, integration, implementation, database administration and support of the County of San Diego’s PCMS, ARCC, CSG, HHSA, CSG and FGGG Oracle and SQL server databases, and systems, for business processes and procedures.
• Responsible for migration installation of several Unix and Window based Oracle databases, (i.e., 9i, 10g), for the County of San Diego’s ARCC system for Legato TTC, Millennium database for the County Library and databases for the County website and Oracle Applications Portal .
• Collaborated with Business Leads, Business Analysts, Systems Engineers, DBA’s, Programmers, and other Project Managers from EDS, CSC, Northrop Grumman, BearingPoint, and the County of San Diego point of contacts, for the migration and integration of IT and MIS Systems, for the county of San Diego.
• Responsible for the design, development, testing, integration, implementation of the LAC system, designed to allow the County of San Diego, to effectively manage their resources on the displacement of County of San Diego residents during the 2007 emergency fires and evacuations.

Confidential, San Diego, CA

Senior Database Administrator Contractor

• Performed Oracle 10g, 9i, 8i database management, administration, consolidation, migration, testing, validation, integration and implementation, utilizing validated Oracle Flexible Architecture (OFA).
• Mapped, identified, and performed troubleshooting of databases critical, for Sequenom’s business processes and procedures.
• Performed database administration, documentation, and management of the company’s LIMS and data warehouse systems running on Sun UNIX and Windows OS environments utilizing Oracle 10g, 9i, and 8.1.7.4 RDBMS.
• Performed LIMS data and database troubleshooting, testing, backup and recovery of critical data needed, for the company’s R&D.
• Performed Backup and Recovery procedures, for all of the company’s production and development MS SQL Server 2005 and 2000 databases.
• Provided needed documentation of all production and development Oracle and SQL Server databases in compliance with SOX requirements.

Confidential, San Diego, CA

Senior DBA Architect Project Technical Lead

• Provided Confidential with Project Management and Consulting Support for the Ri-PS005 Laboratory Information Management Systems (LIMS) Migration and Integration Project with cost savings of over $3.5M, for the Pfizer/Pharmacia merger and acquisition (M&A).
• Performed project management, database systems integration, data migration, archival, relocation, reconfiguration, development, systems testing, implementation, and decommissioning of the Legacy VAX/VMS LIM S, compliant with GxP systems and to FDA’s 21 CFR Part 11 requirements.
• Performed migration and integration utilizing validated processes and procedures of the FDA validated SQL *LIMS™ developed by Applied Biosystems, running on HP UNIX OS and Oracle 8.1.7 RDBMS.
• Directed, managed, coordinated and supported Pfizer IT and Pharmacia IT in the successful migration, integration, archival, and decommissioning of Pharmacia’s GxP LIMS and Mi SQL*LIMS, from Pharmacia’s Data Center, in Skokie, IL.
• Successfully migrated and integrated the Nerviano GxP Oracle based SQL*LIMS from Nerviano, Italy, into Pfizer’s Data Center in Groton, CT, and in Pfizer’s MOPS Data Center, in New Jersey, respectively.
• Established a formal validated and documented the LIMS migration, development, testing, implementation and integration process, compliant with GxP systems and FDA 21 CFR Part 11 requirements, for the migration and integration of the Pfizer/Pharmacia FDA validated LIMS .
• Authored project documents for the Pfizer Ri-PS005 LIMS Migration Project, (i.e., Requirements Documents, Requirements Matrix, Design, Test Plans, Test Procedures, and summary Documents, Installation Qualifications, and Service Level Agreements). Performed operational readiness and verification reviews of the GxP LIMS systems.

Confidential, San Diego, CA

Senior Database Administrator Manager

• Managed a team of database administrators and consultants. Performed database administration, maintenance, monitoring, backup and recovery of the company’s MS SQL Server 2000 used for the company’s Great Plains accounting and financial services.
• Mapped the data structures and data flow of the company’s drug discovery process end to end from Molecular Biology, Protein Chemistry, Crystallography, Computational Biology, SAS and Drug Discovery. Improved the efficiency of solving protein structures with Crystallography from several years to less than six months.
• Designed, developed, administered, integrated, and implemented fully optimized large scale, secure, multiple Oracle 9i and 8.1.7 production and development databases and data warehousing schemas, running on Sun Solaris 8 Unix resulting in efficient and effective management of several terabytes of scientific data and images generated throughout Confidential drug discovery process pipeline.
• Designed, developed and implemented robust, high available Clustered Oracle 8.1.7 RDBMS running on Windows 2000 Advanced Server Compaq Intel systems and Storage Works SAN devices using various RAID Array configurations, providing 24/7 support reducing expected downtime for large database and data warehousing transactions and high volume traffic generated by the automated robotics and imaging systems.
• Provided clear directions and expectations for the DBMS team by improved and well documented database policies, procedures, standards and Service Level Agreements (SLA), used for the company scientific Oracle database management systems (DBMS) and resources website providing immediate database request status updates throughout the company.
• Managed and led the DBMS team in the design, development, federation and integration of the production Oracle 8.1.7 scientific database systems, architecture and strategic plan aligned with corporate strategy and operating goals.
• Coordinated efforts to ensure the successful development, migration, backup, disaster recovery, configuration management and implementation of specific scientific database applications into production.

Confidential, San Diego, CA

Senior Database Administrator

• Designed, developed, implemented large scale multiple Clustered SQL Server 7 databases and multiple MS SQL database servers located at a co-location in AboveNet in San Jose. This is a B2B and CRM, commercial web site using Microsoft technologies, Active Server Pages (ASP) database driven web site, which enabled automobile dealerships to create online direct mail and email promotions to their specific customer database and or available dealer prospect database.
• Designed, developed, and managed and maintained the company’s SQL Server 7 databases for high availability, scalability, and fault tolerance, using the latest Compaq 8500R, DL350, Photon Servers, Compaq StorageWorks, and running on Microsoft’s Windows NT 4 Enterprise Edition Clustering, SQL Server 7 Enterprise Edition resulted in very minimal system downtime.
• Responsible for System Design Physical and Logical, Optimization and Configuration, Integration, Installation and Implementation of SQL Server 7 Clustering, and Windows NT 4 Clustering resulting in a very efficient and effective database transaction loads accommodating large internet traffic generated by auto dealerships across the country.