We are able to support all aspects of your SQL/Database and Web Development needs
- WordPress Websites – full design and custom programming, eCommerce, Elementor, various plugins
- SQL Server Development and Administration – All current versions of MS SQL Server
- Other databases – MySQL and Postgres administration and development
- T-SQL – Extensive experience with T-SQL
- SQL Programming – Expertise in writing and evaluating Standard and Advanced Queries, Stored Procedures, Views, User Defined Functions (UDFs), Triggers, Distributed Queries, Agent Jobs/Scheduled Tasks
- Administration – SQL Server administration, including Database Creation, Tables, Indexes, Partition and Cluster Creation, Backups, Recovery, Replication, Linked Servers, Log Shipping
- Cloud and Serverless – AWS, Azure, Rackspace and Heroku (PaaS)
- Database design – Relational integrity constraints, primary and foreign keys, diagrams, indexes
- Performance Tuning – Query Optimization, and Database Consistency Checks using DBCC, SQL Profiler, Database Engine Tuning Advisor, Execution Plans, SQL Server Profiler
- Migrations – Migration of databases to higher versions or different platforms
- Reporting/Visualization/Analysis – SQL Server Reporting Services, Visual Studio Reporting, Tableau, Crystal Reports, Power BI
- Disaster Recovery Planning, Security Management – Server and Database Backup, Malware detection and prevention, WAFs, Firewalls
- Application Programming – 25+ years’ experience in developing database/web applications with various tools, including .Net, Javascript, CSS, HTML5
- Data-Driven Websites – Custom websites with integrated Content Management, including WordPress and Joomla
- International Teams – Ability to manage and co-development with international developers
- Source, Collaboration tools – Extensive experience (including administration) with Jira, Slack, Github, Bitbucket, SourceTree
- Other Services – Written and verbal communication (including documentation, instructions, etc.) and management services
all