SUMMARY:

• Expert level skills with database systems administration, design and implementation.
• Over 20 years of diverse industry experience with full life cycle of software projects as Database Administrator, System Administrator, Analyst/Programmer working in local government, engineering, manufacturing.
• Personally responsible for production systems and implementation projects, as well as serving as a member of a team. Strong problem solving and troubleshooting skills.

TECHNICAL SKILLS:

• Oracle DBA, Oracle RDBMS v. 10g, 9i, 8i and 7.x., OCP DBA 9i, 8i.
• Oracle SQL, SQL*Plus, PL/SQL.
• Oracle Enterprise Manager, DBArtisan, TOAD.
• Database backup and recovery, Oracle Recovery Manager (RMAN).
• Oracle Data Guard, Fail over, Oracle utilities (Loader, export/import, DataPump, dbv).
• Oracle indexing, partitioning, star schema, data warehouse.
• Oracle database performance tuning, tkprof, Statspack.
• Database capacity and storage planning and setup.
• MS SQL Server 2000, Enterprise Manager, BCP, T - SQL, DTS packages.
• Data modeling, database logical and physical design, ER/Studio, ERwin.
• Data quality control, database integrity, database security and audit.
• Cross-platform database migration, heterogeneous data sources integration, ODBC/JDBC.
• SQL, PL/SQL, T-SQL
• C, Cobol, Java, Assemblers, other
• OS scripting (Unix/Linux - ksh, sh; MS Windows - WHS; OpenVMS - DCL)
• Unix/Linux IBM/AIX, HP Alpha/Tru64 Unix, RH Linux.
• MS Windows NT/2000/XP/2003.
• Other VMware WS 5, HP Alpha/OpenVMS
• Storage RAID, Hitachi SAN, NetApp NAS

PROFESSIONAL EXPERIENCE:

Confidential

IS Analyst IV, DBA

Responsibilities:

• Work as a principal database administrator for the site of the Confidential (911 Center that served nine municipalities), responsible for operations and development of Oracle and SQL Server databases with total capacity about 1 TB of data.
• Serve as a member of the centralized Oracle DBA group, provided and participated in cross training with other team members, participated in on-call support.
• Provide expertise in database design and SQL to applications developers; developed database objects, SQL code, scripts for ETL processes and system monitoring.
• Maintain Oracle 10g/9i/8i database software (installed servers and clients, upgrades, patches) on AIX, Linux, Tru64 Unix and Windows platforms, resolved issues with Oracle Tech Support.
• Act as a system administrator for Tru64 Unix servers that hosted Oracle databases, including patching, monitoring, tuning, and configuration.
• Implement Oracle servers with Network Attached Storage (NAS) and SANs, coordinated multi-vendor efforts to resolve performance issues.
• Monitor database performance and availability using OEM/Grid Control; performed database backups using RMAN and database exports.
• Develop necessary changes to the databases and deploy it in production using established change control process; kept database documentation (ER/Studio, DBArtisn, MS Visio).
• Provide the Bureau managers with proposals and evaluations for database design, security, capacity planning; evaluations of hardware, software and storage needs, proposals for database tools.
• Designed, implemented “CADMIS” database - a 250 GB, mission-critical 24/7 database of legal records of 911 calls and related data, to use by all local emergency respond agencies, courts, etc.
• Upgraded, migrated the database from version 7.3 to 8.1.7, 10.2; platform from HP Tru64 to IBM AIX.
• Designed ETL processes for initial, incremental and real-time loading of CAD (Computer Aided Dispatch) data in fact tables as well as loading and updating data in dimension tables. The process consisted of OpenVMS jobs, Unix programs and scripts, Oracle Loader scripts, Oracle database triggers and stored procedures, MS SQL Server DTS packages and jobs. . Developed scripts for monitoring of unattended executions of the ETL processes. Employed Oracle HTTP Server to monitor the system health via web.
• Built data warehouse in Oracle 8i, for tasks of staffing levels forecasting, workload summaries, exceptions reports, etc. Used star schema, materialized views, and parallel query.
• Optimized the database physical design, implemented partitioning, IOT, tuned it for performance.
• Wrote application queries using analytical functions; optimized them using indexes and execution plans.
• Developed and implemented database security and audit, data assess control, data retention schedules, in compliance with the requirements of the City’s Auditor’s Office and established BTS policies.
• Implemented a stand-by database server and a “Transparent Application Failover” on database clients, that allowed for needed maintenance windows while maintaining 24*7 availability of the system.
• Maintained database development environment, provided needed data for development.
• Implemented training environment for Oracle10g using VMware and Windows PCs .
• Administered several specialized mid-sized (20 - 40 GB) MS SQL Server 2000 databases.
• Developed MS SQL Server database objects using ER/Studio, EM, Query Analyzer.
• Integrated Oracle/Unix and MS SQL Server databases using linked servers, ODBC/JDBC connectivity, Oracle/Windows; developed cross-platform DTS packages and data unloading/loading procedures.
• Performed data cleaning and application troubleshooting.

Confidential, WA

Senior Programmer Analyst

Responsibilities:

• Maintained and customized code in reporting module of the billing system for the telecommunications company. VAX Basic, C, DBMS, VAX/VMS.
• Developed, implemented table structures and code to expand application’s functionality.

Confidential

Lead IS Analyst, Oracle DBA

Responsibilities:

• Installed and supported Oracle 7.2 on IBM RS/6000 AIX.
• Designed, implemented databases for applications used by Accounting and Operations Departments.
• Integrated the system with legacy systems and desktops, implemented data load processes.
• Developed, supported a CRM application, using Oracle 5 RDBMS (VAX/VMS), Oracle Forms/ Reports.

Confidential

Lead IS Analyst

Responsibilities:

• Designed and implemented enterprise-wide system for storage and exchange the company engineering data; coordinated data exchange formats with other companies, for Computer Aided Design and Drafting Department.
• Worked as a lead Systems Administrator, installed OS (VAX/VMS), administered users, tuned system performance, planned disk capacity, specified equipment purchase, dealt with vendor tech support, programmed utilities, device drivers, applications. Mainly VAX/VMS, C, Assemblers, DCL, Decnet, PC and mainframe integration; provided training for programmers and end users, for IT Department.
• Designed, developed and implemented a system for production forms and records circulation; supported it through full life cycle; integrated with other enterprise systems (for Confidential ).
• Implemented, supported real-time test control and lab automation systems; developed data acquisition and visualization applications, for Confidential .