Sr. Dba/Staff Software Engineer
Horsham, Pa
Database Administration of Microsoft SQL Server, PostgreSQL, and MySQL databases. Provided database development on Microsoft SQL, PostgreSQL, MySQL, and Oracle databases. Devised and implemented high availability and disaster recovery strategies.• Architected the database and its infrastructure for an enterprise application utilizing SQL Server 2012 for the main backend database and PostgreSQL databases for over 200 remote databases.• Engineered database high availability using SQL Availability Groups. The availability group has maintained 100% uptime since November, 2014 and 100% database availability since January, 2015.• Served as the SQL Server technical lead for Australia’s new broadband network (NBN). Instructed the server setup and optimization for database mirroring.• Instituted high availability for The Weather Channel’s stream controller using PostgreSQL and pgpool II.• Provide Oracle support for AT&T’s reporting needs.• Implemented multiple ETL processes using SSIS and C#.• Provide server maintenance, upgrades, backup and restorations all while maintaining high availability for all physical and virtual SQL servers.• Implemented security best practices and monitoring for all SQL Server environments.• Implemented SQL source control using Redgate products.• Provided direction and oversight to the in-house and external development teams.• Provide database support for all developers.• Mentored junior developers and provided database training.