Your database is where performance, integrity and reporting succeed or fail. DexContact designs new databases, improves existing ones and keeps them running — on premises and in the cloud.
Development
- Database design — data models built for your application, reporting and growth
- Database programming — stored procedures, functions and triggers in SQL, T-SQL, PL/SQL, PL/pgSQL and more
- Migration & consolidation — move and merge data between platforms and formats with integrity checks at every step
- Reporting & analysis — queries, views and reporting structures people can rely on
- Testing — data validation, performance and regression testing
Administration
- Installation, configuration, upgrades and patching
- Performance tuning and capacity planning
- Security hardening
- Backups, standby servers and recovery
- Oracle RAC and Microsoft clustering
- Monitoring and routine maintenance
- Remote SQL Server and Oracle DBA
- Troubleshooting
Platforms
Microsoft SQL ServerOraclePostgreSQLMySQLIBM Db2SQLite
How we work
- Consult — understand the goal and the current data
- Analyze & design — requirements, data model and architecture
- Develop & test — build, validate and load-test
- Release & support — go live, monitor and keep improving