SUMMARY OF QUALIFICATIONS

• 20 years of overall IT experience, including 16-year experience with relational database management systems: Oracle, MS SQL Server, Sybase, Teradata, etc
• Sophisticated consultant experienced as a Database Engineer, Developer and DBA for complex business-critical applications; expertise areas include database support in distributed high availability services in healthcare, insurance, financial, telecommunications, government agencies and others
• Highly skilled in database support, monitoring, tuning and performance improvement, database analysis, system design, data modeling, conversion, data extraction, transformation and loading
• Very strong in SQL, PL/SQL, T-SQL programming, application development and shell / batch scripting
• Demonstrated analytical mentality, excellent problem solving and troubleshooting skills

CERTIFICATION

Oracle Certified Professional (OCP)

TECHNICAL SKILLS

Databases: Oracle 7/11g R2; MS SQL Server 7/2005; Sybase SQL 11.0 / ASE 12.0; Teradata 5.1.1; PostgreSQL; MySQL; DB2 UDB; MS Access; FoxPro
Languages: SQL, PL/SQL, T-SQL, COBOL, C, shell
Tools and Technologies:
Oracle: Application Server, OEM, RAC, ASM, DG, utilities, RMAN, tkprof, AWR, Developer Suite, APEX, etc
MS SQL, Sybase, Teradata, PostgreSQL, DB2, MS Access, FoxPro, Erwin, PowerDesigner, DBArtisan, Informatica, AutoSys, Quest Software, Nagios, MS Excel 
Operating Systems: Linux; Mac OS X;Windows; SUN Solaris; Compaq Tru64 UNIX; HP-UX; AIX

PROFESSIONAL EXPERIENCE

07/2008 – Current Confidential (Boston, MA)

Database Engineer 
Database support and system enhancement for the software development corporation
Technical Functions:

• Performs different scheduled and ongoing tasks, including, but not limited to database product installation, patching, database creation, user initialization and data export/import, deploying application or sandbox schemas as appropriate
• According to rotation schedule: performs all necessary database activities for the Ops team, Tier 3 support for the SOC and engineering support, when requested
• Monitors database upgrade progress during deployment process, responds in timely fashion to the raised problems, escalates issues appropriately when necessary; reports discovered bugs, uses ticketing system for task management
• Performs code review, acts as a primary responder for code change approval requests: validates structural integrity, data consistency and database security, raises concerns regarding potential implications; performs knowledge transfer, walking other members of the team through the whole database requirement review process
• Maintains a distributable library of the SQL, PL/SQL and shell scripts for diagnostics and administration purposes; continues working on enhancements to the code; modified existing sandbox management application code to be deployable and versioned like other database schemas
• Performs various development tasks: suggested and implemented the solution for the RAC environment using SCAN / service names and balancing algorithm in the application system instead of hard-coded data, wrote a shell script that uses a chain of possible SSH connections to execute any scripts/commands at the remote machine, and return results, created a customized code parsing tool to process the existing PL/SQL programs

Environment: Linux, shells, Oracle 11g R2, OEM, Data Guard, Datapump, Nagios, SVN, Perl, MySQL

12/2007 – 05/2008 Short-term projects (Boston, MA)
Database Engineer

Client: Confidential 
Oracle database tuning and performance improvement in datawarehouse environment
Technical Functions:

• Gathered required information from the client
• Analyzed existing database environment, reviewed related application code
• Verified a new-installed test database, reviewed space allocation and database capacity
• Performed data modeling and system configuration tasks
• Analyzed testing approaches and suggested baseline metrics using AWR, STATSPACK, tkprof, etc
• Developed performance improvement strategy: table/index partitioning, SQL/PL/SQL tuning, initialization parameters configuration, SGA/instance tuning (hit ratios, waits, locks, latches, etc)
• Created database scripts to implement the recommendations suggested by Oracle Corp

Client: Confidential
Enterprise database system support and enhancement
Technical Functions:

Performed support for multiple Oracle transactional/datawarehouse databases within Unix / Linux / Windows environment (production, testing and development)

