Sql Server Software Developer
Resume:
I am a highly experienced computer professional with a wide range of skills. I have worked as a database administrator, software developer, and a system administrator. I have a strong belief in creating good documentation and developing procedures for deployment and maintenance.
***@********.***
Resident in Warrington, PA, USA
– Operations Programmer
August 2011 – presentCreating and maintaining middle tier for major PharmaceuticalCreating unit tests for the aboveCreating SQL queries and database interfacesWorking with PHP 5, Oracle, Javascript, XML, XHTML, HTML5, JSON, AJAX
– Operations Programmer
March 2009 – July 2011Replacing code driven modules with database driven user interfacesDesign of automated promotion systemWorking with PHP 5, PostgreSQL, Javascript, XML, XSL, HTML, JSON, AJAX
– Database administrator
December 2007 – February 2009Environment consists of high-availability customer-facing database servers and applications Server versions ranged from PostgreSQL 7.4 to 8.3 Responsible for maintaining the reporting, billing, and invoicing databases (PostgreSQL) (about 125 databases on three servers) Organized automated monthly restores (24 databases on three servers) Worked on reporting, development, QA, and production database environments Setup and/or upgrade database servers and replication environments (AIX/PostgreSQL 8.3/Slony 1.2.12) Documented procedures and configuration Participated in data warehouse design Involved in UTF-8 testing Database design and data modeling Provide support to local and remote developers
- Senior Software Developer / Database Architect
May – June 2007Involved with creating the next generation of their backup product Database modelling and design (PostgreSQL 8.x) Stored procedures and triggers.
Independent Contracting
February 2006 – May 2007Custom website/database work (PostgreSQL/MySQL/Apache) Network monitoring (Nagios) backups (Bacula) server configuration/installation
- Senior Software Developer
September 2004 – February 2006Enhancing and development of knowledge management system Using MySQL, SQL Server, PHP, Apache, IIS, Windows 2000, Windows XP, Windows 2003, CVS, Subversion, Zend Studio and Zend WinEnabler Documenting process as development occurs
Contracting for - Software Engineer/System Administrator
June 2002 - September 2004 Upgrading, installing, and configuring servers. Wrote custom websites and database access routines (PostgreSQL/MySQL) for customer websites Created custom firewalls, mail servers, and web servers for clients, configured Apache, OpenSSL, PostgreSQL, procmail to suit customer requirements, and secured communications between client website and client offices Maintained, patched, and upgraded servers as required, Ottawa, Canada; Software Developer
May 2001 - June 2002 Employed as a software developer working on Ponte's network management software.Designed and ran the automated loadbuild and testing systemConverted NCP (Network Control Point) from NetBSD to Solaris
April 2000 - present Designed and implemented PostgreSQL databases used to track software changes. Upgrade servers progressively over the years from 7.x to 9.x Created triggers and stored procedures to provide complex inter-table relationships, Wellington, New Zealand; Consultant
March 1994 - May 2001
As a consultant, there were a variety of projects including: - created reports using SQL Server and ASP Internal R&D - Worked with JRun, JBuilder, TopLink, and Apache to investigate population of business objects from within JSP pages. - Conversion of an existing system from PowerBuilder 4 to PowerBuilder 5. In the process, an existing class library was removed and PFC was introduced. Working as primary developer, converting code that processed incoming data into a Sybase database. - Worked with a small team creating a work flow management system. This software was designed to make the management of work centers easier and allow managers to supervise resources efficiently. The system uses MTS and Sybase SQL Server. - Providing mentoring on the PowerBuilder 5 and PFC. - Worked on a Wholesale Pool simulator using PowerBuilder 5 and PFC. This system calculates the half hourly price of electricity based on different simulation models. - development of an Educational Framework using PowerBuilder 4 and Sybase SQL Server 10. - PowerBuilder Branch Platform Project. Incorporated many systems in a single GUI front end. Initially a PowerBuilder 3 system running under Windows 3.11, which replaced 3270 screens, the code was later migrated to PowerBuilder 4 and Windows NT. Database converted from Microsoft Access to Oracle. - Developed a PowerBuilder system to facilitate tracking projects and film developments, produce accounting reports, and maintain mailing lists. Subsequently returned to enhance this system to include additional mailing list features including audit trails.
Wellington, New Zealand; Analyst/Programmer, Team Leader
1989 - 1994Development and maintenance of Microsoft Windows applications and a marketing system incorporating MIS information. Worked for Treasury (Foreign Exchange and Money Market systems) Gathered requirements from users, designed and implemented systems and databases (SQLBase & SQLAnywhere) Worked with other departments to allow data sharing between systems
Paxus Consulting Wellington, New Zealand; Consultant
1986 - 1989Worked with clients to determine requirements, then implemented the software and databases Often sole-consultant on site with client Projects included retail financial systems, brokerage systems for Bank of New Zealand
Wellington, New Zealand; Consultant
1985 - 1986 Worked for New Zealand Racing Conference designing a computer system to replace existing manual systems.
Languages: C++, C, PHP, ASP, Perl, Shell scripts, Python
OS Platorms: Windows 2000, Windows XP, Windows 95/98, Windows 3.X, Linux, FreeBSD, NetBSD, Solaris, AIX
Databases: Sybase, Oracle, SQL Anywhere, MySQL, MS Access, SQL Server, PostgreSQL, Ottawa, Canada (1981-1985)Bachelor of Computer Science - High Honours, 1985
Contact this candidate