Database Services – ATSC
435 Orchard Road, Unit #11-01, Wisma Atria Office Tower. Singapore 238877

Database Services

Database Services

ATSC Data services

360o coverage for all your database technologies

Gain expert database management services for Oracle, DB2, SQL Server, MySQL, SharePoint, as well as popular NoSQL technologies such as PostgreSQL, MongoDB, Cassandra… database environments with an unmatched level of service, support and affordability.

Flexible, client-focused delivery options

ATSC has flexible consulting for short-term and ongoing database projects. Use our team for day-to-day support or ad-hoc assignments such as assessments and upgrades. We go beyond the contractual paperwork to make good on the promise that we’ll add value to your business.

SLA Management, Support, & Services

ATSC SLA is a true representation of what you can count on from us. We are committed to supporting and protecting your mission critical data and providing assurance of that protection and support is a critical element of our success.

Services provided with the standard database support package include:

  • Initial database software installation, including configuration and verification as required
  • Performance of daily or weekly backups to disk, as requested by customer
  • Management and monitoring of disk space
  • Database restoration, as needed
  • Rebuilding of database indexes, as required
  • A primary on-call DBA to respond to alerts and customer issues as defined by the level of customer support

Other service options available, depending on database software, include but are not limited to:

  • Standby databases to support business continuity
  • Replication
  • Database cloning for development environments
  • Data conversion/migration assistance
  • Database query tuning
  • Database upgrades/patching
  • Database security maintenance

Database consultancy

ATSC database consulting includes Data Modeling, Design, and Implementation from our DBA experts. In order for your enterprise to function properly, a well-structured and logical database that contains the necessary data is essential for growth and success.

ATSC’s experts can assist you with all aspects of the database development process, including but not limited to:

  • Data modeling to establish a baseline understanding of the unique needs of the organization and database requirements, include major entities, their roles, and relationships.
  • Identifying the types of data to be gathered and analyzed.
  • Conceptual, logical, and physical design modeling to develop an effective information architecture.
  • Determining the ideal RDBMS (MySQL, Oracle, SQL Server, etc) or modern NoSQL technologies (Cassandra, Couchbase, MongoDB, etc) for your organization’s specific needs.
  • Implementation and rigorous testing of the newly designed database.
  • Provide ongoing monitoring, tuning and automation to ensure efficient and effective processes throughout the lifecycle of the database.
  • Apply best practices to all aspects of planning, development, deployment, and security.

Data migration

Migrating from one database to another can be a fairly simple and seemingly routine process, but if the proper failsafe procedures are not put into place, problems can arise. Whether used as a mere repository for data or as storage for business logic (schema migration), certain steps must be followed to eliminate downtime and the potential for data loss. These tasks might include ETL, Modeling, and Source Control for Migration and Restructuring…

ATSC’s expert DBAs can perform a wide variety of complex data migration and restructuring tasks, including:

  • Developing a migration strategy to ensure all steps are designed according to your organization’s specifications, including data quality, data governance, change management…
  • Mapping and transferring your old data to the new system using Extract-Transform-Load (ETL) best practices, including removing bad data and cleaning good data.
  • Ensuring data integrity through data and application review before migration.
  • Implementing a database modeling procedure to seek out, highlight, and eliminate errors or other issues before migration occurs.
  • Implementing version, or source control, in your database to ensure it remains synchronized and consistent with your application source code.
  • Providing ongoing testing and maintenance to ensure a successful migration.

Performance tuning

We need to be conscious of the fact that tuning is an ongoing process.  A new, empty database may perform far differently than after it has been loaded with data.  A system may have completely different performance patterns in the day than it does during night-time processing.  In short, we must be able to track changes in database performance and take appropriate actions that benefits the database as a whole.  Unfortunately, many of the tuning adjustments for database are controlled in a specific file, and hence cannot be targeted at specific transactions.

There is another benefit to having a long-term performance plan.  It is generally the job of the DBA to monitor the resource consumption of database (disk, memory and CPU), and notify the systems administrators in time for them ton order enough of the needed resource.  Many DBA performance planning system include a forecasting function, where the DBA can predict future disk, memory and CPU requirements based upon long-term growth patterns. 

Proactive system tuning is at the core of ATSC’s best practices and is a key differentiator from our competitors. We believe that quality service is to continually suggest, test and implement tuning changes to your system, database, hardware or software simultaneously while your internal technical team can work on other priorities.

Short-term tuning may require tuning of statements, reports, jobs, backups or materialized views, web services. Proactive tuning incorporates system utilization, license optimization, ETL loading, clustering, log shipping, replication jobs, service request/ response or preproduction work. In any of these cases, ATSC’s tuning expertise can ensure that your system is optimized for performance and running smoothly.