Senior Data Architect Resume
Newport News, VA
TECHNICAL SKILLS:
Servers: Sun, HP, IBM Sun, HP, MS Windows Server 2008 R2
Database: Confidential Adaptive Server Enterprise, Qlikview, MS SQL Server 2008 R2, Oracle 12g R2, MySQL
Software: CA s ERwin, IBM s Rational Rose, ASG s Rochade, MS Visio 2012, Sparx Enterprise Architect
Processes: Agile Development
PROFESSIONAL EXPERIENCE:
Confidential, Newport News, VA
Senior Data Architect
Responsibilities:
- Engaged with Limelight Networks to develop data models and MySQL database structure for their MMR intiative. Models consist of Entity Relationship diagrams - conceptual, logical and physical models.
Confidential, Newport Ne ws, VA
Senior Data Architect
Responsibilities:
- Developed and implemented an architecture which integrates multiple Healthcare Registry databases from two distinct vendor implementations into one unified database platform. This unified database hosts many registries as well as source extracts and reports, Dashboards and child databases for a multitude of analytical and business requirements. This database retains a complete, robust trail of all written activity. By design, this database is the heart of company.
Confidential, Norfolk, VA
Data Architect/Database Administrator
Responsibilities:
- Defined and refined new and existing processes for storing, transporting, protecting, archiving and retiring Healthcare records for the Veteran. Scalability, Data Volume and Data Privacy were chief concerns in connecting a variety of systems together to control information flow seamlessly.
- Developed and executed ½ terabyte database migration effort. Despite stringent and complex requirements these databases were migrated from one secure datacenter to another secure datacenter located two time zones away from each other. All data accounted for no unplanned outages.
- Defined data structures to support seamless audit logging via database triggers.
- Lead a team of DBAs in support of large development efforts within NHIN to tighten development practices and improve Administrator processes, modeling the entire database development lifecycle, and producing a DBA Standards and Practices guide. These products delivered an improved developer - customer relationship. In addition, performed Line Manager functions for a team of Java Developers.
- Agile Development processes were instituted to ensure continuous improvement and development of software that maintained step with fast paced Business Requirements. Quick responsiveness was demanded of the database team meet Agile demands. A key component to rapid response was development of Standards and Practices to deliver a consistent methodology for database definition, delivery and maintenance.
Confidential
Technical Architect
Responsibilities:
- Serves the Army Distributed Learning System (DLS) as the primary government architect databases, primarily for the Army Learning Management System (ALMS). Responsibilities include design recommends and business process changes for implementation of enterprise program-related databases and data structures. Ensure the quality of data being received by and sourced from the DLS, scrutinizing interfaces with external systems. Provides oversight and recommendations for management of DLS metadata and consistent modeling of data within the DLS program. Recommends tools and processes, and exercises tools and processes for learning management and metadata.
- Additionally responsibilities include DLS backup Configuration Manager and backup Army Learning Management System Project Manager (Contractor). Lead Technical resource for the DLS Technical Management Division for identifying Service Oriented Architecture (SOA) practices and deliverables supporting DoD’s Net-Centric Data infrastructure initiative. Provide oversight of, and recommend modifications to practices held by the DLS integration contractor and the program management office, having visibility to the environments in which they work. Review and makes recommendations regarding contractor deliverables including the documentation they provide.
Confidential, Washington DC
Performance Architect
Responsibilities:
- Consulting architect responsible for shaping new developments in the Kenan Arbor Billing and Customer Care products for high performance; which introduced parallel processing architecture and tools. Third-party hardware and software tools and in-house development software tools were evaluated for implementation to support the new billing engine.
- Analyzed and defined concepts for future product releases with an eye toward performance, for implementation as new product features. Initiated conceptual design offering delivering an in-memory and network architecture supporting a scalable, high performance backend billing engine.
- Leader of a spirited team of over twenty contributors, worldwide, to resolve serious performance related issues whether they be at the client site or uncovered during new version product performance testing. Fostered the creation of tools to appropriately size hardware environments across Billing and Customer Care software products employing modeling and simulation practices enabling the collection of performance metrics of single or concurrent products. Established ground rules and objectives of large-scale benchmark exercises supporting platform vendor, proof of concept or client driven events.
- Spearheaded research activities for migrating UNIX based software to Intel-based technology supported under Microsoft’s SQL Server database engine. This effort not only established the simplicity of migrating the software tools, but established performance metrics and measured throughput volumes against established metrics. Additional responsibilities of this exercise include initial concept, hardware sizing, acquisition and the migration of data from any database platform to SQL Server.
- Critical to Kenan’s success factor by correcting performance-troubled large-scale deployments worldwide. Successfully persuaded desperate clients to implement time consuming, sweeping hardware and database configuration changes to resolve dismal performance problems. Orchestrate assembled teams of professionals specializing in System, Database and Disk management, often mixed with Hardware vendors and Integration Specialists, in high pressure, high-energy, crisis-control situations.
- As the last word regarding database and operation efficiency, especially Confidential, a wide range of individuals from the Development, Consulting, Benchmark, Performance Tuning and Systems Engineering organizations sought consultation. Dissemination of information was achieved through formal and informal communications. The formal flow of information was via course instruction and authoring whitepapers.
Confidential, Bethesda, MD
Senior Systems Consultant
Responsibilities:
- Exercised broad-ranging skills spanning the database technology spectrum. Twice honored as contributing panelist authoring four examinations for Confidential 11.5. Fine-tuned and oversaw technical procedures for migrating SQL Servers from version 4.9.2 to 11 for Confidential Corp. and Bell Atlantic Corp; whose environments consisted of two hundred database servers.
- Member of an elite SWAT team, restoring performance of crippled production databases, often in two to three days. These engagements often demanded instantaneous application of analytical and tactical skills in high pressure, often hostile situations. Among the satisfied customers were National Public Radio, IBM, CorNet International, with all situations positively resolved.
- Synergized hardware and database configuration for SUN, optimizing performance during a SUN and SGI benchmark. This activity allowed SUN to strengthen a foothold in an SGI dominated environment. Crafted high performance stored procedures for Wellspring Resources.
Confidential, Cambridge, MA
Database Engineer - Performance Specialist
Responsibilities:
- Achieved the position of Performance and Benchmark Specialist by demonstrating a commanding knowledge of database behaviors. In this capacity, discovery and resolution of database bottlenecks increased billing system performance and concurrency throughput a ratio of fifteen to one. This feat enabled Confidential to develop a larger customer install base.
- Analyzed and tuned production support environments, resolving many potentially crippling issues. Production problems were challenging to this billing system as each customer employed the application differently, shifting bottlenecks to various portions of the database.
- Responsible for streamlining product development environment ensuring a high quality database structure. Performed technical management tasks while owning the Database Development Domain and leading a small team of database developers. Evaluated third-party tools for performance monitoring, reverse engineering and database platform conversion.
Confidential, Norwood, MA
Senior Database Administrator
Responsibilities:
- Joined the firm during their process of outsourcing major portions of their MIS function. Led a team of technically oriented individuals through the analysis, repair and re-integration of a corrupt VAX Common Data Dictionary. Because of the speed and effectiveness of the repairs, the major outsourcing project remained on schedule. Coached and assisted other DBAs through performance and process improvements for 35 production RDB databases resulting in streamlined production processes for backup, recovery, and analysis achieving 30 to 50 percent improvement. Advised application programmers of specific “dos and don'ts” of effective and efficient database access techniques.
Confidential, Maynard, MA
Database Administrator
Responsibilities:
- Designed, developed, and maintained a VAX/VMS RDB database. The database’s size was a ten gigabyte which was considered a large database for that time.
- Educated programmers on database access techniques, enabling them to write more efficient code. Analyzed data to determine the amount of space the database required to meet its performance needs.
- Captured performance metrics using database statistical tools in order to tune the databases. Critiqued and improved application architecture, specifically around database issues. Served as technical consultant within the department for database issues.
- Provided full range analytical and technical support for the Domestic Materials Tracking and Salary Management System applications. Ensured proper documentation and code management practices delivering stable, supportable application environments.