Manager Support
Resume:
Elena Yevtushenko
*******@*****.***
Cell: 1-437-***-**** (Toronto, ON)
Certifications: Master Oracle and SQL server DBA, BigData Architect Professional Summary
With more than 15 years in IT including 11 years as an Oracle Database Administrator and 4 years in administration of Microsoft SQL Server 7.0, 2000, 2005 and 2008. Extensive experience in full life cycle development as an Oracle DBA in Information Technology. Specialization in Oracle 11g, 10g, 9i, 8i, in System Architecture, Database Modeling, System Re-engineering, Requirement Analysis, Functional Specifications, DB creation, backup, recovery, performance tuning, database administration/development using tools like PL/SQL, Toad, PL/SQL Developer, SQL*Loader, in Unix, Sun, HP, IBM and Windows NT environments. I have been championed with a variety of responsibilities ranging from DBA work, Oracle Applications DBA work and Database Manager work. I have performed clustering, release management, upgrades, and physical and logical data modeling for number of companies. My current position is a Group Lead of Oracle DBA and SQL DBA teams at Astadia, level 1 Production support. Design, installation and maintenance of Oracle databases 8,9,10 and 11, RMAN and HOT backups, OEM and SQL server databases. 2 years in MongoDB/MariaDB Administrator.
Technical Skills
DBMA and Database Tools: SQL/SQLPlus, Oracle 8i/9i/10g/10g2/11g, TOAD, Oracle Enterprise Manager (GUI & OEM Grid Control) Oracle RAC, RMAN, OID, Fusion Middleware (Weblogic), Oracle Application Server, Quest, WRQ Reflections, Exceed, Putty, MobaXterm X server, HeidiSQL, SQL Server Management Studio.
Configuration Management: Clear Quest, SourceSafe, Putty, F-Secure Operating Systems: Windows 95/98/2000/ME/XP/Vista/NT/Windows 7/8, UNIX, Linux, Sun/Solaris 9/10, AIX, Exadata.
Applications: MS Office, Toad, Visio, SQL Management Studio, Tivoli job scheduling, PL/SQL Developer, SQL Developer, Microsoft Office Databases: Oracle 7-12 with SQL*Plus, iSQL*PLUS, MS ODBC, SQL Server 7/2000-2012, MongoDB, MySQL/MariaDB
Development Tools: MS Visual Studio, BPEL, Oracle 9i Designer, Visio, TOAD (SQL Tool), PL/SQL Developer,SQL Developer.
Programming Languages: SQL, PL/SQL, Shell script, AWK, SED Monitoring tools: McAfee Sentrigo
Communications: FTP, SCP, SFTP, WinSCP
Technical Training
BigData Architect
Exadata training
Oracle 11g Administration
Oracle 10g Administration
Oracle 9i DBA Administration (Fundamental I & II), SQL/PLSQL, Architecture, Administration, Network, Performance, Tuning, Backup and Recovery SQL Server 2005 Administration
Ksh/csh/bash script writing
MongoDB University
Professional Experience
B-Right Software Services LTD – gives services to Tangram Soft, Israel DBA Oracle, SQL and MongoDB
June 2017- Current
• Consulting services for maintenance, monitoring and support of Oracle databases in various environments (development, test and production).
• Support for Exadata DBs, monitoring, upgrade.
• Support for development, test and production environments in MongoDB using MMS tool
(OPS Manager), MongoChief and MTools for performance monitoring.
• Managed customer applications in MS SQL 2005-2014
• Support testing environments in MySQL/MariaDB.
• Participated in upgrade Exadata DBs.
• Configuration of Sentrigo security tool for Oracle, MS SQL and MongoDB DBs.
• Manage production systems by addressing tablespace and datafile errors, resolve blocking locks, address application errors, monitor and address database performance issues. Professional Experience
Migdal Insurance Company Ltd., Israel
DBA Oracle and MongoDB
August 2017 - Current
• Providing services for maintenance, monitoring and support of Oracle databases in various environments (development, test and production).
• Support for Exadata DBs, monitoring, upgrade.
• Support for development, test and production environments in MongoDB using MMS tool
(OPS Manager), MongoChief and MTools for performance monitoring.
• Managed customer applications in MS SQL 2005-2014
• Support testing environments in MySQL/MariaDB.
• Participated in upgrade Exadata DBs.
• Configuration of Sentrigo security tool for Oracle, MS SQL and MongoDB DBs.
• Manage production systems by addressing tablespace and datafile errors, resolve blocking locks, address application errors, monitor and address database performance issues.
• Upgrade Oracle DBs 11g to Oracle 12c
• Transfer DBs from Exadata 2x to Exadata 6x using DataGuard technology. Professional Experience
Tangram Soft (projects in Migdal), Israel
DBA Oracle, SQL and MongoDB
December 2015- August 2017
• Consulting services for maintenance, monitoring and support of Oracle databases in various environments (development, test and production).
• Support for Exadata DBs, monitoring, upgrade.
• Support for development, test and production environments in MongoDB using MMS tool
(OPS Manager), MongoChief and MTools for performance monitoring.
• Managed customer applications in MS SQL 2005-2014
• Support testing environments in MySQL/MariaDB.
• Participated in upgrade Exadata DBs.
• Configuration of Sentrigo security tool for Oracle, MS SQL and MongoDB DBs.
• Manage production systems by addressing tablespace and datafile errors, resolve blocking locks, address application errors, monitor and address database performance issues. Professional Experience
Astadia St.Louis MO (projects in Anheuser Busch)
Team Lead- Oracle, SQL and Business objects
July 2011- August 2015
• Consulting services for maintenance, monitoring and support of Oracle databases in various environments (development, test and production).
• Problem research and resolution (development, test and production).
• Provide support for upgrades, patches and bug fixes.
• BI reports creation in Cognos Report Studio.
• Monitor the development, test and production systems, and adjust/correct as needed.
• Monitor and resolve performance issues.
• Manage customer application process and Oracle monitor alerts.
• Review automated health check reports and correct items that could potentially cause failures.
• Monitor KPI performance of support teams and remediate as needed.
• Perform routing health tasks such as routine password changes, writing shell scripts for monitoring, recover data from backups and manage Archive log space.
• Manage production systems by addressing tablespace and datafile errors, resolve blocking locks, address application errors, monitor and address database performance issues.
• Provide support for upgrades, patches and bug fixes.
• Upgrade client software, including ITRM and software distribution processes.
• Create/modify database objects (DDL).
• Creation of new databases and users.
• Creation of standard roles and granting of access rights.
• Ensure enforcement of customer security rules.
• Maintain backup scripts - review automated report and correct items that could potentially cause failures.
• Monitor for long-running transactions which could potentially impact performance Monitor adherence to standards and correct non-compliant items.
• General technical support and Q&A.
• Sql queries tuning, performance tuning.
• Upgrade environments from Oracle 9g and 10g to 11.2.0.2 maintaining Critical Patches
• Ensure database availability, reliability, security, and connectivity
• Administer privileged accounts
• Performance issues – work with application teams to identify query problems Professional Experience
Cognizant, FPL Melbourne, FL
Oracle Senior DBA
January 2015- June 2015
Top level technical expert and visionary responsible for the development of strategy, design and implementation of an assigned technology or for the network or infrastructure components to support that strategy. Produces documented frameworks, architectures and plans which describe how to manage the implementation and integration of a technical environment. Designs and implements database environments by employing appropriate technology that would ensure the highest levels of data availability. Analyzes business process and practices in an effort to drive the design and implementation of information technology database solutions that meet customer needs and business initiatives. Interprets internal or external business issues and recommends best practices. Solves complex problems; takes a broad perspective to identify innovative solutions. Works independently, with guidance in only the most complex situations. May lead functional teams or projects. Possesses a solutions-oriented approach and high work ethic with excellent communication and process management skills. Primary Job Functions:
• Drive the development and communication of long-term strategic goals for the database environments to meet existing and future business needs.
• Create models for new database development and/or changes to existing ones to take advantage of new technologies.
• Install and configure relevant database network components to ensure access as well as database consistency and integrity.
• Drive the development of policies and procedures by utilizing best practices and technologies to maximize database performance and efficiency.
• Work with application development staff to establish appropriate end-user database access control levels and develop routines for end-users to facilitate best practices database use.
• Engage in effective physical data storage allocation and usage to facilitate the data growth as well as resource consumption.
• Increase and enhance existing knowledge base with the database group by conducting researches and training to make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Promote efficient data migration processes to meet various business needs for data.
• Advocate the adoption of database security policies to prevent un-authorized access to business data.
Professional Experience
Pontis, Glil-Yam Israel
Oracle DBA, applicative DBA and Integration person January 2009 – July 2010
• Performed product upgrades, monitoring and performance analyzing for Claro and Vodafone Spain products.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• Monitor the health of the databases and Integrative logs, and checks and automates ALERT logs.
• Coordination with Oracle Support, developers and functional teams in effective resolution of product packages.
• Monitoring for the Database Operations, Memory Allocations (Database buffer cache, Redo log buffer Cache, Shared pool, etc)
• OEM – monitor space alerts, warnings/critical errors.
• Performance issues – work with application teams to identify query problems
• RMAN – perform backups, check failures and kick off based full destinations
• Release Management – Coordination of changes between business team and DBA, application of scripts, upgrading applications, review logs for errors, work with developers to clean up errors.
• Install Oracle 10g, and upgrade machines with Oracle Critical Patches as necessary
• Clone databases from production RMAN backups
• Monitoring and auditing database operations. Performing recovery procedures from system crashes
• Track/Analyze database performance against the metrics
• Rebuild indexes
• ASM configuration.
• Troubleshoot - Detect and resolve database performance concerns
• Restore/Backup - Recover individual tables or entire database as necessary (data) Professional Experience
Amdocs, Raanana Israel
Oracle DBA
February 2008 – January 2009
• DBA Oracle at Amdocs in Oracle versions 9i, 10g and 11g.
• Providing DBA support for development teams and customers.
• Strong troubleshooting abilities.
• Close cooperation with customers.
• Installing new versions and applying maintenance fixes supplied by the vendor.
• Setting and tuning system parameters.
• Maintenance of the Oracle Database 9i, 10g, 11g and instance.(24/7 on Call Support)
• Upgraded Oracle database from 9i to 10g.
• Tuning the operating system, network, and transaction processors to work with the database.
• Ensuring appropriate storage for the database.
• Enabling the database to work with storage devices and storage management software.
• Interfacing with any other technologies required by database applications.
• Installing third-party DBA tools.
• Systems Design, Development, Testing, Implementation & Documentations.
• Developed various PL/SQL packages, stored procedures and triggers.
• Followed defined DBA methodologies when possible and to make efforts to re-use and share developments those packages developed at server.
• Implemented Database Backup/Recovery strategies.
• Oracle Database security, creation of users, creation and assignment of roles, analyze space requirements and maintain table spaces, creation and maintenance of tables and indexes.
• Database Backup (Online Backup, Physical Backup) and recovery using Amdocs' tools.
• Involved in Physical Backup and Logical Backup including full backup, control file backup, partial On-line and Off-line backups using shell scripts and Export/Import utility
• Written shell scripts for automating various database administration tasks.
• Good working knowledge of Amdocs tools like creofa, cia, Tiger.
• Coordination with Oracle Support, developers, testers and functional teams (CC, Integration and CORE).
Professional Experience
Oracle DBA developer, Israel
March 2007 – January 2008
• Projects for John Bryce, Israel
• Ensure database availability, reliability, security, and connectivity
• Administer privileged accounts
• Create/delete/modify DB user accounts and access privileges
• Monitor health (table space size, error logs, queue logs, etc) of single node and RAC Systems
• Track/Analyze database performance against the metrics
• Perform Dump datasets
• Run DB maintenance scripts as provided by Level 3/PMO
• Rebuild indexes
• Troubleshooting/repair of DB's within skill level authority scope and per Level 3/PMO direction
• Troubleshoot - Detect and resolve database performance concerns
• Restore/Backup - Recover individual tables or entire database as necessary (data) Professional Experience
Freelancer, Israel
SQL DBA, Oracle DBA
February 2002 – November 2005
• Support and development Projects on SQL Server 2005 and Oracle
• Support and development Projects on MS Access and VB6
• Database, SQL Performance issues – work with application teams to identify query problems
• RMAN – perform backups, restored/cloned databases from backup.
• Release Management – Coordination of changes between business team and DBA, application of scripts, upgrading applications, review logs for errors, work with developers to clean up errors.
• Clone databases from client dumps
• Monitoring and auditing database operations. Performing recovery procedures from system crashes
Education and Certifications
• 2017 Exadata training
• 2017 BigData Architect at John Bryce College.
• 2016 Certificated MongoDB DBA
• 2007-2008 Graduated MASTER DBA in ORACLE 9i/10g and MS SQL Server at John Bryce College.
• 2002-2004 Advanced study to bachelor's degree at Hadassah College, Jerusalem.
• 1997 Course "Microsoft Office (Word, Excel, Access, and PowerPoint)".
• 1998 Course “Microsoft SQL Server 7.0”
• 1998 Database Management course at Odessa State Academy, Ukraine
Contact this candidate