Database Architect2013 - PRESENTValmarc Corporation
Technologies: Cloud, ShellScript, Linux, Data Modeling, Toad, Python 2, Database Design, PL/SQL, Relational Databases, SQL, Oracle, MySQL
- Designed a database for a Brand Protect system including a logical data model and physical data model.
- Developed MySQL and Oracle stored procedures and functions. Worked constantly in SQL optimization.
- Migrated a database from MySQL to Oracle including the stored procedures code.
- Developed data load scripts using Shell and Python.
- Implemented high-availability solutions for both Oracle (Active DataGuard) and MySQL (replication).
- Designed and developed a geolocation clustering solution based on DBSCAN algorithm using Python and PL/SQL.
- Designed and developed a document store within MySQL database.
- Implemented backup and recovery strategy using RMAN (Oracle) and MySQL Enterprise backup (MySQL).
Database Architect2010 - 2013MicroBilt
Technologies: Data Modeling, Toad, SQL Server 2016, T-SQL, Database Design, PL/SQL, Relational Databases, SQL, Microsoft SQL Server, MySQL, Oracle
- Designed databases for a credit scoring and payment processing application including the logical data model and physical data model.
- Developed PL/SQL stored procedures and packages; also included T-SQL stored procedures.
- Implemented a high-availability solution using Stream replication (Oracle) and Master-Master MySQL replication.
- Developed client reports using XML queries.
- Implemented an archiving process utilizing Oracle partitioning.
Database Administrator2008 - 2010MathWorks
Technologies: ShellScript, Linux, T-SQL, Relational Databases, SQL, Microsoft SQL Server, MySQL, Oracle
- Designed and implemented database physical and logical structure for Oracle, SQL Server and MySQL databases.
- Developed SSIS packages and SQL Server/MySQL stored procedure and triggers.
- Designed and implemented an Oracle RAC database.
- Developed and designed MySQL and SQL Server replications.
- Built backup and recovery strategy and procedures for a MySQL databases.
Senior Database Administrator2003 - 2008Manhattan Associates
Technologies: ShellScript, Linux, Toad, PL/SQL, Relational Databases, SQL, IBM DB2, Oracle
- Designed and implemented database physical structures.
- Designed logical data structures and provided support for back-end development.
- Developed back-end application components for a web-based information system using PL/SQL and Perl.
- Implemented database performance tuning and SQL optimization.
- Installed a database monitoring system using Oracle Enterprise Manager Grid Control.
Database Consultant2000 - 2003GRT Corporation
Technologies: ShellScript, Linux, PL/SQL, Relational Databases, SQL, Microsoft SQL Server, IBM DB2, Oracle
- Installed, configured, and supported databases under Oracle, DB2, and SQL server.
- Performed database tuning and SQL tuning.
- Configured cluster databases under DB2 EEE, Oracle RAC, and SQL Server cluster.
- Developed and implemented backup and recovery strategies.
- Built stored procedures.
Database Administrator1996 - 2000Central Bank of Russia
Technologies: ShellScript, Linux, Relational Databases, SQL, Oracle
- Installed and upgraded Oracle RDBMS.
- Developed backup and recovery strategies and procedures.
- Configured and maintained an Oracle Parallel server cluster.
- Performed database and SQL tuning.
- Implemented proactive database monitoring based on the HP OpenView EMP framework.