System Administrator Security Clearance

Nicolai Yetush

Cell: 437-***-****, e-mail: *******@*****.***

System Administrator and Hadoop Administrator

PROFESSIONAL SUMMARY

** *****’ total experience in IT. Master degree in Computer Science.

27+ years’ experience as a DBA working with Oracle, MS SQL, MySQL on UNIX, Linux and Windows Servers

20 years’ experience in IT for the administration, maintenance, and monitoring of high availability at Amdocs with products for leading cellular companies around the world.

9+ 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

Solid communication and interpersonal skills

Holder of Security Clearance

TECHNICAL SKILLS

Hardware Linux, HP, HP MX, SUN Solaris, AIX (IBM), Windows Workstations

Operating Systems Windows, UNIX, Linux, RHEL, Ubuntu, CentOS

Programming Languages KSH, Bash, SQL, PL/SQL, PERL, Python, PowerShell, C++, Turbo Pascal, VB6, SAX Basic, LISP, COBOL, HTML, CSS, XML, JavaScript, Ant

Tools Perforce, ASC, Control-M, Autosys, Microstrategy, SharePoint, Xtra-C, Putty, MobaXterm, VMWare, Microsoft HyperV, Docker, Toad Data Modeler, Erwin, Confluence, UCS Manager, Genkins, iSpirer, Solarwinds, DataDog, CMDB

Databases (RDBMS) Oracle, MS SQL Server, DB2, Teradata, PostgreSQL, MySQL, MariaDB, MS Access, PostgreSQL, AlloyDB, NonStop DB

Databases (NoSQL) MongoDB (Ops Manager, Atlas), Hadoop (HBase, Hive, YARN, Oozie, Zookeeper), Cassandra, ElasticSearch, Couchbase.

Development Tools MS Visual Studio, BPEL, Oracle Designer, AutoCAD, Visio, TOAD, SQL Developer, XML Formatter, PL/SQL Developer, Eclipse, SQL Management Studio, Query Analyzer, GIT, Sublime, emacs, vi, Spider, HeidiSQL, Power BI

DB Management Tools Embarcadero DB Monitor, Oracle Enterprise Manager (OEM), SQL Server Management Studio, Quality Center, Nagios, Ganglia, Grafana

ETL Tools Informatica, NiFi, Oracle Golden Gate

Schedulers Crontab, Autosys, Windows Task Scheduler, Control-M

Communications: FTP, SFTP, SCP, WinSCP, RDP

Cloud: AWS (EC2, RDS Aurora DynamoDB, VPC, Amazon Connect, DynamoDB, Amazon Kenisis Datastreams, Amazon S3, Amazon Polly, AWS Lamda, Cloud Formation and CloudWatch), Azure (vNET, CosmoDB), GCP

BigData: Hortonworks, Cloudera

Network: TCP/IP, LDAP, AD

Ticketing systems: SNOW (Service NOW), JIRA, BMC Remedy, SmartIT

Monitoring tools: DataDog, Grafana, Solarwinds

CI/CD: Jenkins (Jeeves, Jarvis), BitBucket, GitHub PROFESSIONAL EXPERIENCE

06/2017-Present B-Right Software Services LTD

Position: System Administrator and Hadoop Administrator Tasks:

Support clients such as TD, CIBC, CPP, Rogers, Bell Canada, TELUS (Communication, Health), VIVO Brazil, Ministry of Citizens.

Automation of different processes for CD/CI, DB auditing on SHELL, BASH, PL/SQL and Ansible

Remediation of UAT and PROD Oracle DBs per SOC requirements to be compliant.

Monitoring of Cloudera cluster for heavy queries, memory spilled, etc and creation and customization of new tenant spaces. Participating in Agile Scrum teams. Creating support strategy for open source and cloud native DB technologies.

Installed, configured, and maintained Linux servers (Red Hat, CentOS, Ubuntu, SUSE) in physical and virtual environments.