• Wrote/modified shell scripts and batch files to implement database administration operations
• Implemented reverse engineering using ERwin, participated in conceptual design, logical / physical model design, database cleanup, performance improvement, scalability planning Performed extraction, transformation and loading data within enterprise database environment using external tables, stored procedures, functions, packages, SQL*Loader and integrating procedure calls with shell scripts
• Investigated and resolved related ETL process issues

Environment: Tru64, HP-UX, Linux, Windows XP/2000; shells, awk, Oracle 9i/10g, OEM, SQL*Plus, Export/Import, SQL*Loader, Control-M, ERwin, TOAD

12/2006 – 12/2007 Confidential (Waltham, MA)
Database Engineer

Data Warehouse / Data Mart development, implementation and maintenance

Technical Functions: Worked as part of a team and independently to design, develop solutions, based on complex business requirements; produced and provided deliverables to customers Performed extraction, transformation and loading data within data warehouse environment using stored procedures, functions, SQL*Loader, external tables, SQL and shell scripts, converting business requirements into technical specifications

• Fulfilled specialized market data analysis, developed and produced analytical reports and quarterly / annual statements
• Investigated and resolved issues related to ETL process, data staging and transformations before loading from multiple data sources
• Performed capacity planning, data conversion, performance tuning, and troubleshooting tasks
• Participated in system design, using methodologies based on various classification systems and models
• Developed and implemented various approaches of EDI transmission processing
• Developed customized applications (Forms, APEX) for database administration purposes and database access interface

Environment: Windows XP/2000; AIX, HP-UX, shells, Oracle 10g, Oracle 10g AS, Oracle 10g DS, SQL*Plus, utilities, APEX, MS Access, MS Excel, Informatica, TOAD

02/2006 – 12/2006 Client: Confidential (Windsor, CT)
Database Consultant

• Database support in production/QA/development environments, monitoring and maintenance of full application batch cycle for various business applications
• Performed system support of existing jobs (over 2000) and created new jobs in Autosys scheduling system for all types of environment
• Loaded business critical data from different external data sources into Oracle databases
• Worked on optimization, tuning and performance improvement for existing and created new SQL queries Wrote UNIX shell scripts to process large incoming files by implementing different file parsing and comparison algorithms Participated in multiple projects as a batch/database support and development resource
• Investigated and resolved all issues related to ETL process, fulfilled data analysis, conversion, performance tuning, and troubleshooting tasks
• Ran ad hoc reports and quarterly statements and delivered them to customers

Environment: Windows XP; Tru64 UNIX; Linux; SUN Solaris, shells, AWK, Oracle 9i/10g, OEM, SQL*Plus, SQL*Loader, TOAD

11/2005 – 02/2006 Client: Confidential. (Boston, MA)
Database Consultant

• Data Processor - customized verification and control system to load business critical data from different external data sources into Oracle database

Performed extraction, transformation and loading data into Oracle database using external tables, stored procedures, functions and SQL*Loader and integrating procedure calls with shell scripts Wrote UNIX shell scripts to process large incoming files implementing different file parsing and comparison algorithms Assisted in maintenance of database tables, performs space allocation, capacity planning, system configuration, import

• Configured initialization parameters for database performance tuning
• Investigated and resolved all issues related to ETL process, fulfills data analysis, conversion, performance tuning, and troubleshooting tasks
• Tested and deployed all components of Data Processor (PL/SQL stored procedures, functions, packages, triggers, SQL and shell scripts)

Environment: Windows XP; Tru64 UNIX; Linux; SUN Solaris, shells, AWK, Oracle 9i, SQL*Plus, OEM, SQL*Loader, Import

07/2005 – 11/2005 Client: Confidential (Hartford, CT)
Database Consultant

