Architect/lead Programmer/ Sql Server Dba Resume
4.00/5 (Submit Your Rating)
SUMMARY:
More than 25 years architecting, developing and maintaining solutions for various departments across multiple lines of industries.
COMPUTER SKILLS:
- T - SQL 20 years ; C# - 10 years; VB - 7 years; ASP.Net - 14 years;
- JavaScript, HTML, XML, XSLT, CSS - 7+ years
- Microsoft SQL Server - 20 years, Microsoft Access - 5 years, Sybase - 2 years, Oracle - 2 years, MYSQL - 2 years
- Microsoft Windows - Various
EXPERIENCE:
Architect/Lead Programmer/ SQL Server DBA
Confidential
Responsibilities:
- Hired on a one month contract, as the first programmer, stayed on for 7 years architecting and developing in all areas of the company. Grew the department to 7 programmers by the end.
- Interacted with all internal departments and external customers to determine needs, spec out, develop, roll out, train, maintain and support clients in a rapidly changing environment.
- Performed the DBA role throughout. Configured and maintained databases across multiple servers and versions. Assisted developers with performance tuning. Performed maintenance plans. Responsible for backups, restores and recoveries. Corrected issues in real time if needed. Created and maintained data models.
- The company was dependent on outside files driving business. Heavily involved in ETL development and monitoring.
- Technologies used were C# and ASP.Net using SQL Server as the backend. VS 2008, 2010, 2012, VS2015. SQL Server 2005, 2008, 2008 R2, 2012, 2014.
Programmer Analyst
Confidential
Responsibilities:
- Developed notification system to the financial life insurance loan personnel.
- This system scanned the internet looking for obituary name matches of people with life insurance loans.
- Created specifications and test planning with the CFO and people within the Loan Department.
- Technologies used were VB 2008 with SQL Server 2008.
Architect/Lead Programmer
Confidential
Responsibilities:
- Conceived, developed and implemented from my co-authored patent number US6529889 a data driven product sold to insurance, pharmaceutical and security based organizations. This n-tier product emphasized maximum flexibility in both code and data structures in order to minimize core program changes. The product was part windows and part web.
- Architected the logical and physical data models as well as the n-tier program structure.
- Coded logic to generate custom Word documents and ASP web pages at runtime, via VB and C# that consumed rules established by Subject Matter Experts.
- Supported client installations by interfacing with them to understand their data systems and then developed XSD specifications and methods desired to assist in data exchanging.
- Maintained project road maps with input from internal as well as external bodies via meetings with these bodies.
- Established monthly technology review meetings to discuss future existing and competing technologies and how they might impact the product enhancement pipeline. Assigned people as needed to vet cost benefit analysis.
- Setup and adjusted testing methodologies and feedback methods with external groups.
- Created and participated in a coding/technology standards group which established technologies and coding guidelines and performed code reviews.
- Hosted post product release meetings in order to gather feedback on how to improved product release cycles and product quality.
- Developed functional and technical specifications.
- Managed employees as well as consultants, assigning tasks and direction as required.
- Mentored junior developers in Visual Basic, SQL Server and other technologies.
- Encouraged staff to continually share concepts or questions at any time.
- Continual dialoging with Sales and Marketing on both new product needs and solving current product issues.
- Participated in the creating of marketing material regarding the technology and its hosting/installation requirements.
- Product covered various editions of Visual Basic, VB 6 years, C# 3years.
Database: Access - 3 years, SQL Server 6.5, 7 and years, Oracle 10 - 1 year.
Technology: XSLT, XML, ASP Classic, ASP.Net, ADO.Net, ADO & DAO, Word VBA, stored procedures/functions and database administration.
Database Specialist
Confidential
Responsibilities:
- Converted all of their newspaper publishing solutions from Sybase 11.5 to Oracle 8.
- Developed a data exchange solution between Atex and SAP for customer and billing information related to display and line ads.
Database Architect
Confidential
Responsibilities:
- Working with employees and management at Confidential, Confidential created a logical and physical model that would support the maintenance department and its needs to identify all assets no matter the type, schedule typical maintenance and help dispatch via cell technology staff to unscheduled maintenance requests.
Programmer Analyst
Confidential
Responsibilities:
- Working with IT and HR staffs developed VB applications, created reports with Crystal Reports and wrote stored procedures on a SQL Server and Oracle backend.
