Galina Pritsker Email & Phone Number

New York, Ny, Us

MSSQL Server DBA

Charlotte, Nc, Us

Administered 35 SQL Server databases and multiple Oracle Instances of all systems related to the publishing process, as well as for external web pages. There were 800 daily users on these systems, and they were highly visible at all levels of the company; performance was paramount.-24/7 Oracle DBA Production support. Administrated an Oracle Title Management System and a Digital Asset Bank System that included Oracle Server 9i installation, configuration, performance tuning, RMAN, utilizing AWR on Oracle10G and production support on the UNIX platform.-Backup/restore/tar and Cloning of Oracle instances to QA/development environment. Tablespace management, database capacity planning and reorganization/gathering of statistics for tables/indexes, implementation of backup and recovery procedures, performance tuning using dictionary views-Implemented the database portions of 30+ web-based in-house developed .NET applications, utilizing CLR functions on the SQL Server database.-Worked with application developers to optimize schema design and query construction.-Migrated Oracle database to SQL Server 2005 for the Title Management System and all its applications and processes. Was a pioneer in implementing the migration using the Microsoft SSMA utility.-Provided 24/7 production/user testing/development database environment, including via remote access.-Created standard documentation for production deployment, monitoring and performance.-Converted sales force automation system based on Sybase 6.5, including merge replication, to Microsoft SQL Server 2000.-Created and managed all processes in Autosys Scheduling System for major Applications.-Actively participated as TAP (early beta tester) for Microsoft KATMAI (SQL Server 2008), converting one of the Simon & Schuster publisher databases -Implemented and monitored daily and weekly batch jobs, using AutoSys Scheduler, SQL DTS, and SQL SSIS packages. .

Responsible for division-wide AIX/SUN administration, architecture and design on various-sized RS6000's and SUN servers. Also responsible for data modeling, database logical and physical design and database administration for applications that run on these servers. These servers ran AIX 4.2.1, 4.1, 3.25, Solaris 2.6, Sybase SQL Server System 11.0.3, 10.0.2 and 4.92. Installed, configured and tested these systems in development environments prior to moving them into the production operations area. Turned over to operations customized support procedures for each server based on function of server and application. Provided 24/7 production support for hardware or software problems arising on these servers, including troubleshooting operating system issues, Sybase problems or any other subsystem issues. Implemented and maintained HACMP, DNS, NFS, TCP/IP, DataTools SQL Back Track, SYSBACK, and SYBASE SQL Server. Maintained the IBM MQseries and SNA Server. Run installations and upgrades of all operating systems and additional software and hardware on these servers. Wrote Korn shell and SQL scripts to automate ordinary system and database administration tasks. Used ERwin to generate database models and schemas. All changes to databases first made in Erwin model and then Erwin generated DDL is applied to the database. Wrote customized triggers that are held in the models. Wrote stored procedures for ordinary SA and DBA tasks. Responsible for determining and implementing referential integrity segmentation, indices, defaults, groups and domain types. Responsible for developing backup and recovery schemes, dbcc procedures, distribution of databases, automation of log dumps via transaction thresholds, and optimizing performance and tuning queries.

Developed and demonstrated Actuate reports to business area for High Yield, Portfolio, and Financial Systems. (Actuate allows to build new highly intelligent reports, which enable Fixed Income (FI) business users to generate online reports on a completely ad-hoc basis.) Report Object connected to various kinds of data sources, including Sybase Server, ODBC SQL engines, and flat files. Maintained and supported the Opportunity! System - a contact management and decision support system for the High-Grade Research sub-department of FI. This system was built on top of Lotus Notes. The user interface was built using Lotus ViP, integrated with the Lotus Notes database and SQL Server.Participated in and managed parts of a multi-team development project focused on reengineering of the core components of the Books-and-Records system and migration of the core databases to the RDBMS-based distributed client/server environment. The existing Tandem-based system processed ~200,000 complex (multi-update, multi-read) transactions per day. The re-engineered Dividend and Interest Calculation sub-system and the associated core databases (Securities Master, Trade History and Account Master) were built on Tandem’s massively-parallel Himalaya platform running Non-Stop SQL, with presentation logic and a subset of business rules implemented in PowerBuilder on Windows and NT front-ends. I led the design and development of the new “Subject-Area” SQL/MP databases and the implementation of the database access layer routines.As the primary Tandem DBA, I provided day-to-day support for a 60-GB Tandem SQL and Enscribe database production environment. This included scheduled maintenance of SQL tables and catalogs, development of new SQL tables and queries, resolution of production problems, management of application turnover requests, and maintenance of existing applications (e.g., Bond Buyer).

New York, Ny, Us

Worked as a member of the systems development/support team responsible for implementation and maintenance of the Tandem-based Consumer Collections system. The Consumer Collections system enabled client companies to automatically collect payments from their customers’ bank accounts through the Automated Clearinghouse system. Participated in a number of new developments projects, from requirements analysis to design, implementation and system testing, and provided ongoing support to several key modules of the existing system. Involved in a process of creating and support the Repository database for Business Object.