Database Developer Resume
SUMMARY
- My background includes more than 20 years of designing, implementing and supporting leading edge applications built around SQL Server, Oracle and other databases in concert with cloud and 3rd party APIs on Windows, Linux and the Web. My past clients and employers include Fortune 100, mid - size and small privately-held firms. I have owned and managed two successful software consulting firms.
TECHNICAL SKILLS
Databases: SQL Server (on premises and cloud), Oracle 7.x - 11gR2, Azure Database, Azure Database, MySQL, Snowflake, DB2 and NoSQL databases including Redis and MongoDB.
Tools: / Languages / Frameworks: C#, Transact-SQL, PL/SQL, Java, PowerShell, shell scripting, SSIS, SSRS, SSAS, Entity Framework, WPF, Web API, ASP.NET, Silverlight, .Net Core, MVC, SharePoint, MVVM, dependency injection, automated integration and unit testing, C++, C, HTML, JSON and a working knowledge of Python, Angular, JavaScript and Razor views. I have lots of experience with Erwin, Bachman and SQL Designer data modeling software and SQL Server Management Studio, SQL Profiler and Toad data management tools. Tableau, SAS, Cognos, MicroStrategy, Power BI, Actuate and other reporting and analytics platforms.
Methodologies: Agile, TDD Test Driven Development and Waterfall
Cloud Services: Azure, Amazon Web Services (AWS) S3, Snowflake Cloud Database, Okta Identity Management, Slack, GitHub, Bitbucket, GitHub, Salesforce, Mailgun, NetSuite, Melissa Data, and Swift Pay.
PROFESSIONAL EXPERIENCE
Confidential
Database Developer
Responsibilities:
- Built and supported real-time enterprise data warehouse reporting services for tracking client communications Using Web Focus, SSRS and SSAS. Ensured single source of record for accuracy across all reports.
- SSIS processes to load external 3rd party datasets vial file and APIs. Flight Information, hospital and clinic demographic data.
- Level 2 support for DEVOPS managed database releases and production support issues. This included helping the 30+ members of the Product Engineering Group with database tasks.
- Refactored and sped up components for time critical member alerts and trip reporting services.
- Built improvements to speed up avoid duplicate mailings from alert and daily digest communications through our SQL Server/Redis/Mailgun outbound pipeline.
- Improved the firm’s database deployment workflow by automating deployment steps and improving the checks and balances between development teams. This work included streamlining documentation and the cross referencing of SQL scripts to application code and related Jira tasks against the deployment checklist.
- Built PowerShell application to extract and upload partitioned SQL Server data to Amazon S3 for use in Snowflake cloud based reporting databases and to actively manage storage for application databases.
- To address European privacy laws (GDPR), I designed and managing the development of an application to purge user PIA in a controlled fashion from all of the firm’s 14 production databases. The results of these actions were captured in a centralized audit database. This asynchronous application was created using C#, EF 6.0 and Transact-SQL code on SQL Server 2019.
- Solved a number of real-time ongoing database performance and storage issues, one that led to the retention of a $500K per year client. Others included the management of expired data and the refactoring or disposal of dozens of questionable indexes.
- Upgraded the firm’s production databases from SQL Server 2000 to 2014. This required the removal of all SQL Server 2000 - 2005 dependencies including hundreds of NOLOCK hints. Three production databases were also decoupled and the client facing DB moved to a new dedicated server. This work, combined with changing the locking model radially improved the system’s overall performance, scalability and contention metrics as well as client response timings.
- Technical Proof of Concepts (POCs) around the migration of data and related processes to the cloud on Azure PaaS and IaaS, Snowflake and reporting POCs with Tableau and Power BI.
Confidential, North Wales, PA
Software Consultant
Responsibilities:
- Built and supported a Silverlight / Web 2.0 / Skype based telemarketing application suite to handle tasks and management of marketing projects across multiple phone rooms and locations.
- SSIS processes to load external 3rd party datasets vial file and APIs.
- SSRS and SSAS reporting on project status and employee performance metrics.
- Built an honoraria payment and reconciliation application using WPF MVVM, C#, Entity Framework 6, SQL Server and Melissa Data and Swiftpay web services to handle address validation and payment.
- Maintained and upgraded firm’s on-premise and virtualized SQL Server and SharePoint environments from SQL server 2005 to SQL server 2014.
Confidential
Project Manager / Development Lead / Consultant
Responsibilities:
- Worked with Healthgrades to extend Clean Customer’s Master Data Model (MDM) solution to integrate their internal data for hospitals and clients with Salesforce, NetSuite and demographics provided by AHA and Billians. I developed SOAP and Restful services to support user corrections and reporting. I built cross system propagation of changes to maintain both point in time and a current reporting of client organizations for sales and cost reporting.
- Migrated the Confidential C# based entity collation and address matching application to Entity Framework from nHibernate, improving its throughput by 50%.
- SSIS processes to load external 3rd party Hospital and clinic demographics
- SSRS and SSAS for analysis and reporting.
Confidential, Horsham, PA
Director Database Operations
Responsibilities:
- Managed firm’s Oracle database environment with a team of application and infrastructure DBAs. We performed upgrades from Oracle 7.3 though Oracle 11g Release 2, converted both database and web server operating systems from Sun Solaris to Red Hat Linux, implemented ASM, replication and Active Data Guard.
- Reengineered the applications and database structures used to scrub, shred XML, update, maintain respondent survey results. This included migrating from synchronous to asynchronous propagation, relocating the reporting processes off the database serving client requests to a database on a dedicated machine for reporting inside the firewall. This work led to performance improvements by removing contention between servicing client request and the reporting pipeline.
- Created data models and ETL processes for an data warehouse of 40% of the daily US medical purchasing and facility treatment data. This system utilized external tables for loading and table compression and partitioning for efficient data management.
- Built a participant score card which captured in real time the value of each participant relative to current recruiting efforts based on a number of KPIs. This scorecard helped the firm to better contain costs, manage respondent relationships and improve the quality and number of recruits.