Database Engineer Resume Profile
2.00/5 (Submit Your Rating)
Boston, MA
Objective
- My objective is to use my industry experience in software and database development, information security, and network design to architect enterprise solutions, implement and research new technology to add value to the firm, and successfully execute on projects. I am results oriented, able to work independently to execute on and assist in delivering on business initiatives, improving efficiency, lower the total cost of development, and improve the reliability of software through automation, process improvements, and standards development.
WORK EXPERIENCE
Database Engineer
Confidential
Responsibilities
- Implement new external as well as internal data feeds to support Global Equity and Fixed Income research.
- Develop process to build out the SQL Server research data warehouse to support firm wide research
- initiatives.
- Enhance our proprietary C file loader to improve efficiency, performance, as well as add new vendor feeds.
- Primary focus on high performance sql, fully re - runnable architecture, flexible database architecture to support
- data consumption through our statistical packages.
- Development of a unit testing, data quality, and code deployment strategy and process.
Database Engineer
Confidential
Responsibilities
- Analyze existing software and database infrastructure.
- Implement BI-SAM performance and attribution software replacing the existing StatPro implementation.
- Assist in the development and implementation of a proprietary index database.
- Enhance the initial phase of the swap functionality implemented in our HiNet accounting system.
- Develop Python to support building building of the proprietary index database and an internal graphing
- process.
Senior Security Architect
Confidential
- Implemented plugin based HttpModule to identify and prevent suspicious and potentially malicious behavior.
- Worked with management to develop security roadmap initiatives to mature the overall security posture, the
- goal being to provide an ROI on security.
- Worked with vendors to develop and apply a static analysis source code scanning tool and process.
- Research emerging and zero-day threats as they pertain to our Internet properties.
- Security code review and analysis of existing code bases in .NET, SQL, SQL Server.
- Mobile operating system and application security review and analysis to prioritize threats and advise
- management and team about existing and emerging vulnerabilities.
- Responsible for mentoring new members of the team and get them up to speed.
- Review and approve functional requirement documents for all new projects.
- Responsible for architecting and supporting secure solutions including working with development to get new
- vulnerabilities addressed and implemented.
Senior Database Engineer
Confidential
- Reduced database engineering overhead through custom automation allowing our global development team
- to maintain schema and data objects more efficiently.
- Responsibilities include development and review of backend code for Monster sites from conception to
- implementation.
- Design and development of a new internal website DB Eng process manager to manage the database
- kit creation, day-to-day maintenance including an automated facility to deploy database code to global
- environments.
- Development of a full end-to-end system for making internal database release processes smarter
- Development of both SSIS packages as well as console application to perform ETL functions.
- Projects include SQL Server 2000 migration to 2005.
- Global Unicode database conversion project including acting as a consultant to internal groups to help them
- convert their databases, SSIS/DTS packages, and database objects including stored procedures, views, UDF,
- and triggers.
- Design, development, and implemented several .NET applications to enumerate SSIS, DTS packages as well
- as interface with our source control system to upgrade database objects using a rules based engine saving
- hundreds of hours of employee time using a manual process and allowing the project to meet an aggressive
- time line.
- Worked with team members in evaluating, applying, and recommending new software tools, techniques, and
- standards including new architectures and processes for DB Engineering to improve reliability, scalability, and
- manageability.
Team and Technical Lead/Senior Software Engineer
Confidential
- Worked with business leaders to develop new applications using C and VB.NET using the 1.1 and 2.0 .NET
- frameworks.
- Responsible for .NET development and direction for the organization using both WinForms and WebForms.
- Designed developed .NET web services, WebForms and WinForm applications to replace existing VB6 and
- classic ASP applications as well as new application development.
- Worked with management to bring much of the software development in-house, create a distributed
- development environment and instituted an enterprise development environment as well as implement industry
- best practices and standards.
- Responsible for R D of new and emerging technologies including SQL Server 2005, Share Point 2007, as
- well as developing a managed enterprise application security API using Active Directory to provide seamless
- login capability and management.
- Managed, mentored and assisted other developers in both maintaining existing applications written in classic
- ASP, VB6, .NET, and SQL Server 2000 as well as debug chronic application performance issues.
- Introduced SOA design principles, OO design, ER modeling, and the use of design patterns as part of the
- software development process.
- Responsible for development, design, and implementation of C web applications consuming hosted web
- services as well as our own web services.
- Created a web service to web enable a proprietary ratings database accessed through a 3rd party API.
Technical Lead, Software/Database Architect
Confidential
- Worked with management to develop long term goals and yearly budgets.
- Responsible for project management and coordination of Information Technology projects including
- architecting Intranet, updating and coding Internet site, designing, maintaining, and getting junior programmers
- up to speed on numerous web and thick client applications.
- Developed and implemented information security policy and programs including periodic company
- information security awareness sessions and a redesign of intranet to make information security related
- materials readily available.
- Responsible for developing and evaluating a migration path and repurposing for Oracle 9i, Oracle 10g, Visual
- Studio .NET, and all ageing hardware.
- Responsible for the complete life cycle software development including documentation and procedures.
- Led companywide disaster recovery design, development, and implementation.
- Responsible for development of programs used for checks and balances via the front-end and full reporting
- functionality both ad-hoc and via a web front-end.
- Responsible for identifying and implementing efficiency techniques and measures within SQL Server and
- Oracle databases and all applications interfacing with those DB's such as review of indices, relationships,
- and code itself .
- Implemented a complete database and software development lifecycle environment consisting of staging,
- QA, and production environments.
- Led design, development, and administration of our internal laboratory information management system
- LIMS .
- Architected, designed, and implemented numerous applications both web and thick client from inception
- to coding, performance oriented data access components in Oracle or SQL server backend to coding the
- business and presentation layers.
- Application design and development in Windows and Linux environments, creating a fully interoperable
- database enabled group of web and desktop applications requiring a full workflow analysis of existing data
- inputs.
- Responsible for network security firewall configuration, VPN configuration and implementation, patch
- management, software security, SPAM/spyware mitigation, and intellectual property protection.
Database/Software Engineer
Confidential
- Filled the DBA/backup DBA role for all DB's including production, development, and QA.
- Developed backend SQL stored procedures for reporting purposes, to support VC backend jobs for money
- movement and fraud detection Early Warning
- Developed a VC /XML file parser to facilitate a partner data feed.
- Created a multithreaded VC /COM backend program to refresh our database from a 3rd party screen
- scraping technology provider.
- Responsible for all transactions between our proprietary databases and our Sales Logix 3rd party software
- implementation using several VC applications.
- Design, implementation, and documentation of all DTS jobs in SQL server 7.0 implementation.
- Developed and implemented extended stored procedures written in VC as well as took advantage of
- existing stored procedures to email results to data analysts in an automated process.
- Supported and maintained Kana Mail 3rd party software .
- Maintained several backend processes written in VC responsible for money movements such as credit
- card processing and ACH transactions.
- Responsible for data mining and reporting services for executives and managers.
- Evaluated and worked with our data warehousing team to determine and implement a COGNOS OLAP
- solution.
- Assisted junior members of our team in learning DB development techniques as well as transitioning
- responsibility for established processes.
- Created a SQL server security policy and worked with others to implement the policy.
- Initiated an NT security oversight committee to review and initiate hardening of our production systems.
Web Master
Confidential
- Managed both front-end graphics design and website/database redesign.
- Led Internet/Intranet Network Topography design and documentation.
- Implemented offsite dial-in capability through a Cisco AS5200.
- Internet/Intranet Security Administration.
- Internet/Intranet Application Development and Support using VB Script, Java Script, and Active Server Pages
- ASP .
- Developed a custom helpdesk application for entering and managing helpdesk tickets.
- Responsible for administration and development of our SQL Server 6.5 database.
- Assisted in administering/supporting our MS Windows NT Systems.