SUMMARY:

Senior Level Infrastructure/Systems Engineer with advanced experience and training and a discipline in Operating System builds (Linux) with over 10 years in Database deployments (DB2, MySQL, Mongo, Oracle) and OS builds. Platforms include IBM pSeries, VMware, Power systems server technology. Experienced in OS installation, OpenShift Cloud Platform, Active Directory, logical and physical design of application related services, network configurations, upgrades and virtualization (RDBMS, CIFS, DNS, NFS, NAS - ISCSi, TOMCAT). Developed and maintained systems and database in accordance with business requirements. Primary focus on virtualization, CI/CD automated deployments and builds, orchestration and distributed systems.

TECHNICAL SKILLS:

Hypervisors: VMWare ESXi 5.5, Virtual Box

Operating Systems: Windows 2003, 2008, Unix/Linux, AIX, Centos, Redhat {5-7}, MAC OS, Docker

Programming Languages: Python 2.x-3.x, Bourne Shell - (BASH, KSH), PL/SQL, Ruby

Cloud Technologies: AWS, Softlayer, Redhat Open Stack, OpenShift

Automation Tools: Puppet 4.5, Jenkins

Office Productivity Tools: Word, Excel, Publisher, Power Point, Access, Outlook

Management Software: Chef, Kubernetes

PROFESSIONAL EXPERIENCE:

Confidential

Linux Integration Engineer/ Database

Responsibilities:

• Provisioning Linux VMs via IBM SOFTLAYER configuration tool; Principal Linux IE for automating user management and system related operations
• Building ext4 file systems partitions (mkfs, partprobe, lvm2 etc); Installing system wide packages to support database deployments; Providing solutions and support for 24/7 DB2 LUW databases; Building out DB2 databases for e-commerce platform
• Execute daily configuration management of Tomcat Apache, DNS, file permissions, network service resources; Providing vendor with properly tuned SQL and deploying via java based jar’s
• Building database related scripts for durability/availability (Backups, repairs/reorgs, updating system statistics); Tuning database buffers, online backups and table exports; Redesigning skewed data for DB2 DPF tables; Building and automating database platform refreshes via cursor loads; Experience with database compression capabilities and Table Partitioning; Designing a sandbox environment with Core production tables for application development in DB2; Configuring HADR environment and allowing read capability on the standby for reporting; Creating database maintenance jobs for backups, table exports and archive’s
• Built additional essential programs for database restores, roll-forwards, database create base scripts, db2 restart script for HADR and database instance upon server reboot, database log cleanup and a weekly process to capture growth; Built a log monitor program to monitor database logging usage to send alerts in case 80% usage threshold is breached; Assisting with database queries as needed by the developers

Confidential

Linux Integration Engineer/ Database

Responsibilities:

• Daily automation of tasks using Python (Methods, Libraries, functions) including text filtering to facilitate for application analysis; Patching Linux systems as required by applications and vulnerabilities (STIG); Deploying Linux VMs, Apache, MySQL, PHP (LAMP) environments, Samba, DNS, NFS, CIFS, SSL/TLS and SELinux, Tomcat; KVM Building w/ type 1 and type 2 hypervisors; Managing Amazon Web Services infrastructure and working with EC2 instances; Configuring Network Interface bonding/teaming for load balancing and deploy cache only DNS; Configuring and installing application related binaries
• Working with Database administrators to tune kernel for Oracle installations on RedHat Linux.; Working with Middleware to configure web component services for JBOSS, Tririga; Managing VMware based Linux systems and troubleshooting cluster issues; Upgrading/Patching Linux via Redhat Channel, RHN Satellite 7.2 - 7.4, 6.x - 7.x x86 64 server edition; Ensuring availability and reliability of systems through backups, monitoring and tuning; Implementing Multi-Factor authentication in AWS; Configuring CPU time slice for server side processes that need to be CPU bound; Resolving client/user issues both Linux and database related; Installation configuration of puppet master and puppet agent to ensure central administration, user creation, package update and maintenance of the infrastructure; Experience configuring and using AWS CLI
• In depth understanding of Linux network services and how to troubleshoot them (DNS, SSH, SFTP, CIFS, NFS); Performing system level network changes and server VLAN moves; Cloud deployment of Linux VMs and applications in cloud and server less infrastructure; Extensive shell scripting experience in bash and ksh; Installing operating systems on Hypervisors - Oracle VB, VMWare, RHEL (5,6,7); Managing groups and user accounts assigned permissions to users.; Configuring DHCP, DNS servers and IP4 addresses; Working with Linux alternaticves; TCP/IP configuration of IPV4 and IPV6; Installing and configuring Puppet - Environments, Classes, Modules, Agent Nodes
• Using Nova service for VM builds and multi-tenancy; Knowledgeable w/ various hypervisors for virtualization - KVM, VMware ; Writing and Building Python code for task automation; Installing SDK, JDK environments for COTS applications; Integrating to Linux domain and windows clients using Samba server (CIFS) and NFS; Configuring Apache server (vhosts and SSL secured webpages); Design MySQL database backup and recovery strategies; Proficient in Disk management - fdisk, gdisk; Knowledgeable in create partitions on attached devices (/dev/sda etc.); Designing auto scaling solutions for servers, databases and applications
• Working and building file systems, LVM manager; Experienced w/ creating and deploying DR solutions for VMware snapshots, Glance and the use of Switch to store block and file based images; Disk Management, partitioning tools like fdisk, sfdisk, mke2fs, e2fsck, tune2fs etc. Experience with database compression capabilities and Table Partitioning; Providing 24x7 support, performance tuning, automating database backups, restore and archiving procedures; Extensive experience in shell scripting, command line, and gui based administration; Experienced in both remote and onsite administration; Administrating the Installation and configurations of various software’s (RDBMS, NoSQL, Linux distributions - packages, repos, binaries); Supporting and managine MySQL instances running in RDS; Building micro service database functions and projects with OpenShift container platform

