Alexandra Syssoyeva

System Database Administrator MS SQL Server and Oracle

ac19sz@r.postjobfree.com 613-***-**** https://www.linkedin.com/in/AlexandraSyssoyeva67619/

Competent Database Administrator and Database Developer - MS SQL Server and Oracle with in-depth experience in database support and development. Deep knowledge of RDBMS. Practical knowledge in backup and recovery processes and activities. Ability to identify problems and implement corrective processes. Task-oriented, focused, responsible and independent as well as a team player. Passionate about databases and new technologies. Willing to relocate.

Qualifications Summary:

Planning, installation, configuration, and maintenance of multiple RDBMS platforms (Oracle 7/8/9i, MS SQL Server 2000/2005/2008/2008R2/2012, MySQL (4.x, 5.x)).

Design and implementation of backup plans and disaster recovery strategies using various types of backups.

Enterprise infrastructure capacity planning.

Support of application development databases.

Provided 24/7 on-all support for production databases on a rotation basis.

Production databases administration and performance tuning.

Design of replication process and support of reporting databases.

Logical database design and physical schema implementation.

Development and support of the security model.

Maintenance of developer environment.

Professional Experience

Reference # 1 (volunteer project)

Salesforce data loading Mar.2017 – present

Export data from CIVI CRM and load into Salesforce org.

Learned standard referential links in CIVI CRM and schema customization.

Developed SQL queries to extract the data.

In co-operation with Salesforce administrator loaded the data into Salesforce org.

Utilized MySQL workbench and Salesforce data loader.

Reference # 2(volunteer project)

Database ongoing support and application automated testing ITO 2.0.

Ottawa

Apr.2017 – present

Configured environment for the project (installed Java8, Eclipse, Maven, Tomcat, MySQL )

Analyzed the database schema (MySQL),

Added new objects to the database, defined referential integrity.

Developed Selenium scripts for automated testing.

Reference # 3

Ulba Metallurgic Plant

Ust-Kamenogorsk, Kazakhstan

Dec 1999 – Oct. 2015

Project 1: ERP System Database Administrator MS SQL Server 2003-2015

The enterprise ERP system included 3 production databases, a reporting database and 3 staging databases for development and testing. 350+ active users in production. The size of the production databases varied from 100 GB to 700 GB.

As a database administrator was responsible for 24/7 support of the ERP databases. Performed every day activities on production databases for support of the industrial level data quality, performance, resources utilization, transactions reliability. Designed and maintained staging databases for application development and testing.

Designed and implementation of backup plan and disaster recovery strategies.

Business process analysis and database cleanup which lead to 15% improvement of database performance.

Migration from M S SQL Server 2000, 2005, 2008 to MS SQL Server 2012.

Led the application development team on development of efficient database queries.

Enterprise infrastructure capacity planning.

Installation, configurations, application of patches and service packs for MS SQL Server.

Documented of known problems and solutions.

Followed-up with the stake holders.

Achievements:

Designed and implemented of backup plan and disaster recovery strategies. Recovery of databases to the point of failure. Database migration. Scripts development for database backup automation, cloning, and database administration (indices reorganization, update statistics). Troubleshooting of long running queries.

Technologies and tools: MS SQL Server 2000/2005/2008/2008R2 Standard Edition. Server Management Studio (SSMS). SQL Server Profiler to monitor database and users activity, Dynamic Management View (DMV) analyze long running queries. SQL Server Agent. Windows System Monitor to find CPU and memory utilization.

Project 2: Database Administrator and Designer MS SQL Server 2006-2015

The system verified identity information and granted access to the food kiosks for the plant employees. The information was uploaded to the plant ERP for billing.

As a database designer was responsible for logical and physical database design and implementation. As a database administrator was responsible for 24/7 support of the OLTP databases, and backup and recovery plan.

Logical and physical database design and implementation.

Designed and implementation of the backup plan and disaster recovery strategies.

Database performance monitoring and tuning.

Developed and supported of the security model.

Achievements:

