Candidates About

 

Alla Tsitsior 

EDUCATION           

Completed Canadian Securities Course and CPH exam.

Master degree in Science (Computer Science). Area of specialization: Artificial Intelligence (NLU). University of Manitoba, Canada

Bachelor (Honors) degree in Computer Science.  University of Manitoba, Canada

 

TECHNICAL SKILLS SUMMARY

WMware 5.5, MS SQL Server, MY SQL, Oracle 6,7, 8, 9i, 10g, 11g, 12c, ASM, RAC, Data Guard,  Oracle Cloud, OEM GRID, Sun Solaris, Linux, HP-UX, AIX ,  Oracle Exdata, Oracle ERP 10.7- 11i,  SAP, 9iAS, SQL, PL/SQL, SQL Loader, SQLNET, NET8, C, PRO-C, XML, VB,   Windows, HA Oracle Sun Cluster 2.2 & 3.1), Veritas  for Oracle HA,  OVM 2.X, OVM 3.X, Replication (Quest Shareplex, Data Mirror, Oracle snapshots, AQ, Streams),  AAA Radius, Backup and Recovery  ( RMAN, BMC SQL BackTrack,  Networker,  ADSM,  Netbackup),  SAN (Hitachi &EMC), EMC  DMX, EMC Timefinder, LDAP (SiteMinder), Unix shell scripting,  Perl,  Autosys, OMS, BMC Patrol, REMEDY, BB, DB Artizan, TOAD,  PL/SQL Developer, Logical and Physical Data Modeling (ERWIN, Discoverer/Designer), Logical and Physical Database Design, Data Warehousing  (ETL- Informatica), Cloud, BI and Analytics, Capacity Planning,  Project Management, Inconcert (Form Flow), Delrina Forms, SAP Crystal Reports, Pascal, Fortran V & 77, PL/1, LISP, C, Motif Gui,  MS Access

 

SCIENTIFIC POSTER PRESENTATIONS

