Tony A. Carey
267.608.6099
email:
Skills Summary
Oracle
and SQL Server RDBMS
PL/SQL and T-SQL (stored procedures and
triggers)
Logical and Physical Data Modeling using Erwin
Server and SQL statement tuning
Database migration and ETL development
Data Warehouse development and administration
Oracle 8i and 9i Server installation and
administration
SQL Server installation and
administration
Oracle network setup and configuration
(including Listener and Name Server)
Multi-threaded Server option
Oracle RAC/OPS
Oracle Advance Replication (read-only
snapshots, updatable snapshots, multi-master)
Backup and recovery using RMAN
Physical design and
database capacity planning
Languages SQL, PL/SQL, T-SQL,
Python, Java, C/C++, Perl with DBI/Oraperl, Unix shell
(Korn, Bash, C), XML/HTML, Javascript/Vbscript (ASP)
Operating Systems Unix (Linux, AIX, IRIX,
Solaris), Windows 2000/XP, Web/Application Servers, Apache, Tomcat, IIS
Development Tools Erwin, ERStudio,
DBArtisan, Toad, Sagent, SQL*Loader, SQL*Plus, Import/Export, Unix development tools (Linux, AIX, IRIX, Solaris), Visual
C++, Borland C++, Crystal Report, R&R Report Writer
Experience
8/2005 to Comverse Technology
Present
Database Manager
·
Managing a Database Development
group for a Real-time Billing (RTB) Product.
·
The group is broken into 2
teams. One team is responsible for developing PL/SQL batch-processing to
support the Real-Time Billing Product. The other is responsible for
Product upgrades, i.e. producing PL/SQL, SQL, and Unix
shell scripts to perform RTB upgrades.
·
Manage the daily activities of
the developers and DBAs, provide technical leadership; and implement short-term
and long-term planning for the group.
· Development and Product environment is Oracle 8i (upgrading to 10g) on Compact Servers.
12/2003 The Sycamore
Group
8/2005
On
assignment at Veritable LP (1/2005 to 8/2005)
·
(2nd engagement)
Architected a Financial Asset Management Reporting schema using Erwin. This
schema will interact with an Axys Data Warehouse which resides in a Microsoft
SQL*Server 2000 database. It will also provide a setup facility for
interacting with Crystal Report.
·
Involved with setting up the
Data Warehouse and writing Sagent plans for loading, accessing, and
manipulating the Data in the Warehouse.
·
(1st engagement)
Enhanced and managed a Financial Transaction database schema with Erwin. Wrote
PL/SQL stored procedures to manage new business requirements. Installed
and configured a new Oracle 9.2 database on a dual-processor Linux
server.
·
Migrated the
database schema from the old database server to the new one. Deployed a
standby database using RMAN, and managed the production database
On
assignment at VWR (11/2004 to 1/2005)
·
This client has an E-Commerce
Web site-using Oracle (Linux) as the backend database, Apache for the web
servers, and Object-Oriented Perl CGIs to deliver pages for the site.
·
After completing a performance
analysis on this site, involved with creating PL/SQL Packages and triggers to
deliver content to pages more efficiently.
·
Involved with modifying Perl
Modules to invoke the new database stored procedures. I also migrated the site to a mod-perl implementation.
On
assignment at City Of Philadelphia (11/2004 to
1/2005)
·
Completed the architect for a
database schema to manage the City’s budgets, projects, and contracts. The
data model was done in Erwin.
·
The database was deployed on
Oracle 9i. As part of the Erwin design, PL/SQL procedures and triggers
were created to implement various business rules and data flows.
On
assignment at Brinker Capital (12/2003 to 3/2004)
·
Developed T-SQL stored
procedures for a new Financial Reporting System.
·
Developed database migration
software to move data from the old Financial System to the new one.
·
All the migration software was
written in Python, and hosted on Windows XP machines. The database
deployed was SQL Server 7.0 (recently upgraded to SQL Server 2000), running on
a Windows NT server.
·
This assignment also required
some database design, and managing several SQL Server databases.
8/1997 to Independent
Consultant, Oracle DBA/Database Developer
9/2003
On
assignment at GlaxoSmithKline (6/2002 to 9/2003)
·
Developed database migration
software for merging all corporate biological databases into a single
centralized database. All the systems were written in Python, and were
hosted on both Linux and Windows NT servers. The database deployed was
Oracle 8.1.7 running on Linux.
·
This assignment consisted of
writing software in Python to migrate corporate wide biological metadata, data,
summaries, and results into a single central database repository. The
assignment also consisted of writing PL/SQL packages and triggers to manage
biological metadata and compounds. It also consisted of managing
several development databases.
On
assignment at Dress For Success (4/2001 to
Present)
·
Designed and developed a web
based client/staff information system. The database deployed was Oracle 8.1.7
running on AIX. The Webserver deployed was IIS running on Windows NT 4.0.
·
This assignment consisted of
defining the H/W and S/W architecture to support the website and backend
database, installation of the database, designing the database schema, and
writing an object based database interface library with ASP (Vbscript).
On
assignment at Prodigy Services (6/1999 to 10/2001)
·
DBA for the development
databases. Managing database accounts and resources.
Performing database backups and upgrades. Instance and SQL
tuning. All development databases were Oracle 8.1.5, in a distributed
network environment. Some database instances are deployed on RS/6000s
running AIX, other instances reside on NT machines.
·
Designed and implemented a
database schema and tools for migrating customers to Prodigy’s Internet
service. Migration tools were written in C++ using Rogue Wave DBTools.h++, and Perl with DBD::Oracle for database
access.
·
Supporting developers with
database table designs for value-added service features. Writing
triggers and stored procedures to enforce business rules. Creating snapshots
and views for distributed database synchronization.
On assignment at Infonautics Corporation (7/1998
to 6/1999)
Independent
Consultant, Project Leader/DBA
·
Managed and assisted in the
development of a Knowledge Management System. This was a web-based system
designed to manage, search, and retrieve information centered around user-defined communities. The database deployed was
Oracle 8.0.
·
The assignment consisted of
supporting enhancements to the site via database schema changes. Generating
logical designs of the database. Database Interface Server development.
HTML/CGI development to manage and control information on the web pages.
Developing JavaScript modules to support web pages.
On assignment at Lotus Development Corp (8/1997
to 7/1998)
·
Designed and developed an Oracle
7.3 based Internet e-mail system. This system was targeted at medium and large
ISPs requiring a scaleable e-mail solution. The database consisted of
subscriber profile and e-mail messages. SMTP and POP servers were provided with
connectivity to the database for inbound mail delivery and retrieval. The RDBMS
was deployed on RS/6000s running AIX. Oracle advance replication was used to
synchronize subscriber profile data across several instances.
·
The assignment consisted of
setting up and administering the development databases. Generating logical
designs to establish optimal relationships between entities. Customer
preinstallation preparation. Support training. Creating physical designs to
increase I/O throughput and minimize disk contention. Server and SQL statement
tuning. Setting up symmetric replication environment. Writing PL/SQL stored procedures
and trigger to maintain business rules. Developing scripts (Perl, Oraperl,
shell) to install and administer the mail system database. Assisting developers
with database issues.
3/1994 to Naviant Technology Solutions
8/1997
Consultant
On
assignment at Prodigy Services (3/1994 to 8/1997)
·
Assisted with the development and deployment of Prodigy's Internet
service. This was a totally new service, and Prodigy's first installation of an
Oracle database. The database consisted of subscriber profile, deals, session,
chat, personalization, and e-mail data. The RDBMS was deployed on RS/6000s
running AIX. Oracle parallel server (OPS) option was installed for load
balancing and failover.
·
The assignment consisted of
setting up and administering the development and production databases.
Monitoring the production database. Generating logical and physical designs.
Setting up OPS. Writing C++ classes (using RogueWave's DBtools.h++) to retrieve
database transaction statues. Migrating schema changes from development to
production. Writing data conversion scripts in Oraperl and PL/SQL. Designing
and setting up subscriber replication using Oracle's read-only snapshots
mechanism. Training DBAs to manage the production environment. Assisting
developers with database issues. Server and SQL statement tuning.
On assignment at Infonautics Corporation (3/1994
to 4/1996)
·
Designed and implemented an Oracle 7.2 base online document search
and retrieval system. The database consisted of subscriber information, access
controls, and a document directory. The RDBMS was hosted on a Silicon Graphic
server running IRIX. Oracle's multi-threaded sever option was utilized to
achieve faster connectivity to the database, and to maximize the number of
sessions.
·
The assignment consisted of
setting up and administering the development and production databases.
Generating logical and physical designs. Developing a database access API in
PRO*C. Integrating a natural language search engine into the Oracle database.
Document preparation scripting. Server and SQL statement tuning. Writing PL/SQL
stored procedures and trigger to maintain business rules. Developing scripts
(Perl, Oraperl, shell) to administer the system.
11/984 to Gandalf Systems Inc.
3/1994
Software Development Manager
·
Managed a group of Engineers developing software for wide-area
network (WAN) products.
·
This included development of
software for data circuit and cell switching. T1/E1 link module development.
Network management, network routing, call control, switching, and link (LAP-B)
protocol software development.
Academic Background
B.A. Math and Computer Science,
Professional Associations
Member,
Midlantic Business (Formerly SBADV)
Member,
International Oracle Users Group (IOUG)
Member,
The Institute Of Electrical And Electronic Engineers
(IEEE)