Definition of the detailed database design including tables, indexes, views, constraints, triggers, stored procedures. Development, implementation, and periodical testing of the backup and recovery plan for the databases. Monitoring of available disk space on the database server and remediation. Management of user privileges. Writing database documentation, including enterprise data standards, data dictionary based reporting.

Technologies and tools: MS SQL Server 2005 Standard Edition. Server Management Studio (SSMS). SQL Server Profiler to monitor database and users activity, Dynamic Management View (DMV) for analysis of long running queries. SQL Server Agent. Windows System Monitor to find CPU and memory utilization.

Project 3: ERP System Database Administrator Oracle 1999-2007

The ERP system included production database (150+ GB, 100+ active users, 24/7), standby disaster recovery database and a test database for development and testing.

Planned installation, configuration, and maintenance of Oracle environment.

Developed of the backup and recovery strategy.

Optimization and tuning of SQL queries.

Maintained of system security.

Development and maintenance of the standby databases.

Supported 24*7 production support and solved all kinds of critical problems.

Achievements:

Installation, configuration, and maintenance of Oracle 7 / 8i & 9i databases and maintenance of patch level. Design of backup and recovery strategy. Point-in-Time recovery. Development of automation scripts for backups and cloning. Daily maintenance activities like analysis of the tables/indexes and monitoring of their growth. Management of user accounts and privileges to access the database. Documentation of known problems and solutions.

Technologies and tools:

Oracle 7.3/8i/9i, SQL*Plus, SQL Loader, Oracle Enterprise Manager, SQL Navigator, TOAD for Oracle. Oracle performance tuning using Explain Plan, SQL Trace, TKPROF and STATSPACK.

Project 4: Database Administrator and Designer 2005-2015

Ongoing development support of the Internal Portal Information System. The system served enterprise wide historical data to various stakeholders.

Data modeling, logical and physical databases design.

Performed Day-to-Day DBA tasks.

Planning, installation, configuration, and maintenance of multiple RDBMS platforms.

Development of the backup and recovery strategy.

Maintenance of developer environment.

Created and maintained users and groups with proper security through Profiles, Roles, Privileges and Auditing.

Achievements:

Logical and Physical Databases Design on various platforms: Oracle, MS SQL Server and MySQL. Creating SQL objects (tables, indexes, views, stored procedures, user defined data types and functions). Performing Day-to-Day DBA tasks - checking databases availability and database logs, maintenance of indexes and re-creating table partitions, management of resources on servers, 24/7 on-call production databases support. Design and implementation of backup plans and disaster recovery strategies using various types of backups and writing scripts for these backups.

Technologies and tools:

MS SQL Server 2000/2005/2008/2008R2, Server Management Studio (SSMS). SQL Server Profiler, Dynamic Management View (DMV). SQL Server Agent. Windows System. Oracle 8i/9i, SQL*Plus, SQL Loader, Export, Import, Oracle Enterprise Manager, SQL Navigator, TOAD for Oracle. Oracle performance tuning using the "Explain Plan" statement, SQL Trace, TKPROF and STATSPACK. Application Software Apache Web Server, IIS, HTML, PHP.

Education AND Professional Development

Master degree in Mathematics and Information Science from East Kazakhstan State University, Ust-Kamenogorsk, Kazakhstan

Bachelor in Information Systems Design from East Kazakhstan State Technical University, Ust-Kamenogorsk, Kazakhstan.

Administering a Microsoft SQL Server 2000 Database, Microsoft Certified Education Center Novosibirsk, Russia.

Programming a Microsoft SQL Server 2000 Database, Microsoft Certified Education Center Novosibirsk, Russia

Oracle8: Database Administration, Oracle University, Novosibirsk, Russia.

Oracle8: Backup and Recover Workshop, Oracle University, Novosibirsk, Russia.

Oracle8 Network Administration, Oracle University, Novosibirsk, Russia.

Oracle8: Enterprise DBA Part 2 Performance and Tuning, Oracle University, Novosibirsk, Russia.

Algonquin College GAS -English for Academic Purposes Level 1, 2, Ottawa, Canada, 2017

Contact this candidate