Resume Builder
< Back
Edit this resume to make it your own!

Your Name

Sr. Database Architect


Programmer Analyst / Database Engineer / Oracle Consultant / Database Architect / Project Manager with more than 15 years of experience in Database Design, Programming and Analysis of Relational Database Information Systems.

Work Experience

Sr. Database Architect

Advance Auto Parts/APC, Roanoke, VA

Feb 2011Current

Responsible for planning and direction of the Electronic Parts Catalog (EPC) project by providing expert level knowledge of database technologies, design alternatives and their implications for which they have accountability.
  • Establishing the database environment, classes, entities, programming objects, database programming layer and naming standards for the project areas for which they are assigned
  • Managing issue identification and problem resolution process
  • Addressing systems development and integration issues
  • Creating a prototype as part of design and estimation efforts
  • Conducted code reviews on various sprints in the iteration
  • Research of ETL tools and RDBMS to fit project requirements and finances
  • Integrating test plans and conducting testing on assigned integration threads
  • Production Staging, Launch, Piloting and Post Implementation assignments as required
  • Populating the development, QA and staging environments with appropriate test data from AAIA,
  • Building bulk data load software for centralized EPC databases and/or data push software for Store databases
  • Responsible for database security in the development and test environments
  • Submission of reports on disk capacity estimates and database physical design information
  • Monitoring resources including CPU usage and space utilization in the development and test environments
  • Executing and optimizing queries on behalf of the development team and the business users, identifying potential barriers to project success and offering proactive solutions that align to the culture and operating model of Advance Auto Parts and the project team

Database Developer/Engineer

Meridium Inc, Roanoke, VA

Dec 2007Mar 2008

Oct 2009 - Feb 2011

