Database Services
SQL Server 2008+
- SQL Server database administration and maintenance
- Define specifications and designing and documenting database schema. We can also help with data modeling & business requirement process
- Scripting, writing stored procedures, triggers, functions and complex highly-optimized queries
- Using profiling and other techniques for database optimization to identify performance bottlenecks in complex systems, and enterprise extraction, transformation, and loading (ETL, star schema design and table partitioning/sub-partitioning) with SQL Server 2005/2008 Integration Services (SSIS).
- Design, build, and deploy SSRS reports and SSIS packages
- Design, build, and deploy asynchronous triggers using Service Broker
- Replication performance impact testing with existing applications
- Configure transactional replication on DEV/QA/Stage & production environments
- Coordinate efforts to ensure all database environments Dev., QA, Stage, and Production are in sync.
Oracle
- SQL Server database administration and maintenance
- Define specifications and designing and documenting database schema. We can also help with data modeling & business requirement process
- Scripting, writing stored procedures, triggers, functions and complex highly-optimized queries
- Monitoring and tuning the general performance of the Oracle database
- PL/SQL, stored procedures and triggers development
- Installing and configuring Oracle Application Express/HTMLDB and Oracle HTTP server, as well as creating and maintaining the associated Workspaces and Workspace users.