Prime technology specialist, inc.
Feb. 5, 2007 - present
PhilamCare Health Systems Inc.
UN Ave., Manila
February 5, 2007 - PRESENT
EZ-CAP is an initiative of PhilamCare to enable them to manage their business/channel partners effectively and profitably. It is a provider of affordable healthcare plans.
Role: Database Administrator
1. Mrs. Ramos is a part of the Project development team that implements and support the Department requirements and carries out deployments for the MIS1 and MIS2 system where all the health benefits and claims of clients process.
2. Mrs. Ramos is the person handling the Database Administration on PhilamCare which covers the following responsibilities:
o SQL Server Installation and Configuration
o DB Account creation, modification, deletion.
o DB Monitoring, troubleshooting, Remediation
o Database design and object creation.
o Creation and Maintenance of Objects SQL Database
o Scripting ( SQL Database)
o User Requested Performance Tuning
o Running DB Scripts to perform various DB Cleaning and Monitoring Operations
o Migration from SQLBASE database to MSSQL 2000.
o Migration of EZCAP database from EZ-CAP 4.1 to 4.2, 4.2 To 4.3, 4.3. To 4.3.1, 4.3.1 To 4.4, 4.4 To 4.5, 4.5 to 4.6
o Database Backup and Restoration from SQLBASE 7.0, MSSQL 6.5, MSSQL 7.0, MSSQL 2000
o Monitor schedule jobs and schedules tasks for Development and Production servers.
o Database System Access Maintenance and database utilization monitoring.
o Data Extraction EZCAP Database maintenance and monitoring.
o Responsible in deployment of system programs in Visual Basic 4.0 and Visual Basic 6.0 environments.
o Migrate EZ-CAP objects from 3.11 to 4.1,4.1 to 4.2, 4.2 to 4.3, 4.3 to 4.3.1, 4.3.1 to 4.4, 4.4 to 4.5. 4.5 to 4.5.1, 4.5.1 to 4.6, 4.6 to 5.0 environments.
o Responsible in ensuring all PhilamCare Databases is synchronize with the system setup as well maintaining the database related EZ-CAP objects such as setup of users login, access rights, Server Roles, Data update and more.
SQLBase 7.5.1, EZ-CAP 3.11 – 4.5, EZMigrate, SQLEXEC3, FixedDates, MSSQL 6.5, MSSQL 7.0 and MSSQL 2000, BCP and MSDTS