Managed system performance by monitoring, analyzing, and tuning system parameters (CPU, memory, disk I/O, network).

Automated tasks using shell scripting (Bash), Python, or Ansible for routine maintenance, backups, patching, and deployments.

Performed system updates and patch management to ensure security and stability, adhering to change control processes.

Set up and manage user accounts, permissions, and access controls using LDAP, Active Directory, and local tools.

Configured and manage services such as Oracle, MySQL/PostgreSQL, DNS, DHCP, NFS, Samba, FTP, and SSH.

Implemented and managed backup and recovery strategies using tools like rsync, tar, cron jobs, or enterprise solutions (e.g., Bacula, Veeam).

Troubleshoot hardware, software, and network issues, ensuring minimal downtime and quick resolution.

Supported DevOps and CI/CD workflows, including integration with Jenkins, Git, Docker, and Kubernetes.

Hardened servers against security vulnerabilities, configure firewalls (iptables, firewalld), and audit logs using tools like auditd and logrotate.

Maintained documentation of infrastructure, configurations, procedures, and troubleshooting steps.

Worked closely with development and IT teams to support deployments, migrations, and performance tuning.

Ensured high availability and disaster recovery planning through clustering, replication, and load balancing

(HAProxy).

Monitored systems using tools like Nagios, Zabbix, Prometheus, or Grafana, and respond to alerts proactively.

Installed of Amdocs products for Ordering, Billing, CRM and Ensemble applications

Created ODS environments with ETL flows through the Oracle Golden Gate, Hadoop cluster.

Database support for Oracle, MSSQL, MySQL, MariaDB, PostgreSQL and MongoDB.

Oracle DB creation on Linux/Windows with ASM configuration and on Exadata

Always-On SQL Server cluster creation and maintenance. Installation and upgrade of SolarWinds DPA.

Implementing high availability and disaster recovery strategy for critical data and Cloud DBs

Installing and maintaining database server environments. Representing Database teams on cross-functional projects.

Ensuring Compliance Controls are maintained to protect data.

MSSQL, MySQL, MariaDB, PostgreSQL, MongoDB installation, configuration, monitoring, backup/recovery. Oracle RMAN backup and recovery.

Migration of applications from Oracle to PostgreSQL, from Oracle to MSSQL, from MSSQL to Oracle

Migration of client DBs from on-premises to cloud (AWS, GCP) – Oracle/Postgres to Aurora/AlloyDB

Migration of client DBs to AWS fully or partially. AWS architect (AWS VPC, IAM, Subnets, Routing Tables, NACL, Security Groups, EC2, S3, EBS, RDS, ECS, ECR, Route 53, CloudFront, Direct Connect, SNS, SQS, SWF, Lambda, CloudWatch), and migration to Azure Cosmos DB.

Hadoop clusters installation (with and without Kerberos), monitoring performance and capacity, optimization of jobs and processes for heavy cluster loads.

UNIX/Linux Administration – installation, customization, OS patches, process monitoring, UCS Manager etc. Active Directory administration - tasks for user account management, LDAP configuration.

Shell and Python scripting in UNIX/Linux for alerts, flows automation and validation for ETL jobs.

System administration – Windows Servers and UNIX/Linux environments creation, configuration, monitoring, patching, VMware installation and configuration.

Created multiple OS images (Linux and Windows) for VM with the preinstalled SW per customer design.

Customization and deployment of business patches for Production, version control.

Production deployments by using Jenkins.

Reports creation by using PowerBI or Tableau, created and run SSIS Packages. Put and get data into Snowflake for BI analysis and report creation.

Created automation flows through the Apache NiFi, Informatica for RDBMS and NoSQL DBs.

Data replication and processing with Oracle and Kafka, using BigData on YARN or Spark.

ElasticSearch installation and maintenance on Windows for application search engine.

Deploy HFs (ad-hoc) on UAT/SIT and Performance DB environments (PET) with on-call support

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. Work in an Agile environment and SCRUM Projects using JIRA