Worked on Meridium's Core framework databases (Oracle and SQL Server) that support its Asset Performance Management (APM) System. The APM system provides information to various manufacturing/industrial clients on how to increase production capacity, lower costs, limit risks and downtime.
  • Conducted regular and baseline upgrades and testing on the core database both local and client, including changes to the design, documentation, data conversions, query optimization, data modeling and performance tuning during various upgrade cycles.
  • Helped in migrating of the RDBMS to the recent database versions (Oracle 9i to 10g to 11i and SQL Server 2005 to 2008), as well as data migration.
  • Also been an integral part of customer database upgrades including (error identification, rectification, importing and processing data from xml files to improve the upgrade performance, monitoring and reporting.
  • Programming simultaneously in SQL, TSQL and PL/SQL to support applications on dual platforms.
  • Identified problems, created tasks, work items, determined work assignments and recommended problem resolutions
  • Monitored performance and grid locks to assist in smooth conduct of operations.
  • Researched software and other products to solve current and future needs of the organization. Studied trends and emerging technologies that could affect growth and future direction of the organizational needs and goals. Conducted a study on cloud computing to determine changes that may need to be effected to promote the migration of existing technology in this direction.

Oracle Consultant and PL/SQL Programmer

Inforeliance, New Carrollton, MD

May 2007Jul 2007

Worked on the IRS XML Relational Database (XRDB) (Oracle 10g) that provides information about corporate taxes and establishes organizational interfaces between Corporate Data & Systems Management Division, Product Assurance, Tax Exempt Government Entities (TE/GE) and Mission Assurance.
  • Migrated xml type data from staging tables to the main database
  • Performance tuning of data
  • SQL and PL/SQL programming
  • Use of tools like Designer, TOAD, SQL Developer, Developer suite and Beyond Compare.

Database Engineer / Administrator / Project Manager

Virginia Bioinformatics Institute, Blacksburg, VA

Jun 2005Apr 2007

Worked on the design and development of an integrated Proteomics RDBMS including genomics, transcriptomics, proteomics, metabolomics, pathways, computer modeling, and advanced analytical tools, funded by grants from the NIH (National Institute of Health) and the NIAID (National Institute of Allergy and Infectious Diseases). The database is the first of its kind in the area of Bioinformatics.
  • Assisted Lead Scientist in Proteomics project management tasks in the capacity of a Project Manager by working with software designers and research scientists by being an integral part of the SDLC of the project. Created baselines/timelines, requirement documents, held meetings and follow ups to manage the project.
  • Developed, maintained and monitored databases using tools like ERWIN and OEM
  • Migrated data from flat files, tab-delimited, XML files to oracle.
  • Scheduled regular exports, imports, data pumps, hot and cold backups
  • Conducted regular study of data storage, usability, audit, performance statistics
  • Created schema and schema objects like tables, views, packages, procedures, functions and triggers, and rules like roles and privileges
  • Designed the data access layer using SQL and PL/SQL programming
  • Used tools like TOAD and Microsoft Project.
  • Other DBA and oracle programmer related activities

Programmer Analyst (Systems)

R&K Engineering Inc, Roanoke, VA

Jun 2000Jun 2005

Worked on a DOD Interactive System of co-coordinating Real Property Requirements between Army/National Guard sites and their respective regions.
  • Worked on Modernization of existing applications by moving them to a .NET platform using C#, ASP.NET, VB.NET.
  • Analyzed various Systems and designed numerous applications and programs for the Real Property Management system of the Department of Defense using Oracle 8i/9i, Macromedia-Authorware and MS-SQL server.
  • Designed and developed The Interactive Timecard System (Payroll, Employee, Project records) using CASE Tools like Designer and Developer.
  • Worked as the Lead programmer for the Real Property Inventory System - Phase I for the NAVY & Marine Coors with Oracle 9i and SQL Server as the backend RDBMS and Microsoft .NET as the interface.
  • Developed an Interactive Computer Based Training for the Real Property Planning of US Military Installations using Macromedia Authorware.
  • Designed, Administered and Managed Oracle databases (Performance tuning, Optimization, Planning, Exports, Imports)
  • Creation and development of reports using SQL and PL/SQL (Packages, Procedures, Functions and Triggers).

Summer Intern (Database Administration / Programmer)

Virginia Commonwealth University, Richmond, VA

Jun 1999Aug 1999

Analyzed, Designed and developed an EIS system for the Graduate Admissions Office at the University
  • Planned and executed project to effect Query optimization, security and concurrency control on Oracle databases.
  • Designed web pages and brochures for the Graduate School of Business using FrontPage, PageMaker and Photoshop.

Graduate Assistant (Database Administration / Programmer)

Aug 1998May 1999

Sept 1999 - May 2000
  • Managed the database of graduate studies records in Microsoft Access (creation of tables, forms, and reports).
  • Web integration of student databases, record processing and report management


Master of Business Administration in Management Information Systems

Virginia Commonwealth University, Richmond, VA


Additional Information

  • Oracle 11.2i, 10g, 9i, 8i
  • Microsoft SQL Server 2008
  • PostGres 9.2.3, MySQL 5.0
  • SQL, PL/SQL, T-SQL, Packages, Procedures, Functions, Triggers, Database Design, Administration and Management
  • Oracle Forms, Reports, Developer 2000,
  • Designer 2000, CA Erwin Data Modeler, Embarcadero ERStudio Data Architect, IBM's Rational Data Architect, Visio
  • Oracle Enterprise Manager (OEM), TOAD, SQL Developer, SQL Navigator
  • Microsoft Office: Word, Excel, Access, PowerPoint, Publisher, Outlook, Project

  • Windows NT/2000/2003/XP, UNIX

  • MKS Source Integrity, Visual Source Safe, CVS, Tortoise
  • CorelDraw, Photoshop, PageMaker, AutoCAD

(Architect/Modeling/Designing, SQL/PLSQL/TSQL Programming, Consulting) (15+ years)
  • Database Design: Architecture, designing, installation and configuration of the database, Design and Programming of the Database Access Layer
  • Data analysis: Database conceptualization based on internal or external customer input
  • Database modeling: Generated conceptual, logical and physical Database Models. Reverse engineered source databases from varied platforms to a physical model to facilitate transportation between compatible target platforms.
  • Database Security: Implemented views, Row level security (RLS/FGAC), DBMS obfuscation and data encryption, PL/SQL wrapping, roles and privileges and other security policies to enforce database security.
  • Data Migration: Loaded and extracted data and from various sources (text file, ASCII files, excel spreadsheets, MS-Access, XML) using SQL Loader, data conversion tools and xml functions. Migrated data from other relational databases like MySQL, SQL Server using external vendor tools like Data Loader and PostGres using tools like PostGres Plus Advanced Server's Enterprise Migration Toolkit.
  • Performance Tuning: Tuned queries using Explain Plan. Analyzed query performance before and after the use of indexes. Generated statistics for database objects and made recommendations based on optimizer statistics and planner feedback.
  • Database size: Worked with large databases greater than 4 Terabytes.
  • Database Programming: Created, modified and deleted tables, views, indexes, clusters, synonyms, sequences, procedures, functions, packages, triggers and other database objects. Programmed using SQL, PL/SQL to select, create, update and delete data. Generated forms and reports.
  • Quality Analysis and Testing: Created use cases to test database integrity and work flow as designed.
  • Project Management: Created project plans, timelines, baselines, and work assignments. Worked with team members and across teams to enable timely execution of deliverables and work items as per project plan.
  • Agile SDLC development: Used iterative and/or waterfall methods to plan database developmental work to fit project requirements and styles.
Powered by Super-Resume | Scala archive