Database Engineer Us
OBJECTIVE: Database Engineer & Administrator
DBA QUALIFICATIONS:
Engineer & Administrator of Decision - Support, Data-Warehouse & OLTP Type Databases
- Strong knowledge & experience in all phases of database design, implementation and
maintenance with Oracle (8, 9, 10g & 11g on Sun Solaris & Linux Large), Microsoft
SQL Server (2000, 2005 & 2008) & Sybase RDBMSs;
- Strong experience in database Performance Tuning and troubleshooting of complex
database problems;
- Strong experience in SQL Performance Tuning;
- Vast Experience with all Proprietary (OEM, SQL Developer, SSMS, SSIS, SQL Profiler, Sybase Central,etc.) and Third Party (Toad, Team-Quest, BMC Patrol, Tivoli, Guardium, etc.) DB Management, Performance & Monitoring tools for Oracle, MSSQL & Sybase databases.
- Strong Experience with database Migration from Older Versions of Oracle & MSSQL to
Newer versions within the same RDBMS platform;
- Strong Experience of Database Migration from Oracle to MSSQL platform via Microsoft
SSMA;
- Strong experience in design & implementation of CUSTOMIZED Enterprise-wide solutions for database maintenance & monitoring;
- Strong knowledge & experience in design and implementation of databases Replication
Solutions for High-Availability Applications and Disaster Recovery purposes via database
Streams, Mirroring, Log-Shipping, etc;
- Strong knowledge & experience in developing SQL Scripts & Stored Procedures
in Oracle, MSSQL & Sybase environments;
- Strong Experience in developing Unix Shell, AWK, Windows Batch & Windows PowerShell scripts for database administration;
- Strong Experience in Physical & Logical Database Modeling utilizing
Erwin, Cayenne (COOL) DBA Case Tools;
- Significant experience with database jobs implementation & scheduling via Maestro & ESP software;
- Some experience with DB2;
PROFESSIONAL EXPERIENCE:
05-91 to Confidential 51 Madison Ave., New York, NY 10010
: Database Engineer & Administrator, Corporate Information Dept.
- Responsible for design, implementation and maintenance of several
Decision-Support, Data-Warehouse & OLTP type databases on Oracle, MSSQL &
Sybase platforms for New York Life Insurance Co.:
- Extensive interaction with customers in developing database requirements;
- Logical Database Design utilizing Erwin (currently) & Cayenne (in the past)
Case Tools;
- Physical Database Design utilizing Erwin & Cayenne Case Tools;
- Physical database implementation;
- Capacity planning;
- Database Replication (Streams, Mirroring, Log-Shipping);
- Database & SQL Performance Tuning & troubleshooting;
- RDBMS & Server upgrades;
- Database Migrations;
- Security Roles & IDs Implementation & Management;
- Development & implementation of DB Maintenance Procedures including
Backup & Recovery procedures, Partition Maintenance Procedures DB Consistency Checks, Database Reorgs, etc. via Unix Scripts, Windows
Scripts, SQL Scripts and utilization of Enterprise Management Database Tools;
- 24/7 Production support of large number of databases including space & performance monitoring, problem troubleshooting, etc;
- Responsible for development of custom Database Maintenance & Monitoring Enterprise-wide solutions.
: Programming Team Leader & Director, Financial Management Dept.
: DPL/I & Cobol Programmer, Financial Management Dept.
Confidential The Institute Of Fine Chemical Technology, Moscow, Russia
RESEARCH SUPERVISOR -- Physical Chemistry Department
- Lead the Scientific Project involving Numerical evaluation of Dirichlet Problem and Non-Linear Output Optimization
(System design in PL/1 & Fortran)
- Supervised one Laboratory Technician and two Graduate Students.