SUMMARY

• 20 years total experience in IT.
• 11+ years’ experience working with Oracle, MS SQL, UNIX, Linux and Windows Server.
• 11 years experience in IT for the administration, maintenance, and monitoring of high availability at Amdocs with products for leading cellular companies around the world.
• 7 years experience with Oracle Golden Gate replication.
• 4+ years’ experience working with NoSQL: MongoDB, Couchbase, Cassandra and Hadoop administration.
• Process oriented, ownership for projects and deadlines
• Self - starter, ability to identify actionable steps towards completing objectives
• Strong problem solving ability, analytical and design skills
• S olid communication and interpersonal skills

TECHNICAL SKILLS

• HP, SUN, AIX, Linux, Windows Workstation Windows, UNIX, Linux, Ubuntu, CentOSKSH, SQL, PL/SQL, PERL, JSON, Python, PowerShell, C++, Turbo Pascal, VB6, SAX Basic, LISP, COBOL, Java, HTML, CSS, XML, JavaScript, AntPerforce, ASC, Control-M
• Microstrategy, SharePoint, Xtra-C, Putty, MobaXterm, VMWare, Docker, AWS, AzureOracle 9-12, MS SQL Server 7/2000-2014, MongoDB, Hadoop (Hbase, Hive), Cassandra, Teradata, PostgreSQL, MySQL, MS Access, ElasticSearc
• CouchbaseMS Visual Studio, BPEL, Oracle 9i Designer, AutoCAD, Visio, TOAD, SQL Developer, XML Formatter, PL/SQL Developer, Eclipse, SQL Management Studio, Query Analyzer, GIT, Sublime, emacs, VI Embarcadero DB Monitor
• Oracle Enterprise Manager (OEM), Remedy, SQL Server Management Studio, Quality Center.TOAD, PL/SQL Developer, SQL Developer, MS Office, Lync,RobomongoFTP, SFTP, SCP

PROFESSIONAL EXPERIENCE

Confidential

Sr. DBA Oracle/SQL/NoSQL/Hadoop Administrator, System Analyst

Responsibilities:

