SUMMARY:

• Results oriented Database Administrator, AWS Certified Solutions Architect, 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 Database Migration Services (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 infrastructure architecture and design using IAM, EBS volume management, AMI’s, Route53, VPC, AWS Object Storage and CDN.
• Experienced in database migrations, clustering, performance tuning, data warehousing management, data architecture, design, development, configuration, integration, and implementations of MySQL, PostgreSQL, SQL Server 2016, 2014, 2012.
• Database administrator, responsible for managing and administering over 100, medium to large MS SQL Server and Oracle Database servers with the Confidential .
• 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 Availability Group and Failover Cluster high-availability configurations and log-shipping.
• Experienced, 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.
• Experienced with SharePoint 2010 and SharePoint 2013 Enterprise configurations and implementations with MSSQL Server 2012.
• Experienced in Oracle 11gR2, 10g, 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 with the Confidential ’s Probation Case Management Systems and Emergency response systems.
• 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.

TECHNICAL ADDENDUM:

Software: AWS Infrastructure /Azure Cloud, DBAAS, MS SQL Server 2016, 2012, 2008, 2005 all versions; AWS MySQL, PostgreSQL, Redshift and Aurora, SharePoint, Oracle RDBMS 12c, 11gR2, 10g, 10g Grid, 9i; DB Artisan, ER Studio; SQL Navigator, Toad; Erwin, SQL Navigator, TOAD, MS Visual Studio 2017, Virtual Box, VMWare, GitHub

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

Responsibilities:

• Courses in Introduction and Intermediate SQL and Oracle Database and SQL Programming
• Responsible for developing two course materials in SQL Programming for a Confidential
• Blended Type Courses with class materials available online using Blackboard and classes

Confidential, San Diego, CA

DevOps / DBA AWS Solutions

Responsibilities:

• Responsible for determining and assessing current on-premise databases with potential hybrid configuration and integration with AWS Cloud environment.
• Responsible for SQL scripting for database and data updates in the production environment.
• Responsible for assessing and determining status of the company’s disaster recovery (DR) plan and recommendations for effective implementation.

Confidential, San Diego, CA

Database Administrator

Responsibilities:

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

Confidential, San Diego, CA

Database Administrator AWS Solutions Architect

Responsibilities:

• 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.
• 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 infrastructure architecture and design using IAM, EBS volume management, AMI’s, Route53, VPC, AWS Object Storage, and CloudFormation.
• 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 Data Warehouse in Amazon’s Redshift, Quicksight, Glue, Athena, S3, EC2, RDS, Matillion, Tableau, Alteryx.

Confidential, San Diego

Database Administrator and Project Management

Responsibilities:

• 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 Confidential .
• 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 Confidential .
• 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.
• Collaborated with Business Leads, Business Analysts, Systems Engineers, DBA’s, Programmers, and other Project Managers from HP and the Confidential point of contacts, for the migration and integration of IT and MIS Systems, for the Confidential .
• Responsible for the design, development, testing, integration, implementation of the LAC system, designed to allow the Confidential, to effectively manage their resources on the displacement of Confidential residents during the 2007 emergency fires and evacuations.

Confidential, San Diego, CA

Database Administrator and Project Management

Responsibilities:

• Database administrator, responsible for managing and administering over 30, medium to large MS SQL Server and Oracle Database servers for the Confidential .
• DBA Technical Lead during the 2006 database migrations involving all RDBMS systems for the Confidential .
• 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, conversion 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 Confidential .
• 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 Confidential .
• Responsible for migration installation of several Unix and Window based Oracle databases, (i.e., 9i, 10g), for the Confidential ’s ARCC system for Legato TTC, Millennium database for the County Library and databases for the County website and Oracle Applications Portal.
• Responsible for the design, development, testing, integration, implementation of the LAC system, designed to allow the Confidential, to effectively manage their resources on the displacement of Confidential residents during the 2007 emergency fires and evacuations.

Confidential, San Diego, CA

Senior Database Administrator

Responsibilities:

• 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 Confidential ’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

Responsibilities:

• Performed Project Management and Oracle database administration support for the Ri-PS005 Laboratory Information Management Systems (LIMS) Migration and Integration Project with cost savings of over $3.5M, for the Confidential merger and acquisition (M&A).
• Performed database systems integration, database migration, archival, reconfiguration, development, systems testing, implementation, and decommissioning of the Legacy VAX/VMS LIM S, compliant with GxP systems and to Confidential ’s 21 CFR Part 11 requirements.
• Performed migration and integration utilizing validated processes and procedures of the Confidential validated SQL *LIMS™ developed by Applied Biosystems, running on HP UNIX OS and Oracle 8.1.7 RDBMS.
• Directed, managed, coordinated and supported Confidential IT and Confidential IT in the successful migration, integration, archival, and decommissioning of Confidential ’s GxP LIMS and Mi SQL*LIMS, from Confidential ’s Data Center, in Skokie, IL.
• Established a formal validated and documented the LIMS migration, development, testing, implementation and integration process, compliant with GxP systems and Confidential 21 CFR Part 11 requirements, for the migration and integration of the Confidential validated LIMS .
• Authored project documents for the Confidential 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

Responsibilities:

• 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 schema, running on Sun Solaris 8 Unix resulting in efficient and effective management of large Oracle databases.
• 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.
• 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.