About

This is what I do.

My name is Andrew J Fenna. I work as a Principal Database Developer.  This is a little about me:-

• 10+ years of experience in different phases of software development life cycle including analysis, design, development, documentation, deployment and system support.
• Experience as a Principle SQL Developer, Architect and Administrator. Also worked as Team Lead on many different projects and assignments.
• Experience in SQL Server versions 6.5-2016, T-SQL, Stored Procedures, Triggers, UDF, TVF, CTE, BCP, DTS, SSIS packages, Cognos BI Tools, Sybase ACE, MySQL, Access, Visio & Git.
• A pioneer of Agile database development and deployments following techniques such as TDD, BDD, CI & CD to from Development to Productions environment's.
• Advance knowledge in RDBMS concepts, conceptual/logical/physical data models, and Dimensional/Star/Snow Flake schemas.
• Expert in application development using the Microsoft Stack such as C#.Net, ASP.Net, VB Script, HTML, XML
• Expert in scripting languages such Powershell, Bash/Shell & Perl.
• Knowledge of NOSQL databases like Couchbase & MongoDB.
• Experience in ETL design, development and implementation.
• Experience in developing a high concurrency database (Over 2TB) running on SQL Server and providing a 100% up time service even when deploying changes.
• Expert in Performance Tuning & Optimisation of SQL Server.
• Experience in data migration from different database platforms. (Access to SQL Server, SQL Server to Sybase; SQL Server to Oracle using TIBCO and SQL Server CDC).
• Experience in implementing Backup & Restore (Full, Differential & Transnational) procedures, Log Shipping & Transaction Replication.
• Strong analytical, problem solving & troubleshooting skills.
• Able to work collaboratively, quickly understand system architecture & business needs while committed to achieving corporate goals.
• Passionate about working with huge data sets.
• Good verbal & written communication skills.
• Ability to work independently & in a large team environment.