OBJECTIVE

• Secure an opportunity within an organization where I can offer my 21+ years of Database Administrator, System Architect, Cloud Architect, Project Management, Vender relations, within IT experience and leadership skills to help achieve its growth and cost - saving objectives.

SUMMARY

• 21 plus years of experience as an DBA, working in Production, DEV, Test, QA, and in Beta Test Shops and on the Bleeding Edge.
• System & Cloud Architect for design and creation of environments for private and public clouds. Collaborate with Stakeholders, business representatives, and subject matter experts to design IT systems. Manage and secure IT assets and frequently update them to meet changing demands of the business.
• Project Management and Agile/Scrum trained for Enterprise Architect role.
• Database versions; Oracle 12c, 11g, 10g, 9i, 8i, 7, MySQL 5.0.51a to 5.6.22, Maria DB, PostgreSQL 9.3.,MS SQL Server 2008 R2, 2012, 2014, NoSQL DBs like MongoDB, Dynamo DB, AWS’s Redshift, AWS RDS services and Beta Test with AWS Aurora, and Cassandra.
• Big Data - evaluation of Informatica software suite, and Oracle 11g Options
• 21 plus years of SQL syntax command line use within all aspects of database work, proof reading and checking syntax coding for developers, and coding troubleshooting.
• Grid Control, ASM, CRS, OEM, RAC, RMAN, SQL*(Plus, Net, Loader, PL/SQL), Export/Import, Data Pump, Standby/Data Guard, Mysql dump, Mysql dbexport, Linux, Solaris 10, Unix, Windows and AWS Amazon Cloud services.
• Databases and Apps on VMware VMs and OVMs, using NetApp Flex cloning process, and also on ZFS Zones on (Sparc), as well as on AWS Amazon Virtue hosts.
• Support E-Business Suit - Financials, Portico Healthcare App, home grown Apps, Data Aggregation, Confidential financial Apps.
• Monitoring Tools - Grid Control, OEM, Quest (Spot Light, SQL Navigator, Toad) MySQL Monitor with Agents, Tripwire, MySQL Workbench., AWS Amazon monitoring services, as well as vNOC, Cloudfront, New Relic, Cloudwatch monitoring software.
• Productive and self sufficient, able to learn and apply skills independently, develop and implement processes for cost saving measures. Able to investigate new technologies, evaluate them, and make recommendations on their effective usefulness to the company, as well as implement them.
• An effective and driven team member comfortable with leading and mentoring others, collaborating or working independently. Strong problem solving, decision-making, analytical abilities, and design cloud environments. Strong vendor relations management skills.
• Team leader of many special projects, effective team manager and director of wide level projects, keeping team on track to meet SLAs. Very effective Project Manager.
• Utilized Explain Plan, tk prof, AWR, and other monitoring tools to assist in the identification of non-performing database transactions and recommended changes to code and/or database objects to remediate, resulting in X performance gain.
• Interfaced closely with Developers and Program Managers to assess the database storage needs at proposed and ongoing projects, along with database total environment design for On Premises or In Cloud.
• Managed Vendor relations and setup partnerships with Oracle, HP, VMWare, SUSE, Red Hat, Jaspersoft BI, Talend and Microsoft.
• Performed system analysis, and capacity planning required supporting the low latency, high availability requirements of BCF/GSI OLTP /AWS Cloud Services for mission critical systems.
• Design total systems needed to migrate Confidential from SUN/SPARC on Solaris 10 64 bit to HP Blades on SUSE/Red Hat Lunix OS, with HP 3 PAR network storage.
• Recommended partitioning strategies through which the historical transactions produced by the system could still be available as needed but without impacting performance of the high-use data being accessed for current transactions.
• Supported development by Developers in environments using; OLTP, EDI, XML, C, C++, Java, J2EE, JDev, Oracle Forms 6.1, Python 2-3, Perl, and E-Commerce.
• Used shell scripting; C, Korn, BSH shell and Crontab.
• Team Lead responsible for implementing the full life cycle of database design and development with physical and logical data modeling.
• Team Lead for customer design of Database Cloud environment from a Land environment, with key attention to High Availability and performance.
• Planned and designed of Disaster Recovery site for prior employers and customers.
• Set-up, design and plan for network wide setup of RAC clusters for production, UAT, DEV, QA and SUP. Planned and designed Multi Tenant approach for application to control database sprawl.
• SQL server 2012, PostgreSQL 9.3, and MY SQL 5.0 to 5.6.14 on VMs / ZFS Zones using Solaris 10 and various flavors of Linux or Windows Servers.
• SOA support and tailor design such as LAMP stack for customer in the AWS Cloud.
• SaaS support and design of GSI Web services Apps, and Portico Sys Medical Apps.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Administrator / System & Cloud Architect

Responsibilities:

• Freelance Confidential services, short term IT projects for multiple different clients.
• Troubleshooting and Support services for environments, systems, and applications within both Local Hybrid Clouds and AWS Hosted Public Cloud.
• Design / Redesign environments and systems with a focus on complete systems both Local Hybrid environments and AWS Hosted Public cloud environments.
• Setup and Support for Backups and DR services and plans for environments future growth and expansion, including expansion into AWS Hosted Public Cloud.
• Database work for; Oracle, MySQL, SQL Server 2008, 2012, and AWS environments within the Public Cloud databases using EC2 (Bring your Own license) and RDS databases.
• Training and Documentation of environments, systems, and applications for best practices for their use and support purposes for client’s knowledge.