Aronsky D, Jones I, Tsitsior A, Hubbard G, Slusser T, Zhou C. Forecasting Emergency Department Diversion with a Bayesian Network: A Prospective Evaluation. AMIA Annual Symposium 2009 Onsite Program (page #73)

 

 

EMPLOYMENT

5/2010-Present

Virtual Citadel (formerly BroadRiver Communications) –Senior Oracle DBA

Provide database technical evaluation and recommendation on database design and architecture, integration and development, database high availability solution, database replication architecture, database backup, disaster and recovery strategies, grid computing and cloud management, database monitoring and management, performance tuning, database audit and security compliance and daily database operation and maintenance.

·         Architectural design, development, implementation, support and maintenance of Virtual Citadel OLTP, Data Warehouse and SAP applications

·         Installation of Oracle 11g/12c software, creation of Oracle RAC and Non RAC databases on AIX, Sun Solaris Unix, Linux environments, Exadata

·         Tune and monitor Disaster Recovery procedures  and Backup and Recovery using RMAN,  Data Guard, and Netbackup

·         Database tuning, SQL statement tuning,  application and system tuning using UNIX/Linux system monitoring utilities, shell scripts and GRID

·         General troubleshooting of problems involving the Oracle infrastructure

·         Maintenance, upkeep, safety and integrity of databases including RAC  in 24/7 environment in Unix/Linux/Exadata environments

·         Provide primary support, maintenance, monitoring, and troubleshooting for all database issues including 11g/12c RAC, Data Guard, Golden Gate replication and GRID production databases

·         Patching, database upgrades and migrations

·         Database and Virtual Citadel applications testing

·         Oracle 11g/12c databases patching and upgrades, and data center migrations

• Capacity planning and management 
• Creating and implementing Disaster Recovery and business continuity best practices
• Evaluation of database standards and compliance in Virtual Citadel database environments  for implementation of data governance best practices
• Participation, and successful completion of Virtual Citadel internal and external audits for HIPAA, PCI-DSS, SOX and CJIS(government cloud)
• Analysis and evaluation of existing database controls and alerts; and design and implementation of enhancements to the existing framework

·         Provide primary support and troubleshooting for all database issues

·         Evaluate and recommend upgrades;  new database tools and technologies as appropriate for the enterprise.

 

7/2009 -4/2010

New York Life Insurance - Sr. Oracle DBA/Consultant

Design, development, implementation, support and maintenance of  NYL applications on  Oracle 10G  in Sun/Solaris environment

 

·         Installation of Oracle 10g software, creation of Oracle databases on Sun Solaris Unix environments

·         Tune and monitor Disaster Recovery procedures  and Backup and Recovery using RMAN and Data Guard, and Netbackup

·         Database tuning, SQL statement tuning,  application and system tuning using UNIX system monitoring utilities, shell scripts and GRID

·         General troubleshooting of problems involving the Oracle infrastructure

·         Maintenance, upkeep, safety and integrity of over 100 databases including RAC  in 24/7 environment in Windows and Unix environments

·         Provide primary support, maintenance, monitoring, and troubleshooting for all database issues including 10G RAC, Data Guard, Streams and GRID production databases

·         Database and New York Life applications testing

·         Oracle 10G RAC, Data Guard , Streams  and GRID databases patching and upgrades

• Capacity planning and management 
• Evaluation of database standards and compliance in NYL database environments  for implementation of Data governance best practices
• Participation, and successful completion of Database  group internal and external audits
• Analysis and evaluation  of existing database controls and alerts; and design and implementation of enhancements to the existing framework
• Installation, configuration, support and maintenance of BMC Discovery, Event Manager and Performance Management(Portal) Oracle based products

 

6/2008 – 10/2008 

Air2Web Communications - Sr. Oracle DBA/Consultant

·         Installation and configuration of 10GR2 RAC multi-node clusters on Sun Solaris using Veritas Storage Foundation 5.2 for Oracle and ASM on Hitachi SAN storage. 

·         Physical Data Guard installation , configuration  and creation  for 10G Primary RAC to Standby RAC for Disaster Recovery

·         Oracle 10G to 11G single instance and RAC DataGuard migration

·         Installation and configuration of 11G RAC and single instance databases on Sun Solaris using Veritas and ASM

·         Support, maintenance, monitoring, tuning and performance optimization of Oracle 9i , 10GR2 and 11g RAC production and test databases, 10G and 11G RAC Data Guard production , test databases and applications

·         Define, setup, tune and monitor HA and backup and recovery procedures for databases including Disaster Recovery including RMAN and 10G and 11G Data Guard in Sun Solaris RAC environments

·         10G RAC and 11G  database patching, upgrades, and migrations from ASM to Veritas Storage Foundation 5.2 for Oracle

·         Diagnose and debug complicated performance, connectivity, security issues involving critical applications

·         9iRAC, 10G and 11G RAC Database and Applications administration and monitoring using Unix shell scripts and OEM.

·         Install , configure, and maintain GRID Control for 10G and 11G RAC and single instance production and development environments

·         Provide primary support and troubleshooting for all database issues

·         Capacity planning and management

• Create and manage database policies, procedures and standards including Data governance
• Consult less experienced department personnel to help develop their database skills  
• Evaluate and recommend upgrades;  new database tools and technologies as appropriate for the enterprise.

 

02/2007 – 12/2007

Vanderbilt University Medical Center - Sr. Oracle DBA / Architect

Analyze, design, develop and implement ‘Forecasting Emergency Department Diversion with A Bayesian Network’ real-time application in Oracle 10G RAC-Linux environment to track and avoid patient diversions in Vanderbilt Medical Center Emergency Department.

·         Research, analyze, and define system specifications for ED Diversion application

·         Evaluate DataGuard, Oracle Streams, and Oracle AQ replication technologies as a potential solution for data integration for multiple Vanderbilt Medical Center Oracle and other source systems to provide historical and real-time medical patient data in the ED Diversion Oracle database.

·         Develop ETL flows, design logical Data Warehouse architecture and data model, implement physical Data Warehouse design (schema, indexes, partitions, etc.) for ED Diversion application

• Design and create logical and physical data models of a new integrated database that will be populated with one year historical medical patient data and real-time medical patient data from multiple data sources.
• Design, develop and implement Data Governance framework for the new database
• Design, develop and implement ED Diversion application software to generate historical and real-time application data in Vanderbilt Medical Center production 10G RAC Data Warehouse and OLTP environments
• Create ED Diversion views and PL/SQL scripts for easy and fast access  to the new database
• Perform database and applications tuning, and troubleshoot performance issues  using OEM 10G  and Oracle PL/SQL developer
• Create Forecasting ED diversion application design and system documentation
• Create an easy to understand testing framework. 
• Participate in technical architecture and database design review committees to address new database standards compliance with VUM standards

 

09/2005-12/2006

T-Mobile -  Sr. Oracle DBA/Consultant

Support and maintenance of T-Mobile AMDOCS billing applications on Oracle 8i and 9i, 10G HP-UX  environment:

·         Installation, configuration, upgrade and migration of Oracle 8i and 9i, 10G RAC   and Timesten databases  in development, test and training environments

·         Support, maintenance, monitoring, tuning and performance optimization of Oracle 8i and  9i VLDB (13T+)  (with Oracle Partitioning feature) databases  and Timesten databases and  AMDOCS billing applications environments

·         Support, maintenance and monitoring of  Oracle9i  DataGuard databases, database replication using  Oracle Streams, and  migration to 10G RAC.

·         Refresh/clone of AMDOCS billing test and development environments from production environments  using SQL Loader

·         Define, setup, tune and monitor  backup and recovery procedures for databases using RMAN

·         Assist developers with database and SQL query design and tuning and provide end-user support

·         Diagnose and debug complicated performance, connectivity, security issues involving critical billings applications

·         Participate in an valuation and implementation of  OEM 10G Grid in full OMS mode to control and manage enterprise billing applications and databases

·         Database and Applications administration  and monitoring using Unix shell scripts  and OEM 10G

·         Integration of Oracle with third-party replication solutions such as : Data Mirror

 

 

 

06/2004-09/2005

Nextel - Sr. Oracle DBA/Consultant

Design, development,  implementation, support and maintenance of  real time Engineering applications and Billing Appliactions on  Oracle 8i, 9i and 10G, in Sun/Solaris , HP –UX and EMC environment

·         Installation, configuration, upgrade and migration of Oracle 8i ,9i and 10G databases, and Quest Shareplex 4.x and 5.0 replication software

·         Support, maintenance, monitoring, tuning and performance optimization of Oracle 8i , 9i & 10G VLDB  with Oracle partitioning feature databases and  applications replication environments

·         Evaluate current business processes technical requirement and assist in review and evaluation of data delivery/capture technologies to achieve innovative computerized solutions to increase productivity and enhance database interface capability, data warehousing, retrieval, and reporting.

·         Technical design, architecture and development of data warehouse requirement. This includes implementing new systems, enhancing legacy systems, and integrating data environments

·         Set up, maintenance and support of applications replication (Shareplex 4.x and 5.X) environments

·         Assist developers with database and SQL query design and tuning and provide end-user support using TOAD and OEM tools

·         Set up Oracle 9i XDB development environment and assist developers with XDB apps performance evaluation , tuning and optimization

·         Assist in AAA Radius Servers configuration and Radius queries development and execution

·         Diagnose and debug complicated performance, connectivity, security issues involving critical apps

·         Database and Applications administration and monitoring using Unix shell scripts

·         Evaluation of new Oracle technology (10G Rac), and integration of Oracle with third-party applications

·         Design and set up new ED development/test lab consisting of clustered multiple test environments on Sun V490s, Cisco 9216is switches, Hitachi SAN storage, and Veritas 4.0 Foundation for Oracle HA

 

 

12/2003-03/2004

BCGI - Sr. Oracle DBA/Consultant

Project Lead/Sr. DBA on upgrade/migration of customized telecom applications from Sun Fire 10k, Solaris 6, Oracle 8.1.6, HA Oracle Cluster 2.2, EMC Timefinder 8730s environment to Sun Fire 15k, Solaris 9, Oracle 9.2.0.4. EMC DMX 8000, HA Oracle Sun cluster 3.1 environment.

·         Creation of 9i migration/upgrade plan for 10 databases from production Sun Fire 10k environment to new Sun Fire 15k Environment

·         Upgrade and migration of Oracle 8.1.6 databases from 10k to Oracle 9.2.0.4 on 15k using EMC Timefinder and DMX 8000

·         Patching Oracle 9.2.04 using new Opatch utility

·         Analyze current production environment, review applicable Oracle 9i features and create Oracle 9i features recommendation document

·         Test and implement new Oracle 9i features:

o    Conversion to locally managed tablespaces

o    Automatic UNDO

o    Dynamic SGA

o    Spfile

·         Calculate/size memory for new production environment (Sun Fire 15k multiple virtual domains)

·         Perform Dynamic Memory testing on Sun Fire 15k with Oracle 9i DISM and ASYNC I/O

·         Configure Oracle 9.2.0.4 HA Oracle Sun cluster 3.1 environment on Sun Fire 15k and perform HA testing with Unix SAs

·         Assist with troubleshooting existing production environment performance problems

 

 

09/2002-12/2003

Intercall - Sr. Oracle DBA/Consultant

Support and maintenance of billing applications and SAP on Oracle 8i and 9i, 9iAS in Sun Solaris and Red Hat linux, environments:

·         Installation, configuration, upgrade and migration of Oracle 8i & 9i  databases and customized applications

·         Support, maintenance, monitoring, tuning and performance optimization of SAP in Oracle 9i environments

·         Support, maintenance, monitoring, tuning and performance optimization, space management, partitioning maintenance, security set up and auditing, cloning, backup and recovery ( RMAN and Networker), and capacity planning of Oracle 8i and 9i databases

·         Determine and implement best practices for Oracle setup, monitoring, backup and recovery, ETL procedure, High-Availability and Disaster Recovery, installation, tuning, security and auditing

·         Evaluate current business processes technical requirement and assist in review and evaluation of data delivery/capture technologies to achieve innovative computerized solutions to increase productivity and enhance database interface capability, data warehousing, retrieval, and reporting.

·         Technical design, architecture and development of data warehouse requirement. This includes implementing new systems, enhancing legacy systems, and integrating data environments

·         Perform production Data Marts and Data Warehouse Loads using ETL tools (Iformatica)

·         Set up, maintenance and support of applications replication (snapshots and advanced queuing) environments

·         Assist developers with database and SQL query design  and tuning using TOAD and provide end-user support

·         Diagnose and debug complicated performance, connectivity, security issues involving critical apps

·         Database and Applications administration  using Unix shell scripting and Perl, and BigBrother monitoring tool

·         Evaluation of new Oracle technology, certification of new hardware and storage (SAN), integration of Oracle with third-party applications

 

05/2001-08/2001

McKinsey & Co - Oracle Apps DBA/Consultant

Support and maintenance of 24x7 Oracle Applications 11.03 and 11i and Oracle 8 & 8i databases in AIX UNIX environment:

·         Installation, configuration, upgrade and migration of Oracle 7, 8 & 8i databases and application software

·         Support, maintenance, tuning, space management, cloning, backup and recovery (SQL Backtrack and ADSM), and capacity planning of Oracle 8 & 8i databases

·         Support and maintenance of Apps 11.03 and 11i(patch application, concurrent manager, forms server, web server, load balancing, forms, jobs, reports, printer setup, flex fields, logs)

·         Maintenance and support of Oracle Apps replication (snapshots) environments

·         Assist developers with database and SQL query design and tuning and provide end-user support

·         Troubleshoot database and Apps 11.03 and 11i performance issues: network, SQLNET/NET8, middle tier, concurrent manager, forms

·         Database and Applications administration using Unix shell scripting  and OEM

 

 

08/2000-12/2000

Schonfeld Securities - Oracle Consultant/Project Manager 

 Project management of a historical Oracle 8i data warehouse system for day-trading applications and quantitative research:

·         Gather and analyze business and user requirements, logical and physical data modeling (Erwin),

·         Logical and physical database design (indexing strategies and physical partitioning design)

·         Database capacity planning, resource (cpu, disk, memory) usage and forecasting

·         Hardware evaluation/selection (Sun, HP, EMC), design of backup/restore and disaster recovery solutions

·         Design ETL processes to optimally load detailed and history trading data

 

 

04/1998-08/2000       

Merrill Lynch - Oracle Financials DBA/Consultant

Support and maintenance of Investment Banking 24x7 Oracle 7, 8 &8i databases and Oracle Applications on Sun Solaris platform

·         Installation, configuration, support and maintenance of Oracle 7, 8 and 8i databases and Apps (10.7, 11& 11i)

·         Database and software upgrades (Y2K upgrade, Oracle 7 to 8 and 8i migration);

·         Upgrade Applications 10.7 to three-tier 11.03 and 11i, patch application

·         Logical and physical data modeling, logical and physical database design Perform monitoring, tuning and performance optimization, space management, cloning, backup and recovery (RMAN), capacity planning, security management and auditing

·         Implement, support and maintain replicated environments (snapshots and advanced replication)

·         Determine and implement best practices for Oracle setup, monitoring, backup and recovery, installation, tuning, security and auditing

·         Implement, support and maintain High-Availability and Disaster Recovery solutions (Veritas HA Cluster)

·         Assist developers with database and SQL query design and tuning and provide end-user support

·         Troubleshoot database and Applications performance issues: network, SQLNET/NET8, web, forms and reports servers, concurrent manager, forms, batch jobs, reports

·         Unix shell scripting for database and Applications administration

·         Design and implement centralized emailing and paging event notification system using BMC PATROL monitoring tool for 40 Oracle 7 & 8 databases and apps on Sun Solaris and Windows NT platforms.

 

 

07/97-03/98            

PFIZER - Oracle DBA/Consultant

Project management, support and maintenance of 24x7 Oracle 7 Financial Apps on Sun Solaris on AIX platforms

·         Installation, configuration,  upgrade and migration of Oracle databases (Oracle 7 and 8) and Applications

·         Support, maintenance, monitoring, tuning and performance optimization of customized apps

·         Monitoring, tuning and performance optimization, space management, cloning, backup and recovery (SQL BackTrack), capacity planning, security management and auditing  of Oracle 7 environments

·         Set up, maintenance and monitoring of High-Availability and Disaster Recovery Solution: Oracle Standby/DataGuard Databases

·         Assist developers with database and SQL query design and tuning and provide end-user support

·         Troubleshoot database and apps performance issues (i.e. performance, connectivity, security, etc)

·         Unix shell scripting (Korn Shell) for database and Applications administration

 

 

04/95-07/97                  

XEROX (Ontario Legal Aid Plan)  - Sr. Oracle DBA/Consultant

Installation,  support and maintenance of fifty one distributed/replicated Oracle 7 databases, client/server Inconcert (Form Flow) applications, and a data warehousing application.

·         Logical and physical data modeling, logical and physical database design

·         Installation, configuration, upgrade and migration of Oracle databases (Oracle 7 and 8)

·         Installation, upgrade, migration, tuning, support and maintenance of client/server applications software (Inconcert, Delrina, Crystal Reports)

·          Monitoring, tuning and performance optimization, space management, cloning, backup and recovery (shell scripts and Networker), capacity planning, security management and auditing

·         Determine and implement best practices for Oracle setup, monitoring, backup and recovery, High-Availability and Disaster Recovery, installation, tuning, security and auditing

·         Assist applications developers with SQL query design and tuning and provide end-user support

·         Trouble-shoot database and applications performance issues

·          Unix shell scripting (Korn shell) for database and applications administration

·         Design and implementation of scripts/tools to help rollout and manage Oracle in a global distributed environment  (i.e. design, implement and maintain 24x7 server and database monitoring and event notification system by customizing BMC Patrol software)

·         Evaluation of new Oracle and third-party technology, certification of new hardware and storage, integration of Oracle with third-party applications

·         Mentor and supervise junior DBA, develop and implement documentation and coding standards

 

 

01/95-03/95

Bell Sygma – Oracle DBA

Port Ingres database applications to Oracle 7

·         Install and configure ORACLE 7 databases on HP and Sun platforms

·         Design, develop and implement an automated parser software to port Ingres applications to Oracle 7

 

03/94-12/94

Toronto Stock Exchange –Designer/ Analyst

Project  management of  TSE Market Surveillance Oracle 6 & 7 (SCO Unix) client/server applications using DMR project methodology.

·         Gather and analyze user requirements

·         Logical and physical data modeling, logical and physical database design

·         Design, develop, implement, support and maintain Oracle 6 & 7 client/server applications  (Motif GUI, C, Pro-C, SQL*FORMS)

·         Develop and implement documentation and coding standards