We provide IT Staff Augmentation Services!

Sql Developer/dba Resume

Peapack, NJ

SUMMARY:

To obtain a position that will utilize my strong existing skill set and experience, al background and ability to work well with others in a team environment in order to enhance an existing IT infrastructure enabling business to make effective viable decisions in a timely manner.

WORK EXPERIENCE:

SQL Developer/DBA

Confidential, Peapack, NJ

Responsibilities:

  • Automated archiving of decommissioned pharmaceutical systems and databases
  • Maintain compliance with State and Federal regulations with regards to data retention
  • Convert existing iSeries DB2 databases to MS SQL Server 2005/2008R2/2012
  • Work closely with business SME’s to develop data points for data retrieval and document the DRP (Data Retrieval Plan)
  • Build data retrieval queries and procedures in accordance with data retention policies outlined in DRP
  • Execute archived data retrieval requests on demand in response to federal/state audits, etc.

SQL Developer/DBA

Confidential, Warren, NJ

Responsibilities:

  • Maintained and/or enhanced existing database systems, MS SQL 2000/2005/2008/2012 ; assisted in conversion from /2008 & 2012; served as backup Database Administrator (DBA)
  • Supported ad hoc user report requests, systems & requirements analyses, optimized performance and ensured overall database integrity
  • Responsible for all reporting for the enterprise, including:
  • Consolidated Reporting System (CRS) - web based ASP.Net & IBI WebFocus reporting tool consisting of over 100 high-level reports with sophisticated selection criteria
  • Managed Reporting Engine (MRE) - ad hoc reporting interface supporting 50+ user reports
  • ReportCaster - IBI report scheduler distributing 100+ scheduled reports thru out the enterprise
  • User/Configuration management including installation, tuning, security & upgrades
  • New report development with IBI WebFocus scripting, including front-end UI and back-end database T-SQL
  • Developed & maintained several Extract-Transform-Load (ETL) projects using SQL Server Integration Services (SSIS)
  • Tested all applications and documented test results across a three-tiered environment; including unit, regression & integration testing
  • Responsible for maintaining User Acceptance Testing (UAT) environment; ensured integrity of test database and managed system architecture
  • Provided first level support for all nightly Production job streams (when on call)
  • Maintained SAS70 compliance and provided Requirements Analyses and Design specifications in adherence to Software/Project Development Life Cycle (SDLC/PDLC)

SQL Developer/DBA

Confidential, Fort Monmouth, NJ

Responsibilities:

  • Automated loading of all hardware/software purchase orders into Oracle 10G database for Confidential Small Computer Procurement program ( Confidential )
  • Developed & maintained repository of automation staging/conversion scripts and tuned for performance improvement
  • Supported Extract-Transform-Load (ETL) from flat file/Excel spreadsheet to Oracle 10G and ensured database integrity
  • Responsible for adherence to existing policies & budget requirements as dictated by Confidential standards
  • Developed reports & analyses using Cognos and variety of other automation hardware/software tools
  • Responsible for running Order Processing & Account Balancing on a periodic basis, including briefing and advising management for presentation to Confidential
  • Successfully processed over $1 Billion in orders

Systems/Software Engineer

Confidential, Princeton Junction, NJ

Responsibilities:

  • Responsible for off-site engineering, development & testing of all software products at Confidential for integration into enterprise client/server infrastructure on Windows 2000/XP/2003 & Unix/Linux platforms
  • Designed implementation plans & procedures, and interfaced with existing configuration management policies
  • Planned, designed, developed & implemented software test plans, descriptions & reports using IT Governance & Perl scripting; prepared detailed test reports and maintained repository
  • Maintained & coordinated lab systems performance, including Unix/Linux shell script code & Windows Management Instrumentation (WMI) VBScript code
  • Directed, monitored & coordinated electronic delivery of software products across the enterprise
  • Designed software modifications, developed coding structures & specifications using Perl & Java
  • Administered Sybase, SQL Server & DB2 database for several client/server systems, including Scheduler & Metrics (internal distributed test lab & infrastructure tool to measure performance & quality metrics) and Quality Center (HP IT Governance tool)
  • Oversaw design, implementation & maintenance of distributed database systems for client, including physical and logical design schema (using Erwin), T-SQL development (Triggers, I-SQL and Structured Procedures) and distributed database coding implemented as web technology services using Perl & Java
  • Successfully built inquiry website for Scheduler back-end database using Model/View/Control (MVC) design, T-SQL and Perl Template Toolkit and distributed across the enterprise
  • Created automated solution for database auditing & maintenance and saved approximately 200 man-hours per month in reports preparation resulting in average monthly savings of $10,000
  • Responsible for other consultants in use of Metrics & Scheduler database systems
  • Developed comprehensive reporting system across MS SQL Server & Sybase ASE using T-SQL, Perl, Business Objects Crystal reports (BOCR) and Excel for risk management criteria presentation to upper management

Senior Test Engineer/System Administrator

Confidential, Eatontown, NJ

Responsibilities:

  • Planned, designed, developed & implemented software test plans, descriptions & reports in accordance with Defense Information Systems Agency ( Confidential ) COE Integration & Runtime Specification (I&RTS) guidelines
  • Provided Test Lab support and periodic status reports on activity to management, via Video Teleconferencing (VTC) to Fort Hood and other Confidential facilities
  • Developed & implemented reuse architecture repository for all Test Lab Common Software products & upgrades, including commercial off-the-shelf (COTS) products as well as external software support from Confidential Reuse Center, Fort Belvoir, VA
  • Installed and configured all Test Lab operating systems (OS) upgrades
  • Performed systems administration & user/group security implementation including Unix/Linux shell script coding & WMI VBScript coding
  • Planned, directed, monitored, coordinated, analyzed and troubleshot secure networks, including routing and DNS/DHCP IP telecommunications configuration for a classified test lab environment
  • Designed & wired existing Test Lab; installed & configured Netscape Directory Services for Lightweight Directory Access Protocol (LDAP) software in a Command & Control environment, including creating/maintaining LDAP Data Interchange Files
  • Served on various systems support and managerial committees; developed requirements analyses & technical solutions for compliance with Confidential regulations
  • Oversaw implementation & fielding of Confidential 6.5 & 7.0 revisions

Hire Now