Confidential

Sr. Database Engineer(DBA) / System & Cloud Architect

Responsibilities:

• Design the whole Plan for the project to move an On Premises Application into the AWS Cloud, from AIX/Unix 12c Rel. 1 (12.1.0.2.0 ) Enterprise Edition to RHEL 6.6 Linux 12c Rel. 1 (12.1.0.2.0 ) Enterprise Edition.
• Design the AWS environment for SIT, QA, and Production as single instance databases with Data Guard for DR. One DG for QA in the same availability zone, and two DG for Production with one in the same availability zone and another in a different availability zone. All DG databases are Physical Data Guard databases.
• Aid in design of an automation process using Puppet, to build future AWS Oracle servers using a Golden AMI (Thin client set, RHEL 6.6 Linux), Oracle Response file to build new Oracle Databases (passing a parameter to define the new database name), and a script to apply Customer specific MBS controls).
• Design Monitoring using; AWS Console, Tripwire, and Oracle OEM.

Confidential

Sr. Database Engineer(DBA) / Systems & Cloud Architect

Responsibilities:

• Support company’s Databases in the MHE environment such as; Oracle (12c, 11g, 10g), MySQL (5.5x, 5.6x) Mark Logic (4.0, 6.0), SQL Server (2008 R2, 2012, 2014), and setup and support AWS RDS databases (Oracle, MySQL, and SQL Server).
• Database environment planning, design, migrate company data around their land systems to both MHE and the Amazon hosted Cloud solutions, upgrade and patch databases to latest version for the specific database.
• Performance tuning, troubleshooting, and design of new project databases and support existing company database to aid in making them better performing and designed more effectively with greater attention to High Availability for the Cloud.
• Database Operations Team Lead, Project and Cloud Architect Design for all projects, and mentoring Database Administrators within Operations staff, Tier 3 support.

Confidential

Lead Database Administrator / Systems & Cloud Architect

Responsibilities:

• Support customer’s Databases in the AWS Amazon Cloud environment such as; Oracle (12c, 11g, 10g), MySQL (5.5x, 5.6x) PostgreSQL (9.3), SQL Server (2008 R2, 2012, 2014), NoSQL DBs (MongoDB/DynamoDB), Redshift, and Beta tested AWS Aurora, and Cassandra.
• Database environment design, onboard, migrate customers data from their land systems to the Amazon hosted Cloud solutions, upgrade databases to latest version for the specific database.
• Performance tuning, troubleshooting, and design of customer databases to aid in making them better performing and designed more effectively with greater attention to High Availability for the Cloud.
• Database Team Lead, Cloud Architect Design, and mentoring engineering staff, on-boarding/ supporting 85+ customers into the AWS cloud.

Confidential

Lead Database Administrator/ Systems Architect/ Project Manager

Responsibilities:

• Director of Database services
• Redesigned the Confidential company infrastructure from SUN-SPARC/Solaris 10 x86-64bit with attached storage to HP Blades/Servers running Linux OS SUES/Red Hat/ Oracle, with 3 PAR network storage, migrating from ZFS Zones to VMware 5.1 VMs or Oracle OVMs.
• Setup, managed, and established relations and partner agreements with different vendors like: Oracle, HP, VMWare, SUSE, and Red Hat. Worked out contracts and licensing financial agreements between Confidential and all the different vendors.
• Established an Oracle vendor Lab over one million dollars in equipment and software for Beta testing with T4s servers, ZFS network storage, OEM 12c, Oracle 12c, OVMs
• Evaluated Data Aggregation software like Jaspersoft BI, and Talend ETL, and Oracle ETL tools for parsing data from XML nightly feeds into Confidential Databases.
• Troubleshooting various customer Database and Apps issues and worked to their resolution. For MySQL Data Mart customers worked out to set up MySQL Monitor and installing MySQL Agent remotely to monitor their local processes. Set up various MySQL logging within the database, and configured and tested an OS level log rotation process to clean up these many huge log files.
• Written various documents on new technology, rewrite and set up new procedures, corporate reports, and customer facing issues.
• Worked out and tested the many different paths for Confidential to upgrade in place or migrate from their former MySQL 5.0.51a Community version to 5.1.71 to 5.5.31 to reach MySQL 5.6.14 Enterprise edition. Tested the differences between the various steps with the many new variables that will need to be put into place so that once the company and all our customers are up on 5.6.14 MySQL, Confidential software will work correctly and effectively.
• Redesign of the Confidential software, from being one customer per database, to being Multi-tenant allowing the Confidential software to be able to silo an individual customer’s schemas and data in their own silo environment within a given MySQL database. Thus allowing Confidential to have on an average six customer per database depending on the parts of the Confidential software they use, and their usage demands, along with other related demands.
• Worked out MySQL Replication, that with MySQL 5.6 Enterprise version we could set up Backup servers, Reporting servers, and DR for production. Also, through VMs either VMWare 5.1 VMs, OVMs, or ZFS Zones I would utilize these VMs in setting up DEV, Test, and QA environments that could easily be set up and refreshed as needed.
• Managed many meetings and conference calls with Vendors, Customers, and company employees as a Project Manager.
• Worked with MS SQL Server 2012, PostgreSQL 9.3, MariaDB to evaluate possible usage of these database types working with MySQL and Oracle DBSs.