Migration and customization of RDBMS DBs on Cloud AWS, GCP and Azure.

Participated in LAB for projects to migrate Oracle/MSSQL to SAP.

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)

Training - Responsible for the training of all new employees using SOP up-to-date.

Diagnose and address issues related to different Hadoop environments.

On-call support for UAT HF (ad-hoc) deployment, PROD CR implementations, performed tasks per SNOW tickets. Provide on-call rotating support for systems under team responsibilities. 10/2015-06/2017 Amdocs Inc

Position: Linux System Administrator, DBA Oracle/SQL and Hadoop administrator Tasks:

Support clients such as AT&T US, Rogers, Vodafone NL, Time Warner Cable (TWC), AT&T Mexico, VIVO Brazil and Comcast

Installation Amdocs products, OSS support in VMs.

Database support for Oracle 11g, 12c and MSSQL 2012/2014 on both Windows and Linux.

Creation and customization business patches for Production

Monitoring MongoDB DBs, backup

Data storage in MySQL, PostgreSql, Couchbase and Cassandra.

Migration of Amdocs applications from Oracle to PostgreSQL.

Automation – created scripts to automate Oracle Golden Gate 12 activity for replicated objects. Created set of scripts for DataHub and Control-M tool.

Documentation (SOP) - Provided documentation on new and existing procedures for Oracle operational environments. Writing of high level design documents and system architecture documents.

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.

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

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)

ETL scripting (shell, Python) and objects mapping/customization with special request

ElasticSearch installation on Windows and Linux, configuration of replication, fields indexing etc

Control-M installation and scripts creation for Control-M or Autosys.

Microstrategy installation and configuration.

Oracle Golden Gate for ETL operations, Control-M or Autosys, Microstrategy, TOAD, SQL Developer

Shell (ksh, bash) scripting for task automation ETL processes

RDBMS and NoSQL DB monitoring

TOAD Data Modeler, ERWIN, Visio

08/2010-10/2015 Amdocs Inc, US

Position: Production Sr. DBA Oracle/SQL/NoSQL, System Analyst, Change Management Analyst Tasks:

Support for clients such as AT&T, US Cellular, Vonage and Charter

Installation and support for Amdocs products like OMS, CRM, Cramer, ACS etc., OSS support

Application and System DBA support for the following products: Ordering (OMS), Billing (Enabler), CRM, RPL, AMSS, ACS, ELLA.

Participated in projects with MySQL, Teradata, CouchDB installation and administration.

Installation and monitoring replication tools Golden Gate versions 11 and 12, Data Guard.

Database support for Oracle 10g, 11g and MSSQL 2012/2014

Administration support in Hadoop (Hortonworks and/or Cloudera) clusters creation and monitoring.

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.

Monitor space alerts, warnings/critical errors.

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)

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.

Utilized BMC Remedy ticketing program to track work on various issues.

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.

Disaster recovery training, 24/7 Production support

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 with OLTP/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.

Confirmed overall data quality matches to documented standards for details such as Description, Justification Details, Impact Description, Implementation Plan and Rollback Plan 10/2006-08/2010 Amdocs Inc

Position: DBA Oracle

Tasks:

Installation and support for Amdocs products like OMS, CRM, Enabler, Cramer, ACS etc. (Delivery team)

Application and System DBA support for the following products: Ordering (OMS), Billing (Enabler), CRM, RPL, Cramer, Ensemble, AMSS, ACS, TLG, SE etc.

Support for clients such as AT&T, Telstra, Mobilcom, ClearWire and Vonage, OSS support

Working with Amdocs tools: TIGER, Scout, Genesis, DB Extract, CIA, and Validation Tool.

Installation, administration and upgrade Oracle DB instances.

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.

ERD creation for all Amdocs products.

2005-2006 Veracity Group

Position: Linux System Administrator, DBA Oracle and SQL Tasks:

DBA Oracle & SQL Server and DBA advisor at “Veracity”

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.

Languages: English, French, Deutsch

Contact this candidate