• Data Warehouse release migration support
• Performed new release migration in a timely manner having aggressive deadline
• Implemented system enhancements and changes in on-going business requirements, converting them to the technical requirement, following the established database standards and technical specifications
• Performed extraction, transformation and loading data into and from various databases using various ETL utilities and shell scripts
• As part of a team and independently developed, modified, tested, and deployed tables, indexes, views, triggers, stored procedures, etc
• Worked on optimization, tuning and performance improvement for SQL queries and views, collecting statistics, analyzing database objects
• Provided support for the application batch cycle in production, writes/modifies UNIX shell scripts, schedules and runs ETL jobs
• Performed support activities for developers and business users

Environment: Windows XP 2003; AIX 5.3; ksh, Teradata; Oracle; MS SQL; ERwin; Data Warehouse; COBOL; MS Excel; MS Access

03/2005 – 07/2005 Client: Confidential (Boston, MA)
Database Consultant

Database upgrade and support and application development for the Department’s Information SystemPerformed installation, configuring and support of Oracle 10g Application Server components (Infrastructure and middle-tier)

• Implemented Oracle database and applications upgrade to version 10g
• Performed space allocation, system configuration, backup, export/import
• Created and maintained databases, configures initialization parameters for database performance tuning
• Monitored the growth of the database objects for capacity planning
• Investigated and resolved all issues related to the transition during the upgrade process
• Fulfilled database analysis, data conversion, performance tuning, and troubleshooting tasks
• Wrote, modified, tested, and deployed PL/SQL stored procedures, functions, packages, and database triggers
• Performed all phases of application upgrade; recompiled, debugged, modified, tested, and deployed forms, reports, menus, and libraries; wrote/modified shell scripts and batch files to implement upgrade operations

Implemented reverse engineering using Oracle Designer, converting MS Access applications to Oracle

Environment: Windows XP/2000; HP-UX, shell, Oracle 8i/10g, OEM, Export/Import, Oracle10g AS, Oracle10g DS, Forms 6/10g, Reports 6/10g, Designer 9i, SQL*Plus, WEBUTIL, MS Access

09/2004 – 01/2005 Client: Confidential (Springfield, MA)
Software Developer
Application System support in both development and production environment for various business lines and products of Retirement Services, Life Insurance
Performed technical system support for specific business applications (Reflex, TRC, The Journey, etc)
As part of Bugs/Enhancements team and independently worked on code debugging, enhancements, and changes in accordance with on-going business requirements, following the established standards and technical specifications
Wrote, modified, tested, and deployed stored procedures and database triggers
Fulfilled various troubleshooting tasks: SQL tuning, system performance improvement, database analysis, and unit testing
Wrote functional and technical specification basing on software analysis information and the requirements gathered from business users 
Performed version control of applications and program units using Source Code Control System (SCCS)
Provided status reports to Project/Reporting Manager 
Environment: Windows XP; HP-UX; Sybase ASE 12.0; Oracle 8i; DB2 7; Centura 2.1; CodeWright 7.5; SQR; Source Code Control System

02/2004 – 07/2004 Client: Confidential (Boston, MA)
Database Consultant

Database and application upgrade for the customer’s Information and Reporting System

Implemented Oracle database upgrade from version 8i to 9i Release 2; application upgrade (Forms from version 5 to 9i, Reports from version 3 to 9i) in a timely manner, meeting aggressive deadlines
Performed product installation, space allocation, system configuration, backup, export/import, transporting tablespaces
Created and maintained databases, configured initialization parameters for database performance tuning 
Monitored the growth of the database objects for capacity planning using Oracle Enterprise Manager
Investigated and resolved all issues related to the transition from client-server to 3-tier architecture during the upgrade process
Fulfilled database analysis, data conversion, performance tuning, and troubleshooting tasks
Wrote/modified UNIX shell scripts, batch files to implement upgrade operations
Implemented all phases of application upgrade; recompiled, debugged, modified, tested, and deployed Oracle forms, reports, PL/SQL stored procedures and libraries, functions, packages, and triggers (300+ forms, 200+ reports, 600+ tables, 600+ triggers, 200+ packages, 500+ stand-alone procedures/functions, 50+ PL/SQL libraries)

Implemented reverse engineering using Oracle Designer, application version control using CVS