• Application and System (Physical) DBA support for the following products: Ordering (OMS), Billing (Enabler), CRM, RPL, Cramer, Ensemble, AmSS, ACS, TLG, SE, ELLA, ODS etc.
• Working with Amdocs tools: TIGER, Scout, Genesis, DB Extract, CIA, Validation Tool etc.
• Installation, administration and upgrade Oracle, MS SQL, PostgreSQL, MySQL and other than RDBMS DBs: Cassandra, MongoDB , Hortonworks and Cloudera - Hadoop, Ambari, Hue, Hive, HBase etc.
• Participated in projects with MySQL, Teradata, CouchDB installation and administration.
• Installation and monitoring replication tools Golden Gate versions 11 and 12, Data Guard.
• Installation of Control-M tool and customization scripts for Control-M jobs
• Golden Gate installation and configuration for ETL for projects with ODS (Operational Data Store)
• Golden Gate installation and configuration for one way replication for DEV, UAT, Performance and PROD environments. Worked closely with development and BI teams to configure the proper ODS environment.
• Worked collaboratively to manage build outs of large data clusters.
• Hadoop clusters installation (common and secured clusters), monitoring performance and capacity.
• Unix and DBA infrastructure delivery, the provided a broad range of research, installation (incl. deployment and release management), maintenance, configuration, administration of systems and applications
• Training - Responsible for the training of all new employees using SOP up-to-date.
• Diagnose and address issues related to different Hadoop environments.
• Helped design big data clusters and administered them.
• Worked both independently and as an integral part of the development team.
• Communicated all issues and participated in weekly strategy meetings.
• Administered back end services and databases in the virtual environment.
• Implemented system wide monitoring and alerts.
• Hadoop Hortonworks (Ambari, HDFS, MR, YARN, Hive, HBase, Zookeeper, Oozie, Hue, Beeswax, Beeline, PIG)
• Hadoop Cloudera (Cloudera Manager, HDFS, MR, YARN, Hive, HBase, Zookeeper, Oozie, Hue, PIG, Impala, Sqoop, Flume, Spark)
• Microstrategy installation and configuration.
• Database Security - Created administrator accounts with required roles. Maintained all necessary security paperwork for these operational accounts.
• Documentation (SOP) - Provided documentation on new and existing procedures for Oracle operational environments. Writing of high level design documents and system architecture documents.
• High Availability - Responsible for the continued availability of all supported Oracle products.
• Involved in the logical data design, worked close with the Development team.
• High level design for the new projects including logical structures, system requirements and customization of application design.
• ERD (logical data design) creation for all Amdocs products.
• Monitor space alerts, warnings/critical errors.
• Release Management - Coordination of changes between business team and DBA, creation of scripts, upgrading applications, review logs for errors, work with developers to clean up errors.
• Unix and DBA infrastructure delivery, the provided a broad range of research, installation (incl. deployment and release management), maintenance, configuration, administration of systems and applications
• Ensure database availability, reliability, security, and connectivity
• Monitor health (table space size, error logs, queue logs, etc) of single node and RAC Systems
• Track/Analyze database performance against the metrics using AWR/STATSPACK
• Performed the configuration, design, build deploy and provisioning of DB (asses required resources, creates database schemas, manage accesses, executes and proposed improvements to SQL scripts developed by other teams)
• Rebuild indexes, tables, purge procedures, and remove duplicated data.
• Migration from Oracle 9 to Oracle 10, from Oracle 10 to Oracle 11, from Oracle 10 to Oracle 12.
• Restore/Backup - Recover individual tables exp/imp and expdp/impdp or entire database as necessary (COLD/HOT Backup)
• Build test environments from correct baseline applying software releases and supporting testers with problems found during SIT testing using scripts, export/import and datapump: exp/imp, expdp/impdp.
• Performance issues - work with application teams to identify and fix culprit.
• Reporting - Generated reports related to replication queues, replication connections, processes and database free space. Received daily reports regarding overall system health and latency.
• Scripting - Responsible for the creation and maintenance of new internal tools. Tools primarily consisted of Shell scripts that interacted with the UNIX OS and Oracle databases. These scripts utilized multiple tools that included grep, sed, perl, python and awk.
• Automation - created scripts to automate Oracle Golden Gate 12 activity for replicated objects. Created set of scripts for DataHub and Control-M tool.
• SQL Programming - Created database objects (tables, views and stored procedures) to increase the productivity of the operational DBAs. Procedures ranged from those that check user accounts to those that run SQL across multiple servers. Generated PL/SQL queries that provide important information to the administrator.
• Support - Provided phone support for customer, after hours to support long running processes. Traveled to the site when necessary to assist the on shift administrator.
• Training - Responsible for the training of all new employees using SOP up-to-date.
• ETL and objects mapping/customization with special request.
• Customized environments creation with specific product’ structure and data in RAC and single DBs.
• Created and maintained additional testing environments as requested and needed by applications development.
• Preparation and installation DB business patches per customer standards - delivery team.
• Created and maintained a “data copy” utility that was used to extract/copy data from production to test for problem replication and testing.
• Monitoring of database environments, automation of long complex processes.
• Participates alongside the Database Administrators in planning database related initiatives such as patch management, database access, security audit and version upgrades.
• Assists with applying database changes to multiple environments in support of the software development lifecycle.
• Provide on-call support for the supported RDBMS and BigData (NoSQL) - Hadoop, Cassandra, MongoDB for 24 X 7 operations.
• Utilized BMC Remedy ticketing program to track work on various issues.
• Utilized various logs to document work completed at our level.
• Shared responsibility of shift work with other DBAs. Personnel were staffed 24x7x365.
• Participated in the migration of servers to new hardware that included the upgrade of applications.
• Participated in the project to migrate data from Oracle to MS SQL or PostgreSQL
• Disaster recovery training.
• Support databases and engineering;
• Source code management and version control;
• Ensuring consistency of data and schema across multiple environments (development, QA, UAT and production);
• Sanitation and testing stored procedures; sanitation of hygiene databases;
• Support projects with OLTP and OLAP.
• Participated in projects and tasks for transfer Oracle DB to SQL Server (tables, triggers, unions, joins, complex queries and stored procedures, power shell programming), supported Teradata DBs.
• Installed and upgraded SQL Server 2008, 2012. Administrated DB on SQL Server for configuration, backup, environments upgrade with business patches and restore.
• Assisted to DEV team to modify and fix reports created on COBOL.

Environment: SQL, PL/SQL, UNIX Shells, KSH, Python, PERL, AWK, SED, Java, ANT ENVIRONMENT: HP-UNIX, AIX-UNIX, SUN/SOLARIS, Linux, Windows NT 4.0, ORACLE 8-12

Confidential

DBA Oracle and SQL

Responsibilities:

• DBA Oracle & SQL Server and DBA advisor at “ Confidential ”
• Application projects on PL/SQL for cellular companies for OLAP and OLTP.
• Creation and support for RAC DBs (Oracle 9i/10g)
• Responsible for maintaining backups of the databases Oracle 10g (RMAN, hot and cold backups).
• VBA programmer.
• Oracle installation on Windows and UNIX platforms (Linux - RedHat, CentOS)
• VMware installation and preparation for training classes for Oracle products on VM Linux machines
• Acronis backups/images for training classes.
• Have completed projects involving creating, supporting and administering Databases.
• Data Base and SQL Statement Tuning, Backup and Data Recovery.
• Installation of all MS Windows versions, MS office, backup programs
• Projects on MS Access.

ENVIRONMENT: Windows XP, Oracle, SQL Server, MS Access.

Confidential

Technician

Responsibilities:

• Help Desk and Technical support at Confidential Technologies.
• Thermal Transfer Printer Technician.
• Programmer at Internal Revenue, Ukraine.
• Languages FoxPro, Clipper and C/C++.
• Environment: MS Access, Excel, Word with Windows 98.