We provide IT Staff Augmentation Services!

Senior Database Consultant Resume

5.00/5 (Submit Your Rating)

New Jersey, NJ

Proactive and highly motivated Information Technology professional with expertise in building, enhancing and integrating databases for financial disclosure reporting, project management and modification requests. Team leader and builder who can motivate players to achieve consensus regarding competing priorities. Known for designing complex systems within tight timeframes and budget constraints. Recognized for producing high quality work through untiring resolve and dedication.

TECHNICAL SKILLS

Databases: SQL Server 2008 R2/2008/2005/2000, Oracle 8/8i/9i, Sybase XI, Ingres.

Languages: TSQL, ColdFusion 4.5/5.0/MX, JavaScript, Shell, C, HTML, and VBScript.

Systems: Windows 2008/2003/2000/XP, SunOS, Solaris, UNIX Sys V.

Other: ERStudio 7.1, AdeptSQL Diff, WebLogic, Mercury Quality Center, Dreamweaver MX, ColdFusion Studio, Crystal Reports, Visual SourceSafe

PROFESSIONAL EXPERIENCE

Confidential Fort Monmouth, NJ 2005 - Present
Senior Database Consultant, US ARMY CECOM LCMC, Software Engineering Center

Viatech is a full-spectrum information technology and support organization providing services and solutions to both government and industry. Viatech’s capabilities include application development, workplace automation, hardware and software solutions, acquisition support, logistics support, network support, and computer related services and products.

  • Database Lead for the Financial Disclosure Management (FDM) application which is a DoD-approved system for electronic filing, reviewing, and managing of required financial disclosure.
  • Designed, developed and maintained multiple instances over dozens of databases in SQL Server 2005 and SQL Server 2008 for all FDM team members’ use. These databases service over 100,000 users and more than 25 government agencies.
  • Scripted entire databases with test and training data in order to quickly rebuild and verify environments as application release builds came in.
  • Performed FDM database upgrades from SQL 2000 to 2005 to 2008 during application release deployments and scripted numerous database migration scripts for dozens of application updates.
  • Assigned work items to other DBA resources per requirements discussed at team meetings.
  • Provided Tier 3 back-end support for FDM’s help desk for all database and application issues.
  • Worked closely with developers, system testers, business analyst and trainers.
  • Used third party tools like AdeptSQL Diff for database object and data compare features.
  • Tuned SQL Server performance using SQL native tools like SQL Profiler, Windows Performance Monitor, system stored procedures and Dynamic Management Views (DMVs).
  • Accomplished all production release work items within scheduled timelines even when requirements changed during and near the end of the release cycle.

Confidential, Bridgewater, NJ 2005 ColdFusion and Database Consultant

  • Provided data warehousing design requirements and data integrity consulting for a VoIP company.
  • Developed time and cost estimates based on requirements to enhance and re-design a material request application, written in ColdFusion and using an Oracle database, for a Tier 2 telecom client.
  • Created and modified data warehouse reports, written in ColdFusion, for a Tier 1 telecom client

Confidential Middletown, NJ 1989 - 2004

Project Manager, Technical Lead, Technical Information Design and Development 2000 – 2004

  • Promoted to manage the feature enhancements of ColdFusion Professional Services Management System. Accountable for over $30M in annual revenue recovery for organization with over 150 people.
  • Project managed team of 12 developers, testers, writers and administrators responsible for the enhancements, integration and deployment of 14 applications with over 30 sub-applications.
  • Managed requested enhancements across limited releases and limited resources.
  • Created operational processes that pro-actively handled issues before they became complaints.
  • Led development efforts and improved functionality, user experience and database integrity for the system by deploying eight releases throughout the life of the project.
  • Migrated a SQL Server 2000 database from one schema to another. Modified and deployed their ColdFusion MX website to production for organization that maintained all Building Emergency Action Plans. Received award from customers’ director for a job well done.
  • Received two management awards in 2002 and 2003 for exceptional effort, quality work, untiring resolve and dedication to the system. The product demonstrated the maturity of the system and its importance to the success of the organization on many levels.

Developer, DBA, Data Warehouse Specialist, Tester and Lab Manager 1989 – 2000
ANS Development/Decision Support Systems/Web Services

  • Led design and development of an on-line reporting application using Microsoft’s On-Line Analytical Processing (OLAP) Services. Allowed users to drill down on their data warehouse. Provided management and advertising companies with reports that specified counts of customer interests. Resulted in advertisements tailored to customers’ interests.
  • Performance tester responsible for developing, generating and executing load scripts on IIS 4 Windows NT servers running ASP and JRUN web applications. Measured system response time, throughput and utilization of the web sites. Simulated attempts by virtual users to simultaneously access the site.
  • Served as lab manager responsible for consolidating three development/test labs into one.
  • Administered over 20 NT web and database servers.
  • Added a second private 100 Mb network to all servers.
  • Installed and configured SSL certificates and other software on all servers.
  • Eliminated extra lab space. Resulted in significant savings to the organization.
  • Significantly improved reporting processes by developing resource utilization, headcount and funding reports for upper management. Designed and developed back-end database and front-end reports. Received two awards, from the director and department head.
  • Increased database performance for the Integrated Business Management System (IBMS) by 200%. Identified process and security issues. Implemented solutions. Reduced IBMS help desk calls by 50% in the first three months. Worked on SQL scripts, Crystal Reports, data integrity, system performance, operations and support.
  • Designed and developed scripts written in Expect and TCL that automatically logged into every node of a frame relay network and performed administrative tasks. Scripts eliminated the need for network administrators to manually log in and correct parameters on hundreds of BPX nodes.
  • Designed and developed a front-end contract maintenance and billing system (SLA Tool) using Ingres. Software system added, closed, updated and amended service contracts. Managed over $50M in customer contracts.
  • Developed and implemented Quality Improvements to reduce the cost of running a system performance and capacity-planning database.

Education

MS, Computer Science,

BS, Computer Science

Awards and Affiliations

Promoted four times and received over ten customer and management recognition awards for extra effort, teamwork, outstanding performance and quality.

We'd love your feedback!