Confidential, Washington DC

Linux/ Database Administrator

Responsibilities:

• Building and managing Linux systems via kick start configuration scripts; managing users in ldap database and installing server side packages using rpm; Creating and manager Linux users and groups; Building DB2 UTF-8 non-Latin1 based databases to allow developers test environments to test multi-byte character expansion sets; Reviewing and tuning high intensive SQL through use of db2top, db2advis, explain plans and building indexes to improve SQL read performance
• Configured HADR databases with sync and async modes; Managing Linux VMs and adhering to user management; Writing stored procedures which read and modify data to better assist developer tasks
• Responding to JIRA’s and resolving any DB issues; Task automation through Tivoli JSC UI; Performing Database reorgs and runstats using database configuration parameters; Configuring database roles for groups and users to ease the security and administration task of the DBA’s
• Reorganizing and restructuring of existing Databases to meet the OFA standards and for optimizing the performance.; Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention.
• Configure Install and Upgrade Oracle 10g from 10.2.0.1. to 10.2.0.5 all single Instances on Linux Red Hat; Support for Oracle RAC, including applying patches, performance tuning, backup and recovery with RMAN; Support for installing RAC software; Installing and configuring of Oracle.

Confidential, Washington DC

Linux/ Database Administrator

Responsibilities:

• Implementing and automating tasks using python and bash level scripts for - OS level file backups, TSM archiving, db2look and database auditing; Coding and deploying stored procedures for server side processing to improve response time; Configuring database roles for groups and users to ease the security and administration task of the DBA’s; Configured MySQL Replication as part of HA solution
• Proficient in Disk management - fdisk, gdisk; Knowledgeable in create partitions on attached devices (/dev/sda etc.); Designing auto scaling solutions for servers, databases and applications; Working and building file systems, LVM manager; Experienced w/ creating and deploying DR solutions for VMware snapshots, Disk Management, partitioning tools like fdisk, sfdisk, mke2fs, e2fsck, tune2fs etc. Experience with database compression capabilities and Table Partitioning; Providing 24x7 support, performance tuning, automating database backups, restore and archiving procedures; On-call duties such as application and web support, snapshot database restoration and back rsync to disaster recovery site.
• Creating highly available databases for development, test and production environments; Performing daily restores of snapshot databases on a need basis; Implementing db2 audit facility to monitor both database and instance level usage; Configuring high availability and disaster recovery databases for highly sensitive applications; Installed, configured and maintained MySQL DB instances; Creating DML triggers to shadow source table data and ensure availability for historical purposes
• Configuring HADR environment and allowing read capability on the standby for reporting; Creating database maintenance jobs for backups, table exports and archive’s for TSM; Configuring all previously created DB2 databases to use TSM server for database logging
• Upgrading db2 instances V9.5 to V9.7, databases and applying fix packs; Configuring the db2fm, db2fmcd and a db2rc script in init to ensure various instances are started on Upstart run level 3 & 5.

Confidential, Macon, GA

Systems Engineer

Responsibilities:

• Participated in design review meetings, involved in logical design and in converting logical model into a physical database model; Provisioning MySQL database instances; Building Master/Slave node replication environment for MySQL; Creating database stored procedures to facilitate purging and archiving of highly sensitive audit data; Participating in database on-call support for 24/7 applications; Manage Tomcat and Apache web servers; Script in Perl, Python and Unix Shell to automate processes and simplify tasks; Update System Network configuration and assist w/ VLAN moves
• Designing and architecting the DB2 database server environments for optimal performance ie SQL processing, transaction logging, batch jobs; Sharding, Monitoring, Replicating Mongo Database Systems; Install, configure and administer Mongo Database.
• Tivoli Storage Manager design, implementation, and management; Creating and managing collections within MongoDB; Building Analytics solution using MongoDB for non-transaction critical applications; Installed Percona MySQL 5.5 rpm binary on Linux Redhat 5
• Designed new databases, backup strategies, and recovery strategies using Xtra Backup; Designing a sandbox environment with Core production tables for application development in DB2; Upgrading DB2 Connect clients to V10.5; Installing DB2 V10.5 AESE version with root privileges using DB2 install;
• Enforcing all db2 activities be logged on the database level; Documenting built process for operational use; Implementing a bi-yearly and yearly termination archive process to archive non-active data; Assisting with database queries as needed by the developers