t-SQL and SQL Serversmy skills |
I have been working with TSQL and MS SQL Servers for almost ten years. I am very familiar with the technology from SQL2000 all the way to SQL2014 enterprise and AZURE-SQL. In my experience I have mostly worked on projects for SME's, most with no dedicated Database Administrator. Most of the applications I have designed or worked on use a database which I also designed. I have good knowledge of relational databases, their design, implementations and maintenance patterns.
In my career to date, I have designed and maintened a number of large production databases that were critical to the client's business operations. I have therefore a clear understanding and a serious approach to database design and maintenance and the responsibilities attached to it.
Over the last 10/11 years I have designed and (often) maintained the database of numerous applications. I have also been maintaining a number of SQL servers (with up to almost 100 databases) for different clients and I have extensive experience working with countless production databases.
I can safely state that I am extremely confident around relational databases and SQL servers, how to configure, support and maintain SQL Servers, how to design, implement and manipulate relational databases.
During my career, I have designed a few applications (see more details) intended to store an increasing number of transactions (3 to 5 years according to customer requirements) along with detailed additional data. I have been running some of these databases for over 5 years now. No size or performance issues have been reported due to large volumes of data.
I have a long and valuable experience using TSQL for many different purposes, from diagnostics to writing procedures to handling business logic and other operations requiring dedicated algorithms.
I feel extremely confident around T-SQL. I have an advanced knowledge when writing SQL code. However, while I do prefer to keep business logic properly encapsulated in a single place, on various occasions using the power of SQL, I will perform some tasks better and faster giving an overall better experience to the users.
I am very serious about keeping my SQL skills constantly up to date.