Environment: Windows XP/2000; HP-UX, bash, csh, Korn shell, Oracle 8i/9i R.2, OEM, partitioning, rman, Export/Import, transportable tablespaces, Oracle9iAS, Ora9iDS, Forms 5/9i, Reports 2.5/9i, Designer 6i/9i, SQL*Plus, WEBUTIL; CVS; Citrix

09/2002 – 01/2004 Client: Confidential (Hartford, CT)
Systems Advisor
Worked on many projects in various business lines and products of Insurance industry
Designed and developed complex solutions from customer’s business requirements; translated business/functional requirements into code
Implemented system enhancements and changes in accordance with on-going business requirements, which should be converted to the technical requirement following the established development standards and provided technical specifications
Worked as part of a team and independently to develop, modify, test, and deploy Oracle forms, reports, PL/SQL stored procedures, functions, packages, triggers, tables, complex SQL queries and views
Performed Pro*COBOL coding required to maintain and enhance the existing product set
Performed database analysis, design, data modeling and troubleshooting tasks, testing activities
Worked on optimization, tuning and performance improvement (reducing execution time for SQL queries and PL/SQL procedures, view modifications, analyzing tables, indexes)
Performed upgrades and/or rewrites of existing code to new platforms, support the migration in a timely manner, wrote/modified UNIX shell scripts, batch files, controlled versions of the applications using PVCS
Provided support for the application batch cycle in production, schedule and run OS jobs
Supported user interfaces and site activity reports
Environment: Windows 98/2000; Compaq Tru64 UNIX V5.1; bash, csh, Korn shell, Oracle 8i/9i, Developer 6i, SQL*Plus, Pro*COBOL, SQL*Loader, Export/Import; SQL Navigator 4; SQLab Xpert 4.5; PVCS; ERwin 3.5.2; Citrix; Autosys; Excel; Access

01/2002 – 04/2002 Client: Confidential. (Stamford, CT)
Developer
Created customized forms, PL/SQL stored procedures, OS jobs, SQL queries / scripts, shell scripts / batch files
Developed reporting system, which generated system status reports to customers
Supported remote customer’s systems, implemented OS and database management procedures
Performed migration, product installation and upgrade, capacity planning, tuning
Enhanced customized company’s SalesForce reporting system based on the data downloaded from the Web into MS Access 2000 database
Wrote functional and technical specifications based on user requirements
Interfaced with application programmers to develop system designs to expand the SalesForce capabilities 
Performed product evaluation for internal use and wrote recommendations for clients
Completed Oracle Certification Program
Environment: Windows 2000; Sun Solaris 2.x; HP-UX; Oracle 8/9i, Developer6i (Forms 6i, Reports 6i), OEM 2.2, SQL*Plus, SalesForce Tools, MS Access 2000;

06/2001 – 01/2002 Client: Confidential (NYC, NY)
DBA
Performed administration, support, data modeling and optimization for mission critical OLTP / DW environment (6 instances, 600+ users worldwide)
In unpredictable situation successfully replaced the previous DBA who left the client site with a short notice; in 3 days acquired all the information needed to perform DBA activities
Created stored procedures, triggers and SQL queries, OS jobs, scripts and reports
Participated in system design and data modeling (logical and physical)
Provided on-going system support for developers and users 
Resolved system security issues, reconciled database logins, roles and groups, improved audit system
Fulfilled capacity planning, SQL tuning and overall performance improvement
Monitored key system events, reported current system status to managers according to SLA 
Contacted System Administrator/Help Desk to resolve OS and networking issues and Technical Support to discuss serious technical problems 
Implemented backup, recovery, stand-by database strategy, data replication, migration, upgrade, database creation, system configuration, connectivity
Environment: Windows NT/2000; Sybase SQL Server 11.0.3/ASE 11.9.2, Backup, Replication, Central, Advantage, Modeler, isql, bcp, dbcc; DBArtisan; ODBC, MS Access; Erwin; PowerBuilder 7;

EDUCATION

BS in Computer Sciences, MS in Mathematics