SUMMARY

• 28 years in IT as DBA, Linux and DevOps Administrator and developer in Healthcare, Finance and Aerospace industries.
• Fast learner, hardworking, responsible, initiative, detail - oriented, team player, requires low supervision, problem solver.
• Very strong and enthusiastic in optimization, performance tuning, simplifying and standardizing (unifying) solutions
• Certified Microsoft MCDBA MCSD, Linux Administrator (LPIC, SUSE) and NetApp SAN Administrator 7-Mode

TECHNICAL SKILLS

Databases: MS SQL Server, MySQL, ORACLE, Postgres, SyBase, OpenEdge Progress

Scripts and Programming Languages: Shell, PHP, Perl, PowerShell, C/C++, VC++, Transact SQL (T-SQL), PL/SQL, VB/VBA

Tools: /Programs VMWare, HyperV, Amazon Web Services (AWS), RMan, Apache, Tomcat, Nagios, Puppet, GitHub, WordPress

OS: Windows, RedHat, CentOS, SUSE, Ubuntu, Debian, AIX, FreeBSD, Solaris

Storage SAN: NetApp 7-mode

PROFESSIONAL EXPERIENCE

Confidential

DevOps and Database Administrator

Responsibilities:

• Configure and deploy servers and storage in Peak10 Data center in FLL and DR center in Atlanta;
• Install RedHat, SUSE, AIX, configure and tune network ( LACP) using IPERF, IFTOP
• Tune file-systems ( LVM, XFS, mounting options) with IOZONE, use LVM snapshots for super-fast volume restore
• Install and configure SQL Server, OpenEdge Progress, MySQL, Postgres,
• Database performance tuning, Query optimization, Capacity planning
• Establish SQL Server Transaction Log Shipping, Database Mirroring, Always ON; MySQL Master-Master Replication; and Progress Replication-Plus with two targets; mysqldump and RMan backups; provide Disaster Recovery and cluster fail-over solutions; establish daily real-time UAT/QA refreshes using LVM Snapshots
• Provide Database security on SQL Server, OpenEdge Progress, Oracle 11g Enterprise and Oracle 12c R1 standard servers, automate RMan backups, migrate data using Oracle EXP/IMP utilities
• Using Puppet and Chef automate deployments, create and maintain CRON jobs, version upgrades.
• With Nagios establish full monitoring of servers and applications, provide email and SMS (Text) alerts.
• Design Shell, PHP, Perl and other scripts, C/C++ programs (using GCC, Make), 4GL
• Design and tune T-SQL queries and stored procedures in order to automate different processes and monitoring.
• Use GitHub to download, sync, compile and install required software (i.e. Nagios), configure local GitHub repository
• Install and configure Apache and Tomcat servers to run multiple Web-sites
• Help primary Storage Administrator to install NetApp SAN, configure and monitor them
• Release and RFC Deployment, On-Call Support
• Research Amazon Web Services (AWS) and GoDaddy, migrate and configure WordPress from IIS to Apache
• Completely automated a release deployment process for corporate primary systems COSMOS & Visual Marketing
• Conducted a thorough research of EXT2, EXT3, XFS, BTRFS file systems and mounting options, and improved hardware SSD RAID-10 performance of production Dell PowerEdge.
• By LVM Snapshots dramatically speeded up Real-time UAT huge DB-Refreshes, reduced Disk I/O and Network usage
• Provided 3-node distributed Progress 11.7 DB Cluster between three Data centers using OpenEdge Replication Plus.
• Reduced complexity, replaced hundreds redundant Bash Shell, Perl, PHP scripts with unified parameter-taking ones.
• Made systems more reliable by unifying their configuration, standardizing all data and folder structures.
• Dramatically improved security by C++ development (with GCC) of centralized routine to unify retrieval of encrypted credentials from one secured place instead of hard-coded passwords in hundreds scripts and INI-files.
• Improved SQL Server 2016 Enterprise security by eliminating couple causes of high vulnerability
• Conducted research, optimized backup practice and saved terabytes on Production NetApp SAN
• With IPTables, Selinux, FireWall, Sticky bits, and ACL improved security of Linux systems
• Simplified and provided Fault Tolerance solution for AIX based system Symix residing on IBM chassis, created self-installable media images from VIOS LPAR

Confidential

SAAS to automate FDA Trial submission.

Responsibilities:

• With Transact SQL (T-SQL) Implemented advanced multi-threaded DB Maintenance routine
• To optimize SQL Server usage I designed stored procedures and scheduled several SQL Jobs to a) Clean abandoned Replication settings;b) Drop abandoned SQL Jobs; c) Delete orphaned files from database folders
• To ensure that all business SQL jobs are always running as expected and never fail w/o our attention I designed and implemented a scheduled routine, which checks that every business job will definitely send an Email alert if it failed
• To ensure that all business jobs will perform well and utilize proper Assemblies I designed a scheduled routine to check right version of Assembly in all client databases
• To improve performance implemented Stored Procedure force-changing Database SNAPSHOT ISOLATION
• On Transact SQL (T-SQL) designed Stored Procedure to update incrementally statistics for the Indexes
• Using IOZONE and IPERF I've investigated NetApp SAN and found a root cause of malfunction. As result, we improved NetApp SAN performance in more than 10 times
• I had automated IIS log collection in order to perform scientific analysis of Primary corporate application
• With Nagios Implemented self-correcting monitoring system, automatically fixing on the fly minor issues.
• Help developers to optimize database schema, Indexes, Stored Procedures and Triggers designed on T-SQL or PL/SQL

Confidential

Senior Database and Linux Administrator

Responsibilities:

• Install and configure SQL Servers, Oracle, tune their performance
• Design T-SQL or PL/SQL stored procedures to automate maintenance and help developers
• Manage user security, respond to requests of Application support. On-Call support.
• Automate nightly backups on T-SQL and RMan. Performance tuning.
• Designed Self-correcting monitoring system. Production down-times dramatically reduced from Few/Week to Zero/Year
• Standardized and unified configuration of corporate Database servers. This significantly improved their reliability and predictability of their behavior.